Record 03
Record 03 is the account identifier and summary status. This record identifies the account number and shows account activity and status. Record 03 ends with the account trailer record (49).
Required or Optional |
Field Description |
Field Position |
EnterpriseOne Table and Field |
Field Type and Length |
Description |
|---|---|---|---|---|---|
R |
Record Code |
1 |
Not applicable |
Numeric 2 |
The value in this field is always 03. |
R |
Customer Account Number |
2 |
F09610 SGBAN F09611 BGBAN |
String 29 |
The commercial account number. This number should include significant leading zeros. |
O |
Currency Code |
3 |
Not applicable |
String 3 |
This field does not map to an EnterpriseOne table. |
O |
Type Code |
4 |
Not applicable |
String 3 |
This field does not map to an EnterpriseOne table. |
O |
Amount - Summary |
5 |
F09610 SGOPBAA |
Numeric 15, 2 |
The opening and closing balances. Summary amounts are positive and do not include a sign. |
O |
Item Count |
6 |
Not applicable |
Numeric 5 |
This field does not map to an EnterpriseOne table. |
O |
Funds Type |
7 |
Not applicable |
Character 1 |
This field does not map to an EnterpriseOne table. |
O |
Value Date |
8A |
Not applicable |
Numeric 6 |
This field does not map to an EnterpriseOne table. |
O |
Value Time |
9A |
Not applicable |
Numeric 4 |
This field does not map to an EnterpriseOne table. |
O |
Amount - Immediate Availability |
8B |
Not applicable |
Numeric 15, 2 |
This field does not map to an EnterpriseOne table. |
O |
Amount - 1 Day Availability |
8B |
Not applicable |
Numeric 15, 2 |
This field does not map to an EnterpriseOne table. |
O |
Amount - 2 or more Day Availability |
10B |
Not applicable |
Numeric 15, 2 |
This field does not map to an EnterpriseOne table. |
O |
Number of Distributions |
8C |
Not applicable |
Numeric 1 |
This field does not map to an EnterpriseOne table. |
O |
Day Availability 1 |
9C |
Not applicable |
Numeric 1 |
This field does not map to an EnterpriseOne table. |
O |
Amount Available 1 |
10C |
Not applicable |
Numeric 15, 2 |
This field does not map to an EnterpriseOne table. |
O |
Day Availability 2 |
11C |
Not applicable |
Numeric 1 |
This field does not map to an EnterpriseOne table. |
O |
Amount Available 2 |
12C |
Not applicable |
Numeric 15, 2 |
This field does not map to an EnterpriseOne table. |
O |
Day Availability 3 |
13C |
Not applicable |
Numeric 1 |
This field does not map to an EnterpriseOne table. |
O |
Amount Available 3 |
14C |
Not applicable |
Numeric 15, 2 |
This field does not map to an EnterpriseOne table. |