GPBR_DRVWAG_XRF(SQL Table) |
Index Back |
---|---|
eSocial Wage Type Cross RefeSocial Wage Type Cross Reference Table. This record is composed by fields that are common to events to Wage Type. Each event that shall be sent to the government has an entry on this table. |
# | 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_EVENT_CD | Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
3 | GPBR_WAGE_TYPES_ID | Character(8) | VARCHAR2(8) NOT NULL | Wages Types IDs for eSocial Brazil |
4 | PIN_ELEM_NUM | Number(8,0) | INTEGER NOT NULL | Element Number |
5 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
6 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |
7 | GPBR_PRV_DT | Date(10) | DATE | eSocial Previous Date |