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

Mapping SWIFT Fields to the F09610 and F09611 Tables

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

These rules apply to the SWIFT bank format:

  • A } delimits the beginning of a block and a -} delimits the end of the block.

  • Fields within a block are enclosed with : :

  • If a delimiter is required between fields, a slash (/) is used.

  • A comma (,) is used instead of a decimal.

  • The amount is always in the currency of the bank account.