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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SM43001 NCHAR STRING 10 0 10 ServOrderNo Service Order Number   1 Да
SM43002 NCHAR STRING 4 0 4 ItemNo Order Line Number   2 Да
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 25 0 25 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 PlannedAmntOcu Unit Price Planned (Invoice Currency)      
SM43010 NUMERIC MONEY 28 8 20 ActualAmntOcu Unit Price Actual (Invoice Currency)      
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 Да
SM43025 NUMERIC MONEY 28 8 20 PlannedAmountICU 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 50 0 50 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 PlannedAmountLcu Unit Price Planned (Local Currency)      
SM43044 NUMERIC MONEY 28 8 20 ActualAmountICU Unit Price Actual (Order Currency)      
SM43045 NUMERIC MONEY 28 8 20 ActualAmountLCU Unit Price Actual (Local Currency)      
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 ActualStrTime 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 Flag_CreatedByJob Was Created from Job      
SM43065 NCHAR SWITCH 1 0 1 Flag Custom ICU rate Use Custom Invoice Currency Rate      
SM43066 NUMERIC X_NUMERIC 23 8 15 Custom ICU rate Custom Invoice Currency Exchange Rate 1      
SM43067 NUMERIC X_NUMERIC 23 8 15 Custom ICU Exchange Rate 2 Custom Invoice Currency Exchange Rate 2      
SM43068 NCHAR STRING 3 0 3 Custom ICU Exchange Rate Algorithm Custom Invoice Currency Exchange Rate Algorithm      
SM43069 NVARCHAR VSTRING 10 0 10 Operation Type Time Operation Type Time      
SM43070 NVARCHAR VSTRING 10 0 10 Financial Operation Code Time Financial Operation Code Time      
SM43071 NVARCHAR VSTRING 32 0 32 Line GUID MsProject Line GUID      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Service Order Management | Service Order Activity Lines History