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