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 PL17 PL17001 InvoiceNo VSTRING 25 25 0 Invoice Number
2 PL17 PL17002 CustomerCode VSTRING 10 10 0 Supplier Code
3 PL17 PL17003 TransType VSTRING 1 1 0 Transaction Type X - Tax transaction created at the time of invoice (To be used for non cash tax method).
Y - Tax transaction created at the time of payment. (To be used for cash tax method).
Z - Tax transaction for tax portion of discount for early payments.
(Note that both X and Y transaction type are created regardless if you use cash method or not).
6 PL17 PL17004 TaxCodeTaxRate VSTRING 2 2 0 VAT Code
7 PL17 PL17005 LineNo VSTRING 7 7 0 Line Number
8 PL17 PL17006 TransDate DATE 8 0 0 Transaction Date
PL17 PL17007 InvoiceDate DATE 8 0 0 Invoice Date
PL17 PL17008 BaseAmount MONEY 20 28 8 Base Amount (Local Currency)
PL17 PL17009 TaxAmount MONEY 20 28 8 Tax Amount (Local Currency)
PL17 PL17010 Remark VSTRING 4 4 0 Remark
PL17 PL17011 TransNo VSTRING 9 9 0 Invoice Reference Number
PL17 PL17012 CashMethod VSTRING 1 1 0 Cash Method
PL17 PL17013 Deductable VSTRING 6 6 0 Deductible
PL17 PL17014 ExpandedMacro VSTRING 1 1 0 Expanded Macro
PL17 PL17015 Reported VSTRING 1 1 0 Reported
PL17 PL17016 DeductibleAm MONEY 20 28 8 Deductible Amount
PL17 PL17017 BookedCostAmount MONEY 20 28 8 Booked Cost Amount
PL17 PL17018 VATDiffAmount MONEY 20 28 8 VAT Difference Amount
9 PL17 PL17019 TransactionNoLineNo VSTRING 9 9 0 Transaction Number
5 PL17 PL17020 TaxType STRING 6 6 0 Tax Type
PL17 PL17021 TaxLiability STRING 6 6 0 Tax Liability Code
4 PL17 PL17022 TaxCode STRING 6 6 0 Tax Code
PL17 PL17023 DocumentType STRING 3 3 0 Document Type
PL17 PL17024 TaxClassification STRING 2 2 0 Tax Classification
PL17 PL17025 TaxCertificate VSTRING 15 15 0 Tax Certificate
PL17 PL17026 TaxCertifFlag STRING 1 1 0 Tax Certificate Print Status
PL17 PL17027 PaymentNumber STRING 2 2 0 Payment Number
PL17 PL17028 PaymentSubNumber STRING 2 2 0 Payment Sub Number
PL17 PL17029 StockItem VSTRING 35 35 0 Stock Item Code
PL17 PL17030 OrigBatchNumber VSTRING 12 12 0 Batch Number
PL17 PL17031 TaxRate X_NUMERIC 12 20 8 Tax Rate
PL17 PL17032 TaxCalcMethod INTEGER 2 0 0 Tax Calculation Method Used for tax engine 1 and 2 (see SYL1003 for details)
PL17 PL17033 RateType STRING 1 1 0 Rate Type Used for tax engine 1 and 2 (see SYL1006 for details)
PL17 PL17034 TaxBaseType INTEGER 2 0 0 Tax Base Type Used for tax engine 1 and 2 (see SYL1004 for details)
PL17 PL17035 TaxExemption STRING 2 2 0 Tax Exemption Used for tax engine 1 and 2 (see PLL1006 for details)
PL17 PL17036 TaxExemptionRate X_NUMERIC 12 20 8 Tax Exemption Rate
PL17 PL17037 PurchOrderNo VSTRING 10 10 0 Purchase Order Number
PL17 PL17038 FiscTextCode VSTRING 10 10 0 Fiscal Text Code
PL17 PL17039 TributarySitCode VSTRING 10 10 0 Tributary Situation Code
PL17 PL17040 CVFCode VSTRING 10 10 0 CVF Code
PL17 PL17041 STBaseAmount MONEY 20 28 8 Exemption Amount (Local Currency)
PL17 PL17042 STTaxAmount MONEY 20 28 8 Tributary Substitution Amount (Local Currency)
PL17 PL17043 TaxCategory VSTRING 10 10 0 Tax Category
PL17 PL17044 OriginalCompany VSTRING 2 2 0 Original Company
PL17 PL17045 MarginPercent X_NUMERIC 12 20 8 Margin %
PL17 PL17046 FixedPrice MONEY 20 28 8 Fixed Price (Local Currency)
PL17 PL17047 AcceptedDifference X_NUMERIC 12 20 8 Accepted Difference %
PL17 PL17048 ResolutionName VSTRING 40 40 0 Resolution Name
PL17 PL17049 ResolutionDate DATE 8 0 0 Resolution Date
PL17 PL17050 InvoiceRefer VSTRING 25 25 0 InvoiceRefer This field can be filled in the records related to the Prepayments.
The reference to Invoice for the same customer code must be added for all “compensative” prepayment tax records.
PL17 PL17051 OrigCurrCode VSTRING 2 2 0 Original Currency Code This field should contain the original currency code.
PL17 PL17052 BaseAmountOCU MONEY 20 28 8 Base Amount (Original Currency) This field should contain the tax base amount in original currency.
PL17 PL17053 TaxSlipNo VSTRING 15 15 0 Tax Slip No This field should contain the purchase tax slip number.
PL17 PL17054 TaxSlipLine VSTRING 6 6 0 Tax Slip Line This field should contain the purchase tax slip line.
PL17 PL17055 AccountingInfo ACCSTR 120 120 0 Accounting Info
PL17 PL17056 LineReference VSTRING 7 7 0 Line Reference
PL17 PL17057 FinYear VSTRING 4 4 0 Financial Year
PL17 PL17058 RefGL06 VSTRING 9 9 0 Ref GL06
PL17 PL17059 DirectfromGL VSTRING 1 1 0 Direct from GL
PL17 PL17060 IssuerCode STRING 6 6 0 Issuer Code Issuer Code
PL17 PL17061 OrderLineNo STRING 10 10 0 Order Line Number Order Line Number
PL17 PL17062 AASCode VSTRING 25 25 0 AAS code
PL17 PL17063 ThirdPartySupplier VSTRING 10 10 0 ThirdPartySupplier ThirdPartySupplier
PL17 PL17064 ProRataAmount MONEY 20 28 8 ProRataAmount Italian functionality to story VAT deductible
PL17 PL17065 ReferSLInvoice VSTRING 25 25 0 Reference to SL Invoice
PL17 PL17066 CertificateDate DATE 8 0 0 Certificate Date
PL17 PL17067 NonDeductAm MONEY 20 28 8 Non Deductible Amount
PL17 PL17068 OrderSubLineNo VSTRING 6 6 0 OrderSubLineNo OrderSubLineNo
PL17 PL17069 ActualTaxBase MONEY 20 28 8 Actual Tax Base
PL17 PL17070 ActualTaxRate X_NUMERIC 12 20 8 Actual Tax Rate
PL17 PL17071 DestinationRate X_NUMERIC 8 16 8 Destination Rate
PL17 PL17072 CostType STRING 2 2 0 Cost Type
PL17 PL17073 HMRCPeriodKey VSTRING 4 4 0 HMRC Period Key Key of HMRC period to which this transaction line is included.
PL17 PL17074 TaxRegCountry STRING 3 3 0 Tax Registration Country
PL17 PL17075 Specification STRING 3 3 0 Specification
PL17 PL17076 Notification STRING 3 3 0 Notification