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
DI01	Stock Items	Company	DI010100
DI02	Stock Item Foreign Descriptions	Company	DI020100
DI03	Invoicing Parameters	Company	DI030100
DI04	Stock Item Price List	Company	DI040100
DI05	Invoice Texts	Company	DI050100
DI08	Invoice Templates	Company	DI080100
DI10	Invoice Head	Company	DI100100
DI11	Invoice Lines	Company	DI110100
DIH0		Company	DIH00100
DIH1		Company	DIH10100
DIXX	Temp. DI table		DIXX0000
DIXY	Workf.close Inv		DIXY0000

Fields
PK	Table	Name	Description	Type	Length		Precision	Note
1	DI03	DI03001	Year_	STRING	2	2	0	Year
	DI03	DI03002	InvNoDummy	NUMBER	1	20	0	(obsolete)
	DI03	DI03003	CrNDummy	NUMBER	1	20	0	(obsolete)
	DI03	DI03004	CopiesPrint	INTEGER	2	0	0	Number of Invoice Copies
	DI03	DI03005	StdSalesTax	VSTRING	6	6	0	Normal VAT Code This field should contain the Standard Tax Code
	DI03	DI03006	StdAccCode	STRING	2	2	0	Normal Accounting Code
	DI03	DI03007	InvoiceFee	X_NUMERIC	6	14	8	Invoice Fee
	DI03	DI03008	StCodeLeng	INTEGER	2	0	0	Length of Stock Item Code
	DI03	DI03009	ExtSalTax1	X_NUMERIC	6	14	8	Extra Sales Tax 1
	DI03	DI03010	ExtSalTax2	X_NUMERIC	6	14	8	Extra Sales Tax 2
	DI03	DI03011	ExtSalTax3	X_NUMERIC	6	14	8	Extra Sales Tax 3
	DI03	DI03012	IntInvDummy	NUMBER	1	20	0	(obsolete)
	DI03	DI03013	Spare	VSTRING	1	1	0	(obsolete)
	DI03	DI03014	Spare	VSTRING	1	1	0	(obsolete)
	DI03	DI03015	SaveHistory	VSTRING	1	1	0	SaveHistory
	DI03	DI03016	Spare	VSTRING	1	1	0	(obsolete)
	DI03	DI03017	Spare	VSTRING	1	1	0	(obsolete)
	DI03	DI03018	Spare	VSTRING	1	1	0	(obsolete)
	DI03	DI03019	Spare	VSTRING	1	1	0	(obsolete)
	DI03	DI03020	Spare	VSTRING	1	1	0	(obsolete)
	DI03	DI03021	AvgMarkup	X_NUMERIC	6	14	8	Average Gross Profit
	DI03	DI03022	PriceWVAT	X_NUMERIC	6	14	8	Prices Includes VAT
	DI03	DI03023	DecInQty	INTEGER	1	0	0	Number of Decimals in Prices
	DI03	DI03024	Spare	VSTRING	1	1	0	(obsolete)

Apicosoft