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