Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: SM69 - «Contract Codes». Маска имени таблицы: «SM69%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SM69001 | NCHAR | STRING | 3 | 0 | 3 | ContractType | Contract Type | 1 | Да | |
SM69002 | NCHAR | STRING | 25 | 0 | 25 | Description | Description | |||
SM69003 | NCHAR | STRING | 10 | 0 | 10 | TypeOfLabour | Category of Time Activity | |||
SM69004 | NCHAR | STRING | 10 | 0 | 10 | TypeOfCost | Category of Cost Activity | |||
SM69005 | NCHAR | STRING | 10 | 0 | 10 | TypeMaterial | Category of Material Activity | |||
SM69006 | NCHAR | STRING | 10 | 0 | 10 | AccCustomer | Internal Customer Code | |||
SM69007 | NVARCHAR | VSTRING | 30 | 0 | 30 | Remark1 | Remark Line 1 | |||
SM69008 | NVARCHAR | VSTRING | 30 | 0 | 30 | Remark2 | Remark Line 2 | |||
SM69009 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | CallBackHours | Call Back Time | |||
SM69010 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStartMon | Working Hours Monday Start Time 1 | |||
SM69011 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStopMon | Working Hours Monday End Time 1 | |||
SM69012 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStartTue | Working Hours Tuesday Start Time 1 | |||
SM69013 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStopTue | Working Hours Tuesday End Time 1 | |||
SM69014 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStartWed | Working Hours Wednesday Start Time 1 | |||
SM69015 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStopWed | Working Hours Wednesday End Time 1 | |||
SM69016 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStartThu | Working Hours Thursday Start Time 1 | |||
SM69017 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStopThu | Working Hours Thursday End Time 1 | |||
SM69018 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStartFri | Working Hours Friday Start Time 1 | |||
SM69019 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStopFri | Working Hours Friday End Time 1 | |||
SM69020 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStartSat | Working Hours Saturday Start Time 1 | |||
SM69021 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStopSat | Working Hours Saturday End Time 1 | |||
SM69022 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStartSun | Working Hours Sunday Start Time 1 | |||
SM69023 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStopSun | Working Hours Sunday End Time 1 | |||
SM69024 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | RespBackHours | Response Time | |||
SM69025 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStartMon | Working Hours Monday Start Time 2 | |||
SM69026 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStopMon | Working Hours Monday End Time 2 | |||
SM69027 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStartTue | Working Hours Tuesday Start Time 2 | |||
SM69028 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStopTue | Working Hours Tuesday End Time 2 | |||
SM69029 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStartWed | Working Hours Wednesday Start Time 2 | |||
SM69030 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStopWed | Working Hours Wednesday End Time 2 | |||
SM69031 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStartThu | Working Hours Thursday Start Time 2 | |||
SM69032 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStopThu | Working Hours Thursday End Time 2 | |||
SM69033 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStartFri | Working Hours Friday Start Time 2 | |||
SM69034 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStopFri | Working Hours Friday End Time 2 | |||
SM69035 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStartSat | Working Hours Saturday Start Time 2 | |||
SM69036 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStopSat | Working Hours Saturday End Time 2 | |||
SM69037 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStartSun | Working Hours Sunday Start Time 2 | |||
SM69038 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RespStopSun | Working Hours Sunday End Time 2 | |||
SM69039 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccntString | Accounting String | |||
SM69040 | INT | INTEGER | 0 | 0 | 2 | DefContrPeriod (DCP) | Default Contract Period | |||
SM69041 | INT | INTEGER | 0 | 0 | 2 | DCP_Unit_Code | Default Contract Period Unit | 1 - Years
2 - Month 3 - Weeks 4 - Days |
||
SM69042 | INT | INTEGER | 0 | 0 | 2 | DefInvInterval (DII) | Default Invoice Interval | |||
SM69043 | INT | INTEGER | 0 | 0 | 2 | DII_Unit_Code | Default Invoice Interval Unit | 1 - Years
2 - Month 3 - Weeks 4 - Days |
||
SM69044 | NCHAR | STRING | 10 | 0 | 10 | Account_Steering | Account Steering | |||
SM69045 | NCHAR | STRING | 6 | 0 | 6 | TAX _Code_Default | Default VAT Code | |||
SM69046 | NCHAR | SWITCH | 1 | 0 | 1 | Flag_EnterPrice_on_Line | Enter Price and Discount | |||
SM69047 | NCHAR | SWITCH | 1 | 0 | 1 | Flag_AdvanceInvoice | Invoice in Advance | |||
SM69048 | NCHAR | SWITCH | 1 | 0 | 1 | Flag_SerialNo_Mandatory | Mandatory Serial Number | |||
SM69049 | NCHAR | SWITCH | 1 | 0 | 1 | Flag_CheckAvailable | Check Material Availability | |||
SM69050 | NCHAR | STRING | 1 | 0 | 1 | Contract_Nature | Used For | 1 - Service
2 - Rental/Leasing 3 - Call-off order 4 - Blanket order |
||
SM69051 | NCHAR | STRING | 70 | 0 | 70 | Line_Entry_Mask | Line Entry Mask | One string where each character represents a line field, it controls if the field should be adjustable/visible when enter/adjust contract lines. | ||
SM69052 | NCHAR | SWITCH | 1 | 0 | 1 | Flag_SerialNo_TransactionHistory | Serial Number Transaction History | |||
SM69053 | NCHAR | STRING | 3 | 0 | 3 | SerialNo_History_TransactionType | Serial Number History Transaction Type | |||
SM69054 | NCHAR | STRING | 1 | 0 | 1 | Contract_Counter | Contract Counter | |||
SM69055 | INT | INTEGER | 0 | 0 | 2 | Price_UnitCode_Default | Default Time Unit for Prices | 1 - Years
2 - Month 3 - Weeks 4 - Days |
||
SM69056 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code | Accounting Code | |||
SM69057 | NCHAR | SWITCH | 1 | 0 | 1 | DeferralsCreationRule | Deferrals Creation Rule | |||
SM69058 | NCHAR | SWITCH | 1 | 0 | 1 | DeferralsAllocRule | Deferrals Allocation Rule | |||
SM69059 | INT | INTEGER | 0 | 0 | 4 | IntHandlingDays | Internal handling in days | |||
SM69060 | NCHAR | STRING | 3 | 0 | 3 | IntegrAccDimName | Integrated AccDim Name | |||
SM69061 | NCHAR | STRING | 3 | 0 | 3 | IntegrAccDimDescr1 | Integrated AccDim Description Line 1 | |||
SM69062 | NCHAR | STRING | 3 | 0 | 3 | IntegrAccDimDescr2 | Integrated AccDim Description Line 2 | |||
SM69063 | NCHAR | SWITCH | 1 | 0 | 1 | Spare | Spare | |||
SM69064 | NCHAR | STRING | 1 | 0 | 1 | PurchaseOrderCounter | Purchase Order Counter | |||
SM69065 | INT | INTEGER | 0 | 0 | 1 | PurchaseOrderType | Purchase Order Type | |||
SM69066 | NCHAR | SWITCH | 1 | 0 | 1 | AdjustmentOfPurchaseOrder | Adjustment of Purchase Order | |||
SM69067 | NCHAR | SWITCH | 1 | 0 | 1 | UpdateFromPurchaseOrder | Update from Purchase Order | |||
SM69068 | NCHAR | SWITCH | 1 | 0 | 1 | UpdateToPurchaseOrder | Update to Purchase Order | |||
SM69069 | NCHAR | SWITCH | 1 | 0 | 1 | UseLTM | Use LTM | |||
SM69070 | INT | INTEGER | 0 | 0 | 2 | ReservationType | Reservation Type | |||
SM69071 | INT | INTEGER | 0 | 0 | 2 | ReservationDuration | Reservation Time Out (Duration) | |||
SM69072 | INT | INTEGER | 0 | 0 | 2 | ReservationTimeUnit | Reservation Time Out (Time unit) | |||
SM69073 | INT | INTEGER | 0 | 0 | 2 | TypeOfPricing | Type of Pricing | |||
SM69074 | NCHAR | SWITCH | 1 | 0 | 1 | GenerateSalesStatistics | Generate Sales Statistics | |||
SM69075 | INT | INTEGER | 0 | 0 | 2 | AcceptedDeliveryInterval | Accepted Delivery Interval | |||
SM69076 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | Warehouse Code | |||
SM69077 | NCHAR | SWITCH | 1 | 0 | 1 | ApplyMainCustomer | Apply Main Customer | |||
SM69078 | NVARCHAR | VSTRING | 10 | 0 | 10 | Operation Type | Operation Type | |||
SM69079 | NVARCHAR | VSTRING | 10 | 0 | 10 | Financial Operation Code | Financial Operation Code | |||
SM69080 | NCHAR | SWITCH | 1 | 0 | 1 | Spare | Spare | |||
SM69081 | INT | INTEGER | 0 | 0 | 1 | Default Contract term | Default Contract term | |||
SM69082 | NCHAR | SWITCH | 1 | 0 | 1 | Copy To History | Copy To History | |||
SM69083 | INT | INTEGER | 0 | 0 | 2 | Discount validity calculation | Discount validity calculation |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Service Order Management | Contract Codes