| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | GMBKSTID | Bank Statement ID | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 2 | GMSTMD | Statement Date | Date | Generic Edit | 6 | 0 | |
| 3 | GMBSTN | Auto Bank Statement Number | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 4 | GMGLBA | G/L Bank Account | String | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | GMLIN | Line Number - General | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 6 | GMBSSEQ | Bank Statement Sequence | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 7 | GMSTLIN | Staging Line Number | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 8 | GMRECCODE | Reconciliation Code | Character | UDC (09 RC) | 1 | 0 | Allow NULL? |
| 9 | GMANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 | Allow NULL? |
| 10 | GMSTRN | Bank Statement Transaction Code | String | UDC (09 BJ) | 3 | 0 | Allow NULL? |
| 11 | GMCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 12 | GMDEBE | Debits Entered | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | GMCREE | Credits Entered | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | GMCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 15 | GMFDEB | Foreign Debit | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | GMFCRE | Foreign Credit | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 17 | GMSTAM | Amount - Tax | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | GMCTAM | Amount - Foreign Tax | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | GMATXA | Amount - Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 20 | GMCTXA | Amount - Foreign Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | GMEXR1 | Tax Expl Code 1 | String | UDC (00 EX) | 2 | 0 | Allow NULL? |
| 22 | GMTXA1 | Tax Rate/Area | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | GMRMK | Name - Remark | String | Generic Edit | 30 | 0 | Allow NULL? |
| 24 | GMCUSTSUP | Customer Supplier Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 25 | GMCSTSPFLG | Customer/Supplier Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | GMAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 27 | GMKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 28 | GMDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 29 | GMDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 30 | GMSFX | Document Pay Item | String | Generic Edit | 3 | 0 | Allow NULL? |
| 31 | GMDOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 32 | GMDGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 33 | GMDCTM | Document Type - Matching | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 34 | GMVLDT | Date - Cleared/Value | Date | Generic Edit | 6 | 0 | |
| 35 | GMOVDT | Date - Original Cleared/Value | Date | Generic Edit | 6 | 0 | |
| 36 | GMDMTJ | Date - Matching Check or Item - Julian | Date | Generic Edit | 6 | 0 | |
| 37 | GMDMT | Date - Matching Check or Item | Date | Generic Edit | 6 | 0 | |
| 38 | GMSBL | Subledger - G/L | String | Generic Edit | 8 | 0 | Allow NULL? |
| 39 | GMSBLT | Subledger Type | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 40 | GMR1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 | Allow NULL? |
| 41 | GMR1O | Original Reference 1 | String | Generic Edit | 8 | 0 | Allow NULL? |
| 42 | GMABRF | Create Auto Batch Receipt | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 43 | GMSSTC | Status Code - Item | Character | UDC (H00 SU) | 1 | 0 | Allow NULL? |
| 44 | GMREASCODE | Reason Code | String | UDC (09 UR) | 3 | 0 | Allow NULL? |
| 45 | GMPYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 46 | GMTRANT | External Transaction Type | String | Generic Edit | 4 | 0 | Allow NULL? |
| 47 | GMSUBF9 | Subfield 9 | String | Generic Edit | 34 | 0 | Allow NULL? |
| 48 | GMINFO1 | Misc Information | String | Generic Edit | 390 | 0 | Allow NULL? |
| 49 | GMUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 50 | GMPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 51 | GMJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 52 | GMUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 53 | GMUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 54 | GMCKNU | Receipt Number | String | Generic Edit | 25 | 0 | Allow NULL? |
