SO_SalesOrderQuoteHistoryWrk SO Sales Order Quote History WorkRel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_SalesOrderQuoteHistory_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_SalesOrderQuoteHistoryWrk"+%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 GroupField2 . . . . . . . . . 7 SNN Group Field 2 . . . . . . . . . 4 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . . 5 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE 6 OrderStatus . . . . . . . . . 1 SNN Order Status. . . . . . . . . . 7 MasterRepeatingOrderNo. . . . 7 SNN Master Repeating Order Number . 8 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 9 ARDivisionDesc. . . . . . . . 30 SNN AR Division Description . . . . 10 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 11 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 12 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . . 13 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . . 14 LastInvoiceNo . . . . . . . . 7 SNN Last Invoice Number . . . . . . 15 LastInvoiceDate . . . . . . . 8 SNN Last Invoice Date . . . . . . .DATE 16 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 17 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . . 18 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . . 19 SplitCommissions. . . . . . . 1 SNN Split Commissions . . . . . . . 20 CancelReasonCode. . . . . . . 5 SNN Cancellation Reason Code. . . . 21 CancelReasonCodeDesc. . . . . 30 SNN Cancellation Reason Code Descri 22 EBMSubmissionType . . . . . . 1 SNN EBM Internet Submission Type. . 23 EBMUserIDSubmittingThisOrder. 15 SNN EBM Internet User ID Submitting 24 RMANo . . . . . . . . . . . . 7 SNN RMA Number. . . . . . . . . . . 25 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 26 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . . 27 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 28 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . . 29 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 30 SequenceNo. . . . . . . . . . 14 SNN Sequence Number . . . . . . . . 31 CancelledLine . . . . . . . . 1 SNN Cancelled Line. . . . . . . . . 32 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 33 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 34 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 35 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . . 36 ExtendedDescriptionText . . . 4096 SNN Extended Description Text . . . 37 PriceOverridden . . . . . . . 1 SNN Has Price Been Overridden . . . 38 ExplodedKitItem . . . . . . . 1 SNN Exploded Kit Item . . . . . . . 39 PromiseDate . . . . . . . . . 8 SNN Promise Date. . . . . . . . . .DATE 40 UnitOfMeasure . . . . . . . . 4 SNN Unit of Measure . . . . . . . . 41 SalesKitLineKey . . . . . . . 6 SNN Sales Kit Line Key. . . . . . . 42 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . . 43 CRMUserName . . . . . . . . . 40 SNN CRM User Name . . . . . . . . . 44 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . . 45 CRMCompanyName. . . . . . . . 40 SNN CRM Company Name. . . . . . . . 46 CRMPersonID . . . . . . . . . 11 SNN CRMPersonID . . . . . . . . . . 47 CRMPersonName . . . . . . . . 40 SNN CRM Person Name . . . . . . . . 48 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . . 49 CRMOpportunityDesc. . . . . . 40 SNN CRM Opportunity Description . . 50 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . . 51 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . . 52 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . . 53 DepositAmt. . . . . . . . . . 13.2 NNN Deposit Amount. . . . . . . . . 54 QuantityOrderedOriginal . . . 16.6 NNN Quantity Ordered Original . . . 55 QuantityOrderedRevised. . . . 16.6 NNN Quantity Ordered Revised. . . . 56 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . . 57 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . . 58 LastExtensionAmt. . . . . . . 12.2 NNN Last Extension Amount . . . . . 59 OriginalUnitPrice . . . . . . 16.6 NNN Original Unit Price . . . . . . 60 LastUnitPrice . . . . . . . . 16.6 NNN Last Unit Price . . . . . . . .