Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: GL65 - «Allocation Trans. remeasure File». Маска имени таблицы: «GL65%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
GL65001 | DATETIME | DATE | 0 | 0 | 8 | DATE_ | Transaction Date (Source) | |||
GL65002 | INT | INTEGER | 0 | 0 | 6 | Transaction_number | Transaction Number (Source) | 2 | Да | |
GL65003 | NCHAR | STRING | 2 | 0 | 2 | translation_number | Translation Number | 1 | Да | |
GL65004 | NCHAR | STRING | 2 | 0 | 2 | Currency_code_src | Currency Code Source | |||
GL65005 | NCHAR | STRING | 1 | 0 | 1 | Currency_type_src | Currency Type Source | 0 - Ordinary currency
1 - Floating EMU currency 2 - EMU compliant currency 3 - Euro |
||
GL65006 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Rate_1_src | Currency Exchange Rate 1 | |||
GL65007 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | rate_2_src | Currency Exchange Rate 2 | |||
GL65008 | NVARCHAR | ACCSTR | 50 | 0 | 50 | Accounting_str_src | Accounting String Source | |||
GL65009 | NCHAR | STRING | 2 | 0 | 2 | Curremcy_code_target | Currency Code Target | |||
GL65010 | NCHAR | STRING | 1 | 0 | 1 | Currency_type_targ | Currency Type Target | 0 - Ordinary currency
1 - Floating EMU currency 2 - EMU compliant currency 3 - Euro |
||
GL65011 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Rate_1_target | Currency Exchange Rate 1 (Target) | |||
GL65012 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | rate_2_target | Currency Exchange Rate 2 (Target) | |||
GL65013 | NVARCHAR | ACCSTR | 50 | 0 | 50 | Accounting_str_targ | Accounting String Target | |||
GL65014 | NUMERIC | MONEY | 28 | 8 | 20 | Amount_target | Amount Target | |||
GL65015 | NVARCHAR | VSTRING | 2 | 0 | 2 | CompanyCodeSrc | Company Code Source | |||
GL65016 | INT | INTEGER | 0 | 0 | 2 | MinPeriod | Minimum Period | |||
GL65017 | INT | INTEGER | 0 | 0 | 2 | MaxPeriod | Maximum Period | |||
GL65018 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | SourceAmount | Source Amount | |||
GL65019 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | TranslAmount | Translated Amount | |||
GL65020 | NCHAR | STRING | 2 | 0 | 2 | RestatedCurCode | Currency Code Restated | |||
GL65021 | NCHAR | STRING | 1 | 0 | 1 | RestatedCurType | Currency Type Restated | 0 - Ordinary currency
1 - Floating EMU currency 2 - EMU compliant currency 3 - Euro |
||
GL65022 | NVARCHAR | VSTRING | 25 | 0 | 25 | TransTextSource | Transaction Text Source | |||
GL65023 | NVARCHAR | VSTRING | 25 | 0 | 25 | TransTextTarget | Transaction Text Target | |||
GL65024 | NCHAR | STRING | 3 | 0 | 3 | SourceCurName | Currency Name Source | |||
GL65025 | NCHAR | STRING | 3 | 0 | 3 | RestatedCurName | Currency Name Restated | |||
GL65026 | NCHAR | STRING | 3 | 0 | 3 | TargetCurName | Currency Name Target | |||
GL65027 | NCHAR | STRING | 2 | 0 | 2 | TargetCompCode | Company Code Target | |||
GL65028 | NCHAR | STRING | 6 | 0 | 6 | TargetTransNum | Transaction Number Target | |||
GL65029 | NCHAR | STRING | 5 | 0 | 5 | LineNumber | Line Number | 3 | Да |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | General Ledger | Compound Allocation Remeasurement Transactions