T7BRTA

Union dues | #other | Component: Brazil

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

Column Name	Description
MANDT FK	Client
EMFSL FK	Payee key for bank transfers
SUBTY FK	Subtype
ENDDA	End Date

Column Name	Description
💲 Currency Key (WAERS):
LIMIT	Scale limit

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description

Column Name	Description	Domain name
MESRE	Initial reference month	NUMC2
MESRF	Final reference month	NUMC2

Master Data Relations \| to Other Relations ↓	Join Conditions
Client	`T7BRTA.MANDT == T000.MANDT`
Currency Key	`T7BRTA.MANDT == TCURC.MANDT` `T7BRTA.WAERS == TCURC.WAERS`
Assessment basis wage type for employee's union dues ? End Date Client Assessment basis wage type for employee's union dues	`T7BRTA.[column in domain "MOLGA"] == T512W.MOLGA` `T7BRTA.ENDDA == T512W.ENDDA` `T7BRTA.MANDT == T512W.MANDT` `T7BRTA.WTYPI == T512W.LGART`
Union dues wage type ? End Date Client Union dues wage type	`T7BRTA.[column in domain "MOLGA"] == T512W.MOLGA` `T7BRTA.ENDDA == T512W.ENDDA` `T7BRTA.MANDT == T512W.MANDT` `T7BRTA.WTYPO == T512W.LGART`

Other Relations \| to Master Data Relations ↑	Join Conditions
Payee key for bank transfers ? Client Payee key for bank transfers	`T7BRTA.[column in domain "ENDDA"] == T521B.ENDDA` `T7BRTA.MANDT == T521B.MANDT` `T7BRTA.EMFSL == T521B.EMFSL`
Subtype ? Subtype Client ? Payee key for bank transfers	`T7BRTA.[column in domain "MOLGA"] == T521C.MOLGA` `T7BRTA.SUBTY == T521C.SUBTY` `T7BRTA.MANDT == T521C.MANDT` `T7BRTA.[column in domain "INFTY"] == T521C.INFTY` `T7BRTA.EMFSL == T521C.EMFSL`