RA_GenerateTransactionsWrk            RA Generate Transactions Work   Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: RA_GenerateTransactions_upd
 SQL Def: Y  SysDB: N                     "MAS_"+%C$+"/RA"+%C$+"/RA_GenerateTransactionsWrk"+%S$+".M4T"

 KPRIMARY: SortField

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
   2  GroupField. . . . . . . . . .     9 SNN  Group Field . . . . . . . . . .
   3  DocumentType. . . . . . . . .     1 SNN  Document Type . . . . . . . . .
   4  RMANo . . . . . . . . . . . .     7 SNN  RMA Number. . . . . . . . . . .
   5  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .
   6  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .
   7  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .
   8  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .
   9  VendorNo. . . . . . . . . . .     7 SNN  Vendor Number . . . . . . . . .
  10  ActualInvoiceNo . . . . . . .     7 SNN  Actual Invoice Number . . . . .
  11  SequenceNo. . . . . . . . . .     6 SNN  Sequence Number . . . . . . . .
  12  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
  13  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
  14  ItemType. . . . . . . . . . .     1 SNN  Item Type . . . . . . . . . . .
  15  ReceiptsDetailLineKey . . . .     6 SNN  Receipts Detail Line Key. . . .
  16  SOPOBatchNo . . . . . . . . .     5 SNN  SO/PO Batch Number. . . . . . .
  17  CustomerAction. . . . . . . .     1 SNN  Customer Action . . . . . . . .
  18  ItemAction. . . . . . . . . .     1 SNN  Item Action . . . . . . . . . .
  19  ReplacementItemCode . . . . .    30 SNN  Replacement Item Code . . . . .
  20  ReplacementItemType . . . . .     1 SNN  Replacement Item Type . . . . .
  21  VendorAction. . . . . . . . .     1 SNN  Vendor Action . . . . . . . . .
  22  DropShip. . . . . . . . . . .     1 SNN  Drop Ship . . . . . . . . . . .
  23  CrossShip . . . . . . . . . .     1 SNN  Cross Ship. . . . . . . . . . .
  24  CreditFreight . . . . . . . .     1 SNN  Credit Freight. . . . . . . . .
  25  WarrantyCode. . . . . . . . .    10 SNN  Warranty Code . . . . . . . . .
  26  ExpirationDate. . . . . . . .     8 SNN  Expiration Date . . . . . . . .DATE
  27  ExpirationDateOverridden. . .     1 SNN  Expiration Date Overridden. . .
  28  CostOfGoodsSoldAcctKey. . . .     9 SNN  Cost Of Goods Sold Account Key.
  29  CostOfGoodsSoldAccount. . . .    41 SNN  Fully Formatted Cost Of Goods S
  30  SalesAcctKey. . . . . . . . .     9 SNN  Sales Account Key . . . . . . .
  31  SalesAccount. . . . . . . . .    41 SNN  Fully Formatted Sales Account N
  32  HistoryCOGSAcctKey. . . . . .     9 SNN  History Cost Of Goods Sold Acco
  33  HistoryCOGSAccount. . . . . .    41 SNN  Fully Formatted History Cost Of
  34  CommentText . . . . . . . . .  2048 SNN  . . . . . . . . . . . . . . .
  35  InvoiceNotOnFile. . . . . . .     1 SNN  Invoice Not On File . . . . . .
  36  GenerateDocumentSO. . . . . .     1 SNN  Generate Document Sales Order .
  37  GenerateDocumentCM. . . . . .     1 SNN  Generate Document Credit Memo .
  38  GenerateDocumentRO. . . . . .     1 SNN  Generate Document Return Order.
  39  GenerateDocumentPO. . . . . .     1 SNN  Generate Document Purchase Orde
  40  QuantityReturned. . . . . . . 16.6  NNN  Quantity Returned . . . . . . .
  41  InvoiceUnitPrice. . . . . . . 16.6  NNN  Invoice Unit Price. . . . . . .
  42  RestockingCharge. . . . . . . 11.3  NNN  Restocking Charge . . . . . . .