GPBR_ES5003_EST

(SQL Table)
Index Back

Establishment and tax info

Store S-5003 (identification of the establishment or building construction location and its tax related information) returned by the government.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPBR_DRIVER_SEQ Number(30,0) DECIMAL(30) NOT NULL Driver Sequence
2 GPBR_DRV_SPLIT_SEQ Number(20,0) DECIMAL(20) NOT NULL eSocial - Split Sequence
3 GPBR_ESTAB_IN_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Establishment Inscription Type
1=CNPJ
3=CAEPF
4=CNO
4 GPBR_ESTAB_ID_EST Character(20) VARCHAR2(20) NOT NULL Establishment ID
5 GPBR_COD_LOCAT Character(30) VARCHAR2(30) NOT NULL eSocial Location Code
6 LOCAT_TYPE_BRA Character(2) VARCHAR2(2) NOT NULL eSocial Location Type
7 ESTAB_TYPE_CD_BRA Character(1) VARCHAR2(1) NOT NULL Establishment Type Code
1=Micro
2=Small
3=Other
8 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil