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

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица AM33 — Fixed Asset Parameters

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
AM33001 NCHAR STRING 4 0 4 IndexKey Index Key 1 Да
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

История изменения структуры таблицы / 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
AM33026 0 1 0 1 0 1 0 1 0 1 0 1
AM33027 0 1 0 1 0 1 0 1 0 1 0 1
AM33028 0 1 0 1 0 1 0 1
AM33029 0 2 0 2
AM33030 0 1
AM33031 1 1
AM33032 1 1
AM33033 1 1

Навигация: