| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | SGBSTN | Auto Bank Statement Number | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 2 | SGSTMD | Statement Date | Date | Generic Edit | 6 | 0 | |
| 3 | SGBAN | Electronic Bank Account Number | String | Generic Edit | 29 | 0 | Allow NULL? |
| 4 | SGBSSEQ | Bank Statement Sequence | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 5 | SGBKSTID | Bank Statement ID | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 6 | SGMESST | Electronic Message Type | String | Generic Edit | 5 | 0 | Allow NULL? |
| 7 | SGDESC04 | Description 4 | String | Generic Edit | 45 | 0 | Allow NULL? |
| 8 | SGOBDBCR | Opening Balance Debit/Credit Indicator | Character | UDC (09 CD) | 1 | 0 | Allow NULL? |
| 9 | SGOLVDT | Opening Booking Date | Date | Generic Edit | 6 | 0 | |
| 10 | SGOCRCD | Opening Currency Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 11 | SGTCRCD | Transaction Currency Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 12 | SGOPBAA | Opening Balance Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | SGCBDBCR | Closing Balance Debit/Credit Indicator | Character | UDC (09 CD) | 1 | 0 | Allow NULL? |
| 14 | SGCBVLDT | Closing Booking Date | Date | Generic Edit | 6 | 0 | |
| 15 | SGCCRCD | Closing Currency Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 16 | SGCLBAA | Closing Balance Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 17 | SGCADBCR | Closing Available Balance D/C Indicator | Character | UDC (09 CD) | 1 | 0 | Allow NULL? |
| 18 | SGCAVLDT | Closing Available Value Date | Date | Generic Edit | 6 | 0 | |
| 19 | SGCACRCD | Closing Available Currency Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 20 | SGCAVAA | Closing Available Balance | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | SGFADBCR | Forward Available Balance D/C Indicator | Character | UDC (09 CD) | 1 | 0 | Allow NULL? |
| 22 | SGFVLDT | Forward Value Date | Date | Generic Edit | 6 | 0 | |
| 23 | SGFACRCD | Forward Available Currency Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 24 | SGFAVAA | Forward Available Balance | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 25 | SGFIO | File Input/Output | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | SGEFI | Electronic Format Indicator | String | UDC (09 FT) | 6 | 0 | Allow NULL? |
| 27 | SGRECCODE | Reconciliation Code | Character | UDC (09 RC) | 1 | 0 | Allow NULL? |
| 28 | SGETRN | Electronic Trans Ref Number | String | Generic Edit | 16 | 0 | Allow NULL? |
| 29 | SGBSSID | Sender Identification | String | Generic Edit | 9 | 0 | Allow NULL? |
| 30 | SGBSRID | Receiver Identification | String | Generic Edit | 9 | 0 | Allow NULL? |
| 31 | SGBSODF | One Day Float | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 32 | SGBSTDF | Two Or More Days Float | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 33 | SGOKPURGE | Ok Purge | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 34 | SGUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 35 | SGPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | SGJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 37 | SGUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 38 | SGUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |