GPBR_ES_TE_DTL (SQL Table)	Index Back
eSocail Tax Reduction eSocail Tax Reduction

GPBR_ES_TE_DTL

(SQL Table)

eSocail Tax Reduction

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: GPBR_ES_CMP2_VW

2 YEARCD Character(4) VARCHAR2(4) NOT NULL Calendar Year

3 GPBR_ESOC_MONTHCD Character(2) VARCHAR2(2) NOT NULL eSocial Competency Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December

4 GPBR_ES_PERIOD_TP Character(1) VARCHAR2(1) NOT NULL eSocial Period Type
1=Monthly
2=Annual

5 GPBR_ES_REV_AMT Signed Number(27,2) DECIMAL(25,2) NOT NULL Total Gross RevenueeSocail

6 GPBR_ES_REV_ACT Signed Number(27,2) DECIMAL(25,2) NOT NULL Total Gross RevenueeSocail

7 GPBR_ES_PERC_RE Number(6,2) DECIMAL(5,2) NOT NULL eSocial % Reduction

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: GPBR_ES_CMP2_VW
2	YEARCD	Character(4)	VARCHAR2(4) NOT NULL	Calendar Year
3	GPBR_ESOC_MONTHCD	Character(2)	VARCHAR2(2) NOT NULL	eSocial Competency Month 01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December
4	GPBR_ES_PERIOD_TP	Character(1)	VARCHAR2(1) NOT NULL	eSocial Period Type 1=Monthly 2=Annual
5	GPBR_ES_REV_AMT	Signed Number(27,2)	DECIMAL(25,2) NOT NULL	Total Gross RevenueeSocail
6	GPBR_ES_REV_ACT	Signed Number(27,2)	DECIMAL(25,2) NOT NULL	Total Gross RevenueeSocail
7	GPBR_ES_PERC_RE	Number(6,2)	DECIMAL(5,2) NOT NULL	eSocial % Reduction