SO_OpenOrdersByItemWrk               SO Open Orders By Item Work      Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: SO_OpenOrdersByItemReport_rpt
 SQL Def: Y  SysDB: N                         "MAS_"+%C$+"/SO"+%C$+"/SO_OpenOrdersByItemWrk"+%S$+".M4T"

 KPRIMARY: SortField

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
   2  SalesOrderNo. . . . . . . . .     7 SNN  Sales Order Number. . . . . . .
   3  OrderDate . . . . . . . . . .     8 SNN  Order Date. . . . . . . . . . .DATE
   4  OrderType . . . . . . . . . .     1 SNN  Order Type. . . . . . . . . . .
   5  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .
   6  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .
   7  CustomerName. . . . . . . . .    30 SNN  Customer Name . . . . . . . . .
   8  EBMSubmissionType . . . . . .     1 SNN  EBM Internet Submission Type. .
   9  RMANo . . . . . . . . . . . .     7 SNN  RMA Number. . . . . . . . . . .
  10  LineSeqNo . . . . . . . . . .    14 SNN  Line Sequence Number. . . . . .
  11  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
  12  ItemType. . . . . . . . . . .     1 SNN  Item Type . . . . . . . . . . .
  13  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
  14  WarehouseCode . . . . . . . .     3 SNN  WarehouseCode . . . . . . . . .
  15  UnitOfMeasure . . . . . . . .     4 SNN  Unit of Measure . . . . . . . .
  16  PromiseDate . . . . . . . . .     8 SNN  Promise Date. . . . . . . . . .DATE
  17  ProductLine . . . . . . . . .     4 SNN  Product Line. . . . . . . . . .
  18  CRMUserID . . . . . . . . . .    11 SNN  CRM User ID . . . . . . . . . .
  19  CRMUserLastName . . . . . . .    30 SNN  CRM User Last Name. . . . . . .
  20  CRMUserFirstName. . . . . . .    30 SNN  CRM User First Name . . . . . .
  21  CRMCompanyID. . . . . . . . .    11 SNN  CRM Company ID. . . . . . . . .
  22  CRMCompanyName. . . . . . . .   120 SNN  CRM Company Name. . . . . . . .
  23  CRMProspectID . . . . . . . .    11 SNN  CRM Prospect ID . . . . . . . .
  24  CRMPersonID . . . . . . . . .    11 SNN  CRM Person ID . . . . . . . . .
  25  CRMPersonFirstName. . . . . .    60 SNN  CRM Person First Name . . . . .
  26  CRMPersonLastName . . . . . .    80 SNN  CRM Person Last Name. . . . . .
  27  CRMOpportunityID. . . . . . .    11 SNN  CRM Opportunity ID. . . . . . .
  28  CRMOpportunityDesc. . . . . .    80 SNN  CRM Opportunity Description . .
  29  QuantityOrdered . . . . . . . 16.6  NNN  Quantity Ordered. . . . . . . .
  30  QuantityShipped . . . . . . . 16.6  NNN  Quantity Shipped. . . . . . . .
  31  QuantityBackordered . . . . . 16.6  NNN  Quantity Backordered. . . . . .
  32  NetQuantityOnOrder. . . . . . 16.6  NNN  Net Quantity On Order . . . . .
  33  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .