пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Asset Management»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица AMH1 — Fixed Assets History

Таблица: AMH1 — «Fixed Assets History». Маска имени таблицы: «AMH1%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
AMH1001 NCHAR STRING 3 0 3 TransactionType Transaction Type   1 Да
AMH1002 DATETIME DATE 0 0 8 TransactionDate Transaction Date   2 Да
AMH1003 NCHAR STRING 9 0 9 TransactionTime Transaction Time   3 Да
AMH1004 NVARCHAR VSTRING 35 0 35 InventoryCode Asset Code   4 Да
AMH1005 NCHAR STRING 10 0 10 TransactionCode Transaction Code   5 Да
AMH1006 NCHAR STRING 8 0 8 UserID User   6 Да
AMH1007 NVARCHAR VSTRING 10 0 10 TransactionCounter Transaction Number   7 Да
AMH1008 NVARCHAR VSTRING 35 0 35 DescrLine1 Description Line 1      
AMH1009 NVARCHAR VSTRING 35 0 35 DescrLine2 Description Line 2      
AMH1010 NVARCHAR VSTRING 10 0 10 InventGroup Asset Group      
AMH1011 NVARCHAR VSTRING 50 0 50 AccString Accounting String      
AMH1012 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
AMH1013 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
AMH1014 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
AMH1015 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
AMH1016 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)
   
AMH1017 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
AMH1018 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
AMH1019 NVARCHAR VSTRING 3 0 3 NoteNo Note Number      
AMH1020 NVARCHAR VSTRING 4 0 4 CategoryA Category A      
AMH1021 NVARCHAR VSTRING 4 0 4 CategoryB Category B      
AMH1022 NVARCHAR VSTRING 15 0 15 Location Location      
AMH1023 NVARCHAR VSTRING 10 0 10 SuplCode Supplier Code      
AMH1024 NVARCHAR VSTRING 35 0 35 SupplierName Supplier Name      
AMH1025 NVARCHAR VSTRING 35 0 35 SupNameAddr1 Supplier Address Line 1      
AMH1026 NVARCHAR VSTRING 35 0 35 SupNameAddr2 Supplier Address Line 2      
AMH1027 NVARCHAR VSTRING 35 0 35 SupNameAddr3 Supplier Address Line 3      
AMH1028 NVARCHAR VSTRING 25 0 25 NameContact Contact Name      
AMH1029 NVARCHAR VSTRING 15 0 15 Telephone Telephone Number      
AMH1030 NVARCHAR VSTRING 15 0 15 SupplInv Supplier Invoice      
AMH1031 NVARCHAR VSTRING 9 0 9 TransactionNoPCInvoice Transaction Number Purchase Invoice      
AMH1032 DATETIME DATE 0 0 8 WarrExpDate Warranty Expiration Date      
AMH1033 NVARCHAR VSTRING 25 0 25 InsuranceComp Insurance Company      
AMH1034 NVARCHAR VSTRING 20 0 20 InsuranceNo Insurance Number      
AMH1035 NUMERIC MONEY 28 8 20 InsuredAm Insured Amount      
AMH1036 NUMERIC MONEY 28 8 20 PurchPrice Purchase Price      
AMH1037 NUMERIC MONEY 28 8 20 RePurchPr Replacement Purchase Price      
AMH1038 NUMERIC MONEY 28 8 20 AccRepairs Accumulated Repairs      
AMH1039 NUMERIC MONEY 28 8 20 AccAddons Accumulated Add-ons      
AMH1040 DATETIME DATE 0 0 8 DatePurch Date Purchased      
AMH1041 DATETIME DATE 0 0 8 DateScrapped Date Scrapped      
AMH1042 NVARCHAR VSTRING 4 0 4 ScrSoldCode Disposal Code      
AMH1043 NVARCHAR VSTRING 6 0 6 IndexValue Index Value      
AMH1044 NCHAR STRING 4 0 4 LUpdDepr Last Depreciation Update Date      
AMH1045 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
AMH1046 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
AMH1047 NVARCHAR VSTRING 9 0 9 TransactionNoGL General Ledger Transaction Number      
AMH1048 NUMERIC MONEY 28 8 20 Spare (obsolete)      
AMH1049 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMH1050 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMH1051 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMH1052 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMH1053 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMH1054 NVARCHAR VSTRING 1 0 1 Capitalization Allowed Capitalization Allowed      
AMH1055 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
AMH1056 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
AMH1057 NUMERIC MONEY 28 8 20 Spare (obsolete)      
AMH1058 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMH1059 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMH1060 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMH1061 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMH1062 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMH1063 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
AMH1064 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
AMH1065 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
AMH1066 NVARCHAR VSTRING 30 0 30 InternRem1 Remark Line 1      
AMH1067 NVARCHAR VSTRING 30 0 30 InternRem2 Remark Line 2      
AMH1068 NVARCHAR VSTRING 5 0 5 InsuranCode Insurance Category      
AMH1069 NVARCHAR VSTRING 1 0 1 DocFlag Label Status      
AMH1070 NVARCHAR VSTRING 20 0 20 ServContract Service Contract      
AMH1071 NVARCHAR VSTRING 1 0 1 GenBudget Generate Budget      
AMH1072 NVARCHAR VSTRING 1 0 1 GenTrans Generate Transactions      
AMH1073 NVARCHAR VSTRING 15 0 15 UserDefDat1 User Defined Field 1      
AMH1074 NVARCHAR VSTRING 10 0 10 UserDefDat2 User Defined Field 2      
AMH1075 NVARCHAR VSTRING 10 0 10 UserDefDat3 User Defined Field 3      
AMH1076 NVARCHAR VSTRING 5 0 5 UserDefDat4 User Defined Field 4      
AMH1077 NVARCHAR VSTRING 1 0 1 DeprMetC [Calc] Depreciation Method      
AMH1078 NVARCHAR VSTRING 2 0 2 DeprPerC [Calc] Depreciation Periods/Years      
AMH1079 NVARCHAR VSTRING 6 0 6 DeprCalc [Calc] Depreciation %      
AMH1080 NUMERIC MONEY 28 8 20 DeprAmC [Calc] Depreciation Amount      
AMH1081 NUMERIC MONEY 28 8 20 DeprBaseC [Calc] Depreciation Base      
AMH1082 NUMERIC MONEY 28 8 20 ScrapValC [Calc] Scrap Value      
AMH1083 NUMERIC MONEY 28 8 20 AccDeprC [Calc] Accumulated Depreciations      
AMH1084 NUMERIC MONEY 28 8 20 DeprecC [Calc] Depreciations Current Year      
AMH1085 NUMERIC MONEY 28 8 20 ExtraDeprC [Calc] Extra Depreciations      
AMH1086 NVARCHAR VSTRING 6 0 6 IndexValueC [Calc] Index Value      
AMH1087 DATETIME DATE 0 0 8 DeprStrtDate Depreciation Start Date      
AMH1088 NVARCHAR VSTRING 1 0 1 NatSwitch1 National Switch 1      
AMH1089 NVARCHAR VSTRING 1 0 1 NatSwitch2 National Switch 2      
AMH1090 NVARCHAR VSTRING 1 0 1 NatSwitch3 National Switch 3      
AMH1091 DATETIME DATE 0 0 8 NationDate1 National Date 1      
AMH1092 DATETIME DATE 0 0 8 NationDate2 National Date 2      
AMH1093 DATETIME DATE 0 0 8 NationDate3 National Date 3      
AMH1094 NUMERIC MONEY 28 8 20 NatAmount1 National Amount 1      
AMH1095 NUMERIC MONEY 28 8 20 NatAmount2 National Amount 2      
AMH1096 NUMERIC MONEY 28 8 20 NatAmount3 National Amount 3      
AMH1097 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
AMH1098 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
AMH1099 NVARCHAR VSTRING 6 0 6 Deprec2Calc [Calc] Depreciation % 2      
AMH1100 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
AMH1101 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
AMH1102 NVARCHAR VSTRING 1 0 1 DeprSwCalc [Calc] Depreciation % Switch      
AMH1103 DATETIME DATE 0 0 8 BookEntryDate Book-Entry Date      
AMH1104 INT INTEGER 0 0 1 FlagLinkedtoStockCode Linked to Stock Item      
AMH1105 NVARCHAR VSTRING 12 0 12 BatchNo Batch ID      
AMH1106 NVARCHAR VSTRING 6 0 6 WH Warehouse      
AMH1107 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code      
AMH1108 NVARCHAR VSTRING 12 0 12 BatchNoOriginal Batch Number      
AMH1109 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
AMH1110 DATETIME DATE 0 0 8 DepreciationEndDate Depreciation End Date      
AMH1111 INT INTEGER 0 0 1 LockFlag Locked      
AMH1112 INT INTEGER 0 0 1 SummaryLevelFlag Summary Level      
AMH1113 NVARCHAR VSTRING 35 0 35 ReportingLevel1 Asset Code Reporting Level 1      
AMH1114 NVARCHAR VSTRING 35 0 35 ReportingLevel2 Asset Code Reporting Level 2      
AMH1115 NVARCHAR VSTRING 35 0 35 ReportingLevel3 Asset Code Reporting Level 3      
AMH1116 NVARCHAR VSTRING 35 0 35 ReportingLevel4 Asset Code Reporting Level 4      
AMH1117 NVARCHAR VSTRING 35 0 35 ReportingLevel5 Asset Code Reporting Level 5      
AMH1118 NVARCHAR VSTRING 4 0 4 LastUpdateDepreciationTax Last Update Depreciation Tax      
AMH1119 NUMERIC MONEY 28 8 20 ValueInConsolidationCurrency ValueInConsolidationCurrency      
AMH1120 NVARCHAR VSTRING 35 0 35 AlphaSearchKey AlphaSearchKey      
AMH1121 NVARCHAR VSTRING 6 0 6 LeaseGroupCode Lease Group Code      
AMH1122 NVARCHAR VSTRING 6 0 6 LeaseCategoryCode Lease Category Code      
AMH1123 NVARCHAR VSTRING 35 0 35 SupNameAddr4 Supplier Address Line 4      
AMH1124 NVARCHAR VSTRING 35 0 35 SupNameAddr5 Supplier Address Line 5      
AMH1125 NVARCHAR VSTRING 35 0 35 SupNameAddr6 Supplier Address Line 6      
AMH1126 NVARCHAR VSTRING 35 0 35 SupNameAddr7 Supplier Address Line 7      
AMH1127 NVARCHAR VSTRING 3 0 3 SupCountryCode Supplier Country Code      

Навигация: