Таблица: AM36 - «Currency Depreciation». Маска имени таблицы: «AM36%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
AM36001 | NVARCHAR | VSTRING | 35 | 0 | 35 | InventoryCode | Asset Code | 1 | Да | |
AM36002 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrencyCode | Currency Code Depreciation | 2 | Да | |
AM36003 | 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. |
||
AM36004 | NVARCHAR | VSTRING | 12 | 0 | 12 | NLBalAccTax | [Tax] Balance Account Over/Under Depreciations | |||
AM36005 | NVARCHAR | VSTRING | 12 | 0 | 12 | NLPLAccTax | [Tax] P&L Account Over/Under Depreciations | |||
AM36006 | NVARCHAR | VSTRING | 3 | 0 | 3 | DepPerYrTax | [Tax] Depreciation Periods/Years | |||
AM36007 | NVARCHAR | VSTRING | 6 | 0 | 6 | DeprTax | [Tax] Depreciation % | |||
AM36008 | NUMERIC | MONEY | 28 | 8 | 20 | DeprAmTax | [Tax] Depreciation Amount | |||
AM36009 | NUMERIC | MONEY | 28 | 8 | 20 | DeprBaseTax | [Tax] Depreciation Base | |||
AM36010 | NUMERIC | MONEY | 28 | 8 | 20 | Residual Value TAX | [Tax] Residual Value | |||
AM36011 | NUMERIC | MONEY | 28 | 8 | 20 | AccDeprTax | [Tax] Accumulated Depreciations | |||
AM36012 | NUMERIC | MONEY | 28 | 8 | 20 | DeprYearTax | [Tax] Depreciations Current Year | |||
AM36013 | NUMERIC | MONEY | 28 | 8 | 20 | ExtraDeprTax | [Tax] Extra Depreciations | |||
AM36014 | NVARCHAR | VSTRING | 6 | 0 | 6 | Depr2Tax | [Tax] Depreciation % 2 | |||
AM36015 | NVARCHAR | VSTRING | 1 | 0 | 1 | DeprSwTax | [Tax] Depreciation Switch | |||
AM36016 | NVARCHAR | VSTRING | 2 | 0 | 2 | DepMethodPln | [Plan] 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. |
||
AM36017 | NVARCHAR | VSTRING | 12 | 0 | 12 | NLBalAccPln | [Plan] Balance Account Depreciations | |||
AM36018 | NVARCHAR | VSTRING | 12 | 0 | 12 | NLPLAccPln | [Plan] P&L Account Depreciations | |||
AM36019 | NVARCHAR | VSTRING | 3 | 0 | 3 | DepPerYrPln | [Plan] Depreciation Periods/Years | |||
AM36020 | NVARCHAR | VSTRING | 6 | 0 | 6 | DeprPln | [Plan] Depreciation % | |||
AM36021 | NUMERIC | MONEY | 28 | 8 | 20 | DeprAmPln | [Plan] Depreciation Amount | |||
AM36022 | NUMERIC | MONEY | 28 | 8 | 20 | DeprBasePln | [Plan] Depreciation Base | 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. |
||
AM36023 | NUMERIC | MONEY | 28 | 8 | 20 | Residual Value PLAN | [Plan] Residual Value | |||
AM36024 | NUMERIC | MONEY | 28 | 8 | 20 | AccDeprPln | [Plan] Accumulated Depreciations | |||
AM36025 | NUMERIC | MONEY | 28 | 8 | 20 | DeprYearPln | [Plan] Depreciations this year | |||
AM36026 | NUMERIC | MONEY | 28 | 8 | 20 | ExtraDeprPln | [Plan] Extra Depreciations | |||
AM36027 | NVARCHAR | VSTRING | 2 | 0 | 2 | Per1WoDepr | [Plan] Period Without Depreciations 1 | |||
AM36028 | NVARCHAR | VSTRING | 2 | 0 | 2 | Per2WoDepr | [Plan] Period Without Depreciations 2 | |||
AM36029 | NVARCHAR | VSTRING | 2 | 0 | 2 | Per3WoDepr | [Plan] Period Without Depreciations 3 | |||
AM36030 | NVARCHAR | VSTRING | 6 | 0 | 6 | Depr2Pln | [Plan] Depreciation % 2 | |||
AM36031 | NVARCHAR | VSTRING | 1 | 0 | 1 | DeprSwPln | [Plan] Depreciation Switch | |||
AM36032 | NUMERIC | MONEY | 28 | 8 | 20 | PurchaseCost | Purchase Cost | |||
AM36033 | NVARCHAR | VSTRING | 1 | 0 | 1 | DailyDeprPln | [Plan] Depreciate on Daily Basis | |||
AM36034 | NVARCHAR | VSTRING | 1 | 0 | 1 | DailyDeprTax | [Tax] Depreciate on Daily Basis | |||
AM36035 | NVARCHAR | VSTRING | 1 | 0 | 1 | Dummy | (obsolete) | |||
AM36036 | NCHAR | STRING | 1 | 0 | 1 | DepPerUnitTx | [Tax] Depreciation Period Unit | |||
AM36037 | NCHAR | STRING | 1 | 0 | 1 | DepPerUnitPn | [Plan] Depreciation Period Unit | |||
AM36038 | NUMERIC | MONEY | 28 | 8 | 20 | SalesRevenue | Sales Revenue | |||
AM36039 | INT | INTEGER | 0 | 0 | 1 | YearReducDeprTax | [Tax] Yearly Reducing Depreciation | |||
AM36040 | DATETIME | DATE | 0 | 0 | 8 | DeprStartTax | [Tax] Depreciation Start Date | |||
AM36041 | INT | INTEGER | 0 | 0 | 1 | YearReducDeprPlan | [Plan] Yearly Reducing Depreciation | |||
AM36042 | DATETIME | DATE | 0 | 0 | 8 | DeprStartPlan | [Plan] Depreciation Start Date | |||
AM36043 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
AM36044 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
AM36045 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
AM36046 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
AM36047 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
AM36048 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
AM36049 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
AM36050 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code PUR | [PUR] Accounting Code Purchase Transactions | |||
AM36051 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code TAX | [TAX] Accounting Code Tax Depreciation Transactions | |||
AM36052 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code PLA | [PLA] Accounting Code Plan Depreciation Transactions | |||
AM36053 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code SAL | [SAL] Accounting Code Sales Transactions | |||
AM36054 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code SCR | [SCR] Accounting Code Scrap Transactions | |||
AM36055 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code REV | [REV] Accounting Code Revaluation Transactions | |||
AM36056 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code ETX | [ETX] Accounting Code Extra Tax Transactions | |||
AM36057 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code FUS | [FUS] Accounting Code Fusion Transactions | |||
AM36058 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code ICT | [ICT] Accounting Code IC Transfer Transactions | |||
AM36059 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code PLP | [PLP] Accounting Code Purchasing from PL | |||
AM36060 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code ACT | [ACT] Accounting Code Activation from SM | |||
AM36061 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code OLD | [OLD] Accounting Code Take Over from Old System | |||
AM36062 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code TRA | [TRA] Accounting Code Transfer | |||
AM36063 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES3 | [RES] Accounting Code spare 3 | |||
AM36064 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES4 | [RES] Accounting Code spare 4 | |||
AM36065 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES5 | [RES] Accounting Code spare 5 | |||
AM36066 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES6 | [RES] Accounting Code spare 6 | |||
AM36067 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES7 | [RES] Accounting Code spare 7 | |||
AM36068 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code SFA | [SFA] Accounting Code Transfer from Stock | |||
AM36069 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code STO | [STO] Accounting Code Return to Stock | |||
AM36070 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code REA | [REA] Accounting Code Automatic Revaluation | |||
AM36071 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES11 | [RES] Accounting Code spare 11 | |||
AM36072 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES12 | [RES] Accounting Code spare 12 | |||
AM36073 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES13 | [RES] Accounting Code spare 13 | |||
AM36074 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES14 | [RES] Accounting Code spare 14 | |||
AM36075 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES15 | [RES] Accounting Code spare 15 | |||
AM36076 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES16 | [RES] Accounting Code spare 16 | |||
AM36077 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES17 | [RES] Accounting Code spare 17 | |||
AM36078 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES18 | [RES] Accounting Code spare 18 | |||
AM36079 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES19 | [RES] Accounting Code spare 19 | |||
AM36080 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code RES20 | [RES] Accounting Code spare 20 | |||
AM36081 | NUMERIC | MONEY | 28 | 8 | 20 | Scrap Value Booked | Scrap Value Booked | |||
AM36082 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Accel Factor Plan | Acceleration Factor (Plan) | |||
AM36083 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Accel Factor Tax | Acceleration Factor (Tax) | |||
AM36084 | NUMERIC | MONEY | 28 | 8 | 20 | Depr Next Year Plan | Depreciations during next year (Plan) | |||
AM36085 | NUMERIC | MONEY | 28 | 8 | 20 | Depr Next Year Tax | Depreciation during next year (Tax) |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Asset Management | Depreciations per Currency