     RA_OpenRMAWrk                         RA Open RMA Work                Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: RA_OpenRMAReport_rpt
     SQL Def: Y  SysDB: N                                  "MAS_"+%C$+"/RA"+%C$+"/RA_OpenRMAWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
       2  GroupField. . . . . . . . . .    30 SNN  Group Field . . . . . . . . . .
       3  RMANo . . . . . . . . . . . .     7 SNN  RMA Number. . . . . . . . . . .
       4  RMADate . . . . . . . . . . .     8 SNN  RMA Date. . . . . . . . . . . .DATE
       5  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .
       6  ARDivisionDesc. . . . . . . .    30 SNN  AR Division Description . . . .
       7  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .
       8  RMAStatus . . . . . . . . . .     1 SNN  RMA Status. . . . . . . . . . .
       9  ExpireDate. . . . . . . . . .     8 SNN  Expire Date . . . . . . . . . .DATE
      10  BillToName. . . . . . . . . .    30 SNN  Bill To Name. . . . . . . . . .
      11  ReturnToAddressCode . . . . .     4 SNN  Return To Address Code. . . . .
      12  ReturnToName. . . . . . . . .    30 SNN  Return To Name. . . . . . . . .
      13  LineKey . . . . . . . . . . .     6 SNN  Line Key. . . . . . . . . . . .
      14  LineSeqNo . . . . . . . . . .    14 SNN  Line Sequence Number. . . . . .
      15  InvoiceNo . . . . . . . . . .     7 SNN  Invoice Number. . . . . . . . .
      16  HeaderSeqNo . . . . . . . . .     6 SNN  Header Sequence Number. . . . .
      17  DetailSeqNo . . . . . . . . .     6 SNN  Detail Sequence Number. . . . .
      18  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
      19  ItemType. . . . . . . . . . .     1 SNN  Item Type . . . . . . . . . . .
      20  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
      21  ReturnReasonCode. . . . . . .    10 SNN  Return Reason Code. . . . . . .
      22  CustomerAction. . . . . . . .     1 SNN  Customer Action . . . . . . . .
      23  ItemAction. . . . . . . . . .     1 SNN  Item Action . . . . . . . . . .
      24  WarehouseCode . . . . . . . .     3 SNN  Warehouse Code. . . . . . . . .
      25  ReplacementItemCode . . . . .    30 SNN  Replacement Item Code . . . . .
      26  ReplacementItemType . . . . .     1 SNN  Replacement Item Type . . . . .
      27  UnitOfMeasure . . . . . . . .     4 SNN  Unit Of Measure . . . . . . . .
      28  CrossShip . . . . . . . . . .     1 SNN  Cross Ship. . . . . . . . . . .
      29  WarrantyCode. . . . . . . . .    10 SNN  WarrantyCode. . . . . . . . . .
      30  ExpirationDate. . . . . . . .     8 SNN  Expiration Date . . . . . . . .DATE
      31  CostOfGoodsSoldAcctKey. . . .     9 SNN  Cost Of Goods Sold Account Key.
      32  CostOfGoodsSoldAccount. . . .    41 SNN  Fully Formatted Cost Of Goods S
      33  SalesAcctKey. . . . . . . . .     9 SNN  Sales Account Key . . . . . . .
      34  SalesAccount. . . . . . . . .    41 SNN  Fully Formatted Sales Account N
      35  HistoryCOGSAcctKey. . . . . .     9 SNN  History Cost Of Goods Sold Acct
      36  HistoryCOGSAccount. . . . . .    41 SNN  Fully Formatted History Cost Of
      37  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .
      38  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .
      39  SalespersonNo . . . . . . . .     4 SNN  Salesperson Number. . . . . . .
      40  VendorWarrantyCode. . . . . .    10 SNN  Vendor Warranty Code. . . . . .
      41  QuantityReturned. . . . . . . 16.6  NNN  Quantity Returned . . . . . . .
      42  QuantityReceived. . . . . . . 16.6  NNN  Quantity Received . . . . . . .
      43  InvoiceUnitPrice. . . . . . . 16.6  NNN  Invoice Unit Price. . . . . . .
      44  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .
      45  RestockingCharge. . . . . . . 11.3  NNN  Restocking Charge . . . . . . .