Quiz
Exporting Daily Transactions
You need to send the Daily Transactions data to the bank regulator.
Create a text file containing the Daily Transactions Data. Also include today’s date (you can use the TODAY() function and the Date9 format for this).
The bank regulator requires this layout for the file:
Do not include variable names in the text file.
1
1
1
ColumnVariableExample
1-9Date26JUL2018
10-11Leave Blank
12-16Transaction_ID00001
17-18Leave Blank
19-27Account_Number150374590
28-29Leave Blank
30-35TransactionCredit
36-37Leave Blank
38-53Amount$43,970.00
/docProps/thumbnail.jpeg