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	DI08	DI08001	InvLibrary	STRING	2	2	0	Template Number
2	DI08	DI08002	LineNumber	STRING	5	5	0	Line Number
	DI08	DI08003	LineType	INTEGER	1	0	0	Line Type 0 - Normal line with quantity and price 1 - Specification line with price 2 - Block total 3 - Sub total 4 - Text line
	DI08	DI08004	StockCode	VSTRING	35	35	0	Stock Item Code
	DI08	DI08005	LineSpecif	VSTRING	70	70	0	Line Description
	DI08	DI08006	VATCode	VSTRING	6	6	0	VAT Code This field should contain the Tax Code in invoice library file
	DI08	DI08007	AccCode1	STRING	2	2	0	Accounting Code 1
	DI08	DI08008	TaxCode	INTEGER	1	0	0	Extra Tax Code
	DI08	DI08009	AccString	ACCSTR	120	120	0	Accounting String
	DI08	DI08010	Quantity	X_NUMERIC	12	20	8	Quantity
	DI08	DI08011	Price	MONEY	20	28	8	Unit Price
	DI08	DI08012	Discount	X_NUMERIC	6	14	8	Discount
	DI08	DI08013	InvoiceCurrCode	INTEGER	2	0	0	Currency Code Invoice
	DI08	DI08014	AccCode2	STRING	2	2	0	Accounting Code 2

Apicosoft