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 AM36 AM36001 InventoryCode VSTRING 35 35 0 Asset Code
2 AM36 AM36002 CurrencyCode VSTRING 2 2 0 Currency Code Depreciation
AM36 AM36003 DepMethodTax VSTRING 2 2 0 [Tax] Depreciation Method Depreciation methods:
0 - No depreciation.
1 - As percentage of the depreciation basis (Straight Line).
2 - As percentage of the balance (Reducing Balance)
3 - Fixed Amount per Financial Year.
4 - Sum for the Year (SOY.
5 - Proportional Depreciation
6 - The method is designed for Assets with the economic life more than a year.
7 - Double Declining
8 - As percentage of the depreciation basis (Straight Line).
9 - The assets are depreciated by 50% at acquisition and 50% when the Asset is no longer used.
10 - Percentage of the remaining amount.
11 - The depreciation amount is calculated as a product of the residual value of the Asset and the rate of depreciation determined for the given asset.
AM36 AM36004 NLBalAccTax VSTRING 12 12 0 [Tax] Balance Account Over/Under Depreciations
AM36 AM36005 NLPLAccTax VSTRING 12 12 0 [Tax] P&L Account Over/Under Depreciations
AM36 AM36006 DepPerYrTax VSTRING 3 3 0 [Tax] Depreciation Periods/Years
AM36 AM36007 DeprTax VSTRING 6 6 0 [Tax] Depreciation %
AM36 AM36008 DeprAmTax MONEY 20 28 8 [Tax] Depreciation Amount
AM36 AM36009 DeprBaseTax MONEY 20 28 8 [Tax] Depreciation Base
AM36 AM36010 ResidualValueTAX MONEY 20 28 8 [Tax] Residual Value
AM36 AM36011 AccDeprTax MONEY 20 28 8 [Tax] Accumulated Depreciations
AM36 AM36012 DeprYearTax MONEY 20 28 8 [Tax] Depreciations Current Year
AM36 AM36013 ExtraDeprTax MONEY 20 28 8 [Tax] Extra Depreciations
AM36 AM36014 Depr2Tax VSTRING 6 6 0 [Tax] Depreciation % 2
AM36 AM36015 DeprSwTax VSTRING 1 1 0 [Tax] Depreciation Switch
AM36 AM36016 DepMethodPln VSTRING 2 2 0 [Plan] Depreciation Method Depreciation methods:
0 - No depreciation.
1 - As percentage of the depreciation basis (Straight Line).
2 - As percentage of the balance (Reducing Balance)
3 - Fixed Amount per Financial Year.
4 - Sum for the Year (SOY.
5 - Proportional Depreciation
6 - The method is designed for Assets with the economic life more than a year.
7 - Double Declining
8 - As percentage of the depreciation basis (Straight Line).
9 - The assets are depreciated by 50% at acquisition and 50% when the Asset is no longer used.
10 - Percentage of the remaining amount.
11 - The depreciation amount is calculated as a product of the residual value of the Asset and the rate of depreciation determined for the given asset.
AM36 AM36017 NLBalAccPln VSTRING 12 12 0 [Plan] Balance Account Depreciations
AM36 AM36018 NLPLAccPln VSTRING 12 12 0 [Plan] P&L Account Depreciations
AM36 AM36019 DepPerYrPln VSTRING 3 3 0 [Plan] Depreciation Periods/Years
AM36 AM36020 DeprPln VSTRING 6 6 0 [Plan] Depreciation %
AM36 AM36021 DeprAmPln MONEY 20 28 8 [Plan] Depreciation Amount
AM36 AM36022 DeprBasePln MONEY 20 28 8 [Plan] Depreciation Base Depreciation methods:
0 - No depreciation.
1 - As percentage of the depreciation basis (Straight Line).
2 - As percentage of the balance (Reducing Balance)
3 - Fixed Amount per Financial Year.
4 - Sum for the Year (SOY.
5 - Proportional Depreciation
6 - The method is designed for Assets with the economic life more than a year.
7 - Double Declining
8 - As percentage of the depreciation basis (Straight Line).
9 - The assets are depreciated by 50% at acquisition and 50% when the Asset is no longer used.
10 - Percentage of the remaining amount.
11 - The depreciation amount is calculated as a product of the residual value of the Asset and the rate of depreciation determined for the given asset.
AM36 AM36023 ResidualValuePLAN MONEY 20 28 8 [Plan] Residual Value
AM36 AM36024 AccDeprPln MONEY 20 28 8 [Plan] Accumulated Depreciations
AM36 AM36025 DeprYearPln MONEY 20 28 8 [Plan] Depreciations this year
AM36 AM36026 ExtraDeprPln MONEY 20 28 8 [Plan] Extra Depreciations
AM36 AM36027 Per1WoDepr VSTRING 2 2 0 [Plan] Period Without Depreciations 1
AM36 AM36028 Per2WoDepr VSTRING 2 2 0 [Plan] Period Without Depreciations 2
AM36 AM36029 Per3WoDepr VSTRING 2 2 0 [Plan] Period Without Depreciations 3
AM36 AM36030 Depr2Pln VSTRING 6 6 0 [Plan] Depreciation % 2
AM36 AM36031 DeprSwPln VSTRING 1 1 0 [Plan] Depreciation Switch
AM36 AM36032 PurchaseCost MONEY 20 28 8 Purchase Cost
AM36 AM36033 DailyDeprPln VSTRING 1 1 0 [Plan] Depreciate on Daily Basis
AM36 AM36034 DailyDeprTax VSTRING 1 1 0 [Tax] Depreciate on Daily Basis
AM36 AM36035 Dummy VSTRING 1 1 0 (obsolete)
AM36 AM36036 DepPerUnitTx STRING 1 1 0 [Tax] Depreciation Period Unit
AM36 AM36037 DepPerUnitPn STRING 1 1 0 [Plan] Depreciation Period Unit
AM36 AM36038 SalesRevenue MONEY 20 28 8 Sales Revenue
AM36 AM36039 YearReducDeprTax INTEGER 1 0 0 [Tax] Yearly Reducing Depreciation
AM36 AM36040 DeprStartTax DATE 8 0 0 [Tax] Depreciation Start Date
AM36 AM36041 YearReducDeprPlan INTEGER 1 0 0 [Plan] Yearly Reducing Depreciation
AM36 AM36042 DeprStartPlan DATE 8 0 0 [Plan] Depreciation Start Date
AM36 AM36043 Spare STRING 1 1 0 (obsolete)
AM36 AM36044 Spare STRING 1 1 0 (obsolete)
AM36 AM36045 Spare VSTRING 35 35 0 (obsolete)
AM36 AM36046 Spare VSTRING 35 35 0 (obsolete)
AM36 AM36047 Spare VSTRING 35 35 0 (obsolete)
AM36 AM36048 Spare VSTRING 35 35 0 (obsolete)
AM36 AM36049 Spare VSTRING 35 35 0 (obsolete)
AM36 AM36050 AccountingCodePUR STRING 2 2 0 [PUR] Accounting Code Purchase Transactions
AM36 AM36051 AccountingCodeTAX STRING 2 2 0 [TAX] Accounting Code Tax Depreciation Transactions
AM36 AM36052 AccountingCodePLA STRING 2 2 0 [PLA] Accounting Code Plan Depreciation Transactions
AM36 AM36053 AccountingCodeSAL STRING 2 2 0 [SAL] Accounting Code Sales Transactions
AM36 AM36054 AccountingCodeSCR STRING 2 2 0 [SCR] Accounting Code Scrap Transactions
AM36 AM36055 AccountingCodeREV STRING 2 2 0 [REV] Accounting Code Revaluation Transactions
AM36 AM36056 AccountingCodeETX STRING 2 2 0 [ETX] Accounting Code Extra Tax Transactions
AM36 AM36057 AccountingCodeFUS STRING 2 2 0 [FUS] Accounting Code Fusion Transactions
AM36 AM36058 AccountingCodeICT STRING 2 2 0 [ICT] Accounting Code IC Transfer Transactions
AM36 AM36059 AccountingCodePLP STRING 2 2 0 [PLP] Accounting Code Purchasing from PL
AM36 AM36060 AccountingCodeACT STRING 2 2 0 [ACT] Accounting Code Activation from SM
AM36 AM36061 AccountingCodeOLD STRING 2 2 0 [OLD] Accounting Code Take Over from Old System
AM36 AM36062 AccountingCodeTRA STRING 2 2 0 [TRA] Accounting Code Transfer
AM36 AM36063 AccountingCodeRES3 STRING 2 2 0 [RES] Accounting Code spare 3
AM36 AM36064 AccountingCodeRES4 STRING 2 2 0 [RES] Accounting Code spare 4
AM36 AM36065 AccountingCodeRES5 STRING 2 2 0 [RES] Accounting Code spare 5
AM36 AM36066 AccountingCodeRES6 STRING 2 2 0 [RES] Accounting Code spare 6
AM36 AM36067 AccountingCodeRES7 STRING 2 2 0 [RES] Accounting Code spare 7
AM36 AM36068 AccountingCodeSFA STRING 2 2 0 [SFA] Accounting Code Transfer from Stock
AM36 AM36069 AccountingCodeSTO STRING 2 2 0 [STO] Accounting Code Return to Stock
AM36 AM36070 AccountingCodeREA STRING 2 2 0 [REA] Accounting Code Automatic Revaluation
AM36 AM36071 AccountingCodeRES11 STRING 2 2 0 [RES] Accounting Code spare 11
AM36 AM36072 AccountingCodeRES12 STRING 2 2 0 [RES] Accounting Code spare 12
AM36 AM36073 AccountingCodePRC STRING 2 2 0 [PRC] Accounting Code Project Capitalization
AM36 AM36074 AccountingCodeRES14 STRING 2 2 0 [RES] Accounting Code spare 14
AM36 AM36075 AccountingCodeRES15 STRING 2 2 0 [RES] Accounting Code spare 15
AM36 AM36076 AccountingCodeRES16 STRING 2 2 0 [RES] Accounting Code spare 16
AM36 AM36077 AccountingCodeRES17 STRING 2 2 0 [RES] Accounting Code spare 17
AM36 AM36078 AccountingCodeRES18 STRING 2 2 0 [RES] Accounting Code spare 18
AM36 AM36079 AccountingCodeRES19 STRING 2 2 0 [RES] Accounting Code spare 19
AM36 AM36080 AccountingCodeRES20 STRING 2 2 0 [RES] Accounting Code spare 20
AM36 AM36081 ScrapValueBooked MONEY 20 28 8 Scrap Value Booked
AM36 AM36082 AccelFactorPlan X_NUMERIC 12 20 8 Acceleration Factor (Plan)
AM36 AM36083 AccelFactorTax X_NUMERIC 12 20 8 Acceleration Factor (Tax)
AM36 AM36084 DeprNextYearPlan MONEY 20 28 8 Depreciations during next year (Plan)
AM36 AM36085 DeprNextYearTax MONEY 20 28 8 Depreciation during next year (Tax)
AM36 AM36086 FixDepreciationsTillPeriod INTEGER 2 0 0 Fix depreciations till period