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 AMR1 AMR1001 InventoryCode STRING 35 35 0 InventoryCode
2 AMR1 AMR1002 TransactionCode STRING 10 10 0 TransactionCode
3 AMR1 AMR1003 SubperiodNo VSTRING 1 1 0 SubperiodNo
AMR1 AMR1004 GroupOfReval VSTRING 2 2 0 GroupOfReval
AMR1 AMR1005 PurchaseDate DATE 8 0 0 PurchaseDate
AMR1 AMR1006 DeprAmBefRev MONEY 20 28 8 DeprAmBefRev
AMR1 AMR1007 DeprAmAftRev MONEY 20 28 8 DeprAmAftRev
AMR1 AMR1008 DepBasBefRev MONEY 20 28 8 DepBasBefRev
AMR1 AMR1009 DepBasAftRev MONEY 20 28 8 DepBasAftRev
AMR1 AMR1010 BalAccAssets ACCSTR 120 120 0 BalAccAssets
AMR1 AMR1011 BalAccDeprec VSTRING 12 12 0 BalAccDeprec
AMR1 AMR1012 NLAccAdditCapProfit VSTRING 12 12 0 NL Acc. Additional Cap Profit
AMR1 AMR1013 Spare VSTRING 1 1 0 Spare
AMR1 AMR1014 Spare VSTRING 1 1 0 Spare
AMR1 AMR1015 Spare VSTRING 1 1 0 Spare
AMR1 AMR1016 FaUpdateFlag STRING 1 1 0 FaUpdateFlag
AMR1 AMR1017 TransSentFlg VSTRING 1 1 0 TransSentFlg
AMR1 AMR1018 FARecUpdDate DATE 8 0 0 FARecUpdDate
AMR1 AMR1019 GLTransactNo STRING 9 9 0 GLTransactNo
AMR1 AMR1020 AssetAccCodeInfo VSTRING 12 12 0 Asset Accounting Code Information
AMR1 AMR1021 DepreciationAccCodeInfo VSTRING 12 12 0 Deprecioation Accounting Code Infromation
AMR1 AMR1022 NLAccAdditionCapitalProfitAccCode VSTRING 12 12 0 NL Acc. Additional Cap Profit Acc Code
AMR1 AMR1023 NLAccAdditionCapitalProfitAccCodeInfo VSTRING 25 25 0 NL Acc Additional Cap Profit accounting code info
AMR1 AMR1024 BalAccDeprecAAScode VSTRING 25 25 0 BalAccDeprec AAS code
AMR1 AMR1025 AccAdditCapAAScode VSTRING 25 25 0 AccAdditCap AAS code
AMR1 AMR1026 NLAccAdditionalCapLoss VSTRING 12 12 0 NL Acc. Additional Cap Loss
AMR1 AMR1027 NLAccAdditionalCapLossAccCode VSTRING 12 12 0 NL Acc. Additional Cap Loss Acc Code
AMR1 AMR1028 NLAccAdditionalCapLossAccountingCodeInfo VSTRING 25 25 0 NL Acc Additional Cap Loss accounting code info