пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / 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 SM01 — Service Order Master Table

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SM01001 NCHAR STRING 10 0 10 ServiceOrdNo Service Order Number   1 Да / Yes
SM01002 NCHAR STRING 10 0 10 CustCodeInv Customer Code Invoice      
SM01003 NCHAR STRING 10 0 10 CustCodeServ Customer Code Service      
SM01004 NVARCHAR VSTRING 35 0 35 CustomerRef Customer Reference      
SM01005 NCHAR STRING 20 0 20 CustomerPONo Customer Purchase Order Number      
SM01006 NCHAR STRING 35 0 35 ObjStockCode Service Object      
SM01007 NCHAR STRING 20 0 20 ObjSerialNo Service Object Serial Number      
SM01008 NVARCHAR VSTRING 25 0 25 ObjectDescr1 Service Object Description Line 1      
SM01009 NVARCHAR VSTRING 25 0 25 ObjectDescr2 Service Object Description Line 2      
SM01010 NCHAR STRING 10 0 10 ObjMaintContNo Service Object Contract      
SM01011 NVARCHAR VSTRING 70 0 70 ServiceReq1 Text Line 1      
SM01012 NVARCHAR VSTRING 70 0 70 ServiceReq2 Text Line 2      
SM01013 NVARCHAR VSTRING 70 0 70 ServiceReq3 Text Line 3      
SM01014 NVARCHAR VSTRING 70 0 70 ServiceReq4 Text Line 4      
SM01015 NVARCHAR VSTRING 35 0 35 OurReference Our Reference      
SM01016 NCHAR STRING 10 0 10 FieldEngineer Resource Code Engineer      
SM01017 DATETIME DATE 0 0 8 CALLETADate Service Call ETA Date      
SM01018 NUMERIC X_NUMERIC 13 8 5 CALLETATime Service Call ETA Time      
SM01019 DATETIME DATE 0 0 8 CALLETRDate Service Call ETR Date      
SM01020 NUMERIC X_NUMERIC 13 8 5 CALLETRTime Service Call ETR Time      
SM01021 DATETIME DATE 0 0 8 CALLLOGEDDt Service Call Date Logged      
SM01022 NUMERIC X_NUMERIC 13 8 5 CALLLOGEDTime Service Call Time Logged      
SM01023 DATETIME DATE 0 0 8 CALLOPENDate Service Call Date Opened      
SM01024 NUMERIC X_NUMERIC 13 8 5 CALLOPENTime Service Call Time Opened      
SM01025 DATETIME DATE 0 0 8 CALLCOMPLDate Service Call Date Committed      
SM01026 NUMERIC X_NUMERIC 13 8 5 CALLCOMPLTime Service Call Time Committed      
SM01027 DATETIME DATE 0 0 8 CALLCLOSEDt Service Call Date Closed      
SM01028 NUMERIC X_NUMERIC 13 8 5 CALLCLOSETime Service Call Time Closed      
SM01029 NCHAR STRING 4 0 4 ProPriGroCode Product Price Group Code      
SM01030 NUMERIC MONEY 28 8 20 FixPriceHrs (obsolete)      
SM01031 NUMERIC MONEY 28 8 20 FixPriceCst (obsolete)      
SM01032 NUMERIC MONEY 28 8 20 FixPriceMat (obsolete)      
SM01033 INT INTEGER 0 0 1 InvSpecHours (obsolete)      
SM01034 INT INTEGER 0 0 1 InvSpecCosts (obsolete)      
SM01035 INT INTEGER 0 0 1 InvSpecMat (obsolete)      
SM01036 NCHAR STRING 2 0 2 PaymentTerm (obsolete)      
SM01037 DATETIME DATE 0 0 8 InvoiceDate Last Invoice Date      
SM01038 NCHAR STRING 15 0 15 InvoiceNo Last Invoice Number      
SM01039 INT INTEGER 0 0 1 InteStatFlag Quotation State 0 — The Service Order is in Order State

1 — The Service Order is in Quotation State
   
SM01040 INT INTEGER 0 0 1 DOCFLAGQuotation Quotation Print Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01041 INT INTEGER 0 0 1 DOCFLAGConfirm Confirmation Print Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01042 INT INTEGER 0 0 1 DOCFLAGSrvOrder Service Order Print Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01043 INT INTEGER 0 0 1 InvUpdStatus (obsolete)      
SM01044 NVARCHAR VSTRING 3 0 3 LanguageCode Language      
SM01045 NCHAR STRING 1 0 1 DocmntLayout Document Layout      
SM01046 INT INTEGER 0 0 1 EngnPagingFlag Engineer Paging Status      
SM01047 INT INTEGER 0 0 1 InvMergeOption Invoice Merge Option Invoice merge option (invoices will be consolidated in sales ledger).

0 — No consolidated invoice

1 — Consolidate invoice per week

2 — Consolidate invoice per month
   
SM01048 NUMERIC MONEY 28 8 20 HandlingFee (obsolete)      
SM01049 NCHAR STRING 2 0 2 CurrencyCode Currency Code Order      
SM01050 NCHAR STRING 2 0 2 Pricelist (obsolete)      
SM01051 NCHAR STRING 6 0 6 WareHouse Warehouse      
SM01052 DATETIME DATE 0 0 8 BookEntryDate Book-Entry Date      
SM01053 NCHAR STRING 1 0 1 CurrencyClause Currency Compensation      
SM01054 NCHAR STRING 1 0 1 CurrencyContract Currency Contract      
SM01055 NCHAR STRING 1 0 1 StkToolWCHR Service Object Type A — Asset

B — BOM Configuration

C — Training Course

H — Resource

N — No service object

S — Stock Item

T — MPC Tool

W — Work Centre
   
SM01056 INT INTEGER 0 0 2 EDITransmCnt EDI Sent Counter      
SM01057 INT INTEGER 0 0 2 EDIReceivCnt EDI Received Counter      
SM01058 NCHAR SWITCH 1 0 1 EDIFlag1 EDI Document 1 Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01059 NCHAR SWITCH 1 0 1 EDIFlag2 EDI Document 2 Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01060 NCHAR SWITCH 1 0 1 EDIFlag3 EDI Document 3 Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01061 NCHAR SWITCH 1 0 1 EDIFlag4 EDI Document 4 Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01062 NCHAR SWITCH 1 0 1 PriorityFlg1 Service Order Priority      
SM01063 NCHAR SWITCH 1 0 1 PriorityFlg2 Weighted Priority      
SM01064 NCHAR STRING 2 0 2 OrderStatus Order Status      
SM01065 NCHAR STRING 3 0 3 MaintenaCode Contract Type      
SM01066 NCHAR SWITCH 1 0 1 LetterOfCredit Letter of Credit      
SM01067 DATETIME DATE 0 0 8 LCOpenDate Letter of Credit Open Date      
SM01068 DATETIME DATE 0 0 8 LCDueDate Letter of Credit Due Date      
SM01069 NVARCHAR VSTRING 20 0 20 LCReference Letter of Credit Reference      
SM01070 NCHAR SWITCH 1 0 1 GenerPIATrans Generate WIP Transactions      
SM01071 NCHAR STRING 4 0 4 CustSiteNo Site Code      
SM01072 DATETIME DATE 0 0 8 CALLATADate Service Call ATA Date      
SM01073 NUMERIC X_NUMERIC 13 8 5 CALLATATime Service Call ATA Time      
SM01074 DATETIME DATE 0 0 8 MaterialDate Material Date      
SM01075 NUMERIC X_NUMERIC 13 8 5 MaterialTime Material Time      
SM01076 NCHAR STRING 4 0 4 IncidentCode Incident Code      
SM01077 NCHAR STRING 15 0 15 AnalysisCode Analysis Code      
SM01078 NCHAR STRING 10 0 10 MasterServOrder Master Service Order Number      
SM01079 INT INTEGER 0 0 1 OrderStruStatus Order Structure Status      
SM01080 INT INTEGER 0 0 1 DOCFLAGPckNo Picking List Local Print Status Document status for internal material picking list:

0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01081 INT INTEGER 0 0 1 DOCFLAGTrans Transport Document Print Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01082 INT INTEGER 0 0 1 DOCFLAGExport Export Document Print Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01083 INT INTEGER 0 0 1 DOCFLAGProformInv Proforma Invoice Print Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01084 NCHAR STRING 15 0 15 ExtSrvStaCode Extended Service Statistic Code      
SM01085 NCHAR STRING 20 0 20 DeliveryNotNo Delivery Note Number      
SM01086 NCHAR STRING 2 0 2 DeliveryCode Delivery Terms      
SM01087 NCHAR STRING 2 0 2 DeliveryMethod Delivery Method      
SM01088 INT INTEGER 0 0 1 DOCFLDeliNot Delivery Note 1 Print Status Document status for customer delivery note 1:

0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01089 INT INTEGER 0 0 1 DOCFLSubsuppler Sub-Supplier Delivery Note Print Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01090 INT INTEGER 0 0 1 DOCFLFridok1 User Document 1 Print Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01091 INT INTEGER 0 0 1 DOCFLFridok2 User Document 2 Print Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01092 INT INTEGER 0 0 1 DOCFLFridok3 User Document 3 Print Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01093 INT INTEGER 0 0 1 DOCFLCustDel Delivery Note 2 Print Status Document status for customer delivery note 2:

0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01094 NCHAR SWITCH 1 0 1 MastOrdPrint Master Order Printing 1 — The serviced item belong to a master order and can not be delivered with customer delivery note before all orders are closed.

0 — The serviced item can be delivered when closed.
   
SM01095 DATETIME DATE 0 0 8 SerNoDelDate Serial Number Delivery Date      
SM01096 DATETIME DATE 0 0 8 SerNoWarrExp Serial Number Warranty Expire Date      
SM01097 NCHAR STRING 6 0 6 OrderType Order Type      
SM01098 NUMERIC X_NUMERIC 20 8 12 PlannedHours Planned Hours      
SM01099 NCHAR STRING 35 0 35 SwapArtNo Swap Stock Item      
SM01100 NVARCHAR VSTRING 25 0 25 SwapDescr1 Swap Stock Item Description Line 1      
SM01101 NVARCHAR VSTRING 25 0 25 SwapDescr2 Swap Stock Item Description Line 2      
SM01102 NCHAR STRING 20 0 20 SwapSerieNo Swap Serial Number      
SM01103 INT INTEGER 0 0 1 PickinglCenter Picking List External Print Status Document status for external material picking list:

0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01104 INT INTEGER 0 0 1 ReturnNote Return Note Print Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01105 INT INTEGER 0 0 1 Proforma Proforma Print Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01106 INT INTEGER 0 0 1 Ettikes Labels Print Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01107 INT INTEGER 0 0 1 CustDelNote Delivery Note 3 Print Status Document status for customer delivery note 3:

0 — Document not ready for printing

1 — Print document

2 — Document sent
   
SM01108 NCHAR STRING 14 0 14 StatistCode Statistical Code Extended      
SM01109 NUMERIC MONEY 28 8 20 StatistValue Statistical Value (Local Currency) The unit price of the service object (only for stock items)    
SM01110 NCHAR STRING 3 0 3 SalesmanOrder Salesman      
SM01111 NCHAR STRING 3 0 3 SalesmanInvoicer Salesman Invoice Manager      
SM01112 NCHAR STRING 4 0 4 ObjPriceGroup Product Group as Price Group      
SM01113 NVARCHAR ACCSTR 50 0 50 AccString Accounting String      
SM01114 DATETIME DATE 0 0 8 STATUSDate Status Date      
SM01115 NUMERIC X_NUMERIC 13 8 5 STATUSTime Status Time      
SM01116 NVARCHAR VSTRING 20 0 20 STATUSTEXT Status Text      
SM01117 NUMERIC X_NUMERIC 20 8 12 RespTimeCont Response Time Contract      
SM01118 NCHAR STRING 10 0 10 CustContrGar Customer Code Internal for Contract and Warranty      
SM01119 NCHAR STRING 2 0 2 PriclCntrGar Price List for Contract and Warranty      
SM01120 NCHAR STRING 10 0 10 CustomerCntr (obsolete)      
SM01121 NCHAR STRING 6 0 6 WIPWHGood WIP Warehouse      
SM01122 NCHAR STRING 6 0 6 WIPBinGood WIP Bin      
SM01123 NCHAR STRING 6 0 6 WIPDACode WIP Delivery Address Code      
SM01124 DATETIME DATE 0 0 8 ExchangeDate Currency Exchange Date      
SM01125 NUMERIC X_NUMERIC 13 8 5 Spare (obsolete)      
SM01126 NUMERIC X_NUMERIC 20 8 12 RespTimePhone Call Back Response Time      
SM01127 INT INTEGER 0 0 1 WIPDACtype WIP Delivery Address Code Type 0 — Delivery Warehouse

1 — Installation Address (Site)

2 — Internal Customer

3 — Delivery Address (Temporary)
   
SM01128 NCHAR STRING 4 0 4 InteEscaCode Internal Escalation Code      
SM01129 NCHAR STRING 20 0 20 TextRef Text Reference      
SM01130 DATETIME DATE 0 0 8 ETCDate ETC Date      
SM01131 NUMERIC X_NUMERIC 13 8 5 ETCTime ETC Time      
SM01132 INT INTEGER 0 0 1 CustStatus Invoice Customer Type 0 — Customer

1 — Contract

2 — Warranty
   
SM01133 NCHAR STRING 10 0 10 ReferenceNo Problem Code Reference      
SM01134 NUMERIC X_NUMERIC 20 8 12 Spare (obsolete)      
SM01135 NCHAR STRING 3 0 3 ExchangeAlgorithm Currency Exchange Algorithm      
SM01136 NCHAR STRING 2 0 2 Spare (obsolete)      
SM01137 NCHAR STRING 10 0 10 OrderedCustomerCode Customer Code Order      
SM01138 NVARCHAR VSTRING 3 0 3 SerNumWarType Serial number selected warranty type      
SM01139 NCHAR STRING 10 0 10 Spare Contract Line Number      
SM01140 NCHAR STRING 2 0 2 Spare (obsolete)      
SM01141 NUMERIC X_NUMERIC 20 8 12 MassRepairQty Quantity for Mass Repair      
SM01142 NUMERIC X_NUMERIC 15 8 7 OrderDiscPerc Order Discount %      
SM01143 NUMERIC X_NUMERIC 15 8 7 ExtComissPerc (obsolete)      
SM01144 NVARCHAR VSTRING 10 0 10 ExtComissText (obsolete)      
SM01145 NCHAR STRING 2 0 2 SOAccCode Accounting Code Service Order      
SM01146 NUMERIC X_NUMERIC 23 8 15 ExchangeRate1 Currency Exchange Rate 1      
SM01147 NUMERIC X_NUMERIC 23 8 15 ExchangeRate2 Exchange Rate 2      
SM01148 NUMERIC MONEY 28 8 20 FixPriceHoursLcu (obsolete)      
SM01149 NUMERIC MONEY 28 8 20 FixPriceCostsLcu (obsolete)      
SM01150 NUMERIC MONEY 28 8 20 FixPriceMatLcu (obsolete)      
SM01151 NUMERIC X_NUMERIC 23 8 15 FixedExchRate1 Fixed Exchange Rate 1      
SM01152 NUMERIC X_NUMERIC 23 8 15 FixedExchRate2 Fixed Exchange Rate 2      
SM01153 NCHAR STRING 3 0 3 FixesExchAlgorithm Fixed Exchange Algorithm      
SM01154 NVARCHAR VSTRING 15 0 15 CurrencyContractNr Currency Contract Number      
SM01155 NVARCHAR VSTRING 8 0 8 CampaignCode Campaign      
SM01156 NUMERIC X_NUMERIC 14 8 6 LimitForCurrClausePc Currency Compensation Limit %      
SM01157 NUMERIC X_NUMERIC 14 8 6 CompensationPer Currency Compensation %      
SM01158 NCHAR STRING 10 0 10 RequestNo Customer Request      
SM01159 INT INTEGER 0 0 9 SchemaCode Discount Schema Code      
SM01160 DATETIME DATE 0 0 8 DateDiscount Date Discount      
SM01161 NCHAR STRING 6 0 6 ContractStructLineNo Contract Sub-line Number      
SM01162 INT INTEGER 0 0 9 CalendarColRef Calendar Collection      
SM01163 NCHAR STRING 38 0 38 BOMConfigID BOM Configuration ID      
SM01164 NCHAR STRING 38 0 38 BOMNodeID BOM Node ID      
SM01165 NCHAR STRING 30 0 30 LinkedProjectActivity Linked Project Number      
SM01166 NCHAR SWITCH 1 0 1 FLAGElectronicOrder Electronic Order      
SM01167 INT INTEGER 0 0 1 FLAGDocXMLQuote XML/EDI Quotation Status      
SM01168 INT INTEGER 0 0 1 FLAGDocXMLConf XML/EDI Confirmation Status      
SM01169 INT INTEGER 0 0 1 FLAGDocXMLSO XML/EDI Service Order Status      
SM01170 INT INTEGER 0 0 1 FLAGDocXMLMatPickNoteLoc XML/EDI Picking List Local Status      
SM01171 INT INTEGER 0 0 1 FLAGDocXMLTransport XML/EDI Transport Document Status      
SM01172 INT INTEGER 0 0 1 FLAGDocXMLExport XML/EDI Export Document Status      
SM01173 INT INTEGER 0 0 1 FLAGDocXMLDeliveryNote XML/EDI Delivery Note 1 Status      
SM01174 INT INTEGER 0 0 1 FLAGDocXMLSubSuppDelivNote XML/EDI Sub-Supplier Delivery Note Status      
SM01175 INT INTEGER 0 0 1 FLAGDocXMLUser1 XML/EDI User Document 1 Status      
SM01176 INT INTEGER 0 0 1 FLAGDocXMLUser2 XML/EDI User Document 2 Status      
SM01177 INT INTEGER 0 0 1 FLAGDocXMLUser3 XML/EDI User Document 3 Status      
SM01178 INT INTEGER 0 0 1 FLAGDocXMLCustDelivNote XML/EDI Delivery Note 2 Status      
SM01179 INT INTEGER 0 0 1 FLAGDocXMLMatPickNoteExt XML/EDI Picking List External Status      
SM01180 INT INTEGER 0 0 1 FLAGDocXMLReturnNote XML/EDI Return Note Status      
SM01181 INT INTEGER 0 0 1 FLAGDocXMLProforma XML/EDI Proforma Status      
SM01182 INT INTEGER 0 0 1 FLAGDocXMLEttikets XML/EDI Labels Status      
SM01183 INT INTEGER 0 0 1 FLAGDocXMLCustDelivNote3 XML/EDI Delivery Note 3 Status      
SM01184 NCHAR STRING 10 0 10 BOMConfigurationVersion BOM Configuration Version      
SM01185 NCHAR SWITCH 1 0 1 FlagForwardCover Flag Forward Cover      
SM01186 NUMERIC X_NUMERIC 23 8 15 FwdCoverExchRate Forward Cover Exchange rate      
SM01187 NVARCHAR VSTRING 15 0 15 FwdCoverRef Forward Cover Reference      
SM01188 NCHAR STRING 2 0 2 CurrCodeForCurrClause Currency Code Currency Clause      
SM01189 DATETIME DATE 0 0 8 CurrencyClauseStartDate Currency Clause Start Date      
SM01190 DATETIME DATE 0 0 8 CurrencyClauseEndDate Currency clause End Date      
SM01191 NUMERIC X_NUMERIC 23 8 15 ForwardCoverExchangeRate2 Forward Cover Exchange Rate 2      
SM01192 NCHAR STRING 3 0 3 ForwardCoverExchangeRateAlgorithm Forward Cover Exchange Rate Algorithm      
SM01193 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
   
SM01194 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
   
SM01195 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
   
SM01196 NCHAR SWITCH 1 0 1 ConsolidDSDelivery Consolidate DS Delivery      
SM01197 NCHAR STRING 10 0 10 ValueComponentNo Value Component No      
SM01198 NCHAR STRING 1 0 1 CommissionDistributionMethod Commission Distribution Method      
SM01199 NCHAR SWITCH 1 0 1 ExecutionOrderFlag Execution Order flag      
SM01200 INT INTEGER 0 0 4 WCMaintenanceTaskID WC Maintenance Task ID      
SM01201 NCHAR STRING 2 0 2 PMCounterQtyType PM Counter Qty Type      
SM01202 INT INTEGER 0 0 1 DeliveryNoteSortOrder Delivery Note Sort Order      
SM01203 NCHAR SWITCH 1 0 1 PrintDNAtPickConfirm Print Delivery Note at picking confirmation      
SM01204 NCHAR SWITCH 1 0 1 SendDNPickConfirm Send Delivery Note at picking confirmation      
SM01205 INT INTEGER 0 0 1 DeliveryBlocked Delivery blocked      
SM01206 NVARCHAR VSTRING 200 0 200 EmailAddress E-Mail Address      
SM01207 NVARCHAR VSTRING 1 0 1 PartialDeliveryPlanning Partial Delivery Planning 0 – allowed

1 – prohibited
   
SM01208 INT INTEGER 0 0 1 CustomerForPricing Customer for pricing      
SM01209 NCHAR SWITCH 1 0 1 CreditCheckPassed Credit Check Passed      
SM01210 NVARCHAR VSTRING 36 0 36 ExternalID External ID      
SM01211 NCHAR SWITCH 1 0 1 Red Storno Default Red Storno Default      
SM01212 NCHAR STRING 6 0 6 InvPlanLineNo InvPlanLineNo      
SM01213 NVARCHAR VSTRING 20 0 20 Public Procurement Code 1 Public Procurement Code 1      
SM01214 NVARCHAR VSTRING 20 0 20 Public Procurement Code 2 Public Procurement Code 2      

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