На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление заказом на обслуживание» / List of tables of module «Service Order Management»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table SM69 — Contract Codes

Таблица / Table: SM69 — «Contract Codes». Маска имени таблицы / Table name mask: «SM69%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / 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 RespStartMon2 Working Hours Monday Start Time 2      
SM69026 NUMERIC X_NUMERIC 13 8 5 RespStopMon2 Working Hours Monday End Time 2      
SM69027 NUMERIC X_NUMERIC 13 8 5 RespStartTue2 Working Hours Tuesday Start Time 2      
SM69028 NUMERIC X_NUMERIC 13 8 5 RespStopTue2 Working Hours Tuesday End Time 2      
SM69029 NUMERIC X_NUMERIC 13 8 5 RespStartWed2 Working Hours Wednesday Start Time 2      
SM69030 NUMERIC X_NUMERIC 13 8 5 RespStopWed2 Working Hours Wednesday End Time 2      
SM69031 NUMERIC X_NUMERIC 13 8 5 RespStartThu2 Working Hours Thursday Start Time 2      
SM69032 NUMERIC X_NUMERIC 13 8 5 RespStopThu2 Working Hours Thursday End Time 2      
SM69033 NUMERIC X_NUMERIC 13 8 5 RespStartFri2 Working Hours Friday Start Time 2      
SM69034 NUMERIC X_NUMERIC 13 8 5 RespStopFri2 Working Hours Friday End Time 2      
SM69035 NUMERIC X_NUMERIC 13 8 5 RespStartSat2 Working Hours Saturday Start Time 2      
SM69036 NUMERIC X_NUMERIC 13 8 5 RespStopSat2 Working Hours Saturday End Time 2      
SM69037 NUMERIC X_NUMERIC 13 8 5 RespStartSun2 Working Hours Sunday Start Time 2      
SM69038 NUMERIC X_NUMERIC 13 8 5 RespStopSun2 Working Hours Sunday End Time 2      
SM69039 NVARCHAR ACCSTR 50 0 50 AccntString Accounting String      
SM69040 INT INTEGER 0 0 4 DefContrPeriodDCP Default Contract Period      
SM69041 INT INTEGER 0 0 2 DCPUnitCode Default Contract Period Unit 1 — Years

2 — Month

3 — Weeks

4 — Days		    
SM69042 INT INTEGER 0 0 4 DefInvInterval Default Invoice Interval      
SM69043 INT INTEGER 0 0 2 DIIUnitCode Default Invoice Interval Unit 1 — Years

2 — Month

3 — Weeks

4 — Days		    
SM69044 NCHAR STRING 10 0 10 AccountSteering Account Steering      
SM69045 NCHAR STRING 6 0 6 TAXCodeDefault Default VAT Code      
SM69046 NCHAR SWITCH 1 0 1 FlagEnterPriceonLine Enter Price and Discount      
SM69047 NCHAR SWITCH 1 0 1 FlagAdvanceInvoice Invoice in Advance      
SM69048 NCHAR SWITCH 1 0 1 FlagSerialNoMandatory Mandatory Serial Number      
SM69049 NCHAR SWITCH 1 0 1 FlagCheckAvailable Check Material Availability      
SM69050 NCHAR STRING 1 0 1 ContractNature Used For 1 — Service

2 — Rental/Leasing

3 — Call-off order

4 — Blanket order		    
SM69051 NVARCHAR VSTRING 150 0 150 LineEntryMask 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 FlagSerialNoTransactionHistory Serial Number Transaction History      
SM69053 NCHAR STRING 3 0 3 SerialNoHistoryTransactionType Serial Number History Transaction Type      
SM69054 NCHAR STRING 1 0 1 ContractCounter Contract Counter      
SM69055 INT INTEGER 0 0 2 PriceUnitCodeDefault Default Time Unit for Prices 1 — Years

2 — Month

3 — Weeks

4 — Days		    
SM69056 NCHAR STRING 2 0 2 AccountingCode 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 OperationType Operation Type      
SM69079 NVARCHAR VSTRING 10 0 10 FinancialOperationCode Financial Operation Code      
SM69080 NCHAR SWITCH 1 0 1 Spare Spare      
SM69081 INT INTEGER 0 0 1 DefaultContractterm Default Contract term      
SM69082 NCHAR SWITCH 1 0 1 CopyToHistory Copy To History      
SM69083 INT INTEGER 0 0 2 DiscountValidityCalculation Discount validity calculation      
SM69084 NVARCHAR VSTRING 50 0 50 OverviewConfiguration Overview Configuration      
SM69085 NCHAR SWITCH 1 0 1 CreateExecutionOrder Create Execution Order      
SM69086 NCHAR STRING 6 0 6 ExecutionOrderType Execution Order Type      
SM69087 NVARCHAR VSTRING 150 0 150 LineEntryMask2 Mask for Lease Asset Lines      
SM69088 NVARCHAR VSTRING 150 0 150 LineEntryMask3 Mask for Lease Accessory Lines      
SM69089 NVARCHAR VSTRING 150 0 150 LineEntryMask4 Mask for Service Asset Lines      
SM69090 INT INTEGER 0 0 1 PriceTypeAccessory Price Type Accessory      
SM69091 INT INTEGER 0 0 1 DocumentSpecification Document Specification      
SM69092 NCHAR STRING 1 0 1 DefaultJobObjectType Default Job Object Type      
SM69093 NCHAR STRING 35 0 35 DefaultJobObjectCode Default Job Object Code      
SM69094 NCHAR STRING 6 0 6 DefaultJobNumber Default Job Number      
SM69095 NCHAR STRING 3 0 3 ContractLineCreated Contract Line Created      
SM69096 NCHAR STRING 3 0 3 AssetDelivered Asset Delivered      
SM69097 NCHAR STRING 3 0 3 AssetReturned Asset Returned      
SM69098 NCHAR STRING 3 0 3 AssetSold Asset Sold      
SM69099 NCHAR STRING 3 0 3 AssetScrapped Asset Scrapped      
SM69100 NCHAR STRING 3 0 3 ContractLineInvoiced Contract Line Invoiced      
SM69101 NCHAR STRING 3 0 3 ContractLineCredited Contract Line Credited      
SM69102 NCHAR STRING 3 0 3 ContractLineClosed Contract Line Closed      
SM69103 NCHAR SWITCH 1 0 1 ExtendedCommission Extended Commission      
SM69104 INT INTEGER 0 0 1 PriceTypeAsset Price Type Asset      
SM69105 INT INTEGER 0 0 1 InvoiceSpecification Invoice Specification      
SM69106 NCHAR SWITCH 1 0 1 LeaseStatistics Lease Statistics      
SM69107 NCHAR SWITCH 1 0 1 HideLeaseAssetLines Hide Lease Asset Lines      
SM69108 NCHAR SWITCH 1 0 1 HideMaintenanceAssetLines Hide Maintenance Asset Lines      
SM69109 NCHAR SWITCH 1 0 1 HideLeaseAccessoryLines Hide Lease Accessory Lines      
SM69110 NCHAR SWITCH 1 0 1 HideMaintenanceAccessoryLines Hide Maintenance Accessory Lines      
SM69111 INT INTEGER 0 0 2 CreditMode Credit Mode      
SM69112 NUMERIC X_NUMERIC 20 8 12 MinInvoiceTimeValue Min Invoice Time Value      
SM69113 INT INTEGER 0 0 2 DecimalInvoiceTimeValue Decimals in Invoice Time Value      
SM69114 INT INTEGER 0 0 2 LineInvoiceIntervalUnit Line invoice interval unit      
SM69115 NVARCHAR VSTRING 10 0 10 PriceCalculationProfile Price Calculation Profile      
SM69116 NVARCHAR VSTRING 3 0 3 BestPriceCode Best Price Code      
SM69117 INT INTEGER 0 0 2 ConsolidationMode Consolidation Mode      
SM69118 INT INTEGER 0 0 1 BestPriceType 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 LinkWithPOTill Link with PO till      
SM69123 INT INTEGER 0 0 1 DeliveryDateMilestone Delivery Date Milestone      
SM69124 NUMERIC X_NUMERIC 20 8 12 DeliveryTimeValue Delivery Time Value      
SM69125 INT INTEGER 0 0 2 DeliveryTimeUnit Delivery Time Unit      
SM69126 NCHAR SWITCH 1 0 1 UpdatePOStatistics Update PO Statistics      
SM69127 INT INTEGER 0 0 2 InvoicingModel Invoicing Model      
SM69128 INT INTEGER 0 0 2 ClosingRule Closing Rule      
SM69129 NCHAR STRING 3 0 3 RevenueRecognitionModel Revenue Recognition Model      
SM69130 NVARCHAR VSTRING 6 0 6 Default Return WH Default Return WH      
SM69131 NVARCHAR VSTRING 10 0 10 Operation Type (Asset Maintenance Line) Operation Type (Asset Maintenance Line)      
SM69132 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Asset Maintenance Line) Financial Operation Code (Asset Maintenance Line)      
SM69133 NVARCHAR VSTRING 10 0 10 Operation Type (Accessory Lease Line) Operation Type (Accessory Lease Line)      
SM69134 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Accessory Lease Line) Financial Operation Code (Accessory Lease Line)      
SM69135 NVARCHAR VSTRING 10 0 10 Operation Type (Accessory Maintenance Line) Operation Type (Accessory Maintenance Line)      
SM69136 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Accessory Maintenance Line) Financial Operation Code (Accessory Maintenance Line)      
SM69137 INT INTEGER 0 0 2 ServiceProvisionDateForTax Service Provision date for Tax      
SM69138 NCHAR STRING 3 0 3 Taxation Reason Code Taxation Reason Code      

Навигация / Navigation: