| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | W4DOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | W4DCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 3 | W4KCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 4 | W4PCTN | Parent Contract Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | W4PCTT | Parent Contract Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 6 | W4PCKO | Parent Contract Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 7 | W4APPL | Application Number | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 8 | W4ADJN | Adjustment Number | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 9 | W4COCH | Contract Change Number | String | Generic Edit | 3 | 0 | Allow NULL? |
| 10 | W4LNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 11 | W4OPIM | Owner Pay Item | String | Generic Edit | 15 | 0 | Allow NULL? |
| 12 | W4PRTP | Pricing Type - Contracts | Character | UDC (52 PT) | 1 | 0 | Allow NULL? |
| 13 | W4BLSP | Bill Suspend | Character | UDC (52 BS) | 1 | 0 | Allow NULL? |
| 14 | W4AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 15 | W4AN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 16 | W4PTC | Payment Terms Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 17 | W4CO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 18 | W4MCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 19 | W4SBL | Subledger - G/L | String | Generic Edit | 8 | 0 | Allow NULL? |
| 20 | W4SBLT | Subledger Type | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 21 | W4GLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 22 | W4BTFR | Date - Bill From | Date | Generic Edit | 6 | 0 | |
| 23 | W4BTDT | Billed Through | Date | Generic Edit | 6 | 0 | |
| 24 | W4DGL | Date - For G/L (and Voucher) | Date | Generic Edit | 6 | 0 | |
| 25 | W4DDJ | Date - Net Due | Date | Generic Edit | 6 | 0 | |
| 26 | W4DSVJ | Date - Service/Tax | Date | Generic Edit | 6 | 0 | |
| 27 | W4ICU | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 28 | W4DOCZ | Document (Order # Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 29 | W4DCTI | Document Type - Invoice Only | String | UDC (00 DI) | 2 | 0 | Allow NULL? |
| 30 | W4KCOI | Document Company (Invoice) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 31 | W4SFX | Document Pay Item | String | Generic Edit | 3 | 0 | Allow NULL? |
| 32 | W4APDT | Application Date | Date | Generic Edit | 6 | 0 | |
| 33 | W4APPO | Application Posted Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 34 | W4VOID | Void (V) | Character | UDC (H09 VO) | 1 | 0 | Allow NULL? |
| 35 | W4INVF | Invoice Format Code | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | W4INTY | Invoice Type | Character | UDC (48 IT) | 1 | 0 | Allow NULL? |
| 37 | W4U | Units | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 38 | W4UM | Unit of Measure | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 39 | W4UP | Amount - Price per Unit | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 40 | W4FUP | Amount - Foreign Price per Unit | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 41 | W4PUHP | Previous Billed This Period - Units | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 42 | W4AA | Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 43 | W4ACR | Amount - Currency | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 44 | W4THPD | This Period | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 45 | W4FHPD | This Period - Foreign | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 46 | W4RTHP | This Period - Restated | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 47 | W4PTHP | Previous Billed This Period | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 48 | W4FTHP | Previous Billed This Period - Foreign | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 49 | W4TXA1 | Tax Rate/Area | String | Generic Edit | 10 | 0 | Allow NULL? |
| 50 | W4EXR1 | Tax Expl Code 1 | String | UDC (00 EX) | 2 | 0 | Allow NULL? |
| 51 | W4STAM | Amount - Tax | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 52 | W4CTAM | Amount - Foreign Tax | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 53 | W4PTAM | Amount - Tax - Prior | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 54 | W4FPTA | Amount - Tax - Prior - Foreign | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 55 | W4ATXA | Amount - Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 56 | W4CTXA | Amount - Foreign Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 57 | W4PATX | Amount - Taxable - Previous | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 58 | W4FATX | Amount - Taxable - Previous Foreign | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 59 | W4ATXN | Amount - Non-Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 60 | W4CTXN | Amount - Foreign Non-Taxable | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 61 | W4RTRE | Retainage Release Only | Character | UDC (48 RR) | 1 | 0 | Allow NULL? |
| 62 | W4RGLC | Retention G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 63 | W4PRET | Percent Retainage | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 64 | W4RTNR | Retainage Rule | String | Generic Edit | 3 | 0 | Allow NULL? |
| 65 | W4RCTL | Retainage Control Flag | Character | UDC (48S RC) | 1 | 0 | Allow NULL? |
| 66 | W4RTNG | Retainage | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 67 | W4FTNG | Retainage - Foreign | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 68 | W4RTNP | Retainage - Prior | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 69 | W4FTNP | Retainage - Prior - Foreign | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 70 | W4DDTR | Deferred Tax - Domestic | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 71 | W4FDTR | Deferred Tax - Foreign | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 72 | W4STML | Accrual/Deferral (Stored Materials) | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 73 | W4FTML | Acc/Def (Stored Materials) - Foreign | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 74 | W4PSMA | Previous Billed Stored Material | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 75 | W4FSMA | Prev. Billed Stored Material - Foreign | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 76 | W4RTN1 | Retainage Rule - Stored Material | String | Generic Edit | 3 | 0 | Allow NULL? |
| 77 | W4SMRT | Stored Materials Retainage | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 78 | W4SMRF | Stored Materials Retainage - Foreign | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 79 | W4SMRP | Stored Materials Retainage - Prior Amt | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 80 | W4SMPF | Stored Materials Retainage - Prior-For | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 81 | W4TLAB | Amount - Total Labor | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 82 | W4FLAB | Amount - Foreign Total Labor | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 83 | W4TBUR | Amount - Total Burden | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 84 | W4FBUR | Amount - Foreign Total Burden | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 85 | W4ADSC | Discount Available | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 86 | W4CDS | Amount - Foreign Discount Available | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 87 | W4CRRM | Currency Mode-Foreign or Domestic Entry | Character | UDC (H00 CY) | 1 | 0 | Allow NULL? |
| 88 | W4CRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 89 | W4CRCF | Currency Code - Origin | String | Generic Edit | 3 | 0 | Allow NULL? |
| 90 | W4CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 91 | W4CRRD | Currency Conversion Rate - Divisor | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 92 | W4RMK | Name - Remark | String | Generic Edit | 30 | 0 | Allow NULL? |
| 93 | W4MIVL | Mode of Input - Values | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 94 | W4MISM | Mode of Input - SM | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 95 | W4PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 96 | W4JOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 97 | W4USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 98 | W4MUPM | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 99 | W4UPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 100 | W4VGCSF | GeoCode Ship From | String | Generic Edit | 10 | 0 | Allow NULL? |
| 101 | W4VGCOA | GeoCode Order Accept | String | Generic Edit | 10 | 0 | Allow NULL? |
| 102 | W4VVTY | Vertex Transaction Type | String | UDC (73 TY) | 6 | 0 | Allow NULL? |
| 103 | W4VVTC | Vertex Product Category | String | UDC (73 PC) | 10 | 0 | Allow NULL? |
| 104 | W4PYWP | Pay When Paid | Character | Generic Edit | 1 | 0 | Allow NULL? |