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
PN01 Promissory Notes Parameters Company Year PN010112
PN02 Promissory Notes Company PN020100
PN03 Partners Company PN030100
PN04 Promissory Notes Transactions Company PN040100
PN06 Portfolios Company PN060100
PN08 Operations Company PN080100
PN13 Promissory Notes Text Parameters Company PN130100
PN14 Promissory Notes Report Library Company PN140100
PN17 PN17 Reval.Work Company PN170100
PN19 PN19 Bal.Rep.Work Company PN190100
PN20 Promissory Notes Invoice References Company PN200100
PN21 Promissory Notes Operation Proposal Header Company PN210100
PN23 PN Deemed Settlement work file PN230000

Fields
PK Table Name Description Type Length Precision Note
1 PN20 PN20001 CustSuppCode VSTRING 10 10 0 Customer/Supplier Code
2 PN20 PN20002 InvoiceNo VSTRING 25 25 0 Invoice Number
3 PN20 PN20003 PaymNo VSTRING 6 6 0 Payment Number
5 PN20 PN20004 PNDocType STRING 2 2 0 Promissory Note Document Type
6 PN20 PN20005 PNIntNo STRING 6 6 0 Promissory Note Internal Number
PN20 PN20006 PNPaymAmLoc MONEY 20 28 8 Paid Amount (Local Currency)
PN20 PN20007 PNPaymAmOrig MONEY 20 28 8 Paid Amount (Payment Currency)
4 PN20 PN20008 SubLineNoPL VSTRING 2 2 0 Payment Sub-line Number
7 PN20 PN20009 LedgerCode STRING 2 2 0 Ledger Code SL - Sales Ledger
PL - Purchase Ledger