PO_AutomaticReorderSelectWrk PO Automatic Reorder Selection WorRel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_AutomaticReorderSelectWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 3 APDivisionDesc. . . . . . . . 30 SNN AP Division Description . . . . 4 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 5 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 6 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 7 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . . 8 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 9 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 10 ReorderMethod . . . . . . . . 1 SNN Reorder Method. . . . . . . . . 11 VendorAliasItemNo . . . . . . 30 SNN Vendor Alias Item Number. . . . 12 PurchaseUnitOfMeasure . . . . 4 SNN Purchase Unit Of Measure. . . . 13 StandardUnitOfMeasure . . . . 5 SNN Standard Unit Of Measure. . . . 14 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 15 ProductType . . . . . . . . . 1 SNN Product Type. . . . . . . . . . 16 LastReceiptDate . . . . . . . 8 SNN Last Receipt Date . . . . . . .DATE 17 LastTotalUnitCost . . . . . . 16.6 NNN Last Total Unit Cost. . . . . . 18 EconomicOrderQty. . . . . . . 16.6 NNN Economic Order Quantity . . . . 19 ReorderPointQty . . . . . . . 16.6 NNN Reorder Point Quantity. . . . . 20 MinimumOrderQty . . . . . . . 16.6 NNN Minimum Order Quantity. . . . . 21 MaximumOnHandQty. . . . . . . 16.6 NNN Maximum On Hand Quantity. . . . 22 QuantityOnHand. . . . . . . . 16.6 NNN Quantity On Hand. . . . . . . . 23 QuantityOnPurchaseOrder . . . 16.6 NNN Quantity On Purchase Order. . . 24 QuantityOnSalesOrder. . . . . 16.6 NNN Quantity On Sales Order . . . . 25 QuantityOnBackOrder . . . . . 16.6 NNN Quantity On Back Order. . . . . 26 QuantityOnWorkOrder . . . . . 16.6 NNN Quantity On Work Order. . . . . 27 QuantityRequiredForWO . . . . 16.6 NNN Quantity Required for Work Orde 28 QuantitySoldPTD . . . . . . . 16.6 NNN Quantity Sold Period To Date. . 29 QuantitySoldYTD . . . . . . . 16.6 NNN Quantity Sold Year To Date. . . 30 QuantitySoldPY. . . . . . . . 16.6 NNN Quantity Sold Prior Year. . . . 31 PurchaseQty . . . . . . . . . 16.6 NNN Purchase Quantity . . . . . . . 32 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .