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
HR01	Resource Master Table	Company	HR010100
HR02	Resource Templates	Company	HR020100
HR03	Resource Transactions	Company	HR030100
HR04	Time Planning	Company	HR040100
HR05	Payroll Transactions	Company	HR050100
HR06	Work Schedule (not used)	Company	HR060100
HR10	HR Courses	Company	HR100100
HR11	Course Multilingual Description	Company	HR110100
HR15	Course Plan	Company	HR150100
HR16	Course Details	Company	HR160100
HR17	Course Skills	Company	HR170100
HR18	Acquired Skills	Company	HR180100
HR19	Course Status Mapping	Company	HR190100
HR46	Course Details History	Company	HR460100
HRF1	Exposed Engineer	Company	HRF10100
HRX1	Time Planning 1		HRX10000
HRX2	Time Planning 2		HRX20000
HRX3	Time Planning 3		HRX30000
sca_trg_Audit_HR01	Audit trigger for HR01 table	Company	sca_trg_Audit_HR010100

Fields
PK	Table	Name	Description	Type	Length		Precision	Note
1	HR05	HR05001	LineNumber	STRING	8	8	0	Line Number
	HR05	HR05002	EmployeeCode	STRING	10	10	0	Employee Code
	HR05	HR05003	TransactDate	DATE	8	0	0	Transaction Date
	HR05	HR05004	WageType	STRING	6	6	0	Wage Type
	HR05	HR05005	SourceModule	STRING	1	1	0	Source Module 0 - Project Management 1 - Service Order
	HR05	HR05006	MainSrcObj	VSTRING	20	20	0	Source Object
	HR05	HR05007	LineSrcObj	VSTRING	20	20	0	Source Object Line Number
	HR05	HR05008	ActivityCode	VSTRING	8	8	0	Activity Code
	HR05	HR05009	AccString	ACCSTR	120	120	0	Accounting String
	HR05	HR05010	CostType	STRING	1	1	0	Cost Category
	HR05	HR05011	ActualHours	X_NUMERIC	12	20	8	Hours Actual
	HR05	HR05012	InvHours	X_NUMERIC	12	20	8	Hours to Invoice
	HR05	HR05013	Cost	MONEY	20	28	8	Unit Cost
	HR05	HR05014	Price	MONEY	20	28	8	Unit Price
	HR05	HR05015	Text	VSTRING	35	35	0	Transaction Text
	HR05	HR05016	StartDate	DATE	8	0	0	Start Date
	HR05	HR05017	EndDate	DATE	8	0	0	End Date
	HR05	HR05018	ResourceCode	VSTRING	10	10	0	Resource Code
	HR05	HR05019	UpdateInPA	STRING	1	1	0	Update in Payroll

Apicosoft