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

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
GL62001 NCHAR STRING 2 0 2 Category Compound Category   1 Да
GL62002 NCHAR STRING 1 0 1 Typeamtbal Type   2 Да
GL62003 INT INTEGER 0 0 4 AllocNum Allocation Number   3 Да
GL62004 INT INTEGER 0 0 3 AllocLineNo Allocation Line Number   4 Да
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      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | General Ledger | Compound Allocation Lines