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_COSTs$ |
ORD_SEQ |
cap(dat(PS_DATE_BOUGHT,'w D m y @ h:N A')) |