1. General Accounting Implementation Guide
  2. Mapping BAI2 Fields to the F09610 and F09611 Tables

Mapping BAI2 Fields to the F09610 and F09611 Tables

This section describes how the Process Automatic Bank Statements Flat File Program (R09600) maps fields for the BAI2 bank format from the bank flat file to the EnterpriseOne bank statement staging header (F09610) and detail (F09611) tables.

These rules apply to the BAI2 bank format:

  • A comma (,) delimits fields within records.

  • A slash (/) indicates the end of the logical record, except for record 16.

  • The comma and slash characters are not allowed in any fields except for record 16 text.

  • Adjacent delimiters (, ,) identify a default or unspecified field value.

  • Amount fields do not contain decimals.

    The decimal places are implied, based on the currency code.

  • The default currency code is USD (2 decimal places).

  • If record 16 does not end within a text field, that record must end with a delimiter slash(/), even if the continuation record (88) begins with or includes text. If record 16 ends with text that is to be continued, that record must not end with a delimiter.