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