GPBR_STG_LPR_VW

(SQL View)
 Index Back

Income Tax Details

Income Tax Details in Labor Proceeding Tax BRA.

SELECT REV.GPBR_DRIVER_SEQ , REV.GPBR_DRV_SPLIT_SEQ , REV.COMPANY , REV.GPBR_PROC_NUM , REV.GPBR_ESOC_YEAR , REV.GPBR_ESOC_MONTHCD , REV.GPBR_CPF_ID , REV.GPBR_REVENUE_CODE , REV.AMOUNT1_BRA , REV.GPBR_ESOC_AMT_01 , REV.GPBR_ESOC_AMT_02 , REV.GPBR_ESOC_AMT_03 , REV.GPBR_ESOC_AMT_04 , REV.GPBR_ESOC_AMT_05 , REV.GPBR_ESOC_AMT_06 , REV.GPBR_ESOC_AMT_07 , REV.GPBR_DESCR60 FROM %Table(GPBR_STG_LP_REV) REV , %Table(GPBR_DRIVER_DAT) DRV WHERE REV.GPBR_DRIVER_SEQ = DRV.GPBR_DRIVER_SEQ AND REV.GPBR_DRV_SPLIT_SEQ = DRV.GPBR_DRV_SPLIT_SEQ AND DRV.GPBR_STATUS = 'XRDY'

# 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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: GPBR_COMPBRA_VW

4 GPBR_PROC_NUM Character(30) VARCHAR2(30) NOT NULL Proceeding Number
5 GPBR_ESOC_YEAR Number(4,0) SMALLINT NOT NULL Competency Year
6 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
7 GPBR_CPF_ID Character(11) VARCHAR2(11) NOT NULL eSocial National ID Number
8 GPBR_REVENUE_CODE Character(6) VARCHAR2(6) NOT NULL Revenue Code.
9 AMOUNT1_BRA Number(17,2) DECIMAL(16,2) NOT NULL Amount
10 GPBR_ESOC_AMT_01 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
11 GPBR_ESOC_AMT_02 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
12 GPBR_ESOC_AMT_03 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
13 GPBR_ESOC_AMT_04 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
14 GPBR_ESOC_AMT_05 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
15 GPBR_ESOC_AMT_06 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
16 GPBR_ESOC_AMT_07 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
17 GPBR_DESCR60 Character(60) VARCHAR2(60) NOT NULL Description of length 60.