| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | IMMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 2 | IMITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | IMSTAW | Status | Character | UDC (00 WS) | 1 | 0 | Allow NULL? |
| 4 | IMEFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 | |
| 5 | IMDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 6 | IMDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 7 | IMEFFF | Effective - From Date | Date | Generic Edit | 6 | 0 | |
| 8 | IMSERK | Key Value Serial Number | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 9 | IMNMFC | Freight Classification (NMFC) | String | UDC (49 BE) | 4 | 0 | Allow NULL? |
| 10 | IMNMFI | NMFC Item Number | String | Generic Edit | 6 | 0 | Allow NULL? |
| 11 | IMSTCC | Standard Transportation Commodity Code | String | Generic Edit | 10 | 0 | Allow NULL? |
| 12 | IMFRT1 | Freight Category Code 1 | String | UDC (49 CJ) | 6 | 0 | Allow NULL? |
| 13 | IMFRT2 | Freight Category Code 2 | String | UDC (49 CK) | 6 | 0 | Allow NULL? |
| 14 | IMHSCD | Harmonized Shipping Code | String | Generic Edit | 12 | 0 | Allow NULL? |
| 15 | IMPDCG | Producer of Goods | String | UDC (49 BV) | 4 | 0 | Allow NULL? |
| 16 | IMPFCT | Preference Criteria | Character | UDC (49 BU) | 1 | 0 | Allow NULL? |
| 17 | IMECCN | Export Control Commodity Number | String | Generic Edit | 10 | 0 | Allow NULL? |
| 18 | IMDMFR | Domestic/Foreign Commodity | Character | UDC (49 BW) | 1 | 0 | Allow NULL? |
| 19 | IMUNNA | UN or NA Number | String | Generic Edit | 6 | 0 | Allow NULL? |
| 20 | IMHZDC | Hazard Class or Division | String | UDC (49 BX) | 3 | 0 | Allow NULL? |
| 21 | IMHZDL | Hazard Label | String | UDC (49 CC) | 3 | 0 | Allow NULL? |
| 22 | IMFPNT | Flash Point Temperature | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 23 | IMSTPU | Temperature Type | Character | UDC (41B TP) | 1 | 0 | Allow NULL? |
| 24 | IMPKGP | Packaging Group | String | UDC (49 BY) | 3 | 0 | Allow NULL? |
| 25 | IMPKIN | Packaging Instructions | String | UDC (49 CB) | 4 | 0 | Allow NULL? |
| 26 | IMSRSK | Subsidiary Risk | String | UDC (49 BZ) | 3 | 0 | Allow NULL? |
| 27 | IMUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 28 | IMPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 29 | IMJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 30 | IMUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 31 | IMTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |