Таблица: 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 Supplier_Name 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 15 0 15 SupplInv Supplier Invoice      
AM31025 NVARCHAR VSTRING 6 0 6 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 Spare (obsolete)      
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 Flag_LinkedtoStockCode Linked to Stock Item      
AM31098 NVARCHAR VSTRING 35 0 35 Address_Supplier_Line_4 Supplier Address Line 4      
AM31099 DATETIME DATE 0 0 8 Depreciation End Date Depreciation End Date      
AM31100 INT INTEGER 0 0 1 Lock Flag Locked      
AM31101 INT INTEGER 0 0 1 Summary Level Flag Summary Level      
AM31102 NVARCHAR VSTRING 35 0 35 Reporting Level 1 Asset Code Reporting Level 1      
AM31103 NVARCHAR VSTRING 35 0 35 Reporting Level 2 Asset Code Reporting Level 2      
AM31104 NVARCHAR VSTRING 35 0 35 Reporting Level 3 Asset Code Reporting Level 3      
AM31105 NVARCHAR VSTRING 35 0 35 Reporting Level 4 Asset Code Reporting Level 4      
AM31106 NVARCHAR VSTRING 35 0 35 Reporting Level 5 Asset Code Reporting Level 5      
AM31107 NVARCHAR VSTRING 4 0 4 Last Update Depreciation Tax 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 Lease Group Code Lease Group Code      
AM31111 NVARCHAR VSTRING 6 0 6 Lease Category Code Lease Category Code      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Asset Management | Asset Master Table