T7BREFD_EEDOCS

Employee identification documents | #transactional | Component: Brazil
Column Name Description
MANDT FK Client
EVENT_ID FK Event identifier
RECORD_ID Record code
Column Name Description
Column Name Description
Column Name Description
RIC_ISSUE_DT Issuing date of the civil identity registry
RG_ISSUE_DT Issuing date of the ID card
RNE_ISSUE_DT Issuing date of the national foreigner registry
OC_ISSUE_DT Issuing date of the registration in class entity
OC_VALIDITY_DT Validity date of the registration in class entity
CHN_ISSUE_DT Driver's license issuing date
CNH_VALIDITY_DT Driver's license validity date
CNH_EXPEDITION First qualification date (CNH)
Column Name Description
CTPS_STATE State (FU) Show values
Column Name Description Domain name
PARENT_ID Parent record code NUMC09
CTPS_NUMBER Worker's Card for Social Welfare number - WCSW PBR_CTNR
CTPS_SERIES Worker's Card series number - WCSW PBR_CTSR
RIC_NUMBER Civil identity registry number (RIC) PBR_CPFNR
RIC_ISSUER null
RG_NUMBER Identification Document number PBR_IDNR
RG_ISSUER null
RNE_NUMBER Foreign Identification Document number PBR_IDFNR
RNE_ISSUER null
OC_NUMBER Registration number in the class body CHAR14
OC_ISSUER null
CNH_NUMBER Professional Driver's License number PBR_DRVNR
CNH_ISSUER null
RIC_ISSUER_ORG Issuing authority of the civil identity registry HRPADBR_DOC_ISSUER
RG_ISSUER_ORG Issuing authority of the ID card HRPADBR_DOC_ISSUER
RNE_ISSUER_ORG Issuing authority of the national foreigner registry HRPADBR_DOC_ISSUER
OC_ISSUER_ORG Issuing authority of the registration in class entity HRPADBR_DOC_ISSUER
CNH_ISSUER_ORG Driver's license issuing authority HRPADBR_DOC_ISSUER
CNH_UF CNH issuing federation state CHAR2
CNH_CATEGORY CNH category HRPADBR_EFD_CNH_CATEGORY
Master Data Relations Join Conditions
Event identifier
Client T7BREFD_EEDOCS.MANDT == T000.MANDT