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
CM3L	table Extended Contract Lines	Company		CM3L0100
CMBP	Best Price Table	Company		CMBP0100
CMH1	Contract History Master File	Company		CMH10100
CMH3	Contract Line History File	Company		CMH30100
CMH4	Delivery Schedule History	Company		CMH40100
CMH5	Contract Line Act History	Company		CMH50100
CMHD		Company		CMHD0100
CMHI	Invoicing Plan History	Company		CMHI0100
CMHL	Extended Contract Lines LTM History	Company		CMHL0100
CMHT	Contract Line Text History	Company		CMHT0100
CMI2	Contract Instalment Lines	Company		CMI20100
CMI4	Contract Instalment Lines History	Company		CMI40100
CMIP	Invoicing Plan	Company		CMIP0100
CMMT	Business Transaction Type Contract Mapping	Company		CMMT0100
CMVV	Variable Values	Company		CMVV0100
SM11	Service Contract Master	Company		SM110100
SM13	Service Contract Lines	Company		SM130100
SM15	Service Contract Parameters	Company		SM150100
SM16	Service Contract Document Texts	Company		SM160100
SM17	Phrase File	Company		SM170100
SM18	Contract Price Table	Company		SM180100
SM1T	Service Contract Line Texts	Company		SM1T0100
SM20	Service Contract Automatic Accounting Coding Schedule	Company	Year	SM200112
SM31	WIP Transaction Journal	Company	Year	SM310112
SM34	Price Calculation Profiles	Company		SM340100
SM35	Service Contract Index File	Company		SM350100
SM36	Index History File	Company		SM360100
SM69	Contract Codes	Company		SM690100
SM70	Contract Invoicing History	Company		SM700100
SM71	Service Contract Deferrals Booking History	Company		SM710100
SM75	Delivery Schedule	Company		SM750100
SM85	Contract Line Activities	Company		SM850100

Fields
PK	Table	Name	Description	Type	Length		Precision	Note
1	CMHI	CMHI001	ContractNumber	VSTRING	10	10	0	Contract Number
2	CMHI	CMHI002	PlanLineNumber	STRING	6	6	0	Plan Line Number
	CMHI	CMHI003	InvoiceType	INTEGER	2	0	0	Invoice Type
	CMHI	CMHI004	EventType	INTEGER	2	0	0	Event Type
	CMHI	CMHI005	EventDate	DATE	8	0	0	Event Date
	CMHI	CMHI006	InvoiceAmountCCU	MONEY	20	28	8	Invoice Amount CCU
	CMHI	CMHI007	AmntToDeductCCU	MONEY	20	28	8	Amount to deduct CCU
	CMHI	CMHI008	TaxCode	STRING	6	6	0	Tax Code
	CMHI	CMHI009	TaxLiability	STRING	6	6	0	Tax Liability
	CMHI	CMHI010	PaymentTerm	STRING	2	2	0	Payment Term
	CMHI	CMHI011	InvoiceFrom	DATE	8	0	0	Invoice From
	CMHI	CMHI012	InvoiceTo	DATE	8	0	0	Invoice To
	CMHI	CMHI013	Comment	VSTRING	200	200	0	Comment
	CMHI	CMHI014	Status	INTEGER	2	0	0	Status
	CMHI	CMHI015	InvoiceNumber	VSTRING	15	15	0	Invoice Number
	CMHI	CMHI016	LineSortingNumber	STRING	6	6	0	Line Sorting Number
	CMHI	CMHI017	OriginalInvoiceNumber	VSTRING	15	15	0	Original Invoice Number
	CMHI	CMHI018	InvDate	DATE	8	0	0	Invoice Date
	CMHI	CMHI019	XMLInvoiceFlag	INTEGER	1	0	0	XML Invoice Flag
	CMHI	CMHI020	SpecificationFlag	SWITCH	1	1	0	Specification flag
	CMHI	CMHI021	RestoreContractState	SWITCH	1	1	0	Restore contract state
	CMHI	CMHI022	OriginalPlanLineNumber	STRING	6	6	0	Original Plan Line Number
	CMHI	CMHI023	InvCounterID	VSTRING	12	12	0	Invoice Counter ID
	CMHI	CMHI024	TaxationReasonCode	STRING	3	3	0	Taxation Reason Code

Apicosoft