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

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table AM33 — Fixed Asset Parameters

Таблица / Table: AM33 — «Fixed Asset Parameters». Маска имени таблицы / Table name mask: «AM33%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
AM33001 NCHAR STRING 4 0 4 IndexKey Index Key   1 Да / Yes
AM33002 NUMERIC X_NUMERIC 18 8 10 AssetNoCount (obsolete)      
AM33003 NUMERIC X_NUMERIC 18 8 10 InsuranIndex Insurance Index Defines the current insurance index. This is used to calculate new insurance values for assets.    
AM33004 NUMERIC X_NUMERIC 18 8 10 DeprecIndex Depreciation Index Defines the current index for replacement cost. This is used to calculate new replacement values in connection with calculation of revaluation method depreciations.    
AM33005 NUMERIC X_NUMERIC 18 8 10 DeprecPeriod Depreciation Periods Defines how often (in periods) budget and depreciations shall be calculation, e.g. ‘2’ gives depreciations every other month, ‘3’ every quarter, etc.    
AM33006 NUMERIC X_NUMERIC 18 8 10 TransactNo (obsolete)      
AM33007 NUMERIC X_NUMERIC 18 8 10 InterestRate Estimated Interest Rate      
AM33008 NUMERIC X_NUMERIC 18 8 10 PartialValue Remaining Balance Remaining balance is only used in Austria and Germany for country specific calculations.    
AM33009 NUMERIC X_NUMERIC 18 8 10 LastUpdYear Last Updated Year Defines the last year depreciations have been update and closed, new depreciations can’t be calculated for the defined year or earliest years. (The year format is YYYY).    
AM33010 INT INTEGER 0 0 1 UseTransCntr Use General Ledger Transaction Counter      
AM33011 INT INTEGER 0 0 1 GenerateBudg Generate Budget for Balance Account      
AM33012 INT INTEGER 0 0 1 DeprFullYear Depreciate Full Year According to Tax      
AM33013 INT INTEGER 0 0 1 TaxCalcControl Tax Calculation Control 0 — No tax calculation control.

1 — Both tax and plan depreciation may be calculated. For other business operations only plan GL transaction lines are generated.

2 — Only plan depreciation calculating is allowed. For all business operations only plan GL transaction lines are generated.
   
AM33014 INT INTEGER 0 0 1 StockValueDefinitionMethod Stock Value Definition Method The stock value of an asset , to be transferred to Stock Control is defined as:

0 — Plan balance value of the asset

1 — Tax balance value of the asset
   
AM33015 INT INTEGER 0 0 1 InhibFASB52 Insert Date Stamp for FASB52      
AM33016 INT INTEGER 0 0 1 RuondingRule Rounding Rule Defines rounding rule to use when calculating depreciations:

0 — Standard rounding

1 — Rounding to upper figure in decimals.

2 — Rounding to lower figure in decimals.

3 — Rounding to upper integer.

4 — Rounding to lower integer.
   
AM33017 INT INTEGER 0 0 1 DirectTransf Full Amount of Tax Depreciation 1 — The total amount for tax depreciations may be booked to the appropriate accounts.

0 — Only the difference between planned and tax depreciations may be booked.
   
AM33018 NVARCHAR VSTRING 6 0 6 JournalCodeForGL Journal Code for General Ledger      
AM33019 INT INTEGER 0 0 1 ReducingBasisbyResidualValue Reducing Basis by Residual Value 1 — Before calculating depreciation, basis will be reduced with residual value if any and depreciation will be done up to 0

0 — Depreciation will be calculated up to residual value if any
   
AM33020 NCHAR STRING 10 0 10 FixedAssetNo (obsolete)      
AM33021 NUMERIC NUMBER 20 0 10 BusinessTransNor (obsolete)      
AM33022 INT INTEGER 0 0 1 UseMaster Use Fixed Asset Transactions      
AM33023 INT INTEGER 0 0 1 AutomaticAssetNo Automatic Fixed Asset Transaction Number      
AM33024 INT INTEGER 0 0 1 DateControl Date Consistency Control      
AM33025 INT INTEGER 0 0 4 CreateReportingLevelForTangible Create Reporting Level for Tangible Stock Item      
AM33026 INT INTEGER 0 0 1 DepreciationFromPeriodValue Depreciation from period value      
AM33027 INT INTEGER 0 0 1 FinalPeriodRule Final period rule      
AM33028 INT INTEGER 0 0 1 CheckDepreciation Check Depreciation      
AM33029 INT INTEGER 0 0 2 NumOfDaysFinPeriod No of days per financial period      
AM33030 INT INTEGER 0 0 1 BilinerTransactions Biliner Transactions split AM34 lines or accumulate amounts with equal accounting string    
AM33031 NCHAR STRING 1 0 1 SeparateAccountForProfitAndLoss Separate accounts for profit and loss      
AM33032 NCHAR STRING 1 0 1 RevaluationMethod Revaluation method      
AM33033 NCHAR STRING 1 0 1 AllowAssetValueToExceedPurchasePriceDuringAutomaticRevaluation Allow asset value to exceed purchase price during automatic revaluation      

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