T5V2G

Connection org. numbers and rep. org. number | #other | Component: Norway
Column Name Description
CLIENT FK Client
ORGBE FK Firm org. number (bedriftsnummer)
ENDDA End Date
Column Name Description
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
Column Name Description
ERC_ZONE Zone for ERC rate Show values
Column Name Description Domain name
BANKID Short Key for a House Bank HBKID
KONTOID ID for Account Details HKTID
EMPORG Employers Organisation CHAR4
MLEGE Maximum length of self-declared illness in days
MOEGE Max. no. of occurences of self-declared illness
MLEGETOT Maximum length of self-declared illness in days per 12 month
TELNR Telephone Number TELNR
BANKN Bank account number BANKN
CONTACT_NAME Contact Person Name for Reimbursement TEXT80
Master Data Relations | to Other Relations ↓ Join Conditions
Business sector ("Bransje")
  • Business sector ("Bransje")
  • Client
  • T5V2G.BUAREA == T5V6A.BUAREA
  • T5V2G.CLIENT == T5V6A.MANDT
Client T5V2G.CLIENT == T000.MANDT
NACE Code - Code to identify the branch of a company
  • ?
  • Client
  • NACE Code - Code to identify the branch of a company
  • T5V2G.[column in domain "ENDDA"] == T5V2J.ENDDA
  • T5V2G.CLIENT == T5V2J.CLIENT
  • T5V2G.NACE == T5V2J.NACE
Organisation group(Organisasjonsledd)
  • Organisation group(Organisasjonsledd)
  • Client
  • T5V2G.ORGLED == T5V2O.ORGLED
  • T5V2G.CLIENT == T5V2O.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Layout rule for address type
  • Layout rule for address type
  • Client
  • ?
  • ?
  • T5V2G.ARBGID == T536A.VARGU
  • T5V2G.CLIENT == T536A.MANDT
  • T5V2G.[column in domain "P00_SEQNA"] == T536A.SEQNU
  • T5V2G.[column in domain "ANART"] == T536A.ANART
Municipality Number
  • ?
  • Municipality Number
  • T5V2G.[column in domain "ENDDA"] == T5V2A.ENDDA
  • T5V2G.MUNICC == T5V2A.MUNIC
Firm org. number (bedriftsnummer)
  • T5V2G.CLIENT == T5V2L.CLIENT
  • T5V2G.ORGBE == T5V2L.ORGBE
Legal org. number (juridisk nummer)
  • T5V2G.CLIENT == T5V2M.CLIENT
  • T5V2G.ORGJU == T5V2M.ORGJU
Layout rule for address type
  • Layout rule for address type
  • Client
  • ?
  • ?
  • T5V2G.PEAVDID == T536A.VARGU
  • T5V2G.CLIENT == T536A.MANDT
  • T5V2G.[column in domain "P00_SEQNA"] == T536A.SEQNU
  • T5V2G.[column in domain "ANART"] == T536A.ANART
Organizations number used for tax and ERC reporting
  • T5V2G.CLIENT == T5V2I.CLIENT
  • T5V2G.REPNR == T5V2I.REPNR