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 AM32 AM32001 InventCode VSTRING 35 35 0 Asset Template Code
AM32 AM32002 DescrLine1 VSTRING 35 35 0 Description Line 1
AM32 AM32003 DescrLine2 VSTRING 35 35 0 Description Line 2
AM32 AM32004 InventGrCode VSTRING 10 10 0 Asset Group
AM32 AM32005 BalAccAssets ACCSTR 120 120 0 Accounting String
AM32 AM32006 BalAccDepr VSTRING 12 12 0 (obsolete)
AM32 AM32007 PLAccDepr VSTRING 12 12 0 (obsolete)
AM32 AM32008 BalAccDepr2 VSTRING 12 12 0 (obsolete)
AM32 AM32009 PLAccDepr2 VSTRING 12 12 0 (obsolete)
AM32 AM32010 CostCenter STRING 1 1 0 Retroactive Adjustment of Depreciations 0 - No retroactive adjustment will be made.
1 - Retroactive adjustment of depreciation will be made if basis or method is changed.
2 - No retroactive adjustment will be made and accumulated year depreciation is not taken into account (only methods 1,5,8)
AM32 AM32011 ProductCode VSTRING 1 1 0 (obsolete)
AM32 AM32012 YearlyReducingTaxDepreciation VSTRING 1 1 0 Yearly Reducing Tax Depreciation Depreciation is calculated:
0 - Accordingly to the parameter set-up
1 - Only for periods when you have had the asset
2 - For the whole year, even for asset acquired during the year
3 - Accordingly to semi-annual rule.
AM32 AM32013 NoteNumber STRING 3 3 0 Note Number
AM32 AM32014 CategoryA VSTRING 4 4 0 Category A
AM32 AM32015 CategoryB VSTRING 4 4 0 Category B
AM32 AM32016 Location VSTRING 15 15 0 Location
AM32 AM32017 SupplierCode VSTRING 10 10 0 Supplier Code
AM32 AM32018 SupplierName VSTRING 35 35 0 Supplier Name
AM32 AM32019 SupplierAdd1 VSTRING 35 35 0 Supplier Address Line 1
AM32 AM32020 SupplierAdd2 VSTRING 35 35 0 Supplier Address Line 2
AM32 AM32021 SupplierAdd3 VSTRING 35 35 0 Supplier Address Line 3
AM32 AM32022 TechContact VSTRING 25 25 0 Contact Name
AM32 AM32023 TelephNumber VSTRING 15 15 0 Telephone Number
AM32 AM32024 SupplInvNo VSTRING 25 25 0 Supplier Invoice
AM32 AM32025 NLTransNo VSTRING 9 9 0 Transaction Number Purchase Invoice
AM32 AM32026 WarrExpDate DATE 8 0 0 Warranty Expiration Date
AM32 AM32027 InsurancComp VSTRING 25 25 0 Insurance Company
AM32 AM32028 InsuranceNo VSTRING 20 20 0 Insurance Number
AM32 AM32029 InsureAmount MONEY 20 28 8 Insured Amount
AM32 AM32030 PurchPrice MONEY 20 28 8 Purchase Price
AM32 AM32031 RePurchPri MONEY 20 28 8 Replacement Purchase Price
AM32 AM32032 AccRepairs MONEY 20 28 8 Accumulated Repairs
AM32 AM32033 AccAddons MONEY 20 28 8 Accumulated Add-ons
AM32 AM32034 DatePurchase DATE 8 0 0 Date Purchased
AM32 AM32035 DateScraSold DATE 8 0 0 Date Scrapped
AM32 AM32036 ScraSoldCode VSTRING 4 4 0 Disposal Code
AM32 AM32037 IndexValue X_NUMERIC 6 14 8 Index Value
AM32 AM32038 LastUpdDepr VSTRING 4 4 0 Last Depreciation Update Date Defines the financial year and book-keeping period up-to which depreciations have been booked. It is updated automatically on calculation of depreciations.
AM32 AM32039 TaxDeprMeth STRING 1 1 0 (obsolete)
AM32 AM32040 TaxDeprPerYr INTEGER 2 0 0 (obsolete)
AM32 AM32041 TaxDeprec X_NUMERIC 6 14 8 (obsolete)
AM32 AM32042 TaxDeprAm MONEY 20 28 8 (obsolete)
AM32 AM32043 TaxDeprBase MONEY 20 28 8 (obsolete)
AM32 AM32044 TaxScrapVal MONEY 20 28 8 (obsolete)
AM32 AM32045 TaxAccumDepr MONEY 20 28 8 (obsolete)
AM32 AM32046 TaxDeprYear MONEY 20 28 8 (obsolete)
AM32 AM32047 TaxExtraDepr MONEY 20 28 8 (obsolete)
AM32 AM32048 CapitalizationAllowed STRING 1 1 0 Capitalization Allowed
AM32 AM32049 PlanDeprPerY INTEGER 2 0 0 (obsolete)
AM32 AM32050 PlanDeprec X_NUMERIC 6 14 8 (obsolete)
AM32 AM32051 PlanDeprAm MONEY 20 28 8 (obsolete)
AM32 AM32052 PlanDeprBase MONEY 20 28 8 (obsolete)
AM32 AM32053 PlanScrapVal MONEY 20 28 8 (obsolete)
AM32 AM32054 PlanAccDepr MONEY 20 28 8 (obsolete)
AM32 AM32055 PlanDeprYear MONEY 20 28 8 (obsolete)
AM32 AM32056 PlanExtraDep MONEY 20 28 8 (obsolete)
AM32 AM32057 PlanPeriodN1 STRING 2 2 0 (obsolete)
AM32 AM32058 PlanPeriodN2 STRING 2 2 0 (obsolete)
AM32 AM32059 PlanPeriodN3 STRING 2 2 0 (obsolete)
AM32 AM32060 InternalRem1 VSTRING 30 30 0 Remark Line 1
AM32 AM32061 InternalRem2 VSTRING 30 30 0 Remark Line 2
AM32 AM32062 InsurancCode VSTRING 5 5 0 Insurance Category
AM32 AM32063 DocumentFlag STRING 1 1 0 Print New Label
AM32 AM32064 ServContract VSTRING 20 20 0 Service Contract
AM32 AM32065 GenerateBudg STRING 1 1 0 Generate Budget 1 - Budget will be calculated and transactions are created for general ledger
0 - Budget will only be calculated and printed on the report, no budget transactions are created for the general ledger
AM32 AM32066 GenerateTran STRING 1 1 0 Generate Transactions 1 - When calculating depreciations, general ledger transactions will be created and be placed in the day-book journal
0 - Depreciations will only be calculated and printed on the calculation report, no general ledger transactions will be created.
AM32 AM32067 UserDefData1 VSTRING 15 15 0 User Defined Field 1
AM32 AM32068 UserDefData2 VSTRING 10 10 0 User Defined Field 2
AM32 AM32069 UserDefData3 VSTRING 10 10 0 User Defined Field 3
AM32 AM32070 UserDefData4 VSTRING 5 5 0 User Defined Field 4
AM32 AM32071 CalcDeprMeth INTEGER 1 0 0 [Calc] Depreciation Method
AM32 AM32072 CalcDeprPerY INTEGER 2 0 0 [Calc] Depreciation Periods/Years
AM32 AM32073 CalcDeprec X_NUMERIC 6 14 8 [Calc] Depreciation %
AM32 AM32074 CalcDeprAm MONEY 20 28 8 [Calc] Depreciation Amount
AM32 AM32075 CalcDeprBase MONEY 20 28 8 [Calc] Depreciation Base
AM32 AM32076 CalcScrapVal MONEY 20 28 8 [Calc] Scrap Value
AM32 AM32077 CalcAccDepr MONEY 20 28 8 [Calc] Accumulated Depreciations
AM32 AM32078 CalcDeprYear MONEY 20 28 8 [Calc] Depreciations Current Year
AM32 AM32079 CalcExtraDep MONEY 20 28 8 [Calc] Extra Depreciations
AM32 AM32080 CalcIndexVal X_NUMERIC 6 14 8 [Calc] Index Value
AM32 AM32081 DepStartDate DATE 8 0 0 Depreciation Start Date
AM32 AM32082 NationalSw1 INTEGER 1 0 0 National Switch 1
AM32 AM32083 NationalSw2 INTEGER 1 0 0 National Switch 2
AM32 AM32084 NationalSw3 INTEGER 1 0 0 National Switch 3
AM32 AM32085 NationDate1 DATE 8 0 0 National Date 1
AM32 AM32086 NationDate2 DATE 8 0 0 National Date 2
AM32 AM32087 NationDate3 DATE 8 0 0 National Date 3
AM32 AM32088 NationalAm1 MONEY 20 28 8 National Amount 1
AM32 AM32089 NationalAm2 MONEY 20 28 8 National Amount 2
AM32 AM32090 NationalAm3 MONEY 20 28 8 National Amount 3
AM32 AM32091 DepreciatTAX X_NUMERIC 6 14 8 (obsolete)
AM32 AM32092 DeprecPlan X_NUMERIC 6 14 8 (obsolete)
AM32 AM32093 DeprecCalc X_NUMERIC 6 14 8 [Calc] Depreciation % 2
AM32 AM32094 DepSwitcTask INTEGER 1 0 0 (obsolete)
AM32 AM32095 DepSwitcPlan INTEGER 1 0 0 (obsolete)
AM32 AM32096 DepSwitchCalc INTEGER 1 0 0 [Calc] Depreciation % Switch
AM32 AM32097 FlagLinkedtoStockCode INTEGER 1 0 0 Linked to Stock Item
AM32 AM32098 Spare VSTRING 35 35 0 (obsolete)
AM32 AM32099 DepreciationEndDate DATE 8 0 0 Depreciation End Date
AM32 AM32100 LockFlag INTEGER 1 0 0 Locked
AM32 AM32101 SummaryLevelFlag INTEGER 1 0 0 Summary Level
AM32 AM32102 ReportingLevel1 VSTRING 35 35 0 Asset Code Reporting Level 1
AM32 AM32103 ReportingLevel2 VSTRING 35 35 0 Asset Code Reporting Level 2
AM32 AM32104 ReportingLevel3 VSTRING 35 35 0 Asset Code Reporting Level 3
AM32 AM32105 ReportingLevel4 VSTRING 35 35 0 Asset Code Reporting Level 4
AM32 AM32106 ReportingLevel5 VSTRING 35 35 0 Asset Code Reporting Level 5
AM32 AM32107 LastUpdateDepreciationTax VSTRING 4 4 0 Last Update Depreciation Tax
AM32 AM32108 ValueInConsolidationCurrency MONEY 20 28 8 ValueInConsolidationCurrency
AM32 AM32109 spare VSTRING 35 35 0 spare
AM32 AM32110 LeaseGroupCode VSTRING 6 6 0 Lease Group Code
AM32 AM32111 LeaseCategoryCode VSTRING 6 6 0 Lease Category Code
AM32 AM32112 SupplierAdd4 VSTRING 35 35 0 Supplier Address Line 4
AM32 AM32113 SupplierAdd5 VSTRING 35 35 0 Supplier Address Line 5
AM32 AM32114 SupplierAdd6 VSTRING 35 35 0 Supplier Address Line 6
AM32 AM32115 SupplierAdd7 VSTRING 35 35 0 Supplier Address Line 7
AM32 AM32116 SupplierCountryCode VSTRING 3 3 0 Supplier Country Code