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

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table CMH3 — Contract Line History File

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
CMH3001 NCHAR STRING 10 0 10 ServContrNo Service Contract Number   1 Да / Yes
CMH3002 NCHAR STRING 6 0 6 LineNo Contract Line Number   2 Да / Yes
CMH3003 NCHAR STRING 1 0 1 LineType Line Type      
CMH3004 NCHAR STRING 35 0 35 StockCode Stock Item Code      
CMH3005 NCHAR STRING 20 0 20 SerialNo SerialNo      
CMH3006 NVARCHAR VSTRING 25 0 25 DescrLine1 Description Line 1      
CMH3007 NVARCHAR VSTRING 25 0 25 DescrLine2 Description Line 2      
CMH3008 NUMERIC MONEY 28 8 20 PricePerUnitOCU Unit Price (Contract Currency)      
CMH3009 NCHAR STRING 1 0 1 Spare Spare      
CMH3010 NUMERIC X_NUMERIC 15 8 7 DiscountPercent Discount %      
CMH3011 DATETIME DATE 0 0 8 DateEntryLine Date_EntryLine      
CMH3012 NCHAR STRING 3 0 3 ContractType Contract_Type      
CMH3013 INT INTEGER 0 0 1 PriceType PriceType      
CMH3014 NCHAR STRING 2 0 2 AccCode Accounting Code      
CMH3015 NCHAR STRING 6 0 6 JobCode JobCode      
CMH3016 NCHAR STRING 6 0 6 Warehouse Warehouse      
CMH3017 NCHAR STRING 7 0 7 Spare Spare      
CMH3018 NCHAR STRING 6 0 6 Spare Spare      
CMH3019 NCHAR STRING 6 0 6 SalesTaxCode VAT Code      
CMH3020 NCHAR STRING 7 0 7 LineTax2 VAT Code 2      
CMH3021 DATETIME DATE 0 0 8 NextInvDate Next Invoice Date      
CMH3022 NCHAR STRING 4 0 4 InstallatSite Site Code      
CMH3023 DATETIME DATE 0 0 8 DateLineStart Contract Line Start Date      
CMH3024 DATETIME DATE 0 0 8 DateLineEnd Contract Line End Date      
CMH3025 NUMERIC X_NUMERIC 20 8 12 OverRespTime Response Time Override      
CMH3026 INT INTEGER 0 0 1 Status Line Status      
CMH3027 NUMERIC MONEY 28 8 20 ChangeValueOCU Change Value (Contract Currency)      
CMH3028 NCHAR STRING 20 0 20 ReasChngText Change Reason      
CMH3029 DATETIME DATE 0 0 8 ChangeDate Change Date      
CMH3030 NVARCHAR ACCSTR 120 0 120 AccString Accounting String      
CMH3031 DATETIME DATE 0 0 8 DiscEndDate Discount End Date      
CMH3032 NCHAR STRING 10 0 10 CustCodeSite Customer Code Installation Address      
CMH3033 NCHAR STRING 2 0 2 ContactCurrency Currency Code Contract      
CMH3034 NUMERIC MONEY 28 8 20 PrevAccPrice Previous Accrual Unit Price (Local Currency)      
CMH3035 DATETIME DATE 0 0 8 DateAcCreated Date Accruals Created      
CMH3036 DATETIME DATE 0 0 8 DateContrClosed Date Contract Closed      
CMH3037 NUMERIC MONEY 28 8 20 AccumAccrAcount Accumulated Accrual Amount (Local Currency)      
CMH3038 DATETIME DATE 0 0 8 PrevAccrStartDate Previous Accrual Start Date      
CMH3039 DATETIME DATE 0 0 8 PrevAccrEndDate Previous Accrual End Date      
CMH3040 NCHAR STRING 6 0 6 SubLineNum Contract Sub-line Number   3 Да / Yes
CMH3041 NCHAR STRING 2 0 2 PriceList Price List      
CMH3042 INT INTEGER 0 0 2 PriceUnitCode Price_UnitCode      
CMH3043 NCHAR STRING 10 0 10 CalendarID CalendarID      
CMH3044 NUMERIC X_NUMERIC 20 8 12 QtyPlanned Qty_Planned      
CMH3045 NUMERIC X_NUMERIC 20 8 12 QtyActual Qty_Actual      
CMH3046 NUMERIC X_NUMERIC 20 8 12 RentalUnitsActual Quantity Actual Rental      
CMH3047 INT INTEGER 0 0 4 UnitCodeQty UnitCode_Qty      
CMH3048 NCHAR STRING 4 0 4 CntrLineStartTime Contract Line Start Time      
CMH3049 NCHAR STRING 4 0 4 CntrLineEndTime Contract Line End Time      
CMH3050 NUMERIC X_NUMERIC 28 8 20 InvoiceQty InvoiceQty      
CMH3051 DATETIME DATE 0 0 8 RequestedDate RequestedDate      
CMH3052 DATETIME DATE 0 0 8 ConfirmedDate ConfirmedDate      
CMH3053 DATETIME DATE 0 0 8 LastUsedDate LastUsedDate      
CMH3054 DATETIME DATE 0 0 8 AcceptedDate AcceptedDate      
CMH3055 NUMERIC X_NUMERIC 20 8 12 Spare Spare      
CMH3056 NVARCHAR VSTRING 10 0 10 DefaultEngineer Default Engineer      
CMH3057 DATETIME DATE 0 0 8 ExpiryDate Reservation Expiry Date      
CMH3058 NVARCHAR VSTRING 20 0 20 ReqDelTimeRem Requested Delivery Time remark      
CMH3059 NVARCHAR VSTRING 20 0 20 AccDelTimeRem Accepted Delivery Time remark      
CMH3060 DATETIME DATE 0 0 8 ContractLinePricingDate Contract Line Pricing Date      
CMH3061 NCHAR STRING 10 0 10 ContractPricingNumber Contract Pricing Number      
CMH3062 NCHAR STRING 15 0 15 InvoiceNo InvoiceNo   4 Да / Yes
CMH3063 NCHAR STRING 4 0 4 ExecutionLineNo Execution Line No      
CMH3064 NCHAR STRING 1 0 1 LeaseObjectType Lease Object Type      
CMH3065 INT INTEGER 0 0 1 LeaseLineNature Lease Line Nature      
CMH3066 NVARCHAR VSTRING 6 0 6 GroupCode Group Code      
CMH3067 NVARCHAR VSTRING 10 0 10 ValueComponent Value Component      
CMH3068 NCHAR SWITCH 1 0 1 IndexClause Index Clause      
CMH3069 NUMERIC MONEY 28 8 20 Deposit Deposit      
CMH3070 NUMERIC MONEY 28 8 20 CapitalValue Capital Value      
CMH3071 NUMERIC MONEY 28 8 20 ResidualValue Residual Value      
CMH3072 NVARCHAR VSTRING 6 0 6 InterestRateCode Interest Rate Code      
CMH3073 NUMERIC X_NUMERIC 15 8 7 InterestRatePercentage Interest Rate Percentage      
CMH3074 INT INTEGER 0 0 3 InterestRateTime Interest Rate Time      
CMH3075 INT INTEGER 0 0 1 InterestRateTimeUnit Interest Rate Time Unit      
CMH3076 NUMERIC X_NUMERIC 20 8 12 TotalNumPeriods Total Number of Periods      
CMH3077 NUMERIC X_NUMERIC 20 8 12 CurrentNumOfPeriods Current number of Periods      
CMH3078 NUMERIC X_NUMERIC 20 8 12 InvoicedNumOfPeriods Invoiced number of Periods      
CMH3079 NUMERIC MONEY 28 8 20 LeaseCharge Lease Charge      
CMH3080 NUMERIC MONEY 28 8 20 AccumulatedDepreciation Accumulated Depreciation      
CMH3081 NCHAR STRING 6 0 6 ExecutionStructureLineNumber Execution Structure Line Number      
CMH3082 NCHAR STRING 6 0 6 ExecutionSubStructureLineNumber Execution Sub Structure Line Number      
CMH3083 NCHAR SWITCH 1 0 1 CreateServiceOrdOnReturn Create Service Order on Return      
CMH3084 INT INTEGER 0 0 3 DaysInService Days in Service      
CMH3085 NVARCHAR VSTRING 10 0 10 LeaseContractNo Linked Lease Contract No      
CMH3086 NVARCHAR VSTRING 6 0 6 LeaseLineNo Linked Lease Contract Line No      
CMH3087 NVARCHAR VSTRING 6 0 6 LeaseSublineNo Linked Lease Contract Subline No      
CMH3088 NUMERIC MONEY 28 8 20 CapitalCharge Capital Charge      
CMH3089 NUMERIC MONEY 28 8 20 InterestCharge Interest Charge      
CMH3090 NUMERIC X_NUMERIC 20 8 12 InvoiceTimeValue Invoice Time Value      
CMH3091 INT INTEGER 0 0 2 InvoiceTimeUnit Invoice Time Unit      
CMH3092 NUMERIC X_NUMERIC 20 8 12 PriorQty Prior Qty      
CMH3093 DATETIME DATE 0 0 8 Change_Date Change Date      
CMH3094 NCHAR SWITCH 1 0 1 UseBestPrice Use Best Price      
CMH3095 INT INTEGER 0 0 9 JobID Job ID      
CMH3096 NCHAR STRING 6 0 6 ServiceOrderType Service Order Type      
CMH3097 NUMERIC X_NUMERIC 20 8 12 MinOrderedQty Min Ordered Qty      
CMH3098 NUMERIC X_NUMERIC 20 8 12 DeliveryTime Delivery Time      
CMH3099 INT INTEGER 0 0 2 DeliveryTimeUnit Delivery Time Unit      
CMH3100 INT INTEGER 0 0 1 Subtype Subtype      
CMH3101 NCHAR SWITCH 1 0 1 ApprovedCreditLimit Approved Credit Limit      
CMH3102 NCHAR STRING 3 0 3 VariableInterestRateCode1 Variable Interest Rate Code 1      
CMH3103 NUMERIC X_NUMERIC 15 8 7 VariableInterestRatePercent1 Variable Interest Rate Percent.1      
CMH3104 NCHAR STRING 3 0 3 VariableInterestRateCode2 Variable Interest Rate Code 2      
CMH3105 NUMERIC X_NUMERIC 15 8 7 VariableInterestRatePercent2 Variable Interest Rate Percent.2      
CMH3106 NCHAR STRING 6 0 6 InvoicePlanLineNumber Invoice Plan Line Number   5 Да / Yes
CMH3107 NUMERIC X_NUMERIC 20 8 12 AgreedInterval Agreed Interval      
CMH3108 INT INTEGER 0 0 2 AgreedIntervalUnit Agreed Interval Unit      
CMH3109 NUMERIC X_NUMERIC 20 8 12 AgreedQty Agreed Qty      
CMH3110 NCHAR STRING 2 0 2 QtyType Qty Type      
CMH3111 NUMERIC MONEY 28 8 20 OverPriceQty Over Price/Qty      
CMH3112 NCHAR STRING 8 0 8 CostCode Cost Code      
CMH3113 DATETIME DATE 0 0 8 UsageBillingFrom Usage Billing From      
CMH3114 NVARCHAR VSTRING 6 0 6 ReturnWH Return WH      
CMH3115 NVARCHAR VSTRING 10 0 10 OperationType Operation Type      
CMH3116 NVARCHAR VSTRING 10 0 10 FinancialOperationCode Financial Operation Code      
CMH3117 NVARCHAR VSTRING 25 0 25 NCMCode NCM Code      
CMH3118 NCHAR STRING 3 0 3 TaxationReasonCode Taxation Reason Code      
CMH3119 NUMERIC X_NUMERIC 20 8 12 QuantityPerMultiple Quantity Per Multiple      

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