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	HR04	HR04001	PlanningType	VSTRING	1	1	0	Planning Type 0 - Planned only on date 1 - Planned with date and time
2	HR04	HR04002	ResourceCode	VSTRING	10	10	0	Resource Code
3	HR04	HR04003	PlannedDate	DATE	8	0	0	Planned Start Date
4	HR04	HR04004	PlannedTime	VSTRING	4	4	0	Planned Start Time
5	HR04	HR04005	PlanModSrc	VSTRING	1	1	0	Planning Source 0 - Project Management 1 - Service Order
6	HR04	HR04006	PlanOrdProj	VSTRING	30	30	0	Planning Object Includes full qualifier for project activity line or service order line
	HR04	HR04007	PlanActItem	VSTRING	10	10	0	Activity Code
	HR04	HR04008	PlanHrsQty	X_NUMERIC	12	20	8	Planned Hours
	HR04	HR04009	PlanActClo	VSTRING	1	1	0	Status
	HR04	HR04010	DoneDate	DATE	8	0	0	Date Planning Created
	HR04	HR04011	DoneByUser	VSTRING	8	8	0	Created By
	HR04	HR04012	LatestChDate	DATE	8	0	0	Date Changed
	HR04	HR04013	LatesrChUser	VSTRING	8	8	0	Updated By
	HR04	HR04014	ResourceGrp	VSTRING	10	10	0	Resource Group
	HR04	HR04015	FlagCloseTsk	VSTRING	1	1	0	Task is Closed
	HR04	HR04016	EndDate	DATE	8	0	0	Planned End Date
	HR04	HR04017	EndTime	VSTRING	4	4	0	Planned End Time

Apicosoft