GDPDU 2 Transaction Summary Export (GDPDU_REV_SUM_DAY)

Available when the Exports>Country Exports application parameter is set to Y, the GDPDU 2 Transaction Summary export reflects summary of financial transactions, including Accounts Receivable (AR) transactions, that have been posted in a defined date range.

File Type

GDPDU_REV_SUM_DAY

File Description

GDPDU 2 Transaction Summary

Export Source

EXP_TB_VIEW

Source Description

Export View Based Off of Trial Balance Report

Pre Export Procedure

exp_create_gdpdu.pre_export('GDPDU_REV_SUM')

Post Export Procedure

exp_create_gdpdu.post_export('GDPDU_REV_SUM')

Parameter Form

exp_by_daterange

File Name Formula

'GDPDU_REV_SUM'

File Extn Formula

'csv'

Filter Condition

TRX_DATE BETWEEN TO_DATE(SYS_CONTEXT('CLIENTCONTEXT','EXPORT_START_DATE'),'RRRRMMDD') AND TO_DATE(SYS_CONTEXT('CLIENTCONTEXT','EXPORT_END_DATE'),'RRRRMMDD') AND TRX_CODE NOT LIKE '%I' AND TRX_CODE NOT IN (SELECT pms_p.get_parameter('CASH_SHIFT_DROP') FROM dual UNION ALL SELECT pms_p.get_parameter('CHECK_SHIFT_DROP') FROM dual UNION ALL SELECT pms_p.get_parameter('DEPOSIT_LED_TRX_CODE') FROM dual )

See the full GDPDU 2 Transaction Summary Export Data Definition

Sample GDPDU 2 Transaction Summary Export Data