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	DI11	DI11001	InvoiceNo	STRING	15	15	0	Invoice Number
2	DI11	DI11002	LineNumber	STRING	5	5	0	Line Number
	DI11	DI11003	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
	DI11	DI11004	StockCode	VSTRING	35	35	0	Stock Item Code
	DI11	DI11005	LineSpecif	VSTRING	70	70	0	Line Description
	DI11	DI11006	VATCode	VSTRING	6	6	0	VAT Code This field should contain the Tax Code for invoice line
	DI11	DI11007	AccCode1	STRING	2	2	0	Accounting Code 1
	DI11	DI11008	TaxCode	INTEGER	1	0	0	Extra Tax Code
	DI11	DI11009	AccString	ACCSTR	120	120	0	Accounting String
	DI11	DI11010	Quantity	X_NUMERIC	12	20	8	Quantity
	DI11	DI11011	Price	MONEY	20	28	8	Unit Price
	DI11	DI11012	Discount	X_NUMERIC	6	14	8	Discount
	DI11	DI11013	AccCode2	STRING	2	2	0	Accounting Code 2
	DI11	DI11014	TaxReasonCode	STRING	3	3	0	Taxation Reason Code

Apicosoft