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.