IM_ReorderReportWrk IM Reorder Report Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IM_ReorderReport_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_ReorderReportWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SYY Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 30 SNN Group Field . . . . . . . . . . 3 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 4 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 5 PurchaseUnitOfMeasure . . . . 4 SNN Purchase Unit Of Measure. . . . 6 StandardUnitOfMeasure . . . . 4 SNN Standard Unit Of Measure. . . . 7 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 8 ProductLineDesc . . . . . . . 25 SNN Product Line Description. . . . 9 ProductType . . . . . . . . . 1 SNN Product Type. . . . . . . . . . 10 PrimaryAPDivisionNo . . . . . 2 SNN Primary AP Division Number. . . 11 PrimaryVendorNo . . . . . . . 7 SNN Primary Vendor Number . . . . . 12 PrimaryVendorName . . . . . . 30 SNN Primary Vendor Name . . . . . . 13 LastReceiptDate . . . . . . . 8 SNN Last Receipt Date . . . . . . .DATE 14 Category1Desc . . . . . . . . 15 SNN Category 1 Description. . . . . 15 Category1 . . . . . . . . . . 10 SNN Category 1. . . . . . . . . . . 16 Category2Desc . . . . . . . . 15 SNN Category 2 Description. . . . . 17 Category2 . . . . . . . . . . 10 SNN Category 2. . . . . . . . . . . 18 Category3Desc . . . . . . . . 15 SNN Category 3 Description. . . . . 19 Category3 . . . . . . . . . . 10 SNN Category 3. . . . . . . . . . . 20 Category4Desc . . . . . . . . 15 SNN Category 4 Description. . . . . 21 Category4 . . . . . . . . . . 10 SNN Category 4. . . . . . . . . . . 22 InventoryCycle. . . . . . . . 1 SNN Inventory Cycle . . . . . . . . 23 VendorAliasItemNo . . . . . . 30 SNN Vendor Alias Item Number. . . . 24 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 25 WarehouseDesc . . . . . . . . 30 SNN Warehouse Description . . . . . 26 BinLocation . . . . . . . . . 10 SNN Bin Location. . . . . . . . . . 27 ReorderMethod . . . . . . . . 1 SNN Reorder Method. . . . . . . . . 28 LastTotalUnitCost . . . . . . 16.6 NNN Last Total Unit Cost. . . . . . Mask:########.000000- 29 PurchaseUMConvFctr. . . . . . 12.4 NNN Purchase Unit of Measure Conver 30 SalesUMConvFctr . . . . . . . 12.4 NNN Sales Unit of Measure Conversio 31 EconomicOrderQty. . . . . . . 16.6 NNN Economic Order Quantity . . . . Mask:########.000000- 32 ReorderPointQty . . . . . . . 16.6 NNN Reorder Point Quantity. . . . . Mask:########.000000- 33 MinimumOrderQty . . . . . . . 16.6 NNN Minimum Order Quantity. . . . . Mask:########.000000- 34 MaximumOnHandQty. . . . . . . 16.6 NNN Maximum On Hand Quantity. . . . 35 QuantityOnHand. . . . . . . . 16.6 NNN Quantity On Hand. . . . . . . . Mask:########.000000- 36 QuantityOnPurchaseOrder . . . 16.6 NNN Quantity On Purchase Order. . . 37 QuantityOnSalesOrder. . . . . 16.6 NNN QuantityOnSalesOrder. . . . . . 38 QuantityOnBackOrder . . . . . 16.6 NNN Quantity On Back Order. . . . . Mask:########.000000- 39 QuantityOnWorkOrder . . . . . 16.6 NNN Quantity On Work Order. . . . . 40 QuantityRequiredForWO . . . . 16.6 NNN Quantity Required For Work Orde Mask:########.000000- 41 QuantitySoldPTD . . . . . . . 16.6 NNN Quantity Sold Period To Date. . Mask:########.000000- 42 QuantitySoldYTD . . . . . . . 16.6 NNN Quantity Sold Year To Date. . . Mask:########.000000- 43 QuantitySoldPY. . . . . . . . 16.6 NNN Quantity Sold Prior Year. . . . Mask:########.000000-