| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | HCCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | HCMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 3 | HCOBJ | Object Account | String | Generic Edit | 6 | 0 | Allow NULL? |
| 4 | HCSUB | Subsidiary | String | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | HCDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 6 | HCDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 7 | HCSFXO | Order Suffix | String | Generic Edit | 3 | 0 | Allow NULL? |
| 8 | HCLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 9 | HCAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 10 | HCECST | Amount - Extended Cost | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 11 | HCAEXP | Amount - Extended Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | HCATXN | Amount - Non-Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | HCATXA | Amount - Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | HCSTAM | Amount - Tax | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | HCTXA1 | Tax Rate/Area | String | Generic Edit | 10 | 0 | Allow NULL? |
| 16 | HCEXR1 | Tax Expl Code 1 | String | UDC (00 EX) | 2 | 0 | Allow NULL? |
| 17 | HCEXR2 | Tax Expl Code 2 | String | UDC (00 EX) | 2 | 0 | Allow NULL? |
| 18 | HCTRDJ | Date - Order/Transaction | Date | Generic Edit | 6 | 0 | |
| 19 | HCDGL | Date - For G/L (and Voucher) | Date | Generic Edit | 6 | 0 | |
| 20 | HCDSVJ | Date - Service/Tax | Date | Generic Edit | 6 | 0 | |
| 21 | HCTX | Purchasing Taxable (Y/N) | Character | UDC (H00 TV) | 1 | 0 | Allow NULL? |
| 22 | HCITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 23 | HCLITM | 2nd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 24 | HCAITM | 3rd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 25 | HCLNTY | Line Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 26 | HCUORG | Units - Order/Transaction Quantity | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 27 | HCUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 28 | HCFVTY | Factor Value - Type | Character | UDC (H00 FV) | 1 | 0 | Allow NULL? |
| 29 | HCTA1 | Tax Authority | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 30 | HCTXR1 | Tax Rate 1 | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 31 | HCTA2 | Tax Authority 2 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 32 | HCTXR2 | Tax Rate 2 | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 33 | HCTA3 | Tax Authority 3 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 34 | HCTXR3 | Tax Rate 3 | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 35 | HCTA4 | Tax Authority 4 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 36 | HCTXR4 | Tax Rate 4 | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 37 | HCTA5 | Tax Authority 5 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 38 | HCTXR5 | Tax Rate 5 | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 39 | HCSTA1 | Amount - Sales Tax Tax Authority 1 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 40 | HCSTA2 | Amount - Sales Tax Tax Authority 2 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 41 | HCSTA3 | Amount - Sales Tax Tax Authority 3 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 42 | HCSTA4 | Amount - Sales Tax Tax Authority 4 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 43 | HCSTA5 | Amount - Sales Tax Tax Authority 5 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 44 | HCPRT1 | Print (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 45 | HCOVTX | Tax Override | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 46 | HCTXVA | Amount - Tax Variance | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 47 | HCTXVR | Tax Variance % | Numeric | Generic Edit | 15 | 3 | Allow NULL? |
| 48 | HCPOST | G/L Posted Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 49 | HCICU | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 50 | HCICUT | Batch Type | String | UDC (98 IT) | 2 | 0 | Allow NULL? |
| 51 | HCGDVL | Amount - Goods Value | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 52 | HCCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 53 | HCCRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 54 | HCSQNO | Number - Sequence | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 55 | HCAG | Amount - Gross | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 56 | HCUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 57 | HCUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 58 | HCPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 59 | HCUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 60 | HCJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 61 | HCAPD | Amount - Paid | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 62 | HCTAXE | Amount - Sales Tax Exempt | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 63 | HCDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 64 | HCKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 65 | HCITRG | VAT Register Type | String | UDC (74 02) | 2 | 0 | Allow NULL? |
| 66 | HCTCRG | VAT Register Class | String | UDC (74 01) | 2 | 0 | Allow NULL? |
| 67 | HCBCRC | Currency Code - Base | String | Generic Edit | 3 | 0 | Allow NULL? |
| 68 | HCNRTA | Non-Recoverable Tax Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
