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

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
CMH3001 NCHAR STRING 10 0 10 ServContrNo Service Contract Number   1 Да
CMH3002 NCHAR STRING 6 0 6 LineNo Contract Line Number   2 Да
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        
CMH3010 NUMERIC X_NUMERIC 15 8 7 Discount % Discount %      
CMH3011 DATETIME DATE 0 0 8 Date_EntryLine Date_EntryLine      
CMH3012 NCHAR STRING 3 0 3 Contract_Type Contract_Type      
CMH3013 NCHAR SWITCH 1 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        
CMH3018 NCHAR STRING 6 0 6 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 Date_LineStart Contract Line Start Date      
CMH3024 DATETIME DATE 0 0 8 Date_LineEnd 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 50 0 50 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 SubLineNo Contract Sub-line Number   3 Да
CMH3041 NCHAR STRING 2 0 2 PriceList Price List      
CMH3042 INT INTEGER 0 0 2 Price_UnitCode Price_UnitCode      
CMH3043 NCHAR STRING 10 0 10 CalendarID CalendarID      
CMH3044 NUMERIC X_NUMERIC 20 8 12 Qty_Planned Qty_Planned      
CMH3045 NUMERIC X_NUMERIC 20 8 12 Qty_Actual Qty_Actual      
CMH3046 NUMERIC X_NUMERIC 20 8 12 RentalUnits_Actual Quantity Actual Rental      
CMH3047 INT INTEGER 0 0 2 UnitCode_Qty 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 Qty Unit Factor Qty Unit Factor      
CMH3056 NVARCHAR VSTRING 10 0 10 Default Engineer Default Engineer      
CMH3057 DATETIME DATE 0 0 8 Expiry Date 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 Contract Line Pricing Date Contract Line Pricing Date      
CMH3061 NCHAR STRING 10 0 10 Contract Pricing Number Contract Pricing Number      
CMH3062 NCHAR STRING 15 0 15 InvoiceNo InvoiceNo   4 Да

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Contract Management | Contract Line History File