Таблица: GL67 - «Consolidation sel. history File». Маска имени таблицы: «GL67%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
GL67001 | DATETIME | DATE | 0 | 0 | 8 | date_ | Run Date | 1 | Да | |
GL67002 | INT | INTEGER | 0 | 0 | 6 | Transaction_number | Transaction Number | 2 | Да | |
GL67003 | NCHAR | STRING | 2 | 0 | 2 | Translation_no | Translation Number | 3 | Да | |
GL67004 | NVARCHAR | VSTRING | 12 | 0 | 12 | From_account | Minimum Account | |||
GL67005 | NVARCHAR | VSTRING | 12 | 0 | 12 | To_account | Maximum Account | |||
GL67006 | NVARCHAR | VSTRING | 2 | 0 | 2 | From_Dimension_1_cat | Minimum Category Accounting Dimension 1 | |||
GL67007 | NVARCHAR | VSTRING | 2 | 0 | 2 | to_dim1_cat | Maximum Category Accounting Dimension 1 | |||
GL67008 | NVARCHAR | VSTRING | 12 | 0 | 12 | from_dim1 | Minimum Accounting Dimension 1 | |||
GL67009 | NVARCHAR | VSTRING | 12 | 0 | 12 | to_dim_1 | Maximum Accounting Dimension 1 | |||
GL67010 | NVARCHAR | VSTRING | 2 | 0 | 2 | from_dim2_cat | Minimum Category Accounting Dimension 2 | |||
GL67011 | NVARCHAR | VSTRING | 2 | 0 | 2 | to_dim2_cat | Maximum Category Accounting Dimension 2 | |||
GL67012 | NVARCHAR | VSTRING | 12 | 0 | 12 | from_dim2 | Minimum Accounting Dimension 2 | |||
GL67013 | NVARCHAR | VSTRING | 12 | 0 | 12 | to_dim2 | Maximum Accounting Dimension 2 | |||
GL67014 | NVARCHAR | VSTRING | 2 | 0 | 2 | from_dim3_cat | Minimum Category Accounting Dimension 3 | |||
GL67015 | NVARCHAR | VSTRING | 2 | 0 | 2 | to_dim3_cat | Maximum Category Accounting Dimension 3 | |||
GL67016 | NVARCHAR | VSTRING | 12 | 0 | 12 | from_dim3 | Minimum Accounting Dimension 3 | |||
GL67017 | NVARCHAR | VSTRING | 12 | 0 | 12 | To_Dim_3 | Maximum Accounting Dimension 3 |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | General Ledger | Compound Allocation Selection History