T5JSI

HR Branch Office Information for Social Insurance JP | #other | Component: Japan
Column Name Description
MANDT FK Client
SCIMF Social Insurance Modifier
Column Name Description
Column Name Description
Column Name Description
Column Name Description
HIRUL Rule for Health Insurance in Santei/Geppen Process Show values
EPRUL Rule for Employee's Pension in Santei/Geppen Show values
RULNI Payment rule for Nursing insurance Show values
PTRUL Santei evaluation rule for parttime workers(Japan) Show values
IKRUL Basic specifications for IKKATSU TEKIYOU Show values
REGIN Region Code Show values
Column Name Description Domain name
PSTLZ Postal Code PSTLZ
ORT01 Line of Address in Kanji TEXT30
ORT02 Line of Address in Kanji TEXT30
STRAS Line of Address in Kanji TEXT30
JGSNM Name of Branch office TEXT50
JGNPS Title of Representative Person TEXT20
JGNPR Name of Representative Person TEXT40
TELNR Telephone Number TELNR
SCICA Social Insurance Code (Area) TEXT8
SCICC Social Insurance Code (Name) TEXT8
SCINR Social Insurance given number TEXT5
SCICN Social Insurance Code (Number) TEXT6
SCIHI Office ID for HI Union TEXT8
SCIPF Office ID for Pension Fund TEXT8
SCIPN Office number for Pension Fund TEXT8
SCICS Social insurance sign (area) TEXT8
CJPRK Name of Representative (Kana) TEXT80
CJNMK Company Name in Katakana (Legal Person) TEXT100
CJGNN Name of Company (Legal Person) TEXT50
CJDPK Department Name (Kana) TEXT80
CJGND Department Name TEXT80
CPSTL Postal Code PSTLZ
CORT1 Line of Address in Kanji TEXT30
CORT2 Line of Address in Kanji TEXT30
CSTRA Line of Address in Kanji TEXT30
CAKN1 Line of Address in Katakana TEXT60
CAKN2 Line of Address in Katakana TEXT60
CAKN3 Line of Address in Katakana TEXT60
CTELN Telephone Number TELNR
CFAXN Fax Number CHAR14
CEMAD E-mail Address TEXT80
DSTID Destination Identifier CHAR23
DSTXT Text of Destination Identifier TEXT80
Master Data Relations Join Conditions
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • T5JSI.MANDT == T005E.MANDT
  • T5JSI.CCOUN == T005E.COUNC
  • T5JSI.CLAND == T005E.LAND1
  • T5JSI.CSTAT == T005E.REGIO
Country/Region Key
  • Country/Region Key
  • Client
  • T5JSI.CLAND == T005.LAND1
  • T5JSI.MANDT == T005.MANDT
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • T5JSI.MANDT == T005E.MANDT
  • T5JSI.COUNC == T005E.COUNC
  • T5JSI.LAND1 == T005E.LAND1
  • T5JSI.STATE == T005E.REGIO
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • T5JSI.MANDT == T005S.MANDT
  • T5JSI.CLAND == T005S.LAND1
  • T5JSI.CSTAT == T005S.BLAND
Country/Region Key
  • Country/Region Key
  • Client
  • T5JSI.LAND1 == T005.LAND1
  • T5JSI.MANDT == T005.MANDT
Client T5JSI.MANDT == T000.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • T5JSI.MANDT == T005S.MANDT
  • T5JSI.LAND1 == T005S.LAND1
  • T5JSI.STATE == T005S.BLAND