Таблица / Table: AMH6 — «Depreciation per Currency History». Маска имени таблицы / Table name mask: «AMH6%cc00»
Поле / Field | Тип поля / Field Type | Тип поля Scala / iScala Field Type | Длина поля / Field length | Точность / Precision | Длина Scala / iScala length | Комментарий / Comment | Расширенный комментарий / Extended comment | Дополнительное описание / Additional description | Позиция в индексе / Index position | Первичный ключ? / Is Primary key? |
AMH6001 | NCHAR | STRING | 3 | 0 | 3 | TransactionType | Transaction Type | 1 | Да / Yes | |
AMH6002 | DATETIME | DATE | 0 | 0 | 8 | TransactionDate | Transaction Date | 2 | Да / Yes | |
AMH6003 | NCHAR | STRING | 9 | 0 | 9 | TransactionTime | Transaction Time | 3 | Да / Yes | |
AMH6004 | NVARCHAR | VSTRING | 35 | 0 | 35 | InventoryCode | Asset Code | 4 | Да / Yes | |
AMH6005 | NCHAR | STRING | 10 | 0 | 10 | TransactionCode | Transaction Code | 5 | Да / Yes | |
AMH6006 | NCHAR | STRING | 8 | 0 | 8 | UserID | User ID | 6 | Да / Yes | |
AMH6007 | INT | INTEGER | 0 | 0 | 10 | TransactionCounter | Transaction Number | 7 | Да / Yes | |
AMH6008 | NCHAR | STRING | 2 | 0 | 2 | CurrCode | Currency Code Depreciation | 8 | Да / Yes | |
AMH6009 | NVARCHAR | VSTRING | 2 | 0 | 2 | DepMethodTax | [Tax] Depreciation Method | Depreciation methods: 0 — No depreciation. 1 — As percentage of the depreciation basis (Straight Line). 2 — As percentage of the balance (Reducing Balance) 3 — Fixed Amount per Financial Year. 4 — Sum for the Year (SOY. 5 — Proportional Depreciation 6 — The method is designed for Assets with the economic life more than a year. 7 — Double Declining 8 — As percentage of the depreciation basis (Straight Line). 9 — The assets are depreciated by 50% at acquisition and 50% when the Asset is no longer used. 10 — Percentage of the remaining amount. 11 — The depreciation amount is calculated as a product of the residual value of the Asset and the rate of depreciation determined for the given asset. |
||
AMH6010 | NVARCHAR | VSTRING | 12 | 0 | 12 | NLBalAccTax | [Tax] Balance Account Over/Under Depreciations | |||
AMH6011 | NVARCHAR | VSTRING | 12 | 0 | 12 | NLPLAccTax | [Tax] P&L Account Over/Under Depreciations | |||
AMH6012 | NVARCHAR | VSTRING | 3 | 0 | 3 | DepPerYrTax | [Tax] Depreciation Periods/Years | |||
AMH6013 | NVARCHAR | VSTRING | 6 | 0 | 6 | DeprTax | [Tax] Depreciation % | |||
AMH6014 | NUMERIC | MONEY | 28 | 8 | 20 | DeprAmTax | [Tax] Depreciation Amount | |||
AMH6015 | NUMERIC | MONEY | 28 | 8 | 20 | DeprBaseTax | [Tax] Depreciation Base | |||
AMH6016 | NUMERIC | MONEY | 28 | 8 | 20 | ResidualValueTAX | [Tax] Residual Value | |||
AMH6017 | NUMERIC | MONEY | 28 | 8 | 20 | AccDeprTax | [Tax] Accumulated Depreciations | |||
AMH6018 | NUMERIC | MONEY | 28 | 8 | 20 | DeprYearTax | [Tax] Depreciations Current Year | |||
AMH6019 | NUMERIC | MONEY | 28 | 8 | 20 | ExtraDeprTax | [Tax] Extra Depreciations | |||
AMH6020 | NVARCHAR | VSTRING | 6 | 0 | 6 | Depr2Tax | [Tax] Depreciation % 2 | |||
AMH6021 | NVARCHAR | VSTRING | 1 | 0 | 1 | DeprSwTax | [Tax] Depreciation Switch | |||
AMH6022 | NVARCHAR | VSTRING | 2 | 0 | 2 | DepMethodPln | [Plan] Depreciation Method | |||
AMH6023 | NVARCHAR | VSTRING | 12 | 0 | 12 | NLBalAccPln | [Plan] Balance Account Depreciations | |||
AMH6024 | NVARCHAR | VSTRING | 12 | 0 | 12 | NLPLAccPln | [Plan] P&L Account Depreciations | |||
AMH6025 | NVARCHAR | VSTRING | 3 | 0 | 3 | DepPerYrPln | [Plan] Depreciation Periods/Years | |||
AMH6026 | NVARCHAR | VSTRING | 6 | 0 | 6 | DeprPln | [Plan] Depreciation % | |||
AMH6027 | NUMERIC | MONEY | 28 | 8 | 20 | DeprAmPln | [Plan] Depreciation Amount | |||
AMH6028 | NUMERIC | MONEY | 28 | 8 | 20 | DeprBasePln | [Plan] Depreciation Base | |||
AMH6029 | NUMERIC | MONEY | 28 | 8 | 20 | ResidualValuePLAN | [Plan] Residual Value | |||
AMH6030 | NUMERIC | MONEY | 28 | 8 | 20 | AccDeprPln | [Plan] Accumulated Depreciations | |||
AMH6031 | NUMERIC | MONEY | 28 | 8 | 20 | DeprYearPln | [Plan] Depreciations this year | |||
AMH6032 | NUMERIC | MONEY | 28 | 8 | 20 | ExtraDeprPln | [Plan] Extra Depreciations | |||
AMH6033 | NVARCHAR | VSTRING | 2 | 0 | 2 | Per1WoDepr | [Plan] Period Without Depreciations 1 | |||
AMH6034 | NVARCHAR | VSTRING | 2 | 0 | 2 | Per2WoDepr | [Plan] Period Without Depreciations 2 | |||
AMH6035 | NVARCHAR | VSTRING | 2 | 0 | 2 | Per3WoDepr | [Plan] Period Without Depreciations 3 | |||
AMH6036 | NVARCHAR | VSTRING | 6 | 0 | 6 | Depr2Pln | [Plan] Depreciation % 2 | |||
AMH6037 | NVARCHAR | VSTRING | 1 | 0 | 1 | DeprSwPln | [Plan] Depreciation Switch | |||
AMH6038 | NUMERIC | MONEY | 28 | 8 | 20 | PurchaseCost | Purchase Cost | |||
AMH6039 | NVARCHAR | VSTRING | 1 | 0 | 1 | DailyDeprPln | [Plan] Depreciate on Daily Basis | |||
AMH6040 | NVARCHAR | VSTRING | 1 | 0 | 1 | DailyDeprTax | [Tax] Depreciate on Daily Basis | |||
AMH6041 | NVARCHAR | VSTRING | 1 | 0 | 1 | Dummy | (obsolete) | |||
AMH6042 | NCHAR | STRING | 1 | 0 | 1 | DepPerUnitTx | [Tax] Depreciation Period Unit | |||
AMH6043 | NCHAR | STRING | 1 | 0 | 1 | DepPerUnitPn | [Plan] Depreciation Period Unit | |||
AMH6044 | NUMERIC | MONEY | 28 | 8 | 20 | SalesRevenue | Sales Revenue | |||
AMH6045 | INT | INTEGER | 0 | 0 | 1 | YearReducDeprTax | [Tax] Yearly Reducing Depreciation | |||
AMH6046 | DATETIME | DATE | 0 | 0 | 8 | DeprStartTax | [Tax] Depreciation Start Date | |||
AMH6047 | INT | INTEGER | 0 | 0 | 1 | YearReducDeprPlan | [Plan] Yearly Reducing Depreciation | |||
AMH6048 | DATETIME | DATE | 0 | 0 | 8 | DeprStartPlan | [Plan] Depreciation Start Date | |||
AMH6049 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
AMH6050 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
AMH6051 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
AMH6052 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
AMH6053 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
AMH6054 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
AMH6055 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
AMH6056 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodePUR | [PUR] Accounting Code Purchase Transactions | |||
AMH6057 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeTAX | [TAX] Accounting Code Tax Depreciation Transactions | |||
AMH6058 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodePLA | [PLA] Accounting Code Plan Depreciation Transactions | |||
AMH6059 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeSAL | [SAL] Accounting Code Sales Transactions | |||
AMH6060 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeSCR | [SCR] Accounting Code Scrap Transactions | |||
AMH6061 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeREV | [REV] Accounting Code Revaluation Transactions | |||
AMH6062 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeETX | [ETX] Accounting Code Extra Tax Transactions | |||
AMH6063 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeFUS | [FUS] Accounting Code Fusion Transactions | |||
AMH6064 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeICT | [ICT] Accounting Code IC Transfer Transactions | |||
AMH6065 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodePLP | [PLP] Accounting Code Purchasing from PL | |||
AMH6066 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeACT | [ACT] Accounting Code Activation from SM | |||
AMH6067 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeOLD | [OLD] Accounting Code Take Over from Old System | |||
AMH6068 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeTRA | [TRA] Accounting Code Transfer | |||
AMH6069 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeRES3 | [RES] Accounting Code spare 3 | |||
AMH6070 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeRES4 | [RES] Accounting Code spare 4 | |||
AMH6071 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeRES5 | [RES] Accounting Code spare 5 | |||
AMH6072 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeRES6 | [RES] Accounting Code spare 6 | |||
AMH6073 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeRES7 | [RES] Accounting Code spare 7 | |||
AMH6074 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeSFA | [SFA] Accounting Code Transfer from Stock | |||
AMH6075 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeSTO | [STO] Accounting Code Return to Stock | |||
AMH6076 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeREA | [REA] Accounting Code Automatic Revaluation | |||
AMH6077 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeRES11 | [RES] Accounting Code spare 11 | |||
AMH6078 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeRES12 | [RES] Accounting Code spare 12 | |||
AMH6079 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodePRC | [PRC] Accounting Code Project Capitalization | |||
AMH6080 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeRES14 | [RES] Accounting Code spare 14 | |||
AMH6081 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeRES15 | [RES] Accounting Code spare 15 | |||
AMH6082 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeRES16 | [RES] Accounting Code spare 16 | |||
AMH6083 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeRES17 | [RES] Accounting Code spare 17 | |||
AMH6084 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeRES18 | [RES] Accounting Code spare 18 | |||
AMH6085 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeRES19 | [RES] Accounting Code spare 19 | |||
AMH6086 | NCHAR | STRING | 2 | 0 | 2 | AccountingCodeRES20 | [RES] Accounting Code spare 20 | |||
AMH6087 | NUMERIC | MONEY | 28 | 8 | 20 | ScrapValueBooked | Scrap Value Booked | |||
AMH6088 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | AccelFactorPlan | Acceleration Factor (Plan) | |||
AMH6089 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | AccelFactorTax | Acceleration Factor (Tax) | |||
AMH6090 | NUMERIC | MONEY | 28 | 8 | 20 | DeprNextYearPlan | Depreciation during next year (Plan) | |||
AMH6091 | NUMERIC | MONEY | 28 | 8 | 20 | DeprNextYearTax | Depreciation during next year (Tax) | |||
AMH6092 | INT | INTEGER | 0 | 0 | 2 | FixDepreciationsTillPeriod | Fix depreciations till period |
Навигация / Navigation:
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список системных таблиц / System Tables
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Основными Средствами»/List of tables of module «Asset Management»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Контрактами»/List of tables of module «Contract Management»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Прямая выписка счетов»/List of tables of module «Direct Invoicing»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Главная Книга»/List of tables of module «General Ledger»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Ресурсами»/List of tables of module «Resourse Management»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «База Данных рынка»/List of tables of module «Market Database»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Материалами в Производстве»/List of tables of module «Material Production Control»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Заказы на Продажу»/List of tables of module «Sales Order»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Зарплата»/List of tables of module «Payroll»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Заказ на Закупку»/List of tables of module «Purchase Order»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Книга Закупок»/List of tables of module «Purchase Ledger»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Долговые обязательства»/List of tables of module «Promissory Notes»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Проектами»/List of tables of module «Project Management»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Запасами»/List of tables of module «Stock Control»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Книга Продаж»/List of tables of module «Sales Ledger»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление заказом на обслуживание»/List of tables of module «Service Order Management»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Статистика»/List of tables of module «Statistics»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Системные Утилиты/Автом. Офиса»/List of tables of module «System Utilities/Office Autom.»