Таблица: GL5A - «Multi-Currency Links». Маска имени таблицы: «GL5A%cc%yy»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
GL5A001 | NCHAR | STRING | 12 | 0 | 12 | ParentAccountNO | Parent Account | 1 | Да | |
GL5A002 | NCHAR | STRING | 12 | 0 | 12 | LinkedAccountNO | Linked Statistical Currency Account | |||
GL5A003 | NCHAR | STRING | 12 | 0 | 12 | ProfitAccountCode | Profit Account | |||
GL5A004 | NCHAR | STRING | 12 | 0 | 12 | LossAccountCode | Loss Account | |||
GL5A005 | NCHAR | STRING | 10 | 0 | 10 | RateFlags | Rate Options | Rate option for debit, first character in string is for debit transaction lines and second character is for credit:
0 - Query menu to adjust the rate at transaction entry. 1 - Debit/Credit transactions are calculated using selling rate for currency. 2 - Debit/Credit transactions are calculated using buying rate for currency. |
||
GL5A006 | INT | INTEGER | 0 | 0 | 2 | CurrencyCode | Currency Code | 2 | Да | |
GL5A007 | NCHAR | STRING | 2 | 0 | 2 | RevaluationMethod | Revaluation Method | 0 - No revaluation
1 - Only revaluate account when the result is a currency loss. 2 - Revaluate account regardless if the result is a profit or a loss. 3 - Only revaluate account when the result is a currency profit. |
||
GL5A008 | NVARCHAR | VSTRING | 12 | 0 | 12 | AccrualAccountCode | Accrual Account |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | General Ledger | Multi-Currency Links