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 PLPU PLPU001 ProposalNumber STRING 10 10 0 P.K. Field filled from counter
PLPU PLPU002 DueDateAdjust1 INTEGER 3 0 0 Due Date Adjust 1
PLPU PLPU003 DueDateAdjust2 INTEGER 3 0 0 Due Date Adjust 2
PLPU PLPU004 DueDateAdjust3 INTEGER 3 0 0 Due Date Adjust 3
PLPU PLPU005 DueDateAdjust4 INTEGER 3 0 0 Due Date Adjust 4
PLPU PLPU006 DueDateAdjust5 INTEGER 3 0 0 Due Date Adjust 5
PLPU PLPU007 DueDateAdjust6 INTEGER 3 0 0 Due Date Adjust 6
PLPU PLPU008 DueDateAdjust7 INTEGER 3 0 0 Due Date Adjust 7
PLPU PLPU009 DueDateAdjust8 INTEGER 3 0 0 Due Date Adjust 8
PLPU PLPU010 DueDateAdjust9 INTEGER 3 0 0 Due Date Adjust 9
PLPU PLPU011 DueDateAdjust10 INTEGER 3 0 0 Due Date Adjust 10
PLPU PLPU012 PaymentDate DATE 8 0 0 Payment Date
PLPU PLPU013 MaxAmount MONEY 20 28 8 Max Amount
PLPU PLPU014 PaymentMethod STRING 2 2 0 Payment Method
PLPU PLPU015 AltPaymentMethod STRING 2 2 0 Alt. Payment Method
PLPU PLPU016 SuppMin VSTRING 10 10 0 Supplier min
PLPU PLPU017 SuppMax VSTRING 10 10 0 Supplier max
PLPU PLPU018 CategoryMin STRING 4 4 0 Category min
PLPU PLPU019 CategoryMax STRING 4 4 0 Category max
PLPU PLPU020 CurrencyMin STRING 2 2 0 Currency min
PLPU PLPU021 CurrencyMax STRING 2 2 0 Currency max
PLPU PLPU022 SegMin ACCSTR 120 120 0 accounting string
PLPU PLPU023 SegMax ACCSTR 120 120 0 accounting string
PLPU PLPU024 DebitSum MONEY 20 28 8 Debit sum
PLPU PLPU025 SelectedDueDate DATE 8 0 0 Selected Due Date
PLPU PLPU026 SundayPayment INTEGER 2 0 0 Sunday Payment
PLPU PLPU027 SaturdayPayment INTEGER 2 0 0 Saturday Payment
PLPU PLPU028 DirectUseOfCredit INTEGER 2 0 0 Direct use of Credit
PLPU PLPU029 NoPayDate1 DATE 8 0 0 No Pay Date 1
PLPU PLPU030 NoPayDate2 DATE 8 0 0 No Pay Date 2
PLPU PLPU031 NoPayDate3 DATE 8 0 0 No Pay Date 3
PLPU PLPU032 NoPayDate4 DATE 8 0 0 No Pay Date 4
PLPU PLPU033 NoPayDate5 DATE 8 0 0 No Pay Date 5
PLPU PLPU034 NoPayDate6 DATE 8 0 0 No Pay Date 6
PLPU PLPU035 NoPayDate7 DATE 8 0 0 No Pay Date 7
PLPU PLPU036 NoPayDate8 DATE 8 0 0 No Pay Date 8
PLPU PLPU037 NoPayDate9 DATE 8 0 0 No Pay Date 9
PLPU PLPU038 NoPayDate10 DATE 8 0 0 No Pay Date 10
PLPU PLPU039 NoPayDate11 DATE 8 0 0 No Pay Date 11
PLPU PLPU040 NoPayDate12 DATE 8 0 0 No Pay Date 12
PLPU PLPU041 NoPayDate13 DATE 8 0 0 No Pay Date 13
PLPU PLPU042 NoPayDate14 DATE 8 0 0 No Pay Date 14
PLPU PLPU043 NoPayDate15 DATE 8 0 0 No Pay Date 15
PLPU PLPU044 NoPayDate16 DATE 8 0 0 No Pay Date 16
PLPU PLPU045 NoPayDate17 DATE 8 0 0 No Pay Date 17
PLPU PLPU046 NoPayDate18 DATE 8 0 0 No Pay Date 18
PLPU PLPU047 NoPayDate19 DATE 8 0 0 No Pay Date 19
PLPU PLPU048 NoPayDate20 DATE 8 0 0 No Pay Date 20
PLPU PLPU049 NoPayDate21 DATE 8 0 0 No Pay Date 21
PLPU PLPU050 NoPayDate22 DATE 8 0 0 No Pay Date 22
PLPU PLPU051 NoPayDate23 DATE 8 0 0 No Pay Date 23
PLPU PLPU052 NoPayDate24 DATE 8 0 0 No Pay Date 24
PLPU PLPU053 NoPayDate25 DATE 8 0 0 No Pay Date 25
PLPU PLPU054 NoPayDate26 DATE 8 0 0 No Pay Date 26
PLPU PLPU055 NoPayDate27 DATE 8 0 0 No Pay Date 27
PLPU PLPU056 NoPayDate28 DATE 8 0 0 No Pay Date 28
PLPU PLPU057 NoPayDate29 DATE 8 0 0 No Pay Date 29
PLPU PLPU058 NoPayDate30 DATE 8 0 0 No Pay Date 30
PLPU PLPU059 NoPayDate31 DATE 8 0 0 No Pay Date 31
PLPU PLPU060 NoPayDate32 DATE 8 0 0 No Pay Date 32
PLPU PLPU061 NoPayDate33 DATE 8 0 0 No Pay Date 33
PLPU PLPU062 NoPayDate34 DATE 8 0 0 No Pay Date 34
PLPU PLPU063 NoPayDate35 DATE 8 0 0 No Pay Date 35
PLPU PLPU064 NoPayDate36 DATE 8 0 0 No Pay Date 36
PLPU PLPU065 NoPayDate37 DATE 8 0 0 No Pay Date 37
PLPU PLPU066 NoPayDate38 DATE 8 0 0 No Pay Date 38
PLPU PLPU067 NoPayDate39 DATE 8 0 0 No Pay Date 39
PLPU PLPU068 NoPayDate40 DATE 8 0 0 No Pay Date 40
PLPU PLPU069 NoPayDate41 DATE 8 0 0 No Pay Date 41
PLPU PLPU070 NoPayDate42 DATE 8 0 0 No Pay Date 42
PLPU PLPU071 NoPayDate43 DATE 8 0 0 No Pay Date 43
PLPU PLPU072 NoPayDate44 DATE 8 0 0 No Pay Date 44
PLPU PLPU073 NoPayDate45 DATE 8 0 0 No Pay Date 45
PLPU PLPU074 NoPayDate46 DATE 8 0 0 No Pay Date 46
PLPU PLPU075 NoPayDate47 DATE 8 0 0 No Pay Date 47
PLPU PLPU076 NoPayDate48 DATE 8 0 0 No Pay Date 48
PLPU PLPU077 UseSLCredits INTEGER 2 0 0 Use SL Credits
PLPU PLPU078 AllowNegBalance INTEGER 2 0 0 Allow negative balance
PLPU PLPU079 CreditSum MONEY 20 28 8 Credit sum
PLPU PLPU080 UseOtherCurrency INTEGER 2 0 0 Use Other Currency
PLPU PLPU081 PaymentCurrency INTEGER 2 0 0 Payment Currency
PLPU PLPU082 BookDate DATE 8 0 0 Book Date
PLPU PLPU083 DueDateCredit DATE 8 0 0 Due Date Credit
PLPU PLPU084 JournalCode STRING 6 6 0 Journal Code
PLPU PLPU085 TransInClose INTEGER 2 0 0 Trans in Close
PLPU PLPU086 BankCode VSTRING 10 10 0 swiss
PLPU PLPU087 CheckPMBalance INTEGER 2 0 0 Check PM Balance
PLPU PLPU088 DeferOfPayment INTEGER 3 0 0 Defer. of Payment
PLPU PLPU089 Priority1 INTEGER 1 0 0 Priority 1
PLPU PLPU090 Priority2 INTEGER 1 0 0 Priority 2
PLPU PLPU091 Priority3 INTEGER 1 0 0 Priority 3
PLPU PLPU092 Priority4 INTEGER 1 0 0 Priority 4
PLPU PLPU093 Priority5 INTEGER 1 0 0 Priority 5
PLPU PLPU094 Priority6 INTEGER 1 0 0 Priority 6
PLPU PLPU095 Priority7 INTEGER 1 0 0 Priority 7
PLPU PLPU096 Priority8 INTEGER 1 0 0 Priority 8
PLPU PLPU097 Priority9 INTEGER 1 0 0 Priority 9
PLPU PLPU098 PaymentCurrency2 INTEGER 2 0 0 Payment Currency 2
PLPU PLPU099 PaymentCurrencySub-type1 SWITCH 1 1 0 Payment Currency Sub-type 1
PLPU PLPU100 PaymentCurrencySub-type2 SWITCH 1 1 0 Payment Currency Sub-type 2
PLPU PLPU101 PaymentCurrencySub-type3 SWITCH 1 1 0 Payment Currency Sub-type 3
PLPU PLPU102 PaymentCurrencySub-type4 SWITCH 1 1 0 Payment Currency Sub-type 4
PLPU PLPU103 PaymentCurrencySub-type5 SWITCH 1 1 0 Payment Currency Sub-type 5
PLPU PLPU104 PaymentCurrencySub-type6 SWITCH 1 1 0 Payment Currency Sub-type 6
PLPU PLPU105 PaymentCurrencySub-type7 SWITCH 1 1 0 Payment Currency Sub-type 7
PLPU PLPU106 PaymentCurrencySub-type8 SWITCH 1 1 0 Payment Currency Sub-type 8
PLPU PLPU107 PaymentCurrencySub-type9 SWITCH 1 1 0 Payment Currency Sub-type 9
PLPU PLPU108 PaymentCurrencySub-type10 SWITCH 1 1 0 Payment Currency Sub-type 10
PLPU PLPU109 CurrencyCodeSub-type1 INTEGER 2 0 0 Currency Code Sub-type 1
PLPU PLPU110 CurrencyCodeSub-type2 INTEGER 2 0 0 Currency Code Sub-type 2
PLPU PLPU111 CurrencyCodeSub-type3 INTEGER 2 0 0 Currency Code Sub-type 3
PLPU PLPU112 CurrencyCodeSub-type4 INTEGER 2 0 0 Currency Code Sub-type 4
PLPU PLPU113 CurrencyCodeSub-type5 INTEGER 2 0 0 Currency Code Sub-type 5
PLPU PLPU114 CurrencyCodeSub-type6 INTEGER 2 0 0 Currency Code Sub-type 6
PLPU PLPU115 CurrencyCodeSub-type7 INTEGER 2 0 0 Currency Code Sub-type 7
PLPU PLPU116 CurrencyCodeSub-type8 INTEGER 2 0 0 Currency Code Sub-type 8
PLPU PLPU117 CurrencyCodeSub-type9 INTEGER 2 0 0 Currency Code Sub-type 9
PLPU PLPU118 CurrencyCodeSub-type10 INTEGER 2 0 0 Currency Code Sub-type 10
PLPU PLPU119 NotificationEmail VSTRING 120 120 0 Email address for notification
PLPU PLPU120 Spare SWITCH 1 1 0 Spare