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 AMH6 AMH6001 TransactionType STRING 3 3 0 Transaction Type
2 AMH6 AMH6002 TransactionDate DATE 8 0 0 Transaction Date
3 AMH6 AMH6003 TransactionTime STRING 9 9 0 Transaction Time
4 AMH6 AMH6004 InventoryCode VSTRING 35 35 0 Asset Code
5 AMH6 AMH6005 TransactionCode STRING 10 10 0 Transaction Code
6 AMH6 AMH6006 UserID STRING 8 8 0 User ID
7 AMH6 AMH6007 TransactionCounter INTEGER 10 0 0 Transaction Number
8 AMH6 AMH6008 CurrCode STRING 2 2 0 Currency Code Depreciation
AMH6 AMH6009 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.
AMH6 AMH6010 NLBalAccTax VSTRING 12 12 0 [Tax] Balance Account Over/Under Depreciations
AMH6 AMH6011 NLPLAccTax VSTRING 12 12 0 [Tax] P&L Account Over/Under Depreciations
AMH6 AMH6012 DepPerYrTax VSTRING 3 3 0 [Tax] Depreciation Periods/Years
AMH6 AMH6013 DeprTax VSTRING 6 6 0 [Tax] Depreciation %
AMH6 AMH6014 DeprAmTax MONEY 20 28 8 [Tax] Depreciation Amount
AMH6 AMH6015 DeprBaseTax MONEY 20 28 8 [Tax] Depreciation Base
AMH6 AMH6016 ResidualValueTAX MONEY 20 28 8 [Tax] Residual Value
AMH6 AMH6017 AccDeprTax MONEY 20 28 8 [Tax] Accumulated Depreciations
AMH6 AMH6018 DeprYearTax MONEY 20 28 8 [Tax] Depreciations Current Year
AMH6 AMH6019 ExtraDeprTax MONEY 20 28 8 [Tax] Extra Depreciations
AMH6 AMH6020 Depr2Tax VSTRING 6 6 0 [Tax] Depreciation % 2
AMH6 AMH6021 DeprSwTax VSTRING 1 1 0 [Tax] Depreciation Switch
AMH6 AMH6022 DepMethodPln VSTRING 2 2 0 [Plan] Depreciation Method
AMH6 AMH6023 NLBalAccPln VSTRING 12 12 0 [Plan] Balance Account Depreciations
AMH6 AMH6024 NLPLAccPln VSTRING 12 12 0 [Plan] P&L Account Depreciations
AMH6 AMH6025 DepPerYrPln VSTRING 3 3 0 [Plan] Depreciation Periods/Years
AMH6 AMH6026 DeprPln VSTRING 6 6 0 [Plan] Depreciation %
AMH6 AMH6027 DeprAmPln MONEY 20 28 8 [Plan] Depreciation Amount
AMH6 AMH6028 DeprBasePln MONEY 20 28 8 [Plan] Depreciation Base
AMH6 AMH6029 ResidualValuePLAN MONEY 20 28 8 [Plan] Residual Value
AMH6 AMH6030 AccDeprPln MONEY 20 28 8 [Plan] Accumulated Depreciations
AMH6 AMH6031 DeprYearPln MONEY 20 28 8 [Plan] Depreciations this year
AMH6 AMH6032 ExtraDeprPln MONEY 20 28 8 [Plan] Extra Depreciations
AMH6 AMH6033 Per1WoDepr VSTRING 2 2 0 [Plan] Period Without Depreciations 1
AMH6 AMH6034 Per2WoDepr VSTRING 2 2 0 [Plan] Period Without Depreciations 2
AMH6 AMH6035 Per3WoDepr VSTRING 2 2 0 [Plan] Period Without Depreciations 3
AMH6 AMH6036 Depr2Pln VSTRING 6 6 0 [Plan] Depreciation % 2
AMH6 AMH6037 DeprSwPln VSTRING 1 1 0 [Plan] Depreciation Switch
AMH6 AMH6038 PurchaseCost MONEY 20 28 8 Purchase Cost
AMH6 AMH6039 DailyDeprPln VSTRING 1 1 0 [Plan] Depreciate on Daily Basis
AMH6 AMH6040 DailyDeprTax VSTRING 1 1 0 [Tax] Depreciate on Daily Basis
AMH6 AMH6041 Dummy VSTRING 1 1 0 (obsolete)
AMH6 AMH6042 DepPerUnitTx STRING 1 1 0 [Tax] Depreciation Period Unit
AMH6 AMH6043 DepPerUnitPn STRING 1 1 0 [Plan] Depreciation Period Unit
AMH6 AMH6044 SalesRevenue MONEY 20 28 8 Sales Revenue
AMH6 AMH6045 YearReducDeprTax INTEGER 1 0 0 [Tax] Yearly Reducing Depreciation
AMH6 AMH6046 DeprStartTax DATE 8 0 0 [Tax] Depreciation Start Date
AMH6 AMH6047 YearReducDeprPlan INTEGER 1 0 0 [Plan] Yearly Reducing Depreciation
AMH6 AMH6048 DeprStartPlan DATE 8 0 0 [Plan] Depreciation Start Date
AMH6 AMH6049 Spare STRING 1 1 0 (obsolete)
AMH6 AMH6050 Spare STRING 1 1 0 (obsolete)
AMH6 AMH6051 Spare VSTRING 35 35 0 (obsolete)
AMH6 AMH6052 Spare VSTRING 35 35 0 (obsolete)
AMH6 AMH6053 Spare VSTRING 35 35 0 (obsolete)
AMH6 AMH6054 Spare VSTRING 35 35 0 (obsolete)
AMH6 AMH6055 Spare VSTRING 35 35 0 (obsolete)
AMH6 AMH6056 AccountingCodePUR STRING 2 2 0 [PUR] Accounting Code Purchase Transactions
AMH6 AMH6057 AccountingCodeTAX STRING 2 2 0 [TAX] Accounting Code Tax Depreciation Transactions
AMH6 AMH6058 AccountingCodePLA STRING 2 2 0 [PLA] Accounting Code Plan Depreciation Transactions
AMH6 AMH6059 AccountingCodeSAL STRING 2 2 0 [SAL] Accounting Code Sales Transactions
AMH6 AMH6060 AccountingCodeSCR STRING 2 2 0 [SCR] Accounting Code Scrap Transactions
AMH6 AMH6061 AccountingCodeREV STRING 2 2 0 [REV] Accounting Code Revaluation Transactions
AMH6 AMH6062 AccountingCodeETX STRING 2 2 0 [ETX] Accounting Code Extra Tax Transactions
AMH6 AMH6063 AccountingCodeFUS STRING 2 2 0 [FUS] Accounting Code Fusion Transactions
AMH6 AMH6064 AccountingCodeICT STRING 2 2 0 [ICT] Accounting Code IC Transfer Transactions
AMH6 AMH6065 AccountingCodePLP STRING 2 2 0 [PLP] Accounting Code Purchasing from PL
AMH6 AMH6066 AccountingCodeACT STRING 2 2 0 [ACT] Accounting Code Activation from SM
AMH6 AMH6067 AccountingCodeOLD STRING 2 2 0 [OLD] Accounting Code Take Over from Old System
AMH6 AMH6068 AccountingCodeTRA STRING 2 2 0 [TRA] Accounting Code Transfer
AMH6 AMH6069 AccountingCodeRES3 STRING 2 2 0 [RES] Accounting Code spare 3
AMH6 AMH6070 AccountingCodeRES4 STRING 2 2 0 [RES] Accounting Code spare 4
AMH6 AMH6071 AccountingCodeRES5 STRING 2 2 0 [RES] Accounting Code spare 5
AMH6 AMH6072 AccountingCodeRES6 STRING 2 2 0 [RES] Accounting Code spare 6
AMH6 AMH6073 AccountingCodeRES7 STRING 2 2 0 [RES] Accounting Code spare 7
AMH6 AMH6074 AccountingCodeSFA STRING 2 2 0 [SFA] Accounting Code Transfer from Stock
AMH6 AMH6075 AccountingCodeSTO STRING 2 2 0 [STO] Accounting Code Return to Stock
AMH6 AMH6076 AccountingCodeREA STRING 2 2 0 [REA] Accounting Code Automatic Revaluation
AMH6 AMH6077 AccountingCodeRES11 STRING 2 2 0 [RES] Accounting Code spare 11
AMH6 AMH6078 AccountingCodeRES12 STRING 2 2 0 [RES] Accounting Code spare 12
AMH6 AMH6079 AccountingCodePRC STRING 2 2 0 [PRC] Accounting Code Project Capitalization
AMH6 AMH6080 AccountingCodeRES14 STRING 2 2 0 [RES] Accounting Code spare 14
AMH6 AMH6081 AccountingCodeRES15 STRING 2 2 0 [RES] Accounting Code spare 15
AMH6 AMH6082 AccountingCodeRES16 STRING 2 2 0 [RES] Accounting Code spare 16
AMH6 AMH6083 AccountingCodeRES17 STRING 2 2 0 [RES] Accounting Code spare 17
AMH6 AMH6084 AccountingCodeRES18 STRING 2 2 0 [RES] Accounting Code spare 18
AMH6 AMH6085 AccountingCodeRES19 STRING 2 2 0 [RES] Accounting Code spare 19
AMH6 AMH6086 AccountingCodeRES20 STRING 2 2 0 [RES] Accounting Code spare 20
AMH6 AMH6087 ScrapValueBooked MONEY 20 28 8 Scrap Value Booked
AMH6 AMH6088 AccelFactorPlan X_NUMERIC 12 20 8 Acceleration Factor (Plan)
AMH6 AMH6089 AccelFactorTax X_NUMERIC 12 20 8 Acceleration Factor (Tax)
AMH6 AMH6090 DeprNextYearPlan MONEY 20 28 8 Depreciation during next year (Plan)
AMH6 AMH6091 DeprNextYearTax MONEY 20 28 8 Depreciation during next year (Tax)
AMH6 AMH6092 FixDepreciationsTillPeriod INTEGER 2 0 0 Fix depreciations till period