Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
ITEMNMBR | Item Number |
String | 32 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
REPLENISHMENTMETHOD | Replenishment Method 1 – Make |
Integer | 2 | View | |
PRIMVNDR | Primary Vendor |
String | 16 | View | |
PRCHSNGLDTM | Purchasing Lead Time |
Currency | 10 | View | |
MNFCTRNGFXDLDTM | Manufacturing Fixed Lead Time |
Currency | 10 | View | |
MNFCTRNGVRBLLDTM | Manufacturing Variable Lead Time |
Currency | 10 | View | |
MNMMORDRQTY | Minimum Order Qty |
Currency | 10 | View | |
MXMMORDRQTY | Maximum Order Qty |
Currency | 10 | View | |
ORDERMULTIPLE | Order Multiple |
Currency | 10 | View | |
FXDORDRQTY | Fixed Order Qty |
Currency | 10 | View | |
NMBROFDYS | Number of Days |
Integer | 2 | View | |
ORDRPNTQTY | Order Point Qty |
Currency | 10 | View | |
ORDRUPTOLVL | Order Up To Level |
Currency | 10 | View | |
SFTYSTCKQTY | Safety Stock Qty |
Currency | 10 | View | |
ORDERPOLICY | Order Policy 1 – Not planned |
Integer | 2 | View | |
SHRINKAGEFACTOR | Shrinkage Factor |
Currency | 10 | View | |
PLNNNGTMFNCDYS | Planning Time Fence Days |
Integer | 2 | View | |
PLANNERID | Planner ID |
String | 16 | View | |
BUYERID | Buyer ID |
String | 16 | View | |
MOVEIN | MoveIn |
Boolean | 2 | View | |
MOVEOUT | MoveOut |
Boolean | 2 | View | |
CANCELED | Cancelled |
Boolean | 2 | View | |
Move_Out_Fence | Move-Out Fence |
Integer | 2 | View |