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
ST01	Salesmen	Company	ST010100
ST02	Sales Order Entry Statistics	Company	ST020100
ST03	Sales Order Invoicing Statistics	Company	ST030100
ST05	Sales Districts	Company	ST050100
ST06	Workfile for budgets		ST060000
ST07	Commission Rates	Company	ST070100
ST08	Purchase Statistics	Company	ST080100
ST10	Bookings	Company	ST100100
ST11	Selected Bookings	Company	ST110100
ST12	Yearly Booking File	Company	ST120100
ST13	Service Statistics	Company	ST130100
ST14	Query On Statistics		ST140000
ST15	Purchase Order Header Statistics	Company	ST150100
ST16	Purchase Order Line Statistics	Company	ST160100
ST17	Purchase Order Ordering Statistics	Company	ST170100
ST18	Purchase Order Confirmation Statistics	Company	ST180100
ST19	Purchase Order Goods Receipt Statistics	Company	ST190100
ST20	Purchase Order Invoice Statistics	Company	ST200100
ST22	Sales Order Entry Statistics Advanced Discounts	Company	ST220100
ST23	Sales Order Invoice Statistics Advanced Discounts	Company	ST230100
ST24	Sales Contract Statistics	Company	ST240100
ST25	Lease Statistics	Company	ST250100
ST40		Company	ST400100
STCS		Company	STCS0100
STST		Company	STST0100

Fields
PK	Table	Name	Description	Type	Length		Precision	Note
1	ST19	ST19001	OrderNo	STRING	10	10	0	Purchase Order Number
2	ST19	ST19002	OrderLine	STRING	6	6	0	Purchase Order Line Number
3	ST19	ST19003	OrderSubLine	STRING	6	6	0	Purchase Order Sub-line Number
4	ST19	ST19004	DeliveryLine	STRING	6	6	0	Purchase Order Delivery Line Number
5	ST19	ST19005	OrderType	SWITCH	1	1	0	Order Type 0 - Purchase Order Proposal / Request for Quotation 1 - Normal Order 2 - Back Order 3 - Direct Delivery to Customer 4 - Replenishment Order
6	ST19	ST19006	Counter	INTEGER	10	0	0	Line Counter
	ST19	ST19007	ScaUser	STRING	8	8	0	User
	ST19	ST19008	TransactionDate	DATE	8	0	0	Transaction Date
	ST19	ST19009	TransactionTime	STRING	8	8	0	Transaction Time
	ST19	ST19010	TransactionType	STRING	2	2	0	Transaction Type 10 - Created 20 - Updated 60 - Deleted
	ST19	ST19011	QtyPCUnit	X_NUMERIC	12	20	8	Quantity (Purchase Unit)
	ST19	ST19012	QtySCUnit	X_NUMERIC	12	20	8	Quantity (Stock Unit)
	ST19	ST19013	PriceOrderCurrency	MONEY	20	28	8	Unit Price (Order Currency)
	ST19	ST19014	PriceLCU	MONEY	20	28	8	Unit Price (Local Currency)
	ST19	ST19015	DiscLinePercent	X_NUMERIC	6	14	8	Discount Line %
	ST19	ST19016	DiscOrdPercent	X_NUMERIC	6	14	8	Discount Order %
	ST19	ST19017	DateDelivery	DATE	8	0	0	Date Delivered
	ST19	ST19018	GoodsNote	STRING	10	10	0	Goods Received Note
	ST19	ST19019	DeliveryNote	VSTRING	20	20	0	Delivery Note Number
	ST19	ST19020	BatchID	STRING	12	12	0	Batch ID
	ST19	ST19021	FlagActive	SWITCH	1	1	0	Active
	ST19	ST19022	CommodityCode	VSTRING	35	35	0	Commodity code

Apicosoft