Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: AMH1 - «Spare». Маска имени таблицы: «AMH1%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
AMH1001 | NCHAR | STRING | 3 | 0 | 3 | Transaction Type | Transaction Type | 1 | Да | |
AMH1002 | DATETIME | DATE | 0 | 0 | 8 | Transaction Date | Transaction Date | 2 | Да | |
AMH1003 | NCHAR | STRING | 9 | 0 | 9 | Transaction Time | Transaction Time | 3 | Да | |
AMH1004 | NVARCHAR | VSTRING | 35 | 0 | 35 | Inventory code | Asset Code | 4 | Да | |
AMH1005 | NCHAR | STRING | 10 | 0 | 10 | Transaction Code | Transaction Code | 5 | Да | |
AMH1006 | NCHAR | STRING | 8 | 0 | 8 | UserID | User | 6 | Да | |
AMH1007 | NVARCHAR | VSTRING | 10 | 0 | 10 | Transaction Counter | 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 | Supplier_Name | 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 | 6 | 0 | 6 | TransactionNo_PCInvoice | 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 | 6 | 0 | 6 | TransactionNo_GL | 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 | Spare | (obsolete) | |||
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 | NVARCHAR | VSTRING | 20 | 0 | 20 | DeprBaseC | [Calc] Depreciation Base | |||
AMH1082 | NVARCHAR | VSTRING | 20 | 0 | 20 | ScrapValC | [Calc] Scrap Value | |||
AMH1083 | NVARCHAR | VSTRING | 20 | 0 | 20 | AccDeprC | [Calc] Accumulated Depreciations | |||
AMH1084 | NVARCHAR | VSTRING | 20 | 0 | 20 | DeprecC | [Calc] Depreciations Current Year | |||
AMH1085 | NVARCHAR | VSTRING | 20 | 0 | 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 | Flag_LinkedtoStockCode | 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 | Stock_Code | Stock Item Code | |||
AMH1108 | NVARCHAR | VSTRING | 12 | 0 | 12 | BatchNo_Original | Batch Number | |||
AMH1109 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address_Supplier_Line_4 | Supplier Address Line 4 | |||
AMH1110 | DATETIME | DATE | 0 | 0 | 8 | DepreciationEndDate | Depreciation End Date | |||
AMH1111 | INT | INTEGER | 0 | 0 | 1 | Lock Flag | Locked | |||
AMH1112 | INT | INTEGER | 0 | 0 | 1 | Summary Level Flag | Summary Level | |||
AMH1113 | NVARCHAR | VSTRING | 35 | 0 | 35 | Reporting Level 1 | Asset Code Reporting Level 1 | |||
AMH1114 | NVARCHAR | VSTRING | 35 | 0 | 35 | Reporting Level 2 | Asset Code Reporting Level 2 | |||
AMH1115 | NVARCHAR | VSTRING | 35 | 0 | 35 | Reporting Level 3 | Asset Code Reporting Level 3 | |||
AMH1116 | NVARCHAR | VSTRING | 35 | 0 | 35 | Reporting Level 4 | Asset Code Reporting Level 4 | |||
AMH1117 | NVARCHAR | VSTRING | 35 | 0 | 35 | Reporting Level 5 | Asset Code Reporting Level 5 | |||
AMH1118 | NVARCHAR | VSTRING | 4 | 0 | 4 | Last Update Depreciation Tax | Last Update Depreciation Tax | |||
AMH1119 | NUMERIC | MONEY | 28 | 8 | 20 | ValueInConsolidationCurrency | ValueInConsolidationCurrency | |||
AMH1120 | NVARCHAR | VSTRING | 35 | 0 | 35 | AlphaSearchKey | AlphaSearchKey |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Asset Management | Fixed Assets History