T5QGP

Personnel area, business subsection (Australia) | #other | Component: Australia

Column Name	Description

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
SSPSW	Sending Service Provider Role	Show values

Column Name	Description	Domain name
EGANO	Employer Group Account Number/Group Certs	CHAR9
GEMNM	Employer's Trading Name	CHAR200
GEAD1	Business Address Line 1	CHAR38
GEAD2	Business Address Line 1	CHAR38
GEORT	City	TEXT25
EMPNM	Supplier Name for Group Certificates	CHAR200
ACNNO	Australian Company Number/Group Certs	CHAR9
SUPMN	Supplier Mnemonic Payment Summary/Group Certs	NUM11
GECNM	Contact Name	CHAR38
GECPH	Phone Number	CHAR15
GECFX	Fax Number	CHAR15
EMAD1	Business Address Line 1	CHAR38
EMORT	City	TEXT25
EMPLZ	Postal Code	PSTLZ
GEPLZ	Postal Code	PSTLZ
EMCFX	Fax Number	CHAR15
EMCPH	Phone Number	CHAR15
EMCNM	Contact Name	CHAR38
EMAD2	Business Address Line 1	CHAR38
GSIGN	Authorised Signatory for Payment summary/Group Certificate	CHAR48
EMACN	Supplier Australian Company Number (ACN)	CHAR9
EMP01	Supplier Postal Address Line 1 and Line 2	CHAR38
EMP02	Supplier Postal Address Line 1 and Line 2	CHAR38
EMPSU	City	TEXT25
EMPPC	Postal Code	PSTLZ
EMPMA	Supplier Email Address	CHAR76
GETNM	Employer's Trading Name	CHAR200
EMSRF	Supplier File Reference	CHAR16
ABNUM	Australian Business Number	NUM11
ATOID	ATO corporate external gateway user ID	CHAR10
EMABN	Australian Business Number	NUM11
BRNUM	ABN Branch Number	NUM3
EMBCH	ABN Branch Number	NUM3
EMPLR	Superannuation Fund Generated Employer Identifier	P13Q_EMPLR
GECEM	Employer Email Address	CHAR76
EMNUM	Registered Agent Number	CHAR8
INABN	Australian Business Number	NUM11
INCNM	Intermediary Contact Name	CHAR200
INEMA	Intermediary E-mail Address	CHAR200
INCPH	Intermediary Business Hours Phone Number	CHAR16
SSPNM	Sending Service Provider Name	CHAR200

Master Data Relations \| to Other Relations ↓	Join Conditions
Country/Region Key Country/Region Key Client	`T5QGP.EMCOU == T005.LAND1` `T5QGP.MANDT == T005.MANDT`
Country/Region Key Country/Region Key Client	`T5QGP.EMPCO == T005.LAND1` `T5QGP.MANDT == T005.MANDT`
Region (State, Province, County) ? Region (State, Province, County)	`T5QGP.MANDT == T005S.MANDT` `T5QGP.[column in domain "LAND1"] == T005S.LAND1` `T5QGP.EMPST == T005S.BLAND`
Region (State, Province, County) ? Region (State, Province, County)	`T5QGP.MANDT == T005S.MANDT` `T5QGP.[column in domain "LAND1"] == T005S.LAND1` `T5QGP.EMREG == T005S.BLAND`
Country/Region Key Country/Region Key Client	`T5QGP.GECOU == T005.LAND1` `T5QGP.MANDT == T005.MANDT`
Region (State, Province, County) ? Region (State, Province, County)	`T5QGP.MANDT == T005S.MANDT` `T5QGP.[column in domain "LAND1"] == T005S.LAND1` `T5QGP.GEREG == T005S.BLAND`
Client	`T5QGP.MANDT == T000.MANDT`
Superannuation Modifiers Check Table Australia	`T5QGP.MANDT == T5QSZ.MANDT` `T5QGP.SUPER == T5QSZ.SUPER`

Other Relations \| to Master Data Relations ↑	Join Conditions
Personnel Subarea Personnel Subarea Personnel Area	`T5QGP.MANDT == T001P.MANDT` `T5QGP.BTRTL == T001P.BTRTL` `T5QGP.WERKS == T001P.WERKS`
Personnel Area Personnel Subarea Personnel Area	`T5QGP.MANDT == T001P.MANDT` `T5QGP.BTRTL == T001P.BTRTL` `T5QGP.WERKS == T001P.WERKS`