One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Список таблиц модуля /List of tables of module «Service Order Management»

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table SM10 — Service Order Type Parameter

Таблица / Table: SM10 — «Service Order Type Parameter File I/O». Маска имени таблицы / Table name mask: «SM10%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SM10001 NCHAR STRING 6 0 6 OrderTypeNo Order Type   1 Да / Yes
SM10002 NCHAR STRING 2 0 2 Object Object Specifies the type of parameters the option string holds for the order type:

00 — General order type options

01 — Document options

09 — Activity line options

10 — Cost line options

11 — Material line options
2 Да / Yes
SM10003 NCHAR STRING 2 0 2 ObjectType Object Type   3 Да / Yes
SM10004 NCHAR STRING 32 0 32 TxtSwUserLevel Option String 1      
SM10005 NCHAR STRING 64 0 64 TxtSwUserLev2 Option String 2      
SM10006 NVARCHAR ACCSTR 120 0 120 AccString Accounting String      
SM10007 NVARCHAR VSTRING 3 0 3 IntegrAccDimName Integrated AccDim Name      
SM10008 NVARCHAR VSTRING 3 0 3 IntegrAccDimDescr1 Integrated AccDim Descr Line 1      
SM10009 NVARCHAR VSTRING 3 0 3 IntegrAccDimDescr2 Integrated AccDim Descr Line 2      
SM10010 NVARCHAR VSTRING 10 0 10 OperationTypeTime Operation Type Time      
SM10011 NVARCHAR VSTRING 10 0 10 FinancialOperationCodeTime Financial Operation Code Time      
SM10012 NVARCHAR VSTRING 10 0 10 OperationTypeCost Operation Type Cost      
SM10013 NVARCHAR VSTRING 10 0 10 FinancialOperationCodeCost Financial Operation Code Cost      
SM10014 NVARCHAR VSTRING 10 0 10 OperationTypeMaterial Operation Type Material      
SM10015 NVARCHAR VSTRING 10 0 10 FinancialOperationCodeMaterial Financial Operation Code Material      
SM10016 NVARCHAR VSTRING 2 0 2 OrderStatusForClosed Order status for Closed      
SM10017 NVARCHAR VSTRING 50 0 50 OverviewConfiguration Overview Configuration      
SM10018 NCHAR SWITCH 1 0 1 ExecutionOrder Execution Order      
SM10019 NCHAR SWITCH 1 0 1 ExtendedCommission Extended Commission      
SM10020 INT INTEGER 0 0 1 ClosingRule Closing rule      
SM10021 NCHAR STRING 3 0 3 ReasonCode Reason Code      
SM10022 INT INTEGER 0 0 1 DeductionRule Deduction Rule      
SM10023 NCHAR STRING 3 0 3 DefaultSNTransactionTypeForESC Default Serial Number Transaction Type For ESC      

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