На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление заказом на обслуживание» / List of tables of module «Service Order Management»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table SM41 — Service Order Head History

Таблица / Table: SM41 — «Service Order Master History File». Маска имени таблицы / Table name mask: «SM41%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SM41001 NCHAR STRING 10 0 10 ServiceOrdNo Service Order Number   1 Да / Yes
SM41002 NCHAR STRING 10 0 10 CustCodeInv Customer Code Invoice      
SM41003 NCHAR STRING 10 0 10 CustCodeServ Customer Code Service      
SM41004 NVARCHAR VSTRING 35 0 35 CustomerRef Customer Reference      
SM41005 NCHAR STRING 20 0 20 CustomerPONo Customer Purchase Order Number      
SM41006 NCHAR STRING 35 0 35 ObjStockCode Service Object      
SM41007 NCHAR STRING 20 0 20 ObjSerialNo Service Object Serial Number      
SM41008 NVARCHAR VSTRING 25 0 25 ObjectDescr1 Service Object Description Line 1      
SM41009 NVARCHAR VSTRING 25 0 25 ObjectDescr2 Service Object Description Line 2      
SM41010 NCHAR STRING 10 0 10 ObjMaintContNo Service Object Contract      
SM41011 NVARCHAR VSTRING 70 0 70 ServiceReq1 Text Line 1      
SM41012 NVARCHAR VSTRING 70 0 70 ServiceReq2 Text Line 2      
SM41013 NVARCHAR VSTRING 70 0 70 ServiceReq3 Text Line 3      
SM41014 NVARCHAR VSTRING 70 0 70 ServiceReq4 Text Line 4      
SM41015 NVARCHAR VSTRING 35 0 35 OurReference Our Reference      
SM41016 NCHAR STRING 10 0 10 FieldEngineer Resource Code Engineer      
SM41017 DATETIME DATE 0 0 8 CALLETADate Service Call ETA Date      
SM41018 NUMERIC X_NUMERIC 13 8 5 CALLETATime Service Call ETA Time      
SM41019 DATETIME DATE 0 0 8 CALLETRDate Service Call ETR Date      
SM41020 NUMERIC X_NUMERIC 13 8 5 CALLETRTime Service Call ETR Time      
SM41021 DATETIME DATE 0 0 8 CALLLOGEDDt Service Call Date Logged      
SM41022 NUMERIC X_NUMERIC 13 8 5 CALLLOGEDTime Service Call Time Logged      
SM41023 DATETIME DATE 0 0 8 CALLOPENDate Service Call Date Opened      
SM41024 NUMERIC X_NUMERIC 13 8 5 CALLOPENTime Service Call Time Opened      
SM41025 DATETIME DATE 0 0 8 CALLCOMPLDate Service Call Date Committed      
SM41026 NUMERIC X_NUMERIC 13 8 5 CALLCOMPLTime Service Call Time Committed      
SM41027 DATETIME DATE 0 0 8 CALLCLOSEDt Service Call Date Closed      
SM41028 NUMERIC X_NUMERIC 13 8 5 CALLCLOSETime Service Call Time Closed      
SM41029 NCHAR STRING 4 0 4 ProPriGroCode Product Price Group Code      
SM41030 NUMERIC MONEY 28 8 20 FixPriceHrs (obsolete)      
SM41031 NUMERIC MONEY 28 8 20 FixPriceCst (obsolete)      
SM41032 NUMERIC MONEY 28 8 20 FixPriceMat (obsolete)      
SM41033 INT INTEGER 0 0 1 InvSpecHours (obsolete)      
SM41034 INT INTEGER 0 0 1 InvSpecCosts (obsolete)      
SM41035 INT INTEGER 0 0 1 InvSpecMat (obsolete)      
SM41036 NCHAR STRING 2 0 2 PaymentTerm (obsolete)      
SM41037 DATETIME DATE 0 0 8 InvoiceDate Last Invoice Date      
SM41038 NCHAR STRING 15 0 15 InvoiceNo Last Invoice Number   2 Да / Yes
SM41039 INT INTEGER 0 0 1 InteStatFlag Quotation State      
SM41040 INT INTEGER 0 0 1 DOCFLAGQuotation Quotation Print Status      
SM41041 INT INTEGER 0 0 1 DOCFLAGConfirm Confirmation Print Status      
SM41042 INT INTEGER 0 0 1 DOCFLAGSrvOrder Service Order Print Status      
SM41043 INT INTEGER 0 0 1 InvUpdStatus (obsolete)      
SM41044 NVARCHAR VSTRING 3 0 3 LanguageCode Language      
SM41045 NCHAR STRING 1 0 1 DocmntLayout Document Layout      
SM41046 INT INTEGER 0 0 1 EngnPagingFlag Engineer Paging Status      
SM41047 INT INTEGER 0 0 1 InvMergeOption Invoice Merge Option      
SM41048 NUMERIC MONEY 28 8 20 HandlingFee (obsolete)      
SM41049 NCHAR STRING 2 0 2 CurrencyCode Currency Code Order      
SM41050 NCHAR STRING 2 0 2 Pricelist (obsolete)      
SM41051 NCHAR STRING 6 0 6 WareHouse Warehouse      
SM41052 DATETIME DATE 0 0 8 BookEntryDate Book-Entry Date      
SM41053 NCHAR STRING 1 0 1 CurrencyClause Currency Compensation      
SM41054 NCHAR STRING 1 0 1 CurrencyContract Currency Contract      
SM41055 NCHAR STRING 1 0 1 StkToolWCHR Service Object Type      
SM41056 INT INTEGER 0 0 2 EDITransmCnt EDI Sent Counter      
SM41057 INT INTEGER 0 0 2 EDIReceivCnt EDI Received Counter      
SM41058 NCHAR SWITCH 1 0 1 EDIFlag1 EDI Document 1 Status      
SM41059 NCHAR SWITCH 1 0 1 EDIFlag2 EDI Document 2 Status      
SM41060 NCHAR SWITCH 1 0 1 EDIFlag3 EDI Document 3 Status      
SM41061 NCHAR SWITCH 1 0 1 EDIFlag4 EDI Document 4 Status      
SM41062 NCHAR SWITCH 1 0 1 PriorityFlg1 Service Order Priority      
SM41063 NCHAR SWITCH 1 0 1 PriorityFlg2 Weighted Priority      
SM41064 NCHAR STRING 2 0 2 OrderStatus Order Status      
SM41065 NCHAR STRING 3 0 3 MaintenaCode Contract Type      
SM41066 NCHAR SWITCH 1 0 1 LetterOfCredit Letter of Credit      
SM41067 DATETIME DATE 0 0 8 LCOpenDate Letter of Credit Open Date      
SM41068 DATETIME DATE 0 0 8 LCDueDate Letter of Credit Due Date      
SM41069 NVARCHAR VSTRING 20 0 20 LCReference Letter of Credit Reference      
SM41070 NCHAR SWITCH 1 0 1 GenerPIATrans Generate WIP Transactions      
SM41071 NCHAR STRING 4 0 4 CustSiteNo Site Code      
SM41072 DATETIME DATE 0 0 8 CALLATADate Service Call ATA Date      
SM41073 NUMERIC X_NUMERIC 13 8 5 CALLATATime Service Call ATA Time      
SM41074 DATETIME DATE 0 0 8 MaterialDate Material Date      
SM41075 NUMERIC X_NUMERIC 13 8 5 MaterialTime Material Time      
SM41076 NCHAR STRING 4 0 4 IncidentCode Incident Code      
SM41077 NCHAR STRING 15 0 15 AnalysisCode Analysis Code      
SM41078 NCHAR STRING 10 0 10 MasterServOrder Master Service Order Number      
SM41079 INT INTEGER 0 0 1 OrderStruStatus Order Structure Status      
SM41080 INT INTEGER 0 0 1 DOCFLAGPckNo Picking List Local Print Status      
SM41081 INT INTEGER 0 0 1 DOCFLAGTrans Transport Document Print Status      
SM41082 INT INTEGER 0 0 1 DOCFLAGExport Export Document Print Status      
SM41083 INT INTEGER 0 0 1 DOCFLAGProformInv Proforma Invoice Print Status      
SM41084 NCHAR STRING 15 0 15 ExtSrvStaCode External Commission Code      
SM41085 NCHAR STRING 20 0 20 DeliveryNotNo Delivery Note Number      
SM41086 NCHAR STRING 2 0 2 DeliveryCode Delivery Terms      
SM41087 NCHAR STRING 2 0 2 DeliveryMethod Delivery Method      
SM41088 INT INTEGER 0 0 1 DOCFLDeliNot Delivery Note 1 Print Status      
SM41089 INT INTEGER 0 0 1 DOCFLSubsuppler Sub-Supplier Delivery Note Print Status      
SM41090 INT INTEGER 0 0 1 DOCFLFridok1 User Document 1 Print Status      
SM41091 INT INTEGER 0 0 1 DOCFLFridok2 User Document 2 Print Status      
SM41092 INT INTEGER 0 0 1 DOCFLFridok3 User Document 3 Print Status      
SM41093 INT INTEGER 0 0 1 DOCFLCustDel Delivery Note 2 Print Status      
SM41094 NCHAR SWITCH 1 0 1 MastOrdPrint Master Order Delivery Note      
SM41095 DATETIME DATE 0 0 8 SerNoDelDate Serial Number Delivery Date      
SM41096 DATETIME DATE 0 0 8 SerNoWarrExp Serial Number Warranty Expire Date      
SM41097 NCHAR STRING 6 0 6 OrderType Order Type      
SM41098 NUMERIC X_NUMERIC 20 8 12 PlannedHours Planned Hours      
SM41099 NCHAR STRING 35 0 35 SwapArtNo Swap Stock Item      
SM41100 NVARCHAR VSTRING 25 0 25 SwapDescr1 Swap Stock Item Description Line 1      
SM41101 NVARCHAR VSTRING 25 0 25 SwapDescr2 Swap Stock Item Description Line 2      
SM41102 NCHAR STRING 20 0 20 SwapSerieNo Swap Serial Number      
SM41103 INT INTEGER 0 0 1 PickinglCenter Picking List External Print Status      
SM41104 INT INTEGER 0 0 1 ReturnNote Return Note Print Status      
SM41105 INT INTEGER 0 0 1 Proforma Proforma Print Status      
SM41106 INT INTEGER 0 0 1 Ettikes Labels Print Status      
SM41107 INT INTEGER 0 0 1 CustDelNote Delivery Note 3 Print Status      
SM41108 NCHAR STRING 14 0 14 StatistCode Statistical Code Extended      
SM41109 NUMERIC MONEY 28 8 20 StatistValue Statistical Value (Local Currency)      
SM41110 NCHAR STRING 3 0 3 SalesmanOrder Salesman      
SM41111 NCHAR STRING 3 0 3 SalesmanInvoicer Salesman Invoice Manager      
SM41112 NCHAR STRING 4 0 4 ObjPriceGroup Product Group as Price Group      
SM41113 NVARCHAR ACCSTR 50 0 50 AccString Accounting String      
SM41114 DATETIME DATE 0 0 8 STATUSDate Status Date      
SM41115 NUMERIC X_NUMERIC 13 8 5 STATUSTime Status Time      
SM41116 NVARCHAR VSTRING 20 0 20 STATUSTEXT Status Text      
SM41117 NUMERIC X_NUMERIC 20 8 12 RespTimeCont Response Time Contract      
SM41118 NCHAR STRING 10 0 10 CustContrGar Customer Code Internal for Contract and Warranty      
SM41119 NCHAR STRING 2 0 2 PriclCntrGar Price List for Contract and Warranty      
SM41120 NCHAR STRING 10 0 10 CustomerCntr (obsolete)      
SM41121 NCHAR STRING 6 0 6 WIPWHGood WIP Warehouse      
SM41122 NCHAR STRING 6 0 6 WIPBinGood WIP Bin      
SM41123 NCHAR STRING 6 0 6 WIPDACode WIP Delivery Address Code      
SM41124 DATETIME DATE 0 0 8 ExchangeDate Currency Exchange Date      
SM41125 NUMERIC X_NUMERIC 13 8 5 Spare (obsolete)      
SM41126 NUMERIC X_NUMERIC 20 8 12 RespTimePhone Call Back Response Time      
SM41127 INT INTEGER 0 0 1 WIPDACtype WIP Delivery Address Code Type      
SM41128 NCHAR STRING 4 0 4 InteEscaCode Internal Escalation Code      
SM41129 NCHAR STRING 20 0 20 TextRef Text Reference      
SM41130 DATETIME DATE 0 0 8 ETCDate ETC Date      
SM41131 NUMERIC X_NUMERIC 13 8 5 ETCTime ETC Time      
SM41132 INT INTEGER 0 0 1 CustStatus Invoice Customer Type      
SM41133 NCHAR STRING 10 0 10 ReferenceNo Problem Code Reference      
SM41134 NUMERIC X_NUMERIC 20 8 12 Spare (obsolete)      
SM41135 NCHAR STRING 3 0 3 ExchangeAlgorithm Currency Exchange Algorithm      
SM41136 NCHAR STRING 2 0 2 Spare (obsolete)      
SM41137 NCHAR STRING 10 0 10 OrderedCustomerCode Customer Code Order      
SM41138 NVARCHAR VSTRING 3 0 3 SerNumWarType Serial number selected warranty type      
SM41139 NCHAR STRING 10 0 10 Spare Contract Line Number      
SM41140 NCHAR STRING 2 0 2 Spare (obsolete)      
SM41141 NUMERIC X_NUMERIC 20 8 12 MassRepairQty Quantity for Mass Repair      
SM41142 NUMERIC X_NUMERIC 15 8 7 OrderDiscPerc Order Discount %      
SM41143 NUMERIC X_NUMERIC 15 8 7 ExtComissPerc (obsolete)      
SM41144 NVARCHAR VSTRING 10 0 10 ExtComissText (obsolete)      
SM41145 NCHAR STRING 2 0 2 SOAccCode Accounting Code Service Order      
SM41146 NUMERIC X_NUMERIC 23 8 15 ExchangeRate1 Currency Exchange Rate 1      
SM41147 NUMERIC X_NUMERIC 23 8 15 ExchangeRate2 Exchange Rate 2      
SM41148 NUMERIC MONEY 28 8 20 FixPriceHoursLcu (obsolete)      
SM41149 NUMERIC MONEY 28 8 20 FixPriceCostsLcu (obsolete)      
SM41150 NUMERIC MONEY 28 8 20 FixPriceMatLcu (obsolete)      
SM41151 NUMERIC X_NUMERIC 23 8 15 FixedExchRate1 Fixed Exchange Rate 1      
SM41152 NUMERIC X_NUMERIC 23 8 15 FixedExchRate2 Fixed Exchange Rate 2      
SM41153 NCHAR STRING 3 0 3 FixesExchAlgorithm Fixed Exchange Algorithm      
SM41154 NVARCHAR VSTRING 15 0 15 CurrencyContractNr Currency Contract Number      
SM41155 NVARCHAR VSTRING 8 0 8 CampaignCode Campaign      
SM41156 NUMERIC X_NUMERIC 14 8 6 LimitForCurrClausePc Currency Compensation Limit %      
SM41157 NUMERIC X_NUMERIC 14 8 6 CompensationPer Currency Compensation %      
SM41158 NCHAR STRING 10 0 10 RequestNo Customer Request      
SM41159 INT INTEGER 0 0 9 SchemaCode Discount Schema Code      
SM41160 DATETIME DATE 0 0 8 DateDiscount Date Discount      
SM41161 NCHAR STRING 6 0 6 ContractStructLineNo Contract Sub-line Number      
SM41162 INT INTEGER 0 0 9 CalendarColRef Calendar Collection      
SM41163 NCHAR STRING 38 0 38 BOMConfigID BOM Configuration ID      
SM41164 NCHAR STRING 38 0 38 BOMNodeID BOM Node ID      
SM41165 NCHAR STRING 30 0 30 LinkedProjectActivity Linked Project Number      
SM41166 NCHAR SWITCH 1 0 1 FLAGElectronicorder Electronic Order      
SM41167 INT INTEGER 0 0 1 FLAGDocXMLQuote XML/EDI Quotation Status      
SM41168 INT INTEGER 0 0 1 FLAGDocXMLConf XML/EDI Confirmation Status      
SM41169 INT INTEGER 0 0 1 FLAGDocXMLSO XML/EDI Service Order Status      
SM41170 INT INTEGER 0 0 1 FLAGDocXMLMatPickNoteLoc XML/EDI Picking List Local Status      
SM41171 INT INTEGER 0 0 1 FLAGDocXMLTransport XML/EDI Transport Document Status      
SM41172 INT INTEGER 0 0 1 FLAGDocXMLExport XML/EDI Export Document Status      
SM41173 INT INTEGER 0 0 1 FLAGDocXMLDeliveryNote XML/EDI Delivery Note 1 Status      
SM41174 INT INTEGER 0 0 1 FLAGDocXMLSubSuppDelivNote XML/EDI Sub-Supplier Delivery Note Status      
SM41175 INT INTEGER 0 0 1 FLAGDocXMLUser1 XML/EDI User Document 1 Status      
SM41176 INT INTEGER 0 0 1 FLAGDocXMLUser2 XML/EDI User Document 2 Status      
SM41177 INT INTEGER 0 0 1 FLAGDocXMLUser3 XML/EDI User Document 3 Status      
SM41178 INT INTEGER 0 0 1 FLAGDocXMLCustDelivNote XML/EDI Delivery Note 2 Status      
SM41179 INT INTEGER 0 0 1 FLAGDocXMLMatPickNoteExt XML/EDI Picking List External Status      
SM41180 INT INTEGER 0 0 1 FLAGDocXMLReturnNote XML/EDI Return Note Status      
SM41181 INT INTEGER 0 0 1 FLAGDocXMLProforma XML/EDI Proforma Status      
SM41182 INT INTEGER 0 0 1 FLAGDocXMLEttikets XML/EDI Labels Status      
SM41183 INT INTEGER 0 0 1 FLAGDocXMLCustDelivNote3 XML/EDI Delivery Note 3 Status      
SM41184 NCHAR STRING 10 0 10 VersionNumber BOM Configuration Version      
SM41185 NCHAR SWITCH 1 0 1 FlagForwardCover Flag Forward Cover      
SM41186 NUMERIC X_NUMERIC 23 8 15 FwdCoverExchRate Forward Cover Exchange rate      
SM41187 NVARCHAR VSTRING 15 0 15 FwdCoverRef Forward Cover Reference      
SM41188 NCHAR STRING 2 0 2 CurrCodeForCurrClause Currency Code Currency Clause      
SM41189 DATETIME DATE 0 0 8 CurrencyClauseStartDate Currency Clause Start Date      
SM41190 DATETIME DATE 0 0 8 CurrencyClauseEndDate Currency clause End Date      
SM41191 NUMERIC X_NUMERIC 23 8 15 ForwardCoverExchangeRate2 Forward Cover Exchange Rate 2      
SM41192 NCHAR STRING 3 0 3 ForwardCoverExchangeRateAlgorithm Forward Cover Exchange Rate Algorithm      
SM41193 INT INTEGER 0 0 1 DocSpecHrs Documents Specification Hours 0 — The sum of work, cost and material is printed as a single total amount

1 — All activity lines are printed as a single total amount.

2 — Each activity transaction is printed on the document		    
SM41194 INT INTEGER 0 0 1 DocSpecCost Documents Specification Costs 1 — All cost lines are printed as a single total amount.

2 — Each cost transaction is printed on the document		    
SM41195 INT INTEGER 0 0 1 DocSpecMat Documents Specification Material 1 — All material lines are printed as a single total amount.

2 — Each material transaction is printed on the document		    
SM41196 NCHAR SWITCH 1 0 1 ConsolidDSDelivery Consolidate DS Delivery      
SM41197 NCHAR STRING 10 0 10 ValueComponentNo Value Component No      
SM41198 NCHAR STRING 1 0 1 CommissionDistributionMethod Commission Distribution Method      
SM41199 NCHAR SWITCH 1 0 1 ExecutionOrderFlag Execution Order flag      
SM41200 INT INTEGER 0 0 4 WCMaintenanceTaskID WC Maintenance Task ID      
SM41201 NCHAR STRING 2 0 2 PMCounterQtyType PM Counter Qty Type      
SM41202 INT INTEGER 0 0 1 DeliveryNoteSortOrder Delivery Note Sort Order      
SM41203 NCHAR SWITCH 1 0 1 PrintDNAtPickConfirm Print Delivery Note at picking confirmation      
SM41204 NCHAR SWITCH 1 0 1 SendDNPickConfirm Send Delivery Note at picking confirmation      
SM41205 INT INTEGER 0 0 1 DeliveryBlocked Delivery blocked      
SM41206 NVARCHAR VSTRING 200 0 200 EmailAddress E-Mail Address      
SM41207 NVARCHAR VSTRING 1 0 1 PartialDeliveryPlanning Partial Delivery Planning 0 – allowed

1 – prohibited		    
SM41208 INT INTEGER 0 0 1 CustomerForPricing Customer for pricing      
SM41209 NCHAR SWITCH 1 0 1 CreditCheckPassed Credit Check Passed      
SM41210 NVARCHAR VSTRING 36 0 36 ExternalID External ID      
SM41211 NCHAR SWITCH 1 0 1 Red Storno Default Red Storno Default      
SM41212 NCHAR STRING 6 0 6 InvPlanLineNo InvPlanLineNo   3 Да / Yes
SM41213 NVARCHAR VSTRING 20 0 20 Public Procurement Code 1 Public Procurement Code 1      
SM41214 NVARCHAR VSTRING 20 0 20 Public Procurement Code 2 Public Procurement Code 2      

Навигация / Navigation: