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 PN21 PN21001 OperPropNo VSTRING 8 8 0 Proposal Number
PN21 PN21002 NotesType VSTRING 1 1 0 Notes Type
PN21 PN21003 PropCurrCode VSTRING 2 2 0 Proposal Currency Code
PN21 PN21004 PropAmount MONEY 20 28 8 Proposal Amount
PN21 PN21005 CreationDate DATE 8 0 0 Date Created
PN21 PN21006 FirstPrintDate DATE 8 0 0 Date First Printed
PN21 PN21007 ReprintDate DATE 8 0 0 Date Reprinted
PN21 PN21008 UpdDate DATE 8 0 0 Date Updated
PN21 PN21009 ApprovalDate DATE 8 0 0 Date Approved
PN21 PN21010 MinDueDate DATE 8 0 0 Minimum Due Date
PN21 PN21011 MaxDueDate DATE 8 0 0 Maximum Due Date
PN21 PN21012 MinIntNum VSTRING 6 6 0 Minimum Internal Number
PN21 PN21013 MaxIntNum VSTRING 6 6 0 Maximum Internal Number
PN21 PN21014 MinNotStat VSTRING 2 2 0 Minimum Note Status
PN21 PN21015 MaxNotStat VSTRING 2 2 0 Maximum Note Status
PN21 PN21016 MinErsrTyp VSTRING 1 1 0 Minimum Endorser Type
PN21 PN21017 MaxErsrTyp VSTRING 1 1 0 Maximum Endorser Type
PN21 PN21018 MinErsrCod VSTRING 10 10 0 Minimum Endorser Code
PN21 PN21019 MaxErsrCod VSTRING 10 10 0 Maximum Endorser Code
PN21 PN21020 MinErseTyp VSTRING 1 1 0 Minimum Endorsee Type
PN21 PN21021 MaxErseTyp VSTRING 1 1 0 Maximum Endorsee Type
PN21 PN21022 MinErseCod VSTRING 10 10 0 Minimum Endorsee Code
PN21 PN21023 MaxErseCod VSTRING 10 10 0 Maximum Endorsee Code
PN21 PN21024 MinPotfTyp VSTRING 1 1 0 Minimum Portfolio Type
PN21 PN21025 MaxPortfTyp VSTRING 1 1 0 Maximum Portfolio Type
PN21 PN21026 MinPortfNum VSTRING 2 2 0 Minimum Portfolio Number
PN21 PN21027 MaxPortfNum VSTRING 2 2 0 Maximum Portfolio Number
PN21 PN21028 MinPBankCod VSTRING 10 10 0 Minimum Payment Bank Code
PN21 PN21029 MaxPBankCod VSTRING 10 10 0 Maximum Payment Bank Code
PN21 PN21030 MinNotAmt MONEY 20 28 8 Minimum Note Amount
PN21 PN21031 MaxNotAmt MONEY 20 28 8 Maximum Note Amount
PN21 PN21032 LastOpCode VSTRING 2 2 0 Last Operation Code