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