18 COLUMNS | 1 INDEXES | ERP 6.0 | TCACS_FORMULA TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Incentive and Commission Management ICM
1	ERP EHP7	6.0	TCACS_FORMULA	18	1	Calculation formula	Incentive and Commission Management ICM

TOP ERP 6.0 | TCACS_FORMULA COLUMNS

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	APPL	Commission Application (ICM)	nvarchar	6	Allow NULL?
3	FRMOBJTYPE	Formula: Object type	nvarchar	2	Allow NULL?
4	FORMULAID	Formula identifier	nvarchar	10	Allow NULL?
5	VERSION	Version of Master Data or Customizing Object	nvarchar	6	Allow NULL?
6	FORMULA_GUID	Formula GUID	nvarchar	32	Allow NULL?
7	BUSI_BEGIN	Effective from	nvarchar	14	Allow NULL?
8	BUSI_END	Effective Until (Time Stamp: YYYY.MM.DD hh:mm:ss)	nvarchar	14	Allow NULL?
9	TECH_BEGIN	Technically Valid From	nvarchar	14	Allow NULL?
10	TECH_END	Technically Valid To (Time Stamp: JJJJ.MM.TT hh:mm:ss)	nvarchar	14	Allow NULL?
11	FLG_CANCEL_OBJ	Indicator: Object is Invalid	char	1	Allow NULL?
12	FLG_CANCEL_VERS	Indicator: Version is Invalid	char	1	Allow NULL?
13	CHG_TCODE	Transaction in Which the Change Was Made	nvarchar	20	Allow NULL?
14	CHG_USR	Last user to change object	nvarchar	12	Allow NULL?
15	TRI_METH_TYP	Triggering Method	char	1	Allow NULL?
16	TRI_METH_TARGET	Processing Target of Triggering Method	char	1	Allow NULL?
17	STATUS_VERSION	Object Version Status	char	1	Allow NULL?
18	STATUS_WORK	Object Version Processing Status	char	1	Allow NULL?

Name	Primary	Unique	Type	Columns
TCACS_FORMULA~0	Yes	Yes	CLUSTERED	VERSION, FORMULAID, FRMOBJTYPE, APPL, MANDT