SO_OpenOrdersWrk SO Open Orders Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_OpenSalesOrderReport_rpt,SO_OpenOrdersByJob_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_OpenOrdersWrk"+%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 GroupFieldDesc. . . . . . . . 30 SNN Group Field Description . . . .DESCRIPTION 4 GroupField2 . . . . . . . . . 9 SNN Group Field 2 . . . . . . . . . 5 GroupFieldDesc2 . . . . . . . 30 SNN Group Field Description 2 . . .DESCRIPTION 6 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . . 7 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE 8 OrderType . . . . . . . . . . 1 SNN Order Type. . . . . . . . . . . 9 OrderStatus . . . . . . . . . 1 SNN Order Status. . . . . . . . . . 10 MasterRepeatingOrderNo. . . . 7 SNN Master Repeating Order Number . 11 MasterRepeatingOrderType. . . 1 SNN Master Repeating Order Type . . 12 ShipExpireDate. . . . . . . . 8 SNN Ship Expire Date. . . . . . . .DATE 13 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 14 ARDivisionDesc. . . . . . . . 30 SNN AR_Division.DivisionDesc. . . . 15 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 16 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 17 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . .NAME 18 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . . 19 LastInvoiceOrderNo. . . . . . 7 SNN Last Invoice Order Number . . . 20 LastInvoiceOrderDate. . . . . 8 SNN Last Invoice Order Date . . . .DATE 21 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 22 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . . 23 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . . 24 SplitCommissions. . . . . . . 1 SNN Split Commissions . . . . . . . 25 EBMSubmissionType . . . . . . 1 SNN EBM Internet Submission Type. . 26 EBMUserIDSubmittingThisOrder. 15 SNN EBM Internet User ID Submitting 27 PaymentType . . . . . . . . . 5 SNN Payment Type. . . . . . . . . . 28 CancelReasonCode. . . . . . . 5 SNN Cancellation Reason Code. . . . 29 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . .JOBNO 30 TaxDetailFormatted. . . . . . 460 SNN Tax Detail Formatted. . . . . . 31 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . 32 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 33 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 34 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 35 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 36 WarehouseCode . . . . . . . . 3 SNN WarehouseCode . . . . . . . . . 37 PriceLevel. . . . . . . . . . 1 SNN Price Level . . . . . . . . . . 38 UnitOfMeasure . . . . . . . . 4 SNN Unit of Measure . . . . . . . . 39 KitOrComponent. . . . . . . . 1 SNN Kit or Component Line . . . . . 40 PriceOverridden . . . . . . . 1 SNN Has Price Been Overriden. . . . 41 PromiseDate . . . . . . . . . 8 SNN Promise Date. . . . . . . . . .DATE 42 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . .COSTCODE 43 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 44 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . .COSTTYPE 45 UserName. . . . . . . . . . . 30 SNN User Name . . . . . . . . . . . 46 RMANo . . . . . . . . . . . . 7 SNN RMA Number. . . . . . . . . . . 47 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT 48 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . . 49 CRMUserLastName . . . . . . . 30 SNN CRM User Last Name. . . . . . . 50 CRMUserFirstName. . . . . . . 30 SNN CRM User First Name . . . . . . 51 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . . 52 CRMCompanyName. . . . . . . . 120 SNN CRM Company Name. . . . . . . . 53 CRMProspectID . . . . . . . . 11 SNN CRM Prospect ID . . . . . . . . 54 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . . 55 CRMPersonFirstName. . . . . . 60 SNN CRM Person First Name . . . . . 56 CRMPersonLastName . . . . . . 80 SNN CRM Person Last Name. . . . . . 57 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . . 58 CRMOpportunityDesc. . . . . . 80 SNN CRM Opportunity Description . . 59 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . . 60 QuantityShipped . . . . . . . 16.6 NNN Quantity Shipped. . . . . . . . 61 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . . 62 UnitPrice . . . . . . . . . . 16.6 NNN Unit Price. . . . . . . . . . .PRICE Mask:##,###,###.000000- 63 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . . 64 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . . 65 DepositAmt. . . . . . . . . . 13.2 NNN Deposit Amount. . . . . . . . . 66 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . . 67 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .