GDPDU 1 Transaction Details Export (GDPDU_REV_DET_DAY)

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

Note: This export will not contain any of the following:

- Transactions posted with an internal transaction code.
- Cash Sift Drop transactions
- Check Shift Drop transactions
- Transactions posted with Deposit Ledger Transaction Codes.

File Type

GDPDU_REV_DET_DAY

File Description

GDPDU 1 Transaction Details

Export Source

EXP_ALL_TRANSACTIONS_VIEW

Source Description

All Financial Transactions View

Pre Export Procedure

exp_create_gdpdu.pre_export('GDPDU_REV_DET')

Post Export Procedure

exp_create_gdpdu.post_export('GDPDU_REV_DET')

Parameter Form

exp_by_daterange

File Name Formula

'GDPDU_REV_TRX_DET'

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 NVL(IS_INTERNAL_YN,'N') <> 'Y' AND TRX_TYPE <> 'PACKAGE' 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 1 Transaction Details Export Data Definition

Sample GDPDU 1 Transaction Details Export Data