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

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision 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 Type_amt_bal Type   2 Да / Yes
GL62003 INT INTEGER 0 0 4 Allocation_number Allocation Number   3 Да / Yes
GL62004 INT INTEGER 0 0 3 Allocation_line_no 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 Dimension_1 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 dimension_2 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 Dimension_3 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      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | General Ledger | Compound Allocation Lines