APL |
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