Таблица: 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