пользователям программных продуктов 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 SM03 — Service Order Activity Lines

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

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

5 — Linked picture

9 — Text line
   
SM03004 NCHAR STRING 8 0 8 ActivityCode Activity Code      
SM03005 NVARCHAR VSTRING 35 0 35 Description Description      
SM03006 NCHAR STRING 10 0 10 FldEngineer Resource Code Engineer      
SM03007 NUMERIC X_NUMERIC 20 8 12 PlannedHours Hours Planned      
SM03008 NUMERIC X_NUMERIC 20 8 12 ActualHours Hours Actual      
SM03009 NUMERIC MONEY 28 8 20 SPARE SPARE      
SM03010 NUMERIC MONEY 28 8 20 SPARE SPARE      
SM03011 NUMERIC MONEY 28 8 20 BudgCostLCU Unit Cost Planned (Local Currency)      
SM03012 NUMERIC MONEY 28 8 20 ActuaCostLCU Unit Cost Actual (Local Currency)      
SM03013 NCHAR STRING 4 0 4 Spare (obsolete)      
SM03014 NUMERIC MONEY 28 8 20 ProposInvAmoOcu Unit Price Proposed for Invoice (Invoice Currency)      
SM03015 NUMERIC MONEY 28 8 20 ActualInvAmoOcu Unit Price Actual Invoiced (Invoice Currency)      
SM03016 NCHAR STRING 6 0 6 VATCode1 VAT Code 1      
SM03017 NCHAR STRING 2 0 2 AccountCode Accounting Code      
SM03018 NCHAR STRING 6 0 6 CostType Cost Category      
SM03019 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
   
SM03020 NCHAR STRING 6 0 6 Spare (obsolete)      
SM03021 NCHAR SWITCH 1 0 1 IncludFixPr Included in Fixed Price      
SM03022 NCHAR STRING 10 0 10 CustCodeInv Customer Code Invoice      
SM03023 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
SM03024 NCHAR STRING 15 0 15 InvoiceNo Invoice Number      
SM03025 NUMERIC MONEY 28 8 20 PlannedPriceOCU Unit Price Planned (Order Currency)      
SM03026 DATETIME DATE 0 0 8 TransactDate Transaction Date      
SM03027 NUMERIC X_NUMERIC 15 8 7 DiscountLabour Discount %      
SM03028 NUMERIC X_NUMERIC 20 8 12 HoursInvoice Hours to Invoiced      
SM03029 NCHAR STRING 2 0 2 PricelistNo Price List      
SM03030 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
   
SM03031 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.
   
SM03032 NCHAR STRING 2 0 2 Spare (obsolete)      
SM03033 NCHAR STRING 8 0 8 PriceTabell Price Table      
SM03034 NVARCHAR ACCSTR 50 0 50 AccString Accounting String      
SM03035 NCHAR STRING 6 0 6 VATCode2 VAT Code 2      
SM03036 DATETIME DATE 0 0 8 ActivStrDate Planned Start Date      
SM03037 NUMERIC X_NUMERIC 13 8 5 ActivStrTime Planned Start Time      
SM03038 DATETIME DATE 0 0 8 ActivEndDate Planned End Date      
SM03039 NUMERIC X_NUMERIC 13 8 5 ActivEndTime Planned End Time      
SM03040 INT INTEGER 0 0 1 IncludedInCurrencyClause Include in Currency Clause      
SM03041 NCHAR STRING 2 0 2 OrderCurrencyCode Currency Code Order      
SM03042 NUMERIC X_NUMERIC 28 8 20 CurrExchRate Currency Exchange Rate      
SM03043 NUMERIC MONEY 28 8 20 SPARE SPARE      
SM03044 NUMERIC MONEY 28 8 20 ActualPriceOCU Unit Price Actual (Order Currency)      
SM03045 NUMERIC MONEY 28 8 20 SPARE SPARE      
SM03046 NUMERIC MONEY 28 8 20 PropInvAmountIcu Unit Price Proposed for Invoice (Order Currency)      
SM03047 NUMERIC MONEY 28 8 20 PropInvAmountLcu Unit Price Proposed for Invoice (Local Currency)      
SM03048 NUMERIC MONEY 28 8 20 ActInvAmountIcu Unit Price Actual Invoiced (Order Currency)      
SM03049 NUMERIC MONEY 28 8 20 ActInvAmountLCU Unit Price Actual Invoiced (Local Currency)      
SM03050 NCHAR STRING 2 0 2 InvoiceCurrency Currency Code Invoice      
SM03051 NCHAR SWITCH 1 0 1 StatusSwitch0 Line Status 1      
SM03052 NCHAR SWITCH 1 0 1 StatusSwitch1 Line Status 2      
SM03053 NCHAR SWITCH 1 0 1 StatusSwitch2 Line Status 3      
SM03054 NCHAR SWITCH 1 0 1 StatusSwitch3 Line Status 4      
SM03055 NCHAR SWITCH 1 0 1 StatusSwitch4 Line Status 5      
SM03056 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
   
SM03057 DATETIME DATE 0 0 8 ActualStartDate Actual Start Date      
SM03058 NUMERIC X_NUMERIC 13 8 5 ActualStrTime Actual Start Time      
SM03059 DATETIME DATE 0 0 8 ActualEndDate Actual End Date      
SM03060 NUMERIC X_NUMERIC 13 8 5 ActualEndTime Actual End Time      
SM03061 NCHAR STRING 150 0 150 Predecessors Predecessors MS Project Reserved for use when integrating with MS project    
SM03062 NCHAR STRING 6 0 6 JobNo Job Number      
SM03063 NCHAR STRING 10 0 10 CheckListID Check List ID      
SM03064 NCHAR SWITCH 1 0 1 FlagCreatedbyJobOrder Was Created from Job      
SM03065 NCHAR SWITCH 1 0 1 UseCustomICURate Use Custom Invoice Currency Rate      
SM03066 NUMERIC X_NUMERIC 23 8 15 CustomICURate Custom Invoice Currency Exchange Rate 1      
SM03067 NUMERIC X_NUMERIC 23 8 15 CustomICUExchRate2 Custom Invoice Currency Exchange Rate 2      
SM03068 NCHAR STRING 3 0 3 CustomICUExchRateAlg Custom Invoice Currency Exchange Rate Algorithm      
SM03069 NVARCHAR VSTRING 10 0 10 OperationTypeTime Operation Type Time      
SM03070 NVARCHAR VSTRING 10 0 10 FinancialOperationCodeTime Financial Operation CodeTime      
SM03071 NVARCHAR VSTRING 36 0 36 LineGUID Line GUID      
SM03072 NVARCHAR VSTRING 6 0 6 LineGroup Line Group      
SM03073 INT INTEGER 0 0 9 JobID JobID      
SM03074 NVARCHAR VSTRING 20 0 20 DelivNoteNo Delivery Note Number      
SM03075 INT INTEGER 0 0 1 DeliveryBlocked Delivery blocked      
SM03076 NCHAR SWITCH 1 0 1 ApprovedCreditLimit Approved Credit Limit      
SM03077 DATETIME DATE 0 0 8 ConfirmedArrivalDate Confirmed Arrival Date Confirmed Arrival Date — ‘Delivery Confirmation’ functionality    
SM03078 NCHAR STRING 6 0 6 InvPlanLineNo InvPlanLineNo      
SM03079 NCHAR STRING 3 0 3 Taxation Reason Code Taxation Reason Code      

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