пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Asset Management»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица AM32 — Asset Master Templates

Таблица: AM32 — «Fixed Assets Standard». Маска имени таблицы: «AM32%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
AM32001 NVARCHAR VSTRING 35 0 35 InventCode Asset Template Code   1 Да
AM32002 NVARCHAR VSTRING 35 0 35 DescrLine1 Description Line 1      
AM32003 NVARCHAR VSTRING 35 0 35 DescrLine2 Description Line 2      
AM32004 NVARCHAR VSTRING 10 0 10 InventGrCode Asset Group      
AM32005 NVARCHAR VSTRING 50 0 50 BalAccAssets Accounting String      
AM32006 NVARCHAR VSTRING 12 0 12 BalAccDepr (obsolete)      
AM32007 NVARCHAR VSTRING 12 0 12 PLAccDepr (obsolete)      
AM32008 NVARCHAR VSTRING 12 0 12 BalAccDepr2 (obsolete)      
AM32009 NVARCHAR VSTRING 12 0 12 PLAccDepr2 (obsolete)      
AM32010 NCHAR STRING 1 0 1 CostCenter Retroactive Adjustment of Depreciations 0 — No retroactive adjustment will be made.
1 — Retroactive adjustment of depreciation will be made if basis or method is changed.
2 — No retroactive adjustment will be made and accumulated year depreciation is not taken into account (only methods 1,5,8)
   
AM32011 NVARCHAR VSTRING 1 0 1 ProductCode (obsolete)      
AM32012 NVARCHAR VSTRING 1 0 1 YearlyReducingTaxDepreciation Yearly Reducing Tax Depreciation Depreciation is calculated:
0 — Accordingly to the parameter set-up
1 — Only for periods when you have had the asset
2 — For the whole year, even for asset acquired during the year
3 — Accordingly to semi-annual rule.
   
AM32013 NCHAR STRING 3 0 3 NoteNumber Note Number      
AM32014 NVARCHAR VSTRING 4 0 4 CategoryA Category A      
AM32015 NVARCHAR VSTRING 4 0 4 CategoryB Category B      
AM32016 NVARCHAR VSTRING 15 0 15 Location Location      
AM32017 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code      
AM32018 NVARCHAR VSTRING 35 0 35 SupplierName Supplier Name      
AM32019 NVARCHAR VSTRING 35 0 35 SupplierAdd1 Supplier Address Line 1      
AM32020 NVARCHAR VSTRING 35 0 35 SupplierAdd2 Supplier Address Line 2      
AM32021 NVARCHAR VSTRING 35 0 35 SupplierAdd3 Supplier Address Line 3      
AM32022 NVARCHAR VSTRING 25 0 25 TechContact Contact Name      
AM32023 NVARCHAR VSTRING 15 0 15 TelephNumber Telephone Number      
AM32024 NVARCHAR VSTRING 25 0 25 SupplInvNo Supplier Invoice      
AM32025 NVARCHAR VSTRING 9 0 9 NLTransNo Transaction Number Purchase Invoice      
AM32026 DATETIME DATE 0 0 8 WarrExpDate Warranty Expiration Date      
AM32027 NVARCHAR VSTRING 25 0 25 InsurancComp Insurance Company      
AM32028 NVARCHAR VSTRING 20 0 20 InsuranceNo Insurance Number      
AM32029 NUMERIC MONEY 28 8 20 InsureAmount Insured Amount      
AM32030 NUMERIC MONEY 28 8 20 PurchPrice Purchase Price      
AM32031 NUMERIC MONEY 28 8 20 RePurchPri Replacement Purchase Price      
AM32032 NUMERIC MONEY 28 8 20 AccRepairs Accumulated Repairs      
AM32033 NUMERIC MONEY 28 8 20 AccAddons Accumulated Add-ons      
AM32034 DATETIME DATE 0 0 8 DatePurchase Date Purchased      
AM32035 DATETIME DATE 0 0 8 DateScraSold Date Scrapped      
AM32036 NVARCHAR VSTRING 4 0 4 ScraSoldCode Disposal Code      
AM32037 NUMERIC X_NUMERIC 14 8 6 IndexValue Index Value      
AM32038 NVARCHAR VSTRING 4 0 4 LastUpdDepr Last Depreciation Update Date Defines the financial year and book-keeping period up-to which depreciations have been booked. It is updated automatically on calculation of depreciations.    
AM32039 NCHAR STRING 1 0 1 TaxDeprMeth (obsolete)      
AM32040 INT INTEGER 0 0 2 TaxDeprPerYr (obsolete)      
AM32041 NUMERIC X_NUMERIC 14 8 6 TaxDeprec (obsolete)      
AM32042 NUMERIC MONEY 28 8 20 TaxDeprAm (obsolete)      
AM32043 NUMERIC MONEY 28 8 20 TaxDeprBase (obsolete)      
AM32044 NUMERIC MONEY 28 8 20 TaxScrapVal (obsolete)      
AM32045 NUMERIC MONEY 28 8 20 TaxAccumDepr (obsolete)      
AM32046 NUMERIC MONEY 28 8 20 TaxDeprYear (obsolete)      
AM32047 NUMERIC MONEY 28 8 20 TaxExtraDepr (obsolete)      
AM32048 NCHAR STRING 1 0 1 Capitalization Allowed Capitalization Allowed      
AM32049 INT INTEGER 0 0 2 PlanDeprPerY (obsolete)      
AM32050 NUMERIC X_NUMERIC 14 8 6 PlanDeprec (obsolete)      
AM32051 NUMERIC MONEY 28 8 20 PlanDeprAm (obsolete)      
AM32052 NUMERIC MONEY 28 8 20 PlanDeprBase (obsolete)      
AM32053 NUMERIC MONEY 28 8 20 PlanScrapVal (obsolete)      
AM32054 NUMERIC MONEY 28 8 20 PlanAccDepr (obsolete)      
AM32055 NUMERIC MONEY 28 8 20 PlanDeprYear (obsolete)      
AM32056 NUMERIC MONEY 28 8 20 PlanExtraDep (obsolete)      
AM32057 NCHAR STRING 2 0 2 PlanPeriodN1 (obsolete)      
AM32058 NCHAR STRING 2 0 2 PlanPeriodN2 (obsolete)      
AM32059 NCHAR STRING 2 0 2 PlanPeriodN3 (obsolete)      
AM32060 NVARCHAR VSTRING 30 0 30 InternalRem1 Remark Line 1      
AM32061 NVARCHAR VSTRING 30 0 30 InternalRem2 Remark Line 2      
AM32062 NVARCHAR VSTRING 5 0 5 InsurancCode Insurance Category      
AM32063 NCHAR STRING 1 0 1 DocumentFlag Print New Label      
AM32064 NVARCHAR VSTRING 20 0 20 ServContract Service Contract      
AM32065 NCHAR STRING 1 0 1 GenerateBudg Generate Budget 1 — Budget will be calculated and transactions are created for general ledger
0 — Budget will only be calculated and printed on the report, no budget transactions are created for the general ledger
   
AM32066 NCHAR STRING 1 0 1 GenerateTran Generate Transactions 1 — When calculating depreciations, general ledger transactions will be created and be placed in the day-book journal
0 — Depreciations will only be calculated and printed on the calculation report, no general ledger transactions will be created.
   
AM32067 NVARCHAR VSTRING 15 0 15 UserDefData1 User Defined Field 1      
AM32068 NVARCHAR VSTRING 10 0 10 UserDefData2 User Defined Field 2      
AM32069 NVARCHAR VSTRING 10 0 10 UserDefData3 User Defined Field 3      
AM32070 NVARCHAR VSTRING 5 0 5 UserDefData4 User Defined Field 4      
AM32071 INT INTEGER 0 0 1 CalcDeprMeth [Calc] Depreciation Method      
AM32072 INT INTEGER 0 0 2 CalcDeprPerY [Calc] Depreciation Periods/Years      
AM32073 NUMERIC X_NUMERIC 14 8 6 CalcDeprec [Calc] Depreciation %      
AM32074 NUMERIC MONEY 28 8 20 CalcDeprAm [Calc] Depreciation Amount      
AM32075 NUMERIC MONEY 28 8 20 CalcDeprBase [Calc] Depreciation Base      
AM32076 NUMERIC MONEY 28 8 20 CalcScrapVal [Calc] Scrap Value      
AM32077 NUMERIC MONEY 28 8 20 CalcAccDepr [Calc] Accumulated Depreciations      
AM32078 NUMERIC MONEY 28 8 20 CalcDeprYear [Calc] Depreciations Current Year      
AM32079 NUMERIC MONEY 28 8 20 CalcExtraDep [Calc] Extra Depreciations      
AM32080 NUMERIC X_NUMERIC 14 8 6 CalcIndexVal [Calc] Index Value      
AM32081 DATETIME DATE 0 0 8 DepStartDate Depreciation Start Date      
AM32082 INT INTEGER 0 0 1 NationalSw1 National Switch 1      
AM32083 INT INTEGER 0 0 1 NationalSw2 National Switch 2      
AM32084 INT INTEGER 0 0 1 NationalSw3 National Switch 3      
AM32085 DATETIME DATE 0 0 8 NationDate1 National Date 1      
AM32086 DATETIME DATE 0 0 8 NationDate2 National Date 2      
AM32087 DATETIME DATE 0 0 8 NationDate3 National Date 3      
AM32088 NUMERIC MONEY 28 8 20 NationalAm1 National Amount 1      
AM32089 NUMERIC MONEY 28 8 20 NationalAm2 National Amount 2      
AM32090 NUMERIC MONEY 28 8 20 NationalAm3 National Amount 3      
AM32091 NUMERIC X_NUMERIC 14 8 6 DepreciatTAX (obsolete)      
AM32092 NUMERIC X_NUMERIC 14 8 6 DeprecPlan (obsolete)      
AM32093 NUMERIC X_NUMERIC 14 8 6 DeprecCalc [Calc] Depreciation % 2      
AM32094 INT INTEGER 0 0 1 DepSwitcTask (obsolete)      
AM32095 INT INTEGER 0 0 1 DepSwitcPlan (obsolete)      
AM32096 INT INTEGER 0 0 1 DepSwitchCalc [Calc] Depreciation % Switch      
AM32097 INT INTEGER 0 0 1 FlagLinkedtoStockCode Linked to Stock Item      
AM32098 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
AM32099 DATETIME DATE 0 0 8 DepreciationEndDate Depreciation End Date      
AM32100 INT INTEGER 0 0 1 LockFlag Locked      
AM32101 INT INTEGER 0 0 1 SummaryLevelFlag Summary Level      
AM32102 NVARCHAR VSTRING 35 0 35 ReportingLevel1 Asset Code Reporting Level 1      
AM32103 NVARCHAR VSTRING 35 0 35 ReportingLevel2 Asset Code Reporting Level 2      
AM32104 NVARCHAR VSTRING 35 0 35 ReportingLevel3 Asset Code Reporting Level 3      
AM32105 NVARCHAR VSTRING 35 0 35 ReportingLevel4 Asset Code Reporting Level 4      
AM32106 NVARCHAR VSTRING 35 0 35 ReportingLevel5 Asset Code Reporting Level 5      
AM32107 NVARCHAR VSTRING 4 0 4 LastUpdateDepreciationTax Last Update Depreciation Tax      
AM32108 NUMERIC MONEY 28 8 20 ValueInConsolidationCurrency ValueInConsolidationCurrency      
AM32109 NVARCHAR VSTRING 35 0 35 spare spare      
AM32110 NVARCHAR VSTRING 6 0 6 LeaseGroupCode Lease Group Code      
AM32111 NVARCHAR VSTRING 6 0 6 LeaseCategoryCode Lease Category Code      
AM32112 NVARCHAR VSTRING 35 0 35 SupplierAdd4 Supplier Address Line 4      
AM32113 NVARCHAR VSTRING 35 0 35 SupplierAdd5 Supplier Address Line 5      
AM32114 NVARCHAR VSTRING 35 0 35 SupplierAdd6 Supplier Address Line 6      
AM32115 NVARCHAR VSTRING 35 0 35 SupplierAdd7 Supplier Address Line 7      
AM32116 NVARCHAR VSTRING 3 0 3 SupplierCountryCode Supplier Country Code      

История изменения структуры таблицы / 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
AM32024 15 15 15 15 15 15 15 15 15 15 25 25 25 25
AM32025 6 6 6 6 6 6 9 9 9 9 9 9 9 9
AM32109 35 35 35 35 35 35 35 35 35 35
AM32110 6 6 6 6 6 6 6 6 6 6
AM32111 6 6 6 6 6 6 6 6 6 6
AM32112 35 35 35 35 35 35 35 35
AM32113 35 35 35 35 35 35 35 35
AM32114 35 35 35 35 35 35 35 35
AM32115 35 35 35 35 35 35 35 35
AM32116 3 3 3 3 3 3 3 3

Навигация: