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
sca_AuditRegisterChangeSetCD	Registers company-dependent ChangeSet	Company	sca_AuditRegisterChangeSetCD0100
sca_AuditRegisterChangeStepCD	Registers a change for a table	Company	sca_AuditRegisterChangeStepCD0100
ScaAuditChangeSetsCD	The table is used to track allocated ChangeSets	Company	ScaAuditChangeSetsCD0100
ScaAuditChangeStepsCD	The table is used to track changes in tables attributed to ChangeSet steps	Company	ScaAuditChangeStepsCD0100

Fields
PK	Table	Name	Description	Type	Length		Note
	ScaAuditChangeStepsCD	_ChangeSetGUID	ChangeSetGUID	X_UNIQUEIDENTIFIER	36	0	Change Set GUID GUID of the ChangeSet to which the step it attributed
	ScaAuditChangeStepsCD	_DataRows	DataRows	X_BIGINT	20	0	Number of Changed Rows Number of rows affected by the operation
	ScaAuditChangeStepsCD	_ShortTableName	TableName	VSTRING	128	128	Table Name Short name of the table in which changes occurred
	ScaAuditChangeStepsCD	_SQLUser	SQLUser	VSTRING	256	256	SQL User SQL connection user
	ScaAuditChangeStepsCD	_StepStartTimeOffset	StepStartTimeOffset	X_DATETIMEOFFSET	34	3	Step Start Date-Time with TimeZone Offset Step Start Date-Time with TimeZone Offset
	ScaAuditChangeStepsCD	_StepStartUTCTime	StepStartUTCTime	X_DATETIME2	27	3	Step start UTC Date-Time The date/time when the step began, in UTC
	ScaAuditChangeStepsCD	_TableName	TableName	VSTRING	128	128	Table Name Full name of the table in which changes occurred
1	ScaAuditChangeStepsCD	TempID	TempID	X_BIGINT	20	0	Change Step Row ID Temporary identifier of the row

Apicosoft