concat_ws('|',concept,'', editaction, DATE_FORMAT(editdate,'%d-%b-%y'),
        CASE when reference is null then 'null' when reference='' then 'null' else reference END, '')
C78650||create|05-Dec-08|null|
C78681||create|05-Dec-08|null|
C78677||create|05-Dec-08|null|
C78705||create|05-Dec-08|null|
C78647||create|05-Dec-08|null|
C78662||create|05-Dec-08|null|
C78701||create|05-Dec-08|null|
C78632||create|05-Dec-08|null|
C78710||create|05-Dec-08|null|
C78699||create|05-Dec-08|null|
C78642||create|05-Dec-08|null|
C78625||create|05-Dec-08|null|
C78661||create|05-Dec-08|null|
C78673||create|05-Dec-08|null|
C78639||create|05-Dec-08|null|
C78629||create|05-Dec-08|null|
C78657||create|05-Dec-08|null|
C78645||create|05-Dec-08|null|
C78675||create|05-Dec-08|null|
C78624||create|05-Dec-08|null|
C78672||create|05-Dec-08|null|
C78655||create|05-Dec-08|null|
C78689||create|05-Dec-08|null|
C78706||create|05-Dec-08|null|
C78678||create|05-Dec-08|null|
C78649||create|05-Dec-08|null|
C78634||create|05-Dec-08|null|
C78659||create|05-Dec-08|null|
C78704||create|05-Dec-08|null|
C78663||create|05-Dec-08|null|
C78700||create|05-Dec-08|null|
C78676||create|05-Dec-08|null|
C78688||create|05-Dec-08|null|
C78711||create|05-Dec-08|null|
C78660||create|05-Dec-08|null|
C78652||create|05-Dec-08|null|
C78667||create|05-Dec-08|null|
C78630||create|05-Dec-08|null|
C78656||create|05-Dec-08|null|
C78682||create|05-Dec-08|null|
C78687||create|05-Dec-08|null|
C78653||create|05-Dec-08|null|
C78708||create|05-Dec-08|null|
C78628||create|05-Dec-08|null|
C78665||create|05-Dec-08|null|
C78707||create|05-Dec-08|null|
C78683||create|05-Dec-08|null|
C78695||create|05-Dec-08|null|
C78692||create|05-Dec-08|null|
C78664||create|05-Dec-08|null|
C78671||create|05-Dec-08|null|
C78698||create|05-Dec-08|null|
C78654||create|05-Dec-08|null|
C78658||create|05-Dec-08|null|
C78694||create|05-Dec-08|null|
C78633||create|05-Dec-08|null|
C78703||create|05-Dec-08|null|
C78646||create|05-Dec-08|null|
C78637||create|05-Dec-08|null|
C78631||create|05-Dec-08|null|
C78638||create|05-Dec-08|null|
C78627||create|05-Dec-08|null|
C78693||create|05-Dec-08|null|
C78636||create|05-Dec-08|null|
C78679||create|05-Dec-08|null|
C78691||create|05-Dec-08|null|
C78696||create|05-Dec-08|null|
C78640||create|05-Dec-08|null|
C78668||create|05-Dec-08|null|
C78643||create|05-Dec-08|null|
C78690||create|05-Dec-08|null|
C78626||create|05-Dec-08|null|
C78644||create|05-Dec-08|null|
C78674||create|05-Dec-08|null|
C78684||create|05-Dec-08|null|
C78635||create|05-Dec-08|null|
C78670||create|05-Dec-08|null|
C78697||create|05-Dec-08|null|
C78648||create|05-Dec-08|null|
C78686||create|05-Dec-08|null|
C78669||create|05-Dec-08|null|
C78702||create|05-Dec-08|null|
C78641||create|05-Dec-08|null|
C78680||create|05-Dec-08|null|
C78651||create|05-Dec-08|null|
C78623||create|05-Dec-08|null|
C78666||create|05-Dec-08|null|
C78685||create|05-Dec-08|null|
C78709||create|05-Dec-08|null|
C78776||create|12-Dec-08|null|
C78736||create|12-Dec-08|null|
C78712||create|12-Dec-08|null|
C78720||create|12-Dec-08|null|
C78790||create|12-Dec-08|null|
C78713||create|12-Dec-08|null|
C78774||create|12-Dec-08|null|
C78771||create|12-Dec-08|null|
C78739||create|12-Dec-08|null|
C78757||create|12-Dec-08|null|
C78784||create|12-Dec-08|null|
C78724||create|12-Dec-08|null|
C78770||create|12-Dec-08|null|
C78731||create|12-Dec-08|null|
C27150||retire|12-Dec-08|null|
C27150||merge|12-Dec-08|C26691|
C26691||merge|12-Dec-08|C26691|
C78744||create|12-Dec-08|null|
C78789||create|12-Dec-08|null|
C78785||create|12-Dec-08|null|
C78737||create|12-Dec-08|null|
C78747||create|12-Dec-08|null|
C78772||create|12-Dec-08|null|
C78725||create|12-Dec-08|null|
C78782||create|12-Dec-08|null|
C78749||create|12-Dec-08|null|
C78745||create|12-Dec-08|null|
C78779||create|12-Dec-08|null|
C78753||create|12-Dec-08|null|
C78719||create|12-Dec-08|null|
C78721||create|12-Dec-08|null|
C78748||create|12-Dec-08|null|
C78714||create|12-Dec-08|null|
C78741||create|12-Dec-08|null|
C78715||create|12-Dec-08|null|
C78759||create|12-Dec-08|null|
C78754||create|12-Dec-08|null|
C78788||create|12-Dec-08|null|
C78781||create|12-Dec-08|null|
C78751||create|12-Dec-08|null|
C78742||create|12-Dec-08|null|
C78780||create|12-Dec-08|null|
C78746||create|12-Dec-08|null|
C78726||create|12-Dec-08|null|
C78743||create|12-Dec-08|null|
C78735||create|12-Dec-08|null|
C78733||create|12-Dec-08|null|
C78766||create|12-Dec-08|null|
C78783||create|12-Dec-08|null|
C78764||create|12-Dec-08|null|
C78718||create|12-Dec-08|null|
C78793||create|12-Dec-08|null|
C78723||create|12-Dec-08|null|
C78777||create|12-Dec-08|null|
C78740||create|12-Dec-08|null|
C78756||create|12-Dec-08|null|
C78729||create|12-Dec-08|null|
C77385||retire|12-Dec-08|null|
C77385||merge|12-Dec-08|C65746|
C65746||merge|12-Dec-08|C65746|
C78786||create|12-Dec-08|null|
C78750||create|12-Dec-08|null|
C78755||create|12-Dec-08|null|
C78716||create|12-Dec-08|null|
C78424||retire|12-Dec-08|C77527|
C78768||create|12-Dec-08|null|
C78765||create|12-Dec-08|null|
C78734||create|12-Dec-08|null|
C78758||create|12-Dec-08|null|
C78728||create|12-Dec-08|null|
C78762||create|12-Dec-08|null|
C78769||create|12-Dec-08|null|
C78778||create|12-Dec-08|null|
C78787||create|12-Dec-08|null|
C78738||create|12-Dec-08|null|
C78763||create|12-Dec-08|null|
C78761||create|12-Dec-08|null|
C78775||create|12-Dec-08|null|
C78717||create|12-Dec-08|null|
C78722||create|12-Dec-08|null|
C78732||create|12-Dec-08|null|
C78727||create|12-Dec-08|null|
C78730||create|12-Dec-08|null|
C78752||create|12-Dec-08|null|
C78760||create|12-Dec-08|null|
C78828||create|19-Dec-08|null|
C78862||create|19-Dec-08|null|
C78817||create|19-Dec-08|null|
C78823||create|19-Dec-08|null|
C78827||create|19-Dec-08|null|
C78813||create|19-Dec-08|null|
C78794||create|19-Dec-08|null|
C78839||create|19-Dec-08|null|
C78842||create|19-Dec-08|null|
C78807||create|19-Dec-08|null|
C78864||create|19-Dec-08|null|
C78852||create|19-Dec-08|null|
C78861||create|19-Dec-08|null|
C78846||create|19-Dec-08|null|
C17523||retire|19-Dec-08|C17254|
C78820||create|19-Dec-08|null|
C78872||create|19-Dec-08|null|
C78822||create|19-Dec-08|null|
C78796||create|19-Dec-08|null|
C78853||create|19-Dec-08|null|
C78868||create|19-Dec-08|null|
C78805||create|19-Dec-08|null|
C78849||create|19-Dec-08|null|
C78837||create|19-Dec-08|null|
C78803||create|19-Dec-08|null|
C78795||create|19-Dec-08|null|
C78854||create|19-Dec-08|null|
C78833||create|19-Dec-08|null|
C78863||create|19-Dec-08|null|
C78843||create|19-Dec-08|null|
C78821||create|19-Dec-08|null|
C78802||create|19-Dec-08|null|
C78838||create|19-Dec-08|null|
C78815||create|19-Dec-08|null|
C78800||create|19-Dec-08|null|
C78809||create|19-Dec-08|null|
C78874||create|19-Dec-08|null|
C78865||create|19-Dec-08|null|
C78869||create|19-Dec-08|null|
C78819||create|19-Dec-08|null|
C78870||create|19-Dec-08|null|
C78873||create|19-Dec-08|null|
C78845||create|19-Dec-08|null|
C78835||create|19-Dec-08|null|
C78814||create|19-Dec-08|null|
C78798||create|19-Dec-08|null|
C78799||create|19-Dec-08|null|
C78804||create|19-Dec-08|null|
C78808||create|19-Dec-08|null|
C78832||create|19-Dec-08|null|
C78858||create|19-Dec-08|null|
C78801||create|19-Dec-08|null|
C78797||create|19-Dec-08|null|
C78866||create|19-Dec-08|null|
C78818||create|19-Dec-08|null|
C78850||create|19-Dec-08|null|
C78831||create|19-Dec-08|null|
C78834||create|19-Dec-08|null|
C78859||create|19-Dec-08|null|
C78860||create|19-Dec-08|null|
C78812||create|19-Dec-08|null|
C78829||create|19-Dec-08|null|
C78811||create|19-Dec-08|null|
C78806||create|19-Dec-08|null|
C78816||create|19-Dec-08|null|
C78856||create|19-Dec-08|null|
C78824||create|19-Dec-08|null|
C78826||create|19-Dec-08|null|
C78871||create|19-Dec-08|null|
C78844||create|19-Dec-08|null|
C28170||retire|19-Dec-08|null|
C28170||merge|19-Dec-08|C13261|
C13261||merge|19-Dec-08|C13261|
C78875||create|19-Dec-08|null|
C78867||create|19-Dec-08|null|
C78841||create|19-Dec-08|null|
C78810||create|19-Dec-08|null|
C78855||create|19-Dec-08|null|
C78857||create|19-Dec-08|null|
C78830||create|19-Dec-08|null|
C78840||create|19-Dec-08|null|