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