SO_OpenOrdersByPromiseDateWrk SO Open Orders By Promise Date WoRel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_OpenOrdersByPromiseDate_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_OpenOrdersByPromiseDateWrk"+%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 ShipExpireDate. . . . . . . . 8 SNN Ship Expire Date. . . . . . . .DATE 6 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 7 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 8 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 9 EBMSubmissionType . . . . . . 1 SNN EBM Internet Submission Type. . 10 RMANo . . . . . . . . . . . . 7 SNN RMA Number. . . . . . . . . . . 11 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 12 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 13 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 14 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 15 WarehouseCode . . . . . . . . 3 SNN WarehouseCode . . . . . . . . . 16 UnitOfMeasure . . . . . . . . 4 SNN Unit of Measure . . . . . . . . 17 PromiseDate . . . . . . . . . 8 SNN Promise Date. . . . . . . . . .DATE 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 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .