T5UTV

Unemployment Insurance Work Sites/NC-9901 Locations | #other | Component: USA

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

Column Name	Description
MANDT FK	Client
TXCMP FK	Tax company
TAXAU FK	Tax authority
WKSIT	Worksite
ENDDA	End Date

Column Name	Description

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
NCSTA	HR-US: NC-9901 Status	Show values

Column Name	Description	Domain name
LTEXT	Description	TEXT30
ADRES	Address Text (Name, Street, City, Tel. No.)	TEXT40
STRAS	Street and House Number	TEXT30
ORT01	City	TEXT25
ZIPCD	Postal Code	PSTLZ
TELNR	Telephone Number	TELNR
REPUN	Worksite Reporting Unit Number	NUMC5
NCLOC	NC9901 Location Code	CHAR9

Master Data Relations	Join Conditions
Client	`T5UTV.MANDT == T000.MANDT`
HR-US: NC-9901 Major Activity HR-US: NC-9901 Major Activity Client	`T5UTV.NCACT == T5UMA.MACODE` `T5UTV.MANDT == T5UMA.MANDT`
Region (State, Province, County) ? Region (State, Province, County)	`T5UTV.MANDT == T005S.MANDT` `T5UTV.[column in domain "LAND1"] == T005S.LAND1` `T5UTV.STATE == T005S.BLAND`
Tax Company Tax company Client	`T5UTV.TXCMP == T5UTL.TXCMP` `T5UTV.MANDT == T5UTL.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Tax Authority Tax authority Client	`T5UTV.TAXAU == T5UTZ.TAXAU` `T5UTV.MANDT == T5UTZ.MANDT`