PO_AutoReorderSelection PO Auto Reorder Selection Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: N SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_AutoReorderSelection.M4T"
KPRIMARY: APDivisionNo+VendorNo+ItemCode+WarehouseCode KEXTENDEDDESC: ExtendedDescriptionKey+APDivisionNo+VendorNo+ItemCode+WarehouseCode
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL Notes: {PO8$(1,2)} 2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM ChngTag:Rep lace1/APDivisionNo$ Notes: {PO8$(3,7)} 3 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE Notes: {PO8$(10,15)} 4 ExtendedDescriptionKey. . . . 10 SNY Extended Description Key. . . .EXTDESCKEY Read Only:Y 5 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM Notes: {PO8$(30,3)} 6 ItemType. . . . . . . . . . . 1 SNY Item Type . . . . . . . . . . . Valid:1,2,3,4,5 Notes: 1=Inventory Item, 2=Special Item, 3=Charge Item, 4=Comment Item, 5=Miscellaneo us Item 7 ReorderMethod . . . . . . . . 1 SYN Reorder Method. . . . . . . . . Notes: {PO8$(53,1)} 8 VendorAliasItemNo . . . . . . 30 SNN Vendor Alias Item Number. . . . Notes: {PO8$(54,30)} 9 QuantityOnHand. . . . . . . . 16.6 NNN Quantity On Hand. . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: {PO8[0]} 10 QuantityOnPurchaseOrder . . . 16.6 NNN Quantity On Purchase Order. . .QUANTITY Mask:##,###,###.000000- Notes: {PO8[1]} 11 QuantityOnSalesOrder. . . . . 16.6 NNN Quantity On Sales Order . . . .QUANTITY Mask:##,###,###.000000- Notes: {PO8[2]} 12 QuantityOnBackOrder . . . . . 16.6 NNN Quantity On Back Order. . . . .QUANTITY Mask:##,###,###.000000- Notes: {PO8[3]} 13 QuantityOnWorkOrder . . . . . 16.6 NNN Quantity On Work Order. . . . .QUANTITY Mask:##,###,###.000000- Notes: {PO8[14]} 14 QuantityRequiredForWO . . . . 16.6 NNN Quantity Required for Work OrdeQUANTITY Mask:##,###,###.000000- Notes: {PO8[15]} 15 ReorderPointQty . . . . . . . 16.6 NNN Reorder Point Quantity. . . . .QUANTITY Mask:##,###,###.000000- Notes: {PO8[4]} 16 MinimumOrderQty . . . . . . . 16.6 NNN Minimum Order Quantity. . . . .QUANTITY Mask:##,###,###.000000- Notes: {PO8[5]} 17 EconomicOrderQty. . . . . . . 16.6 NNN Economic Order Quantity . . . .QUANTITY Mask:##,###,###.000000- Notes: {PO8[6]} 18 MaximumOnHandQty. . . . . . . 16.6 NNN Maximum On Hand Quantity. . . .QUANTITY Mask:##,###,###.000000- Notes: {PO8[7]} 19 RecommendedOrderQty . . . . . 16.6 NNN Recommended Order Quantity. . .QUANTITY Mask:##,###,###.000000- Notes: {PO8[8]} 20 QuantitySoldPTD . . . . . . . 16.6 NNN Quantity Sold Period To Date. .QUANTITY Mask:##,###,###.000000- Notes: {PO8[9]} 21 QuantitySoldYTD . . . . . . . 16.6 NNN Quantity Sold Year To Date. . .QUANTITY Mask:##,###,###.000000- Notes: {PO8[10]} 22 QuantitySoldPY. . . . . . . . 16.6 NNN Quantity Sold Prior Year. . . .QUANTITY Mask:##,###,###.000000- Notes: {PO8[11]} 23 QuantitySoldNP. . . . . . . . 16.6 NNN Quantity Sold Next Period . . .QUANTITY Mask:##,###,###.000000- Notes: {PO8[13]} 24 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Mask:##,###,###.000000- Notes: {PO8[12]} 25 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 26 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 27 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000