Таблица: 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