     RA_CustomerInvoiceSearch               RA Customer Invoice Search     Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: SO_SalesJournal_upd
     SQL Def: Y  SysDB: N                              "MAS_"+%C$+"/RA"+%C$+"/RA_CustomerInvoiceSearch.M4T"

     KPRIMARY: ARDivisionNo+CustomerNo+ItemCode+InvoiceNo+HeaderSeqNo+DetailSeqNo
     KINVOICE: InvoiceNo+ARDivisionNo+CustomerNo+ItemCode+HeaderSeqNo+DetailSeqNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  ARDivisionNo. . . . . . . . .     2 SNY  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {RAS$(1,2)}
       2  CustomerNo. . . . . . . . . .    20 SYY  Customer Number . . . . . . . .CUSTOMERNO
                                                    FmtType:MASTERNUMC ChngTag:Re
                                                    place1/ARDivisionNo$ Notes:
                                                    {RAS$(3,7)}
       3  ItemCode. . . . . . . . . . .    30 SYN  Item Code . . . . . . . . . . .ITEMCODE
                                                    ChngTag:Replace0 Notes:
                                                    {RAS$(10,15)}
       4  ItemType. . . . . . . . . . .     1 SYN  Item Type . . . . . . . . . . .
                                                    Valid:1,2,3,5 Notes:
                                                    1=Regular Item, 2=Special
                                                    Item, 3=Charge Item,
                                                    4=Comment Item, 5=Miscellaneo
                                                    us Item
       5  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .DESCRIPTION
                                                    Notes: {RAS$(43,30)}
       6  InvoiceNo . . . . . . . . . .     7 SYN  Invoice Number. . . . . . . . .INVOICE
                                                    FmtType:MASTERNUM
       7  HeaderSeqNo . . . . . . . . .     6 SNN  Header Sequence Number. . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {RAS$(32,3)}
       8  DetailSeqNo . . . . . . . . .     6 SNN  Detail Sequence Number. . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {RAS$(35,5)}
       9  ModuleCode. . . . . . . . . .     3 SYN  Module Code . . . . . . . . . .MODULECODE
                                                    Notes: {RAS$(40,2)}
      10  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
                                                    Notes: {RAS$(73,6)}
      11  ShipDate. . . . . . . . . . .     8 SNN  Ship Date . . . . . . . . . . .DATE
                                                    Notes: {RAS$(79,6)}
      12  UnitOfMeasure . . . . . . . .     4 SYN  Unit Of Measure . . . . . . . .UNITOFMEASURE
                                                    Notes: {RAS$(85,4)}
      13  SalesOrderNo. . . . . . . . .     7 SYN  Sales Order Number. . . . . . .SALESORDERNO
                                                    FmtType:CHARNUM Notes:
                                                    {RAS$(89,7)}
      14  CustomerPONo. . . . . . . . .    15 SNN  Customer PO Number. . . . . . .CUSTOMERPONO
                                                    Notes: {RAS$(96,15)}
      15  QuantityShipped . . . . . . . 16.6  NNN  Quantity Shipped. . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {RAS[0]}