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
GL00 Ordered Reports File Company GL000100
GL03 Accounting Dimensions Company Year GL030112
GL06 General Ledger Transactions Company Year GL060112
GL07 Daybook Journal Transactions Company Year GL070112
GL08 Opening Balance Journal Transactions Company Year GL080112
GL09 Report Layouts Company GL090100
GL10 General Ledger Parameters Company Year GL100112
GL11 Automatic Allocations Company GL110100
GL12 Chart of Account Headings Company Year GL120112
GL14 Simulation Transactions Company Year GL140112
GL15 Transaction Workfile C Company GL150100
GL16 General Ledger Parameters 2 Company Year GL160112
GL18 Phrase File Company GL180100
GL19 Transaction Workfile D Company GL190100
GL1A GL Budget Profiles Company Year GL1A0112
GL21 Project History Transactions Company GL210100
GL22 Transaction Workfile A Company GL220100
GL23 Report Generator Company GL230100
GL24 Report Notes Company GL240100
GL25 Report Interactive Notes Company GL250100
GL26 Cash Flow Planned Transaction Setup Company GL260100
GL27 Cash Flow Accounts Company GL270100
GL28 Parameter File Interest Charge Project Company GL280100
GL29 Account Number Alias Company GL290100
GL30 Transaction Workfile B Company GL300100
GL34 WrkDepreciation GL340000
GL40 Consolidated Currencies Company Year GL400112
GL41 Consolidation Account Translations Company Year GL410112
GL42 Cash-Book Reconciliation Accounts Company GL420100
GL43 Cash-Book Reconciliation Transactions Company GL430100
GL44 Workfile Cheques Company GL440100
GL45 Transaction Text Company Year GL450112
GL46 Valid Coding Combinations Company Year GL460112
GL52 General Ledger Balances Company Year GL520112
GL53 Account Schedule Company Year GL530112
GL55 Foreign Descriptions Company Year GL550112
GL56 Commitments Company Year GL560112
GL57 Bank Statement Header Company GL570100
GL58 Bank Statement Transactions Company GL580100
GL59 Reconcilation Proposal Company GL590100
GL5A Multi-Currency Links Company Year GL5A0112
GL5B Multi-Currency General Ledger Balances Company Year GL5B0112
GL5C Bank Definition Company GL5C0100
GL5D Multi-Link Statistical Account Balances Company Year GL5D0112
GL5S SPED parameters Company Year GL5S0112
GL60 Compound Allocations Company GL600100
GL61 Compound Allocation Descriptions Company GL610100
GL62 Compound Allocation Lines Company GL620100
GL65 Compound Allocation Remeasurement Transactions Company GL650100
GL67 Compound Allocation Selection History Company GL670100
GL77 EMU Conversion Set-up Company GL770100
GL80 Un-Authorized Transactions (Greece) Company Year GL800112
GLB2 Operation Details Company GLB20100
GLB3 Receipt Information Company GLB30100
GLBT Converted GL06 transactions Company Year GLBT0112
GLC1 Statement- or Debit/Credit Notification Message Company GLC10100
GLC2 Statement- or Debit/Credit Notification Message Page Company GLC20100
GLC3 Statement- or Debit/Credit Notification Company GLC30100
GLC4 Statement- or Debit/Credit Notification Entry Company GLC40100
GLC5 Statement- or Debit/Credit Notification Entry Detail Company GLC50100
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction Company GLC60100
GLC7 Statement- or Debit/Credit Notification Entry Detail Transaction Unstructured Remittance Company GLC70100
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance Company GLC80100
GLC9 Charges Company GLC90100
GLCB Petty Cash Master Table Company Year GLCB0112
GLCD Petty Cash Desk Parameters Company Year GLCD0112
GLCE Cash Office Company GLCE0100
GLCF Cash Office Language Dependent Description Company GLCF0100
GLCG Reason Code Company GLCG0100
GLCH Notification processing template header Company GLCH0100
GLCI Reason Code Language Dependent Description Company GLCI0100
GLCL Notification processing template Line Company GLCL0100
GLCW Compound Periodic Allocation Work File GLCW0000
GLCX Petty Cash Extension File Company Year GLCX0112
GLCY Petty Cash Transaction File Company Year GLCY0112
GLEB Extended General Ledger Balance Company Year GLEB0112
GLF1 Financial Reporting Report Definition Company GLF10100
GLF2 Financial Reporting RowSet Company GLF20100
GLF3 Financial Reporting Row Company GLF30100
GLF4 Financial Reporting Leaf Row Properties Company GLF40100
GLF5 Financial Reporting ColumnSet Company GLF50100
GLF6 Financial Reporting Column Company GLF60100
GLF7 Accounting Dimension Categories Company GLF70100
GLF8 Accounting Dimension Categories Leaf Properties Company GLF80100
GLFA Financial Reporting Report Definition Descriptions Company GLFA0100
GLFB Financial Reporting RowSet Descriptions Company GLFB0100
GLFC Financial Reporting Row Descriptions Company GLFC0100
GLFD Financial Reporting ColumnSet Descriptions Company GLFD0100
GLFE Financial Reporting Column Descriptions Company GLFE0100
GLFF Accounting Dimension Categories Descriptions Company GLFF0100
GLGL GL Consolidation Company GLGL0100
GLH0 PMS Interface File Structure Definition (Header) Company GLH00100
GLH1 PMS Interface File Structure Definition (Records) Company GLH10100
GLH2 PMS Interface Mapping File Company GLH20100
GLHI FA Transaction History Company GLHI0100
GLII Company fiscal parameters for Italian fiscal reports Company GLII0100
GLR1 Company GLR10100
GLR2 Company GLR20100
GLR6 GL Reversed Transactions Company Year GLR60112
GLR7 GL Reversed Transactions in Daybook Journal Company Year GLR70112
GLRD Company GLRD0100
GLRH Revenue Recognition History WIP Journal Company GLRH0100
GLRJ Company Year GLRJ0112
GLRM Revenue Recognition Model Codes Company GLRM0100
GLRR Company GLRR0100
GLTH BLiner functionality Company Year GLTH0112
GLTM Transaction Mapping Company GLTM0100
GLTR Transformation Rules for BLiner functionality Company Year GLTR0112
GLXX Wrk. Acc.Spec. GLXX0000
GLXZ SQL work file GLXZ0000
GLZZ Hyperion Export Parameters Company GLZZ0100
sca_trg_Audit_GL03 Audit trigger for GL03 table Company Year sca_trg_Audit_GL030112
sca_trg_Audit_GL10 Audit trigger for GL10 table Company Year sca_trg_Audit_GL100112
sca_trg_Audit_GL16 Audit trigger for GL16 table Company Year sca_trg_Audit_GL160112
sca_trg_Audit_GL53 Audit trigger for GL53 table Company Year sca_trg_Audit_GL530112
sca_trg_Audit_GLCD Audit trigger for GLCD table Company Year sca_trg_Audit_GLCD0112
sca_trg_Audit_GLCE Audit trigger for GLCE table Company sca_trg_Audit_GLCE0100
sca_trg_Audit_GLCF Audit trigger for GLCF table Company sca_trg_Audit_GLCF0100
sca_trg_Audit_GLCG Audit trigger for GLCG table Company sca_trg_Audit_GLCG0100
sca_trg_Audit_GLCI Audit trigger for GLCI table Company sca_trg_Audit_GLCI0100

Fields
PK Table Name Description Type Length Precision Note
1 GLHI GLHI001 TransCod VSTRING 3 3 0 TransCod
2 GLHI GLHI002 TransDate DATE 8 0 0 TransDate
3 GLHI GLHI003 TransTime VSTRING 9 9 0 TransTime
4 GLHI GLHI004 InventoryCod VSTRING 10 10 0 InventoryCod
5 GLHI GLHI005 TransCode VSTRING 10 10 0 TransCode
6 GLHI GLHI006 CurrencyCod VSTRING 2 2 0 CurrencyCod
7 GLHI GLHI007 UserId VSTRING 8 8 0 UserId
GLHI GLHI008 DescrLine1 VSTRING 30 30 0 DescrLine1
GLHI GLHI009 DescrLine2 VSTRING 30 30 0 DescrLine2
GLHI GLHI010 InventGroup VSTRING 10 10 0 InventGroup
GLHI GLHI011 AccString ACCSTR 120 120 0 AccString
GLHI GLHI012 Spare VSTRING 12 12 0 Spare
GLHI GLHI013 Spare VSTRING 12 12 0 Spare
GLHI GLHI014 Spare VSTRING 12 12 0 Spare
GLHI GLHI015 Spare VSTRING 12 12 0 Spare
GLHI GLHI016 RetrDeprec VSTRING 1 1 0 RetrDeprec
GLHI GLHI017 Spare VSTRING 1 1 0 Spare
GLHI GLHI018 Spare VSTRING 1 1 0 Spare
GLHI GLHI019 NoteNo VSTRING 3 3 0 NoteNo
GLHI GLHI020 CategoryA VSTRING 4 4 0 CategoryA
GLHI GLHI021 CategoryB VSTRING 4 4 0 CategoryB
GLHI GLHI022 Location VSTRING 15 15 0 Location
GLHI GLHI023 SuplCode VSTRING 10 10 0 SuplCode
GLHI GLHI024 SupNameAddr1 VSTRING 32 32 0 SupNameAddr1
GLHI GLHI025 SupNameAddr2 VSTRING 32 32 0 SupNameAddr2
GLHI GLHI026 SupNameAddr3 VSTRING 32 32 0 SupNameAddr3
GLHI GLHI027 SupNameAddr4 VSTRING 32 32 0 SupNameAddr4
GLHI GLHI028 NameContact VSTRING 25 25 0 NameContact
GLHI GLHI029 Telephone VSTRING 15 15 0 Telephone
GLHI GLHI030 SupplInv VSTRING 15 15 0 SupplInv
GLHI GLHI031 TransactNo VSTRING 9 9 0 TransactNo
GLHI GLHI032 WarrExpDate DATE 8 0 0 WarrExpDate
GLHI GLHI033 InsuranceComp VSTRING 25 25 0 InsuranceComp
GLHI GLHI034 InsuranceNo VSTRING 20 20 0 InsuranceNo
GLHI GLHI035 InsuredAm MONEY 20 28 8 InsuredAm
GLHI GLHI036 PurchPrice VSTRING 20 20 0 PurchPrice
GLHI GLHI037 RePurchPr VSTRING 20 20 0 RePurchPr
GLHI GLHI038 AccRepairs VSTRING 20 20 0 AccRepairs
GLHI GLHI039 AccAddons VSTRING 20 20 0 AccAddons
GLHI GLHI040 DatePurch DATE 8 0 0 DatePurch
GLHI GLHI041 DateScrapped DATE 8 0 0 DateScrapped
GLHI GLHI042 ScrSoldCode VSTRING 4 4 0 ScrSoldCode
GLHI GLHI043 IndexValue VSTRING 6 6 0 IndexValue
GLHI GLHI044 LUpdDepr STRING 4 4 0 LUpdDepr
GLHI GLHI045 Spare VSTRING 1 1 0 Spare
GLHI GLHI046 Spare VSTRING 2 2 0 Spare
GLHI GLHI047 Spare VSTRING 6 6 0 Spare
GLHI GLHI048 Spare MONEY 20 28 8 Spare
GLHI GLHI049 Spare VSTRING 20 20 0 Spare
GLHI GLHI050 Spare VSTRING 20 20 0 Spare
GLHI GLHI051 Spare VSTRING 20 20 0 Spare
GLHI GLHI052 Spare VSTRING 20 20 0 Spare
GLHI GLHI053 Spare VSTRING 20 20 0 Spare
GLHI GLHI054 Spare VSTRING 1 1 0 Spare
GLHI GLHI055 Spare VSTRING 2 2 0 Spare
GLHI GLHI056 Spare VSTRING 6 6 0 Spare
GLHI GLHI057 Spare MONEY 20 28 8 Spare
GLHI GLHI058 Spare VSTRING 20 20 0 Spare
GLHI GLHI059 Spare VSTRING 20 20 0 Spare
GLHI GLHI060 Spare VSTRING 20 20 0 Spare
GLHI GLHI061 Spare VSTRING 20 20 0 Spare
GLHI GLHI062 Spare VSTRING 20 20 0 Spare
GLHI GLHI063 Spare VSTRING 2 2 0 Spare
GLHI GLHI064 Spare VSTRING 2 2 0 Spare
GLHI GLHI065 Spare VSTRING 2 2 0 Spare
GLHI GLHI066 InternRem1 VSTRING 30 30 0 InternRem1
GLHI GLHI067 InternRem2 VSTRING 30 30 0 InternRem2
GLHI GLHI068 InsuranCode VSTRING 5 5 0 InsuranCode
GLHI GLHI069 DocFlag VSTRING 1 1 0 DocFlag
GLHI GLHI070 ServContract VSTRING 20 20 0 ServContract
GLHI GLHI071 GenBudget VSTRING 1 1 0 GenBudget
GLHI GLHI072 GenTrans VSTRING 1 1 0 GenTrans
GLHI GLHI073 UserDefDat1 VSTRING 15 15 0 UserDefDat1
GLHI GLHI074 UserDefDat2 VSTRING 10 10 0 UserDefDat2
GLHI GLHI075 UserDefDat3 VSTRING 10 10 0 UserDefDat3
GLHI GLHI076 UserDefDat4 VSTRING 5 5 0 UserDefDat4
GLHI GLHI077 DeprMetC VSTRING 1 1 0 DeprMetC
GLHI GLHI078 DeprPerC VSTRING 2 2 0 DeprPerC
GLHI GLHI079 DeprCalc VSTRING 6 6 0 DeprCalc
GLHI GLHI080 DeprAmC MONEY 20 28 8 DeprAmC
GLHI GLHI081 DeprBaseC VSTRING 20 20 0 DeprBaseC
GLHI GLHI082 ScrapValC VSTRING 20 20 0 ScrapValC
GLHI GLHI083 AccDeprC VSTRING 20 20 0 AccDeprC
GLHI GLHI084 DeprecC VSTRING 20 20 0 DeprecC
GLHI GLHI085 ExtraDeprC VSTRING 20 20 0 ExtraDeprC
GLHI GLHI086 IndexValueC VSTRING 6 6 0 IndexValueC
GLHI GLHI087 DeprStrtDate DATE 8 0 0 DeprStrtDate
GLHI GLHI088 NatSwitch1 VSTRING 1 1 0 NatSwitch1
GLHI GLHI089 NatSwitch2 VSTRING 1 1 0 NatSwitch2
GLHI GLHI090 NatSwitch3 VSTRING 1 1 0 NatSwitch3
GLHI GLHI091 NationDate1 DATE 8 0 0 NationDate1
GLHI GLHI092 NationDate2 DATE 8 0 0 NationDate2
GLHI GLHI093 NationDate3 DATE 8 0 0 NationDate3
GLHI GLHI094 NatAmount1 MONEY 20 28 8 NatAmount1
GLHI GLHI095 NatAmount2 MONEY 20 28 8 NatAmount2
GLHI GLHI096 NatAmount3 MONEY 20 28 8 NatAmount3
GLHI GLHI097 Spare VSTRING 6 6 0 Spare
GLHI GLHI098 Spare VSTRING 6 6 0 Spare
GLHI GLHI099 Deprec2Calc VSTRING 6 6 0 Deprec2Calc
GLHI GLHI100 Spare VSTRING 1 1 0 Spare
GLHI GLHI101 Spare VSTRING 1 1 0 Spare
GLHI GLHI102 DeprSwCalc VSTRING 1 1 0 DeprSwCalc
GLHI GLHI103 DepMethodTax VSTRING 2 2 0 DepMethodTax
GLHI GLHI104 NLBalAccTax VSTRING 12 12 0 NLBalAccTax
GLHI GLHI105 NLPLAccTax VSTRING 12 12 0 NLPLAccTax
GLHI GLHI106 DepPerYrTax VSTRING 3 3 0 DepPerYrTax
GLHI GLHI107 DeprTax VSTRING 6 6 0 DeprTax
GLHI GLHI108 DeprAmTax MONEY 20 28 8 DeprAmTax
GLHI GLHI109 DeprBaseTax VSTRING 20 20 0 DeprBaseTax
GLHI GLHI110 ScrapValTax VSTRING 20 20 0 ScrapValTax
GLHI GLHI111 AccDeprTax VSTRING 20 20 0 AccDeprTax
GLHI GLHI112 DeprYearTax VSTRING 20 20 0 DeprYearTax
GLHI GLHI113 ExtraDeprTax VSTRING 20 20 0 ExtraDeprTax
GLHI GLHI114 Depr2Tax VSTRING 6 6 0 Depr2Tax
GLHI GLHI115 DeprSwTax VSTRING 1 1 0 DeprSwTax
GLHI GLHI116 DepMethodPln VSTRING 2 2 0 DepMethodPln
GLHI GLHI117 NLBalAccPln VSTRING 12 12 0 NLBalAccPln
GLHI GLHI118 NLPLAccPln VSTRING 12 12 0 NLPLAccPln
GLHI GLHI119 DepPerYrPln VSTRING 3 3 0 DepPerYrPln
GLHI GLHI120 DeprPln VSTRING 6 6 0 DeprPln
GLHI GLHI121 DeprAmPln MONEY 20 28 8 DeprAmPln
GLHI GLHI122 DeprBasePln VSTRING 20 20 0 DeprBasePln
GLHI GLHI123 ScrapValPln VSTRING 20 20 0 ScrapValPln
GLHI GLHI124 AccDeprPln VSTRING 20 20 0 AccDeprPln
GLHI GLHI125 DeprYearPln VSTRING 20 20 0 DeprYearPln
GLHI GLHI126 ExtraDeprPln VSTRING 20 20 0 ExtraDeprPln
GLHI GLHI127 Per1WoDepr VSTRING 2 2 0 Per1WoDepr
GLHI GLHI128 Per2WoDepr VSTRING 2 2 0 Per2WoDepr
GLHI GLHI129 Per3WoDepr VSTRING 2 2 0 Per3WoDepr
GLHI GLHI130 Depr2Pln VSTRING 6 6 0 Depr2Pln
GLHI GLHI131 DeprSwPln VSTRING 1 1 0 DeprSwPln
GLHI GLHI132 PurchaseCost VSTRING 20 20 0 PurchaseCost
GLHI GLHI133 DailyDeprPln VSTRING 1 1 0 DailyDeprPln
GLHI GLHI134 DailyDeprTax VSTRING 1 1 0 DailyDeprTax
GLHI GLHI135 Dummy VSTRING 1 1 0 Dummy
GLHI GLHI136 DepPerUnitTx STRING 1 1 0 DepPerUnitTx
GLHI GLHI137 DepPerUnitPn STRING 1 1 0 DepPerUnitPn
GLHI GLHI138 SalesRevenue MONEY 20 28 8 SalesRevenue
GLHI GLHI139 YearReducDeprTax INTEGER 1 0 0 YearReducDeprTax
GLHI GLHI140 DeprStartTax DATE 8 0 0 DeprStartTax
GLHI GLHI141 YearReducDeprPlan INTEGER 1 0 0 YearReducDeprPlan
GLHI GLHI142 DeprStartPlan DATE 8 0 0 DeprStartPlan
GLHI GLHI143 LockFlag VSTRING 1 1 0 LockFlag
GLHI GLHI144 SummaryLevel VSTRING 1 1 0 SummaryLevel
GLHI GLHI145 ReportingLevel1 VSTRING 12 12 0 ReportingLevel1
GLHI GLHI146 ReportingLevel2 VSTRING 12 12 0 ReportingLevel2
GLHI GLHI147 ReportingLevel3 VSTRING 12 12 0 ReportingLevel3
GLHI GLHI148 ReportingLevel4 VSTRING 12 12 0 ReportingLevel4
GLHI GLHI149 ReportingLevel5 VSTRING 12 12 0 ReportingLevel5
GLHI GLHI150 AccCodePUR VSTRING 2 2 0 AccCodePUR
GLHI GLHI151 AccCodeTAX VSTRING 2 2 0 AccCodeTAX
GLHI GLHI152 AccCodePLA VSTRING 2 2 0 AccCodePLA
GLHI GLHI153 AccCodeSAL VSTRING 2 2 0 AccCodeSAL
GLHI GLHI154 AccCodeSCR VSTRING 2 2 0 AccCodeSCR
GLHI GLHI155 AccCodeREV VSTRING 2 2 0 AccCodeREV
GLHI GLHI156 AccCodeETX VSTRING 2 2 0 AccCodeETX
GLHI GLHI157 AccCodeFUS VSTRING 2 2 0 AccCodeFUS
GLHI GLHI158 AccCodeICT VSTRING 2 2 0 AccCodeICT
GLHI GLHI159 AccCodePLP VSTRING 2 2 0 AccCodePLP
GLHI GLHI160 AccCodeACT VSTRING 2 2 0 AccCodeACT
GLHI GLHI161 AccCodeRE1 VSTRING 2 2 0 AccCodeRE1
GLHI GLHI162 AccCodeRE2 VSTRING 2 2 0 AccCodeRE2
GLHI GLHI163 AccCodeRE3 VSTRING 2 2 0 AccCodeRE3
GLHI GLHI164 AccCodeRE4 VSTRING 2 2 0 AccCodeRE4
GLHI GLHI165 AccCodeRE5 VSTRING 2 2 0 AccCodeRE5
GLHI GLHI166 AccCodeRE6 VSTRING 2 2 0 AccCodeRE6
GLHI GLHI167 AccCodeRE7 VSTRING 2 2 0 AccCodeRE7
GLHI GLHI168 AccCodeRE8 VSTRING 2 2 0 AccCodeRE8
GLHI GLHI169 AccCodeRE9 VSTRING 2 2 0 AccCodeRE9
GLHI GLHI170 AccCodeRE10 VSTRING 2 2 0 AccCodeRE10
GLHI GLHI171 AccCodeRE11 VSTRING 2 2 0 AccCodeRE11
GLHI GLHI172 AccCodeRE12 VSTRING 2 2 0 AccCodeRE12
GLHI GLHI173 AccCodeRE13 VSTRING 2 2 0 AccCodeRE13
GLHI GLHI174 AccCodeRE14 VSTRING 2 2 0 AccCodeRE14
GLHI GLHI175 AccCodeRE15 VSTRING 2 2 0 AccCodeRE15
GLHI GLHI176 AccCodeRE16 VSTRING 2 2 0 AccCodeRE16
GLHI GLHI177 AccCodeRE17 VSTRING 2 2 0 AccCodeRE17
GLHI GLHI178 AccCodeRE18 VSTRING 2 2 0 AccCodeRE18
GLHI GLHI179 AccCodeRE19 VSTRING 2 2 0 AccCodeRE19
GLHI GLHI180 AccCodeRE20 VSTRING 2 2 0 AccCodeRE20