pick(PB_SALES_METHOD,D_TROUPE_DESC,D_FESTIVAL_DESC,'','Consignation','Stock',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 D m y @ h:N A'))
|