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 PN01 PN01001 CompCodYeInd STRING 4 4 0 Company Year
PN01 PN01002 NoOfPortfoli STRING 2 2 0 (obsolete)
PN01 PN01003 StaStamDutPr STRING 6 6 0 State Stamp Duty %
PN01 PN01004 StaStamDutAm STRING 9 9 0 State Stamp Duty Amount
PN01 PN01005 TCodCusFldRef STRING 3 3 0 Tax Code Customer Field Reference
PN01 PN01006 TCodCusFldLen STRING 3 3 0 Tax Code Customer Field Length
PN01 PN01007 TOffCustFldRef STRING 3 3 0 Tax office Customer File Field Reference
PN01 PN01008 TOffCustFldLen STRING 3 3 0 Tax office Customer File Field Length
PN01 PN01009 TCodSupFldRef STRING 3 3 0 Tax Code Supplier File Field Reference
PN01 PN01010 TCodSupFldLen STRING 3 3 0 Tax Code Supplier File Field Length
PN01 PN01011 TOffSupFldRef STRING 3 3 0 Tax Office Supplier File Field Reference
PN01 PN01012 TOffSupFldLen STRING 3 3 0 Tax Office Supplier File Field Length
PN01 PN01013 Spare STRING 1 1 0 (obsolete)
PN01 PN01014 Spare STRING 1 1 0 (obsolete)
PN01 PN01015 Spare STRING 1 1 0 (obsolete)
PN01 PN01016 RecInpDefStat STRING 2 2 0 Receive from Customer Default Operation
PN01 PN01017 RecOutDefStat STRING 2 2 0 Endorsement to Supplier Default Operation
PN01 PN01018 PayableDefStatus STRING 2 2 0 Own Issue Default Operation
PN01 PN01019 GracePeriLengt STRING 3 3 0 Grace Period
PN01 PN01020 GracePerUnit STRING 1 1 0 Grace Period Unit 0 - Days
1 - Calendar periods
PN01 PN01021 AcceptPerLen STRING 3 3 0 Acceptance Period
PN01 PN01022 AcceptPerUnit STRING 1 1 0 Acceptance Period Unit 0 - Days
1 - Calendar periods
PN01 PN01023 ProtestPerLen STRING 3 3 0 Protest Period
PN01 PN01024 ProtestPerUnt STRING 1 1 0 Protest Period Unit 0 - Days
1 - Calendar periods
PN01 PN01025 ContLiabPerLen STRING 3 3 0 Contingent Liability Margin Period
PN01 PN01026 ContLiabPerUnt STRING 1 1 0 Contingent Liability Margin Period Unit 0 - Days
1 - Calendar periods
PN01 PN01027 StdMonthDay STRING 2 2 0 The Standard Month in Days
PN01 PN01028 Spare STRING 1 1 0 (obsolete)
PN01 PN01029 Spare STRING 1 1 0 (obsolete)
PN01 PN01030 Spare STRING 1 1 0 (obsolete)
PN01 PN01031 Spare STRING 1 1 0 (obsolete)
PN01 PN01032 IntegrWithPL SWITCH 1 1 0 Integrated With Purchase Ledger
PN01 PN01033 IntegrWithSL SWITCH 1 1 0 Integrated With Sales Ledger
PN01 PN01034 Spare SWITCH 1 1 0 (obsolete)
PN01 PN01035 Spare SWITCH 1 1 0 (obsolete)
PN01 PN01036 WghtAveDueDt SWITCH 1 1 0 Weighted Average Due Date
PN01 PN01037 Spare SWITCH 1 1 0 (obsolete)
PN01 PN01038 CheckUniqSN SWITCH 1 1 0 (obsolete)
PN01 PN01039 Spare SWITCH 1 1 0 (obsolete)
PN01 PN01040 Spare SWITCH 1 1 0 (obsolete)
PN01 PN01041 Spare SWITCH 1 1 0 (obsolete)
PN01 PN01042 ShiftSunday STRING 2 2 0 Shift Days for Sunday
PN01 PN01043 ShiftMonday STRING 2 2 0 Shift Days for Monday
PN01 PN01044 ShiftTuesday STRING 2 2 0 Shift Days for Tuesday
PN01 PN01045 ShiftWednesday STRING 2 2 0 Shift Days for Wednesday
PN01 PN01046 ShiftThursday STRING 2 2 0 Shift Days for Thursday
PN01 PN01047 ShiftFriday STRING 2 2 0 Shift Days for Friday
PN01 PN01048 ShiftSaturday STRING 2 2 0 Shift Days for Saturday
PN01 PN01049 SettleBankCode STRING 10 10 0 Settlement Bank Code
PN01 PN01050 StdPortfolioCR STRING 2 2 0 Default Portfolio for Receivable Cheques
PN01 PN01051 StdPortfolioNR STRING 2 2 0 Default Portfolio for Payable Cheques
PN01 PN01052 StdPortfolioCP STRING 2 2 0 Default Portfolio for Receivables Notes
PN01 PN01053 StdPortfolioNP STRING 2 2 0 Default Portfolio for Payable Notes