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

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table AM31 — Asset Master Table

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
AM31001 NVARCHAR VSTRING 35 0 35 InventoryCod Asset Code   1 Да / Yes
AM31002 NVARCHAR VSTRING 35 0 35 DescrLine1 Description Line 1      
AM31003 NVARCHAR VSTRING 35 0 35 DescrLine2 Description Line 2      
AM31004 NVARCHAR VSTRING 10 0 10 InventGroup Asset Group      
AM31005 NVARCHAR ACCSTR 120 0 120 AccString Accounting String      
AM31006 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
AM31007 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
AM31008 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
AM31009 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
AM31010 NVARCHAR VSTRING 1 0 1 RetrDeprec 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)
   
AM31011 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
AM31012 NVARCHAR VSTRING 1 0 1 YearlyRedicingTaxDepreciation 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.
   
AM31013 NVARCHAR VSTRING 3 0 3 NoteNo Note Number      
AM31014 NVARCHAR VSTRING 4 0 4 CategoryA Category A      
AM31015 NVARCHAR VSTRING 4 0 4 CategoryB Category B      
AM31016 NVARCHAR VSTRING 15 0 15 Location Location      
AM31017 NVARCHAR VSTRING 10 0 10 SuplCode Supplier Code      
AM31018 NVARCHAR VSTRING 35 0 35 SupplierName Supplier Name      
AM31019 NVARCHAR VSTRING 35 0 35 SupNameAddr1 Supplier Address Line 1      
AM31020 NVARCHAR VSTRING 35 0 35 SupNameAddr2 Supplier Address Line 2      
AM31021 NVARCHAR VSTRING 35 0 35 SupNameAddr3 Supplier Address Line 3      
AM31022 NVARCHAR VSTRING 25 0 25 NameContact Contact Name      
AM31023 NVARCHAR VSTRING 15 0 15 Telephone Telephone Number      
AM31024 NVARCHAR VSTRING 25 0 25 SupplInv Supplier Invoice      
AM31025 NVARCHAR VSTRING 9 0 9 TransactNo Transaction Number Purchase Invoice      
AM31026 DATETIME DATE 0 0 8 WarrExpDate Warranty Expiration Date      
AM31027 NVARCHAR VSTRING 25 0 25 InsuranceComp Insurance Company      
AM31028 NVARCHAR VSTRING 20 0 20 InsuranceNo Insurance Number      
AM31029 NUMERIC MONEY 28 8 20 InsuredAm Insured Amount      
AM31030 NUMERIC MONEY 28 8 20 PurchPrice Purchase Price      
AM31031 NUMERIC MONEY 28 8 20 RePurchPr Replacement Purchase Price      
AM31032 NUMERIC MONEY 28 8 20 AccRepairs Accumulated Repairs      
AM31033 NUMERIC MONEY 28 8 20 AccAddons Accumulated Add-ons      
AM31034 DATETIME DATE 0 0 8 DatePurch Date Purchased      
AM31035 DATETIME DATE 0 0 8 DateScrapped Date Scrapped      
AM31036 NVARCHAR VSTRING 4 0 4 ScrSoldCode Disposal Code      
AM31037 NUMERIC X_NUMERIC 14 8 6 IndexValue Index Value      
AM31038 NCHAR STRING 4 0 4 LUpdDepr 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.    
AM31039 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
AM31040 INT INTEGER 0 0 2 Spare (obsolete)      
AM31041 NUMERIC X_NUMERIC 14 8 6 Spare (obsolete)      
AM31042 NUMERIC MONEY 28 8 20 Spare (obsolete)      
AM31043 NUMERIC MONEY 28 8 20 Spare (obsolete)      
AM31044 NUMERIC MONEY 28 8 20 Spare (obsolete)      
AM31045 NUMERIC MONEY 28 8 20 Spare (obsolete)      
AM31046 NUMERIC MONEY 28 8 20 Spare (obsolete)      
AM31047 NUMERIC MONEY 28 8 20 Spare (obsolete)      
AM31048 NVARCHAR VSTRING 1 0 1 CapitalizationAllowed Capitalization Allowed      
AM31049 INT INTEGER 0 0 2 Spare (obsolete)      
AM31050 NUMERIC X_NUMERIC 14 8 6 Spare (obsolete)      
AM31051 NUMERIC MONEY 28 8 20 Spare (obsolete)      
AM31052 NUMERIC MONEY 28 8 20 Spare (obsolete)      
AM31053 NUMERIC MONEY 28 8 20 Spare (obsolete)      
AM31054 NUMERIC MONEY 28 8 20 Spare (obsolete)      
AM31055 NUMERIC MONEY 28 8 20 Spare (obsolete)      
AM31056 NUMERIC MONEY 28 8 20 Spare (obsolete)      
AM31057 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
AM31058 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
AM31059 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
AM31060 NVARCHAR VSTRING 30 0 30 InternRem1 Remark Line 1      
AM31061 NVARCHAR VSTRING 30 0 30 InternRem2 Remark Line 2      
AM31062 NVARCHAR VSTRING 5 0 5 InsuranCode Insurance Category      
AM31063 NVARCHAR VSTRING 1 0 1 DocFlag Print New Label      
AM31064 NVARCHAR VSTRING 20 0 20 ServContract Service Contract      
AM31065 NVARCHAR VSTRING 1 0 1 GenBudget 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
   
AM31066 NVARCHAR VSTRING 1 0 1 GenTrans 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.
   
AM31067 NVARCHAR VSTRING 15 0 15 UserDefDat1 User Defined Field 1      
AM31068 NVARCHAR VSTRING 10 0 10 UserDefDat2 User Defined Field 2      
AM31069 NVARCHAR VSTRING 10 0 10 UserDefDat3 User Defined Field 3      
AM31070 NVARCHAR VSTRING 5 0 5 UserDefDat4 User Defined Field 4      
AM31071 INT INTEGER 0 0 1 DeprMetC [Calc] Depreciation Method      
AM31072 INT INTEGER 0 0 2 DeprPerC [Calc] Depreciation Periods/Years      
AM31073 NUMERIC X_NUMERIC 14 8 6 DeprCalc [Calc] Depreciation %      
AM31074 NUMERIC MONEY 28 8 20 DeprAmC [Calc] Depreciation Amount      
AM31075 NUMERIC MONEY 28 8 20 DeprBaseC [Calc] Depreciation Base      
AM31076 NUMERIC MONEY 28 8 20 ScrapValC [Calc] Scrap Value      
AM31077 NUMERIC MONEY 28 8 20 AccDeprC [Calc] Accumulated Depreciations      
AM31078 NUMERIC MONEY 28 8 20 DeprecC [Calc] Depreciations Current Year      
AM31079 NUMERIC MONEY 28 8 20 ExtraDeprC [Calc] Extra Depreciations      
AM31080 NUMERIC X_NUMERIC 14 8 6 IndexValueC [Calc] Index Value      
AM31081 DATETIME DATE 0 0 8 DeprStrtDate Depreciation Start Date      
AM31082 INT INTEGER 0 0 1 NatSwitch1 National Switch 1      
AM31083 INT INTEGER 0 0 1 NatSwitch2 National Switch 2      
AM31084 INT INTEGER 0 0 1 NatSwitch3 National Switch 3      
AM31085 DATETIME DATE 0 0 8 NationDate1 National Date 1      
AM31086 DATETIME DATE 0 0 8 NationDate2 National Date 2      
AM31087 DATETIME DATE 0 0 8 NationDate3 National Date 3      
AM31088 NUMERIC MONEY 28 8 20 NatAmount1 National Amount 1      
AM31089 NUMERIC MONEY 28 8 20 NatAmount2 National Amount 2      
AM31090 NUMERIC MONEY 28 8 20 NatAmount3 National Amount 3      
AM31091 NUMERIC X_NUMERIC 14 8 6 Spare (obsolete)      
AM31092 NUMERIC X_NUMERIC 14 8 6 Spare (obsolete)      
AM31093 NUMERIC X_NUMERIC 14 8 6 Deprec2Calc [Calc] Depreciation % 2      
AM31094 INT INTEGER 0 0 1 Spare (obsolete)      
AM31095 INT INTEGER 0 0 1 Spare (obsolete)      
AM31096 INT INTEGER 0 0 1 DeprSwCalc [Calc] Depreciation % Switch      
AM31097 INT INTEGER 0 0 1 FlagLinkedtoStockCode Linked to Stock Item      
AM31098 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
AM31099 DATETIME DATE 0 0 8 DepreciationEndDate Depreciation End Date      
AM31100 INT INTEGER 0 0 1 LockFlag Locked      
AM31101 INT INTEGER 0 0 1 SummaryLevelFlag Summary Level      
AM31102 NVARCHAR VSTRING 35 0 35 ReportingLevel1 Asset Code Reporting Level 1      
AM31103 NVARCHAR VSTRING 35 0 35 ReportingLevel2 Asset Code Reporting Level 2      
AM31104 NVARCHAR VSTRING 35 0 35 ReportingLevel3 Asset Code Reporting Level 3      
AM31105 NVARCHAR VSTRING 35 0 35 ReportingLevel4 Asset Code Reporting Level 4      
AM31106 NVARCHAR VSTRING 35 0 35 ReportingLevel5 Asset Code Reporting Level 5      
AM31107 NVARCHAR VSTRING 4 0 4 LastUpdateDepreciationTax Last Update Depreciation Tax      
AM31108 NUMERIC MONEY 28 8 20 ValueInConsolidationCurrency ValueInConsolidationCurrency      
AM31109 NVARCHAR VSTRING 35 0 35 AlphaSearchKey Search Key for Description-sorting UPPER(AM31002)    
AM31110 NVARCHAR VSTRING 6 0 6 LeaseGroupCode Lease Group Code      
AM31111 NVARCHAR VSTRING 6 0 6 LeaseCategoryCode Lease Category Code      
AM31112 NVARCHAR VSTRING 35 0 35 SupNameAddr4 Supplier Address Line 4      
AM31113 NVARCHAR VSTRING 35 0 35 SupNameAddr5 Supplier Address Line 5      
AM31114 NVARCHAR VSTRING 35 0 35 SupNameAddr6 Supplier Address Line 6      
AM31115 NVARCHAR VSTRING 35 0 35 SupNameAddr7 Supplier Address Line 7      
AM31116 NVARCHAR VSTRING 3 0 3 SupCountryCode Supplier Country Code      

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