Ad Hoc - Buyer Side Pending DAs

Buyer Side Pending DAs

LIST AGT_TRANS BY CLOSE_PERIOD WITH STATUS = 'U' AND WITH CLOSE_PERIOD BETWEEN 201001 AND 201012 AND WITH TYPE # 'L' AND WITH TYPE # 'O' STATUS TYPE FULL_STREET CLOSE_PERIOD TOTAL PRICE_CLOSED TOTAL GCI TOTAL UNIT

Replace the bold dates with the four digit year and two digit month that you want the report to start and finish in.