One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «Asset Management»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table AMT6 — Depreciations per Currency Transactions

Таблица / Table: AMT6 — «Transaction Currency Depreciation». Маска имени таблицы / Table name mask: «AMT6%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
AMT6001 NVARCHAR VSTRING 35 0 35 InventCode Asset Code   1 Да / Yes
AMT6002 NVARCHAR VSTRING 10 0 10 TransCode Transaction Code   2 Да / Yes
AMT6003 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code Depreciation   3 Да / Yes
AMT6004 NVARCHAR VSTRING 2 0 2 DepMethodTax [Tax] Depreciation Method      
AMT6005 NVARCHAR VSTRING 12 0 12 NLBalAccTax [Tax] Balance Account Over/Under Depreciations      
AMT6006 NVARCHAR VSTRING 12 0 12 NLPLAccTax [Tax] P&L Account Over/Under Depreciations      
AMT6007 NVARCHAR VSTRING 3 0 3 DepPerYrTax [Tax] Depreciation Period Years      
AMT6008 NVARCHAR VSTRING 6 0 6 DeprTax [Tax] Depreciation %      
AMT6009 NUMERIC MONEY 28 8 20 DeprAmTax [Tax] Depreciation Amount      
AMT6010 NUMERIC MONEY 28 8 20 DeprBaseTax [Tax] Depreciation Base      
AMT6011 NUMERIC MONEY 28 8 20 ResidualValueTAX [Tax] Residual Value      
AMT6012 NUMERIC MONEY 28 8 20 AccDeprTax [Tax] Accumulated Depreciations      
AMT6013 NUMERIC MONEY 28 8 20 DeprYearTax [Tax] Depreciations Current Year      
AMT6014 NUMERIC MONEY 28 8 20 ExtraDeprTax [Tax] Extra Depreciations      
AMT6015 NVARCHAR VSTRING 6 0 6 Depr2Tax [Tax] Depreciation % 2      
AMT6016 NVARCHAR VSTRING 1 0 1 DeprSwTax [Tax] Depreciation Switch      
AMT6017 NVARCHAR VSTRING 2 0 2 DepMethodPln [Plan] Depreciation Method      
AMT6018 NVARCHAR VSTRING 12 0 12 NLBalAccPln [Plan] Balance Account Depreciations      
AMT6019 NVARCHAR VSTRING 12 0 12 NLPLAccPln [Plan] P&L Account Depreciations      
AMT6020 NVARCHAR VSTRING 3 0 3 DepPerYrPln [Plan] Depreciation Period Years      
AMT6021 NVARCHAR VSTRING 6 0 6 DeprPln [Plan] Depreciation %      
AMT6022 NUMERIC MONEY 28 8 20 DeprAmPln [Plan] Depreciation Amount      
AMT6023 NUMERIC MONEY 28 8 20 DeprBasePln [Plan] Depreciation Base      
AMT6024 NUMERIC MONEY 28 8 20 ResidualValuePLAN [Plan] Residual Value      
AMT6025 NUMERIC MONEY 28 8 20 AccDeprPln [Plan] Accumulated Depreciations      
AMT6026 NUMERIC MONEY 28 8 20 DeprYearPln [Plan] Depreciations this year      
AMT6027 NUMERIC MONEY 28 8 20 ExtraDeprPln [Plan] Extra Depreciations      
AMT6028 NVARCHAR VSTRING 2 0 2 Per1WoDepr [Plan] Period Without Depreciations 1      
AMT6029 NVARCHAR VSTRING 2 0 2 Per2WoDepr [Plan] Period Without Depreciations 2      
AMT6030 NVARCHAR VSTRING 2 0 2 Per3WoDepr [Plan] Period Without Depreciations 3      
AMT6031 NVARCHAR VSTRING 6 0 6 Depr2Pln [Plan] Depreciation % 2      
AMT6032 NVARCHAR VSTRING 1 0 1 DeprSwPln [Plan] Depreciation Switch      
AMT6033 NUMERIC MONEY 28 8 20 PurchaseCost Purchase Cost      
AMT6034 NVARCHAR VSTRING 1 0 1 DailyDeprPln [Plan] Depreciate on Daily Basis      
AMT6035 NVARCHAR VSTRING 1 0 1 DailyDeprTax [Tax] Depreciate on Daily Basis      
AMT6036 NVARCHAR VSTRING 1 0 1 Dummy (obsolete)      
AMT6037 NCHAR STRING 1 0 1 DepPerUnitTx [Tax] Depreciation Period Unit      
AMT6038 NCHAR STRING 1 0 1 DepPerUnitPn [Plan] Depreciation Period Unit      
AMT6039 NUMERIC MONEY 28 8 20 SalesRevenue Sales Revenue      
AMT6040 INT INTEGER 0 0 1 YearReducDeprTax [Tax] Yearly Reducing Depreciation      
AMT6041 DATETIME DATE 0 0 8 DeprStartTax [Tax] Depreciation Start Date      
AMT6042 INT INTEGER 0 0 1 YearReducDeprPlan [Plan] Yearly Reducing Depreciation      
AMT6043 DATETIME DATE 0 0 8 DeprStartPlan [Plan] Depreciation Start Date      
AMT6044 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
AMT6045 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
AMT6046 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
AMT6047 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
AMT6048 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
AMT6049 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
AMT6050 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
AMT6051 NVARCHAR VSTRING 2 0 2 AccCodePUR [PUR] Accounting Code Purchase Transactions      
AMT6052 NVARCHAR VSTRING 2 0 2 AccCodeTAX [TAX] Accounting Code Tax Depreciation Transactions      
AMT6053 NVARCHAR VSTRING 2 0 2 AccCodePLA [PLA] Accounting Code Plan Depreciation Transactions      
AMT6054 NVARCHAR VSTRING 2 0 2 AccCodeSAL [SAL] Accounting Code Sales Transactions      
AMT6055 NVARCHAR VSTRING 2 0 2 AccCodeSCR [SCR] Accounting Code Scrap Transactions      
AMT6056 NVARCHAR VSTRING 2 0 2 AccCodeREV [REV] Accounting Code Revaluation Transactions      
AMT6057 NVARCHAR VSTRING 2 0 2 AccCodeETX [ETX] Accounting Code Extra Tax Transactions      
AMT6058 NVARCHAR VSTRING 2 0 2 AccCodeFUS [FUS] Accounting Code Fusion Transactions      
AMT6059 NVARCHAR VSTRING 2 0 2 AccCodeICT [ICT] Accounting Code IC Transfer Transactions      
AMT6060 NVARCHAR VSTRING 2 0 2 AccCodePLP [PLP] Accounting Code Purchasing from PL      
AMT6061 NVARCHAR VSTRING 2 0 2 AccCodeACT [ACT] Accounting Code Activation from SM      
AMT6062 NVARCHAR VSTRING 2 0 2 AccCodeRE1 [OLD] Accounting Code Take Over from Old System      
AMT6063 NVARCHAR VSTRING 2 0 2 AccCodeRE2 [TRA] Accounting Code Transfer      
AMT6064 NVARCHAR VSTRING 2 0 2 AccCodeRE3 [RES] Accounting Code spare 3      
AMT6065 NVARCHAR VSTRING 2 0 2 AccCodeRE4 [RES] Accounting Code spare 4      
AMT6066 NVARCHAR VSTRING 2 0 2 AccCodeRE5 [RES] Accounting Code spare 5      
AMT6067 NVARCHAR VSTRING 2 0 2 AccCodeRE6 [RES] Accounting Code spare 6      
AMT6068 NVARCHAR VSTRING 2 0 2 AccCodeRE7 [RES] Accounting Code spare 7      
AMT6069 NVARCHAR VSTRING 2 0 2 AccountingCodeSFA [SFA] Accounting Code Transfer from Stock      
AMT6070 NVARCHAR VSTRING 2 0 2 AccountingCodeSTO [STO] Accounting Code Return to Stock      
AMT6071 NVARCHAR VSTRING 2 0 2 AccountingCodeREA [REA] Accounting Code Automatic Revaluation      
AMT6072 NVARCHAR VSTRING 2 0 2 AccCodeRE11 [RES] Accounting Code spare 11      
AMT6073 NVARCHAR VSTRING 2 0 2 AccCodeRE12 [RES] Accounting Code spare 12      
AMT6074 NVARCHAR VSTRING 2 0 2 AccountingCodePRC [PRC] Accounting Code Project Capitalization      
AMT6075 NVARCHAR VSTRING 2 0 2 AccCodeRE14 [RES] Accounting Code spare 14      
AMT6076 NVARCHAR VSTRING 2 0 2 AccCodeRE15 [RES] Accounting Code spare 15      
AMT6077 NVARCHAR VSTRING 2 0 2 AccCodeRE16 [RES] Accounting Code spare 16      
AMT6078 NVARCHAR VSTRING 2 0 2 AccCodeRE17 [RES] Accounting Code spare 17      
AMT6079 NVARCHAR VSTRING 2 0 2 AccCodeRE18 [RES] Accounting Code spare 18      
AMT6080 NVARCHAR VSTRING 2 0 2 AccCodeRE19 [RES] Accounting Code spare 19      
AMT6081 NVARCHAR VSTRING 2 0 2 AccCodeRE20 [RES] Accounting Code spare 20      
AMT6082 NUMERIC MONEY 28 8 20 ScrapValueBooked Scrap Value Booked      
AMT6083 NUMERIC X_NUMERIC 20 8 12 AccelFactorPlan Acceleration Factor (Plan)      
AMT6084 NUMERIC X_NUMERIC 20 8 12 AccelFactorTax Acceleration Factor (Tax)      
AMT6085 NUMERIC MONEY 28 8 20 DeprNextYearPlan Depreciations during next year (Plan)      
AMT6086 NUMERIC MONEY 28 8 20 DeprNextYearTax Depreciation during next year (Tax)      
AMT6087 INT INTEGER 0 0 2 FixDepreciationsTillPeriod Fix depreciations till period      

Навигация / Navigation: