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 PN06 PN06001 PortfoliType STRING 1 1 0 Portfolio Type R - Receivable
P - Payable
2 PN06 PN06002 PortfolioNo STRING 2 2 0 Portfolio Number
PN06 PN06003 PortfoliName VSTRING 32 32 0 Portfolio Name
PN06 PN06004 PortfolDescr VSTRING 32 32 0 Portfolio Description
PN06 PN06005 StamDutyProc STRING 10 10 0 Stamp Duty %
PN06 PN06006 StaDutyMinAmnt X_NUMERIC 20 28 8 Stamp Duty Minimum Amount
PN06 PN06007 StaDutyMinCurr VSTRING 2 2 0 Currency Code Stamp Duty Minimum Amount
PN06 PN06008 ColleFeeProc STRING 10 10 0 Collection Fee %
PN06 PN06009 CollFeeMinAm X_NUMERIC 20 28 8 Collection Fee Minimum Amount
PN06 PN06010 CollFeeMinCur STRING 2 2 0 Currency Code Collection Fee Minimum Amount
PN06 PN06011 PortfContrSt ACCSTR 120 120 0 Accounting String Portfolio
PN06 PN06012 StamDutyCoSt ACCSTR 120 120 0 Accounting String Stamp Duty
PN06 PN06013 CollFeeConSt ACCSTR 120 120 0 Accounting String Collection Fee
PN06 PN06014 ProtContrStr ACCSTR 120 120 0 Accounting String Protested
PN06 PN06015 ReseContrStr ACCSTR 120 120 0 Accounting String Reserved
PN06 PN06016 BankContrString ACCSTR 120 120 0 Accounting String Bank
PN06 PN06017 SettRateProf ACCSTR 120 120 0 Accounting String Settlement Profit
PN06 PN06018 SettRateLoss ACCSTR 120 120 0 Accounting String Settlement Loss
PN06 PN06019 RevalProfit ACCSTR 120 120 0 Accounting String Revaluation Profit
PN06 PN06020 RevalueLoss ACCSTR 120 120 0 Accounting String Revaluation Loss
PN06 PN06021 UserGroup STRING 8 8 0 User Group
PN06 PN06022 GracePerLen STRING 10 10 0 Grace Period
PN06 PN06023 GracePerUnit STRING 10 10 0 Grace Period Unit
PN06 PN06024 AcceptPerLen STRING 10 10 0 Acceptance Period
PN06 PN06025 AcceptPerUni STRING 10 10 0 Acceptance Period Unit
PN06 PN06026 ProtestPerLn STRING 10 10 0 Protest Period
PN06 PN06027 ProtestPerUn STRING 10 10 0 Protest Period Unit
PN06 PN06028 ContingLiabLen STRING 10 10 0 Contingent Liability Margin Period
PN06 PN06029 ContingLiabUnit STRING 10 10 0 Contingent Liability Margin Period Unit
PN06 PN06030 BankCode STRING 10 10 0 Bank Code
PN06 PN06031 ProfLossMode STRING 1 1 0 Profit/Loss Mode
PN06 PN06032 PortfCurCode STRING 2 2 0 Currency Code Portfolio
PN06 PN06033 RevaluatMode STRING 1 1 0 Revaluate Mode
PN06 PN06034 SpcExRateReval VSTRING 15 15 0 Special Exchange Rate for Revaluation
PN06 PN06035 OtherContrStr ACCSTR 120 120 0 Accounting String Other