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
PL01 Suppliers Company PL010100
PL03 Purchase Ledger Invoices Company PL030100
PL04 Purchase Ledger Invoice Journal Company Year PL040112
PL05 Purchase Ledger Payment Journal Company Year PL050112
PL07 Payment Proposal Company PL070100
PL08 Purchase Ledger Parameters Company Year PL080112
PL09 Purchase Ledger Automatic Accounting Table Company Year PL090112
PL10 Payment Ledger Company PL100100
PL14 Shipping Addresses Company PL140100
PL15 Company PL150100
PL16 Payment Methods Layouts Company PL160100
PL17 VAT Transactions Company PL170100
PL18 Withholding Tax Transactions Company PL180100
PL19 Suppliers Templates Company PL190100
PL21 Purchase Ledger Payments Company PL210100
PL22 Payment Terms PL Company PL220100
PL23 Payment Terms Descriptions Company PL230100
PL24 Tax details for prepayment Company PL240100
PL25 Tax details for payment Company PL250100
PL30 Check Register Company PL300100
PL32 Company PL320100
PL33 Company PL330100
PL40 Prepayment Allocation Lines Company PL400100
PL41 Prepayment Tax Lines Company PL410100
PL43 Prepayment Deductions Company PL430100
PL44 Prepayment Documents Company PL440100
PL45 Extended Bank Info Company PL450100
PL46 Invoice OCR Payment Reference Company PL460100
PL50 Payment Proposal Header Company PL500100
PL51 Payment Proposal Lines Company PL510100
PL56 Swedish BankGiro, PlusGiro services Company PL560100
PL88 Check Printout Company PL880100
PL92 Foreign Payment Temp File I/O PL920000
PL93 Foreign Payment Temp File I/O PL930000
PL95 Russian VAT wrk PL950000
PL96 DueDate report PL960000
PL97 Ledger Statement PL970000
PL98 EC Tax Reports Company PL980100
PLA1 SL account exceptions for revaluation procedure Company PLA10100
PLAG Company PLAG0100
PLB1 Transportation Terms Company PLB1 0100
PLB4 Tax note description lines Company PLB40100
PLBT Company PLBT0100
PLC0 Import information from customs certificates or invoices Company PLC00100
PLDA SEPA Debtor Accounts Company PLDA0100
PLE0 Spain Payment Parameters Company PLE00100
PLH3 Recharge Invoice Accounts Payable Header PLH30000
PLH4 Recharge Invoice Accounts Payable transaction lines PLH40000
PLH5 Company PLH50100
PLH6 Inter-Company Transaction Entry PLH60000
PLH7 Entities and Amounts for current invoice(Work) PLH70000
PLHA Recharge Invoice Parameters Company PLHA0100
PLHB Recharge Invoice Parameters - Target Company PLHB0000
PLHC Work file for entering inter-company transactions PLHC0000
PLHD Recharge Invoice Tax amount PLHD0000
PLHE Recharge expense amounts PLHE0000
PLHF Recharge Amounts PLHF0000
PLHG Recharge Invoice Distribution Templates Company PLHG0100
PLI1 Payment Term Instalments PL Header Company PLI10100
PLI2 Payment Term Instalments PL Lines Company PLI20100
PLI3 Payment Term Instalments PL Company PLI30100
PLIN Invoice Based Intrastat PL Company PLIN0100
PLL1 Supplier Tax Exemptions Company PLL10100
PLL2 Supplier Payment Balances Company PLL20100
PLL3 Payment Proposal Retentions Company PLL30100
PLM0 Company PLM00100
PLM5 Bank Account Number for Currency Code Company PLM50100
PLMH Company PLMH0100
PLPU Company PLPU0100
PLR4 PL Reversed Transaction Company Year PLR40112
PLRE Company PLRE0100
PLS0 SEPA Instalment – Bank account Company PLS00100
PLSE Company PLSE0100
PLSG SEPA Grouping Parameters Company PLSG0100
PLT7 Temp Tax table for autopayments Company PLT70100
PLTC Work File for Printing Tax Certificate PLTC0000
PLTE Company PLTE0100
PLXX PLXX Work File PLXX0000
PLXY PLXY Work File PLXY0000
sca_trg_Audit_PL01 Audit trigger for PL01 table Company sca_trg_Audit_PL010100
sca_trg_Audit_PL03 Audit trigger for PL03 table Company sca_trg_Audit_PL030100
sca_trg_Audit_PL08 Audit trigger for PL08 table Company Year sca_trg_Audit_PL080112
sca_trg_Audit_PL45 Audit trigger for PL45 table Company sca_trg_Audit_PL450100
sca_trg_Audit_PLM0 Audit trigger for PLM0 table Company sca_trg_Audit_PLM00100
SY50 Statistic Currency Rate for Accounting Periods Company Year SY500112

Fields
PK Table Name Description Type Length Precision Note
1 PLHF PLHF001 OrigCompCode STRING 2 2 0 Originating Company
2 PLHF PLHF002 MainInvSupplCode STRING 10 10 0 Main Invoice Supplier Code
3 PLHF PLHF003 MainInvNumber STRING 25 25 0 Main Invoice Number
4 PLHF PLHF004 TargetEntity STRING 10 10 0 Target Entity Used for target company code
PLHF PLHF005 UpdatedFlag SWITCH 1 1 0 Is Updated
PLHF PLHF006 CreatedFlag SWITCH 1 1 0 Is Created
PLHF PLHF007 MultipleEntity STRING 1 1 0 Multiple Entity
PLHF PLHF008 TargetCompanyCode STRING 2 2 0 Target Company Code
PLHF PLHF009 FeeOCU MONEY 20 28 8 Service Fee (Original Currency)
PLHF PLHF010 FeeLCUOC MONEY 20 28 8 Service Fee (Local Currency, Original Company)
PLHF PLHF011 FeeLCUTC MONEY 20 28 8 Service Fee (Local Currency, Target Company)
PLHF PLHF012 FeeCurrDate DATE 8 0 0 Service Fee Currency Date
PLHF PLHF013 FeeExchRateLCOC VSTRING 15 15 0 Service Fee Exchange Rate (Local Currency, Original Company)
PLHF PLHF014 FeeExchRateLCTC VSTRING 15 15 0 Service Fee Exchange Rate (Local Currency, Target Company)
PLHF PLHF015 AmtOCU MONEY 20 28 8 Recharge Amount (Original Currency)
PLHF PLHF016 AmtLCUOC MONEY 20 28 8 Recharge Amount (Local Currency, Original Company)
PLHF PLHF017 AmtLCUTC MONEY 20 28 8 Recharge Amount (Local Currency, Target Company)
PLHF PLHF018 AmtCurrDate DATE 8 0 0 Recharge Amount Currency Date
PLHF PLHF019 AmtExchRateLCUOC VSTRING 15 15 0 Recharge Amount Exchange Rate (Local Currency, Original Company)
PLHF PLHF020 AmtExchRateLCUTC VSTRING 15 15 0 Recharge Amount Exchange Rate (Local Currency, Target Company)
PLHF PLHF021 ActualExpensLCUOC MONEY 20 28 8 Actual Expense (Local Currency, Original Company)
PLHF PLHF022 CurrencyCodeFeeOC INTEGER 2 0 0 Currency Code Service Fee (Original Company)
PLHF PLHF023 CurrencyCodeAmtOC INTEGER 2 0 0 Currency Code Recharge Amount (Original Company)
PLHF PLHF024 CurrencyCodeFeeTC INTEGER 2 0 0 Currency Code Service Fee (Target Company)
PLHF PLHF025 CurrencyCodeAmtTC INTEGER 2 0 0 Currency Code Recharge Amount (Target Company)
PLHF PLHF026 TCCurrCodeOCLCU INTEGER 2 0 0 Target Company Currency Code (Original Company, Local Amounts)
PLHF PLHF027 OCCurrCodeTCLCU INTEGER 2 0 0 Original Company Currency Code (Target Company, Local Amounts)
PLHF PLHF028 FeeTaxOCU MONEY 20 28 8 Service Fee Tax (Original Currency)
PLHF PLHF029 FeeTaxLCUOC MONEY 20 28 8 Service Fee Tax (Local Currency, Original Company)
PLHF PLHF030 FeeTaxLCUTC MONEY 20 28 8 Service Fee Tax (Local Currency, Target Company)
PLHF PLHF031 AmtTotalTaxOCU MONEY 20 28 8 Recharge Total Tax (Original Currency)
PLHF PLHF032 AmtTotalTaxLCUOC MONEY 20 28 8 Recharge Total Tax (Local Currency, Original Company)
PLHF PLHF033 AmtTotalTaxLCUTC MONEY 20 28 8 Recharge Total Tax (Local Currency, Target Company)
PLHF PLHF034 AmtLine0TaxOCU MONEY 20 28 8 Recharge Tax Amount Line 0 (Original Currency)
PLHF PLHF035 AmtLine0TaxLCUOC MONEY 20 28 8 Recharge Tax Amount Line 0 (Local Currency, Original Company)
PLHF PLHF036 AmtLine0TaxLCUTC MONEY 20 28 8 Recharge Tax Amount Line 0 (Local Currency, Target Company)
PLHF PLHF037 AmtLine1TaxOCU MONEY 20 28 8 Recharge Tax Amount Line 1 (Original Currency)
PLHF PLHF038 AmtLine1TaxLCUOC MONEY 20 28 8 Recharge Tax Amount Line 1 (Local Currency, Original Company)
PLHF PLHF039 AmtLine1TaxLCUTC MONEY 20 28 8 Recharge Tax Amount Line 1 (Local Currency, Target Company)
PLHF PLHF040 AmtLine2TaxOCU MONEY 20 28 8 Recharge Tax Amount Line 2 (Original Currency)
PLHF PLHF041 AmtLine2TaxLCUOC MONEY 20 28 8 Recharge Tax Amount Line 2 (Local Currency, Original Company)
PLHF PLHF042 AmtLine2TaxLCUTC MONEY 20 28 8 Recharge Tax Amount Line 2 (Local Currency, Target Company)
PLHF PLHF043 AmtLine3TaxOCU MONEY 20 28 8 Recharge Tax Amount Line 3 (Original Currency)
PLHF PLHF044 AmtLine3TaxLCUOC MONEY 20 28 8 Recharge Tax Amount Line 3 (Local Currency, Original Company)
PLHF PLHF045 AmtLine3TaxLCUTC MONEY 20 28 8 Recharge Tax Amount Line 3 (Local Currency, Target Company)
PLHF PLHF046 AmtLine4TaxOCU MONEY 20 28 8 Recharge Tax Amount Line 4 (Original Currency)
PLHF PLHF047 AmtLine4TaxLCUOC MONEY 20 28 8 Recharge Tax Amount Line 4 (Local Currency, Original Company)
PLHF PLHF048 AmtLine4TaxLCUTC MONEY 20 28 8 Recharge Tax Amount Line 4 (Local Currency, Target Company)
PLHF PLHF049 AmtLine5TaxOCU MONEY 20 28 8 Recharge Tax Amount Line 5 (Original Currency)
PLHF PLHF050 AmtLine5TaxLCUOC MONEY 20 28 8 Recharge Tax Amount Line 5 (Local Currency, Original Company)
PLHF PLHF051 AmtLine5TaxLCUTC MONEY 20 28 8 Recharge Tax Amount Line 5 (Local Currency, Target Company)
PLHF PLHF052 AmtLine6TaxOCU MONEY 20 28 8 Recharge Tax Amount Line 6 (Original Currency)
PLHF PLHF053 AmtLine6TaxLCUOC MONEY 20 28 8 Recharge Tax Amount Line 6 (Local Currency, Original Company)
PLHF PLHF054 AmtLine6TaxLCUTC MONEY 20 28 8 Recharge Tax Amount Line 6 (Local Currency, Target Company)
PLHF PLHF055 AmtLine7TaxOCU MONEY 20 28 8 Recharge Tax Amount Line 7 (Original Currency)
PLHF PLHF056 AmtLine7TaxLCUOC MONEY 20 28 8 Recharge Tax Amount Line 7 (Local Currency, Original Company)
PLHF PLHF057 AmtLine7TaxLCUTC MONEY 20 28 8 Recharge Tax Amount Line 7 (Local Currency, Target Company)
PLHF PLHF058 AmtLine8TaxOCU MONEY 20 28 8 Recharge Tax Amount Line 8 (Original Currency)
PLHF PLHF059 AmtLine8TaxLCUOC MONEY 20 28 8 Recharge Tax Amount Line 8 (Local Currency, Original Company)
PLHF PLHF060 AmtLine8TaxLCUTC MONEY 20 28 8 Recharge Tax Amount Line 8 (Local Currency, Target Company)
PLHF PLHF061 AmtLine9TaxOCU MONEY 20 28 8 Recharge Tax Amount Line 9 (Original Currency)
PLHF PLHF062 AmtLine9TaxLCUOC MONEY 20 28 8 Recharge Tax Amount Line 9 (Local Currency, Original Company)
PLHF PLHF063 AmtLine9TaxLCUTC MONEY 20 28 8 Recharge Tax Amount Line 9 (Local Currency, Target Company)
PLHF PLHF064 ServiceFeeOCUTC MONEY 20 28 8 Service Fee (Original Currency, Target Company)
PLHF PLHF065 RechargeAmtOCUTC MONEY 20 28 8 Recharge Amount (Original Currency, Target Company)
PLHF PLHF066 RechIncSFeeOCUTC MONEY 20 28 8 Recharge Amount Including Service Fee (Original Currency, Target Company)
PLHF PLHF067 RechIncSFeeLCUTC MONEY 20 28 8 Recharge Amount Including Service Fee (Local Currency, Target Company)
PLHF PLHF068 RechTotExpTaxOCU MONEY 20 28 8 Recharge Expense Total Tax (Original Currency)
PLHF PLHF069 RechTotExpTaxLCUOC MONEY 20 28 8 Recharge Expense Total Tax (Local Currency, Original Company)
PLHF PLHF070 RechTotExpTaxLCUTC MONEY 20 28 8 Recharge Expense Total Tax (Local Currency, Target Company)
PLHF PLHF071 Spare MONEY 20 28 8 (obsolete)
PLHF PLHF072 Spare MONEY 20 28 8 (obsolete)
PLHF PLHF073 Spare MONEY 20 28 8 (obsolete)
PLHF PLHF074 Spare MONEY 20 28 8 (obsolete)
PLHF PLHF075 Spare MONEY 20 28 8 (obsolete)
PLHF PLHF076 Spare STRING 2 2 0 (obsolete)
PLHF PLHF077 Spare STRING 2 2 0 (obsolete)
PLHF PLHF078 Spare STRING 2 2 0 (obsolete)