RBS Bankline v3
This information is provided for guidance only; you should always confirm the details before passing the file to BACS software.
Introduction
Scope
The following may be imported to Bankline:
BACS payments
Bulk list payments (initiation of payments from bulk list templates held on Bankline)
Payments from templates (initiation of payments from templates held on Bankline)
Currency and sterling inter-account transfers (IATs)
CHAPS payments (same-day domestic payments)
International payments
Templates for BACS, CHAPS, inter-account transfers and international payments
Bulk list templates
Old BankLine and Royline formats of payments are not supported in Bankline.
The import file must be in a Comma Separated Value (CSV) text file format.
Data Table Structure
Each import file is described in the data table.
Content of Physical Import File
The fields required for each type of payment are described in sequential order (column A) with their data length (column C, where x=alphanumeric, n=numeric and a=alphabetic) and where applicable the required data format e.g. ddmmyyyy or a list of acceptable values e.g. ‘01’, ‘02’ etc.
The data table further describes the fields required within an import file for a particular payment type (columns E, F, G, H and I). Each combination of data field and payment type shows whether the field is:
mandatory – indicated by an ‘M’
optional – indicated by an ‘O’
conditional – shown by a ‘C’
not applicable to this payment type – indicated by a shaded cell.
The data table shows header fields H001-H003 which are optional and appear for each record within the file. If header field H002 is populated on the first record within the file, this value will be used for the filename. Where it is not populated, Bankline will use the name of the import file e.g. VS001-01102006.txt as the filename.
Payments
The payments that may be imported are standard domestic BACS payments, urgent domestic CHAPS payments, currency and sterling IATs and international payments. These are described under column E at section 2.
Payment from Template
The payments from templates that may be imported are standard domestic BACS payments, urgent domestic CHAPS payments, currency and sterling IATS and international payments. These are described under column F at section 2.
Bulk List Payment
The bulk list payments that may be imported are standard domestic BACS payments with a single debit entry and multiple credit entries. These are defined under column G at section 2.
Payment Template Creation
The payment templates that may be imported are standard domestic BACS templates, urgent domestic CHAPS templates, currency and sterling IAT templates and international templates. These are defined under column H at section 2.
Bulk List Template Creation
The bulk list templates that may be imported are standard domestic BACS bulk list templates with a single debit entry and multiple credit entries. These are defined under column I at section 2.
Fields Allocated for Future Use
Sequential values missing from acceptable sets of values have been allocated for future enhancements to the import file structure.
Some fields are shown as not being used by any payment type within the layout. These fields have been created for future enhancements.
Completion of Fields
Data fields do not need to be padded with trailing spaces to reach the correct number of characters in the field length.
Fields that are populated incorrectly and that are not relevant for the type of payment being imported will not be validated.
Physical Import File Content
Key: Std D = Standard Domestic, Urg D = Urgent Domestic, IAT = Inter-account Transfer, INT = International, DR = Debit, CR = Credit
A. | B. | C. | D. | E. | E. | E. | E. | F. | F. | F. | F. | H. | H. | H. | H. | H. | H. | I. | I. |
A. | B. | C. | D. | Std D | Urg D | IAT | INT | Std D | Urg D | IAT | INT | DR | CR | Std D | Urg D | IAT | INT | DR | CR |
A. | B. | C. | Record Type | 01 | 02 | 03 | 04 | 01 | 02 | 03 | 04 | 06 | 07 | 01 | 02 | 03 | 04 | 06 | 07 |
H001 | Originating Customer Identifier | 16x | Customer Identifier of who is importing this file. Not supplied/populate by Bankline file Import process. For use by other channels | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O |
H002 | Import File Name | 50x | File name allocated by the customer Either use file name (Bankline Import) or value supplied here. | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O |
H003 | Bank Identifier | 4x | This will be derived by the mechanism authenticating the submitting customer. | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O |
T001 | Record Type | 2n | Defines what sort of payment is being advised. | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M |
T002 | Template Indicator | 1a | Defines whether the record type is a payment of a payment template creation. T - template. |
|
|
|
|
|
|
|
|
|
| M | M | M | M | M |
|
T003 | Template Reference | 20x | Identity of payment/ bulk list template that is to be used to source this payment. |
|
|
|
| M | M | M | M | M |
| M | M | M | M | M |
|
T004 | Confidential Indicator | 1a | Whether the bulk list template being created is to be marked confidential. |
|
|
|
|
|
|
|
|
|
|
|
|
|
| M |
|
T005 | Beneficiary Identifier | 25x | Customer identifier for a beneficiary in a bulk list. |
|
|
|
|
|
|
|
|
| M |
|
|
|
|
| M |
T006 | Customer Payment Reference | 18x | Reference allocated to the payment by the customer. 18 character available for standard domestic, otherwise 16x only. | O | O | O | O | O | O | O | O |
|
| O | O | O | O |
|
|
T007 | Destination Country | 2a | The ISO country code to which the payment is to be made. |
|
|
| M |
|
|
|
|
|
|
|
|
| M |
|
|
T008 | Priority | 1a | Priority to be allocated to the payment. |
|
|
| M |
|
|
|
|
|
|
|
|
| M |
|
|
T009 | Routing Method | 1a | Any special routing requirements for this payment. |
|
|
| O |
|
|
|
|
|
|
|
|
| O |
|
|
T010 | Debit Account | 34x | The account to be debited for this payment. | M | M | M | M | M | M | M | M | M |
| M | M | M | M | M |
|
T011 | Debit Charges Account Identifier | 34x | If a different account is to be debited for charges. Format as T010 Debit Account Identifier. |
|
|
| O |
|
|
| O |
|
|
|
|
| O |
|
|
T012 | Charges Code Type | 3a | Charge code: |
|
|
| C |
|
|
| C |
|
|
|
|
| C |
|
|
T013 | Payment Currency | 3a | The ISO currency code of the payment. |
|
| M | M | M | M | M | M |
| M | M | M | M | M |
|
|
T014 | Payment Amount | 15n | The amount of the payment may have up to two decimal places– | M | M | M | M | M | M | M | M |
| M |
|
|
|
|
|
|
T015 | Execution Date | DATE | Date on which the payment is to be effected. Format ddmmyyyy e.g. 01102006. |
| M | M | M |
| M | M | M |
|
|
|
|
|
|
|
|
T016 | Credit Date | DATE | Date that funds are received by beneficiary bankers. Format ddmmyyyy e.g. 01102006. | M |
|
|
| M |
|
|
| M |
|
|
|
|
|
|
|
T017 | Ordering Institution BIC/NCC Identifier | 16x | BIC or clearing code. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T018 | Ordering Institution Name and Address 1 | 35x | Free-format name and address details of Financial Institution. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T019 | Ordering Institution Name and Address 2 | 35x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T020 | Ordering Institution Name and Address 3 | 35x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T021 | Ordering Institution Name and Address 4 | 35x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T022 | Account with Bank BIC/NCC Identifier | 16x | BIC or clearing code e.g. sort code. | M | M | C | C |
|
|
|
|
| M | M | M | C | C |
| M |
T023 | Account with Bank Account Number | 34x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T024 | Account with Bank Name and Address 1 | 35x | Free-format name and address details. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T025 | Account with Bank Name and Address 2 | 35x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T026 | Account with Bank Name and Address 3 | 35x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T027 | Account with Bank Name and Address 4 | 35x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T028 | Beneficiary Account Number |
| Format is dependent on the type of payment. | M | M | M | C |
|
|
|
|
| M | M | M | M | C |
| M |
T029 | Beneficiary Institution BIC/NCC Identifier | 16x | BIC or clearing code. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T030 | Beneficiary Name and Address 1 | 35x | Free-format name and address details. | M | M |
| O |
|
|
|
|
| M | M | M |
| O |
| M |
T031 | Beneficiary Name and Address 2 | 35x |
|
| O |
| O |
|
|
|
|
|
|
| O |
| O |
|
|
T032 | Beneficiary Name and Address 3 | 35x |
|
| O |
| O |
|
|
|
|
|
|
| O |
| O |
|
|
T033 | Beneficiary Name and Address 4 | 35x |
|
| O |
| O |
|
|
|
|
|
|
| O |
| O |
|
|
T034 | Beneficiary Reference | 18x |
| O |
|
|
| O |
|
|
| M | O | O |
|
|
| M | O |
T035 | FX Deal Reference | 16n | The reference given to an FX deal. |
|
| C | C |
|
| C | C |
|
|
|
|
|
|
|
|
T036 | FX Deal Exchange Rate | 15n | The exchange rate given to an FX deal. The format allows a maximum of 8 numerics before the decimal point and a maximum of 7 numerics after the decimal point. |
|
| C | C |
|
| C | C |
|
|
|
|
|
|
|
|
T037 | Information for Beneficiary 1 | 35x | Payment Details. For an IAT the credit account narrative may be entered in the first 18 characters. |
| O | O | O |
| O | O | O |
|
|
|
| O |
|
|
|
T038 | Information for Beneficiary 2 | 35x |
|
| C | C | C |
| C | C | C |
|
|
|
| C |
|
|
|
T039 | Information for Beneficiary 3 | 35x |
|
| C | C | C |
| C | C | C |
|
|
|
| C |
|
|
|
T040 | Information for Beneficiary 4 | 35x |
|
| C | C | C |
| C | C | C |
|
|
|
| C |
|
|
|
T041 | RTGS Required | 1a |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T042 | Credit Currency | 3a | ISO currency code of the destination country or your chosen currency for payment. |
|
|
| M |
|
|
| M |
|
|
|
|
| M |
|
|
T043 | Intermediary Bank BIC/NCC Identifier | 16x | BIC or clearing code. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T044 | Intermediary Bank Name and Address 1 | 35x | Free-format name and address details. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T045 | Intermediary Bank Name and Address 2 | 35x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T046 | Intermediary Bank Name and Address 3 | 35x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T047 | Intermediary Bank Name and Address 4 | 35x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T048 | Additional Codewords 1 | 4a | SWIFT codeword. These may be placed in Additional Codeword #1 through to #10. The values for codewords are: |
| O |
| C |
| O |
| C |
|
|
| O |
| C |
|
|
T049 | Additional Codewords Text 1 | 29x | Additional text to accompany the SWIFT codeword. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T050 | Additional Codewords 2 | 4a |
|
| O |
| C |
| O |
| C |
|
|
| O |
| C |
|
|
T051 | Additional Codewords Text 2 | 29x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T052 | Additional Codewords 3 | 4a |
|
| O |
| C |
| O |
| C |
|
|
| O |
| C |
|
|
T053 | Additional Codewords Text 3 | 29x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T054 | Additional Codewords 4 | 4a |
|
| O |
| C |
| O |
| C |
|
|
| O |
| C |
|
|
T055 | Additional Codewords Text 4 | 29x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T056 | Additional Codewords 5 | 4a |
|
| O |
| C |
| O |
| C |
|
|
| O |
| C |
|
|
T057 | Additional Codewords Text 5 | 29x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T058 | Additional Codewords 6 | 4a |
|
| O |
| C |
| O |
| C |
|
|
| O |
| C |
|
|
T059 | Additional Codewords Text 6 | 29x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T060 | Additional Codewords 7 | 4a |
|
| O |
| C |
| O |
| C |
|
|
| O |
| C |
|
|
T061 | Additional Codewords Text 7 | 29x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T062 | Additional Codewords 8 | 4A |
|
| O |
| C |
| O |
| C |
|
|
| O |
| C |
|
|
T063 | Additional Codewords Text 8 | 29X |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T064 | Additional Codewords 9 | 4A |
|
| O |
| C |
| O |
| C |
|
|
| O |
| C |
|
|
T065 | Additional Codewords Text 9 | 29X |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T066 | Additional Codewords 10 | 4A |
|
| O |
| C |
| O |
| C |
|
|
| O |
| C |
|
|
T067 | Additional Codewords Text 10 | 29X |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T068 | Regulatory Reporting 1 | 35x | Code, country and narrative. |
|
|
| O |
|
|
| O |
|
|
|
|
| O |
|
|
T069 | Regulatory Reporting 2 | 35x | Additional narrative. |
|
|
| C |
|
|
| C |
|
|
|
|
| C |
|
|
T070 | Regulatory Reporting 3 | 35x | Additional narrative. |
|
|
| C |
|
|
| C |
|
|
|
|
| C |
|
|
T071 | Remittance Advice Indicator | 1a | Can only contain <C> company letter head. | O |
|
|
| O |
|
|
| O |
| O |
|
|
| O |
|
T072 | Remittance Advice Beneficiary Address 1 | 35x |
| C |
|
|
| C |
|
|
|
| C | C |
|
|
|
| C |
T073 | Remittance Advice Beneficiary Address 2 | 35x |
| C |
|
|
| C |
|
|
|
| C | C |
|
|
|
| C |
T074 | Remittance Advice Beneficiary Address 3 | 35x |
| O |
|
|
| O |
|
|
|
| O | O |
|
|
|
| O |
T075 | Remittance Advice Beneficiary Address 4 | 35x |
| O |
|
|
| O |
|
|
|
| O | O |
|
|
|
| O |
T076 | Remittance Advice Beneficiary FAX Number | 20x |
| O |
|
|
| O |
|
|
|
| O | O |
|
|
|
| O |
T077 | Remittance Advice Beneficiary Email Address | 50x |
| O |
|
|
| O |
|
|
|
| O | O |
|
|
|
| O |
Note: IBAN comprises 30 alphanumeric characters in the following format:
Country code: XX (2 alpha numeric characters)
Check digits: XX (2 numeric characters for validation of the IBAN)
SWIFT/BIC code: XXXX (1st four letters of SWIFT/Bank Identifier code)
Bank code: XX (unique bank code )
Bank code: XX (the first two digits of a/c no.)
A/C no.: 00000xxxxxxx (five leading zeros are added to the last seven digits of a/c no.)
A valid IBAN should always contain 12 digits (inclusive of these five zeros)
Future use: 000 (three zeros)
Currency code: xxx (3 alpha numeric characters)
Conditional Fields
Field | Conditions |
T012 | Conditional for international payments. If Priority (T008) = 'L' and Currency code (T013) is not EURO or is EURO and destination country is not a SEPA country then charge type code must be 'OUR'. If Priority (T008) = 'L' and Currency code (T013) is EURO and destination country is a SEPA country then the charge type code must be 'SHA' or 'OUR'. |
T022 - |
For international payments: If Priority (T008) = 'L' and Currency code (T013) is completed but is not euro OR if Priority (T008) = 'L' and Currency code (T013) is Euro and Destination Country (T007) is not a SEPA country then the Account with Bank BIC/NCC (T022) must not be completed. In all other payments the Account with Bank BIC/NCC (T022) must be completed.
For inter-account transfers: If the credit account is a currency account then the Account with BIC/NCC must be blank else it
|
T028 | Conditional for international payments. Must not be present for an international payment when Routing Method (T009) indicates |
T031 to T033 | 1. Can be optionally supplied when Beneficiary Name and Address #1 (T030) is present. |
T035 | Only applies to Currency IATs and international payments. Must be present if FX Deal Exchange Rate (T036) is present. Otherwise, must not be present. |
T036 | Only applies to Currency IATs and international payments. Must be present if FX Deal Reference (T035) is present. Otherwise, |
T038 to T040 | Conditional for urgent domestic, IAT and international record types. Can be optionally supplied when Information for Beneficiary |
T069 to T070 | Can only be present when Regulatory Reporting Line 1 (T068) is present. Note: T070 can only be present if T069 is supplied. |
T073 to T075 | Can be optionally supplied when Remittance Advice Beneficiary Address #1 (T072) is present. A line can only be present when the |
T048 to T066 | If Priority = L (international LVP payment) then the Additional Codewords #1 though to #10 must be blank. |
T071 |
For standard domestic payments (payment type 01): If T071 Remittance Advice Indicator is supplied then T072 Remittance Advice
For bulk list templates (payment type 06 and 07): If T071 Remittance Advice Indicator is not supplied on the Bulk List Template Debit record (payment type 06) then T072 Remittance Advice Beneficiary Address #1 and T073 Remittance Advice Beneficiary Address #2 should not contain data for any CR record (payment type 07). If T072 Remittance Advice Beneficiary Address #1 is supplied on the Bulk List Template Credit record (payment type 07) then T073 Remittance Advice Beneficiary Address #2 is mandatory.
|
File and Record Combination Rules
Templates are not allowed to be mixed in a file with payments, payments from templates, bulk list template creation and bulk list payments.
Bulk list templates are not allowed to be mixed in a file with payments, payments from templates, template creation and bulk list payments.
Bulk list payments must refer to an existing bulk list template recorded in Bankline.
Payments from templates must refer to an existing template recorded in Bankline.
Where a bulk list payment debit record (type 06) is present in a file it must be the only bulk list payment debit record (type 06). There may be multiple bulk list payment credit records (type 07) records in the same file.
Glossary
Abbreviation
|
Meaning
|
BACS
|
Bank Automated Clearing System.
BACS Payment Schemes limited is the company responsible for the
The BACS payment system operates in a 3-day cycle, whereby payments
|
BIC
|
Bank Identification Code.
This is the structured code used by SWIFT to uniquely identify a financial
|
Domestic
|
Domestic payments are those that are to be made to a beneficiary who is
|
IAT
|
Inter-account transfer.
An IAT is a payment made by a customer from one of their own accounts
|
National Clearing Code
|
The standard identification code for a country, used to uniquely identify a
|
RBSG
|
The Royal Bank of Scotland Group.
|
Sort Code
|
The UK's national clearing code used to uniquely label a bank, branch or
|
SWIFT
|
Society for Worldwide Interbank Financial Telecommunication.
SWIFT operate and regulate the secure network used to transmit many of
|
Date Definitions
This document refers to a number of different dates. This section defines what is meant by each date and context.
Date | Context | Meaning |
Credit Date | Standard domestic |
This is the date on which the receiving institution takes
Typically, this will also be the date on which the funds
|
Execution Date | All payments without |
This is the date on which the payment is processed
For same-day payments, it is also the keying date.
For future dated payments, it is the date on which the
|
Examples
Standard Domestic
,,,01,,,,,,,,,15100031806542,,,GBP,166.42,,01102006,,,,,,151000,,,,,,44298801,,MR JOHN SMITH,,,,XY1234,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Urgent Domestic
,,,02,,,,,,,,,15100031806542,,,GBP,1166,01102006,,,,,,,151000,,,,,,44298801,,MR JOHN SMITH,,,,,,,PYMNT FROM 151000 31806542 of 1166,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Inter-account Transfer
,,,03,,,,,,,,,15100031806542,,,GBP,166.42,01102006,,,,,,,151000,,,,,,44298801,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
International
,,,04,,,,,,US,N,,15100031806542,,,USD,1266.42,01102006,,,,,,, IRVTUS3NIRD,,,,,,44298801,,MR JOHN SMITH,,,,,2006100112999,1.87,,,,,,USD,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Bulk List Payment
,,,06,,SALARY MONTH END 01,,,,,,,15100031806542,,,,,,01102006,,,,,,,,,,,,,,,,,,361275C,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Bulk List Credit Payment
,,,07,,,,1887,,,,,,,,GBP,1566.23,,,,,,,,151000,,,,,,31803654,,MR JOHN SMITH,,,,361275C,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
