пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Главная Книга»/List of tables of module «General Ledger»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table GL62 — Compound Allocation Lines

Таблица / Table: GL62 — «Allocation Transaction File». Маска имени таблицы / Table name mask: «GL62%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
GL62001 NCHAR STRING 2 0 2 Category Compound Category   1 Да / Yes
GL62002 NCHAR STRING 1 0 1 Typeamtbal Type   2 Да / Yes
GL62003 INT INTEGER 0 0 4 AllocNum Allocation Number   3 Да / Yes
GL62004 INT INTEGER 0 0 3 AllocLineNo Allocation Line Number   4 Да / Yes
GL62005 NVARCHAR VSTRING 12 0 12 Account Account Action for each account on new transactions:

A valid account or a string with wildcards.

Wildcards: % — Copy character, $$ — Financial year, ### — Country code, ** — Insert company code, Anything else is literal.
   
GL62006 NVARCHAR VSTRING 12 0 12 Dimension1 Accounting Dimension 1 Action for accounting dimension 1 on new transactions:

[blank] — Leave accounting dimension blank, A valid accounting dimension or a string with wildcards.

Wildcards: % — Copy character, $$ — Financial year, ### — Country code, ** — Insert company code, Anything else is literal.
   
GL62007 NVARCHAR VSTRING 12 0 12 dimension2 Accounting Dimension 2 Action for accounting dimension 2 on new transactions:

[blank] — Leave accounting dimension blank, A valid accounting dimension or a string with wildcards.

Wildcards: % — Copy character, $$ — Financial year, ### — Country code, ** — Insert company code, Anything else is literal.
   
GL62008 NVARCHAR VSTRING 12 0 12 Dimension3 Accounting Dimension 3 Action for accounting dimension 3 on new transactions:

[blank] — Leave accounting dimension blank, A valid accounting dimension or a string with wildcards.

Wildcards: % — Copy character, $$ — Financial year, ### — Country code, ** — Insert company code, Anything else is literal.
   
GL62009 NUMERIC X_NUMERIC 28 8 20 Coefficient Constant      
GL62010 NVARCHAR VSTRING 25 0 25 Text Text      
GL62011 NVARCHAR VSTRING 12 0 12 Dimension4 Accounting Dimension 4 Accounting segment 4    
GL62012 NVARCHAR VSTRING 12 0 12 Dimension5 Accounting Dimension 5 Accounting segment 5    
GL62013 NVARCHAR VSTRING 12 0 12 Dimension6 Accounting Dimension 6 Accounting segment 6    
GL62014 NVARCHAR VSTRING 12 0 12 Dimension7 Accounting Dimension 7 Accounting segment 7    
GL62015 NVARCHAR VSTRING 12 0 12 Dimension8 Accounting dimension 8 Accounting segment 8    
GL62016 NVARCHAR VSTRING 12 0 12 Dimension9 Accounting dimension 9 Accounting segment 9    

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