Enhanced PNDDLV Report

Enhanced PNDDLV Report

The existing report TRANSGL.CSV is used to identify accounts with pending withdrawals that have been completed. The cover function TRANSGLDESCSV calls the function TRANSGLDES and transmits the file before the daily SOD process.

With this enhancement, users can add two new columns to the CSV version of the report:

• REF ID
• EXT SOURCE ID

To include these columns, type Yes at the new prompt:

The CSV report is based off of the LRP report that is generated from the underlying function TRANSGLDES. It displays all data points from the CSV. If the response to the prompt is Yes, the report will contain the new fields, which are parsed from the DESCRIPTION.

These fields are populated for transactions where the TICK is PNDDLV and PNDFEE regardless of what criteria the user entered for TRANSGLDESCSV.

If the user selects transaction type DLV and some are PNDDLV PNDFEE and others are CASH-1, the Ref ID and Ext Source ID will be populated for the PNDDLV & PNDFEE only.

Sample CSV

HDR: {client}- TRANSACTION REPORT-TRADE ACCOUNT=BWNUM, TYPE=DLV, TICK=PNDDLV PNDFEE -Run Date 01/09/23-Run Time: 08:00 A.M.

12761276 ,DLV ,PNDDLV,13321 ,01/09/23,-51.40 ,*PENDING SPO TRANSAC,PENDING SPO TR,ANSAC

12877230 ,DLV ,PNDFEE,13321 ,01/09/23,-31.39 ,*12345678901234ABCDE,12345678901234,ABCDE

18705186 ,DLV ,PNDDLV,13321 ,01/09/23,-712.26 ,*PENDING FEE TRANSAC,PENDING FEE TR,ANSAC

19387124 ,DLV ,PNDDLV,13321 ,01/09/23,-87.33 ,123456789012345 ABCD,12345678901234,5 ABC

20670374 ,DLV ,PNDDLV,13321 ,01/09/23,-2000.00 ,*PENDING WD ,PENDING WD ,

21379530 ,DLV ,PNDDLV,13321 ,01/09/23,-59.22 ,123456789012 ABCDE ,123456789012 A,BCDE

25416603 ,DLV ,PNDDLV,13321 ,01/09/23,-488.34 ,PENDING FEE TRANSAC ,PENDING FEE TR,ANSAC

27908570 ,DLV ,PNDFEE,13321 ,01/09/23,-91.00 ,12345678905678FGHIJK,12345678905678,FGHIJK

TRL RECORDS 00000008 ACCOUNTS 00000008