SO_OpenOrderDetailByItem SO Open Order Detail Sorted by Item Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_OpenOrderDetailByItem.M4T"
KPRIMARY: RecordType+ItemCode+SalesOrderNo+LineKey
KPROMISEDATE: RecordType+PromiseDate+SalesOrderNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 RecordType. . . . . . . . . . 1 SYY Record Type . . . . . . . . . .
Valid:2,4,6 Notes: 2=Open
Order by Item, 4=Open
Backorder by Item, 6=Open
Order by Promise Date
2 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE
ChngTag:Replace0
3 PromiseDate . . . . . . . . . 8 SYY Promise Date. . . . . . . . . .DATE
4 SalesOrderNo. . . . . . . . . 7 SYY Sales Order Number. . . . . . .SALESORDERNO
FmtType:CHARNUM
5 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . .
Mask:000000