One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Asset Management»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table AMT5 — Year Depreciation Transactions

Таблица / Table: AMT5 — «Years Trans Depreciation». Маска имени таблицы / Table name mask: «AMT5%cc%yy»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
AMT5001 NVARCHAR VSTRING 35 0 35 FixedAsset Asset Code   1 Да / Yes
AMT5002 NVARCHAR VSTRING 10 0 10 TransCode Transaction Code   2 Да / Yes
AMT5003 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code Depreciation   3 Да / Yes
AMT5004 NUMERIC MONEY 28 8 20 DepPlanPer1 [Plan] Depreciation Period 1      
AMT5005 NUMERIC MONEY 28 8 20 DeprTaxPer1 [Tax] Depreciation Period 1      
AMT5006 NUMERIC MONEY 28 8 20 DepPlanPer2 [Plan] Depreciation Period 2      
AMT5007 NUMERIC MONEY 28 8 20 DeprTaxPer2 [Tax] Depreciation Period 2      
AMT5008 NUMERIC MONEY 28 8 20 DepPlanPer3 [Plan] Depreciation Period 3      
AMT5009 NUMERIC MONEY 28 8 20 DeprTaxPer3 [Tax] Depreciation Period 3      
AMT5010 NUMERIC MONEY 28 8 20 DepPlanPer4 [Plan] Depreciation Period 4      
AMT5011 NUMERIC MONEY 28 8 20 DeprTaxPer4 [Tax] Depreciation Period 4      
AMT5012 NUMERIC MONEY 28 8 20 DepPlanPer5 [Plan] Depreciation Period 5      
AMT5013 NUMERIC MONEY 28 8 20 DeprTaxPer5 [Tax] Depreciation Period 5      
AMT5014 NUMERIC MONEY 28 8 20 DepPlanPer6 [Plan] Depreciation Period 6      
AMT5015 NUMERIC MONEY 28 8 20 DeprTaxPer6 [Tax] Depreciation Period 6      
AMT5016 NUMERIC MONEY 28 8 20 DepPlanPer7 [Plan] Depreciation Period 7      
AMT5017 NUMERIC MONEY 28 8 20 DeprTaxPer7 [Tax] Depreciation Period 7      
AMT5018 NUMERIC MONEY 28 8 20 DepPlanPer8 [Plan] Depreciation Period 8      
AMT5019 NUMERIC MONEY 28 8 20 DeprTaxPer8 [Tax] Depreciation Period 8      
AMT5020 NUMERIC MONEY 28 8 20 DepPlanPer9 [Plan] Depreciation Period 9      
AMT5021 NUMERIC MONEY 28 8 20 DeprTaxPer9 [Tax] Depreciation Period 9      
AMT5022 NUMERIC MONEY 28 8 20 DepPlanPer10 [Plan] Depreciation Period 10      
AMT5023 NUMERIC MONEY 28 8 20 DeprTaxPer10 [Tax] Depreciation Period 10      
AMT5024 NUMERIC MONEY 28 8 20 DepPlanPer11 [Plan] Depreciation Period 11      
AMT5025 NUMERIC MONEY 28 8 20 DeprTaxPer11 [Tax] Depreciation Period 11      
AMT5026 NUMERIC MONEY 28 8 20 DepPlanPer12 [Plan] Depreciation Period 12      
AMT5027 NUMERIC MONEY 28 8 20 DeprTaxPer12 [Tax] Depreciation Period 12      
AMT5028 NUMERIC MONEY 28 8 20 DepPlanPer13 [Plan] Depreciation Period 13      
AMT5029 NUMERIC MONEY 28 8 20 DeprTaxPer13 [Tax] Depreciation Period 13      
AMT5030 NUMERIC MONEY 28 8 20 DepPlanPer14 [Plan] Depreciation Period 14      
AMT5031 NUMERIC MONEY 28 8 20 DeprTaxPer14 [Tax] Depreciation Period 14      
AMT5032 NUMERIC MONEY 28 8 20 DepPlanPer15 [Plan] Depreciation Period 15      
AMT5033 NUMERIC MONEY 28 8 20 DeprTaxPer15 [Tax] Depreciation Period 15      
AMT5034 NUMERIC MONEY 28 8 20 DepPlanPer16 [Plan] Depreciation Period 16      
AMT5035 NUMERIC MONEY 28 8 20 DeprTaxPer16 [Tax] Depreciation Period 16      
AMT5036 NUMERIC MONEY 28 8 20 DepPlanPer17 [Plan] Depreciation Period 17      
AMT5037 NUMERIC MONEY 28 8 20 DeprTaxPer17 [Tax] Depreciation Period 17      
AMT5038 NUMERIC MONEY 28 8 20 DepPlanPer18 [Plan] Depreciation Period 18      
AMT5039 NUMERIC MONEY 28 8 20 DeprTaxPer18 [Tax] Depreciation Period 18      
AMT5040 NUMERIC MONEY 28 8 20 DepPlanPer19 [Plan] Depreciation Period 19      
AMT5041 NUMERIC MONEY 28 8 20 DeprTaxPer19 [Tax] Depreciation Period 19      
AMT5042 NUMERIC MONEY 28 8 20 DepPlanPer20 [Plan] Depreciation Period 20      
AMT5043 NUMERIC MONEY 28 8 20 DeprTaxPer20 [Tax] Depreciation Period 20      
AMT5044 NUMERIC MONEY 28 8 20 DepPlanPer21 [Plan] Depreciation Period 21      
AMT5045 NUMERIC MONEY 28 8 20 DeprTaxPer21 [Tax] Depreciation Period 21      
AMT5046 NUMERIC MONEY 28 8 20 DepPlanPer22 [Plan] Depreciation Period 22      
AMT5047 NUMERIC MONEY 28 8 20 DeprTaxPer22 [Tax] Depreciation Period 22      
AMT5048 NUMERIC MONEY 28 8 20 DepPlanPer23 [Plan] Depreciation Period 23      
AMT5049 NUMERIC MONEY 28 8 20 DeprTaxPer23 [Tax] Depreciation Period 23      
AMT5050 NUMERIC MONEY 28 8 20 DepPlanPer24 [Plan] Depreciation Period 24      
AMT5051 NUMERIC MONEY 28 8 20 DeprTaxPer24 [Tax] Depreciation Period 24      
AMT5052 NUMERIC MONEY 28 8 20 DepPlanPer25 [Plan] Depreciation Period 25      
AMT5053 NUMERIC MONEY 28 8 20 DeprTaxPer25 [Tax] Depreciation Period 25      

Навигация / Navigation: