     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 . .