APL |
PNDDLV Removals |
PNDDLV Removals
This enhancement adds a new report to identify accounts with pending withdrawals that have been completed. The report is called TRANSGL.CSV. The cover function TRANSGLDESCSV calls the existing function TRANSGLDES and transmits the file before the daily SOD process.
InvestCloud will send an extract of all pending withdrawals on a daily basis. Clients will develop code to read the file and compare the current day’s file to the prior day’s file. Any PDNDLVs that were on the prior day’s file but are not on the current day’s file will be automatically removed by the client.
The cover function TRANSGLDESCSV mimics the LPR (representing the data points that were selected based on the user’s response to the prompts) generated from the TRANSGLDES function. For example:
Sample CSV
HDR: {client}- TRANSACTION REPORT-TRADE ACCOUNT=BWNUM, TYPE=DLV, TICK=PNDDLV -Run Date 12/07/22 12:15 P.M.
ACCT ,TRDTYP,TICK ,SACUS ,TRDDATE ,AMOUNT ,DESCRIPTION
46567252 ,DLV ,PNDDLV,13321 ,12/20/22,-1000.00 ,*PENDING W/D
46567252 ,DLV ,PNDDLV,13321 ,12/20/22,-2000.00 ,*PENDING W/D
46567252 ,DLV ,PNDDLV,13321 ,12/21/22,-2000.00 ,*PENDING W/D
46567252 ,DLV ,PNDDLV,13321 ,12/10/22,-2000.00 ,*SYS W/D
46567252 ,DLV ,PNDDLV,13321 ,12/09/22,-2000.00 ,*SYS W/D
46567252 ,DLV ,PNDDLV,13321 ,12/22/22,-2000.00 ,*PENDING W/D
46567252 ,DLV ,PNDDLV,13321 ,12/23/22,-1000.00 ,*PENDING W/D
46567252 ,DLV ,PNDDLV,13321 ,12/21/22,-2000.00 ,*SYS W/D
TRL RECORDS 00000008 ACCOUNTS 00000001