PO_AutoGenerateOrders PO Auto Generate Orders Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: N SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_AutoGenerateOrders.M4T"
KPRIMARY: ShipFlag+APDivisionNo+VendorNo+ItemCode+ExtendedDescriptionKey+WarehouseCode+SalesOrderNo+Sal esOrderLineKey KEXTENDEDDESC: ExtendedDescriptionKey+ShipFlag+APDivisionNo+VendorNo+ItemCode+WarehouseCode+SalesOrderN o+SalesOrderLineKey
Fld Column Name M/L TUR Description/Notes Class
1 ShipFlag. . . . . . . . . . . 1 SYY Ship Flag . . . . . . . . . . . Notes: {PO_01$(1,1)} D=Drop Ship," "=Standard 2 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL Notes: {PO_01$(2,2)} 3 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM ChngTag:Rep lace1/APDivisionNo$ Notes: {PO_01$(4,7)} 4 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30 5 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE Notes: {PO_01$(11,15)} 6 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . .EXTDESCKEY Read Only:Y 7 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM Notes: {PO_01$(31,3)} 8 SalesOrderNo. . . . . . . . . 7 SYN Sales Order Number. . . . . . .SALESORDERNO Notes: {PO_01$(34,7)} 9 SalesOrderLineKey . . . . . . 6 SNN Sales Order Line Key. . . . . . Mask:000000 Notes: {PO_01$(41 ,5)} From SO_SalesOrderDetail 10 ItemType. . . . . . . . . . . 1 SYY 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 11 QuantityOrderedSO . . . . . . 16.6 NNN Quantity Ordered Sales Order. .QUANTITY Mask:##,###,###.000000- Notes: {PO_01[0]} 12 QuantityOrderedPO . . . . . . 16.6 NNN Quantity Ordered Purchase OrderQUANTITY Mask:##,###,###.000000- Notes: {PO_01[1]} 13 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Mask:##,###,###.000000- Notes: {PO_01[2]} 14 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 15 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 16 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000