| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | WSITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | WSEV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 3 | WSHSCD | Harmonized Shipping Code | String | Generic Edit | 12 | 0 | Allow NULL? |
| 4 | WSPDCG | Producer of Goods | String | UDC (49 BV) | 4 | 0 | Allow NULL? |
| 5 | WSPFCT | Preference Criteria | Character | UDC (49 BU) | 1 | 0 | Allow NULL? |
| 6 | WSDMFR | Domestic/Foreign Commodity | Character | UDC (49 BW) | 1 | 0 | Allow NULL? |
| 7 | WSECCN | Export Control Commodity Number | String | Generic Edit | 10 | 0 | Allow NULL? |
| 8 | WSUNNA | UN or NA Number | String | Generic Edit | 6 | 0 | Allow NULL? |
| 9 | WSHZDC | Hazard Class or Division | String | UDC (49 BX) | 3 | 0 | Allow NULL? |
| 10 | WSPKGP | Packaging Group | String | UDC (49 BY) | 3 | 0 | Allow NULL? |
| 11 | WSSRSK | Subsidiary Risk | String | UDC (49 BZ) | 3 | 0 | Allow NULL? |
| 12 | WSFPNT | Flash Point Temperature | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 13 | WSSTPU | Temperature Type | Character | UDC (41B TP) | 1 | 0 | Allow NULL? |
| 14 | WSPKIN | Packaging Instructions | String | UDC (49 CB) | 4 | 0 | Allow NULL? |
| 15 | WSHZDL | Hazard Label | String | UDC (49 CC) | 3 | 0 | Allow NULL? |
| 16 | WSNMFI | NMFC Item Number | String | Generic Edit | 6 | 0 | Allow NULL? |
| 17 | WSNMFC | Freight Classification (NMFC) | String | UDC (49 BE) | 4 | 0 | Allow NULL? |
| 18 | WSSTCC | Standard Transportation Commodity Code | String | Generic Edit | 10 | 0 | Allow NULL? |
| 19 | WSFRT1 | Freight Category Code 1 | String | UDC (49 CJ) | 6 | 0 | Allow NULL? |
| 20 | WSFRT2 | Freight Category Code 2 | String | UDC (49 CK) | 6 | 0 | Allow NULL? |
| 21 | WSUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 22 | WSPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | WSJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | WSUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 25 | WSTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |