     RA_ReceiptsHistoryWrk                 RA Receipts History Work        Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: RA_ReceiptsHistoryReport_rpt
     SQL Def: Y  SysDB: N                          "MAS_"+%C$+"/RA"+%C$+"/RA_ReceiptsHistoryWrk"+%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  ReceiptSeqNo. . . . . . . . .     6 SNN  Receipt Sequence Number . . . .
       5  RMADate . . . . . . . . . . .     8 SNN  RMA Date. . . . . . . . . . . .DATE
       6  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .
       7  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .
       8  ConfirmTo . . . . . . . . . .    30 SNN  Confirm To. . . . . . . . . . .
       9  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .
      10  CrossShip . . . . . . . . . .     1 SNN  Cross Ship. . . . . . . . . . .
      11  BillToName. . . . . . . . . .    30 SNN  Bill To Name. . . . . . . . . .
      12  BillToAddress1. . . . . . . .    30 SNN  Bill To Address 1 . . . . . . .
      13  BillToAddress2. . . . . . . .    30 SNN  Bill To Address 2 . . . . . . .
      14  BillToAddress3. . . . . . . .    30 SNN  Bill To Address 3 . . . . . . .
      15  BillToCity. . . . . . . . . .    20 SNN  Bill To City. . . . . . . . . .
      16  BillToState . . . . . . . . .     2 SNN  Bill To State . . . . . . . . .
      17  BillToZipCode . . . . . . . .    10 SNN  Bill To Zip Code. . . . . . . .
      18  BillToCountryCode . . . . . .     3 SNN  Bill To Country Code. . . . . .
      19  BillToCountryName . . . . . .    30 SNN  Bill To Country Name. . . . . .
      20  ShipToName. . . . . . . . . .    30 SNN  ShipToName. . . . . . . . . . .
      21  ShipToAddress1. . . . . . . .    30 SNN  Ship To Address 1 . . . . . . .
      22  ShipToAddress2. . . . . . . .    30 SNN  Ship To Address 2 . . . . . . .
      23  ShipToAddress3. . . . . . . .    30 SNN  Ship To Address 3 . . . . . . .
      24  ShipToCity. . . . . . . . . .    20 SNN  Ship To City. . . . . . . . . .
      25  ShipToState . . . . . . . . .     2 SNN  Ship To State . . . . . . . . .
      26  ShipToZipCode . . . . . . . .    10 SNN  Ship To Zip Code. . . . . . . .
      27  ShipToCountryCode . . . . . .     3 SNN  Ship To Country Code. . . . . .
      28  ShipToCountryName . . . . . .    30 SNN  Ship To Country Name. . . . . .
      29  ReturnShipVia . . . . . . . .    15 SNN  Return Ship Via . . . . . . . .
      30  ReturnToAddressCode . . . . .     4 SNN  Return To Address Code. . . . .
      31  ReturnToName. . . . . . . . .    30 SNN  Return To Name. . . . . . . . .
      32  ReturnToAddress1. . . . . . .    30 SNN  Return To Address 1 . . . . . .
      33  ReturnToAddress2. . . . . . .    30 SNN  Return To Address 2 . . . . . .
      34  ReturnToAddress3. . . . . . .    30 SNN  Return To Address 3 . . . . . .
      35  ReturnToCity. . . . . . . . .    20 SNN  Return To City. . . . . . . . .
      36  ReturnToState . . . . . . . .     2 SNN  Return To State . . . . . . . .
      37  ReturnToZipCode . . . . . . .    10 SNN  Return To Zip Code. . . . . . .
      38  ReturnToCountryCode . . . . .     3 SNN  Return To Country Code. . . . .
      39  ReturnToCountryName . . . . .    30 SNN  Return To Country Name. . . . .
      40  ReceiptDate . . . . . . . . .     8 SNN  Receipt Date. . . . . . . . . .DATE
      41  ReceiptDetailSeqNo. . . . . .     6 SNN  Receipt Detail Sequence Number.
                                                    Mask:000000
      42  InvoiceNo . . . . . . . . . .     7 SNN  Invoice No. . . . . . . . . . .
      43  HeaderSeqNo . . . . . . . . .     6 SNN  Header Sequence Number. . . . .
      44  DetailSeqNo . . . . . . . . .     6 SNN  Detail Sequence Number. . . . .
      45  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
      46  ItemType. . . . . . . . . . .     1 SNN  Item Type . . . . . . . . . . .
      47  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
      48  CustomerAction. . . . . . . .     1 SNN  Customer Action . . . . . . . .
      49  ItemAction. . . . . . . . . .     1 SNN  Item Action . . . . . . . . . .
      50  WarehouseCode . . . . . . . .     3 SNN  Warehouse Code. . . . . . . . .
      51  ReplacementItemCode . . . . .    30 SNN  Replacement Item Code . . . . .
      52  ReplacementItemType . . . . .     1 SNN  Replacement Item Type . . . . .
      53  VendorAction. . . . . . . . .     1 SNN  Vendor Action . . . . . . . . .
      54  ReturnReasonCode. . . . . . .    10 SNN  Return Reason Code. . . . . . .
      55  UnitOfMeasure . . . . . . . .     4 SNN  Unit Of Measure . . . . . . . .
      56  DropShip. . . . . . . . . . .     1 SNN  Drop Ship . . . . . . . . . . .
      57  CrossShipItem . . . . . . . .     1 SNN  Cross Ship Item . . . . . . . .
      58  WarrantyCode. . . . . . . . .    10 SNN  Warranty Code . . . . . . . . .
      59  ExpirationDate. . . . . . . .     8 SNN  Expiration Date . . . . . . . .DATE
      60  SalesOrderNo. . . . . . . . .     7 SNN  Sales Order Number. . . . . . .
      61  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .
      62  XpressGeneratedSONo . . . . .     7 SNN  Xpress/Generated SO Number. . .
      63  GeneratedCMInvoiceNo. . . . .     7 SNN  Generated CM Invoice Number . .
      64  GeneratedPurchaseOrderNo. . .     7 SNN  Generated Purchase Order Number
      65  GeneratedPOReturnNo . . . . .     7 SNN  Generated PO Return Number. . .
      66  CostOfGoodsSoldAcctKey. . . .     9 SNN  Cost Of Goods Sold Account Key.
      67  CostOfGoodsSoldAccount. . . .    41 SNN  Fully Formatted Cost Of Goods S
      68  SalesAcctKey. . . . . . . . .     9 SNN  Sales Account Key . . . . . . .
      69  SalesAccount. . . . . . . . .    41 SNN  Fully Formatted Sales Account N
      70  LotSerialNo . . . . . . . . .    15 SNN  Lot Serial Number . . . . . . .
      71  TierType. . . . . . . . . . .     1 SNN  Tier Type . . . . . . . . . . .
      72  QuantityReturned. . . . . . . 16.6  NNN  Quantity Returned . . . . . . .
      73  QuantityReceived. . . . . . . 16.6  NNN  Quantity Received . . . . . . .
      74  LotSerialQuantityReceived . . 16.6  NNN  Lot Serial Quantity Received. .
      75  InvoiceUnitPrice. . . . . . . 16.6  NNN  Invoice Unit Price. . . . . . .
      76  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .
      77  RestockingCharge. . . . . . . 11.3  NNN  Restocking Charge . . . . . . .