One level Up / 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 SM13 — Service Contract Lines

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SM13001 NCHAR STRING 10 0 10 ServContrNo Service Contract Number   1 Да / Yes
SM13002 NCHAR STRING 6 0 6 LineNo Contract Line Number   2 Да / Yes
SM13003 NCHAR STRING 1 0 1 LineType Line Type 0 — Normal contract line

9 — Text line
   
SM13004 NCHAR STRING 35 0 35 StockCode Stock Item Code      
SM13005 NCHAR STRING 20 0 20 SerialNo Serial Number      
SM13006 NVARCHAR VSTRING 25 0 25 DescrLine1 Description Line 1      
SM13007 NVARCHAR VSTRING 25 0 25 DescrLine2 Description Line 2      
SM13008 NUMERIC MONEY 28 8 20 PricePerUnitOCU Unit Price (Contract Currency)      
SM13009 NCHAR STRING 1 0 1 Spare (obsolete)      
SM13010 NUMERIC X_NUMERIC 15 8 7 Discount Discount %      
SM13011 DATETIME DATE 0 0 8 DateEntryLine Date Entered      
SM13012 NCHAR STRING 3 0 3 ContractType Contract Type      
SM13013 INT INTEGER 0 0 1 PriceType Price Type 0 — The prices entered on the contract lines are used, index can be used to restate the prices at invoice time.

1 — Current price from price list will be used at the time of invoice.
   
SM13014 NCHAR STRING 2 0 2 AccCode Accounting Code      
SM13015 NCHAR STRING 6 0 6 JobCode Job Number      
SM13016 NCHAR STRING 6 0 6 WH Warehouse      
SM13017 NCHAR STRING 7 0 7 Spare (obsolete)      
SM13018 NCHAR STRING 6 0 6 Spare (obsolete)      
SM13019 NCHAR STRING 6 0 6 SalesTaxCode VAT Code      
SM13020 NCHAR STRING 7 0 7 LineTax2 VAT Code 2      
SM13021 DATETIME DATE 0 0 8 NextInvDate Next Invoice Date      
SM13022 NCHAR STRING 4 0 4 InstallatSite Site Code      
SM13023 DATETIME DATE 0 0 8 DateLineStart Contract Line Start Date      
SM13024 DATETIME DATE 0 0 8 DateLineEnd Contract Line End Date      
SM13025 NUMERIC X_NUMERIC 20 8 12 OverRespTime Response Time Override      
SM13026 INT INTEGER 0 0 1 Status Line Status 0 — Normal contract line

1 — Changed invoice amount

2 — Cancelled line, by date

3 — Switched of line
   
SM13027 NUMERIC MONEY 28 8 20 DebitCreditValueOCU Debit/Credit Value (Contract Currency)      
SM13028 NCHAR STRING 20 0 20 ReasChngText Change Reason      
SM13029 DATETIME DATE 0 0 8 StatusDate Status Date      
SM13030 NVARCHAR ACCSTR 120 0 120 AccString Accounting String      
SM13031 DATETIME DATE 0 0 8 DiscEndDate Discount End Date      
SM13032 NCHAR STRING 10 0 10 CustCodeSite Customer Code Installation Address      
SM13033 NCHAR STRING 2 0 2 ContactCurrency Currency Code Contract      
SM13034 NUMERIC MONEY 28 8 20 PrevAccPrice Previous Accrual Unit Price (Local Currency)      
SM13035 DATETIME DATE 0 0 8 DateAcCreated Date Accruals Created      
SM13036 DATETIME DATE 0 0 8 DateContrClosed Date Contract Closed      
SM13037 NUMERIC MONEY 28 8 20 AccumAccrAcount Accumulated Accrual Amount (Local Currency)      
SM13038 DATETIME DATE 0 0 8 PrevAccrStartDate Previous Accrual Start Date      
SM13039 DATETIME DATE 0 0 8 PrevAccrEndDate Previous Accrual End Date      
SM13040 NCHAR STRING 6 0 6 SubLineNum Contract Sub-line Number   3 Да / Yes
SM13041 NCHAR STRING 2 0 2 PriceList Price List      
SM13042 INT INTEGER 0 0 2 PriceUnitCode Unit Code Price      
SM13043 NCHAR STRING 10 0 10 CalendarID Calendar ID      
SM13044 NUMERIC X_NUMERIC 20 8 12 QtyPlanned Quantity Planned      
SM13045 NUMERIC X_NUMERIC 20 8 12 QtyActual Quantity Actual      
SM13046 NUMERIC X_NUMERIC 20 8 12 RentalUnitsActual Quantity Actual Rental      
SM13047 INT INTEGER 0 0 4 UnitCodeQty Unit Code Quantity      
SM13048 NCHAR STRING 4 0 4 CntrLineStartTime Contract Line Start Time      
SM13049 NCHAR STRING 4 0 4 CntrLineEndTime Contract Line End Time      
SM13050 NUMERIC X_NUMERIC 28 8 20 InvoiceQty Invoice Qty      
SM13051 DATETIME DATE 0 0 8 RequestedDate Requested Date      
SM13052 DATETIME DATE 0 0 8 ConfirmedDate Confirmed Date      
SM13053 DATETIME DATE 0 0 8 LastUsedDate Last Used Date      
SM13054 DATETIME DATE 0 0 8 AcceptedDate AcceptedDate      
SM13055 NUMERIC X_NUMERIC 20 8 12 Spare Spare      
SM13056 NVARCHAR VSTRING 10 0 10 DefaultEngineer Default Engineer      
SM13057 DATETIME DATE 0 0 8 ExpiryDate Reservation Expiry Date      
SM13058 NVARCHAR VSTRING 20 0 20 ReqDelTimeRem Requested Delivery Time remark      
SM13059 NVARCHAR VSTRING 20 0 20 AccDelTimeRem Accepted Delivery Time remark      
SM13060 DATETIME DATE 0 0 8 ContractLinePricingDate Contract Line Pricing Date      
SM13061 NCHAR STRING 10 0 10 ContractPricingNumber Contract Pricing Number      
SM13062 NCHAR STRING 15 0 15 InvoiceNo InvoiceNo      
SM13063 NCHAR STRING 4 0 4 ExecutionLineNo Execution Line No      
SM13064 NCHAR STRING 1 0 1 LeaseObjectType Lease Object Type For lease contracts: Asset or Accessory    
SM13065 INT INTEGER 0 0 1 LeaseLineNature Lease Line Nature For lease contracts: Lease or Maintenance line    
SM13066 NVARCHAR VSTRING 6 0 6 LineGroupCode Line Group Code      
SM13067 NVARCHAR VSTRING 10 0 10 ValueComponent Value Component      
SM13068 NCHAR SWITCH 1 0 1 IndexClause Index Clause      
SM13069 NUMERIC MONEY 28 8 20 Deposit Deposit      
SM13070 NUMERIC MONEY 28 8 20 CapitalValue Capital Value      
SM13071 NUMERIC MONEY 28 8 20 ResidualValue Residual Value      
SM13072 NVARCHAR VSTRING 6 0 6 InterestRateCode Interest Rate Code      
SM13073 NUMERIC X_NUMERIC 15 8 7 InterestRatePercentage Interest Rate Percentage      
SM13074 INT INTEGER 0 0 3 InterestRateTime Interest Rate Time      
SM13075 INT INTEGER 0 0 1 InterestRateTimeUnit Interest Rate Time Unit      
SM13076 NUMERIC X_NUMERIC 20 8 12 TotalNumPeriods Total Number of Periods      
SM13077 NUMERIC X_NUMERIC 20 8 12 CurrentNumOfPeriods Current number of Periods      
SM13078 NUMERIC X_NUMERIC 20 8 12 InvoicedNumOfPeriods Invoiced number of Periods      
SM13079 NUMERIC MONEY 28 8 20 LeaseCharge Lease Charge      
SM13080 NUMERIC MONEY 28 8 20 AccumulatedDepreciation Accumulated Depreciation      
SM13081 NCHAR STRING 6 0 6 ExecutionStructureLineNumber Execution Structure Line Number      
SM13082 NCHAR STRING 6 0 6 ExecutionSubStructureLineNumber Execution Sub Structure Line Number      
SM13083 NCHAR SWITCH 1 0 1 CreateServiceOrdOnReturn Create Service Order on Return      
SM13084 INT INTEGER 0 0 3 DaysInService Days in Service      
SM13085 NVARCHAR VSTRING 10 0 10 LeaseContractNo Linked Lease Contract No      
SM13086 NVARCHAR VSTRING 6 0 6 LeaseLineNo Linked Lease Contract Line No      
SM13087 NVARCHAR VSTRING 6 0 6 LeaseSublineNo Linked Lease Contract Subline No      
SM13088 NUMERIC MONEY 28 8 20 CapitalCharge Capital Charge      
SM13089 NUMERIC MONEY 28 8 20 InterestCharge Interest Charge      
SM13090 NUMERIC X_NUMERIC 20 8 12 InvoiceTimeValue Invoice Time Value      
SM13091 INT INTEGER 0 0 2 InvoiceTimeUnit Invoice Time Unit      
SM13092 NUMERIC X_NUMERIC 20 8 12 PriorQty Prior Qty      
SM13093 DATETIME DATE 0 0 8 ChangeDate Change Date      
SM13094 NCHAR SWITCH 1 0 1 UseBestPrice Use Best Price      
SM13095 INT INTEGER 0 0 9 JobID Job ID      
SM13096 NCHAR STRING 6 0 6 ServiceOrderType Service Order Type      
SM13097 NUMERIC X_NUMERIC 20 8 12 MinOrderedQty Min Ordered Qty      
SM13098 NUMERIC X_NUMERIC 20 8 12 DeliveryTime Delivery Time      
SM13099 INT INTEGER 0 0 2 DeliveryTimeUnit Delivery Time Unit      
SM13100 INT INTEGER 0 0 1 Subtype Subtype      
SM13101 NCHAR SWITCH 1 0 1 ApprovedCreditLimit Approved Credit Limit      
SM13102 NCHAR STRING 3 0 3 VariableInterestRateCode1 Variable Interest Rate Code 1      
SM13103 NUMERIC X_NUMERIC 15 8 7 VariableInterestRatePercent1 Variable Interest Rate Percent.1      
SM13104 NCHAR STRING 3 0 3 VariableInterestRateCode2 Variable Interest Rate Code 2      
SM13105 NUMERIC X_NUMERIC 15 8 7 VariableInterestRatePercent2 Variable Interest Rate Percent.2      
SM13106 NCHAR STRING 6 0 6 InvoicePlanLineNumber Invoice Plan Line Number      
SM13107 NUMERIC X_NUMERIC 20 8 12 AgreedInterval Agreed Interval      
SM13108 INT INTEGER 0 0 2 AgreedIntervalUnit Agreed Interval Unit      
SM13109 NUMERIC X_NUMERIC 20 8 12 AgreedQty Agreed Qty      
SM13110 NCHAR STRING 2 0 2 QtyType Qty Type      
SM13111 NUMERIC MONEY 28 8 20 OverPriceQty Over Price/Qty      
SM13112 NCHAR STRING 8 0 8 CostCode Cost Code      
SM13113 DATETIME DATE 0 0 8 UsageBillingFrom Usage Billing From      
SM13114 NVARCHAR VSTRING 6 0 6 ReturnWH Return WH      
SM13115 NVARCHAR VSTRING 10 0 10 OperationType Operation Type      
SM13116 NVARCHAR VSTRING 10 0 10 FinancialOperationCode Financial Operation Code      
SM13117 NVARCHAR VSTRING 25 0 25 NCMCode NCM Code      
SM13118 NCHAR STRING 3 0 3 TaxationReasonCode Taxation Reason Code      
SM13119 NUMERIC X_NUMERIC 20 8 12 QuantityPerMultiple Quantity Per Multiple      

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