Understanding the Process Automatic Bank Statements Flat File Program

You use the Process Automatic Bank Statements Flat File program (R09600) to convert the data that you receive from the bank into a format that can be read and used by the JD Edwards EnterpriseOne General Accounting system. The bank file must be a text flat file. This program supports the BAI2 and SWIFT data formats. When you run this program, the system reads the data in the bank file and converts it to the appropriate format. It then writes data to the staging tables (F09610 and F09611). The R09600 calls these business functions to process bank statement data depending on the processing option settings:

• Process Automatic Bank Statements Flat File – BAI2 Format (B0900601)

  This business function is used only when the processing options of the R09600 are set to process BAI2 format. This function reads the text file as input, parses out the data and calls the B0900603 to write records to the staging tables. The system logs all errors that this function encounters in the jdedebug.log.

• Process Automatic Bank Statements Flat File – Swift Format (B0900602)

  This business function is used only when the processing options of the R09600 are set to process SWIFT format. This function reads the text file as input, parses out the data and calls the B0900603 to write records to the staging tables. The system logs all errors that this function encounters in the jdedebug.log.

• Process Automatic Bank Statements Flat File Cache Functions (B0900603)

  This business function is used when processing both the BAI2 and SWIFT formats. This function writes the formatted data to the staging tables.