Таблица: 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