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 AMT5 AMT5001 FixedAsset VSTRING 35 35 0 Asset Code
2 AMT5 AMT5002 TransCode VSTRING 10 10 0 Transaction Code
3 AMT5 AMT5003 CurrencyCode VSTRING 2 2 0 Currency Code Depreciation
AMT5 AMT5004 DepPlanPer1 MONEY 20 28 8 [Plan] Depreciation Period 1
AMT5 AMT5005 DeprTaxPer1 MONEY 20 28 8 [Tax] Depreciation Period 1
AMT5 AMT5006 DepPlanPer2 MONEY 20 28 8 [Plan] Depreciation Period 2
AMT5 AMT5007 DeprTaxPer2 MONEY 20 28 8 [Tax] Depreciation Period 2
AMT5 AMT5008 DepPlanPer3 MONEY 20 28 8 [Plan] Depreciation Period 3
AMT5 AMT5009 DeprTaxPer3 MONEY 20 28 8 [Tax] Depreciation Period 3
AMT5 AMT5010 DepPlanPer4 MONEY 20 28 8 [Plan] Depreciation Period 4
AMT5 AMT5011 DeprTaxPer4 MONEY 20 28 8 [Tax] Depreciation Period 4
AMT5 AMT5012 DepPlanPer5 MONEY 20 28 8 [Plan] Depreciation Period 5
AMT5 AMT5013 DeprTaxPer5 MONEY 20 28 8 [Tax] Depreciation Period 5
AMT5 AMT5014 DepPlanPer6 MONEY 20 28 8 [Plan] Depreciation Period 6
AMT5 AMT5015 DeprTaxPer6 MONEY 20 28 8 [Tax] Depreciation Period 6
AMT5 AMT5016 DepPlanPer7 MONEY 20 28 8 [Plan] Depreciation Period 7
AMT5 AMT5017 DeprTaxPer7 MONEY 20 28 8 [Tax] Depreciation Period 7
AMT5 AMT5018 DepPlanPer8 MONEY 20 28 8 [Plan] Depreciation Period 8
AMT5 AMT5019 DeprTaxPer8 MONEY 20 28 8 [Tax] Depreciation Period 8
AMT5 AMT5020 DepPlanPer9 MONEY 20 28 8 [Plan] Depreciation Period 9
AMT5 AMT5021 DeprTaxPer9 MONEY 20 28 8 [Tax] Depreciation Period 9
AMT5 AMT5022 DepPlanPer10 MONEY 20 28 8 [Plan] Depreciation Period 10
AMT5 AMT5023 DeprTaxPer10 MONEY 20 28 8 [Tax] Depreciation Period 10
AMT5 AMT5024 DepPlanPer11 MONEY 20 28 8 [Plan] Depreciation Period 11
AMT5 AMT5025 DeprTaxPer11 MONEY 20 28 8 [Tax] Depreciation Period 11
AMT5 AMT5026 DepPlanPer12 MONEY 20 28 8 [Plan] Depreciation Period 12
AMT5 AMT5027 DeprTaxPer12 MONEY 20 28 8 [Tax] Depreciation Period 12
AMT5 AMT5028 DepPlanPer13 MONEY 20 28 8 [Plan] Depreciation Period 13
AMT5 AMT5029 DeprTaxPer13 MONEY 20 28 8 [Tax] Depreciation Period 13
AMT5 AMT5030 DepPlanPer14 MONEY 20 28 8 [Plan] Depreciation Period 14
AMT5 AMT5031 DeprTaxPer14 MONEY 20 28 8 [Tax] Depreciation Period 14
AMT5 AMT5032 DepPlanPer15 MONEY 20 28 8 [Plan] Depreciation Period 15
AMT5 AMT5033 DeprTaxPer15 MONEY 20 28 8 [Tax] Depreciation Period 15
AMT5 AMT5034 DepPlanPer16 MONEY 20 28 8 [Plan] Depreciation Period 16
AMT5 AMT5035 DeprTaxPer16 MONEY 20 28 8 [Tax] Depreciation Period 16
AMT5 AMT5036 DepPlanPer17 MONEY 20 28 8 [Plan] Depreciation Period 17
AMT5 AMT5037 DeprTaxPer17 MONEY 20 28 8 [Tax] Depreciation Period 17
AMT5 AMT5038 DepPlanPer18 MONEY 20 28 8 [Plan] Depreciation Period 18
AMT5 AMT5039 DeprTaxPer18 MONEY 20 28 8 [Tax] Depreciation Period 18
AMT5 AMT5040 DepPlanPer19 MONEY 20 28 8 [Plan] Depreciation Period 19
AMT5 AMT5041 DeprTaxPer19 MONEY 20 28 8 [Tax] Depreciation Period 19
AMT5 AMT5042 DepPlanPer20 MONEY 20 28 8 [Plan] Depreciation Period 20
AMT5 AMT5043 DeprTaxPer20 MONEY 20 28 8 [Tax] Depreciation Period 20
AMT5 AMT5044 DepPlanPer21 MONEY 20 28 8 [Plan] Depreciation Period 21
AMT5 AMT5045 DeprTaxPer21 MONEY 20 28 8 [Tax] Depreciation Period 21
AMT5 AMT5046 DepPlanPer22 MONEY 20 28 8 [Plan] Depreciation Period 22
AMT5 AMT5047 DeprTaxPer22 MONEY 20 28 8 [Tax] Depreciation Period 22
AMT5 AMT5048 DepPlanPer23 MONEY 20 28 8 [Plan] Depreciation Period 23
AMT5 AMT5049 DeprTaxPer23 MONEY 20 28 8 [Tax] Depreciation Period 23
AMT5 AMT5050 DepPlanPer24 MONEY 20 28 8 [Plan] Depreciation Period 24
AMT5 AMT5051 DeprTaxPer24 MONEY 20 28 8 [Tax] Depreciation Period 24
AMT5 AMT5052 DepPlanPer25 MONEY 20 28 8 [Plan] Depreciation Period 25
AMT5 AMT5053 DeprTaxPer25 MONEY 20 28 8 [Tax] Depreciation Period 25