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

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

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
AM31001 NVARCHAR VSTRING 35 0 35 InventoryCod Asset Code   1 Да
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 VSTRING 50 0 50 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 Capitalization Allowed 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      

История изменения структуры таблицы / 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
AM31024 15 15 15 15 15 15 15 15 15 15 25 25 25 25
AM31025 6 6 6 6 6 6 9 9 9 9 9 9 9 9
AM31037 6 6 6 6 14 6 14 6 14 6 14 6 14 6
AM31040 2 2 2 2 0 2 0 2 0 2 0 2 0 2
AM31041 6 6 6 6 14 6 14 6 14 6 14 6 14 6
AM31043 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM31044 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM31045 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM31046 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM31047 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM31049 2 2 2 2 0 2 0 2 0 2 0 2 0 2
AM31050 6 6 6 6 14 6 14 6 14 6 14 6 14 6
AM31052 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM31053 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM31054 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM31055 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM31056 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM31071 1 1 1 1 0 1 0 1 0 1 0 1 0 1
AM31072 2 2 2 2 0 2 0 2 0 2 0 2 0 2
AM31073 6 6 6 6 14 6 14 6 14 6 14 6 14 6
AM31075 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM31076 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM31077 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM31078 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM31079 20 20 20 20 28 20 28 20 28 20 28 20 28 20
AM31080 6 6 6 6 14 6 14 6 14 6 14 6 14 6
AM31082 1 1 1 1 0 1 0 1 0 1 0 1 0 1
AM31083 1 1 1 1 0 1 0 1 0 1 0 1 0 1
AM31084 1 1 1 1 0 1 0 1 0 1 0 1 0 1
AM31091 6 6 6 6 14 6 14 6 14 6 14 6 14 6
AM31092 6 6 6 6 14 6 14 6 14 6 14 6 14 6
AM31093 6 6 6 6 14 6 14 6 14 6 14 6 14 6
AM31094 1 1 1 1 0 1 0 1 0 1 0 1 0 1
AM31095 1 1 1 1 0 1 0 1 0 1 0 1 0 1
AM31096 1 1 1 1 0 1 0 1 0 1 0 1 0 1
AM31110 — — — — 6 6 6 6 6 6 6 6 6 6
AM31111 — — — — 6 6 6 6 6 6 6 6 6 6
AM31112 — — — — — — 35 35 35 35 35 35 35 35
AM31113 — — — — — — 35 35 35 35 35 35 35 35
AM31114 — — — — — — 35 35 35 35 35 35 35 35
AM31115 — — — — — — 35 35 35 35 35 35 35 35
AM31116 — — — — — — 3 3 3 3 3 3 3 3

Навигация: