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 AM31 AM31001 InventoryCod VSTRING 35 35 0 Asset Code
AM31 AM31002 DescrLine1 VSTRING 35 35 0 Description Line 1
AM31 AM31003 DescrLine2 VSTRING 35 35 0 Description Line 2
AM31 AM31004 InventGroup VSTRING 10 10 0 Asset Group
AM31 AM31005 AccString ACCSTR 120 120 0 Accounting String
AM31 AM31006 Spare VSTRING 12 12 0 (obsolete)
AM31 AM31007 Spare VSTRING 12 12 0 (obsolete)
AM31 AM31008 Spare VSTRING 12 12 0 (obsolete)
AM31 AM31009 Spare VSTRING 12 12 0 (obsolete)
AM31 AM31010 RetrDeprec VSTRING 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)
AM31 AM31011 Spare VSTRING 1 1 0 (obsolete)
AM31 AM31012 YearlyRedicingTaxDepreciation 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.
AM31 AM31013 NoteNo VSTRING 3 3 0 Note Number
AM31 AM31014 CategoryA VSTRING 4 4 0 Category A
AM31 AM31015 CategoryB VSTRING 4 4 0 Category B
AM31 AM31016 Location VSTRING 15 15 0 Location
AM31 AM31017 SuplCode VSTRING 10 10 0 Supplier Code
AM31 AM31018 SupplierName VSTRING 35 35 0 Supplier Name
AM31 AM31019 SupNameAddr1 VSTRING 35 35 0 Supplier Address Line 1
AM31 AM31020 SupNameAddr2 VSTRING 35 35 0 Supplier Address Line 2
AM31 AM31021 SupNameAddr3 VSTRING 35 35 0 Supplier Address Line 3
AM31 AM31022 NameContact VSTRING 25 25 0 Contact Name
AM31 AM31023 Telephone VSTRING 15 15 0 Telephone Number
AM31 AM31024 SupplInv VSTRING 25 25 0 Supplier Invoice
AM31 AM31025 TransactNo VSTRING 9 9 0 Transaction Number Purchase Invoice
AM31 AM31026 WarrExpDate DATE 8 0 0 Warranty Expiration Date
AM31 AM31027 InsuranceComp VSTRING 25 25 0 Insurance Company
AM31 AM31028 InsuranceNo VSTRING 20 20 0 Insurance Number
AM31 AM31029 InsuredAm MONEY 20 28 8 Insured Amount
AM31 AM31030 PurchPrice MONEY 20 28 8 Purchase Price
AM31 AM31031 RePurchPr MONEY 20 28 8 Replacement Purchase Price
AM31 AM31032 AccRepairs MONEY 20 28 8 Accumulated Repairs
AM31 AM31033 AccAddons MONEY 20 28 8 Accumulated Add-ons
AM31 AM31034 DatePurch DATE 8 0 0 Date Purchased
AM31 AM31035 DateScrapped DATE 8 0 0 Date Scrapped
AM31 AM31036 ScrSoldCode VSTRING 4 4 0 Disposal Code
AM31 AM31037 IndexValue X_NUMERIC 6 14 8 Index Value
AM31 AM31038 LUpdDepr STRING 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.
AM31 AM31039 Spare VSTRING 1 1 0 (obsolete)
AM31 AM31040 Spare INTEGER 2 0 0 (obsolete)
AM31 AM31041 Spare X_NUMERIC 6 14 8 (obsolete)
AM31 AM31042 Spare MONEY 20 28 8 (obsolete)
AM31 AM31043 Spare MONEY 20 28 8 (obsolete)
AM31 AM31044 Spare MONEY 20 28 8 (obsolete)
AM31 AM31045 Spare MONEY 20 28 8 (obsolete)
AM31 AM31046 Spare MONEY 20 28 8 (obsolete)
AM31 AM31047 Spare MONEY 20 28 8 (obsolete)
AM31 AM31048 CapitalizationAllowed VSTRING 1 1 0 Capitalization Allowed
AM31 AM31049 Spare INTEGER 2 0 0 (obsolete)
AM31 AM31050 Spare X_NUMERIC 6 14 8 (obsolete)
AM31 AM31051 Spare MONEY 20 28 8 (obsolete)
AM31 AM31052 Spare MONEY 20 28 8 (obsolete)
AM31 AM31053 Spare MONEY 20 28 8 (obsolete)
AM31 AM31054 Spare MONEY 20 28 8 (obsolete)
AM31 AM31055 Spare MONEY 20 28 8 (obsolete)
AM31 AM31056 Spare MONEY 20 28 8 (obsolete)
AM31 AM31057 Spare VSTRING 2 2 0 (obsolete)
AM31 AM31058 Spare VSTRING 2 2 0 (obsolete)
AM31 AM31059 Spare VSTRING 2 2 0 (obsolete)
AM31 AM31060 InternRem1 VSTRING 30 30 0 Remark Line 1
AM31 AM31061 InternRem2 VSTRING 30 30 0 Remark Line 2
AM31 AM31062 InsuranCode VSTRING 5 5 0 Insurance Category
AM31 AM31063 DocFlag VSTRING 1 1 0 Print New Label
AM31 AM31064 ServContract VSTRING 20 20 0 Service Contract
AM31 AM31065 GenBudget VSTRING 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
AM31 AM31066 GenTrans VSTRING 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.
AM31 AM31067 UserDefDat1 VSTRING 15 15 0 User Defined Field 1
AM31 AM31068 UserDefDat2 VSTRING 10 10 0 User Defined Field 2
AM31 AM31069 UserDefDat3 VSTRING 10 10 0 User Defined Field 3
AM31 AM31070 UserDefDat4 VSTRING 5 5 0 User Defined Field 4
AM31 AM31071 DeprMetC INTEGER 1 0 0 [Calc] Depreciation Method
AM31 AM31072 DeprPerC INTEGER 2 0 0 [Calc] Depreciation Periods/Years
AM31 AM31073 DeprCalc X_NUMERIC 6 14 8 [Calc] Depreciation %
AM31 AM31074 DeprAmC MONEY 20 28 8 [Calc] Depreciation Amount
AM31 AM31075 DeprBaseC MONEY 20 28 8 [Calc] Depreciation Base
AM31 AM31076 ScrapValC MONEY 20 28 8 [Calc] Scrap Value
AM31 AM31077 AccDeprC MONEY 20 28 8 [Calc] Accumulated Depreciations
AM31 AM31078 DeprecC MONEY 20 28 8 [Calc] Depreciations Current Year
AM31 AM31079 ExtraDeprC MONEY 20 28 8 [Calc] Extra Depreciations
AM31 AM31080 IndexValueC X_NUMERIC 6 14 8 [Calc] Index Value
AM31 AM31081 DeprStrtDate DATE 8 0 0 Depreciation Start Date
AM31 AM31082 NatSwitch1 INTEGER 1 0 0 National Switch 1
AM31 AM31083 NatSwitch2 INTEGER 1 0 0 National Switch 2
AM31 AM31084 NatSwitch3 INTEGER 1 0 0 National Switch 3
AM31 AM31085 NationDate1 DATE 8 0 0 National Date 1
AM31 AM31086 NationDate2 DATE 8 0 0 National Date 2
AM31 AM31087 NationDate3 DATE 8 0 0 National Date 3
AM31 AM31088 NatAmount1 MONEY 20 28 8 National Amount 1
AM31 AM31089 NatAmount2 MONEY 20 28 8 National Amount 2
AM31 AM31090 NatAmount3 MONEY 20 28 8 National Amount 3
AM31 AM31091 Spare X_NUMERIC 6 14 8 (obsolete)
AM31 AM31092 Spare X_NUMERIC 6 14 8 (obsolete)
AM31 AM31093 Deprec2Calc X_NUMERIC 6 14 8 [Calc] Depreciation % 2
AM31 AM31094 Spare INTEGER 1 0 0 (obsolete)
AM31 AM31095 Spare INTEGER 1 0 0 (obsolete)
AM31 AM31096 DeprSwCalc INTEGER 1 0 0 [Calc] Depreciation % Switch
AM31 AM31097 FlagLinkedtoStockCode INTEGER 1 0 0 Linked to Stock Item
AM31 AM31098 Spare VSTRING 35 35 0 (obsolete)
AM31 AM31099 DepreciationEndDate DATE 8 0 0 Depreciation End Date
AM31 AM31100 LockFlag INTEGER 1 0 0 Locked
AM31 AM31101 SummaryLevelFlag INTEGER 1 0 0 Summary Level
AM31 AM31102 ReportingLevel1 VSTRING 35 35 0 Asset Code Reporting Level 1
AM31 AM31103 ReportingLevel2 VSTRING 35 35 0 Asset Code Reporting Level 2
AM31 AM31104 ReportingLevel3 VSTRING 35 35 0 Asset Code Reporting Level 3
AM31 AM31105 ReportingLevel4 VSTRING 35 35 0 Asset Code Reporting Level 4
AM31 AM31106 ReportingLevel5 VSTRING 35 35 0 Asset Code Reporting Level 5
AM31 AM31107 LastUpdateDepreciationTax VSTRING 4 4 0 Last Update Depreciation Tax
AM31 AM31108 ValueInConsolidationCurrency MONEY 20 28 8 ValueInConsolidationCurrency
AM31 AM31109 AlphaSearchKey VSTRING 35 35 0 Search Key for Description-sorting UPPER(AM31002)
AM31 AM31110 LeaseGroupCode VSTRING 6 6 0 Lease Group Code
AM31 AM31111 LeaseCategoryCode VSTRING 6 6 0 Lease Category Code
AM31 AM31112 SupNameAddr4 VSTRING 35 35 0 Supplier Address Line 4
AM31 AM31113 SupNameAddr5 VSTRING 35 35 0 Supplier Address Line 5
AM31 AM31114 SupNameAddr6 VSTRING 35 35 0 Supplier Address Line 6
AM31 AM31115 SupNameAddr7 VSTRING 35 35 0 Supplier Address Line 7
AM31 AM31116 SupCountryCode VSTRING 3 3 0 Supplier Country Code