AR_InvoiceHistoryWrk                  AR Invoice History Work         Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: AR_InvoiceHistoryReport_rpt
 SQL Def: Y  SysDB: N                           "MAS_"+%C$+"/AR"+%C$+"/AR_InvoiceHistoryWrk"+%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  HeaderSeqNo . . . . . . . . .     6 SNN  Header Sequence Number. . . . .
   4  DetailSeqNo . . . . . . . . .     6 SNN  Detail Sequence Number. . . . .
   5  InvoiceNo . . . . . . . . . .     7 SNN  Invoice Number. . . . . . . . .INVOICE
   6  InvoiceType . . . . . . . . .     2 SNN  Invoice Type. . . . . . . . . .
   7  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
   8  ModuleCode. . . . . . . . . .     3 SNN  Module Code . . . . . . . . . .MODULECODE
   9  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                Mask:00
  10  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .CUSTOMERNO
  11  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .
  12  SalesOrderNo. . . . . . . . .     7 SNN  Sales Order Number. . . . . . .SALESORDERNO
  13  ShipVia . . . . . . . . . . .    15 SNN  Ship Via. . . . . . . . . . . .
  14  CustomerPONo. . . . . . . . .    15 SNN  Customer PO Number. . . . . . .CUSTOMERPONO
  15  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .
  16  TermsCodeDesc . . . . . . . .    30 SNN  Terms Code Description. . . . .
  17  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .
  18  SalespersonNo . . . . . . . .     4 SNN  Salesperson Number. . . . . . .SALESPERSONNO
  19  SalespersonName . . . . . . .    30 SNN  Salesperson Name. . . . . . . .
  20  BillToName. . . . . . . . . .    30 SNN  Bill To Name. . . . . . . . . .
  21  BillToAddress1. . . . . . . .    30 SNN  Bill To Address 1 . . . . . . .
  22  BillToAddress2. . . . . . . .    30 SNN  Bill To Address 2 . . . . . . .
  23  BillToAddress3. . . . . . . .    30 SNN  Bill To Address 3 . . . . . . .
  24  BillToCity. . . . . . . . . .    20 SNN  Bill To City. . . . . . . . . .
  25  BillToState . . . . . . . . .     2 SNN  Bill To State . . . . . . . . .
  26  BillToZipCode . . . . . . . .    10 SNN  Bill To Zip Code. . . . . . . .
  27  BillToCountryCode . . . . . .     3 SNN  Bill To Country Code. . . . . .
  28  BillToCountryName . . . . . .    30 SNN  Bill To Country Name. . . . . .NAME
  29  ShipToName. . . . . . . . . .    30 SNN  Ship To Name. . . . . . . . . .
  30  ShipToAddress1. . . . . . . .    30 SNN  Ship To Address 1 . . . . . . .
  31  ShipToAddress2. . . . . . . .    30 SNN  Ship To Address 2 . . . . . . .
  32  ShipToAddress3. . . . . . . .    30 SNN  Ship To Address 3 . . . . . . .
  33  ShipToCity. . . . . . . . . .    20 SNN  Ship To City. . . . . . . . . .
  34  ShipToState . . . . . . . . .     2 SNN  Ship To State . . . . . . . . .
  35  ShipToZipCode . . . . . . . .    10 SNN  Ship To Zip Code. . . . . . . .
  36  ShipToCountryCode . . . . . .     3 SNN  Ship To Country Code. . . . . .
  37  ShipToCountryName . . . . . .    30 SNN  Ship To Country Name. . . . . .NAME
  38  ConfirmTo . . . . . . . . . .    30 SNN  Confirm To. . . . . . . . . . .
  39  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .
  40  RMANo . . . . . . . . . . . .     7 SNN  RMA Number. . . . . . . . . . .RMANO
  41  JobNo . . . . . . . . . . . .     7 SNN  Job Number. . . . . . . . . . .JOBNO
  42  CheckNoForDeposit . . . . . .     7 SNN  Check Number For Deposit. . . .
  43  SplitCommissions. . . . . . .     1 SNN  Split Commissions . . . . . . .
  44  SalespersonDivisionNo2. . . .     2 SNN  Salesperson Division Number 2 .
  45  SalespersonNo2. . . . . . . .     4 SNN  Salesperson Number 2. . . . . .
  46  SalespersonName2. . . . . . .    30 SNN  Salesperson Name2 . . . . . . .
  47  SalespersonDivisionNo3. . . .     2 SNN  Salesperson Division Number 3 .
  48  SalespersonNo3. . . . . . . .     4 SNN  Salesperson Number 3. . . . . .
  49  SalespersonName3. . . . . . .    30 SNN  Salesperson Name3 . . . . . . .
  50  SalespersonDivisionNo4. . . .     2 SNN  Salesperson Division Number 4 .
  51  SalespersonNo4. . . . . . . .     4 SNN  Salesperson Number 4. . . . . .
  52  SalespersonName4. . . . . . .    30 SNN  Salesperson Name4 . . . . . . .
  53  SalespersonDivisionNo5. . . .     2 SNN  Salesperson Division Number 5 .
  54  SalespersonNo5. . . . . . . .     4 SNN  Salesperson Number 5. . . . . .
  55  SalespersonName5. . . . . . .    30 SNN  Salesperson Name5 . . . . . . .
  56  EBMSubmissionType . . . . . .     1 SNN  EBM Submission Type . . . . . .
  57  EBMUserIDSubmittingThisOrder.    15 SNN  EBM User ID Submitting This Ord
  58  EBMUserType . . . . . . . . .     1 SNN  EBM User Type . . . . . . . . .
  59  TaxSchedule . . . . . . . . .     9 SNN  Tax Schedule. . . . . . . . . .TAXSCHEDULE
  60  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .ITEMCODE
  61  ItemType. . . . . . . . . . .     1 SNN  Item Type . . . . . . . . . . .
  62  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
  63  SalesAccount. . . . . . . . .    41 SNN  Fully Formatted Sales Account .
  64  WarehouseCode . . . . . . . .     3 SNN  Warehouse Code. . . . . . . . .WAREHOUSE
  65  UnitOfMeasure . . . . . . . .     4 SNN  Unit Of Measure . . . . . . . .UNITOFMEASURE
  66  PriceLevel. . . . . . . . . .     1 SNN  Price Level . . . . . . . . . .
  67  Discount. . . . . . . . . . .     1 SNN  Discount. . . . . . . . . . . .
  68  Commissionable. . . . . . . .     1 SNN  Commissionable. . . . . . . . .
  69  TaxClass. . . . . . . . . . .     2 SNN  Tax Class . . . . . . . . . . .TAXCLASS
  70  DropShip. . . . . . . . . . .     1 SNN  Drop Ship . . . . . . . . . . .
  71  ProductLine . . . . . . . . .     4 SNN  Product Line. . . . . . . . . .
  72  ProductLineDesc . . . . . . .    25 SNN  Product Line Description. . . .DESCRIPTION25
  73  ExpirationDate. . . . . . . .     8 SNN  Expiration Date . . . . . . . .DATE
  74  TierType. . . . . . . . . . .     1 SNN  Tier Type . . . . . . . . . . .
  75  LotSerialNo . . . . . . . . .    15 SNN  Lot Serial Number . . . . . . .
  76  CostCode. . . . . . . . . . .     9 SNN  Cost Code . . . . . . . . . . .COSTCODE
  77  CostCodeFormatted . . . . . .    11 SNN  Cost Code Formatted . . . . . .
  78  CostType. . . . . . . . . . .     1 SNN  Cost Type . . . . . . . . . . .COSTTYPE
  79  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .
  80  TaxDetailFormatted. . . . . .   460 SNN  Tax Detail Formatted. . . . . .
  81  CRMUserID . . . . . . . . . .    11 SNN  CRM User ID . . . . . . . . . .
  82  CRMUserLastName . . . . . . .    30 SNN  CRM User Last Name. . . . . . .
  83  CRMUserFirstName. . . . . . .    30 SNN  CRM User First Name . . . . . .
  84  CRMCompanyID. . . . . . . . .    11 SNN  CRM Company ID. . . . . . . . .
  85  CRMCompanyName. . . . . . . .   120 SNN  CRM Company Name. . . . . . . .
  86  CRMPersonID . . . . . . . . .    11 SNN  CRM Person ID . . . . . . . . .
  87  CRMPersonFirstName. . . . . .    60 SNN  CRM Person First Name . . . . .
  88  CRMPersonLastName . . . . . .    80 SNN  CRM Person Last Name. . . . . .
  89  CRMOpportunityID. . . . . . .    11 SNN  CRM Opportunity ID. . . . . . .
  90  CRMOpportunityDesc. . . . . .    80 SNN  CRM Opportunity Description . .
  91  CommissionRate. . . . . . . .  9.3  NNN  Commission Rate . . . . . . . .
  92  SplitCommRate2. . . . . . . .  9.3  NNN  Split Commission Rate 2 . . . .
  93  SplitCommRate3. . . . . . . .  9.3  NNN  Split Commission Rate 3 . . . .
  94  SplitCommRate4. . . . . . . .  9.3  NNN  Split Commission Rate 4 . . . .
  95  SplitcommRate5. . . . . . . .  9.3  NNN  Split Commission Rate 5 . . . .
  96  TaxableSalesAmt . . . . . . . 13.2  NNN  Taxable Sales Amount. . . . . .
  97  NonTaxableSalesAmt. . . . . . 13.2  NNN  Non-Taxable Sales Amount. . . .
  98  SalesTaxAmt . . . . . . . . . 12.2  NNN  Sales Tax Amount. . . . . . . .
  99  FreightAmt. . . . . . . . . . 12.2  NNN  Freight Amount. . . . . . . . .
 100  DiscountAmt . . . . . . . . . 12.2  NNN  Discount Amount . . . . . . . .
 101  DepositAmt. . . . . . . . . . 13.2  NNN  Deposit Amount. . . . . . . . .
 102  QuantityOrdered . . . . . . . 16.6  NNN  Quantity Ordered. . . . . . . .
 103  QuantityShipped . . . . . . . 16.6  NNN  Quantity Shipped. . . . . . . .
 104  QuantityBackordered . . . . . 16.6  NNN  Quantity Backordered. . . . . .
 105  UnitPrice . . . . . . . . . . 16.6  NNN  Unit Price. . . . . . . . . . .
 106  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .
 107  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .
 108  RetentionAmt. . . . . . . . . 14.2  NNN  Retention Amount. . . . . . . .
 109  LineDiscountPercent . . . . .  9.3  NNN  Line Discount Percentage. . . .
 110  LotSerialQuantityShipped. . . 16.6  NNN  Lot Serial Quantity Shipped . .