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)}