pick(PB_SALES_METHOD,D_TROUPE_DESC,D_FESTIVAL_DESC,'','Consignment','Inventory',D_AUCTION_DESC,D_COURSE_DESC)
|
pick(D_WEB_SHOW_PROMOTION,'',con(SC_DESCRIPTION,' '))
pick(D_WEB_SHOW_PRICE_CODE,'',PC_DESCRIPTION)
|
$PS_TOTAL_COST
|
ORD_SEQ
|
cap(dat(PS_DATE_BOUGHT,'w m D y @ h:N A'))
|