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