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

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

Таблица: AMH6 — «Depreciation per Currency History». Маска имени таблицы: «AMH6%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
AMH6001 NCHAR STRING 3 0 3 TransactionType Transaction Type   1 Да
AMH6002 DATETIME DATE 0 0 8 TransactionDate Transaction Date   2 Да
AMH6003 NCHAR STRING 9 0 9 TransactionTime Transaction Time   3 Да
AMH6004 NVARCHAR VSTRING 35 0 35 InventoryCode Asset Code   4 Да
AMH6005 NCHAR STRING 10 0 10 TransactionCode Transaction Code   5 Да
AMH6006 NCHAR STRING 8 0 8 UserID User ID   6 Да
AMH6007 INT INTEGER 0 0 10 TransactionCounter Transaction Number   7 Да
AMH6008 NCHAR STRING 2 0 2 CurrCode Currency Code Depreciation   8 Да
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 Accounting Code PRC [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      

Навигация: