Таблица / Table: AM32 — «Fixed Assets Standard». Маска имени таблицы / Table name mask: «AM32%cc00»
Поле / Field | Тип поля / Field Type | Тип поля Scala / iScala Field Type | Длина поля / Field length | Точность / Precision | Длина Scala / iScala length | Комментарий / Comment | Расширенный комментарий / Extended comment | Дополнительное описание / Additional description | Позиция в индексе / Index position | Первичный ключ? / Is Primary key? |
AM32001 | NVARCHAR | VSTRING | 35 | 0 | 35 | InventCode | Asset Template Code | 1 | Да / Yes | |
AM32002 | NVARCHAR | VSTRING | 35 | 0 | 35 | DescrLine1 | Description Line 1 | |||
AM32003 | NVARCHAR | VSTRING | 35 | 0 | 35 | DescrLine2 | Description Line 2 | |||
AM32004 | NVARCHAR | VSTRING | 10 | 0 | 10 | InventGrCode | Asset Group | |||
AM32005 | NVARCHAR | VSTRING | 50 | 0 | 50 | BalAccAssets | Accounting String | |||
AM32006 | NVARCHAR | VSTRING | 12 | 0 | 12 | BalAccDepr | (obsolete) | |||
AM32007 | NVARCHAR | VSTRING | 12 | 0 | 12 | PLAccDepr | (obsolete) | |||
AM32008 | NVARCHAR | VSTRING | 12 | 0 | 12 | BalAccDepr2 | (obsolete) | |||
AM32009 | NVARCHAR | VSTRING | 12 | 0 | 12 | PLAccDepr2 | (obsolete) | |||
AM32010 | NCHAR | STRING | 1 | 0 | 1 | CostCenter | 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) |
||
AM32011 | NVARCHAR | VSTRING | 1 | 0 | 1 | ProductCode | (obsolete) | |||
AM32012 | NVARCHAR | VSTRING | 1 | 0 | 1 | YearlyReducingTaxDepreciation | 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. |
||
AM32013 | NCHAR | STRING | 3 | 0 | 3 | NoteNumber | Note Number | |||
AM32014 | NVARCHAR | VSTRING | 4 | 0 | 4 | CategoryA | Category A | |||
AM32015 | NVARCHAR | VSTRING | 4 | 0 | 4 | CategoryB | Category B | |||
AM32016 | NVARCHAR | VSTRING | 15 | 0 | 15 | Location | Location | |||
AM32017 | NVARCHAR | VSTRING | 10 | 0 | 10 | SupplierCode | Supplier Code | |||
AM32018 | NVARCHAR | VSTRING | 35 | 0 | 35 | SupplierName | Supplier Name | |||
AM32019 | NVARCHAR | VSTRING | 35 | 0 | 35 | SupplierAdd1 | Supplier Address Line 1 | |||
AM32020 | NVARCHAR | VSTRING | 35 | 0 | 35 | SupplierAdd2 | Supplier Address Line 2 | |||
AM32021 | NVARCHAR | VSTRING | 35 | 0 | 35 | SupplierAdd3 | Supplier Address Line 3 | |||
AM32022 | NVARCHAR | VSTRING | 25 | 0 | 25 | TechContact | Contact Name | |||
AM32023 | NVARCHAR | VSTRING | 15 | 0 | 15 | TelephNumber | Telephone Number | |||
AM32024 | NVARCHAR | VSTRING | 25 | 0 | 25 | SupplInvNo | Supplier Invoice | |||
AM32025 | NVARCHAR | VSTRING | 9 | 0 | 9 | NLTransNo | Transaction Number Purchase Invoice | |||
AM32026 | DATETIME | DATE | 0 | 0 | 8 | WarrExpDate | Warranty Expiration Date | |||
AM32027 | NVARCHAR | VSTRING | 25 | 0 | 25 | InsurancComp | Insurance Company | |||
AM32028 | NVARCHAR | VSTRING | 20 | 0 | 20 | InsuranceNo | Insurance Number | |||
AM32029 | NUMERIC | MONEY | 28 | 8 | 20 | InsureAmount | Insured Amount | |||
AM32030 | NUMERIC | MONEY | 28 | 8 | 20 | PurchPrice | Purchase Price | |||
AM32031 | NUMERIC | MONEY | 28 | 8 | 20 | RePurchPri | Replacement Purchase Price | |||
AM32032 | NUMERIC | MONEY | 28 | 8 | 20 | AccRepairs | Accumulated Repairs | |||
AM32033 | NUMERIC | MONEY | 28 | 8 | 20 | AccAddons | Accumulated Add-ons | |||
AM32034 | DATETIME | DATE | 0 | 0 | 8 | DatePurchase | Date Purchased | |||
AM32035 | DATETIME | DATE | 0 | 0 | 8 | DateScraSold | Date Scrapped | |||
AM32036 | NVARCHAR | VSTRING | 4 | 0 | 4 | ScraSoldCode | Disposal Code | |||
AM32037 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | IndexValue | Index Value | |||
AM32038 | NVARCHAR | VSTRING | 4 | 0 | 4 | LastUpdDepr | 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. | ||
AM32039 | NCHAR | STRING | 1 | 0 | 1 | TaxDeprMeth | (obsolete) | |||
AM32040 | INT | INTEGER | 0 | 0 | 2 | TaxDeprPerYr | (obsolete) | |||
AM32041 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | TaxDeprec | (obsolete) | |||
AM32042 | NUMERIC | MONEY | 28 | 8 | 20 | TaxDeprAm | (obsolete) | |||
AM32043 | NUMERIC | MONEY | 28 | 8 | 20 | TaxDeprBase | (obsolete) | |||
AM32044 | NUMERIC | MONEY | 28 | 8 | 20 | TaxScrapVal | (obsolete) | |||
AM32045 | NUMERIC | MONEY | 28 | 8 | 20 | TaxAccumDepr | (obsolete) | |||
AM32046 | NUMERIC | MONEY | 28 | 8 | 20 | TaxDeprYear | (obsolete) | |||
AM32047 | NUMERIC | MONEY | 28 | 8 | 20 | TaxExtraDepr | (obsolete) | |||
AM32048 | NCHAR | STRING | 1 | 0 | 1 | Capitalization Allowed | Capitalization Allowed | |||
AM32049 | INT | INTEGER | 0 | 0 | 2 | PlanDeprPerY | (obsolete) | |||
AM32050 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | PlanDeprec | (obsolete) | |||
AM32051 | NUMERIC | MONEY | 28 | 8 | 20 | PlanDeprAm | (obsolete) | |||
AM32052 | NUMERIC | MONEY | 28 | 8 | 20 | PlanDeprBase | (obsolete) | |||
AM32053 | NUMERIC | MONEY | 28 | 8 | 20 | PlanScrapVal | (obsolete) | |||
AM32054 | NUMERIC | MONEY | 28 | 8 | 20 | PlanAccDepr | (obsolete) | |||
AM32055 | NUMERIC | MONEY | 28 | 8 | 20 | PlanDeprYear | (obsolete) | |||
AM32056 | NUMERIC | MONEY | 28 | 8 | 20 | PlanExtraDep | (obsolete) | |||
AM32057 | NCHAR | STRING | 2 | 0 | 2 | PlanPeriodN1 | (obsolete) | |||
AM32058 | NCHAR | STRING | 2 | 0 | 2 | PlanPeriodN2 | (obsolete) | |||
AM32059 | NCHAR | STRING | 2 | 0 | 2 | PlanPeriodN3 | (obsolete) | |||
AM32060 | NVARCHAR | VSTRING | 30 | 0 | 30 | InternalRem1 | Remark Line 1 | |||
AM32061 | NVARCHAR | VSTRING | 30 | 0 | 30 | InternalRem2 | Remark Line 2 | |||
AM32062 | NVARCHAR | VSTRING | 5 | 0 | 5 | InsurancCode | Insurance Category | |||
AM32063 | NCHAR | STRING | 1 | 0 | 1 | DocumentFlag | Print New Label | |||
AM32064 | NVARCHAR | VSTRING | 20 | 0 | 20 | ServContract | Service Contract | |||
AM32065 | NCHAR | STRING | 1 | 0 | 1 | GenerateBudg | 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 |
||
AM32066 | NCHAR | STRING | 1 | 0 | 1 | GenerateTran | 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. |
||
AM32067 | NVARCHAR | VSTRING | 15 | 0 | 15 | UserDefData1 | User Defined Field 1 | |||
AM32068 | NVARCHAR | VSTRING | 10 | 0 | 10 | UserDefData2 | User Defined Field 2 | |||
AM32069 | NVARCHAR | VSTRING | 10 | 0 | 10 | UserDefData3 | User Defined Field 3 | |||
AM32070 | NVARCHAR | VSTRING | 5 | 0 | 5 | UserDefData4 | User Defined Field 4 | |||
AM32071 | INT | INTEGER | 0 | 0 | 1 | CalcDeprMeth | [Calc] Depreciation Method | |||
AM32072 | INT | INTEGER | 0 | 0 | 2 | CalcDeprPerY | [Calc] Depreciation Periods/Years | |||
AM32073 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | CalcDeprec | [Calc] Depreciation % | |||
AM32074 | NUMERIC | MONEY | 28 | 8 | 20 | CalcDeprAm | [Calc] Depreciation Amount | |||
AM32075 | NUMERIC | MONEY | 28 | 8 | 20 | CalcDeprBase | [Calc] Depreciation Base | |||
AM32076 | NUMERIC | MONEY | 28 | 8 | 20 | CalcScrapVal | [Calc] Scrap Value | |||
AM32077 | NUMERIC | MONEY | 28 | 8 | 20 | CalcAccDepr | [Calc] Accumulated Depreciations | |||
AM32078 | NUMERIC | MONEY | 28 | 8 | 20 | CalcDeprYear | [Calc] Depreciations Current Year | |||
AM32079 | NUMERIC | MONEY | 28 | 8 | 20 | CalcExtraDep | [Calc] Extra Depreciations | |||
AM32080 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | CalcIndexVal | [Calc] Index Value | |||
AM32081 | DATETIME | DATE | 0 | 0 | 8 | DepStartDate | Depreciation Start Date | |||
AM32082 | INT | INTEGER | 0 | 0 | 1 | NationalSw1 | National Switch 1 | |||
AM32083 | INT | INTEGER | 0 | 0 | 1 | NationalSw2 | National Switch 2 | |||
AM32084 | INT | INTEGER | 0 | 0 | 1 | NationalSw3 | National Switch 3 | |||
AM32085 | DATETIME | DATE | 0 | 0 | 8 | NationDate1 | National Date 1 | |||
AM32086 | DATETIME | DATE | 0 | 0 | 8 | NationDate2 | National Date 2 | |||
AM32087 | DATETIME | DATE | 0 | 0 | 8 | NationDate3 | National Date 3 | |||
AM32088 | NUMERIC | MONEY | 28 | 8 | 20 | NationalAm1 | National Amount 1 | |||
AM32089 | NUMERIC | MONEY | 28 | 8 | 20 | NationalAm2 | National Amount 2 | |||
AM32090 | NUMERIC | MONEY | 28 | 8 | 20 | NationalAm3 | National Amount 3 | |||
AM32091 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | DepreciatTAX | (obsolete) | |||
AM32092 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | DeprecPlan | (obsolete) | |||
AM32093 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | DeprecCalc | [Calc] Depreciation % 2 | |||
AM32094 | INT | INTEGER | 0 | 0 | 1 | DepSwitcTask | (obsolete) | |||
AM32095 | INT | INTEGER | 0 | 0 | 1 | DepSwitcPlan | (obsolete) | |||
AM32096 | INT | INTEGER | 0 | 0 | 1 | DepSwitchCalc | [Calc] Depreciation % Switch | |||
AM32097 | INT | INTEGER | 0 | 0 | 1 | FlagLinkedtoStockCode | Linked to Stock Item | |||
AM32098 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
AM32099 | DATETIME | DATE | 0 | 0 | 8 | DepreciationEndDate | Depreciation End Date | |||
AM32100 | INT | INTEGER | 0 | 0 | 1 | LockFlag | Locked | |||
AM32101 | INT | INTEGER | 0 | 0 | 1 | SummaryLevelFlag | Summary Level | |||
AM32102 | NVARCHAR | VSTRING | 35 | 0 | 35 | ReportingLevel1 | Asset Code Reporting Level 1 | |||
AM32103 | NVARCHAR | VSTRING | 35 | 0 | 35 | ReportingLevel2 | Asset Code Reporting Level 2 | |||
AM32104 | NVARCHAR | VSTRING | 35 | 0 | 35 | ReportingLevel3 | Asset Code Reporting Level 3 | |||
AM32105 | NVARCHAR | VSTRING | 35 | 0 | 35 | ReportingLevel4 | Asset Code Reporting Level 4 | |||
AM32106 | NVARCHAR | VSTRING | 35 | 0 | 35 | ReportingLevel5 | Asset Code Reporting Level 5 | |||
AM32107 | NVARCHAR | VSTRING | 4 | 0 | 4 | LastUpdateDepreciationTax | Last Update Depreciation Tax | |||
AM32108 | NUMERIC | MONEY | 28 | 8 | 20 | ValueInConsolidationCurrency | ValueInConsolidationCurrency | |||
AM32109 | NVARCHAR | VSTRING | 35 | 0 | 35 | spare | spare | |||
AM32110 | NVARCHAR | VSTRING | 6 | 0 | 6 | LeaseGroupCode | Lease Group Code | |||
AM32111 | NVARCHAR | VSTRING | 6 | 0 | 6 | LeaseCategoryCode | Lease Category Code | |||
AM32112 | NVARCHAR | VSTRING | 35 | 0 | 35 | SupplierAdd4 | Supplier Address Line 4 | |||
AM32113 | NVARCHAR | VSTRING | 35 | 0 | 35 | SupplierAdd5 | Supplier Address Line 5 | |||
AM32114 | NVARCHAR | VSTRING | 35 | 0 | 35 | SupplierAdd6 | Supplier Address Line 6 | |||
AM32115 | NVARCHAR | VSTRING | 35 | 0 | 35 | SupplierAdd7 | Supplier Address Line 7 | |||
AM32116 | NVARCHAR | VSTRING | 3 | 0 | 3 | SupplierCountryCode | Supplier Country Code |
Навигация / Navigation:
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список системных таблиц / System Tables
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Основными Средствами» / List of tables of module «Asset Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Контрактами» / List of tables of module «Contract Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Прямая выписка счетов» / List of tables of module «Direct Invoicing»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Главная Книга» / List of tables of module «General Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Ресурсами» / List of tables of module «Resourse Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «База данных рынка» / List of tables of module «Market Database»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Производством» / List of tables of module «Material Production Control»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Продажу» / List of tables of module «Sales Order»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заработная плата» / List of tables of module «Payroll»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Закупку» / List of tables of module «Purchase Order»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Закупок» / List of tables of module «Purchase Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Долговые обязательства» / List of tables of module «Promissory Notes»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление проектами» / List of tables of module «Project Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Запасами» / List of tables of module «Stock Control»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Продаж» / List of tables of module «Sales Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление заказом на обслуживание» / List of tables of module «Service Order Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Статистика» / List of tables of module «Statistics»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Системные Утилиты» / List of tables of module «System Utilities/Office Autom.»