This section contains the default mapping rules created for the SWIFT940 format.
SWIFT940 header information is stored in records with tags of 25, 28C, 60a, and 62a. A tag behaves similarly as record ID in BAI2. When a record is copied from a SWIFT940 bank statement file to the intermediate table, the Bank Statement Loader program uses the tag as the record ID, but deletes the last non-numeric character. The following is an example:
:20:GL9903010486
:25:720520899611
:28:193
:60F:C990226BEF37692,
:62F:C990227BEF37812,12
The following table contains the legend for SWIFT940 tables:
| Legend for SWIFT940 Tables | Legend for SWIFT940 Tables |
|---|---|
| a | character |
| n | numeric |
| number | numeric |
| x | character or numeric |
| [ ] | optional |
The following table illustrates the mapping of SWIFT940 header information with record ID 25/25 and record name Account Identification to the Bank Statement Headers Interface table:
| Format in SWIFT940 | SWIFT940 Field | Intermediate Table Column | Interface Table Column |
|---|---|---|---|
| 35x: Account Identification | 35x | COLUMN1 | BANK_ACCOUNT_NUM |
The following table illustrates the mapping of SWIFT940 header information with record ID 28C/28 and record name Statement Number/Sequence Number to the Bank Statement Headers Interface table:
| Format in SWIFT940 | SWIFT940 Field | Intermediate Table Column | Interface Table Column |
|---|---|---|---|
| 5n: Statement Number [/3n]: Sequence Number | 5n[/3n] | COLUMN1 | STATEMENT_NUMBER |
The following table illustrates the mapping of SWIFT940 header information with record ID 60a/60 and record name Opening Balance to the Bank Statement Headers Interface table:
| Format in SWIFT940 | SWIFT940 Field | Intermediate Table Column | Interface Table Column |
|---|---|---|---|
| 1a: D or C | 1a | COLUMN2 | |
| 6n: Opening Balance Date | 6n | COLUMN3 | |
| 3a: Currency Code | 3a | COLUMN4 | CURRENCY_CODE |
| 15number: Opening Balance | 15number | COLUMN5 | CONTROL_BEGIN_BALANCE |
The following table illustrates the mapping of SWIFT940 header information with record ID 62a/62 and record name Closing Balance to the Bank Statement Headers Interface table:
| Format in SWIFT940 | SWIFT940 Field | Intermediate Table Column | Interface Table Column |
|---|---|---|---|
| 1a: D or C | 1a | COLUMN2 | |
| 6n: Closing Balance Date | 6n | COLUMN3 | STATEMENT_DATE |
| 3a: Currency Code | 3a | COLUMN4 | |
| 15number: Closing Balance | 15number | COLUMN5 | CONTROL_END_BALANCE |
The remaining columns in the Bank Statement Headers Interface table are populated as indicated in the table below:
| Column Name | Source |
|---|---|
| BANK_NAME | not populated |
| BANK_BRANCH_NAME | not populated |
| CONTROL_TOTAL_DR | not populated, because SWIFT940 does not provide this information |
| CONTROL_TOTAL_CR | not populated, because SWIFT940 does not provide this information |
| CONTROL_DR_LINE_COUNT | not populated |
| CONTROL_CR_LINE_COUNT | not populated |
| CONTROL_LINE_COUNT | not populated |
| RECORD_STATUS_FLAG | defaulted to 'N' |
| ORG_ID | populated by calling the FND_PROFILE API |
| CHECK_DIGITS | not populated |
| CASHFLOW_BALANCE | not populated |
| INT_CALC_BALANCE | not populated |
| ONE_DAY_FLOAT | not populated |
| TWO_DAY_FLOAT | not populated |
| INTRA_DAY_FLAG | 'N' if populated by the Bank Statement Loader program. 'Y' if populated by the Intra-Day Bank Statement Loader program. |
| CREATED_BY | automatically populated at the time of insert |
| CREATION_DATE | automatically populated at the time of insert |
| LAST_UPDATED_BY | automatically populated at the time of insert and update |
| LAST_UPDATE_DATE | automatically populated at the time of insert and update |
SWIFT940 line information is stored in record ID 61. Record ID 61A and record ID 86 are continuation records that contain overflow information from record ID 61. The following is an example:
:61:9903020301D3,92N422NONREF
/OCMT/EURI,78
:86: 43.59.16.629 GTS OPERATIONS ADM
00011000000090 000000520012 9123456 19999
The following table illustrates the mapping of SWIFT940 line information with record ID 61/61 and record name Statement Line to the Bank Statement Lines Interface table:
| Format in SWIFT940 | SWIFT940 Field | Intermediate Table Column | Interface Table Column |
|---|---|---|---|
| 6n: Transaction Date | 6n | COLUMN1 | TRX_DATE |
| [4n] : Entry Date | [4n] | COLUMN2 | |
| 2a: Debit/Credit Mark | 2a | COLUMN3 | |
| [1a] : Funds Code | [1a] | COLUMN4 | |
| 15number : Amount | 15number | COLUMN5 | AMOUNT |
| axxx : Transaction Code | axxx | COLUMN6 | TRX_CODE |
| 16x : Reference for Account Owner | 16x | COLUMN7 | CUSTOMER_TEXT |
| [//16x] : Account Servicing Institution's Reference | [//16x] | COLUMN8 | BANK_ACCOUNT_TEXT |
| [34x] : Supplementary Detail |
The following table illustrates the mapping of SWIFT940 line information with record ID 86/61A and record name Information to Account Owner to the Bank Statement Lines Interface table:
| Format in SWIFT940 | SWIFT940 Field | Intermediate Table Column | Interface Table Column |
|---|---|---|---|
| 65x: Information to Account Owner | 65x | COLUMN1 | BANK_TRX_NUMBER, TRX_TEXT |
Additional Information: [34x] is stored as a separate record ID 61A and is mapped to the TRX_TEXT column. Overflow information from record ID 61 is stored in the same column as the supplementary details in record ID 61. The BANK_TRX_NUMBER column is populated with data from the Information to Account Owner field that matches the default format of Example (xxx). You must change the format to the actual format used by your bank. The Transaction Code field identifies the type of transaction. For example, transfers are identified as TRF. However, the Transaction Code field does not contain information about the debit or credit nature of the transaction. A separate field, the Debit/Credit Mark field, is used to differentiate debit and credit entries, where D means debit and C means credit. When the Bank Statement Loader program populates the TRX_CODE column in the Bank Statement Lines Interface table, it appends the Debit/Credit Mark to the Transaction Code to form a new code. For example, debit transfers are identified as TRFD and credit transfers as TRFC. You must set up these new bank transaction codes in Cash Management before you can import the bank statement information.
The remaining columns in the Bank Statement Lines Interface table are populated as the following table illustrates:
| Column Name | Source |
|---|---|
| BANK_ACCOUNT_NUM | copied from the header information |
| STATEMENT_NUMBER | copied from the header information |
| LINE_NUMBER | sequentially generated, starting with 1 |
| EFFECTIVE_DATE | not populated |
| INVOICE_TEXT | not populated |
| CURRENCY_CODE | not populated, but Bank Statement Import program defaults the currency code from the header information |
| USER_EXCHANGE_RATE_TYPE | not populated |
| EXCHANGE_RATE_DATE | not populated |
| EXCHANGE_RATE | not populated |
| ORIGINAL_AMOUNT | not populated |
| CHARGES_AMOUNT | not populated |
| CREATED_BY | automatically populated at the time of insert |
| CREATION_DATE | automatically populated at the time of insert |
| LAST_UPDATED_BY | automatically populated at the time of insert and update |
| LAST_UPDATE_DATE | automatically populated at the time of insert and update |