GPBR_ES5503_TBL(SQL Table) |
Index Back |
|---|---|
eSocial S-5503 eventStore S-5503 (FGTS by Employee in Labor Proceeding) information returned by the government. |
| # | 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 | GPBR_EVENT_ID | Character(40) | VARCHAR2(40) NOT NULL | eSocial - Generate ID Number Governant |
| 4 | GPBR_RECEIPT_NUM | Character(40) | VARCHAR2(40) NOT NULL | Receipt Num |
| 5 | GPBR_CAL_PRD_ID | Character(7) | VARCHAR2(7) NOT NULL | eSocial Period Calculation |
| 6 | GPBR_COMP_INS_TYPE | Character(1) | VARCHAR2(1) NOT NULL | eSocial Company Inscription Type |
| 7 | ESTAB_ID_BRA | Character(20) | VARCHAR2(20) NOT NULL | Establishment ID Brazil |
| 8 | GPBR_ORIG_CAT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Original CAT Type. |
| 9 | GPBR_PROC_NUM | Character(30) | VARCHAR2(30) NOT NULL | Proceeding Number |
| 10 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |