Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: GL62 - «Allocation Transaction File». Маска имени таблицы: «GL62%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
GL62001 | NCHAR | STRING | 2 | 0 | 2 | Category | Compound Category | 1 | Да | |
GL62002 | NCHAR | STRING | 1 | 0 | 1 | Type_amt_bal | Type | 2 | Да | |
GL62003 | INT | INTEGER | 0 | 0 | 4 | Allocation_number | Allocation Number | 3 | Да | |
GL62004 | INT | INTEGER | 0 | 0 | 3 | Allocation_line_no | 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 | 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 |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | General Ledger | Compound Allocation Lines