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		Note
1	HR10	HR10001	CourseCode	STRING	35	35	Course Code
	HR10	HR10002	Description	VSTRING	35	35	Description
	HR10	HR10003	Length	INTEGER	20	0	Length
	HR10	HR10004	TimeUnit	INTEGER	1	0	Time Unit Time unit for the course length: 0 - Hours 1 - Days 2 - Weeks 3 - Month 4 - Years
	HR10	HR10005	MaxStudents	INTEGER	20	0	Maximum Number of Students
	HR10	HR10006	LastCourseDate	DATE	8	0	Last Course Date
	HR10	HR10007	NextCourseDate	DATE	8	0	Next Course Date
	HR10	HR10008	RepeatInterval	INTEGER	20	0	Repeat Interval
	HR10	HR10009	RepeatTimeUnit	INTEGER	1	0	Repeat Time Unit 0 - Hours 1 - Days 2 - Weeks 3 - Month 4 - Years
	HR10	HR10010	ReplacedBy	VSTRING	35	35	Replaced By Course
	HR10	HR10011	AccountString	ACCSTR	120	120	Accounting String
	HR10	HR10012	OrderType	STRING	6	6	Service Order Type
	HR10	HR10013	TeacherActivity	STRING	8	8	Activity Code Teacher
	HR10	HR10014	StudentActivity	STRING	8	8	Activity Code Student
	HR10	HR10015	JobCode	STRING	6	6	Job Code

Apicosoft