GPBR_ES5011_CRE(SQL Table) |
Index Back |
---|---|
Establishment ID infoEstablishment ID information: ideEstab tag fields in S-5011 file. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(30,0) | DECIMAL(30) NOT NULL | Driver Sequence | |
2 | Number(20,0) | DECIMAL(20) NOT NULL | eSocial - Split Sequence | |
3 | Character(1) | VARCHAR2(1) NOT NULL |
eSocial Establishment Inscription Type
1=CNPJ 3=CAEPF 4=CNO |
|
4 | Character(20) | VARCHAR2(20) NOT NULL | Establishment ID | |
5 | 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. |