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 AM35 AM35001 FixedAsset VSTRING 35 35 0 Asset Code
2 AM35 AM35002 CurrencyCode VSTRING 2 2 0 Currency Code Depreciation
AM35 AM35003 DepPlanPer1 MONEY 20 28 8 [Plan] Depreciation Period 1
AM35 AM35004 DeprTaxPer1 MONEY 20 28 8 [Tax] Depreciation Period 1
AM35 AM35005 DepPlanPer2 MONEY 20 28 8 [Plan] Depreciation Period 2
AM35 AM35006 DeprTaxPer2 MONEY 20 28 8 [Tax] Depreciation Period 2
AM35 AM35007 DepPlanPer3 MONEY 20 28 8 [Plan] Depreciation Period 3
AM35 AM35008 DeprTaxPer3 MONEY 20 28 8 [Tax] Depreciation Period 3
AM35 AM35009 DepPlanPer4 MONEY 20 28 8 [Plan] Depreciation Period 4
AM35 AM35010 DeprTaxPer4 MONEY 20 28 8 [Tax] Depreciation Period 4
AM35 AM35011 DepPlanPer5 MONEY 20 28 8 [Plan] Depreciation Period 5
AM35 AM35012 DeprTaxPer5 MONEY 20 28 8 [Tax] Depreciation Period 5
AM35 AM35013 DepPlanPer6 MONEY 20 28 8 [Plan] Depreciation Period 6
AM35 AM35014 DeprTaxPer6 MONEY 20 28 8 [Tax] Depreciation Period 6
AM35 AM35015 DepPlanPer7 MONEY 20 28 8 [Plan] Depreciation Period 7
AM35 AM35016 DeprTaxPer7 MONEY 20 28 8 [Tax] Depreciation Period 7
AM35 AM35017 DepPlanPer8 MONEY 20 28 8 [Plan] Depreciation Period 8
AM35 AM35018 DeprTaxPer8 MONEY 20 28 8 [Tax] Depreciation Period 8
AM35 AM35019 DepPlanPer9 MONEY 20 28 8 [Plan] Depreciation Period 9
AM35 AM35020 DeprTaxPer9 MONEY 20 28 8 [Tax] Depreciation Period 9
AM35 AM35021 DepPlanPer10 MONEY 20 28 8 [Plan] Depreciation Period 10
AM35 AM35022 DeprTaxPer10 MONEY 20 28 8 [Tax] Depreciation Period 10
AM35 AM35023 DepPlanPer11 MONEY 20 28 8 [Plan] Depreciation Period 11
AM35 AM35024 DeprTaxPer11 MONEY 20 28 8 [Tax] Depreciation Period 11
AM35 AM35025 DepPlanPer12 MONEY 20 28 8 [Plan] Depreciation Period 12
AM35 AM35026 DeprTaxPer12 MONEY 20 28 8 [Tax] Depreciation Period 12
AM35 AM35027 DepPlanPer13 MONEY 20 28 8 [Plan] Depreciation Period 13
AM35 AM35028 DeprTaxPer13 MONEY 20 28 8 [Tax] Depreciation Period 13
AM35 AM35029 DepPlanPer14 MONEY 20 28 8 [Plan] Depreciation Period 14
AM35 AM35030 DeprTaxPer14 MONEY 20 28 8 [Tax] Depreciation Period 14
AM35 AM35031 DepPlanPer15 MONEY 20 28 8 [Plan] Depreciation Period 15
AM35 AM35032 DeprTaxPer15 MONEY 20 28 8 [Tax] Depreciation Period 15
AM35 AM35033 DepPlanPer16 MONEY 20 28 8 [Plan] Depreciation Period 16
AM35 AM35034 DeprTaxPer16 MONEY 20 28 8 [Tax] Depreciation Period 16
AM35 AM35035 DepPlanPer17 MONEY 20 28 8 [Plan] Depreciation Period 17
AM35 AM35036 DeprTaxPer17 MONEY 20 28 8 [Tax] Depreciation Period 17
AM35 AM35037 DepPlanPer18 MONEY 20 28 8 [Plan] Depreciation Period 18
AM35 AM35038 DeprTaxPer18 MONEY 20 28 8 [Tax] Depreciation Period 18
AM35 AM35039 DepPlanPer19 MONEY 20 28 8 [Plan] Depreciation Period 19
AM35 AM35040 DeprTaxPer19 MONEY 20 28 8 [Tax] Depreciation Period 19
AM35 AM35041 DepPlanPer20 MONEY 20 28 8 [Plan] Depreciation Period 20
AM35 AM35042 DeprTaxPer20 MONEY 20 28 8 [Tax] Depreciation Period 20
AM35 AM35043 DepPlanPer21 MONEY 20 28 8 [Plan] Depreciation Period 21
AM35 AM35044 DeprTaxPer21 MONEY 20 28 8 [Tax] Depreciation Period 21
AM35 AM35045 DepPlanPer22 MONEY 20 28 8 [Plan] Depreciation Period 22
AM35 AM35046 DeprTaxPer22 MONEY 20 28 8 [Tax] Depreciation Period 22
AM35 AM35047 DepPlanPer23 MONEY 20 28 8 [Plan] Depreciation Period 23
AM35 AM35048 DeprTaxPer23 MONEY 20 28 8 [Tax] Depreciation Period 23
AM35 AM35049 DepPlanPer24 MONEY 20 28 8 [Plan] Depreciation Period 24
AM35 AM35050 DeprTaxPer24 MONEY 20 28 8 [Tax] Depreciation Period 24
AM35 AM35051 DepPlanPer25 MONEY 20 28 8 [Plan] Depreciation Period 25
AM35 AM35052 DeprTaxPer25 MONEY 20 28 8 [Tax] Depreciation Period 25