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 PL03 PL03001 SupplierCode VSTRING 10 10 0 Supplier Code
2 PL03 PL03002 InvoiceNo VSTRING 25 25 0 Invoice Number
PL03 PL03003 TransactioNo VSTRING 9 9 0 Transaction Number General ledger transaction number for the transaction created when the invoice was created. If the invoice is first entered as an unauthorized invoice, this field will hold the transaction number for the transaction created for the authorized invoice and column PL03018 will hold the transaction number for the authorized invoice transaction.
PL03 PL03004 InvoiceDate DATE 8 0 0 Invoice Date
PL03 PL03005 BookEntrDate DATE 8 0 0 Book-Entry Date Book-entry for the transaction created when the invoice was entered. If the invoice is first entered as an unauthorized invoice, this field will hold the book-entry date for the transaction created for the authorized invoice and column PL03019 will hold the book-entry date for the authorized invoice transaction.
PL03 PL03006 DueDate DATE 8 0 0 Due Date
PL03 PL03007 DiscDate1 DATE 8 0 0 Discount date 1
PL03 PL03008 Discount1 VSTRING 5 5 0 Discount % 1
PL03 PL03009 DiscDate2 DATE 8 0 0 Discount date 2
PL03 PL03010 Discount2 VSTRING 5 5 0 Discount % 2
PL03 PL03011 DiscDate3 DATE 8 0 0 Discount date 3
PL03 PL03012 Discount3 VSTRING 5 5 0 Discount % 3
PL03 PL03013 InvAmoLocCur MONEY 20 28 8 Invoice Amount (Local Currency)
PL03 PL03014 InvAmoOriCur MONEY 20 28 8 Invoice Amount (Invoice Currency)
PL03 PL03015 CurrencyCode VSTRING 2 2 0 Currency Code
PL03 PL03016 SalesTaxAmnt MONEY 20 28 8 Purchase Tax Amount (Local Currency)
PL03 PL03017 AccString ACCSTR 120 120 0 Accounting String
PL03 PL03018 TransNoInvoice VSTRING 9 9 0 Transaction number invoice General ledger transaction number for the transaction created when a invoice is entered as authorized. This field is only used when the invoice is first entered as unauthorized, otherwise column PL03003 is used to store the transaction number for the invoice.
PL03 PL03019 BEDateInv DATE 8 0 0 Book-Entry Date (Invoice) Book-entry date for the transaction created when a invoice is entered as authorized. This field is only used when the invoice is first entered as unauthorized, otherwise column PL03004 is used to store the book-entry date for the invoice.
PL03 PL03020 SupplBankNo VSTRING 10 10 0 Supplier Bank Code
PL03 PL03021 WayOfPayment STRING 2 2 0 Payment Method
PL03 PL03022 PaymBlock VSTRING 1 1 0 Payment Block
PL03 PL03023 AuthorizCod1 VSTRING 5 5 0 Authorization code
PL03 PL03024 CommentaryTx VSTRING 50 50 0 Commentary Text
PL03 PL03025 LatePaymDate DATE 8 0 0 Latest Payment Date
PL03 PL03026 PaidAmounLCU MONEY 20 28 8 Paid Amount (Local Currency)
PL03 PL03027 PaiAmoOriCur MONEY 20 28 8 Paid Amount (Invoice Currency)
PL03 PL03028 PaymentSent VSTRING 1 1 0 Payment sent
PL03 PL03029 PaymPriority VSTRING 1 1 0 Payment Priority
PL03 PL03030 Spare VSTRING 1 1 0 Storno Invoice
PL03 PL03031 VATDiffBooked VSTRING 1 1 0 Tax difference booked
PL03 PL03032 RecurrInvUpd STRING 1 1 0 Recurring invoice updated
PL03 PL03033 PurchOrdNo VSTRING 10 10 0 Order number
PL03 PL03034 TRDateInv DATE 8 0 0 Transaction date invoice
PL03 PL03035 WithHTaxBase MONEY 20 28 8 Withholding Tax Base This field should contain the withholding tax base.
PL03 PL03036 ResVATPaiLCU MONEY 20 28 8 Res payed tax LCU
PL03 PL03037 RecurrInv VSTRING 1 1 0 Recurring Invoice
PL03 PL03038 StateBankCode VSTRING 4 4 0 Central Bank Code
PL03 PL03039 PrelimBooking VSTRING 1 1 0 Unauthorized Flag 0 - The invoice is entered as authorized.
1 - The invoice is only entered as authorized :(Only used in older versions of Scala)
2 - The invoice is only entered as authorized: No book-entry was made for the unauthorized invoices.
3 - The invoice is only entered as authorized: Debit & TAX amounts was booked directly; but cost was book to a control account setup in the automatic account schedule (pos. 24).
4 - The invoice is only entered as authorized: TAX, Debit and Cost are booked to control accounts setup in the automatic account schedule (pos. 23 - 25).
PL03 PL03040 InternRefNo VSTRING 9 9 0 Internal Reference Number
PL03 PL03041 OrigCompCode VSTRING 2 2 0 Original company code
PL03 PL03042 ClearingNLAC VSTRING 12 12 0 Clearing Nominal Ledger account
PL03 PL03043 ReferenComm VSTRING 40 40 0 Payment Text
PL03 PL03044 CurrContract VSTRING 1 1 0 Forward Cover
PL03 PL03045 FixExchgRate X_NUMERIC 10 18 8 Forward cover exchange rate
PL03 PL03046 ContractNo VSTRING 15 15 0 Forward cover contract number
PL03 PL03047 WithHTaxCode VSTRING 8 8 0 With-holding Tax Code
PL03 PL03048 PaymentAuth VSTRING 1 1 0 Payment Authorization Flag
PL03 PL03049 WithholdTaxLocCur MONEY 20 28 8 Withholding Tax Amount (Local Currency)
PL03 PL03050 VATCode VSTRING 2 2 0 Tax Code
PL03 PL03051 AuthoriCode2 VSTRING 5 5 0 Authorization Code 2
PL03 PL03052 TaxCode VSTRING 8 8 0 1099 Tax Code
PL03 PL03053 Amount MONEY 20 28 8 1099 Amount (Local Currency)
PL03 PL03054 RepeatInterval VSTRING 4 4 0 Repeat Interval Specifies the time interval between each recurring invoice where a leading character 'W' means number of weeks, 'M' number of month and without leading character it's number of days.
PL03 PL03055 RepStartDate DATE 8 0 0 Repeat Start Date
PL03 PL03056 RepStopDate DATE 8 0 0 Repeat End Date
PL03 PL03057 RepAmount MONEY 20 28 8 Repeat Amount (Invoice Currency)
PL03 PL03058 RepPercent VSTRING 6 6 0 Repeat %
PL03 PL03059 WHTax X_NUMERIC 5 13 8 Withholding Tax %
PL03 PL03060 VATPaid MONEY 20 28 8 reserved for VAT Paid LCU
PL03 PL03061 FixedExchgRate2 X_NUMERIC 10 18 8 Forward cover exchange rate 2
PL03 PL03062 FixedExchgAlgtm STRING 3 3 0 Forward cover algorithm
PL03 PL03063 ExchgRate1ByAmo X_NUMERIC 10 18 8 Exchange rate 1
PL03 PL03064 ExchgRate2ByAmo X_NUMERIC 10 18 8 Exchange rate 2
PL03 PL03065 ExchgAlgtmByAmo STRING 3 3 0 Exchange rate algorithm
PL03 PL03066 ReferenceNumber VSTRING 25 25 0 International Reference Number
PL03 PL03067 RepCurrCode INTEGER 2 0 0 Reporting currency code
PL03 PL03068 PurchaseOrdAmount MONEY 20 28 8 Purchase order amount
PL03 PL03069 VATDiffAmount MONEY 20 28 8 Tax Difference Amount
PL03 PL03070 AmPaidPNLoc MONEY 20 28 8 Total paid by PN/PDC LCU
PL03 PL03071 AmPaidPNOrig MONEY 20 28 8 Total paid by PN/PDC ICU
PL03 PL03072 PaymPropNo VSTRING 6 6 0 Payment proposal number
PL03 PL03073 SupDivisionCode VSTRING 10 10 0 Supplier Division Code
PL03 PL03074 UnrealizedPrLoss MONEY 20 28 8 Unrealized Profit/Loss
PL03 PL03075 Spare MONEY 20 28 8 <>
PL03 PL03076 OriginalInvoiceNumber VSTRING 25 25 0 Original Invoice Number
PL03 PL03077 InvoicePaidFlag VSTRING 1 1 0 Invoice Paid Flag
PL03 PL03078 OrigTransNum VSTRING 9 9 0 Original Transaction Number
PL03 PL03079 DocumentType STRING 3 3 0 Document Type
PL03 PL03080 TaxLiabilityCode STRING 6 6 0 Tax Liability Code
PL03 PL03081 CFOPCode VSTRING 10 10 0 CFOP Code
PL03 PL03082 OperationType VSTRING 10 10 0 Operation Type
PL03 PL03083 SerialCode VSTRING 10 10 0 Serial code
PL03 PL03084 FiscalTextCode VSTRING 10 10 0 CFOP Fiscal Text Code
PL03 PL03085 CorrectionNumber VSTRING 1 1 0 Correction Number
PL03 PL03086 OrderNo VSTRING 10 10 0 Order number
PL03 PL03087 InvoiceNum VSTRING 25 25 0 Invoice number
PL03 PL03088 InvoiceStatus VSTRING 1 1 0 Invoice status
PL03 PL03089 CashMethod VSTRING 1 1 0 Cash Method
PL03 PL03090 WithholdTaxOriCur MONEY 20 28 8 With-holding Tax Amount ICU
PL03 PL03091 NetInvAmntLCU MONEY 20 28 8 Net Invoice Amount in Local Currency (Brazil)
PL03 PL03092 NetInvAmntOCU MONEY 20 28 8 Net Invoice Amount in Invoice Currency (Brazil)
PL03 PL03093 Instalments SWITCH 1 1 0 Instalment
PL03 PL03094 IssuerCode STRING 6 6 0 Document Issuer Code
PL03 PL03095 IssuerExtCode VSTRING 16 16 0 External Issuer Code
PL03 PL03096 IssuerExpDate DATE 8 0 0 Issuer Expiration Date
PL03 PL03097 POSMachine STRING 1 1 0 POS Machine
PL03 PL03098 TaxNoteNo VSTRING 6 6 0 Tax Note Number External Tax note number must be saved to this field.
PL03 PL03099 TaxNoteRegDate DATE 8 0 0 Tax Note Register Date The date of tax note registration.
PL03 PL03100 DueDateDefinition INTEGER 1 0 0 Due date definition
PL03 PL03101 PaymentTermsCode VSTRING 2 2 0 Payment Term
PL03 PL03102 PaymentTaxLiability STRING 6 6 0 Payment Tax Liability Code PaymentTaxLiabilityCode
PL03 PL03103 PaymentBlockReason INTEGER 3 0 0 Payment Block Reason Code
PL03 PL03104 BrokerSuppliercode VSTRING 10 10 0 Broker Supplier Code
PL03 PL03105 CustomsDeclarationNumber VSTRING 25 25 0 Customs Declaration Number
PL03 PL03106 AdditionalInvoiceFlag INTEGER 1 0 0 Additional Invoice Flag
PL03 PL03107 FiscalKey VSTRING 50 50 0 Fiscal Key
PL03 PL03108 FiscalKeyProtocolNo VSTRING 20 20 0 Fiscal Key Protocol Number
PL03 PL03109 FiscalKeyProtocolDate X_DATETIME 17 0 0 Fiscal Key Protocol Date
PL03 PL03110 ExtUserDefined1 VSTRING 150 150 0 Extended User defined 1
PL03 PL03111 ExtUserDefined2 VSTRING 150 150 0 Extended User defined 2
PL03 PL03112 ExtUserDefined3 VSTRING 150 150 0 Extended User defined 3
PL03 PL03113 ExtUserDefined4 VSTRING 150 150 0 Extended User defined 4
PL03 PL03114 ExtUserDefined5 VSTRING 150 150 0 Extended User defined 5
PL03 PL03115 ExtUserDefined6 VSTRING 150 150 0 Extended User defined 6
PL03 PL03116 ExtUserDefined7 VSTRING 150 150 0 Extended User defined 7
PL03 PL03117 ExtUserDefined8 VSTRING 150 150 0 Extended User defined 8
PL03 PL03118 ExtUserDefined9 VSTRING 150 150 0 Extended User defined 9
PL03 PL03119 ExtUserDefined10 VSTRING 150 150 0 Extended User defined 10
PL03 PL03120 ExtUserDefined11 VSTRING 150 150 0 Extended User defined 11
PL03 PL03121 ExtUserDefined12 VSTRING 150 150 0 Extended User defined 12
PL03 PL03122 ExtUserDefined13 VSTRING 150 150 0 Extended User defined 13
PL03 PL03123 ExtUserDefined14 VSTRING 150 150 0 Extended User defined 14
PL03 PL03124 ExtUserDefined15 VSTRING 150 150 0 Extended User defined 15
PL03 PL03125 ExtUserDefined16 VSTRING 150 150 0 Extended User defined 16
PL03 PL03126 ExtUserDefined17 VSTRING 150 150 0 Extended User defined 17
PL03 PL03127 ExtUserDefined18 VSTRING 150 150 0 Extended User defined 18
PL03 PL03128 ExtUserDefined19 VSTRING 150 150 0 Extended User defined 19
PL03 PL03129 ExtUserDefined20 VSTRING 150 150 0 Extended User defined 20
PL03 PL03130 SpesometroForms VSTRING 12 12 0 Include in Spesometro form
PL03 PL03131 SummaryDoc STRING 1 1 0 Summary Document
PL03 PL03132 PO3Subtype STRING 2 2 0 Sub type
PL03 PL03133 AdjustmNo VSTRING 25 25 0 Adjustment Number (Cancelled Invoice) Adjustment Number (Cancelled Invoice)
PL03 PL03134 AdjustmDate DATE 8 0 0 Adjustment Date (Cancelled Invoice) Adjustment Date (Cancelled Invoice)
PL03 PL03135 AdjustmComment VSTRING 50 50 0 Adjustment Comment (Cancelled Invoice) Adjustment Comment (Cancelled Invoice)
PL03 PL03136 AdjustmCode STRING 2 2 0 Adjustment Code (Cancelled invoice) Adjustment Code (Cancelled Invoice)
PL03 PL03137 PublicProcuremCode1 VSTRING 20 20 0 Public Procurement Code1
PL03 PL03138 PublicProcuremCode2 VSTRING 20 20 0 Public Procurement Code2
PL03 PL03139 TaxDiscFlag SWITCH 1 1 0 Tax discount flag
PL03 PL03140 TaxRegCountry STRING 3 3 0 Tax Registration Country
PL03 PL03141 QRInvoice INTEGER 1 0 0 QR Invoice