Таблица: GL65 - «Allocation Trans. remeasure File». Маска имени таблицы: «GL65%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
GL65001 | DATETIME | DATE | 0 | 0 | 8 | DATE | Transaction Date (Source) | |||
GL65002 | INT | INTEGER | 0 | 0 | 9 | Transactionnumber | Transaction Number (Source) | 2 | Да | |
GL65003 | NCHAR | STRING | 2 | 0 | 2 | translationnumber | Translation Number | 1 | Да | |
GL65004 | NCHAR | STRING | 2 | 0 | 2 | CurrCodeSrc | Currency Code Source | |||
GL65005 | NCHAR | STRING | 1 | 0 | 1 | CurrTypeSrc | Currency Type Source | 0 - Ordinary currency
1 - Floating EMU currency 2 - EMU compliant currency 3 - Euro |
||
GL65006 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Rate1src | Currency Exchange Rate 1 | |||
GL65007 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | rate2src | Currency Exchange Rate 2 | |||
GL65008 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccStrSrc | Accounting String Source | |||
GL65009 | NCHAR | STRING | 2 | 0 | 2 | CurrCodeTarget | Currency Code Target | |||
GL65010 | NCHAR | STRING | 1 | 0 | 1 | CurrTypeTarg | Currency Type Target | 0 - Ordinary currency
1 - Floating EMU currency 2 - EMU compliant currency 3 - Euro |
||
GL65011 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Rate1target | Currency Exchange Rate 1 (Target) | |||
GL65012 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | rate2target | Currency Exchange Rate 2 (Target) | |||
GL65013 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccStrTarg | Accounting String Target | |||
GL65014 | NUMERIC | MONEY | 28 | 8 | 20 | AmntTarget | 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 | 9 | 0 | 9 | TargetTransNum | Transaction Number Target | |||
GL65029 | NCHAR | STRING | 7 | 0 | 7 | LineNumber | Line Number | 3 | Да |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | General Ledger | Compound Allocation Remeasurement Transactions