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 PN02 PN02001 Type STRING 2 2 0 Document Type CR - Cheque receivable
NR - Notes Receivable
CP - Cheques payable
NP - Notes payable
2 PN02 PN02002 InternalNo STRING 6 6 0 Internal Number
PN02 PN02003 PNPDCStatus STRING 2 2 0 PN/PDC Status
PN02 PN02004 DueDate DATE 8 0 0 Due Date
PN02 PN02005 PortfolioNo STRING 2 2 0 Portfolio Number
PN02 PN02006 PNPDCSerNo VSTRING 15 15 0 PN/PDC Serial Number
PN02 PN02007 SavedAmLCU X_NUMERIC 20 28 8 Saved Amount (Local Currency)
PN02 PN02008 CurrencyCode VSTRING 2 2 0 Currency Code
PN02 PN02009 FacedAmFCU X_NUMERIC 20 28 8 Faced Amount (Document Currency)
PN02 PN02010 DrawDate DATE 8 0 0 Draw Date
PN02 PN02011 IssuerCode STRING 10 10 0 Issuer Code
PN02 PN02012 IssuerName VSTRING 35 35 0 Issuer Name
PN02 PN02013 OrigBankCode VSTRING 10 10 0 Originator/Drawee Bank Code
PN02 PN02014 OrigBankName VSTRING 35 35 0 Originator/Drawee Bank Name
PN02 PN02015 OrigBankAdd1 VSTRING 35 35 0 Originator/Drawee Bank Address Line 1
PN02 PN02016 OrigBankAdd2 VSTRING 35 35 0 Originator/Drawee Bank Address Line 2
PN02 PN02017 OrigBankAdd3 VSTRING 35 35 0 Originator/Drawee Bank Address Line 3
PN02 PN02018 OrigBankAdd4 VSTRING 35 35 0 Originator/Drawee Bank Address Line 4
PN02 PN02019 EndorserCode STRING 10 10 0 Endorser Code
PN02 PN02020 InputBEDate DATE 8 0 0 Input BE Date
PN02 PN02021 InputTransNo STRING 9 9 0 Input Transaction Number
PN02 PN02022 InputInvoiNo STRING 25 25 0 Input Invoice Number
PN02 PN02023 InputAmLCU X_NUMERIC 20 28 8 Input Amount (Local Currency)
PN02 PN02024 Spare STRING 1 1 0 (obsolete)
PN02 PN02025 Spare STRING 1 1 0 (obsolete)
PN02 PN02026 InputContStr ACCSTR 120 120 0 Accounting String Input
PN02 PN02027 EndorseeCode STRING 10 10 0 Endorsee/Payee Code
PN02 PN02028 OutputBEDate DATE 8 0 0 Output Book-Entry Date
PN02 PN02029 OutputTranNo STRING 9 9 0 Output Transaction Number
PN02 PN02030 OutputInvoNo STRING 25 25 0 Output Invoice Number
PN02 PN02031 OutputAmLCU X_NUMERIC 20 28 8 Output Amount (Local Currency)
PN02 PN02032 OutpContrStr ACCSTR 120 120 0 Accounting String Output
PN02 PN02033 PrintePNPDC STRING 1 1 0 Printed PN/PDC
PN02 PN02034 PrintedRepLn STRING 1 1 0 Printed Report Line
PN02 PN02035 AmountLCUBef X_NUMERIC 20 28 8 Amount Before Last Revaluation (Local Currency)
PN02 PN02036 RevalModeTaken STRING 1 1 0 Revaluation Mode Taken
PN02 PN02037 DiscAmounLCU X_NUMERIC 20 28 8 Discounted Amount (Local Currency)
PN02 PN02038 DiscAmounCUR X_NUMERIC 20 28 8 Discounted Amount (Document Currency)
PN02 PN02039 InterestProc STRING 6 6 0 Interest %
PN02 PN02040 NoEndorsBefore STRING 3 3 0 Times Endorsed Before
PN02 PN02041 SalesManCode STRING 3 3 0 Salesman
PN02 PN02042 OriginTaxCode STRING 10 10 0 Originator Tax Code
PN02 PN02043 OriginTaxNo STRING 10 10 0 Originator Tax Number
PN02 PN02044 GracePeriLen STRING 10 10 0 Grace Period
PN02 PN02045 GracePerUnit STRING 10 10 0 Grace Period Unit
PN02 PN02046 AcceptPerLen STRING 10 10 0 Acceptance Period
PN02 PN02047 AcceptPerUnt STRING 10 10 0 Acceptance Period Unit
PN02 PN02048 ProtesPerLen STRING 10 10 0 Protest Period
PN02 PN02049 ProtesPerUnt STRING 10 10 0 Protest Period Unit
PN02 PN02050 ContLiabiLen STRING 10 10 0 Contingent Liability Margin Period
PN02 PN02051 ContLiabiUnt STRING 10 10 0 Contingent Liability Margin Period Unit
PN02 PN02052 RemarkLine1 VSTRING 50 50 0 Remark Line 1
PN02 PN02053 RemarkLine2 VSTRING 50 50 0 Remark Line 2
PN02 PN02054 RemarkLine3 VSTRING 50 50 0 Remark Line 3
PN02 PN02055 RemarkLine4 VSTRING 50 50 0 Remark Line 4
PN02 PN02056 StatistCode1 STRING 2 2 0 Statistical Code 1
PN02 PN02057 StatistCode2 STRING 2 2 0 Statistical Code 2
PN02 PN02058 SettledFlag STRING 1 1 0 Settled Flag
PN02 PN02059 HoldDate DATE 8 0 0 Hold Date
PN02 PN02060 IssuerDescript VSTRING 35 35 0 Issuer Description
PN02 PN02061 Spare STRING 1 1 0 (obsolete)
PN02 PN02062 Spare STRING 1 1 0 (obsolete)
PN02 PN02063 LockedByUserId STRING 8 8 0 Locked By
PN02 PN02064 Selected STRING 1 1 0 Selected
PN02 PN02065 PortfolioType STRING 1 1 0 Portfolio Type
PN02 PN02066 DraweeType STRING 1 1 0 Drawee Type
PN02 PN02067 IssuerType STRING 1 1 0 Issuer Type
PN02 PN02068 EndorserType STRING 1 1 0 Endorser Type
PN02 PN02069 EndorseeType STRING 1 1 0 Endorsee Type
PN02 PN02070 LastRevaDate DATE 8 0 0 Last Revaluation Date
PN02 PN02071 ReceiptDate DATE 8 0 0 Received Date
PN02 PN02072 SettleBankCode STRING 10 10 0 Settlement/Pledged Bank Code
PN02 PN02073 PaymBankCode STRING 10 10 0 Payment Bank Code
PN02 PN02074 PaymBankName VSTRING 35 35 0 Payment Bank Name
PN02 PN02075 PaymBankAddr1 VSTRING 35 35 0 Payment Bank Address 1
PN02 PN02076 PaymBankAddr2 VSTRING 35 35 0 Payment Bank Address 2
PN02 PN02077 PaymBankAddr3 VSTRING 35 35 0 Payment Bank Address 3
PN02 PN02078 PaymBankAddr4 VSTRING 35 35 0 Payment Bank Address 4
PN02 PN02079 ProcessDate DATE 8 0 0 Process Date
PN02 PN02080 OperPropNo VSTRING 8 8 0 Operational Proposal Number
PN02 PN02081 IBANforPayment VSTRING 28 28 0 IBAN for Payment
PN02 PN02082 OrigBankAdd5 VSTRING 35 35 0 Originator/Drawee Bank Address Line 5
PN02 PN02083 OrigBankAdd6 VSTRING 35 35 0 Originator/Drawee Bank Address Line 6
PN02 PN02084 OrigBankAdd7 VSTRING 35 35 0 Originator/Drawee Bank Address Line 7
PN02 PN02085 PaymBankAddr5 VSTRING 35 35 0 Payment Bank Address 5
PN02 PN02086 PaymBankAddr6 VSTRING 35 35 0 Payment Bank Address 6
PN02 PN02087 PaymBankAddr7 VSTRING 35 35 0 Payment Bank Address 7
PN02 PN02088 OrigCountryCode VSTRING 3 3 0 Originator/Drawee Country Code
PN02 PN02089 PaymCountryCode VSTRING 3 3 0 Payment Country Code