Таблица: 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 | 4 | 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 | 4 | 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 | 100 | 0 | 100 | 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 | |||
SM69084 | NVARCHAR | VSTRING | 50 | 0 | 50 | Overview Configuration | Overview Configuration | |||
SM69085 | NCHAR | SWITCH | 1 | 0 | 1 | CreateExecutionOrder | Create Execution Order | |||
SM69086 | NCHAR | STRING | 6 | 0 | 6 | ExecutionOrderType | Execution Order Type | |||
SM69087 | NCHAR | STRING | 100 | 0 | 100 | Line_Entry_Mask2 | Mask for Lease Asset Lines | |||
SM69088 | NCHAR | STRING | 100 | 0 | 100 | Line_Entry_Mask3 | Mask for Lease Accessory Lines | |||
SM69089 | NCHAR | STRING | 100 | 0 | 100 | Line_Entry_Mask4 | Mask for Service Asset Lines | |||
SM69090 | INT | INTEGER | 0 | 0 | 1 | Price Type Accessory | Price Type Accessory | |||
SM69091 | INT | INTEGER | 0 | 0 | 1 | Document Specification | Document Specification | |||
SM69092 | NCHAR | STRING | 1 | 0 | 1 | Default Job Object Type | Default Job Object Type | |||
SM69093 | NCHAR | STRING | 35 | 0 | 35 | Default Job Object Code | Default Job Object Code | |||
SM69094 | NCHAR | STRING | 6 | 0 | 6 | Default Job Number | Default Job Number | |||
SM69095 | NCHAR | STRING | 3 | 0 | 3 | Contract Line Created | Contract Line Created | |||
SM69096 | NCHAR | STRING | 3 | 0 | 3 | Asset Delivered | Asset Delivered | |||
SM69097 | NCHAR | STRING | 3 | 0 | 3 | Asset Returned | Asset Returned | |||
SM69098 | NCHAR | STRING | 3 | 0 | 3 | Asset Sold | Asset Sold | |||
SM69099 | NCHAR | STRING | 3 | 0 | 3 | Asset Scrapped | Asset Scrapped | |||
SM69100 | NCHAR | STRING | 3 | 0 | 3 | Contract Line Invoiced | Contract Line Invoiced | |||
SM69101 | NCHAR | STRING | 3 | 0 | 3 | Contract Line Credited | Contract Line Credited | |||
SM69102 | NCHAR | STRING | 3 | 0 | 3 | Contract Line Closed | Contract Line Closed | |||
SM69103 | NCHAR | SWITCH | 1 | 0 | 1 | Extended Commission | Extended Commission | |||
SM69104 | INT | INTEGER | 0 | 0 | 1 | Price Type Asset | Price Type Asset | |||
SM69105 | INT | INTEGER | 0 | 0 | 1 | Invoice Specification | Invoice Specification | |||
SM69106 | NCHAR | SWITCH | 1 | 0 | 1 | Lease Statistics | Lease Statistics | |||
SM69107 | NCHAR | SWITCH | 1 | 0 | 1 | Hide Lease Asset Lines | Hide Lease Asset Lines | |||
SM69108 | NCHAR | SWITCH | 1 | 0 | 1 | Hide Maintenance Asset Lines | Hide Maintenance Asset Lines | |||
SM69109 | NCHAR | SWITCH | 1 | 0 | 1 | Hide Lease Accessory Lines | Hide Lease Accessory Lines | |||
SM69110 | NCHAR | SWITCH | 1 | 0 | 1 | Hide Maintenance Accessory Lines | Hide Maintenance Accessory Lines | |||
SM69111 | INT | INTEGER | 0 | 0 | 2 | Credit Mode | Credit Mode | |||
SM69112 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Min Invoice Time Value | Min Invoice Time Value | |||
SM69113 | INT | INTEGER | 0 | 0 | 2 | Decimals in Invoice Time Value | Decimals in Invoice Time Value | |||
SM69114 | INT | INTEGER | 0 | 0 | 2 | Line invoice interval unit | Line invoice interval unit | |||
SM69115 | NVARCHAR | VSTRING | 10 | 0 | 10 | Price Calculation Profile | Price Calculation Profile | |||
SM69116 | NVARCHAR | VSTRING | 3 | 0 | 3 | Best Price Code | Best Price Code | |||
SM69117 | INT | INTEGER | 0 | 0 | 2 | Consolidation Mode | Consolidation Mode | |||
SM69118 | INT | INTEGER | 0 | 0 | 1 | Best Price Type | Best Price Type | |||
SM69119 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Spare | Spare | |||
SM69120 | INT | INTEGER | 0 | 0 | 4 | Spare | Spare |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Service Order Management | Contract Codes