Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...

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

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table SM43 — Service Order Activity Lines History

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SM43001 NCHAR STRING 10 0 10 ServOrderNo Service Order Number   1 Да / Yes
SM43002 NCHAR STRING 4 0 4 ItemNo Order Line Number   2 Да / Yes
SM43003 NCHAR STRING 1 0 1 LineType Line Type 0 — Normal activity line

5 — Linked picture

9 — Text line
   
SM43004 NCHAR STRING 8 0 8 ActivityCode Activity Code      
SM43005 NVARCHAR VSTRING 35 0 35 Description Description      
SM43006 NCHAR STRING 10 0 10 FldEngineer Resource Code Engineer      
SM43007 NUMERIC X_NUMERIC 20 8 12 PlannedHours Hours Planned      
SM43008 NUMERIC X_NUMERIC 20 8 12 ActualHours Hours Actual      
SM43009 NUMERIC MONEY 28 8 20 SPARE SPARE      
SM43010 NUMERIC MONEY 28 8 20 SPARE SPARE      
SM43011 NUMERIC MONEY 28 8 20 BudgCostLCU Unit Cost Planned (Local Currency)      
SM43012 NUMERIC MONEY 28 8 20 ActuaCostLCU Unit Cost Actual (Local Currency)      
SM43013 NCHAR STRING 4 0 4 Spare (obsolete)      
SM43014 NUMERIC MONEY 28 8 20 ProposInvAmoOcu Unit Price Proposed for Invoice (Invoice Currency)      
SM43015 NUMERIC MONEY 28 8 20 ActualInvAmoOcu Unit Price Actual Invoiced (Invoice Currency)      
SM43016 NCHAR STRING 6 0 6 VATCode1 VAT Code 1      
SM43017 NCHAR STRING 2 0 2 AccountCode Accounting Code      
SM43018 NCHAR STRING 6 0 6 CostType Cost Category      
SM43019 NCHAR STRING 6 0 6 CoveredByContract Covered By Contract 0 — The activity line is not covered by any contract

1 — The activity line is covered be a contract and will not be charged to the customer
   
SM43020 NCHAR STRING 6 0 6 Spare (obsolete)      
SM43021 NCHAR SWITCH 1 0 1 IncludFixPr Included in Fixed Price      
SM43022 NCHAR STRING 10 0 10 CustCodeInv Customer Code Invoice      
SM43023 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
SM43024 NCHAR STRING 15 0 15 InvoiceNo Invoice Number   3 Да / Yes
SM43025 NUMERIC MONEY 28 8 20 PlannedPriceOCU Unit Price Planned (Order Currency)      
SM43026 DATETIME DATE 0 0 8 TransactDate Transaction Date      
SM43027 NUMERIC X_NUMERIC 15 8 7 DiscountLabour Discount %      
SM43028 NUMERIC X_NUMERIC 20 8 12 HoursInvoice Hours to Invoiced      
SM43029 NCHAR STRING 2 0 2 PricelistNo Price List      
SM43030 NCHAR SWITCH 1 0 1 ChangeCustomer Calculate Price Option used internally to indicate if price needs to be recalculated on the activity line.

1 — The price on the activity line has not been recalculated after change of customer

2 — The price on the activity line has already been calculated for the customer on the order line
   
SM43031 INT INTEGER 0 0 1 InvUpdStat Invoice Status 0/1 — The line has not been sent on a invoice

2 — The activity line has been sent/included in a invoice.
   
SM43032 NCHAR STRING 2 0 2 Spare (obsolete)      
SM43033 NCHAR STRING 8 0 8 PriceTabell Price Table      
SM43034 NVARCHAR ACCSTR 120 0 120 AccString Accounting String      
SM43035 NCHAR STRING 6 0 6 VATCode2 VAT Code 2      
SM43036 DATETIME DATE 0 0 8 ActivStrDate Planned Start Date      
SM43037 NUMERIC X_NUMERIC 13 8 5 ActivStrTime Planned Start Time      
SM43038 DATETIME DATE 0 0 8 ActivEndDate Planned End Date      
SM43039 NUMERIC X_NUMERIC 13 8 5 ActivEndTime Planned End Time      
SM43040 INT INTEGER 0 0 1 IncludedInCurrencyClause Included in Currency Clause      
SM43041 NCHAR STRING 2 0 2 OrderCurrencyCode Currency Code Order      
SM43042 NUMERIC X_NUMERIC 28 8 20 CurrExchRate Currency Exchange Rate      
SM43043 NUMERIC MONEY 28 8 20 SPARE SPARE      
SM43044 NUMERIC MONEY 28 8 20 ActualPriceOCU Unit Price Actual (Order Currency)      
SM43045 NUMERIC MONEY 28 8 20 SPARE SPARE      
SM43046 NUMERIC MONEY 28 8 20 PropInvAmountIcu Unit Price Proposed for Invoice (Order Currency)      
SM43047 NUMERIC MONEY 28 8 20 PropInvAmountLcu Unit Price Proposed for Invoice (Local Currency)      
SM43048 NUMERIC MONEY 28 8 20 ActInvAmountIcu Unit Price Actual Invoiced (Order Currency)      
SM43049 NUMERIC MONEY 28 8 20 ActInvAmountLCU Unit Price Actual Invoiced (Local Currency)      
SM43050 NCHAR STRING 2 0 2 InvoiceCurrency Currency Code Invoice      
SM43051 NCHAR SWITCH 1 0 1 StatusSwitch0 Line Status 1      
SM43052 NCHAR SWITCH 1 0 1 StatusSwitch1 Line Status 2      
SM43053 NCHAR SWITCH 1 0 1 StatusSwitch2 Line Status 3      
SM43054 NCHAR SWITCH 1 0 1 StatusSwitch3 Line Status 4      
SM43055 NCHAR SWITCH 1 0 1 StatusSwitch4 Line Status 5      
SM43056 NCHAR SWITCH 1 0 1 StatusSwitch5 Marked for Invoice Applies only to long term order:

0 — The activity line is not marked as ready for invoice

1 — The activity line is ready for invoice
   
SM43057 DATETIME DATE 0 0 8 ActualStartDate Actual Start Date      
SM43058 NUMERIC X_NUMERIC 13 8 5 ActualStrTime Actual Start Time      
SM43059 DATETIME DATE 0 0 8 ActualEndDate Actual End Date      
SM43060 NUMERIC X_NUMERIC 13 8 5 ActualEndTime Actual End Time      
SM43061 NCHAR STRING 150 0 150 Predecessors Predecessors MS Project Reserved for use when integrating with MS project    
SM43062 NCHAR STRING 6 0 6 JobNo Job Number      
SM43063 NCHAR STRING 10 0 10 CheckLineID Check List ID      
SM43064 NCHAR SWITCH 1 0 1 FlagCreatedByJob Was Created from Job      
SM43065 NCHAR SWITCH 1 0 1 CustomICURate Use Custom Invoice Currency Rate      
SM43066 NUMERIC X_NUMERIC 23 8 15 CustomICUExchRate1 Custom Invoice Currency Exchange Rate 1      
SM43067 NUMERIC X_NUMERIC 23 8 15 CustomICUExchRate2 Custom Invoice Currency Exchange Rate 2      
SM43068 NCHAR STRING 3 0 3 CustomICUExchRateAlg Custom Invoice Currency Exchange Rate Algorithm      
SM43069 NVARCHAR VSTRING 10 0 10 OperationTypeTime Operation Type Time      
SM43070 NVARCHAR VSTRING 10 0 10 FinancialOperationCodeTime Financial Operation Code Time      
SM43071 NVARCHAR VSTRING 36 0 36 LineGUID Line GUID      
SM43072 NVARCHAR VSTRING 6 0 6 LineGroup Line Group      
SM43073 INT INTEGER 0 0 9 JobID Job ID      
SM43074 NVARCHAR VSTRING 20 0 20 DelivNoteNo Delivery Note Number      
SM43075 INT INTEGER 0 0 1 DeliveryBlocked Delivery blocked      
SM43076 NCHAR SWITCH 1 0 1 ApprovedCreditLimit Approved Credit Limit      
SM43077 DATETIME DATE 0 0 8 ConfirmedArrivalDate Confirmed Arrival Date Confirmed Arrival Date — ‘Delivery Confirmation’ functionality    
SM43078 NCHAR STRING 6 0 6 InvPlanLineNo InvPlanLineNo   4 Да / Yes
SM43079 NCHAR STRING 3 0 3 TaxationReasonCode Taxation Reason Code      

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