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 PL01 PL01001 SupplierCode STRING 10 10 0 Supplier Code
PL01 PL01002 SupplierName VSTRING 35 35 0 Supplier Name
PL01 PL01003 AddressLine1 VSTRING 35 35 0 Address Line 1
PL01 PL01004 AddressLine2 VSTRING 35 35 0 Address Line 2
PL01 PL01005 AddressLine3 VSTRING 35 35 0 Address Line 3
PL01 PL01006 Reference VSTRING 20 20 0 Reference
PL01 PL01007 Category VSTRING 4 4 0 Supplier Category
PL01 PL01008 TelephoneNo VSTRING 20 20 0 Telephone Number
PL01 PL01009 TelexNo VSTRING 10 10 0 Telex Number
PL01 PL01010 TelefaxNo VSTRING 20 20 0 Fax Number
PL01 PL01011 CustomerCode VSTRING 20 20 0 Customer Code at Supplier
PL01 PL01012 WayofPayment STRING 2 2 0 Payment Method (Invoices)
PL01 PL01013 BankAccountNoPostalGiro VSTRING 15 15 0 Postal Giro A/C
PL01 PL01014 BankGiroAcc VSTRING 15 15 0 Bank Giro Number
PL01 PL01015 BankAccountNo VSTRING 34 34 0 Bank Account Number
PL01 PL01016 BankOffice VSTRING 25 25 0 Bank Office
PL01 PL01017 AddressSWIFT VSTRING 12 12 0 Bank SWIFT Address
PL01 PL01018 CountryCode VSTRING 3 3 0 Country Code
PL01 PL01019 CompanyInvoicing VSTRING 25 25 0 Factoring Company
PL01 PL01020 InterestLatePayment X_NUMERIC 5 13 8 Interest Rate Late Payment
PL01 PL01021 AccountString ACCSTR 120 120 0 Accounting String
PL01 PL01022 WithHoldingTAXCode VSTRING 8 8 0 Withholding Tax Code
PL01 PL01023 DistrictTAXCode VSTRING 8 8 0 Tax District
PL01 PL01024 Spare VSTRING 8 8 0 Spare
PL01 PL01025 TaxRegNo VSTRING 20 20 0 Tax Registration Number
PL01 PL01026 CurrencyCode VSTRING 2 2 0 Currency Code
PL01 PL01027 LanguageCode VSTRING 3 3 0 Language Code
PL01 PL01028 PaymentTerms VSTRING 2 2 0 Payment Term
PL01 PL01029 DeliveryTerms VSTRING 2 2 0 Delivery Term
PL01 PL01030 WayofDelivery VSTRING 2 2 0 Delivery Method
PL01 PL01031 Balance MONEY 20 28 8 Balance
PL01 PL01032 AmountPurchasePreviosYear MONEY 20 28 8 Purchase Previous Year
PL01 PL01033 AmountPurchaseYTD MONEY 20 28 8 Purchase YTD
PL01 PL01034 AmountPurchasePeriod MONEY 20 28 8 Purchase Period
PL01 PL01035 LatestInvoiceDate DATE 8 0 0 Last Invoice Date
PL01 PL01036 LatestPaymentDate DATE 8 0 0 Last Payment Date
PL01 PL01037 NoteInternal1 VSTRING 25 25 0 Remark Line 1
PL01 PL01038 NoteInternal2 VSTRING 25 25 0 Remark Line 2
PL01 PL01039 PaymentPriority VSTRING 1 1 0 Payment Priority
PL01 PL01040 ScalaCustomerCode VSTRING 10 10 0 Customer Code (iScala)
PL01 PL01041 AlphaSearchKey VSTRING 35 35 0 Search Name
PL01 PL01042 ZipCode VSTRING 10 10 0 Post Code
PL01 PL01043 AccountDefault VSTRING 12 12 0 Standard Cost Account
PL01 PL01044 PaymentBlockFlag VSTRING 1 1 0 Payment Block
PL01 PL01045 AmountPurchaseNextYTD MONEY 20 28 8 Purchase Next year
PL01 PL01046 AmountPurchaseNextPeriod MONEY 20 28 8 Purchase Next period
PL01 PL01047 SupplierImportCode VSTRING 1 1 0 Import Supplier
PL01 PL01048 FiscalCode VSTRING 16 16 0 Company Registration Number
PL01 PL01049 BankCode VSTRING 10 10 0 Bank Code
PL01 PL01050 OrganizationType VSTRING 1 1 0 Organization Type
PL01 PL01051 FlagIncludeOnTAXReport VSTRING 1 1 0 Include in Tax Reports
PL01 PL01052 FlagDeductionOfTAX VSTRING 1 1 0 Deduction of Tax
PL01 PL01053 AddressLine4 VSTRING 35 35 0 Address Line 4
PL01 PL01054 FlagCashMethod VSTRING 1 1 0 Use Cash Method for Tax
PL01 PL01055 DeliveryAddressEDI VSTRING 35 35 0 EDI-Delivery Address Number
PL01 PL01056 TAXCode1 VSTRING 2 2 0 Local Tax Code
PL01 PL01057 AutoAccountCode VSTRING 2 2 0 Accounting Code
PL01 PL01058 ApplicationCode3 VSTRING 2 2 0 Application code 3
PL01 PL01059 WithHoldingTAXRate X_NUMERIC 5 13 8 Withholding Tax Rate
PL01 PL01060 CompleteName VSTRING 200 200 0 Complete Name
PL01 PL01061 InvestmentFeePercent X_NUMERIC 5 13 8 Investment Fee Percent
PL01 PL01062 ReportingFlag VSTRING 1 1 0 1099-Reporting
PL01 PL01063 ReportCode VSTRING 8 8 0 1099-Reporting Code
PL01 PL01064 ABCCode VSTRING 1 1 0 ABC code
PL01 PL01065 PaymentInAdvance VSTRING 12 12 0 Account for Advance Payments
PL01 PL01066 LockSupplierForOrdersFlag SWITCH 1 1 0 Locked for New Order
PL01 PL01067 EDIContractFlag SWITCH 1 1 0 Electronic Partner
PL01 PL01068 InvoiceMergeFlag VSTRING 1 1 0 Merge invoice
PL01 PL01069 BillingCode STRING 4 4 0 Billing Code
PL01 PL01070 DateDueMethodFlag STRING 1 1 0 Date Shifting Method
PL01 PL01071 TAXRoundingMethod STRING 1 1 0 Tax Rounding Method 0 - Standard Scala rounding
1 - Round-up to the nearest integer in currency
2 - Round-down to the nearest integer in currency
3 - Normal rounding
PL01 PL01072 AccountType STRING 1 1 0 Account Type Only used for payment method J1 (Japan):
1 - Saving account.
2 - Checking account.
3 - Deposit at notice.
4 - Time deposit.
5 - Special deposit.
6 - Deposit for tax payment.
7 - Foreign currency deposit.
PL01 PL01073 TransferFeeFlag STRING 1 1 0 Transfer Fee Option Only used for payment method J1 (Japan):
1 - From payer's account
2 - From payment amount
PL01 PL01074 ReceiverName VSTRING 45 45 0 Receivers Name
PL01 PL01075 SupplierCodeforAutopayment VSTRING 15 15 0 Additional Supplier Code for Autopayments
PL01 PL01076 BankBranchCode VSTRING 10 10 0 Bank Branch Code
PL01 PL01077 DepositorName VSTRING 45 45 0 Depositor (Account) name
PL01 PL01078 GlobalID VSTRING 25 25 0 Global Supplier ID
PL01 PL01079 DraftSupplierFlag INTEGER 1 0 0 Draft Supplier
PL01 PL01080 IBANActivationFlag INTEGER 1 0 0 IBAN activation
PL01 PL01081 SupplierType STRING 1 1 0 Supplier Type
PL01 PL01082 AccountForUnauthorizedInvoice STRING 12 12 0 Account Unauthorized Invoice
PL01 PL01083 CalendarCollectionReference INTEGER 9 0 0 Calendar Collection
PL01 PL01084 TaxLiabilityCode STRING 6 6 0 Tax Liability Code
PL01 PL01085 EntityType VSTRING 10 10 0 Legal Entity Type
PL01 PL01086 Spare VSTRING 18 18 0 Tax Type
PL01 PL01087 SubstRegNo VSTRING 20 20 0 Substitution Registration Number
PL01 PL01088 MunicRegNo VSTRING 20 20 0 Municipal Registration Number
PL01 PL01089 StateRegNo VSTRING 20 20 0 State Registration Number
PL01 PL01090 SuppActivType VSTRING 10 10 0 Supplier Activity Type
PL01 PL01091 OperationType VSTRING 10 10 0 Operation Type
PL01 PL01092 FinOperationCode VSTRING 10 10 0 Financial Operation Code
PL01 PL01093 CityCode VSTRING 10 10 0 City Code (Brazil)
PL01 PL01094 CreditWayofPayment STRING 2 2 0 Payment Method (Credit Notes)
PL01 PL01095 LTMGroup STRING 6 6 0 LTM Group Code
PL01 PL01096 Warehouse VSTRING 6 6 0 Warehouse Code
PL01 PL01097 TaxIDType STRING 2 2 0 ID Type
PL01 PL01098 ResponsibilityType STRING 2 2 0 Tax Responsibility Type
PL01 PL01099 Harbour VSTRING 4 4 0 Harbour
PL01 PL01100 Bundesland VSTRING 2 2 0 Bundesland
PL01 PL01101 StatManner VSTRING 6 6 0 Statistical Manner Code
PL01 PL01102 CurrIdentNumber VSTRING 2 2 0 Currency ID Number
PL01 PL01103 ECDepartment VSTRING 2 2 0 EC Department Code
PL01 PL01104 Regime VSTRING 2 2 0 Regime Code
PL01 PL01105 FixPaymentDay1 INTEGER 2 0 0 Fixed Payment Day 1
PL01 PL01106 FixPaymentDay2 INTEGER 2 0 0 Fixed Payment Day 2
PL01 PL01107 FixPaymentDay3 INTEGER 2 0 0 Fixed Payment Day 3
PL01 PL01108 PaymntExcludMonth INTEGER 2 0 0 Month excluded from payment
PL01 PL01109 OriginDate DATE 8 0 0 Origin Date This field should contain the origin date for supplier.
PL01 PL01110 ExcContrCode VSTRING 25 25 0 Excise Control Code Excise Control Code
PL01 PL01111 ExcRegNo VSTRING 25 25 0 Excise Registration Number Excise Registration Number
PL01 PL01112 ExciseDivision VSTRING 25 25 0 Excise Division Excise Division
PL01 PL01113 RegionCode VSTRING 10 10 0 Region Code GEO unit
PL01 PL01114 StateProvinceCode VSTRING 10 10 0 State/Province Code GEO unit
PL01 PL01115 CountyCode VSTRING 10 10 0 County Code GEO unit
PL01 PL01116 CurrencyforDS INTEGER 1 0 0 Currency on Drop shipment order
PL01 PL01117 EmailAddress VSTRING 200 200 0 Email Address
PL01 PL01118 AddressLine5 VSTRING 35 35 0 Address Line 5
PL01 PL01119 AddressLine6 VSTRING 35 35 0 Address Line 6
PL01 PL01120 AddressLine7 VSTRING 35 35 0 Address Line 7
PL01 PL01121 ExtUserDefFld1 VSTRING 150 150 0 Extended User defined 1
PL01 PL01122 ExtUserDefFld2 VSTRING 150 150 0 Extended User defined 2
PL01 PL01123 ExtUserDefFld3 VSTRING 150 150 0 Extended User defined 3
PL01 PL01124 ExtUserDefFld4 VSTRING 150 150 0 Extended User defined 4
PL01 PL01125 ExtUserDefFld5 VSTRING 150 150 0 Extended User defined 5
PL01 PL01126 ExtUserDefFld6 VSTRING 150 150 0 Extended User defined 6
PL01 PL01127 ExtUserDefFld7 VSTRING 150 150 0 Extended User defined 7
PL01 PL01128 ExtUserDefFld8 VSTRING 150 150 0 Extended User defined 8
PL01 PL01129 ExtUserDefFld9 VSTRING 150 150 0 Extended User defined 9
PL01 PL01130 ExtUserDefFld10 VSTRING 150 150 0 Extended User defined 10
PL01 PL01131 ExtUserDefFld11 VSTRING 150 150 0 Extended User defined 11
PL01 PL01132 ExtUserDefFld12 VSTRING 150 150 0 Extended User defined 12
PL01 PL01133 ExtUserDefFld13 VSTRING 150 150 0 Extended User defined 13
PL01 PL01134 ExtUserDefFld14 VSTRING 150 150 0 Extended User defined 14
PL01 PL01135 ExtUserDefFld15 VSTRING 150 150 0 Extended User defined 15
PL01 PL01136 ExtUserDefFld16 VSTRING 150 150 0 Extended User defined 16
PL01 PL01137 ExtUserDefFld17 VSTRING 150 150 0 Extended User defined 17
PL01 PL01138 ExtUserDefFld18 VSTRING 150 150 0 Extended User defined 18
PL01 PL01139 ExtUserDefFld19 VSTRING 150 150 0 Extended User defined 19
PL01 PL01140 ExtUserDefFld20 VSTRING 150 150 0 Extended User defined 20
PL01 PL01141 BIC VSTRING 11 11 0 BIC
PL01 PL01142 BlockingFlags VSTRING 30 30 0 Blocking Flags
PL01 PL01143 CommodityCode VSTRING 35 35 0 Commodity Code
PL01 PL01144 ChargesCode STRING 1 1 0 Charges Code
PL01 PL01145 SUFARMA VSTRING 10 10 0 SUFARMA
PL01 PL01146 GovernmentTableNum STRING 1 1 0 Government Table Number
PL01 PL01147 SpesometroForms VSTRING 12 12 0 Include in Spesometro Form
PL01 PL01148 SummaryDoc STRING 1 1 0 Summary Document
PL01 PL01149 PO3Subtypedeb STRING 2 2 0 Sub Type (Invoices)
PL01 PL01150 PO3Subtypecre STRING 2 2 0 Sub Type (Credit Notes)
PL01 PL01151 MainSupplCode STRING 10 10 0 Main Supplier Code
PL01 PL01152 ChargeBearer VSTRING 4 4 0 Charge Bearer
PL01 PL01153 SplitPayment SWITCH 1 1 0 Split Payment
PL01 PL01154 TaxBankAcc VSTRING 34 34 0 Tax Bank Account
PL01 PL01155 Anonymized SWITCH 1 1 0 Anonymized