One level Up / 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

Навигация: