Таблица | Table: ORTH - «Order Template header». Маска имени таблицы | Table Name Mask: «ORTH%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
ORTH001 | NCHAR | STRING | 4 | 0 | 4 | Order Template ID | Order Template ID | 1 | Да / Yes | |
ORTH002 | NVARCHAR | VSTRING | 25 | 0 | 25 | Description | Description | |||
ORTH003 | NCHAR | SWITCH | 1 | 0 | 1 | Horizontal scroll | Horizontal scroll | |||
ORTH004 | INT | INTEGER | 0 | 0 | 2 | Frozen columns | Frozen columns | |||
ORTH005 | NCHAR | SWITCH | 1 | 0 | 1 | ApplyOrderType0 | Applicable to order type 0 | |||
ORTH006 | INT | INTEGER | 0 | 0 | 2 | PermissionOrderType0 | Permission order type 0 | |||
ORTH007 | NCHAR | SWITCH | 1 | 0 | 1 | DefaultOrderType0 | Default for order type 0 | |||
ORTH008 | NCHAR | SWITCH | 1 | 0 | 1 | ApplyOrderType1 | Applicable to order type 1 | |||
ORTH009 | INT | INTEGER | 0 | 0 | 2 | PermissionOrderType1 | Permission order type 1 | |||
ORTH010 | NCHAR | SWITCH | 1 | 0 | 1 | DefaultOrderType1 | Default for order type 1 | |||
ORTH011 | NCHAR | SWITCH | 1 | 0 | 1 | ApplyOrderType2 | Applicable to order type 2 | |||
ORTH012 | INT | INTEGER | 0 | 0 | 2 | PermissionOrderType2 | Permission order type 2 | |||
ORTH013 | NCHAR | SWITCH | 1 | 0 | 1 | DefaultOrderType2 | Default for order type 2 | |||
ORTH014 | NCHAR | SWITCH | 1 | 0 | 1 | ApplyOrderType3 | Applicable to order type 3 | |||
ORTH015 | INT | INTEGER | 0 | 0 | 2 | PermissionOrderType3 | Permission order type 3 | |||
ORTH016 | NCHAR | SWITCH | 1 | 0 | 1 | DefaultOrderType3 | Default for order type 3 | |||
ORTH017 | NCHAR | SWITCH | 1 | 0 | 1 | ApplyOrderType4 | Applicable to order type 4 | |||
ORTH018 | INT | INTEGER | 0 | 0 | 2 | PermissionOrderType4 | Permission order type 4 | |||
ORTH019 | NCHAR | SWITCH | 1 | 0 | 1 | DefaultOrderType4 | Default for order type 4 | |||
ORTH020 | NCHAR | SWITCH | 1 | 0 | 1 | ApplyOrderType5 | Applicable to order type 5 | |||
ORTH021 | INT | INTEGER | 0 | 0 | 2 | PermissionOrderType5 | Permission order type 5 | |||
ORTH022 | NCHAR | SWITCH | 1 | 0 | 1 | DefaultOrderType5 | Default for order type 5 | |||
ORTH023 | NCHAR | SWITCH | 1 | 0 | 1 | ApplyOrderType6 | Applicable to order type 6 | |||
ORTH024 | INT | INTEGER | 0 | 0 | 2 | PermissionOrderType6 | Permission order type 6 | |||
ORTH025 | NCHAR | SWITCH | 1 | 0 | 1 | DefaultOrderType6 | Default for order type 6 | |||
ORTH026 | NCHAR | SWITCH | 1 | 0 | 1 | ApplyOrderType7 | Applicable to order type 7 | |||
ORTH027 | INT | INTEGER | 0 | 0 | 2 | PermissionOrderType7 | Permission order type 7 | |||
ORTH028 | NCHAR | SWITCH | 1 | 0 | 1 | DefaultOrderType7 | Default for order type 7 | |||
ORTH029 | NCHAR | SWITCH | 1 | 0 | 1 | ApplyOrderType8 | Applicable to order type 8 | |||
ORTH030 | INT | INTEGER | 0 | 0 | 2 | PermissionOrderType8 | Permission order type 8 | |||
ORTH031 | NCHAR | SWITCH | 1 | 0 | 1 | DefaultOrderType8 | Default for order type 8 | |||
ORTH032 | NCHAR | SWITCH | 1 | 0 | 1 | ApplyOrderType9 | Applicable to order type 9 | |||
ORTH033 | INT | INTEGER | 0 | 0 | 2 | PermissionOrderType9 | Permission order type 9 | |||
ORTH034 | NCHAR | SWITCH | 1 | 0 | 1 | DefaultOrderType9 | Default for order type 9 | |||
ORTH035 | NCHAR | SWITCH | 1 | 0 | 1 | Template Property 1 | Template Property 1 | |||
ORTH036 | NCHAR | SWITCH | 1 | 0 | 1 | Template Property 2 | Template Property 2 | |||
ORTH037 | NCHAR | SWITCH | 1 | 0 | 1 | Template Property 3 | Template Property 3 | |||
ORTH038 | NCHAR | SWITCH | 1 | 0 | 1 | Template Property 4 | Template Property 4 | |||
ORTH039 | NCHAR | SWITCH | 1 | 0 | 1 | Template Property 5 | Template Property 5 | |||
ORTH040 | NCHAR | SWITCH | 1 | 0 | 1 | Template Property 6 | Template Property 6 | |||
ORTH041 | INT | INTEGER | 0 | 0 | 10 | Foreground rw | Foreground rw | |||
ORTH042 | INT | INTEGER | 0 | 0 | 10 | Background rw | Background rw | |||
ORTH043 | INT | INTEGER | 0 | 0 | 10 | Foreground ro + cmd | Foreground ro + cmd | |||
ORTH044 | INT | INTEGER | 0 | 0 | 10 | Background ro + cmd | Background ro + cmd | |||
ORTH045 | INT | INTEGER | 0 | 0 | 10 | Foreground ro | Foreground ro | |||
ORTH046 | INT | INTEGER | 0 | 0 | 10 | Background ro | Background ro |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Sales Order | Order Template header