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		Precision	Note
1	PN17	PN17001	PortfoliType	STRING	1	1	0	PortfoliType
2	PN17	PN17002	PortfolioNo	STRING	2	2	0	PortfolioNo
3	PN17	PN17003	PNPDCType	STRING	2	2	0	PNPDCType
4	PN17	PN17004	PNPDCIntNo	STRING	6	6	0	PNPDCIntNo
5	PN17	PN17005	PortfContStr	ACCSTR	120	120	0	PortfContStr
	PN17	PN17006	PortfCurrCod	STRING	2	2	0	PortfCurrCod
	PN17	PN17007	BalanceAccnt	STRING	12	12	0	BalanceAccnt
	PN17	PN17008	ProfitAccnt	STRING	12	12	0	ProfitAccnt
	PN17	PN17009	LossAccount	STRING	12	12	0	LossAccount
	PN17	PN17010	RevaluatMode	STRING	1	1	0	RevaluatMode
	PN17	PN17011	SpcExchgRate	VSTRING	15	15	0	SpcExchgRate
	PN17	PN17012	AmountCurrcy	X_NUMERIC	20	28	8	AmountCurrcy
	PN17	PN17013	OldAmountLCU	X_NUMERIC	20	28	8	OldAmountLCU
	PN17	PN17014	NewAmountLCU	X_NUMERIC	20	28	8	NewAmountLCU
	PN17	PN17015	AmntProfLoss	X_NUMERIC	20	28	8	AmntProfLoss
	PN17	PN17016	BelongToUser	STRING	8	8	0	BelongToUser

Apicosoft