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