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