One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Asset Management»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица AM36 — Depreciations per Currency

Таблица: 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 ResidualValueTAX [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 ResidualValuePLAN [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 AccountingCodePUR [PUR] Accounting Code Purchase Transactions      
AM36051 NCHAR STRING 2 0 2 AccountingCodeTAX [TAX] Accounting Code Tax Depreciation Transactions      
AM36052 NCHAR STRING 2 0 2 AccountingCodePLA [PLA] Accounting Code Plan Depreciation Transactions      
AM36053 NCHAR STRING 2 0 2 AccountingCodeSAL [SAL] Accounting Code Sales Transactions      
AM36054 NCHAR STRING 2 0 2 AccountingCodeSCR [SCR] Accounting Code Scrap Transactions      
AM36055 NCHAR STRING 2 0 2 AccountingCodeREV [REV] Accounting Code Revaluation Transactions      
AM36056 NCHAR STRING 2 0 2 AccountingCodeETX [ETX] Accounting Code Extra Tax Transactions      
AM36057 NCHAR STRING 2 0 2 AccountingCodeFUS [FUS] Accounting Code Fusion Transactions      
AM36058 NCHAR STRING 2 0 2 AccountingCodeICT [ICT] Accounting Code IC Transfer Transactions      
AM36059 NCHAR STRING 2 0 2 AccountingCodePLP [PLP] Accounting Code Purchasing from PL      
AM36060 NCHAR STRING 2 0 2 AccountingCodeACT [ACT] Accounting Code Activation from SM      
AM36061 NCHAR STRING 2 0 2 AccountingCodeOLD [OLD] Accounting Code Take Over from Old System      
AM36062 NCHAR STRING 2 0 2 AccountingCodeTRA [TRA] Accounting Code Transfer      
AM36063 NCHAR STRING 2 0 2 AccountingCodeRES3 [RES] Accounting Code spare 3      
AM36064 NCHAR STRING 2 0 2 AccountingCodeRES4 [RES] Accounting Code spare 4      
AM36065 NCHAR STRING 2 0 2 AccountingCodeRES5 [RES] Accounting Code spare 5      
AM36066 NCHAR STRING 2 0 2 AccountingCodeRES6 [RES] Accounting Code spare 6      
AM36067 NCHAR STRING 2 0 2 AccountingCodeRES7 [RES] Accounting Code spare 7      
AM36068 NCHAR STRING 2 0 2 AccountingCodeSFA [SFA] Accounting Code Transfer from Stock      
AM36069 NCHAR STRING 2 0 2 AccountingCodeSTO [STO] Accounting Code Return to Stock      
AM36070 NCHAR STRING 2 0 2 AccountingCodeREA [REA] Accounting Code Automatic Revaluation      
AM36071 NCHAR STRING 2 0 2 AccountingCodeRES11 [RES] Accounting Code spare 11      
AM36072 NCHAR STRING 2 0 2 AccountingCodeRES12 [RES] Accounting Code spare 12      
AM36073 NCHAR STRING 2 0 2 Accounting Code PRC [PRC] Accounting Code Project Capitalization      
AM36074 NCHAR STRING 2 0 2 AccountingCodeRES14 [RES] Accounting Code spare 14      
AM36075 NCHAR STRING 2 0 2 AccountingCodeRES15 [RES] Accounting Code spare 15      
AM36076 NCHAR STRING 2 0 2 AccountingCodeRES16 [RES] Accounting Code spare 16      
AM36077 NCHAR STRING 2 0 2 AccountingCodeRES17 [RES] Accounting Code spare 17      
AM36078 NCHAR STRING 2 0 2 AccountingCodeRES18 [RES] Accounting Code spare 18      
AM36079 NCHAR STRING 2 0 2 AccountingCodeRES19 [RES] Accounting Code spare 19      
AM36080 NCHAR STRING 2 0 2 AccountingCodeRES20 [RES] Accounting Code spare 20      
AM36081 NUMERIC MONEY 28 8 20 ScrapValueBooked Scrap Value Booked      
AM36082 NUMERIC X_NUMERIC 20 8 12 AccelFactorPlan Acceleration Factor (Plan)      
AM36083 NUMERIC X_NUMERIC 20 8 12 AccelFactorTax Acceleration Factor (Tax)      
AM36084 NUMERIC MONEY 28 8 20 DeprNextYearPlan Depreciations during next year (Plan)      
AM36085 NUMERIC MONEY 28 8 20 DeprNextYearTax Depreciation during next year (Tax)      
AM36086 INT INTEGER 0 0 2 FixDepreciationsTillPeriod Fix depreciations till period      

История изменения структуры таблицы / Table structure changes history:

Поле / Field
iScala 2.2 HF 2.3318
iScala 2.3
iScala 2.3 SR1
iScala 2.3 SR2
iScala 2.3 SR3
iScala 3.0 FSP2
iScala 3.0 FSP4
Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length
AM36010 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM36011 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM36012 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM36013 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM36023 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM36024 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM36025 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM36026 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM36082 20 12 20 12 20 12 20 12 20 12 20 12
AM36083 20 12 20 12 20 12 20 12 20 12 20 12
AM36084 28 20 28 20 28 20 28 20 28 20
AM36085 28 20 28 20 28 20 28 20 28 20
AM36086 0 2

Навигация: