Таблица | Table: SM69 - «Contract Codes». Маска имени таблицы | Table Name Mask: «SM69%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
SM69001 NCHAR STRING 3 0 3 ContractType Contract Type   1 Да / Yes
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      
SM69121 INT INTEGER 0 0 1 Spare Spare      
SM69122 INT INTEGER 0 0 1 Link with PO till Link with PO till      
SM69123 INT INTEGER 0 0 1 Delivery Date Milestone Delivery Date Milestone      
SM69124 NUMERIC X_NUMERIC 20 8 12 Delivery Time Value Delivery Time Value      
SM69125 INT INTEGER 0 0 2 Delivery Time Unit Delivery Time Unit      
SM69126 NCHAR SWITCH 1 0 1 Update PO Statistics Update PO Statistics      
SM69127 INT INTEGER 0 0 2 Invoicing Model Invoicing Model      
SM69128 INT INTEGER 0 0 2 Closing Rule Closing Rule      
SM69129 NCHAR STRING 3 0 3 Revenue Recognition Model Revenue Recognition Model      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Service Order Management | Contract Codes