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 PN04 PN04001 JournalCode STRING 2 2 0 Journal Type SL - Sales Ledger Transaction
PL - Purchase Ledger Transaction
GL - General Ledger Transaction
NO - Internal Promissory Note Transaction
2 PN04 PN04002 TransactNumb STRING 9 9 0 Transaction Number
3 PN04 PN04003 TransactLine STRING 3 3 0 Transaction Line Number
PN04 PN04004 OperatioCode STRING 2 2 0 Operation Code
PN04 PN04005 PNPDCInterNumb STRING 6 6 0 PN/PDC Internal Number
PN04 PN04006 BEDate DATE 8 0 0 Book-Entry Date
PN04 PN04007 DueDate DATE 8 0 0 Due Date
PN04 PN04008 SourceStatus STRING 2 2 0 Source Status
PN04 PN04009 PortfolioNo STRING 2 2 0 Portfolio Number
PN04 PN04010 ControlString ACCSTR 120 120 0 Accounting String
PN04 PN04011 LinkedAccount STRING 12 12 0 Linked Account
PN04 PN04012 LocalCurAmnt X_NUMERIC 20 28 8 Amount (Local Currency)
PN04 PN04013 ForeiCurAmnt X_NUMERIC 20 28 8 Amount (Document Currency)
PN04 PN04014 CurrencyCode VSTRING 2 2 0 Currency Code
PN04 PN04015 Printed STRING 1 1 0 Printed
PN04 PN04016 TargetStatus STRING 2 2 0 Target Status
PN04 PN04017 PartnTypeOut STRING 1 1 0 Partner Type (Out)
PN04 PN04018 PartnCodeOut STRING 10 10 0 Partner Code (Out)
PN04 PN04019 PartnTypeIn STRING 1 1 0 Partner Type (In)
PN04 PN04020 PartnCodeIn STRING 10 10 0 Partner Code (In)
PN04 PN04021 DrawBankCode STRING 10 10 0 Drawee/Bank Code
PN04 PN04022 DraweeType STRING 1 1 0 Drawee Type
PN04 PN04023 NoteCheqType STRING 2 2 0 Document Type
PN04 PN04024 PortfoliType STRING 1 1 0 Portfolio Type
PN04 PN04025 SavedDueDate DATE 8 0 0 Saved Due Date