     SO_SalesOrderQuoteHistoryWrk         SO Sales Order Quote History WorkRel: 4.40  Bld: 398  8/28/2009
     Bus Obj: SO_SalesOrderQuoteHistory_rpt
     SQL Def: Y  SysDB: N                   "MAS_"+%C$+"/SO"+%C$+"/SO_SalesOrderQuoteHistoryWrk"+%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  GroupField2 . . . . . . . . .     7 SNN  Group Field 2 . . . . . . . . .
       4  SalesOrderNo. . . . . . . . .     7 SNN  Sales Order Number. . . . . . .
       5  OrderDate . . . . . . . . . .     8 SNN  Order Date. . . . . . . . . . .DATE
       6  OrderStatus . . . . . . . . .     1 SNN  Order Status. . . . . . . . . .
       7  MasterRepeatingOrderNo. . . .     7 SNN  Master Repeating Order Number .
       8  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .
       9  ARDivisionDesc. . . . . . . .    30 SNN  AR Division Description . . . .
      10  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .
      11  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .
      12  CustomerPONo. . . . . . . . .    15 SNN  Customer PO Number. . . . . . .
      13  BillToName. . . . . . . . . .    30 SNN  Bill To Name. . . . . . . . . .
      14  LastInvoiceNo . . . . . . . .     7 SNN  Last Invoice Number . . . . . .
      15  LastInvoiceDate . . . . . . .     8 SNN  Last Invoice Date . . . . . . .DATE
      16  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .
      17  SalespersonNo . . . . . . . .     4 SNN  Salesperson Number. . . . . . .
      18  SalespersonName . . . . . . .    30 SNN  Salesperson Name. . . . . . . .
      19  SplitCommissions. . . . . . .     1 SNN  Split Commissions . . . . . . .
      20  CancelReasonCode. . . . . . .     5 SNN  Cancellation Reason Code. . . .
      21  CancelReasonCodeDesc. . . . .    30 SNN  Cancellation Reason Code Descri
      22  EBMSubmissionType . . . . . .     1 SNN  EBM Internet Submission Type. .
      23  EBMUserIDSubmittingThisOrder.    15 SNN  EBM Internet User ID Submitting
      24  RMANo . . . . . . . . . . . .     7 SNN  RMA Number. . . . . . . . . . .
      25  JobNo . . . . . . . . . . . .     7 SNN  Job Number. . . . . . . . . . .
      26  CostCode. . . . . . . . . . .     9 SNN  Cost Code . . . . . . . . . . .
      27  CostCodeFormatted . . . . . .    11 SNN  Cost Code Formatted . . . . . .
      28  CostType. . . . . . . . . . .     1 SNN  Cost Type . . . . . . . . . . .
      29  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .
      30  SequenceNo. . . . . . . . . .    14 SNN  Sequence Number . . . . . . . .
      31  CancelledLine . . . . . . . .     1 SNN  Cancelled Line. . . . . . . . .
      32  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
      33  ItemType. . . . . . . . . . .     1 SNN  Item Type . . . . . . . . . . .
      34  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
      35  ExtendedDescriptionKey. . . .    10 SNN  Extended Description Key. . . .
      36  ExtendedDescriptionText . . .  4096 SNN  Extended Description Text . . .
      37  PriceOverridden . . . . . . .     1 SNN  Has Price Been Overridden . . .
      38  ExplodedKitItem . . . . . . .     1 SNN  Exploded Kit Item . . . . . . .
      39  PromiseDate . . . . . . . . .     8 SNN  Promise Date. . . . . . . . . .DATE
      40  UnitOfMeasure . . . . . . . .     4 SNN  Unit of Measure . . . . . . . .
      41  SalesKitLineKey . . . . . . .     6 SNN  Sales Kit Line Key. . . . . . .
      42  CRMUserID . . . . . . . . . .    11 SNN  CRM User ID . . . . . . . . . .
      43  CRMUserName . . . . . . . . .    40 SNN  CRM User Name . . . . . . . . .
      44  CRMCompanyID. . . . . . . . .    11 SNN  CRM Company ID. . . . . . . . .
      45  CRMCompanyName. . . . . . . .    40 SNN  CRM Company Name. . . . . . . .
      46  CRMPersonID . . . . . . . . .    11 SNN  CRMPersonID . . . . . . . . . .
      47  CRMPersonName . . . . . . . .    40 SNN  CRM Person Name . . . . . . . .
      48  CRMOpportunityID. . . . . . .    11 SNN  CRM Opportunity ID. . . . . . .
      49  CRMOpportunityDesc. . . . . .    40 SNN  CRM Opportunity Description . .
      50  DiscountAmt . . . . . . . . . 12.2  NNN  Discount Amount . . . . . . . .
      51  SalesTaxAmt . . . . . . . . . 12.2  NNN  Sales Tax Amount. . . . . . . .
      52  FreightAmt. . . . . . . . . . 12.2  NNN  Freight Amount. . . . . . . . .
      53  DepositAmt. . . . . . . . . . 13.2  NNN  Deposit Amount. . . . . . . . .
      54  QuantityOrderedOriginal . . . 16.6  NNN  Quantity Ordered Original . . .
      55  QuantityOrderedRevised. . . . 16.6  NNN  Quantity Ordered Revised. . . .
      56  QuantityShipped . . . . . . . 16.6  NNN  Quantity Shipped. . . . . . . .
      57  QuantityBackordered . . . . . 16.6  NNN  Quantity Backordered. . . . . .
      58  LastExtensionAmt. . . . . . . 12.2  NNN  Last Extension Amount . . . . .
      59  OriginalUnitPrice . . . . . . 16.6  NNN  Original Unit Price . . . . . .
      60  LastUnitPrice . . . . . . . . 16.6  NNN  Last Unit Price . . . . . . . .