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 AMT6 AMT6001 InventCode VSTRING 35 35 0 Asset Code
2 AMT6 AMT6002 TransCode VSTRING 10 10 0 Transaction Code
3 AMT6 AMT6003 CurrencyCode VSTRING 2 2 0 Currency Code Depreciation
AMT6 AMT6004 DepMethodTax VSTRING 2 2 0 [Tax] Depreciation Method
AMT6 AMT6005 NLBalAccTax VSTRING 12 12 0 [Tax] Balance Account Over/Under Depreciations
AMT6 AMT6006 NLPLAccTax VSTRING 12 12 0 [Tax] P&L Account Over/Under Depreciations
AMT6 AMT6007 DepPerYrTax VSTRING 3 3 0 [Tax] Depreciation Period Years
AMT6 AMT6008 DeprTax VSTRING 6 6 0 [Tax] Depreciation %
AMT6 AMT6009 DeprAmTax MONEY 20 28 8 [Tax] Depreciation Amount
AMT6 AMT6010 DeprBaseTax MONEY 20 28 8 [Tax] Depreciation Base
AMT6 AMT6011 ResidualValueTAX MONEY 20 28 8 [Tax] Residual Value
AMT6 AMT6012 AccDeprTax MONEY 20 28 8 [Tax] Accumulated Depreciations
AMT6 AMT6013 DeprYearTax MONEY 20 28 8 [Tax] Depreciations Current Year
AMT6 AMT6014 ExtraDeprTax MONEY 20 28 8 [Tax] Extra Depreciations
AMT6 AMT6015 Depr2Tax VSTRING 6 6 0 [Tax] Depreciation % 2
AMT6 AMT6016 DeprSwTax VSTRING 1 1 0 [Tax] Depreciation Switch
AMT6 AMT6017 DepMethodPln VSTRING 2 2 0 [Plan] Depreciation Method
AMT6 AMT6018 NLBalAccPln VSTRING 12 12 0 [Plan] Balance Account Depreciations
AMT6 AMT6019 NLPLAccPln VSTRING 12 12 0 [Plan] P&L Account Depreciations
AMT6 AMT6020 DepPerYrPln VSTRING 3 3 0 [Plan] Depreciation Period Years
AMT6 AMT6021 DeprPln VSTRING 6 6 0 [Plan] Depreciation %
AMT6 AMT6022 DeprAmPln MONEY 20 28 8 [Plan] Depreciation Amount
AMT6 AMT6023 DeprBasePln MONEY 20 28 8 [Plan] Depreciation Base
AMT6 AMT6024 ResidualValuePLAN MONEY 20 28 8 [Plan] Residual Value
AMT6 AMT6025 AccDeprPln MONEY 20 28 8 [Plan] Accumulated Depreciations
AMT6 AMT6026 DeprYearPln MONEY 20 28 8 [Plan] Depreciations this year
AMT6 AMT6027 ExtraDeprPln MONEY 20 28 8 [Plan] Extra Depreciations
AMT6 AMT6028 Per1WoDepr VSTRING 2 2 0 [Plan] Period Without Depreciations 1
AMT6 AMT6029 Per2WoDepr VSTRING 2 2 0 [Plan] Period Without Depreciations 2
AMT6 AMT6030 Per3WoDepr VSTRING 2 2 0 [Plan] Period Without Depreciations 3
AMT6 AMT6031 Depr2Pln VSTRING 6 6 0 [Plan] Depreciation % 2
AMT6 AMT6032 DeprSwPln VSTRING 1 1 0 [Plan] Depreciation Switch
AMT6 AMT6033 PurchaseCost MONEY 20 28 8 Purchase Cost
AMT6 AMT6034 DailyDeprPln VSTRING 1 1 0 [Plan] Depreciate on Daily Basis
AMT6 AMT6035 DailyDeprTax VSTRING 1 1 0 [Tax] Depreciate on Daily Basis
AMT6 AMT6036 Dummy VSTRING 1 1 0 (obsolete)
AMT6 AMT6037 DepPerUnitTx STRING 1 1 0 [Tax] Depreciation Period Unit
AMT6 AMT6038 DepPerUnitPn STRING 1 1 0 [Plan] Depreciation Period Unit
AMT6 AMT6039 SalesRevenue MONEY 20 28 8 Sales Revenue
AMT6 AMT6040 YearReducDeprTax INTEGER 1 0 0 [Tax] Yearly Reducing Depreciation
AMT6 AMT6041 DeprStartTax DATE 8 0 0 [Tax] Depreciation Start Date
AMT6 AMT6042 YearReducDeprPlan INTEGER 1 0 0 [Plan] Yearly Reducing Depreciation
AMT6 AMT6043 DeprStartPlan DATE 8 0 0 [Plan] Depreciation Start Date
AMT6 AMT6044 Spare VSTRING 1 1 0 (obsolete)
AMT6 AMT6045 Spare VSTRING 1 1 0 (obsolete)
AMT6 AMT6046 Spare VSTRING 35 35 0 (obsolete)
AMT6 AMT6047 Spare VSTRING 35 35 0 (obsolete)
AMT6 AMT6048 Spare VSTRING 35 35 0 (obsolete)
AMT6 AMT6049 Spare VSTRING 35 35 0 (obsolete)
AMT6 AMT6050 Spare VSTRING 35 35 0 (obsolete)
AMT6 AMT6051 AccCodePUR VSTRING 2 2 0 [PUR] Accounting Code Purchase Transactions
AMT6 AMT6052 AccCodeTAX VSTRING 2 2 0 [TAX] Accounting Code Tax Depreciation Transactions
AMT6 AMT6053 AccCodePLA VSTRING 2 2 0 [PLA] Accounting Code Plan Depreciation Transactions
AMT6 AMT6054 AccCodeSAL VSTRING 2 2 0 [SAL] Accounting Code Sales Transactions
AMT6 AMT6055 AccCodeSCR VSTRING 2 2 0 [SCR] Accounting Code Scrap Transactions
AMT6 AMT6056 AccCodeREV VSTRING 2 2 0 [REV] Accounting Code Revaluation Transactions
AMT6 AMT6057 AccCodeETX VSTRING 2 2 0 [ETX] Accounting Code Extra Tax Transactions
AMT6 AMT6058 AccCodeFUS VSTRING 2 2 0 [FUS] Accounting Code Fusion Transactions
AMT6 AMT6059 AccCodeICT VSTRING 2 2 0 [ICT] Accounting Code IC Transfer Transactions
AMT6 AMT6060 AccCodePLP VSTRING 2 2 0 [PLP] Accounting Code Purchasing from PL
AMT6 AMT6061 AccCodeACT VSTRING 2 2 0 [ACT] Accounting Code Activation from SM
AMT6 AMT6062 AccCodeRE1 VSTRING 2 2 0 [OLD] Accounting Code Take Over from Old System
AMT6 AMT6063 AccCodeRE2 VSTRING 2 2 0 [TRA] Accounting Code Transfer
AMT6 AMT6064 AccCodeRE3 VSTRING 2 2 0 [RES] Accounting Code spare 3
AMT6 AMT6065 AccCodeRE4 VSTRING 2 2 0 [RES] Accounting Code spare 4
AMT6 AMT6066 AccCodeRE5 VSTRING 2 2 0 [RES] Accounting Code spare 5
AMT6 AMT6067 AccCodeRE6 VSTRING 2 2 0 [RES] Accounting Code spare 6
AMT6 AMT6068 AccCodeRE7 VSTRING 2 2 0 [RES] Accounting Code spare 7
AMT6 AMT6069 AccountingCodeSFA VSTRING 2 2 0 [SFA] Accounting Code Transfer from Stock
AMT6 AMT6070 AccountingCodeSTO VSTRING 2 2 0 [STO] Accounting Code Return to Stock
AMT6 AMT6071 AccountingCodeREA VSTRING 2 2 0 [REA] Accounting Code Automatic Revaluation
AMT6 AMT6072 AccCodeRE11 VSTRING 2 2 0 [RES] Accounting Code spare 11
AMT6 AMT6073 AccCodeRE12 VSTRING 2 2 0 [RES] Accounting Code spare 12
AMT6 AMT6074 AccountingCodePRC VSTRING 2 2 0 [PRC] Accounting Code Project Capitalization
AMT6 AMT6075 AccCodeRE14 VSTRING 2 2 0 [RES] Accounting Code spare 14
AMT6 AMT6076 AccCodeRE15 VSTRING 2 2 0 [RES] Accounting Code spare 15
AMT6 AMT6077 AccCodeRE16 VSTRING 2 2 0 [RES] Accounting Code spare 16
AMT6 AMT6078 AccCodeRE17 VSTRING 2 2 0 [RES] Accounting Code spare 17
AMT6 AMT6079 AccCodeRE18 VSTRING 2 2 0 [RES] Accounting Code spare 18
AMT6 AMT6080 AccCodeRE19 VSTRING 2 2 0 [RES] Accounting Code spare 19
AMT6 AMT6081 AccCodeRE20 VSTRING 2 2 0 [RES] Accounting Code spare 20
AMT6 AMT6082 ScrapValueBooked MONEY 20 28 8 Scrap Value Booked
AMT6 AMT6083 AccelFactorPlan X_NUMERIC 12 20 8 Acceleration Factor (Plan)
AMT6 AMT6084 AccelFactorTax X_NUMERIC 12 20 8 Acceleration Factor (Tax)
AMT6 AMT6085 DeprNextYearPlan MONEY 20 28 8 Depreciations during next year (Plan)
AMT6 AMT6086 DeprNextYearTax MONEY 20 28 8 Depreciation during next year (Tax)
AMT6 AMT6087 FixDepreciationsTillPeriod INTEGER 2 0 0 Fix depreciations till period