Таблица | Table: AM36 - «Currency Depreciation». Маска имени таблицы | Table Name Mask: «AM36%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
AM36001 NVARCHAR VSTRING 35 0 35 InventoryCode Asset Code   1 Да / Yes
AM36002 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code Depreciation   2 Да / Yes
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)      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Asset Management | Depreciations per Currency