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