T5QSC

Table for Superannuation SuperChoices | #transactional | Component: Australia
Column Name Description
MANDT FK Client
FCODE Super Work ChoiceFund Code
ENDDA End Date
Column Name Description
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
Column Name Description
SSZER SuperStream - Zero earning fund Show values
Column Name Description Domain name
STEXT Super Choice Fund Name PC13Q_SCODE
SFABN ABN of the Super fund DP13Q_ABN
SFN Superannuation Fund Number DP13Q_SFN
SPID Superannuation Product Identification Number DP13Q_SPIN
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 Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • T5QSC.FCOUNTRY == T005.LAND1
  • T5QSC.MANDT == T005.MANDT
Region (State, Province, County) of the Fund
  • ?
  • Region (State, Province, County) of the Fund
  • T5QSC.MANDT == T005S.MANDT
  • T5QSC.[column in domain "LAND1"] == T005S.LAND1
  • T5QSC.FSTATE == T005S.BLAND
Client T5QSC.MANDT == T000.MANDT