Таблица: GLTR - «GL Transformation Rule». Маска имени таблицы: «GLTR%cc%yy»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
GLTR001 | NCHAR | STRING | 4 | 0 | 4 | Rule ID | Rule ID | PK 1 of 1 | 1 | Да |
GLTR002 | NVARCHAR | VSTRING | 50 | 0 | 50 | Description | Description | Description of Rule | ||
GLTR003 | NVARCHAR | ACCSTR | 50 | 0 | 50 | Acc String 1 | Acc String 1 | Real Acc String with/or template symbols | ||
GLTR004 | NVARCHAR | ACCSTR | 50 | 0 | 50 | Acc String 2 | Acc String 2 | Real Acc String with/or template symbols | ||
GLTR005 | INT | INTEGER | 0 | 0 | 4 | Sort Order | Sort Order | Rule with lower sort order is applied first.
Secondary unique index, 1 of 1. |
||
GLTR006 | NVARCHAR | VSTRING | 100 | 0 | 100 | Transaction Types | Transaction Types | Comma separated list of transaction types
(GL06012) to which rule is applicable. Empty – Rule is applicable for all transaction types. |
||
GLTR007 | NVARCHAR | VSTRING | 100 | 0 | 100 | Source Modules | Source Modules | Comma separated list of source modules
(GL06038) to which th rule is applicable. Empty – Rule is applicable for all source modules. |
||
GLTR008 | NVARCHAR | VSTRING | 6 | 0 | 6 | Journal Code | Journal Code | Filled by existing journal code or empty. If filled – rule is applied only if transaction lines have this journal code in GL06008. |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | General Ledger | Transformation Rules for BLiner functionality