| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | GDPOST | G/L Posted Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 2 | GDGLBA | G/L Bank Account | String | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | GDAM | Account Mode - G/L | Character | UDC (H09 AM) | 1 | 0 | Allow NULL? |
| 4 | GDSTMD | Statement Date | Date | Generic Edit | 6 | 0 | |
| 5 | GDSTBA | Bank Statement Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 6 | GDLIN | Line Number - General | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 7 | GDSEQ | Sequence Number | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 8 | GDSSTC | Status Code - Item | Character | UDC (H00 SU) | 1 | 0 | Allow NULL? |
| 9 | GDSTRN | Bank Statement Transaction Code | String | UDC (09 BJ) | 3 | 0 | Allow NULL? |
| 10 | GDAG | Amount - Gross | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 11 | GDCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 12 | GDACR | Amount - Currency | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | GDABC | Amount - Base Company | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | GDSTAM | Amount - Tax | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | GDCTAM | Amount - Foreign Tax | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | GDATXA | Amount - Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 17 | GDCTXA | Amount - Foreign Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | GDEXR1 | Tax Expl Code 1 | String | UDC (00 EX) | 2 | 0 | Allow NULL? |
| 19 | GDTXA1 | Tax Rate/Area | String | Generic Edit | 10 | 0 | Allow NULL? |
| 20 | GDRMK | Name - Remark | String | Generic Edit | 30 | 0 | Allow NULL? |
| 21 | GDAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 22 | GDCBNK | Bank Account Number - Customer | String | Generic Edit | 20 | 0 | Allow NULL? |
| 23 | GDTNST | Transit Number - Bank | String | Generic Edit | 20 | 0 | Allow NULL? |
| 24 | GDCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 25 | GDDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 26 | GDDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 27 | GDSFX | Document Pay Item | String | Generic Edit | 3 | 0 | Allow NULL? |
| 28 | GDDOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 29 | GDDCTM | Document Type - Matching | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 30 | GDDMTJ | Date - Matching Check or Item - Julian | Date | Generic Edit | 6 | 0 | |
| 31 | GDPO | Purchase Order | String | Generic Edit | 8 | 0 | Allow NULL? |
| 32 | GDDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 33 | GDANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 | Allow NULL? |
| 34 | GDDGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 35 | GDSBL | Subledger - G/L | String | Generic Edit | 8 | 0 | Allow NULL? |
| 36 | GDSBLT | Subledger Type | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 37 | GDTRTC | Cash Receipt Tran Code | Character | UDC (H03 TR) | 1 | 0 | Allow NULL? |
| 38 | GDVLDT | Date - Cleared/Value | Date | Generic Edit | 6 | 0 | |
| 39 | GDPYIN | Payment Instrument | Character | UDC (00 PY) | 1 | 0 | Allow NULL? |
| 40 | GDCTL | Control/Statement Field | String | Generic Edit | 13 | 0 | Allow NULL? |
| 41 | GDR1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 | Allow NULL? |
| 42 | GDHMCU | Business Unit - Home | String | Generic Edit | 12 | 0 | Allow NULL? |
| 43 | GDUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 44 | GDKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 45 | GDBTT | Bank Transaction Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 46 | GDR1O | Original Reference 1 | String | Generic Edit | 8 | 0 | Allow NULL? |
| 47 | GDOVDT | Date - Original Cleared/Value | Date | Generic Edit | 6 | 0 | |
| 48 | GDEXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 | Allow NULL? |
| 49 | GDDG | Date - For G/L (and Voucher) | Date | Generic Edit | 6 | 0 | |
| 50 | GDDMT | Date - Matching Check or Item | Date | Generic Edit | 6 | 0 | |
| 51 | GDPYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 52 | GDPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 53 | GDJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 54 | GDUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 55 | GDUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
