| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | WBITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | WBMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 3 | WBEV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 4 | WBSTKT | Stocking Type | Character | UDC (41 I) | 1 | 0 | Allow NULL? |
| 5 | WBGLPT | Category - G/L | String | UDC (41 9) | 4 | 0 | Allow NULL? |
| 6 | WBLNTY | Line Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 7 | WBANPL | Planner Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | WBBUYR | Buyer Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 9 | WBVEND | Primary / Last Supplier Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 10 | WBINMG | Print Message | String | UDC (40 PM) | 10 | 0 | Allow NULL? |
| 11 | WBCMGL | Commitment Method | Character | UDC (H40 CM) | 1 | 0 | Allow NULL? |
| 12 | WBORIG | Country of Origin | String | UDC (00 CN) | 3 | 0 | Allow NULL? |
| 13 | WBTAX1 | Sales Taxable (Y/N) | Character | UDC (H00 TV) | 1 | 0 | Allow NULL? |
| 14 | WBTX | Purchasing Taxable (Y/N) | Character | UDC (H00 TV) | 1 | 0 | Allow NULL? |
| 15 | WBSRCE | Layer Code - Source | Character | UDC (H41 SR) | 1 | 0 | Allow NULL? |
| 16 | WBLOTS | Lot Status Code | Character | UDC (41 L) | 1 | 0 | Allow NULL? |
| 17 | WBSRNR | Serial Number Required | Character | UDC (H41 NR) | 1 | 0 | Allow NULL? |
| 18 | WBCKAV | Check Availability Y/N | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 19 | WBBACK | Backorders Allowed (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 20 | WBPRGR | Item Price Group | String | UDC (40 PI) | 8 | 0 | Allow NULL? |
| 21 | WBRPRC | Reprice (Basket Price) Category | String | UDC (40 PI) | 8 | 0 | Allow NULL? |
| 22 | WBORPR | Order Reprice Category | String | UDC (40 PI) | 8 | 0 | Allow NULL? |
| 23 | WBMMPC | Margin Maintenance (%) | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 24 | WBSLD | Days - Shelf Life Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 25 | WBABCS | ABC Code 1 - Sales - Inventory | Character | UDC (H41 AB) | 1 | 0 | Allow NULL? |
| 26 | WBABCM | ABC Code 1 - Margin - Inventory | Character | UDC (H41 AB) | 1 | 0 | Allow NULL? |
| 27 | WBABCI | ABC Code 3 - Investment - Inventory | Character | UDC (H41 AB) | 1 | 0 | Allow NULL? |
| 28 | WBSRP1 | Sales Catalog Section | String | UDC (41 S1) | 3 | 0 | Allow NULL? |
| 29 | WBSRP2 | Sub Section | String | UDC (41 S2) | 3 | 0 | Allow NULL? |
| 30 | WBSRP3 | Sales Category Code 3 | String | UDC (41 S3) | 3 | 0 | Allow NULL? |
| 31 | WBSRP4 | Sales Category Code 4 | String | UDC (41 S4) | 3 | 0 | Allow NULL? |
| 32 | WBSRP5 | Sales Category Code 5 | String | UDC (41 S5) | 3 | 0 | Allow NULL? |
| 33 | WBSRP6 | Category Code 6 | String | UDC (41 06) | 6 | 0 | Allow NULL? |
| 34 | WBSRP7 | Category Code 7 | String | UDC (41 07) | 6 | 0 | Allow NULL? |
| 35 | WBSRP8 | Category Code 8 | String | UDC (41 08) | 6 | 0 | Allow NULL? |
| 36 | WBSRP9 | Category Code 9 | String | UDC (41 09) | 6 | 0 | Allow NULL? |
| 37 | WBSRP0 | Category Code 10 | String | UDC (41 10) | 6 | 0 | Allow NULL? |
| 38 | WBCARS | Carrier Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 39 | WBCARP | Preferred Carrier - Purchasing | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 40 | WBSHCN | Shipping Conditions Code | String | UDC (41 C) | 3 | 0 | Allow NULL? |
| 41 | WBSHCM | Shipping Commodity Class | String | UDC (41 E) | 3 | 0 | Allow NULL? |
| 42 | WBCYCL | Cycle Count Category | String | UDC (41 8) | 3 | 0 | Allow NULL? |
| 43 | WBPRP1 | Commodity Class | String | UDC (41 P1) | 3 | 0 | Allow NULL? |
| 44 | WBPRP2 | Commodity Sub Class | String | UDC (41 P2) | 3 | 0 | Allow NULL? |
| 45 | WBPRP3 | Supplier Rebate Code | String | UDC (41 P3) | 3 | 0 | Allow NULL? |
| 46 | WBPRP4 | Master Planning Family | String | UDC (41 P4) | 3 | 0 | Allow NULL? |
| 47 | WBPRP5 | Purchasing Category Code 5 | String | UDC (41 P5) | 3 | 0 | Allow NULL? |
| 48 | WBPRP6 | Group - Item Dimension | String | UDC (41 01) | 6 | 0 | Allow NULL? |
| 49 | WBPRP7 | Group - Warehouse Process 1 | String | UDC (41 02) | 6 | 0 | Allow NULL? |
| 50 | WBPRP8 | Group - Warehouse Process 2 | String | UDC (41 02) | 6 | 0 | Allow NULL? |
| 51 | WBPRP9 | Group - Warehouse Process 3 | String | UDC (41 02) | 6 | 0 | Allow NULL? |
| 52 | WBPRP0 | Item Pool | String | UDC (41 05) | 6 | 0 | Allow NULL? |
| 53 | WBOPC | Order Policy Code | Character | UDC (H41 OP) | 1 | 0 | Allow NULL? |
| 54 | WBOPV | Value - Order Policy | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 55 | WBMPST | Planning Code | Character | UDC (H41 MP) | 1 | 0 | Allow NULL? |
| 56 | WBMPSP | Planning Time Fence Rule | Character | UDC (34 TF) | 1 | 0 | Allow NULL? |
| 57 | WBMTF1 | Planning Time Fence Days | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 58 | WBMTF2 | Freeze Time Fence Days | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 59 | WBMTF3 | Message Time Fence Days | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 60 | WBSETL | Setup Labor - Standard | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 61 | WBQUED | Queue Hours - Standard | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 62 | WBECO | ECO Number | String | Generic Edit | 12 | 0 | Allow NULL? |
| 63 | WBECTY | Engineering Change Reason | String | UDC (40 CR) | 2 | 0 | Allow NULL? |
| 64 | WBECOD | Date - Engineering Change Date | Date | Generic Edit | 6 | 0 | |
| 65 | WBPOC | Issue and Receipt | Character | UDC (43 IR) | 1 | 0 | Allow NULL? |
| 66 | WBAVRT | Replenishment Hours - Standard | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 67 | WBACQ | Quantity - Accounting Cost | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 68 | WBITC | Issue Type Code | Character | UDC (41 IT) | 1 | 0 | Allow NULL? |
| 69 | WBTIMB | Time Basis Code | Character | UDC (30 TB) | 1 | 0 | Allow NULL? |
| 70 | WBMERL | Item Revision Level | String | Generic Edit | 3 | 0 | Allow NULL? |
| 71 | WBSRNK | Shrink Factor | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 72 | WBSRKF | Shrink Factor Method | Character | UDC (H40 SR) | 1 | 0 | Allow NULL? |
| 73 | WBLTLV | Leadtime Level | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 74 | WBLTMF | Leadtime MFG | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 75 | WBLTCM | Leadtime Cumulative | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 76 | WBLTPU | Leadtime Per Unit | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 77 | WBMRPP | Fixed or Variable Leadtime | Character | UDC (H41 MS) | 1 | 0 | Allow NULL? |
| 78 | WBFRMP | From Potency | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 79 | WBMLQ | Quantity - MFG Leadtime | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 80 | WBOT1Y | Potency Control | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 81 | WBSTDP | Standard Potency | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 82 | WBTHRP | Thru Potency | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 83 | WBOT2Y | Grade Control | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 84 | WBSTDG | Standard Grade | String | UDC (40 LG) | 3 | 0 | Allow NULL? |
| 85 | WBFRGD | From Grade | String | UDC (40 LG) | 3 | 0 | Allow NULL? |
| 86 | WBTHGD | Thru Grade | String | UDC (40 LG) | 3 | 0 | Allow NULL? |
| 87 | WBPRODM | Product Model | String | UDC (17 PM) | 8 | 0 | Allow NULL? |
| 88 | WBPRODF | Product Family | String | UDC (17 PA) | 8 | 0 | Allow NULL? |
| 89 | WBMCUZ | Business Unit - Alt | String | Generic Edit | 12 | 0 | Allow NULL? |
| 90 | WBCCOST | S/WM Cost Component | String | UDC (30 CA) | 3 | 0 | Allow NULL? |
| 91 | WBRTRND | Returnable Flag | Character | UDC (17 TF) | 1 | 0 | Allow NULL? |
| 92 | WBRPRBL | Repairable Flag | Character | UDC (17 TF) | 1 | 0 | Allow NULL? |
| 93 | WBDCD1 | Disposition Code 1 | String | UDC (17 P1) | 3 | 0 | Allow NULL? |
| 94 | WBDCD2 | Disposition Code 2 | String | UDC (17 P2) | 3 | 0 | Allow NULL? |
| 95 | WBDCD3 | Disposition Code 3 | String | UDC (17 P3) | 3 | 0 | Allow NULL? |
| 96 | WBDCD4 | Disposition Code 4 | String | UDC (17 P4) | 3 | 0 | Allow NULL? |
| 97 | WBDCD5 | Disposition Code 5 | String | UDC (17 P5) | 3 | 0 | Allow NULL? |
| 98 | WBROQI | Reorder Quantity - Input | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 99 | WBRQMX | Reorder Quantity - Maximum | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 100 | WBRQMN | Reorder Quantity - Minimum | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 101 | WBROPI | Reorder Point - Input | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 102 | WBMULT | Quantity - Order Multiples (MRP) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 103 | WBUPC | Units - Per Container | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 104 | WBSAFE | Safety Stock | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 105 | WBAING | Active Ingredient Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 106 | WBBBDD | Best Before Default Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 107 | WBCMDM | Commitment Date Method | Character | UDC (H40 CD) | 1 | 0 | Allow NULL? |
| 108 | WBLECM | Lot Expiraton Date Calculation Method | Character | UDC (H41 EC) | 1 | 0 | Allow NULL? |
| 109 | WBLEDD | Lot Effective Default Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 110 | WBMLOT | Mix Dates / Lots (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 111 | WBPEFD | Purchasing Effective Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 112 | WBSBDD | Sell By Default Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 113 | WBU1DD | User Lot Date 1 Default Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 114 | WBU2DD | User Lot Date 2 Default Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 115 | WBU3DD | User Lot Date 3 Default Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 116 | WBU4DD | User Lot Date 4 Default Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 117 | WBU5DD | User Lot Date 5 Default Days | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 118 | WBXDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 119 | WBLAF | Lot Audit Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 120 | WBLTFM | Special Lot Format | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 121 | WBRWLA | Restrict Work Order Lot Assignment | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 122 | WBLNPA | Lot Number Pre-Assignment | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 123 | WBLOTC | Lot Status Code Expanded | String | Generic Edit | 3 | 0 | Allow NULL? |
| 124 | WBAPSC | Constraints Flag | Character | UDC (42 AC) | 1 | 0 | Allow NULL? |
| 125 | WBPRI1 | Priority One Alert Level | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 126 | WBPRI2 | Priority Two Alert Level | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 127 | WBLTCV | Leadtime Conversion Factor | Numeric | Generic Edit | 15 | 7 | Allow NULL? |
| 128 | WBASHL | Allow Shipping of Held Lots | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 129 | WBCOORE | Country of Origin Required Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
