     SO_RecapWrk                            SO Recap Work                  Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: SO_SalesOrderRecapReport_rpt
     SQL Def: Y  SysDB: N                                    "MAS_"+%C$+"/SO"+%C$+"/SO_RecapWrk"+%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  SalesOrderNo. . . . . . . . .     7 SNN  Sales Order Number. . . . . . .
       4  OrderDate . . . . . . . . . .     8 SNN  Order Date. . . . . . . . . . .DATE
       5  OrderType . . . . . . . . . .     1 SNN  Order Type. . . . . . . . . . .
       6  OrderStatus . . . . . . . . .     1 SNN  Order Status. . . . . . . . . .
       7  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .
       8  ARDivisionDesc. . . . . . . .    30 SNN  AR Division Description . . . .
       9  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .
      10  BillToName. . . . . . . . . .    30 SNN  Bill To Name. . . . . . . . . .
      11  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .
      12  RMANo . . . . . . . . . . . .     7 SNN  RMA Number. . . . . . . . . . .
      13  CRMUserID . . . . . . . . . .    11 SNN  CRM User ID . . . . . . . . . .
      14  CRMUserLastName . . . . . . .    30 SNN  CRM User Last Name. . . . . . .
      15  CRMUserFirstName. . . . . . .    30 SNN  CRM User First Name . . . . . .
      16  CRMCompanyID. . . . . . . . .    11 SNN  CRM Company ID. . . . . . . . .
      17  CRMCompanyName. . . . . . . .   120 SNN  CRM Company Name. . . . . . . .
      18  CRMProspectID . . . . . . . .    11 SNN  CRM Prospect ID . . . . . . . .
      19  CRMPersonID . . . . . . . . .    11 SNN  CRM Person ID . . . . . . . . .
      20  CRMPersonFirstName. . . . . .    60 SNN  CRM Person First Name . . . . .
      21  CRMPersonLastName . . . . . .    80 SNN  CRM Person Last Name. . . . . .
      22  CRMOpportunityID. . . . . . .    11 SNN  CRM Opportunity ID. . . . . . .
      23  CRMOpportunityDesc. . . . . .    80 SNN  CRM Opportunity Description . .
      24  EBMSubmissionType . . . . . .     1 SNN  EBM Submission Type . . . . . .
      25  OrderTotal. . . . . . . . . . 13.2  NNN  Order Total . . . . . . . . . .