| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | SGBDID | Begin Doc Unique ID | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 2 | SGGBJN | G Batch Job Number | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 3 | SGICU | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | SGICUT | Batch Type | String | UDC (98 IT) | 2 | 0 | Allow NULL? |
| 5 | SGIST | Batch Status | Character | UDC (98 IC) | 1 | 0 | Allow NULL? |
| 6 | SGDACN | Doc Action Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 7 | SGEIFL | Edit Instruction Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 8 | SGUKERRO | Error Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 9 | SGGBTF | G Batch Type Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | SGLLNM | Last Line Number | Numeric | Generic Edit | 7 | 0 | Allow NULL? |
| 11 | SGKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 12 | SGDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 13 | SGDOCGB | G Batch Document Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 14 | SGDGL | Date - For G/L (and Voucher) | Date | Generic Edit | 6 | 0 | |
| 15 | SGLT | Ledger Types | String | UDC (09 LT) | 2 | 0 | Allow NULL? |
| 16 | SGDICJ | Date - Batch (Julian) | Date | Generic Edit | 6 | 0 | |
| 17 | SGDSYJ | Date - Batch System Date | Date | Generic Edit | 6 | 0 | |
| 18 | SGTICU | Batch Time | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 19 | SGCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 20 | SGCRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 21 | SGEXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 | Allow NULL? |
| 22 | SGR1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 | Allow NULL? |
| 23 | SGHMCU | Business Unit - Home | String | Generic Edit | 12 | 0 | Allow NULL? |
| 24 | SGGINV | Invoice Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 25 | SGIVD | Date - Invoice | Date | Generic Edit | 6 | 0 | |
| 26 | SGRE | Reverse or Void (R/V) | Character | UDC (H09 RE) | 1 | 0 | Allow NULL? |
| 27 | SGHDGJ | Historical Date - Julian | Date | Generic Edit | 6 | 0 | |
| 28 | SGCRRM | Currency Mode-Foreign or Domestic Entry | Character | UDC (H00 CY) | 1 | 0 | Allow NULL? |
| 29 | SGCRDC | Currency Code - To | String | Generic Edit | 3 | 0 | Allow NULL? |
| 30 | SGDOT1 | Allow Multi-Currency Intercompany Trans. | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 31 | SGATAD | Amount - To Distribute | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 32 | SGCTAD | Amount - Currency To Distribute | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 33 | SGCRYR | Currency Conversion Y/N/Z | Character | UDC (H00 CR) | 1 | 0 | Allow NULL? |
| 34 | SGHCFL | Header Changed Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 35 | SGMDFL | Model Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 36 | SGJEVER | JE Version | String | Generic Edit | 10 | 0 | Allow NULL? |
| 37 | SGERDFL | Exchange Rate Date Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 38 | SGPYIN | Payment Instrument | Character | UDC (00 PY) | 1 | 0 | Allow NULL? |
| 39 | SGCHTT | Config Hub Transaction Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 40 | SGCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 41 | SGUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 42 | SGPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 43 | SGUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 44 | SGTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 45 | SGJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 46 | SGHCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
