Tickets SCD_QUANTITY P_PLAY_TITLE PB_PERF_NOTES
on cap(dat(PB_PERFORM_DATE,'w n D y')) at PB_PERFORM_TIME
at VE_NAME
MS_SECTION/MS_ROW_NUMBER/MS_SEAT_NUMBER pick(D_WEB_SHOW_PROMOTION,'',con(' ',SC_DESCRIPTION)) pick(D_WEB_SHOW_PRICE_CODE,'',con(' ',PC_DESCRIPTION)) pick(MS_NOTE_USE_FLAG,'',MS_SEAT_NOTE) SCD_TOTAL_COST