T5ITD2

Direct employment deductions | #other | Component: Italy

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

Column Name	Description
MANDT FK	Client
CDDTR FK	Tax deduction indicator
TPDET FK	Deduction type	Show values
FASRE	Income bracket for family allowance
CDVAL	Value type indicator	Show values
ENDDA	End Date

Column Name	Description
💲 Currency Key (T500C.WAERS):
REDAD	Annual family income from
REDAA	Family income to
IMANF	Base amount
IMP1	Base amount
IMP2	Base amount
IMP3	Base amount
IMP4	Base amount
IMP5	Base amount
IMP6	Base amount
IMP7	Base amount
IMP8	Base amount
IMP9	Base amount
IMP10	Base amount

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
CDVAL	Value type indicator	Show values

Column Name	Description	Domain name

Master Data Relations	Join Conditions
Tax deduction indicator Tax deduction indicator ? Client	`T5ITD2.CDDTR == T5ITDT.CDDTR` `T5ITD2.[column in domain "ENDDA"] == T5ITDT.ENDDA` `T5ITD2.MANDT == T5ITDT.MANDT`
Client	`T5ITD2.MANDT == T000.MANDT`
Deduction type ? Client Deduction type	`T5ITD2.[column in domain "ENDDA"] == T5ITDR.ENDDA` `T5ITD2.MANDT == T5ITDR.MANDT` `T5ITD2.TPDET == T5ITDR.TPDET`
Wage-Type for deduction coefficient (Fin Law 2007) ? ? Client Wage-Type for deduction coefficient (Fin Law 2007)	`T5ITD2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITD2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITD2.MANDT == T512W.MANDT` `T5ITD2.WTCO1 == T512W.LGART`
Wage-Type for deduction coefficient (Fin Law 2007) ? ? Client Wage-Type for deduction coefficient (Fin Law 2007)	`T5ITD2.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITD2.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITD2.MANDT == T512W.MANDT` `T5ITD2.WTCO2 == T512W.LGART`