| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | ABKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | ABDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | ABDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 4 | ABLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 5 | ABKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 6 | ABDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 7 | ABDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 8 | ABCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 9 | ABAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 10 | ABMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 11 | ABAREC | Amount - Received | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | ABAPTD | Amount - Paid to Date | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | ABLOTN | Lot/Serial Number | String | Generic Edit | 30 | 0 | Allow NULL? |
| 14 | ABUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 15 | ABPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 16 | ABUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 17 | ABQTYS | Units - Stocked | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | ABSOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | ABJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 20 | ABUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 21 | ABLITM | 2nd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 22 | ABTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | ABADSO | Origin State | String | UDC (00 S) | 3 | 0 | Allow NULL? |
| 24 | ABLOCN | Location | String | Generic Edit | 20 | 0 | Allow NULL? |
| 25 | ABVSFST | Ship From State | String | Generic Edit | 3 | 0 | Allow NULL? |
| 26 | ABIVD | Date - Invoice | Date | Generic Edit | 6 | 0 | |
| 27 | ABAEXP | Amount - Extended Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 28 | ABDGL | Date - For G/L (and Voucher) | Date | Generic Edit | 6 | 0 | |
| 29 | ABDCT1 | Close Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 30 | ABAG | Amount - Gross | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 31 | ABTRDJ | Date - Order/Transaction | Date | Generic Edit | 6 | 0 | |
| 32 | ABLNIX | Line Number - X-REF | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 33 | ABDOC1 | Document (Order # Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 34 | ABPCST | Percent - Cost Add-On | Numeric | Generic Edit | 15 | 7 | Allow NULL? |
| 35 | ABADDS | State | String | UDC (00 S) | 3 | 0 | Allow NULL? |
| 36 | ABMCU1 | Parent Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 37 | ABQTYW | Units - Reworked | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
