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 PL19 PL19001 SupplierCode STRING 10 10 0 Supplier Template Code
PL19 PL19002 SupplierName VSTRING 35 35 0 Supplier Name
PL19 PL19003 AddressLine1 VSTRING 35 35 0 Address Line 1
PL19 PL19004 AddressLine2 VSTRING 35 35 0 Address Line 2
PL19 PL19005 AddressLine3 VSTRING 35 35 0 Address Line 3
PL19 PL19006 Reference VSTRING 20 20 0 Reference
PL19 PL19007 Category VSTRING 4 4 0 Supplier Category
PL19 PL19008 TelephonNo VSTRING 20 20 0 Telephone Number
PL19 PL19009 TelexNo VSTRING 10 10 0 Telex Number
PL19 PL19010 TelefaxNo VSTRING 20 20 0 Telefax Number
PL19 PL19011 CusomerCod VSTRING 20 20 0 Customer Code at Supplier
PL19 PL19012 WayOfPayment STRING 2 2 0 Payment Method
PL19 PL19013 PostalGiroAC VSTRING 15 15 0 Bank Account Postal Giro
PL19 PL19014 BankGiroAC VSTRING 15 15 0 Bank Account Bank Giro
PL19 PL19015 BankAccNo VSTRING 34 34 0 Bank Account Number
PL19 PL19016 BankOffice VSTRING 25 25 0 Bank Office
PL19 PL19017 SWIFTAddress VSTRING 12 12 0 Bank SWIFT Address
PL19 PL19018 CountryCode VSTRING 3 3 0 Country Code
PL19 PL19019 InvoicingCompany VSTRING 25 25 0 Factoring Company Name
PL19 PL19020 InterLatePayment X_NUMERIC 5 13 8 Interest Rate Late Payment
PL19 PL19021 AccString ACCSTR 120 120 0 Accounting String
PL19 PL19022 WithHoldTaxCode VSTRING 8 8 0 Withholding Tax Code
PL19 PL19023 DistrictTaxCode VSTRING 8 8 0 Tax District
PL19 PL19024 Spare VSTRING 8 8 0 (obsolete)
PL19 PL19025 TaxRegNo VSTRING 20 20 0 Tax Registration Number
PL19 PL19026 CurrencyCode VSTRING 2 2 0 Currency Code
PL19 PL19027 LanguageCode VSTRING 3 3 0 Language
PL19 PL19028 PaymentTerm VSTRING 2 2 0 Payment Terms
PL19 PL19029 DeliveryTerm VSTRING 2 2 0 Delivery Terms
PL19 PL19030 DeliveryWay VSTRING 2 2 0 Delivery Method
PL19 PL19031 Balance MONEY 20 28 8 Balance
PL19 PL19032 PurchPreYear MONEY 20 28 8 Purchases Previous Year
PL19 PL19033 PurchaseYTD MONEY 20 28 8 Purchases YTD
PL19 PL19034 PurchPeriod MONEY 20 28 8 Purchases Period
PL19 PL19035 LastInvDate DATE 8 0 0 Last Invoice Date
PL19 PL19036 LastPaymDate DATE 8 0 0 Last Payment Date
PL19 PL19037 InternNote1 VSTRING 25 25 0 Remark Line 1
PL19 PL19038 InternNote2 VSTRING 25 25 0 Remark Line 2
PL19 PL19039 PaymentPriority VSTRING 1 1 0 Payment Priority
PL19 PL19040 ScalaCusCode VSTRING 10 10 0 Customer Code (Scala)
PL19 PL19041 AlphaSrchKey VSTRING 35 35 0 Supplier Search Key
PL19 PL19042 ZipCode VSTRING 10 10 0 Zip Code
PL19 PL19043 DefNomLedAC VSTRING 12 12 0 Standard Cost Account
PL19 PL19044 PaymentBlock VSTRING 1 1 0 Payment Block
PL19 PL19045 PurchNextYTD MONEY 20 28 8 Purchases Next YTD
PL19 PL19046 PurchNextPer MONEY 20 28 8 Purchases Next Period
PL19 PL19047 ImportSupCod VSTRING 1 1 0 Import Supplier
PL19 PL19048 FiscalCode VSTRING 16 16 0 Company Registration Number
PL19 PL19049 BankCode VSTRING 10 10 0 Bank Code
PL19 PL19050 OrganizaType VSTRING 1 1 0 Organization Type
PL19 PL19051 IncOnTaxRep VSTRING 1 1 0 Include in Tax Reports
PL19 PL19052 DeductiOfTax VSTRING 1 1 0 Deduction of Tax
PL19 PL19053 AddressLine4 VSTRING 35 35 0 Address Line 4
PL19 PL19054 CshMetSalTax VSTRING 1 1 0 Use Cash Method for Tax
PL19 PL19055 DelivAddrNo VSTRING 35 35 0 EDI-Delivery Address Number
PL19 PL19056 VATCode1 VSTRING 2 2 0 Vat Code
PL19 PL19057 AutoAccCode VSTRING 2 2 0 Accounting Code
PL19 PL19058 ApplicaCode3 VSTRING 2 2 0 (obsolete)
PL19 PL19059 WithHoldTaxRate X_NUMERIC 5 13 8 With-holding Tax Rate
PL19 PL19060 CompleteName VSTRING 200 200 0 Complete Name
PL19 PL19061 InvestmenFee X_NUMERIC 5 13 8 Investment Fee Percent
PL19 PL19062 Reporting VSTRING 1 1 0 1099-Reporting
PL19 PL19063 RepCode VSTRING 8 8 0 1099-Reporting Code
PL19 PL19064 ABCCode VSTRING 1 1 0 ABC Code
PL19 PL19065 PaymInAdvance VSTRING 12 12 0 Account for Advance Payments
PL19 PL19066 LckSuppForOrders SWITCH 1 1 0 Locked for New Order
PL19 PL19067 EDIContractSwitch SWITCH 1 1 0 Electronic Partner
PL19 PL19068 MergeInvoice VSTRING 1 1 0 Merge Invoice
PL19 PL19069 BillingCode STRING 4 4 0 Billing Terms
PL19 PL19070 DueDateMeth STRING 1 1 0 Due Date Shift Method
PL19 PL19071 TaxRoundMeth STRING 1 1 0 Tax Rounding Method
PL19 PL19072 AccountType STRING 1 1 0 Account Type
PL19 PL19073 TransferFee STRING 1 1 0 Transfer Fee
PL19 PL19074 ReceiversName VSTRING 45 45 0 Receivers Name
PL19 PL19075 AutopaySupCode VSTRING 15 15 0 Additional Supplier Code for Automatic Payments
PL19 PL19076 BankBranchCode VSTRING 10 10 0 Bank Branch Code
PL19 PL19077 DepositorName VSTRING 45 45 0 Depositor Account Name
PL19 PL19078 GlobalID VSTRING 25 25 0 Global Supplier ID
PL19 PL19079 DraftSpplier INTEGER 1 0 0 Draft Supplier
PL19 PL19080 IBANactivation INTEGER 1 0 0 IBAN Activation
PL19 PL19081 SupplierType STRING 1 1 0 Supplier Type
PL19 PL19082 AccountPreliminaryCost STRING 12 12 0 Account Unauthorized Invoice
PL19 PL19083 CalendarColRef INTEGER 9 0 0 Calendar Collection
PL19 PL19084 TaxLiabilityCode STRING 6 6 0 Tax Liability Code
PL19 PL19085 EntityType VSTRING 10 10 0 EntityType
PL19 PL19086 Spare VSTRING 18 18 0 Spare
PL19 PL19087 SubstRegNo VSTRING 20 20 0 Substitution Registration Number
PL19 PL19088 MunicRegNo VSTRING 20 20 0 Municipal Registration Number
PL19 PL19089 StateRegNo VSTRING 20 20 0 State Registration Number
PL19 PL19090 SuppActivType VSTRING 10 10 0 Supplier Activity Type
PL19 PL19091 OperationType VSTRING 10 10 0 Operation Type
PL19 PL19092 FinOperationCode VSTRING 10 10 0 Financial Operation Code
PL19 PL19093 CityCode VSTRING 10 10 0 City Code
PL19 PL19094 CreditWayofPayment STRING 2 2 0 CreditWayofPayment
PL19 PL19095 LTMGroup STRING 6 6 0 LTM Group
PL19 PL19096 Warehouse VSTRING 6 6 0 Warehouse code
PL19 PL19097 TaxIDType STRING 2 2 0 TaxIDType
PL19 PL19098 ResponsibilityType STRING 2 2 0 ResponsibilityType
PL19 PL19099 Harbour VSTRING 4 4 0 Harbour
PL19 PL19100 Bundesland VSTRING 2 2 0 Bundesland
PL19 PL19101 StatManner VSTRING 6 6 0 StatManner
PL19 PL19102 CurrIdentNumber VSTRING 2 2 0 CurrIdentNumber
PL19 PL19103 ECDepartment VSTRING 2 2 0 ECDepartment
PL19 PL19104 Regime VSTRING 2 2 0 Regime
PL19 PL19105 FixPaymentDay1 INTEGER 2 0 0 FixPaymentDay1
PL19 PL19106 FixPaymentDay2 INTEGER 2 0 0 FixPaymentDay2
PL19 PL19107 FixPaymentDay3 INTEGER 2 0 0 FixPaymentDay3
PL19 PL19108 PaymntExcludMonth INTEGER 2 0 0 PaymntExcludMonth
PL19 PL19109 OriginDate DATE 8 0 0 Origin Date This field should contain the origin date for supplier.
PL19 PL19110 ExcContrCode VSTRING 25 25 0 Excise Control Code Excise Control Code
PL19 PL19111 ExcRegNo VSTRING 25 25 0 Excise Registration Number Excise Registration Number
PL19 PL19112 ExciseDivision VSTRING 25 25 0 Excise Division Excise Division
PL19 PL19113 RegionCode VSTRING 10 10 0 Region Code GEO unit
PL19 PL19114 StateProvinceCode VSTRING 10 10 0 State/Province Code GEO unit
PL19 PL19115 CountyCode VSTRING 10 10 0 County Code GEO unit
PL19 PL19116 CurrencyforDS INTEGER 1 0 0 Currency for DS
PL19 PL19117 EmailAddress VSTRING 200 200 0 Email address
PL19 PL19118 AddressLine5 VSTRING 35 35 0 Address Line 5
PL19 PL19119 AddressLine6 VSTRING 35 35 0 Address Line 6
PL19 PL19120 AddressLine7 VSTRING 35 35 0 Address Line 7
PL19 PL19121 ExtUserDefFld1 VSTRING 150 150 0 Ext. User defined field 1
PL19 PL19122 ExtUserDefFld2 VSTRING 150 150 0 Ext. User defined field 2
PL19 PL19123 ExtUserDefFld3 VSTRING 150 150 0 Ext. User defined field 3
PL19 PL19124 ExtUserDefFld4 VSTRING 150 150 0 Ext. User defined field 4
PL19 PL19125 ExtUserDefFld5 VSTRING 150 150 0 Ext. User defined field 5
PL19 PL19126 ExtUserDefFld6 VSTRING 150 150 0 Ext. User defined field 6
PL19 PL19127 ExtUserDefFld7 VSTRING 150 150 0 Ext. User defined field 7
PL19 PL19128 ExtUserDefFld8 VSTRING 150 150 0 Ext. User defined field 8
PL19 PL19129 ExtUserDefFld9 VSTRING 150 150 0 Ext. User defined field 9
PL19 PL19130 ExtUserDefFld10 VSTRING 150 150 0 Ext. User defined field 10
PL19 PL19131 ExtUserDefFld11 VSTRING 150 150 0 Ext. User defined field 11
PL19 PL19132 ExtUserDefFld12 VSTRING 150 150 0 Ext. User defined field 12
PL19 PL19133 ExtUserDefFld13 VSTRING 150 150 0 Ext. User defined field 13
PL19 PL19134 ExtUserDefFld14 VSTRING 150 150 0 Ext. User defined field 14
PL19 PL19135 ExtUserDefFld15 VSTRING 150 150 0 Ext. User defined field 15
PL19 PL19136 ExtUserDefFld16 VSTRING 150 150 0 Ext. User defined field 16
PL19 PL19137 ExtUserDefFld17 VSTRING 150 150 0 Ext. User defined field 17
PL19 PL19138 ExtUserDefFld18 VSTRING 150 150 0 Ext. User defined field 18
PL19 PL19139 ExtUserDefFld19 VSTRING 150 150 0 Ext. User defined field 19
PL19 PL19140 ExtUserDefFld20 VSTRING 150 150 0 Ext. User defined field 20
PL19 PL19141 BIC VSTRING 11 11 0 BIC
PL19 PL19142 BlockingFlags VSTRING 30 30 0 Blocking Flags
PL19 PL19143 CommodityCode VSTRING 35 35 0 Commodity code
PL19 PL19144 ChargesCode STRING 1 1 0 Charges code
PL19 PL19145 SUFARMA VSTRING 10 10 0 SUFARMA
PL19 PL19146 GovernmentTableNum STRING 1 1 0 Government Table number
PL19 PL19147 SpesometroForms VSTRING 12 12 0 Spesometro Forms
PL19 PL19148 SummaryDoc STRING 1 1 0 Summary Document
PL19 PL19149 PO3Subtypedeb STRING 2 2 0 PO3 Sub type deb
PL19 PL19150 PO3Subtypecre STRING 2 2 0 PO3 Sub type cre
PL19 PL19151 MainSupplCode STRING 10 10 0 Main Supplier Code
PL19 PL19152 ChargeBearer VSTRING 4 4 0 Charge Bearer
PL19 PL19153 SplitPayment SWITCH 1 1 0 Split Payment
PL19 PL19154 TaxBankAcc VSTRING 34 34 0 Tax Bank Account
PL19 PL19155 Anonymized SWITCH 1 1 0 Anonymized