One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Заказ на Закупку»/List of tables of module «Purchase Order»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table PCTH — Order Template Header

Таблица / Table: PCTH — «Order Template Header». Маска имени таблицы / Table name mask: «PCTH%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PCTH001 NCHAR STRING 4 0 4 OrderTemplateID Order Template ID   2 Да / Yes
PCTH002 NVARCHAR VSTRING 25 0 25 Description Description      
PCTH003 NCHAR SWITCH 1 0 1 Horizontalscroll Horizontal scroll      
PCTH004 INT INTEGER 0 0 2 FrozenColumns Frozen Columns      
PCTH005 NCHAR SWITCH 1 0 1 Applicabletoordertype0 Applicable to order type 0      
PCTH006 INT INTEGER 0 0 2 Permissionordertype0 Permission order type 0      
PCTH007 NCHAR SWITCH 1 0 1 Defaultforordertype0 Default for order type 0      
PCTH008 NCHAR SWITCH 1 0 1 Applicabletoordertype1 Applicable to order type 1      
PCTH009 INT INTEGER 0 0 2 Permissionordertype1 Permission order type 1      
PCTH010 NCHAR SWITCH 1 0 1 Defaultforordertype1 Default for order type 1      
PCTH011 NCHAR SWITCH 1 0 1 Applicabletoordertype2 Applicable to order type 2      
PCTH012 INT INTEGER 0 0 2 Permissionordertype2 Permission order type 2      
PCTH013 NCHAR SWITCH 1 0 1 Defaultforordertype2 Default for order type 2      
PCTH014 NCHAR SWITCH 1 0 1 Applicabletoordertype3 Applicable to order type 3      
PCTH015 INT INTEGER 0 0 2 Permissionordertype3 Permission order type 3      
PCTH016 NCHAR SWITCH 1 0 1 Defaultforordertype3 Default for order type 3      
PCTH017 NCHAR SWITCH 1 0 1 Applicabletoordertype4 Applicable to order type 4      
PCTH018 INT INTEGER 0 0 2 Permissionordertype4 Permission order type 4      
PCTH019 NCHAR SWITCH 1 0 1 Defaultforordertype4 Default for order type 4      
PCTH020 NCHAR SWITCH 1 0 1 Spare Spare      
PCTH021 INT INTEGER 0 0 2 Spare Spare      
PCTH022 NCHAR SWITCH 1 0 1 Spare Spare      
PCTH023 NCHAR SWITCH 1 0 1 Applicabletoordertype6 Applicable to order type 6      
PCTH024 INT INTEGER 0 0 2 Permissionordertype6 Permission order type 6      
PCTH025 NCHAR SWITCH 1 0 1 Defaultforordertype6 Default for order type 6      
PCTH026 NCHAR SWITCH 1 0 1 Templateproperty1 Template property 1      
PCTH027 NCHAR SWITCH 1 0 1 Templateproperty2 Template property 2      
PCTH028 NCHAR SWITCH 1 0 1 Templateproperty3 Template property 3      
PCTH029 NCHAR SWITCH 1 0 1 Templateproperty4 Template property 4      
PCTH030 NCHAR SWITCH 1 0 1 Templateproperty5 Template property 5      
PCTH031 NCHAR SWITCH 1 0 1 Templateproperty6 Template property 6      
PCTH032 INT INTEGER 0 0 10 ForegroundRW Foreground RW      
PCTH033 INT INTEGER 0 0 10 BackgroundRW Background RW      
PCTH034 INT INTEGER 0 0 10 ForegroundRO_CMD Foreground RO + cmd      
PCTH035 INT INTEGER 0 0 10 BackgroundRO_CMD Background RO + cmd      
PCTH036 INT INTEGER 0 0 10 ForegroundRO Foreground RO      
PCTH037 INT INTEGER 0 0 10 BackgroundRO Background RO      
PCTH038 INT INTEGER 0 0 10 ForegroundLinked Foreground Linked      
PCTH039 INT INTEGER 0 0 10 BackgroundLinked Background Linked      
PCTH040 NCHAR SWITCH 1 0 1 QueryTemplate0 Query Template 0      
PCTH041 NCHAR SWITCH 1 0 1 QueryTemplate1 Query Template 1      
PCTH042 NCHAR SWITCH 1 0 1 QueryTemplate2 Query Template 2      
PCTH043 NCHAR SWITCH 1 0 1 QueryTemplate3 Query Template 3      
PCTH044 NCHAR SWITCH 1 0 1 QueryTemplate4 Query Template 4      
PCTH045 NCHAR SWITCH 1 0 1 QueryTemplate5 Query Template 5      
PCTH046 NCHAR SWITCH 1 0 1 QueryTemplate6 Query Template 6      
PCTH047 NCHAR STRING 2 0 2 TemplateType Template Type   1 Да / Yes

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