GPBR_ES5002_DAY

(SQL Table)
Index Back

Income tax information

Income tax information: dmDev tag fields in S-5002 file for Daily Calculation.

# 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_PER_REF Character(7) VARCHAR2(7) NOT NULL eSocial Reference Period
4 GPBR_IDE_DMDEV Character(30) VARCHAR2(30) NOT NULL eSocial Unique payment identifier.
5 GPBR_PAY_TP Character(1) VARCHAR2(1) NOT NULL Patyment TP
0=N/A
1=Payroll
2=Termination
3=Term Non Empl
7=Vacation
6 GPBR_IRRF_DAY Character(2) VARCHAR2(2) NOT NULL Day of IRRF Daily Calculation for S-5002 event.
7 GPBR_IRRF_CODE Character(6) VARCHAR2(6) NOT NULL IRRF Code.
8 GPBR_ESOC_AMT_01 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
9 GPBR_ESOC_AMT_02 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.