T7HRA3

IP Form - Earnings | #masterdata | Component: Croatia

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

Column Name	Description
MANDT	Client
TYEAR FK	Tax year for IP form
BUKRS FK	Company Code
JMBG FK	Unique personal identification number
PERNR FK	Personnel Number
PAYTX	Pay date for payroll result
INDBW	Indicator for indirect valuation
PAYTY	Payroll type	Show values
PAYID	Payroll Identifier

Column Name	Description
💲 Currency Key (T500C.WAERS):
GROSS	Total gross amount
INSUR	Insurance
UNTAE	Extra untaxable
UNTAP	Used untaxable pay
AMTTX	Tax amount and surtax

Column Name	Description

Column Name	Description
PAYTX	Pay date for payroll result

Column Name	Description
PAYTY	Payroll type	Show values

Column Name	Description	Domain name
MUNCO	Municipality Code HR	CHAR8

Master Data Relations	Join Conditions
Company Code Unique personal identification number Personnel Number Client Tax year for IP form Company Code	`T7HRA3.JMBG == T7HRA2.JMBG` `T7HRA3.PERNR == T7HRA2.PERNR` `T7HRA3.MANDT == T7HRA2.MANDT` `T7HRA3.TYEAR == T7HRA2.TYEAR` `T7HRA3.BUKRS == T7HRA2.BUKRS`
Unique personal identification number Unique personal identification number Personnel Number Client Tax year for IP form Company Code	`T7HRA3.JMBG == T7HRA2.JMBG` `T7HRA3.PERNR == T7HRA2.PERNR` `T7HRA3.MANDT == T7HRA2.MANDT` `T7HRA3.TYEAR == T7HRA2.TYEAR` `T7HRA3.BUKRS == T7HRA2.BUKRS`
Personnel Number Unique personal identification number Personnel Number Client Tax year for IP form Company Code	`T7HRA3.JMBG == T7HRA2.JMBG` `T7HRA3.PERNR == T7HRA2.PERNR` `T7HRA3.MANDT == T7HRA2.MANDT` `T7HRA3.TYEAR == T7HRA2.TYEAR` `T7HRA3.BUKRS == T7HRA2.BUKRS`
Tax year for IP form Unique personal identification number Personnel Number Client Tax year for IP form Company Code	`T7HRA3.JMBG == T7HRA2.JMBG` `T7HRA3.PERNR == T7HRA2.PERNR` `T7HRA3.MANDT == T7HRA2.MANDT` `T7HRA3.TYEAR == T7HRA2.TYEAR` `T7HRA3.BUKRS == T7HRA2.BUKRS`