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

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table GLTR — Transformation Rules for BLiner functionality

Таблица / Table: GLTR — «GL Transformation Rule». Маска имени таблицы / Table name mask: «GLTR%cc%yy»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
GLTR001 NCHAR STRING 4 0 4 RuleID Rule ID PK 1 of 1 1 Да / Yes
GLTR002 NVARCHAR VSTRING 50 0 50 Description Description Description of Rule    
GLTR003 NVARCHAR ACCSTR 120 0 120 AccString1 Acc String 1 Real Acc String with/or template symbols    
GLTR004 NVARCHAR ACCSTR 120 0 120 AccString2 Acc String 2 Real Acc String with/or template symbols    
GLTR005 INT INTEGER 0 0 4 SortOrder Sort Order Rule with lower sort order is applied first.

Secondary unique index, 1 of 1.
    
GLTR006 NVARCHAR VSTRING 100 0 100 TransactionTypes 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 SourceModules 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 JournalCode Journal Code Filled by existing journal code or empty. If filled – rule is applied only if transaction lines have this journal code in GL06008.    

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