Block 4
Block 4 contains opening balances, transactions amounts and dates, closing balances, and forecasting amounts. Fields 61 and 86 can be repeated, but they must always occur before field 62.
SWIFT |
Field Description |
Field |
Field Position |
EnterpriseOne Table and Field |
Field Type and Length |
Description |
---|---|---|---|---|---|---|
R |
Transaction Reference Number |
20 |
1–16 |
F09610 SGETRN |
String 16 |
The reference number of electronic statement. |
R |
Account Identification |
25 |
1–35 |
F09610 SGBAN |
String 35 |
The account number. |
R |
Statement Number |
28C |
1–5 |
F09610 SGBSTN F09611 BGBSTN |
Numeric 15 |
The bank statement number. |
O |
Separator |
28C |
/ |
Not applicable |
Character 1 |
This field is required only if there is a sequence number. This field does not map to an EnterpriseOne table. |
O |
Sequence Number |
28C |
7–11 |
F09610 SGBSSEQ F09611 BGBSSEQ |
Numeric 5 |
The sequential number for each transaction. |
R |
Opening Balance Debit/Credit Indicator |
60m or 60f |
1 |
F09610 SGOBDBCR |
Character 1 |
The debit (D) or credit (C) indicator for the opening balance. |
R |
Opening Booking Date |
60m or 60f |
2–7 |
F09610 SGOLVDT |
Date 6 |
The value date for the opening balance, in YYMMDD format. |
R |
Opening Balance Currency Code |
60m or 60f |
8–10 |
F09610 SGOCRCD F09611 BGTCRCD |
String 3 |
The 3-character ISO currency code associated with the opening balance amount. |
R |
Opening Balance Amount |
60m or 60f |
11–25 |
F09610 SGOPBAA |
Numeric 15, 2 |
The opening balance amount. |
R |
Value Date |
61 |
1–6 |
F09611 BGVLDT |
Date 6 |
The date that the transaction clears the bank, in YYMMDD format. |
O |
Booking Date |
61 |
7–10 |
Not applicable |
Date 4 |
This field does not map to an EnterpriseOne table. |
R |
Detail Debit/Credit Indicator |
61 |
11–12 |
F09611 BGDDBCR |
String 2 |
The indicator for debit (D), credit (C), reversal of credit (RC), or reversal of debit (RD). |
O |
Type of Currency |
61 |
13 |
F09611 BGCURRT |
Character 1 |
The third character of the ISO currency code. |
R |
Transaction Amount |
61 |
14–28 |
F09611 BGAA |
Numeric 15, 2 |
The amount of the transaction. |
R |
Transaction Type |
61 |
29–32 |
F09611 BGTRANT |
String 4 |
The transaction type identification code. |
O |
Reference |
61 |
33–48 |
F09611 BGCUSTREF |
String 16 |
The customer reference, such as payment or receipt. |
R |
Separator |
61 |
49–50 |
Not applicable |
/ |
If an external bank reference exists, this field is required. This field does not map to an EnterpriseOne table. |
O |
External Bank Reference |
61 |
51–66 |
F09611 BGBANKREF |
String 16 |
The account servicing institution's reference. |
R |
Separator |
61 |
67–70 |
Not applicable |
/ |
If detail (positions 71-102) exists, this field is required. This field does not map to an EnterpriseOne table. |
O |
Detail |
61 |
71–102 |
F09611 BGSUBF9 |
String 34 |
The supplementary details. |
R |
Informational line |
86 |
All |
F09611 BGINFO1 |
String 390 |
An informational line that can contain 65 characters. There are six informational lines. |
R |
Closing Balance Debit/Credit Indicator |
62m or 62f |
1 |
F09610 SGCBDBCR |
Character 1 |
The indicator debit (D) or credit (C) for the closing balance amount. |
R |
Closing Booking Date |
62m or 62f |
2–7 |
F09610 SGCBDBCR |
Date 6 |
The date of the closing balance, in YYMMDD format. |
R |
Closing Currency Code |
62m or 62f |
8–10 |
F09610 SGCCRCD |
String 3 |
The 3-character ISO currency code for the closing balance. |
R |
Closing Balance Amount |
62m or 62f |
11–25 |
F09610 SGCLBAA |
Numeric 15, 2 |
The closing balance amount. |
R |
Closing Available Balance Debit/Credit Indicator |
64 |
1 |
F09610 SGCADBCR |
Character 1 |
Field 64 is optional, but if it is used all subfields are required. |
R |
Closing Available Value Date |
64 |
2–7 |
F09610 SGCAVLDT |
Date 6 |
The value date for the closing available balance, in YYMMDD format. |
R |
Closing Available Currency Code |
64 |
8–10 |
F09610 SGCACRCD |
String 3 |
The 3-character ISO currency code for the closing available balance. |
R |
Closing Available Balance |
64 |
11–25 |
F09610 SGCAVAA |
Numeric 15, 2 |
The closing available balance amount. |
R |
Forward Available Balance Debit/Credit Indicator |
65 |
1 |
F09610 SGFADBCR |
Character 1 |
Field 65 is optional, but if it is used all subfields are required. |
R |
Forward Available Value Date |
65 |
2–7 |
F09610 SGFVLDT |
Date 6 |
The value date for the forward available balance, in YYMMDD format. |
R |
Forward Available Currency Code |
65 |
8–10 |
F09610 SGFACRCD |
String 3 |
The 3-character ISO currency code for the forward available balance. |
R |
Forward Available Balance |
65 |
11–25 |
F09610 SGFAVAA |
Numeric 15, 2 |
The forward available balance amount. |