| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | W2ICU | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | W2ICUA | Batch Number - Active | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | W2BCTY | Batch Type | Character | UDC (48 BT) | 1 | 0 | Allow NULL? |
| 4 | W2GTYP | Generation Type | Character | UDC (48 GT) | 1 | 0 | Allow NULL? |
| 5 | W2CRDB | Credit/Debit | Character | UDC (40 CG) | 1 | 0 | Allow NULL? |
| 6 | W2KCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 7 | W2CO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 8 | W2DGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 9 | W2PN | Period Number - General Ledger | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 10 | W2FY | Fiscal Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 11 | W2CTRY | Century | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 12 | W2DCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 13 | W2DOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 14 | W2SFX | Document Pay Item | String | Generic Edit | 3 | 0 | Allow NULL? |
| 15 | W2JELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 | Allow NULL? |
| 16 | W2MCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 17 | W2OBJ | Object Account | String | Generic Edit | 6 | 0 | Allow NULL? |
| 18 | W2SUB | Subsidiary | String | Generic Edit | 8 | 0 | Allow NULL? |
| 19 | W2SBL | Subledger - G/L | String | Generic Edit | 8 | 0 | Allow NULL? |
| 20 | W2SBLT | Subledger Type | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 21 | W2AID | Account ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 22 | W2AM | Account Mode - G/L | Character | UDC (H09 AM) | 1 | 0 | Allow NULL? |
| 23 | W2ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 | Allow NULL? |
| 24 | W2LT | Ledger Types | String | UDC (09 LT) | 2 | 0 | Allow NULL? |
| 25 | W2EXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 | Allow NULL? |
| 26 | W2EXR | Name - Remark Explanation | String | Generic Edit | 30 | 0 | Allow NULL? |
| 27 | W2GLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 28 | W2AN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 29 | W2ASID | Serial Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 30 | W2AA | Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 31 | W2ACR | Amount - Currency | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 32 | W2U | Units | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 33 | W2UM | Unit of Measure | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 34 | W2JTAX | Amount - Journaled Tax | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 35 | W2JTXF | Amount - Journaled Tax - Foreign | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 36 | W2AA1 | Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 37 | W2AA2 | Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 38 | W2CRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 39 | W2CRCE | Currency Code - Source | String | Generic Edit | 3 | 0 | Allow NULL? |
| 40 | W2CRCF | Currency Code - Origin | String | Generic Edit | 3 | 0 | Allow NULL? |
| 41 | W2ERDB | Date - Exchange Rate Date Basis | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 42 | W2CRRM | Currency Mode-Foreign or Domestic Entry | Character | UDC (H00 CY) | 1 | 0 | Allow NULL? |
| 43 | W2ERDT | Date - Exchange Rate | Date | Generic Edit | 6 | 0 | |
| 44 | W2CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 45 | W2CRRD | Currency Conversion Rate - Divisor | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 46 | W2EXR1 | Tax Expl Code 1 | String | UDC (00 EX) | 2 | 0 | Allow NULL? |
| 47 | W2WR01 | Categories - Work Order 01 | String | UDC (00 W1) | 4 | 0 | Allow NULL? |
| 48 | W2JBCD | Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 49 | W2JBST | Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 50 | W2HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 | Allow NULL? |
| 51 | W2JMCU | Business Unit - Host | String | Generic Edit | 12 | 0 | Allow NULL? |
| 52 | W2ANUM | Number - AAI Table Number | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 53 | W2TYKY | Key Type | Character | UDC (48 TY) | 1 | 0 | Allow NULL? |
| 54 | W2TKEY | Table Key | String | Generic Edit | 12 | 0 | Allow NULL? |
| 55 | W2TBDT | Date - Table Basis (Julian) | Date | Generic Edit | 6 | 0 | |
| 56 | W2AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 57 | W2DOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 58 | W2PCTN | Parent Contract Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 59 | W2COCH | Contract Change Number | String | Generic Edit | 3 | 0 | Allow NULL? |
| 60 | W2LNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 61 | W2MCUF | BU - From | String | Generic Edit | 12 | 0 | Allow NULL? |
| 62 | W2OBJF | Object Account From | String | Generic Edit | 6 | 0 | Allow NULL? |
| 63 | W2SUBSID | Subsidiary Account | String | Generic Edit | 8 | 0 | Allow NULL? |
| 64 | W2SBLC | Subledger - G/L Cost | String | Generic Edit | 8 | 0 | Allow NULL? |
| 65 | W2SBTC | Subledger Type - Cost | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 66 | W2WR07 | EnterpriseOne Consulting - Service Type | String | UDC (00 W7) | 3 | 0 | Allow NULL? |
| 67 | W2RP11 | Category Code - Business Unit 11 | String | UDC (00 11) | 3 | 0 | Allow NULL? |
| 68 | W2BCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 69 | W2DGL | Date - For G/L (and Voucher) | Date | Generic Edit | 6 | 0 | |
| 70 | W2PRSQ | Parent Sequence Number | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 71 | W2SBSQ | Sequence Number | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 72 | W2SCSQ | Secondary Sequence Number | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 73 | W2SLNK | Split Link | Numeric | Generic Edit | 11 | 0 | Allow NULL? |
| 74 | W2CLNK | Component Link | Numeric | Generic Edit | 11 | 0 | Allow NULL? |
| 75 | W2CCOD | Component Code | String | UDC (48 CM) | 5 | 0 | Allow NULL? |
| 76 | W2TCLS | Transaction Classification | Character | UDC (48 TC) | 1 | 0 | Allow NULL? |
| 77 | W2ELGC | Eligibility Code | Character | UDC (48 EL) | 1 | 0 | Allow NULL? |
| 78 | W2DSVJ | Date - Service/Tax | Date | Generic Edit | 6 | 0 | |
| 79 | W2PRTR | Transaction No. - Payroll | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 80 | W2PRTO | Original Transaction Number - Payroll | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 81 | W2UKID | Unique Key ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 82 | W2JOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 83 | W2PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 84 | W2USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 85 | W2UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 86 | W2UPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 87 | W2TXA1 | Tax Rate/Area | String | Generic Edit | 10 | 0 | Allow NULL? |
| 88 | W2TXITM | Tax - Short Item Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |