| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | BGBSTN | Auto Bank Statement Number | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 2 | BGSTMD | Statement Date | Date | Generic Edit | 6 | 0 | |
| 3 | BGBAN | Electronic Bank Account Number | String | Generic Edit | 29 | 0 | Allow NULL? |
| 4 | BGBKSTID | Bank Statement ID | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 5 | BGSTLIN | Staging Line Number | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 6 | BGBSSEQ | Bank Statement Sequence | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 7 | BGRECCODE | Reconciliation Code | Character | UDC (09 RC) | 1 | 0 | Allow NULL? |
| 8 | BGVLDT | Date - Cleared/Value | Date | Generic Edit | 6 | 0 | |
| 9 | BGBVLDT | Transaction Booking Date | String | Generic Edit | 5 | 0 | Allow NULL? |
| 10 | BGDDBCR | Transaction Debit/Credit Indicator | String | UDC (09 TD) | 2 | 0 | Allow NULL? |
| 11 | BGTCRCD | Transaction Currency Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 12 | BGCURRT | Transaction Currency Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | BGAA | Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | BGTRANT | External Transaction Type | String | Generic Edit | 4 | 0 | Allow NULL? |
| 15 | BGCUSTREF | Customer Reference | String | Generic Edit | 16 | 0 | Allow NULL? |
| 16 | BGBANKREF | Bank Reference | String | Generic Edit | 16 | 0 | Allow NULL? |
| 17 | BGEFI | Electronic Format Indicator | String | UDC (09 FT) | 6 | 0 | Allow NULL? |
| 18 | BGSUBF9 | Subfield 9 | String | Generic Edit | 34 | 0 | Allow NULL? |
| 19 | BGBSTEXT | Bank Statement Text | String | Generic Edit | 40 | 0 | Allow NULL? |
| 20 | BGINFO1 | Misc Information | String | Generic Edit | 390 | 0 | Allow NULL? |
| 21 | BGUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 22 | BGPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | BGJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | BGUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 25 | BGUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
