Oracle Account Reconciliation and Loading Bank BAI Files
Length of Bank Text Column Increased to 1200 Characters When Using BAI Format Bank Files
When loading transactions using BAI Format Bank files, the Bank Text can now be up to 1200 characters long. Three new columns, Bank Text2, Bank Text3, and Bank Text4, are added.
If the Bank Text exceeds 300 characters, one or more of these new columns are used to store the Bank Text. For example, if the Bank Text is 850 characters, then it is loaded into the Bank Text, Bank Text2, and Bank Text3 columns.
Business Benefit: This feature enhances the usability of BAI Bank Format files by allowing users to load longer Bank Text values and then use these during matching.
Integrating BAI, SWIFT MT940, and CAMT.053 Format Bank File Transactions
When loading bank file data, you create a data source associated with the bank file source system. Data Integration converts the BAI, SWIFT MT940, or CAMT.053 file formats to CSV format for loading into Transaction Matching. The CSV load file can be viewed in the Transaction Matching Jobs results.
The source application for BAI Format Bank File Transactions has the following pre-defined constant columns and headers:
- Account
- Amount
- Transaction Type
- Currency
- Transaction Date
- Bank Reference
- Customer Reference
- Bank Text
- Bank Text2, Bank Text3, and Bank Text4
The source application for a Swift MT940 Format Bank File Transactions has the following pre-defined constant fields:
No comments:
Post a Comment