Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: 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 | 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 | ||||
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 | 4 | 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 | Spare | Spare | |||
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 | Да | |
CMH3063 | NCHAR | STRING | 4 | 0 | 4 | Execution Line No | ||||
CMH3064 | NCHAR | STRING | 1 | 0 | 1 | Lease Object Type | Lease Object Type | |||
CMH3065 | INT | INTEGER | 0 | 0 | 1 | Lease Line Nature | Lease Line Nature | |||
CMH3066 | NVARCHAR | VSTRING | 6 | 0 | 6 | Group Code | Group Code | |||
CMH3067 | NVARCHAR | VSTRING | 10 | 0 | 10 | Value Component | Value Component | |||
CMH3068 | NCHAR | SWITCH | 1 | 0 | 1 | Index Clause | Index Clause | |||
CMH3069 | NUMERIC | MONEY | 28 | 8 | 20 | Deposit | Deposit | |||
CMH3070 | NUMERIC | MONEY | 28 | 8 | 20 | Capital Value | Capital Value | |||
CMH3071 | NUMERIC | MONEY | 28 | 8 | 20 | Residual Value | Residual Value | |||
CMH3072 | NVARCHAR | VSTRING | 6 | 0 | 6 | Interest Rate Code | Interest Rate Code | |||
CMH3073 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | Interest Rate Percentage | Interest Rate Percentage | |||
CMH3074 | INT | INTEGER | 0 | 0 | 3 | Interest Rate Time | Interest Rate Time | |||
CMH3075 | INT | INTEGER | 0 | 0 | 1 | Interest Rate Time Unit | Interest Rate Time Unit | |||
CMH3076 | INT | INTEGER | 0 | 0 | 3 | Total Number of Periods | Total Number of Periods | |||
CMH3077 | INT | INTEGER | 0 | 0 | 3 | Current number of Periods | Current number of Periods | |||
CMH3078 | INT | INTEGER | 0 | 0 | 3 | Invoiced number of Periods | Invoiced number of Periods | |||
CMH3079 | NUMERIC | MONEY | 28 | 8 | 20 | Lease Charge | Lease Charge | |||
CMH3080 | NUMERIC | MONEY | 28 | 8 | 20 | Accumulated Depreciation | Accumulated Depreciation | |||
CMH3081 | NCHAR | STRING | 6 | 0 | 6 | Execution Structure Line Number | Execution Structure Line Number | |||
CMH3082 | NCHAR | STRING | 6 | 0 | 6 | Execution Sub Structure Line Number | Execution Sub Structure Line Number | |||
CMH3083 | NCHAR | SWITCH | 1 | 0 | 1 | Create Service Order on Return | Create Service Order on Return | |||
CMH3084 | INT | INTEGER | 0 | 0 | 3 | Days in Service | Days in Service | |||
CMH3085 | NVARCHAR | VSTRING | 10 | 0 | 10 | Lease Contract No | Linked Lease Contract No | |||
CMH3086 | NVARCHAR | VSTRING | 6 | 0 | 6 | Lease Line No | Linked Lease Contract Line No | |||
CMH3087 | NVARCHAR | VSTRING | 6 | 0 | 6 | Lease Subline No | Linked Lease Contract Subline No | |||
CMH3088 | NUMERIC | MONEY | 28 | 8 | 20 | Capital Charge | Capital Charge | |||
CMH3089 | NUMERIC | MONEY | 28 | 8 | 20 | Interest Charge | Interest Charge | |||
CMH3090 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Invoice Time Value | Invoice Time Value | |||
CMH3091 | INT | INTEGER | 0 | 0 | 2 | Invoice Time Unit | Invoice Time Unit | |||
CMH3092 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Prior Qty | Prior Qty | |||
CMH3093 | DATETIME | DATE | 0 | 0 | 8 | Change Date | Change Date | |||
CMH3094 | NCHAR | SWITCH | 1 | 0 | 1 | Use Best Price | Use Best Price | |||
CMH3095 | INT | INTEGER | 0 | 0 | 9 | JobID | Job ID | |||
CMH3096 | NCHAR | STRING | 6 | 0 | 6 | Service Order Type | Service Order Type | |||
CMH3097 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Min Ordered Qty | Min Ordered Qty | |||
CMH3098 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Delivery Time | Delivery Time | |||
CMH3099 | INT | INTEGER | 0 | 0 | 2 | Delivery Time Unit | Delivery Time Unit | |||
CMH3100 | INT | INTEGER | 0 | 0 | 1 | Subtype | Subtype |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR2 - 2.03.10355 | Contract Management | Contract Line History File