T5ITQL

Taxation types to be highlighted in the payroll | #masterdata | Component: Italy

🔑 Keys (5)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical (1)
Other
🔗 Relations (5)

Column Name	Description
MANDT FK	Client
TRFAR FK	Pay scale type
TRFGB FK	Pay Scale Area
TRFKZ	ES grouping for collective agreement provision
ENDDA	End Date

Column Name	Description

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
TPASI	IRPEF taxation type	Show values

Column Name	Description	Domain name

Master Data Relations \| to Other Relations ↓	Join Conditions
CLIENT	`T5ITQL.MANDT == T000.MANDT`
Taxation type End Date Pay scale type Pay Scale Area Taxation type 1 (slip)	`T5ITQL.MANDT == T5ITCT.MANDT` `T5ITQL.ENDDA == T5ITCT.ENDDA` `T5ITQL.TRFAR == T5ITCT.TRFAR` `T5ITQL.TRFGB == T5ITCT.TRFGB` `T5ITQL.TPA1 == T5ITCT.TPASS`
Taxations type End Date Pay scale type Pay Scale Area Taxation type 2 (slip)	`T5ITQL.MANDT == T5ITCT.MANDT` `T5ITQL.ENDDA == T5ITCT.ENDDA` `T5ITQL.TRFAR == T5ITCT.TRFAR` `T5ITQL.TRFGB == T5ITCT.TRFGB` `T5ITQL.TPA2 == T5ITCT.TPASS`

Other Relations \| to Master Data Relations ↑	Join Conditions
Pay scale type ? Pay scale type	`T5ITQL.MANDT == T510A.MANDT` `T5ITQL.[column in domain "MOLGA"] == T510A.MOLGA` `T5ITQL.TRFAR == T510A.TRFAR`
Pay Scale Area ? Client Pay Scale Area	`T5ITQL.[column in domain "MOLGA"] == T510G.MOLGA` `T5ITQL.MANDT == T510G.MANDT` `T5ITQL.TRFGB == T510G.TRFGB`