пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

Таблица: 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 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 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      
AMH1121 NVARCHAR VSTRING 6 0 6 Lease Group Code Lease Group Code      
AMH1122 NVARCHAR VSTRING 6 0 6 Lease Category Code Lease Category Code      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Asset Management | Fixed Assets History

TopList

© Алексей Васильев. 2004-2019. При использовании материалов ссылка обязательна.