| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | WRC9ITM | Short Item Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | WREV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 3 | WRLITM | 2nd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 4 | WRAITM | 3rd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 5 | WRDSC1 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 6 | WRDSC2 | Description - Line 2 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 7 | WRSRTX | Search Text | String | Generic Edit | 30 | 0 | Allow NULL? |
| 8 | WRSTKT | Stocking Type | Character | UDC (41 I) | 1 | 0 | Allow NULL? |
| 9 | WRGLPT | Category - G/L | String | UDC (41 9) | 4 | 0 | Allow NULL? |
| 10 | WRLNTY | Line Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 11 | WRBPFG | Bulk/Packed Flag | Character | UDC (41B BF) | 1 | 0 | Allow NULL? |
| 12 | WRANPL | Planner Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 13 | WRBUYR | Buyer Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 14 | WRSRNR | Serial Number Required | Character | UDC (H41 NR) | 1 | 0 | Allow NULL? |
| 15 | WRBACK | Backorders Allowed (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | WRCKAV | Check Availability Y/N | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 17 | WRCLEV | Level - Inventory Cost | Character | UDC (H40 CL) | 1 | 0 | Allow NULL? |
| 18 | WRPLEV | Level - Sales Base Price | Character | UDC (H40 PL) | 1 | 0 | Allow NULL? |
| 19 | WRPPLV | Level - Purchase Price | Character | UDC (H40 PP) | 1 | 0 | Allow NULL? |
| 20 | WRPMTH | Method - Kit/Configurator Pricing | Character | UDC (H41 PM) | 1 | 0 | Allow NULL? |
| 21 | WRLOTS | Lot Status Code | Character | UDC (41 L) | 1 | 0 | Allow NULL? |
| 22 | WRSRCE | Layer Code - Source | Character | UDC (H41 SR) | 1 | 0 | Allow NULL? |
| 23 | WRCMGL | Commitment Method | Character | UDC (H40 CM) | 1 | 0 | Allow NULL? |
| 24 | WRINMG | Print Message | String | UDC (40 PM) | 10 | 0 | Allow NULL? |
| 25 | WRIFLA | Item Flash Message | String | UDC (40 FL) | 2 | 0 | Allow NULL? |
| 26 | WRTFLA | Standard Unit of Measure Conversion | String | UDC (H40 ST) | 2 | 0 | Allow NULL? |
| 27 | WRPRGR | Item Price Group | String | UDC (40 PI) | 8 | 0 | Allow NULL? |
| 28 | WRRPRC | Reprice (Basket Price) Category | String | UDC (40 PI) | 8 | 0 | Allow NULL? |
| 29 | WRORPR | Order Reprice Category | String | UDC (40 PI) | 8 | 0 | Allow NULL? |
| 30 | WRSLD | Days - Shelf Life Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 31 | WRDSGP | Dispatch Group | String | UDC (41B DG) | 3 | 0 | Allow NULL? |
| 32 | WRABCS | ABC Code 1 - Sales - Inventory | Character | UDC (H41 AB) | 1 | 0 | Allow NULL? |
| 33 | WRABCM | ABC Code 1 - Margin - Inventory | Character | UDC (H41 AB) | 1 | 0 | Allow NULL? |
| 34 | WRABCI | ABC Code 3 - Investment - Inventory | Character | UDC (H41 AB) | 1 | 0 | Allow NULL? |
| 35 | WRUOM1 | Unit of Measure - Primary | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 36 | WRUOM2 | Unit of Measure - Secondary | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 37 | WRUOM3 | Unit of Measure - Purchasing | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 38 | WRUOM4 | Unit of Measure - Pricing | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 39 | WRUOM6 | Unit of Measure - Shipping | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 40 | WRUOM8 | Unit of Measure - Production | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 41 | WRUOM9 | Unit of Measure - Component | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 42 | WRUWUM | Unit of Measure - Weight | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 43 | WRUVM1 | Unit of Measure - Volume | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 44 | WRCMETH | Method - Configurator Costing | Character | UDC (41 CM) | 1 | 0 | Allow NULL? |
| 45 | WRXDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 46 | WRDUAL | Dual Unit Of Measure Item | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 47 | WRDPPO | Dual Picking Process Option | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 48 | WRDLTL | Dual Tolerance | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 49 | WRCMDM | Commitment Date Method | Character | UDC (H40 CD) | 1 | 0 | Allow NULL? |
| 50 | WRLECM | Lot Expiraton Date Calculation Method | Character | UDC (H41 EC) | 1 | 0 | Allow NULL? |
| 51 | WRBBDD | Best Before Default Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 52 | WRSBDD | Sell By Default Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 53 | WRLEDD | Lot Effective Default Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 54 | WRPEFD | Purchasing Effective Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 55 | WRU1DD | User Lot Date 1 Default Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 56 | WRU2DD | User Lot Date 2 Default Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 57 | WRU3DD | User Lot Date 3 Default Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 58 | WRU4DD | User Lot Date 4 Default Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 59 | WRU5DD | User Lot Date 5 Default Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 60 | WRSCPSELL | Sellable Item | Character | UDC (34A SA) | 1 | 0 | Allow NULL? |
| 61 | WRAPSC | Constraints Flag | Character | UDC (42 AC) | 1 | 0 | Allow NULL? |
| 62 | WRCOORE | Country of Origin Required Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
