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 PLH3 PLH3001 OriginatingCompany STRING 2 2 0 Originating Company
2 PLH3 PLH3002 MainInvSupplCode STRING 10 10 0 Main Invoice Supplier Code
3 PLH3 PLH3003 MainInvNumber STRING 25 25 0 Main Invoice Number
4 PLH3 PLH3004 TargetCompanyCode STRING 2 2 0 Target Company
PLH3 PLH3005 UpdatedFlag SWITCH 1 1 0 Updated
PLH3 PLH3006 CreatedFlag SWITCH 1 1 0 Created
PLH3 PLH3007 RechargeAmount MONEY 20 28 8 Recharge Amount
PLH3 PLH3008 RechargeServiceFee MONEY 20 28 8 Recharge Service Fee
PLH3 PLH3009 SupplierCode VSTRING 10 10 0 Supplier Code
PLH3 PLH3010 InvoiceNo VSTRING 25 25 0 Invoice Number
PLH3 PLH3011 TransactioNo VSTRING 9 9 0 Transaction Number
PLH3 PLH3012 InvoiceDate DATE 8 0 0 Invoice Date
PLH3 PLH3013 BookEntryDate DATE 8 0 0 Book-Entry Date
PLH3 PLH3014 DueDate DATE 8 0 0 Due Date
PLH3 PLH3015 DiscDate1 DATE 8 0 0 Discount Date 1
PLH3 PLH3016 Disc1 VSTRING 5 5 0 Discount 1
PLH3 PLH3017 DiscDate2 DATE 8 0 0 Discount Date 2
PLH3 PLH3018 Disc2 VSTRING 5 5 0 Discount 2
PLH3 PLH3019 DiscDate3 DATE 8 0 0 Discount Date 3
PLH3 PLH3020 Disc3 VSTRING 5 5 0 Discount 3
PLH3 PLH3021 InvAmoLocCur MONEY 20 28 8 Invoice Amount (Local Currency)
PLH3 PLH3022 InvAmoOriCur MONEY 20 28 8 Invoice Amount (Invoice Currency)
PLH3 PLH3023 CurrencyCode VSTRING 2 2 0 Currency Code Invoice
PLH3 PLH3024 SalesTaxAmnt MONEY 20 28 8 Sales Tax Amount (Local Currency)
PLH3 PLH3025 AccString ACCSTR 120 120 0 Accounting String
PLH3 PLH3026 TransNoInvoice VSTRING 9 9 0 Transaction Number Invoice
PLH3 PLH3027 BEDateInv DATE 8 0 0 Book-Entry Date Invoice
PLH3 PLH3028 SupplBankNo VSTRING 10 10 0 Supplier Bank Code
PLH3 PLH3029 WayOfPayment STRING 2 2 0 Payment Method
PLH3 PLH3030 PaymBlock VSTRING 1 1 0 Blocked for Payment
PLH3 PLH3031 AuthorizCod1 VSTRING 5 5 0 Authorization Code 1
PLH3 PLH3032 CommentaryTx VSTRING 50 50 0 Text
PLH3 PLH3033 LatePaymDate DATE 8 0 0 Last Payment Date
PLH3 PLH3034 PaidAmounLCU MONEY 20 28 8 Paid Amount (Local Currency)
PLH3 PLH3035 PaidAmounOriCur MONEY 20 28 8 Paid Amount (Invoice Currency)
PLH3 PLH3036 PaymentSent VSTRING 1 1 0 Payment Sent
PLH3 PLH3037 PaymPriority VSTRING 1 1 0 Payment Priority
PLH3 PLH3038 Spare VSTRING 1 1 0 Red Storno Invoice
PLH3 PLH3039 VATDiffBooked VSTRING 1 1 0 Tax Difference Booked
PLH3 PLH3040 RecurrInvUpd STRING 1 1 0 Recurring Invoice Updated
PLH3 PLH3041 PurchOrdNo VSTRING 10 10 0 Purchase Order Number
PLH3 PLH3042 TRDateInv DATE 8 0 0 Transaction Date Invoice
PLH3 PLH3043 Spare VSTRING 22 22 0 (obsolete)
PLH3 PLH3044 ResVATPaiLCU MONEY 20 28 8 Amount Sent for Payment
PLH3 PLH3045 RecurrInv VSTRING 1 1 0 Recurring Invoice
PLH3 PLH3046 StateBankCode VSTRING 3 3 0 Central Bank Code
PLH3 PLH3047 PrelimBooking VSTRING 1 1 0 Preliminary Booking
PLH3 PLH3048 InternRefNo VSTRING 9 9 0 Internal Reference Number
PLH3 PLH3049 OrigCompCode VSTRING 2 2 0 Original Company Code (Central Ledger)
PLH3 PLH3050 ClearingNLAC VSTRING 12 12 0 Clearing Account (Central Ledger)
PLH3 PLH3051 ReferenComm VSTRING 40 40 0 Reference
PLH3 PLH3052 CurrContract VSTRING 1 1 0 Currency Contract
PLH3 PLH3053 FixExchgRate VSTRING 10 10 0 Fixed Exchange Rate
PLH3 PLH3054 ContractNo VSTRING 15 15 0 Currency Contract Number
PLH3 PLH3055 WithHTaxCode VSTRING 3 3 0 With-holding Tax Code
PLH3 PLH3056 PaymentAuth VSTRING 1 1 0 Pay Unauthorized Invoice
PLH3 PLH3057 WithholdTax VSTRING 20 20 0 With-holding Tax Amount (Local Currency)
PLH3 PLH3058 VATCode VSTRING 2 2 0 VAT Code
PLH3 PLH3059 AuthorizCod2 VSTRING 5 5 0 Authorization Code 2
PLH3 PLH3060 TaxCode VSTRING 8 8 0 1099 Tax Code
PLH3 PLH3061 Amount MONEY 20 28 8 1099 Amount (Local Currency)
PLH3 PLH3062 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.
PLH3 PLH3063 RepStartDate DATE 8 0 0 Repeat Start Date
PLH3 PLH3064 RepStopDate DATE 8 0 0 Repeat Stop Date
PLH3 PLH3065 RepAmount MONEY 20 28 8 Repeat Amount (Invoice Currency)
PLH3 PLH3066 RepPercent VSTRING 6 6 0 Repeat percentage
PLH3 PLH3067 WHTax X_NUMERIC 5 13 8 With-holding Tax
PLH3 PLH3068 VATPaid MONEY 20 28 8 (obsolete)
PLH3 PLH3069 FixedExchgRate2 X_NUMERIC 10 18 8 Fixed Exchange Rate 2
PLH3 PLH3070 FixedExchgAlgtm STRING 3 3 0 Fixed Exchange Algorithm
PLH3 PLH3071 ExchgRate1ByAmo X_NUMERIC 10 18 8 Exchange Rate (by amount)
PLH3 PLH3072 ExchgRate2ByAmo X_NUMERIC 10 18 8 Exchange Rate 2 (by amount)
PLH3 PLH3073 ExchgAlgtmByAmo STRING 3 3 0 Fixed Exchange Algorithm (by amount)
PLH3 PLH3074 ReferenceNumber STRING 20 20 0 Reference Number
PLH3 PLH3075 RepCurrCode INTEGER 2 0 0 Currency Code Reporting
PLH3 PLH3076 PurchaseOrdAmount MONEY 20 28 8 Purchase Order Amount (Reporting Currency)
PLH3 PLH3077 VATDiffAmount MONEY 20 28 8 VAT Difference Amount (Local Currency)
PLH3 PLH3078 AmPaidPNLoc MONEY 20 28 8 Total Paid Amount by PN/PDC (Local Currency)
PLH3 PLH3079 AmPaidPNOrig MONEY 20 28 8 Total Paid Amount by PN/PDC (Invoice Currency)
PLH3 PLH3080 PaymPropNo VSTRING 6 6 0 Payment Proposal Number PN
PLH3 PLH3081 SupDivisionCode VSTRING 10 10 0 Supplier Division Code
PLH3 PLH3082 UnrealizedPrLoss MONEY 20 28 8 Unrealized Profit/Loss
PLH3 PLH3083 Spare MONEY 20 28 8 (obsolete)
PLH3 PLH3084 GlobalLocationCode VSTRING 15 15 0 Global Location Code
PLH3 PLH3085 InvoicePaidFlag VSTRING 1 1 0 Invoice Paid
PLH3 PLH3086 OrigTransNum VSTRING 9 9 0 Original Transaction Number
PLH3 PLH3087 DocumentType STRING 3 3 0 Document Type
PLH3 PLH3088 TaxLiabilityCode STRING 6 6 0 Tax Liability Code
PLH3 PLH3089 CFOPCode VSTRING 10 10 0 CFOP Code
PLH3 PLH3090 OperationType VSTRING 10 10 0 Operation Code
PLH3 PLH3091 SerialCode VSTRING 10 10 0 Serial Invoice Prefix
PLH3 PLH3092 FiscalTextCode VSTRING 10 10 0 Fiscal Text Code
PLH3 PLH3093 Detail VSTRING 1 1 0 Detail
PLH3 PLH3094 OrderNo VSTRING 10 10 0 Order Number
PLH3 PLH3095 InvoiceNum VSTRING 25 25 0 Invoice Number
PLH3 PLH3096 InvoiceStatus VSTRING 1 1 0 Invoice Status
PLH3 PLH3097 CashMethod STRING 1 1 0 Cash Method
PLH3 PLH3098 WithholdTaxOriCur MONEY 20 28 8 WithholdTaxOriCur
PLH3 PLH3099 NetInvAmntLCU MONEY 20 28 8 NetInvAmntLCU
PLH3 PLH3100 NetInvAmntOCU MONEY 20 28 8 NetInvAmntOCU
PLH3 PLH3101 Instalments SWITCH 1 1 0 Instalments
PLH3 PLH3102 IssuerCode STRING 6 6 0 IssuerCode
PLH3 PLH3103 IssuerExtCode VSTRING 16 16 0 IssuerExtCode
PLH3 PLH3104 IssuerExpDate DATE 8 0 0 IssuerExpDate
PLH3 PLH3105 POSMachine STRING 1 1 0 POSMachine
PLH3 PLH3106 TaxNoteNo VSTRING 6 6 0 TaxNoteNo
PLH3 PLH3107 TaxNoteRegDate DATE 8 0 0 TaxNoteRegDate
PLH3 PLH3108 DueDateDefinition INTEGER 1 0 0 Due Date Definition
PLH3 PLH3109 PaymentTermsCode STRING 2 2 0 PaymentTermsCode
PLH3 PLH3110 PaymentTaxLiability STRING 6 6 0 PaymentTaxLiability
PLH3 PLH3111 PaymentBlockReason INTEGER 3 0 0 PaymentBlockReason
PLH3 PLH3112 BrokerSuppliercode VSTRING 10 10 0 Broker Supplier code
PLH3 PLH3113 CustomsDeclarationNumber VSTRING 25 25 0 Customs Declaration Number
PLH3 PLH3114 AdditionalInvoiceFlag INTEGER 1 0 0 Additional Invoice Flag
PLH3 PLH3115 FiscalKey VSTRING 50 50 0 Fiscal Key
PLH3 PLH3116 FiscalKeyProtocolNo VSTRING 20 20 0 Fiscal Key Protocol No
PLH3 PLH3117 FiscalKeyProtocolDate X_DATETIME 17 0 0 Fiscal Key Protocol Date
PLH3 PLH3118 ExtUserdefined1 VSTRING 150 150 0 Ext. User defined 1
PLH3 PLH3119 ExtUserdefined2 VSTRING 150 150 0 Ext. User defined 2
PLH3 PLH3120 ExtUserdefined3 VSTRING 150 150 0 Ext. User defined 3
PLH3 PLH3121 ExtUserdefined4 VSTRING 150 150 0 Ext. User defined 4
PLH3 PLH3122 ExtUserdefined5 VSTRING 150 150 0 Ext. User defined 5
PLH3 PLH3123 ExtUserdefined6 VSTRING 150 150 0 Ext. User defined 6
PLH3 PLH3124 ExtUserdefined7 VSTRING 150 150 0 Ext. User defined 7
PLH3 PLH3125 ExtUserdefined8 VSTRING 150 150 0 Ext. User defined 8
PLH3 PLH3126 ExtUserdefined9 VSTRING 150 150 0 Ext. User defined 9
PLH3 PLH3127 ExtUserdefined10 VSTRING 150 150 0 Ext. User defined 10
PLH3 PLH3128 ExtUserdefined11 VSTRING 150 150 0 Ext. User defined 11
PLH3 PLH3129 ExtUserdefined12 VSTRING 150 150 0 Ext. User defined 12
PLH3 PLH3130 ExtUserdefined13 VSTRING 150 150 0 Ext. User defined 13
PLH3 PLH3131 ExtUserdefined14 VSTRING 150 150 0 Ext. User defined 14
PLH3 PLH3132 ExtUserdefined15 VSTRING 150 150 0 Ext. User defined 15
PLH3 PLH3133 ExtUserdefined16 VSTRING 150 150 0 Ext. User defined 16
PLH3 PLH3134 ExtUserdefined17 VSTRING 150 150 0 Ext. User defined 17
PLH3 PLH3135 ExtUserdefined18 VSTRING 150 150 0 Ext. User defined 18
PLH3 PLH3136 ExtUserdefined19 VSTRING 150 150 0 Ext. User defined 19
PLH3 PLH3137 ExtUserdefined20 VSTRING 150 150 0 Ext. User defined 20
PLH3 PLH3138 SpesometroForms VSTRING 12 12 0 Spesometro Forms
PLH3 PLH3139 SummaryDocument STRING 1 1 0 Summary Document
PLH3 PLH3140 PO3Subtype STRING 2 2 0 PO3 Sub type
PLH3 PLH3141 AdjustmNo VSTRING 15 15 0 Adjustment Number Adjustment Number (Cancelled Invoice)
PLH3 PLH3142 AdjustmDate DATE 8 0 0 Adjustment Date Adjustment Date (Cancelled Invoice)
PLH3 PLH3143 AdjustmComment VSTRING 50 50 0 Adjustment Comment Adjustment Comment (Cancelled Invoice)
PLH3 PLH3144 AdjustmCode STRING 2 2 0 Adjustment Code Adjustment Code (Cancelled Invoice)
PLH3 PLH3145 PublicProcuremCode1 VSTRING 20 20 0 Public Procurement Code1
PLH3 PLH3146 PublicProcuremCode2 VSTRING 20 20 0 Public Procurement Code2