На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Основными Средствами» / List of tables of module «Asset Management»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table AM37 — Depreciations per Currency Templates

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
AM37001 NVARCHAR VSTRING 35 0 35 InventCode Asset Template Code   1 Да / Yes
AM37002 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code Depreciation   2 Да / Yes
AM37003 NVARCHAR VSTRING 2 0 2 DepMethodTax [Tax] Depreciation Method      
AM37004 NVARCHAR VSTRING 12 0 12 NLBalAccTax [Tax] Balance Account Over/Under Depreciations      
AM37005 NVARCHAR VSTRING 12 0 12 NLPLAccTax [Tax] P&L Account Over/Under Depreciations      
AM37006 NVARCHAR VSTRING 3 0 3 DepPerYrTax [Tax] Depreciation Periods/Years      
AM37007 NVARCHAR VSTRING 6 0 6 DeprTax [Tax] Depreciation %      
AM37008 NUMERIC MONEY 28 8 20 DeprAmTax [Tax] Depreciation Amount      
AM37009 NUMERIC MONEY 28 8 20 DeprBaseTax [Tax] Depreciation Base      
AM37010 NUMERIC MONEY 28 8 20 ResidualValueTAX [Tax] Residual Value      
AM37011 NUMERIC MONEY 28 8 20 AccDeprTax [Tax] Accumulated Depreciations      
AM37012 NUMERIC MONEY 28 8 20 DeprYearTax [Tax] Depreciations Current Year      
AM37013 NUMERIC MONEY 28 8 20 ExtraDeprTax [Tax] Extra Depreciations      
AM37014 NVARCHAR VSTRING 6 0 6 Depr2Tax [Tax] Depreciation % 2      
AM37015 NVARCHAR VSTRING 1 0 1 DeprSwTax [Tax] Depreciation Switch      
AM37016 NVARCHAR VSTRING 2 0 2 DepMethodPln [Plan] Depreciation Method      
AM37017 NVARCHAR VSTRING 12 0 12 NLBalAccPln [Plan] Balance Account Depreciations      
AM37018 NVARCHAR VSTRING 12 0 12 NLPLAccPln [Plan] P&L Account Depreciations      
AM37019 NVARCHAR VSTRING 3 0 3 DepPerYrPln [Plan] Depreciation Periods/Years      
AM37020 NVARCHAR VSTRING 6 0 6 DeprPln [Plan] Depreciation %      
AM37021 NUMERIC MONEY 28 8 20 DeprAmPln [Plan] Depreciation Amount      
AM37022 NUMERIC MONEY 28 8 20 DeprBasePln [Plan] Depreciation Base      
AM37023 NUMERIC MONEY 28 8 20 ResidualValuePLAN [Plan] Residual Value      
AM37024 NUMERIC MONEY 28 8 20 AccDeprPln [Plan] Accumulated Depreciations      
AM37025 NUMERIC MONEY 28 8 20 DeprYearPln [Plan] Depreciations this year      
AM37026 NUMERIC MONEY 28 8 20 ExtraDeprPln [Plan] Extra Depreciations      
AM37027 NVARCHAR VSTRING 2 0 2 Per1WoDepr [Plan] Period Without Depreciations 1      
AM37028 NVARCHAR VSTRING 2 0 2 Per2WoDepr [Plan] Period Without Depreciations 2      
AM37029 NVARCHAR VSTRING 2 0 2 Per3WoDepr [Plan] Period Without Depreciations 3      
AM37030 NVARCHAR VSTRING 6 0 6 Depr2Pln [Plan] Depreciation % 2      
AM37031 NVARCHAR VSTRING 1 0 1 DeprSwPln [Plan] Depreciation Switch      
AM37032 NUMERIC MONEY 28 8 20 PurchaseCost Purchase Cost      
AM37033 NVARCHAR VSTRING 1 0 1 DailyDeprPln [Plan] Depreciate on Daily Basis      
AM37034 NVARCHAR VSTRING 1 0 1 DailyDeprTax [Tax] Depreciate on Daily Basis      
AM37035 NVARCHAR VSTRING 1 0 1 Dummy (obsolete)      
AM37036 NCHAR STRING 1 0 1 DepPerUnitTx [Tax] Depreciation Period Unit      
AM37037 NCHAR STRING 1 0 1 DepPerUnitPn [Plan] Depreciation Period Unit      
AM37038 NUMERIC MONEY 28 8 20 SalesRevenue Sales Revenue      
AM37039 INT INTEGER 0 0 1 YearReducDeprTax [Tax] Yearly Reducing Depreciation      
AM37040 DATETIME DATE 0 0 8 DeprStartTax [Tax] Depreciation Start Date      
AM37041 INT INTEGER 0 0 1 YearReducDeprPlan [Plan] Yearly Reducing Depreciation      
AM37042 DATETIME DATE 0 0 8 DeprStartPlan [Plan] Depreciation Start Date      
AM37043 NCHAR STRING 1 0 1 Spare (obsolete)      
AM37044 NCHAR STRING 1 0 1 Spare (obsolete)      
AM37045 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
AM37046 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
AM37047 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
AM37048 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
AM37049 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
AM37050 NCHAR STRING 2 0 2 AccountingCodePUR [PUR] Accounting Code Purchase Transactions      
AM37051 NCHAR STRING 2 0 2 AccountingCodeTAX [TAX] Accounting Code Tax Depreciation Transactions      
AM37052 NCHAR STRING 2 0 2 AccountingCodePLA [PLA] Accounting Code Plan Depreciation Transactions      
AM37053 NCHAR STRING 2 0 2 AccountingCodeSAL [SAL] Accounting Code Sales Transactions      
AM37054 NCHAR STRING 2 0 2 AccountingCodeSCR [SCR] Accounting Code Scrap Transactions      
AM37055 NCHAR STRING 2 0 2 AccountingCodeREV [REV] Accounting Code Revaluation Transactions      
AM37056 NCHAR STRING 2 0 2 AccountingCodeETX [ETX] Accounting Code Extra Tax Transactions      
AM37057 NCHAR STRING 2 0 2 AccountingCodeFUS [FUS] Accounting Code Fusion Transactions      
AM37058 NCHAR STRING 2 0 2 AccountingCodeICT [ICT] Accounting Code IC Transfer Transactions      
AM37059 NCHAR STRING 2 0 2 AccountingCodePLP [PLP] Accounting Code Purchasing from PL      
AM37060 NCHAR STRING 2 0 2 AccountingCodeSM [ACT] Accounting Code Activation from SM      
AM37061 NCHAR STRING 2 0 2 AccountingCodeOLD [OLD] Accounting Code Take Over from Old System      
AM37062 NCHAR STRING 2 0 2 AccountingCodeTRA [TRA] Accounting Code Transfer      
AM37063 NCHAR STRING 2 0 2 AccountingCodePLD [RES] Accounting Code spare 3      
AM37064 NCHAR STRING 2 0 2 AccountingCodeTAD [RES] Accounting Code spare 4      
AM37065 NCHAR STRING 2 0 2 AccountingCodeSLS [RES] Accounting Code spare 5      
AM37066 NCHAR STRING 2 0 2 AccountingCode [RES] Accounting Code spare 6      
AM37067 NCHAR STRING 2 0 2 AccountingCodeRAV [RES] Accounting Code spare 7      
AM37068 NCHAR STRING 2 0 2 AccountingCodeSFA [SFA] Accounting Code Transfer from Stock      
AM37069 NCHAR STRING 2 0 2 AccountingCodeSTO [STO] Accounting Code Return to Stock      
AM37070 NCHAR STRING 2 0 2 AccountingCodeREA [REA] Accounting Code Automatic Revaluation      
AM37071 NCHAR STRING 2 0 2 AccountingCodeRES4 [RES] Accounting Code spare 11      
AM37072 NCHAR STRING 2 0 2 AccountingCodeRES5 [RES] Accounting Code spare 12      
AM37073 NCHAR STRING 2 0 2 AccountingCodeRES6 [RES] Accounting Code spare 13      
AM37074 NCHAR STRING 2 0 2 AccountingCodeRES7 [RES] Accounting Code spare 14      
AM37075 NCHAR STRING 2 0 2 AccountingCodeRES8 [RES] Accounting Code spare 15      
AM37076 NCHAR STRING 2 0 2 AccountingCodeRES9 [RES] Accounting Code spare 16      
AM37077 NCHAR STRING 2 0 2 AccountingCodeRES10 [RES] Accounting Code spare 17      
AM37078 NCHAR STRING 2 0 2 AccountingCodeRES11 [RES] Accounting Code spare 18      
AM37079 NCHAR STRING 2 0 2 AccountingCodeRES12 [RES] Accounting Code spare 19      
AM37080 NCHAR STRING 2 0 2 AccountingCodeRES13 [RES] Accounting Code spare 20      
AM37081 NUMERIC MONEY 28 8 20 ScrapValueBooked Scrap Value Booked      
AM37082 NUMERIC X_NUMERIC 20 8 12 AccelFactorPlan Acceleration Factor (Plan)      
AM37083 NUMERIC X_NUMERIC 20 8 12 AccelFactorTax Acceleration Factor (Tax)      
AM37084 NUMERIC MONEY 28 8 20 DeprNextYearPlan Depreciation during next year (Plan)      
AM37085 NUMERIC MONEY 28 8 20 DeprNextYearTax Depreciation during next year (Tax)      
AM37086 INT INTEGER 0 0 2 FixDepreciationsTillPeriod Fix depreciations till period      

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