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
	ScaAuditChangeSetsCD	_BusinessOperationID	BusinessOperationID	INTEGER	11	0	Business Operation ID ID of the Business Operation to which subsequent changes are attributed
	ScaAuditChangeSetsCD	_ChangeSetGUID	ChangeSetGUID	X_UNIQUEIDENTIFIER	36	0	Change Set GUID
	ScaAuditChangeSetsCD	_Computer	Computer	VSTRING	32	32	Computer Name Computer on which business code execution is initiated
	ScaAuditChangeSetsCD	_IssueUTCTime	IssueUTCTime	X_DATETIME2	27	3	Issue UTC Date Time The beginning of the whole business operation
	ScaAuditChangeSetsCD	_ScalaUser	ScalaUser	VSTRING	256	256	iScala User User logged on to iScala
	ScaAuditChangeSetsCD	_WindowsAccount	WindowsAccount	VSTRING	256	256	Windows Account Windows User initiating business code execution
1	ScaAuditChangeSetsCD	TempID	TempID	X_BIGINT	20	0	ChangeSet Row ID Temporary identifier of the row

Apicosoft