| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | W1KCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | W1DCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 3 | W1DOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | W1LNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 5 | W1SY | Product Code | String | UDC (98 SY) | 4 | 0 | Allow NULL? |
| 6 | W1VOID | Void (V) | Character | UDC (H09 VO) | 1 | 0 | Allow NULL? |
| 7 | W1K74LECO | Legal Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 8 | W1DIVJ | Date - Invoice - Julian | Date | Generic Edit | 6 | 0 | |
| 9 | W1VINV | Supplier Invoice Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 10 | W1R74ADNU | Adjustment Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 11 | W1R74ADDT | Adjustment Date | Date | Generic Edit | 6 | 0 | |
| 12 | W1R74CONU | Correction Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 13 | W1R74CODJ | Correction Date | Date | Generic Edit | 6 | 0 | |
| 14 | W1R74ACNU | Adjustment of Correction Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 15 | W1R74ACDJ | Adjustment of Correction Date | Date | Generic Edit | 6 | 0 | |
| 16 | W1DMTJ | Date - Matching Check or Item - Julian | Date | Generic Edit | 6 | 0 | |
| 17 | W1RCDJ | Date - Received | Date | Generic Edit | 6 | 0 | |
| 18 | W1K74LMN | Long Mailing Name | String | Generic Edit | 100 | 0 | Allow NULL? |
| 19 | W1TAX | Tax ID | String | Generic Edit | 20 | 0 | Allow NULL? |
| 20 | W1R74KPP | KPP Code | String | Generic Edit | 15 | 0 | Allow NULL? |
| 21 | W1AEXP | Amount - Extended Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 22 | W1MATH01 | Math Numeric 01 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 23 | W1STA1 | Amount - Sales Tax Tax Authority 1 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 24 | W1MATH02 | Math Numeric 02 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 25 | W1STA2 | Amount - Sales Tax Tax Authority 2 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 26 | W1ATXA | Amount - Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 27 | W1MATH04 | Math Numeric 04 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 28 | W1STA4 | Amount - Sales Tax Tax Authority 4 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 29 | W1ATXN | Amount - Non-Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 30 | W1MATH05 | Math Numeric 05 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 31 | W1STA5 | Amount - Sales Tax Tax Authority 5 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 32 | W1EV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 33 | W1EV02 | J.D. EnterpriseOne Event Point 02 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 34 | W1RPD | Date - Report | Date | Generic Edit | 6 | 0 | |
| 35 | W1JOBS | Job Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 36 | W1CTID | Computer ID | String | Generic Edit | 15 | 0 | Allow NULL? |
| 37 | W1PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 38 | W1USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 39 | W1UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 40 | W1UPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |