PO_OpenOrderDetailByItem PO 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$+"/PO"+%C$+"/PO_OpenOrderDetailByItem.M4T"
KPRIMARY: RecordType+ItemCode+PurchaseOrderNo+LineKey KJOB: RecordType+JobNo+PurchaseOrderNo+LineKey KWORKORDER: RecordType+WorkOrderNo+PurchaseOrderNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 RecordType. . . . . . . . . . 1 SYN Record Type . . . . . . . . . . Valid:2,4 Notes: {POX$(1,1)} (2 = Sort By Item, 4 = Sort by Job/WO No.) 2 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . .JOBNO FmtType:CHARNUM Notes: {POX$(2,7)} (If JC Integrated = Y) 3 WorkOrderNo . . . . . . . . . 7 SNN Work Order Number . . . . . . .WORKORDERNO Notes: {POX$(2,7)} (If WO Itegrated = Y) 4 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 Notes: If RecordType = "2" {POX$(2, 15)}, If RecordType = "4" {POX$(9,15)} 5 PurchaseOrderNo . . . . . . . 7 SYN Purchase Order Number . . . . .PURCHASEORDERNO Notes: If RecordType = "2" {POX$(22,7)}, If RecordType = "4" {POX$(29,7)} 6 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . Notes: If RecordType = "2" {POX$(29,5)}, If RecordType = "4" {POX$(36,5)}