Loading Bank statement with 44 and 54 code lines
Hello,
We are running into difficulties loading bank statements for one of our banks.
The bank states in their spec:
'Each file contains mixed credit and debit transactions in date order. Control total records (transaction code 44 and 54) appear at change of date, indicating the value of all daily debit and credit transactions. These credit and debit total records will always be present, regardless of the type of records on the file.'
These daily credit and debit totals are causing us an issue in our upload process.
We were originally stripping out any code 44 or 54 lines during the SQL Loader process so that they were not being loaded but the problem is that their total values are included in the UTL line control totals.