Scala DB

Business processes implementation, ad-hock services, end-users training and education, maintenance support.

Integration with any third-party services. Customize internal workflows.

SAP Crystal Reports, SQL Server Reporting Services, Excel.

Read More Contact Us

Modules
Name	Description
00	System objects (company-independent)
0C	System objects (company-dependent)
AM	Asset Management
CM	Contract Management
DI	Direct Invoicing
GL	General Ledger
HR	Resourse Management
MA	Market Database
MP	Material Production Control
OR	Sales Order
PA	Payroll
PC	Purchase Order
PL	Purchase Ledger
PN	Promissory Notes
PR	Project Management
SC	Stock Control
SL	Sales Ledger
SM	Service Order Management
SO	Other objects
ST	Statistics
SY	System Utilities/Office Autom.
UD	User-defined

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		Note
1	PN08	PN08001	TransactCode	STRING	2	2	Transaction Code
	PN08	PN08002	TransactName	VSTRING	25	25	Transaction Name
	PN08	PN08003	TransactDes1	VSTRING	25	25	Transaction Description Line 1
	PN08	PN08004	TransactDes2	VSTRING	25	25	Transaction Description Line 2
	PN08	PN08005	TransactText	VSTRING	25	25	Transaction Text
	PN08	PN08006	InitialStat1	STRING	2	2	Initial Status 1
	PN08	PN08007	InitialStat2	STRING	2	2	Initial Status 2
	PN08	PN08008	InitialStat3	STRING	2	2	Initial Status 3
	PN08	PN08009	FinalStatus	STRING	2	2	Final Status
	PN08	PN08010	PortfContAcc	STRING	7	7	Portfolio Account Fraction
	PN08	PN08011	StampDutyAccount	STRING	7	7	Stamp Duty Account Fraction
	PN08	PN08012	CollecFeeAcc	STRING	7	7	Collection Fee Account Fraction
	PN08	PN08013	DepositAccnt	STRING	7	7	Deposit Account Fraction
	PN08	PN08014	ProtestAccnt	STRING	7	7	Protest Account Fraction
	PN08	PN08015	BankAccount	STRING	7	7	Bank Account Fraction
	PN08	PN08016	SetExRatProf	STRING	1	1	Settlement Exchange Rate Profit
	PN08	PN08017	SetExRatLoss	STRING	1	1	Settlement Exchange Rate Loss
	PN08	PN08018	OtherAccNo	STRING	12	12	Other Account Number
	PN08	PN08019	OtherAccount	STRING	7	7	Other Account Fraction
	PN08	PN08020	InpuOutpSign	STRING	1	1	Input/Output Sign 0 - Internal 1 - Input 2 - Output
	PN08	PN08021	SettlmntFlag	STRING	1	1	Settlement PN/PDC
	PN08	PN08022	Type	STRING	1	1	Type 0 - Undefined 1 - Reception 2 - Collection 3 - Return from supplier 4 - Protest 5 - Internal portfolio 6 - Returned to customer with reversal of payment 7 - Lost note 8 - Jumped note 9 - Returned from supplier with reversal of payment

Apicosoft