| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | ISUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 2 | ISJOBS | Job Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | ISITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | ISMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 5 | ISSEQ | Sequence Number | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 6 | ISUITM | Item Number - Unknown Format Entered | String | Generic Edit | 26 | 0 | Allow NULL? |
| 7 | ISANPL | Planner Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | ISPRP4 | Master Planning Family | String | UDC (41 P4) | 3 | 0 | Allow NULL? |
| 9 | ISMPST | Planning Code | Character | UDC (H41 MP) | 1 | 0 | Allow NULL? |
| 10 | ISVEND | Primary / Last Supplier Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 11 | ISBUYR | Buyer Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 12 | ISSAFE | Safety Stock | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 13 | ISPQOH | Quantity on Hand - Primary units | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 14 | ISUOM1 | Unit of Measure - Primary | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 15 | IS34XC01 | Message Type Count Column 01 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 16 | IS34XC02 | Message Type Count Column 02 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 17 | IS34XC03 | Message Type Count Column 03 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 18 | IS34XC04 | Message Type Count Column 04 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 19 | IS34XC05 | Message Type Count Column 05 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 20 | IS34XC06 | Message Type Count Column 06 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 21 | IS34XC07 | Message Type Count Column 07 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 22 | IS34XC08 | Message Type Count Column 08 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 23 | IS34XC09 | Message Type Count Column 09 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 24 | IS34XC10 | Message Type Count Column 10 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 25 | IS34XC11 | Message Type Count Column 11 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 26 | IS34XC12 | Message Type Count Column 12 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 27 | IS34XC13 | Message Type Count Column 13 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 28 | IS34XC14 | Message Type Count Column 14 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 29 | IS34XC15 | Message Type Count Column 15 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 30 | IS34XC16 | Message Type Count Column 16 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 31 | IS34XC17 | Message Type Count Column 17 | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 32 | ISSTKT | Stocking Type | Character | UDC (41 I) | 1 | 0 | Allow NULL? |
| 33 | IS34XDOSC | Current Days Of Supply | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 34 | IS34XDOS1 | Days Of Supply After 1st Receipt | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 35 | IS34XDOS2 | Days Of Supply After 2nd Receipt | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 36 | IS34XDOSS | Days Of Supply Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 37 | IS34XIOHS | Inventory On Hand Status | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 38 | IS34XDUR1 | Days Until First Receipt | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 39 | IS34XDUR2 | Days Until Second Receipt | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 40 | ISUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 41 | IS34XDAL1 | Inventory On Hand Alert | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 42 | IS34XDAL2 | Days Until 1st Receipt Alert | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 43 | IS34XDAL3 | Days Until 2nd Receipt Alert | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 44 | IS34XEANG | Ending Available Negative Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 45 | IS34XCNCD | Component Net Change in Demand | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 46 | IS34XLATN | Leadtime Alert | Integer | Generic Edit | 11 | 0 | Allow NULL? |