One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Asset Management»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица AMT1 — Fixed Asset Transactions

Таблица: AMT1 — «FA Transaction Asset File». Маска имени таблицы: «AMT1%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
AMT1001 NVARCHAR VSTRING 35 0 35 InventoryCod Asset Code   1 Да
AMT1002 NVARCHAR VSTRING 10 0 10 TransCode Transaction Code   2 Да
AMT1003 NVARCHAR VSTRING 35 0 35 DescrLine1 Description Line 1      
AMT1004 NVARCHAR VSTRING 35 0 35 DescrLine2 Description Line 2      
AMT1005 NVARCHAR VSTRING 10 0 10 InventGroup Asset Group      
AMT1006 NVARCHAR VSTRING 50 0 50 AccString Accounting String      
AMT1007 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
AMT1008 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
AMT1009 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
AMT1010 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
AMT1011 NVARCHAR VSTRING 1 0 1 RetrDeprec Retroactive Adjustment of Depreciations      
AMT1012 NVARCHAR VSTRING 1 0 1 DisposalType (obsolete)      
AMT1013 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.
   
AMT1014 NVARCHAR VSTRING 3 0 3 NoteNo Note Number      
AMT1015 NVARCHAR VSTRING 4 0 4 CategoryA Category A      
AMT1016 NVARCHAR VSTRING 4 0 4 CategoryB Category B      
AMT1017 NVARCHAR VSTRING 15 0 15 Location Location      
AMT1018 NVARCHAR VSTRING 10 0 10 SuplCode Supplier Code      
AMT1019 NVARCHAR VSTRING 35 0 35 SupplierName Supplier Name      
AMT1020 NVARCHAR VSTRING 35 0 35 SupNameAddr1 Supplier Address Line 1      
AMT1021 NVARCHAR VSTRING 35 0 35 SupNameAddr2 Supplier Address Line 2      
AMT1022 NVARCHAR VSTRING 35 0 35 SupNameAddr3 Supplier Address Line 3      
AMT1023 NVARCHAR VSTRING 25 0 25 NameContact Contact Name      
AMT1024 NVARCHAR VSTRING 15 0 15 Telephone Telephone Number      
AMT1025 NVARCHAR VSTRING 25 0 25 SupplInv Supplier Invoice      
AMT1026 NVARCHAR VSTRING 9 0 9 TransactNo Transaction Number Purchase Invoice      
AMT1027 DATETIME DATE 0 0 8 WarrExpDate Warranty Expiration Date      
AMT1028 NVARCHAR VSTRING 25 0 25 InsuranceComp Insurance Company      
AMT1029 NVARCHAR VSTRING 20 0 20 InsuranceNo Insurance Number      
AMT1030 NUMERIC MONEY 28 8 20 InsuredAm Insured Amount      
AMT1031 NUMERIC MONEY 28 8 20 PurchPrice Purchase Price      
AMT1032 NUMERIC MONEY 28 8 20 RePurchPr Replacement Purchase Price      
AMT1033 NUMERIC MONEY 28 8 20 AccRepairs Accumulated Repairs      
AMT1034 NUMERIC MONEY 28 8 20 AccAddons Accumulated Add-ons      
AMT1035 DATETIME DATE 0 0 8 DatePurch Date Purchased      
AMT1036 DATETIME DATE 0 0 8 DateScrapped Date Scrapped      
AMT1037 NVARCHAR VSTRING 4 0 4 ScrSoldCode Disposal Code      
AMT1038 NVARCHAR VSTRING 6 0 6 IndexValue Index Value      
AMT1039 NCHAR STRING 4 0 4 LUpdDepr Last Depreciation Update Date      
AMT1040 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
AMT1041 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
AMT1042 NVARCHAR VSTRING 9 0 9 TransNumGL Transaction Number General Ledger      
AMT1043 NUMERIC MONEY 28 8 20 Spare (obsolete)      
AMT1044 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMT1045 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMT1046 NVARCHAR VSTRING 20 0 20 SerNum Serial Number      
AMT1047 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMT1048 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMT1049 NVARCHAR VSTRING 1 0 1 Capitalization Allowed Capitalization Allowed      
AMT1050 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
AMT1051 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
AMT1052 NUMERIC MONEY 28 8 20 Spare (obsolete)      
AMT1053 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMT1054 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMT1055 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMT1056 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMT1057 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
AMT1058 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
AMT1059 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
AMT1060 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
AMT1061 NVARCHAR VSTRING 30 0 30 InternRem1 Remark Line 1      
AMT1062 NVARCHAR VSTRING 30 0 30 InternRem2 Remark Line 2      
AMT1063 NVARCHAR VSTRING 5 0 5 InsuranCode Insurance Category      
AMT1064 NVARCHAR VSTRING 1 0 1 DocFlag Label Status      
AMT1065 NVARCHAR VSTRING 20 0 20 ServContract Service Contract      
AMT1066 NVARCHAR VSTRING 1 0 1 GenBudget Generate Budget      
AMT1067 NVARCHAR VSTRING 1 0 1 GenTrans Generate Transactions      
AMT1068 NVARCHAR VSTRING 15 0 15 UserDefDat1 User Defined Field 1      
AMT1069 NVARCHAR VSTRING 10 0 10 UserDefDat2 User Defined Field 2      
AMT1070 NVARCHAR VSTRING 10 0 10 UserDefDat3 User Defined Field 3      
AMT1071 NVARCHAR VSTRING 5 0 5 UserDefDat4 User Defined Field 4      
AMT1072 NVARCHAR VSTRING 1 0 1 DeprMetC [Calc] Depreciation Method      
AMT1073 NVARCHAR VSTRING 2 0 2 DeprPerC [Calc] Depreciation Period Years      
AMT1074 NVARCHAR VSTRING 6 0 6 DeprCalc [Calc] Depreciation %      
AMT1075 NUMERIC MONEY 28 8 20 DeprAmC [Calc] Depreciation Amount      
AMT1076 NUMERIC MONEY 28 8 20 DeprBaseC [Calc] Depreciation Base      
AMT1077 NUMERIC MONEY 28 8 20 ScrapValC [Calc] Scrap Value      
AMT1078 NUMERIC MONEY 28 8 20 AccDeprC [Calc] Accumulated Depreciations      
AMT1079 NUMERIC MONEY 28 8 20 DeprecC [Calc] Depreciations Current Year      
AMT1080 NUMERIC MONEY 28 8 20 ExtraDeprC [Calc] Extra Depreciations      
AMT1081 NVARCHAR VSTRING 6 0 6 IndexValueC [Calc] Index Value      
AMT1082 DATETIME DATE 0 0 8 DeprStrtDate Depreciation Start Date      
AMT1083 NVARCHAR VSTRING 1 0 1 NatSwitch1 National Switch 1      
AMT1084 NVARCHAR VSTRING 1 0 1 NatSwitch2 National Switch 2      
AMT1085 NVARCHAR VSTRING 1 0 1 NatSwitch3 National Switch 3      
AMT1086 DATETIME DATE 0 0 8 NationDate1 National Date 1      
AMT1087 DATETIME DATE 0 0 8 NationDate2 National Date 2      
AMT1088 DATETIME DATE 0 0 8 NationDate3 National Date 3      
AMT1089 NUMERIC MONEY 28 8 20 NatAmount1 National Amount 1      
AMT1090 NUMERIC MONEY 28 8 20 NatAmount2 National Amount 2      
AMT1091 NUMERIC MONEY 28 8 20 NatAmount3 National Amount 3      
AMT1092 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
AMT1093 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
AMT1094 NVARCHAR VSTRING 6 0 6 Deprec2Calc [Calc] Depreciation % 2      
AMT1095 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
AMT1096 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
AMT1097 NVARCHAR VSTRING 1 0 1 DprSwCal [Calc] Depreciation % Switch      
AMT1098 DATETIME DATE 0 0 8 DateBookEntry Book-Entry Date      
AMT1099 INT INTEGER 0 0 1 FlagLinkedtoStockCode Linked to Stock Item      
AMT1100 NVARCHAR VSTRING 12 0 12 BatchID Batch ID      
AMT1101 NVARCHAR VSTRING 6 0 6 WH Warehouse      
AMT1102 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code      
AMT1103 NVARCHAR VSTRING 12 0 12 BatchNumber Batch Number      
AMT1104 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
AMT1105 DATETIME DATE 0 0 8 DepreciationEndDate Depreciation End Date      
AMT1106 INT INTEGER 0 0 1 LockFlag Locked      
AMT1107 INT INTEGER 0 0 1 SummaryLevelFlag Summary Level      
AMT1108 NVARCHAR VSTRING 35 0 35 ReportingLevel1 Asset Code Reporting Level 1      
AMT1109 NVARCHAR VSTRING 35 0 35 ReportingLevel2 Asset Code Reporting Level 2      
AMT1110 NVARCHAR VSTRING 35 0 35 ReportingLevel3 Asset Code Reporting Level 3      
AMT1111 NVARCHAR VSTRING 35 0 35 ReportingLevel4 Asset Code Reporting Level 4      
AMT1112 NVARCHAR VSTRING 35 0 35 ReportingLevel5 Asset Code Reporting Level 5      
AMT1113 NVARCHAR VSTRING 4 0 4 LastUpdateDepreciationTax Last Update Depreciation Tax      
AMT1114 NUMERIC MONEY 28 8 20 ValueInConsolidationCurrency ValueInConsolidationCurrency      
AMT1115 NVARCHAR VSTRING 35 0 35 AlphaSearchKey Search Key for Description-sotring Upper(AMT1003)    
AMT1116 NVARCHAR VSTRING 6 0 6 LeaseGroupCode Lease Group Code      
AMT1117 NVARCHAR VSTRING 6 0 6 LeaseCategoryCode Lease Category Code      
AMT1118 NVARCHAR VSTRING 35 0 35 SupNameAddr4 Supplier Address Line 4      
AMT1119 NVARCHAR VSTRING 35 0 35 SupNameAddr5 Supplier Address Line 5      
AMT1120 NVARCHAR VSTRING 35 0 35 SupNameAddr6 Supplier Address Line 6      
AMT1121 NVARCHAR VSTRING 35 0 35 SupNameAddr7 Supplier Address Line 7      
AMT1122 NVARCHAR VSTRING 3 0 3 SupCountryCode Supplier Country Code      

Навигация: