Таблица / 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:
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список системных таблиц / System Tables
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Основными Средствами»/List of tables of module «Asset Management»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Контрактами»/List of tables of module «Contract Management»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Прямая выписка счетов»/List of tables of module «Direct Invoicing»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Главная Книга»/List of tables of module «General Ledger»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Ресурсами»/List of tables of module «Resourse Management»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «База Данных рынка»/List of tables of module «Market Database»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Материалами в Производстве»/List of tables of module «Material Production Control»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Заказы на Продажу»/List of tables of module «Sales Order»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Зарплата»/List of tables of module «Payroll»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Заказ на Закупку»/List of tables of module «Purchase Order»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Книга Закупок»/List of tables of module «Purchase Ledger»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Долговые обязательства»/List of tables of module «Promissory Notes»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Проектами»/List of tables of module «Project Management»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Запасами»/List of tables of module «Stock Control»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Книга Продаж»/List of tables of module «Sales Ledger»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление заказом на обслуживание»/List of tables of module «Service Order Management»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Статистика»/List of tables of module «Statistics»
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Системные Утилиты/Автом. Офиса»/List of tables of module «System Utilities/Office Autom.»