Apicosoft

ERP iScala Database Structure
iScala Supprort & Customization

Business processes implementation, ad-hock services, end-users training and education, maintenance support.

Read More Contact Us
Epicor Service Connect

Integration with any third-party services. Customize internal workflows.

Read More Contact Us
Reporting

SAP Crystal Reports, SQL Server Reporting Services, Excel.

Read More Contact Us
Tables
Name Description Dependences Example
AM31 Asset Master Table Company AM310100
AM32 Asset Master Templates Company AM320100
AM33 Fixed Asset Parameters Company AM330100
AM34 WrkDepreciation AM340000
AM35 Depreciations Current Year Company Year AM350112
AM36 Depreciations per Currency Company AM360100
AM37 Depreciations per Currency Templates Company AM370100
AMFA FA Automatic Accounting Schedule Company Year AMFA0112
AMFR FA Revaluation Work Company Year AMFR0112
AMH1 Fixed Assets History Company AMH10100
AMH6 Depreciation per Currency History Company AMH60100
AMPR FA Revaluation Parameters Company Year AMPR0112
AMR1 Spare Company Year AMR10112
AMT1 Fixed Asset Transactions Company AMT10100
AMT5 Year Depreciation Transactions Company Year AMT50112
AMT6 Depreciations per Currency Transactions Company AMT60100
AMTP Fixed Asset Profiles Company AMTP0100

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