GPBR_ES5011_CRE

(SQL Table)
Index Back

Establishment ID info

Establishment ID information: ideEstab tag fields in S-5011 file.

# 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_DED_CD Character(6) VARCHAR2(6) NOT NULL Social security deduction code.
6 GPBR_ESOC_AMT_15 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
7 GPBR_ESOC_AMT_16 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.