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 PN03 PN03001 PartnerType STRING 1 1 0 Partner Type C - Customer
S - Supplier
X - Extraneous
Y - Temporary
2 PN03 PN03002 PartnerCode STRING 10 10 0 Partner Code
PN03 PN03003 Name VSTRING 35 35 0 Name
PN03 PN03004 Description VSTRING 35 35 0 Description
PN03 PN03005 Address1 VSTRING 35 35 0 Address Line 1
PN03 PN03006 Address2 VSTRING 35 35 0 Address Line 2
PN03 PN03007 Address3 VSTRING 35 35 0 Address Line 3
PN03 PN03008 Address4 VSTRING 35 35 0 Address Line 4
PN03 PN03009 CountryCode STRING 3 3 0 Country Code
PN03 PN03010 TaxNo STRING 10 10 0 Partner Tax Code
PN03 PN03011 PhoneNo VSTRING 20 20 0 Telephone Number
PN03 PN03012 FaxNo VSTRING 20 20 0 Telefax Number
PN03 PN03013 TelexNo VSTRING 10 10 0 Telex Number
PN03 PN03014 ContactPerson VSTRING 35 35 0 Contact Person
PN03 PN03015 NoChequeReceiv STRING 6 6 0 Number of Cheques Received
PN03 PN03016 AmountReceivedC X_NUMERIC 20 28 8 Cheques: Amount Received (Local Currency)
PN03 PN03017 IncludCollectedC STRING 6 6 0 Cheques: Including Collected
PN03 PN03018 AmountCollectedC X_NUMERIC 20 28 8 Cheques: Amount Collected (Local Currency)
PN03 PN03019 IncludReturnedC STRING 6 6 0 Cheques: Including Returned
PN03 PN03020 AmountReturnedC X_NUMERIC 20 28 8 Cheques: Amount Returned (Local Currency)
PN03 PN03021 IncludProtestedC STRING 6 6 0 Cheques: Including Protested
PN03 PN03022 AmountProtestedC X_NUMERIC 20 28 8 Cheques: Amount Protested (Local Currency)
PN03 PN03023 NoPNotesReceive STRING 6 6 0 Number of Notes Received
PN03 PN03024 AmountReceivedN X_NUMERIC 20 28 8 Notes: Amount Received (Local Currency)
PN03 PN03025 IncludCollectedN STRING 6 6 0 Notes: Including Collected
PN03 PN03026 AmountCollectedN X_NUMERIC 20 28 8 Notes: Amount Collected (Local Currency)
PN03 PN03027 IncludReturnedN STRING 6 6 0 Notes: Including Returned
PN03 PN03028 AmountReturnedN X_NUMERIC 20 28 8 Notes: Amount Returned (Local Currency)
PN03 PN03029 IncludProtestedN STRING 6 6 0 Notes: Including Protested
PN03 PN03030 AmountProtestedN X_NUMERIC 20 28 8 Notes: Amount Protested (Local Currency)
PN03 PN03031 AlternatCode STRING 10 10 0 Alternative Code
PN03 PN03032 DefPortfolioCheq STRING 2 2 0 Default Portfolio for Cheques
PN03 PN03033 Spare STRING 1 1 0 (obsolete)
PN03 PN03034 BehavTrcStDt DATE 8 0 0 Start Date Behaviour Tracking
PN03 PN03035 BankAccNo VSTRING 34 34 0 Bank Account Number
PN03 PN03036 CrspBankName VSTRING 35 35 0 Correspondent Bank Name
PN03 PN03037 SearchName VSTRING 35 35 0 Partner Name
PN03 PN03038 CrspBankAcnt VSTRING 34 34 0 Correspondent Bank Account Number
PN03 PN03039 CrspBankAdd1 VSTRING 35 35 0 Correspondent Bank Address Line 1
PN03 PN03040 CrspBankAdd2 VSTRING 35 35 0 Correspondent Bank Address Line 2
PN03 PN03041 CrspBankAdd3 VSTRING 35 35 0 Correspondent Bank Address Line 3
PN03 PN03042 CrspBankAdd4 VSTRING 35 35 0 Correspondent Bank Address Line 4
PN03 PN03043 StateCode VSTRING 15 15 0 State Code
PN03 PN03044 CrspStatCode VSTRING 15 15 0 Correspondent Bank State Code
PN03 PN03045 ZIPCode STRING 10 10 0 Zip Code
PN03 PN03046 TaxCode STRING 10 10 0 Partner Tax Office
PN03 PN03047 DefPortfType STRING 1 1 0 Default Portfolio Type
PN03 PN03048 DefPortfolioNotes STRING 2 2 0 Default Portfolio for Notes
PN03 PN03049 BankCode VSTRING 10 10 0 Bank Code
PN03 PN03050 IBANactivation INTEGER 1 0 0 IBAN Activated
PN03 PN03051 Address5 VSTRING 35 35 0 Address Line 5
PN03 PN03052 Address6 VSTRING 35 35 0 Address Line 6
PN03 PN03053 Address7 VSTRING 35 35 0 Address Line 7
PN03 PN03054 CrspBankAdd5 VSTRING 35 35 0 Correspondent Bank Address Line 5
PN03 PN03055 CrspBankAdd6 VSTRING 35 35 0 Correspondent Bank Address Line 6
PN03 PN03056 CrspBankAdd7 VSTRING 35 35 0 Correspondent Bank Address Line 7
PN03 PN03057 CrspCountryCode VSTRING 3 3 0 Correspondent Country Code