     SO_OpenOrdersWrk                      SO Open Orders Work             Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: SO_OpenSalesOrderReport_rpt,SO_OpenOrdersByJob_rpt
     SQL Def: Y  SysDB: N                               "MAS_"+%C$+"/SO"+%C$+"/SO_OpenOrdersWrk"+%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  GroupFieldDesc. . . . . . . .    30 SNN  Group Field Description . . . .DESCRIPTION
       4  GroupField2 . . . . . . . . .     9 SNN  Group Field 2 . . . . . . . . .
       5  GroupFieldDesc2 . . . . . . .    30 SNN  Group Field Description 2 . . .DESCRIPTION
       6  SalesOrderNo. . . . . . . . .     7 SNN  Sales Order Number. . . . . . .
       7  OrderDate . . . . . . . . . .     8 SNN  Order Date. . . . . . . . . . .DATE
       8  OrderType . . . . . . . . . .     1 SNN  Order Type. . . . . . . . . . .
       9  OrderStatus . . . . . . . . .     1 SNN  Order Status. . . . . . . . . .
      10  MasterRepeatingOrderNo. . . .     7 SNN  Master Repeating Order Number .
      11  MasterRepeatingOrderType. . .     1 SNN  Master Repeating Order Type . .
      12  ShipExpireDate. . . . . . . .     8 SNN  Ship Expire Date. . . . . . . .DATE
      13  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .
      14  ARDivisionDesc. . . . . . . .    30 SNN  AR_Division.DivisionDesc. . . .
      15  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .
      16  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .
      17  BillToName. . . . . . . . . .    30 SNN  Bill To Name. . . . . . . . . .NAME
      18  CustomerPONo. . . . . . . . .    15 SNN  Customer PO Number. . . . . . .
      19  LastInvoiceOrderNo. . . . . .     7 SNN  Last Invoice Order Number . . .
      20  LastInvoiceOrderDate. . . . .     8 SNN  Last Invoice Order Date . . . .DATE
      21  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .
      22  SalespersonNo . . . . . . . .     4 SNN  Salesperson Number. . . . . . .
      23  SalespersonName . . . . . . .    30 SNN  Salesperson Name. . . . . . . .
      24  SplitCommissions. . . . . . .     1 SNN  Split Commissions . . . . . . .
      25  EBMSubmissionType . . . . . .     1 SNN  EBM Internet Submission Type. .
      26  EBMUserIDSubmittingThisOrder.    15 SNN  EBM Internet User ID Submitting
      27  PaymentType . . . . . . . . .     5 SNN  Payment Type. . . . . . . . . .
      28  CancelReasonCode. . . . . . .     5 SNN  Cancellation Reason Code. . . .
      29  JobNo . . . . . . . . . . . .     7 SNN  Job Number. . . . . . . . . . .JOBNO
      30  TaxDetailFormatted. . . . . .   460 SNN  Tax Detail Formatted. . . . . .
      31  LineKey . . . . . . . . . . .     6 SNN  Line Key. . . . . . . . . . . .
      32  LineSeqNo . . . . . . . . . .    14 SNN  Line Sequence Number. . . . . .
      33  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
      34  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
      35  ItemType. . . . . . . . . . .     1 SNN  Item Type . . . . . . . . . . .
      36  WarehouseCode . . . . . . . .     3 SNN  WarehouseCode . . . . . . . . .
      37  PriceLevel. . . . . . . . . .     1 SNN  Price Level . . . . . . . . . .
      38  UnitOfMeasure . . . . . . . .     4 SNN  Unit of Measure . . . . . . . .
      39  KitOrComponent. . . . . . . .     1 SNN  Kit or Component Line . . . . .
      40  PriceOverridden . . . . . . .     1 SNN  Has Price Been Overriden. . . .
      41  PromiseDate . . . . . . . . .     8 SNN  Promise Date. . . . . . . . . .DATE
      42  CostCode. . . . . . . . . . .     9 SNN  Cost Code . . . . . . . . . . .COSTCODE
      43  CostCodeFormatted . . . . . .    11 SNN  Cost Code Formatted . . . . . .
      44  CostType. . . . . . . . . . .     1 SNN  Cost Type . . . . . . . . . . .COSTTYPE
      45  UserName. . . . . . . . . . .    30 SNN  User Name . . . . . . . . . . .
      46  RMANo . . . . . . . . . . . .     7 SNN  RMA Number. . . . . . . . . . .
      47  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .COMMENT
      48  CRMUserID . . . . . . . . . .    11 SNN  CRM User ID . . . . . . . . . .
      49  CRMUserLastName . . . . . . .    30 SNN  CRM User Last Name. . . . . . .
      50  CRMUserFirstName. . . . . . .    30 SNN  CRM User First Name . . . . . .
      51  CRMCompanyID. . . . . . . . .    11 SNN  CRM Company ID. . . . . . . . .
      52  CRMCompanyName. . . . . . . .   120 SNN  CRM Company Name. . . . . . . .
      53  CRMProspectID . . . . . . . .    11 SNN  CRM Prospect ID . . . . . . . .
      54  CRMPersonID . . . . . . . . .    11 SNN  CRM Person ID . . . . . . . . .
      55  CRMPersonFirstName. . . . . .    60 SNN  CRM Person First Name . . . . .
      56  CRMPersonLastName . . . . . .    80 SNN  CRM Person Last Name. . . . . .
      57  CRMOpportunityID. . . . . . .    11 SNN  CRM Opportunity ID. . . . . . .
      58  CRMOpportunityDesc. . . . . .    80 SNN  CRM Opportunity Description . .
      59  QuantityOrdered . . . . . . . 16.6  NNN  Quantity Ordered. . . . . . . .
      60  QuantityShipped . . . . . . . 16.6  NNN  Quantity Shipped. . . . . . . .
      61  QuantityBackordered . . . . . 16.6  NNN  Quantity Backordered. . . . . .
      62  UnitPrice . . . . . . . . . . 16.6  NNN  Unit Price. . . . . . . . . . .PRICE
                                                    Mask:##,###,###.000000-
      63  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .
      64  FreightAmt. . . . . . . . . . 12.2  NNN  Freight Amount. . . . . . . . .
      65  DepositAmt. . . . . . . . . . 13.2  NNN  Deposit Amount. . . . . . . . .
      66  DiscountAmt . . . . . . . . . 12.2  NNN  Discount Amount . . . . . . . .
      67  SalesTaxAmt . . . . . . . . . 12.2  NNN  Sales Tax Amount. . . . . . . .