T7CO04A

Social insurance entities | #other | Component: Colombia
Column Name Description
MANDT FK Client
ENTIT FK Social insurance entity ID
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IDISS Social insurance flag Show values
TOTEM Summation of total number of employees by CoCd or entity Show values
PRESE Presentation form Show values
CLACO Defines the contributor type Show values
PRATE Contribution period Show values
COVHE Health coverage Show values
FFISS ISS file format Show values
TYPVI Vinculated type Show values
Column Name Description Domain name
FORMU Smart Forms: Form Name TDSFNAME
FILEP Path anme and magnetic mean for self-assessment TEXT60
CINTI Path name and self-assessment magnetic mean (ISS CINTI) TEXT50
CINTF Path name and self-assessment magnetic mean (ISS CINTF) TEXT50
CODBR Office code - Main PCO_CODBR
STCD1 Tax Number 1 STCD1
Master Data Relations Join Conditions
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • T7CO04A.MANDT == T005S.MANDT
  • T7CO04A.LAND1 == T005S.LAND1
  • T7CO04A.BLAND == T005S.BLAND
City ID
  • City ID
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • T7CO04A.CITYC == T005P.FPRCD
  • T7CO04A.MANDT == T005P.MANDT
  • T7CO04A.LAND1 == T005P.LAND1
  • T7CO04A.BLAND == T005P.BLAND
Country/Region Key
  • Country/Region Key
  • Client
  • T7CO04A.LAND1 == T005.LAND1
  • T7CO04A.MANDT == T005.MANDT
Client T7CO04A.MANDT == T000.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Social insurance entity ID
  • Social insurance entity ID
  • Client
  • ?
  • T7CO04A.ENTIT == T7CO04.ENTIT
  • T7CO04A.MANDT == T7CO04.MANDT
  • T7CO04A.[column in domain "PCO_TYPE"] == T7CO04.TYPEN