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 PN13 PN13001 CompanyCode STRING 4 4 0 Company Code
PN13 PN13002 CompanyInfo1 VSTRING 32 32 0 Company Information Line 1
PN13 PN13003 CompanyInfo2 VSTRING 32 32 0 Company Information Line 2
PN13 PN13004 CompanyInfo3 VSTRING 32 32 0 Company Information Line 3
PN13 PN13005 CompanyInfo4 VSTRING 32 32 0 Company Information Line 4
PN13 PN13006 CompanTaxOff STRING 10 10 0 Company Tax Office
PN13 PN13007 CompaTaxCode STRING 10 10 0 Company Tax Code
PN13 PN13008 Stat00Text1 VSTRING 15 15 0 Status 00 Text Line 1
PN13 PN13009 Stat00Text2 VSTRING 15 15 0 Status 00 Text Line 2
PN13 PN13010 Stat01Text1 VSTRING 15 15 0 Status 01 Text Line 1
PN13 PN13011 Stat01Text2 VSTRING 15 15 0 Status 01 Text Line 2
PN13 PN13012 Stat02Text1 VSTRING 15 15 0 Status 02 Text Line 1
PN13 PN13013 Stat02Text2 VSTRING 15 15 0 Status 02 Text Line 2
PN13 PN13014 Stat03Text1 VSTRING 15 15 0 Status 03 Text Line 1
PN13 PN13015 Stat03Text2 VSTRING 15 15 0 Status 03 Text Line 2
PN13 PN13016 Stat04Text1 VSTRING 15 15 0 Status 04 Text Line 1
PN13 PN13017 Stat04Text2 VSTRING 15 15 0 Status 04 Text Line 2
PN13 PN13018 Stat05Text1 VSTRING 15 15 0 Status 05 Text Line 1
PN13 PN13019 Stat05Text2 VSTRING 15 15 0 Status 05 Text Line 2
PN13 PN13020 Stat06Text1 VSTRING 15 15 0 Status 06 Text Line 1
PN13 PN13021 Stat06Text2 VSTRING 15 15 0 Status 06 Text Line 2
PN13 PN13022 Stat07Text1 VSTRING 15 15 0 Status 07 Text Line 1
PN13 PN13023 Stat07Text2 VSTRING 15 15 0 Status 07 Text Line 2
PN13 PN13024 Stat08Text1 VSTRING 15 15 0 Status 08 Text Line 1
PN13 PN13025 Stat08Text2 VSTRING 15 15 0 Status 08 Text Line 2
PN13 PN13026 Stat09Text1 VSTRING 15 15 0 Status 09 Text Line 1
PN13 PN13027 Stat09Text2 VSTRING 15 15 0 Status 09 Text Line 2
PN13 PN13028 Stat10Text1 VSTRING 15 15 0 Status 10 Text Line 1
PN13 PN13029 Stat10Text2 VSTRING 15 15 0 Status 10 Text Line 2
PN13 PN13030 Stat11Text1 VSTRING 15 15 0 Status 11 Text Line 1
PN13 PN13031 Stat11Text2 VSTRING 15 15 0 Status 11 Text Line 2
PN13 PN13032 Stat12Text1 VSTRING 15 15 0 Status 12 Text Line 1
PN13 PN13033 Stat12Text2 VSTRING 15 15 0 Status 12 Text Line 2
PN13 PN13034 Stat13Text1 VSTRING 15 15 0 Status 13 Text Line 1
PN13 PN13035 Stat13Text2 VSTRING 15 15 0 Status 13 Text Line 2
PN13 PN13036 Stat14Text1 VSTRING 15 15 0 Status 14 Text Line 1
PN13 PN13037 Stat14Text2 VSTRING 15 15 0 Status 14 Text Line 2
PN13 PN13038 Stat15Text1 VSTRING 15 15 0 Status 15 Text Line 1
PN13 PN13039 Stat15Text2 VSTRING 15 15 0 Status 15 Text Line 2
PN13 PN13040 Stat16Text1 VSTRING 15 15 0 Status 16 Text Line 1
PN13 PN13041 Stat16Text2 VSTRING 15 15 0 Status 16 Text Line 2
PN13 PN13042 Stat17Text1 VSTRING 15 15 0 Status 17 Text Line 1
PN13 PN13043 Stat17Text2 VSTRING 15 15 0 Status 17 Text Line 2
PN13 PN13044 Stat18Text1 VSTRING 15 15 0 Status 18 Text Line 1
PN13 PN13045 Stat18Text2 VSTRING 15 15 0 Status 18 Text Line 2
PN13 PN13046 Stat19Text1 VSTRING 15 15 0 Status 19 Text Line 1
PN13 PN13047 Stat19Text2 VSTRING 15 15 0 Status 19 Text Line 2
PN13 PN13048 Stat20Text1 VSTRING 15 15 0 Status 20 Text Line 1
PN13 PN13049 Stat20Text2 VSTRING 15 15 0 Status 20 Text Line 2
PN13 PN13050 Spare VSTRING 15 15 0 (obsolete)
PN13 PN13051 Spare VSTRING 15 15 0 (obsolete)