T5QSF

Superannuation Fund Code Designation Australia | #other | Component: Australia

Column Name	Description

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
SGLFU	Superannuation Guarantee Fund Flag Australia	Show values
DBFND	Defined benefit fund	Show values
SSZER	SuperStream - Zero earning fund	Show values

Column Name	Description	Domain name
EMPLR	Superannuation Fund Generated Employer Identifier	P13Q_EMPLR
DPCON	Superannuation Default Contribution Percentage	DEC3_2
RETAF	Superannuation Retirement Age for Females	P13Q_RETAF
RETAM	Superannuation Retirement Age for Males	P13Q_RETAM
EDCON	Employee Default Contribution Percentage	DEC3_2
MAXCN	Superannuation Maximum Company Contribution	P13Q_EMEAR
MINCN	Superannuation Minimum Company Contribution	P13Q_EMEAR
FACTR	Superannuation Australia Factoring Method	CHAR1
DAGWT	Superannuation Deduction WT for aged employee	LGART
AGDPC	Superannuation Default Contribution Percentage for aged emp.	DEC3_2
ABNUM	Australian Business Number	NUM11
USINO	Unique Superannuation Identification Number	CHAR14
ENDURL	End Point URL	CHAR120
ORGNAME	Sender Organization Name	CHAR120
BRANCHNUMBER	Bank State Branch Number	CHAR15
ACCOUNTNUMBER	Financial Institution Account Number	CHAR20
ACCOUNTNAME	Financial Institution Account Name	CHAR40
VENDOR	Account Number of Vendor or Creditor
CUSTOMERREFNO	Customer Reference Number	CHAR20
BPAYBILLERCODE	BPay Biller Code	CHAR10
BRANCHNAME	Financial Institution Branch Name	CHAR40
BANKNAME	Financial Institution Bank Name	CHAR40
FSTRTNO	Fund Street and House Number	PAD_STRAS
FSTRTNAME	2nd Address Line	PAD_LOCAT
FLOCALITY	City of the Fund	PAD_ORT01
FPOSTCODE	Postal Code of the Fund	PSTLZ
FTELNUM	Telephone Contact Number	CHAR10

Master Data Relations \| to Other Relations ↓	Join Conditions
Fundcodes ? Superannuation Fund Code	`T5QSF.MANDT == T591A.MANDT` `T5QSF.[column in domain "INFTY"] == T591A.INFTY` `T5QSF.FCODE == T591A.SUBTY`
Country/Region Key Country/Region Key Client	`T5QSF.FCOUNTRY == T005.LAND1` `T5QSF.MANDT == T005.MANDT`
Region (State, Province, County) of the Fund Country/Region Key Region (State, Province, County) of the Fund	`T5QSF.MANDT == T005S.MANDT` `T5QSF.FCOUNTRY == T005S.LAND1` `T5QSF.FSTATE == T005S.BLAND`
Client	`T5QSF.MANDT == T000.MANDT`
Country	`T5QSF.MOLGA == T500L.MOLGA`

Other Relations \| to Master Data Relations ↑	Join Conditions
Superannuation Contribution Wage Type ? Superannuation Contribution Wage Type ?	`T5QSF.MANDT == T5QSW.MANDT` `T5QSF.[column in domain "MOLGA"] == T5QSW.MOLGA` `T5QSF.CONCO == T5QSW.LGART` `T5QSF.[column in domain "P13Q_ASSIG"] == T5QSW.ASSIG`
Superannuation Deduction Wage Type ? Superannuation Deduction Wage Type ?	`T5QSF.MANDT == T5QSW.MANDT` `T5QSF.[column in domain "MOLGA"] == T5QSW.MOLGA` `T5QSF.DEDEO == T5QSW.LGART` `T5QSF.[column in domain "P13Q_ASSIG"] == T5QSW.ASSIG`
Superannuation W&S Earnings Cumulation Wage Type ? Superannuation W&S Earnings Cumulation Wage Type ?	`T5QSF.MANDT == T5QSW.MANDT` `T5QSF.[column in domain "MOLGA"] == T5QSW.MOLGA` `T5QSF.EACCU == T5QSW.LGART` `T5QSF.[column in domain "P13Q_ASSIG"] == T5QSW.ASSIG`
Superannuation Inflow Wageytpe ? Superannuation Inflow Wageytpe ?	`T5QSF.MANDT == T5QSW.MANDT` `T5QSF.[column in domain "MOLGA"] == T5QSW.MOLGA` `T5QSF.IFLOW == T5QSW.LGART` `T5QSF.[column in domain "P13Q_ASSIG"] == T5QSW.ASSIG`
Superannuation Outflow Wageytpe ? Superannuation Outflow Wageytpe ?	`T5QSF.MANDT == T5QSW.MANDT` `T5QSF.[column in domain "MOLGA"] == T5QSW.MOLGA` `T5QSF.OFLOW == T5QSW.LGART` `T5QSF.[column in domain "P13Q_ASSIG"] == T5QSW.ASSIG`
Ordinary Time Earnings ? Superannuation Ordinary Time Earnings Wage Type ?	`T5QSF.MANDT == T5QSW.MANDT` `T5QSF.[column in domain "MOLGA"] == T5QSW.MOLGA` `T5QSF.OTEWT == T5QSW.LGART` `T5QSF.[column in domain "P13Q_ASSIG"] == T5QSW.ASSIG`