GPBR_STG_PTEEVW

(SQL View)
 Index Back

Labor Proceeding Tax BRA

Staging Record View. This record is used to generate information related to eSocial layout S-2501 - Labor Proceeding Tax.

SELECT LPT_PE.GPBR_DRIVER_SEQ , LPT_PE.GPBR_DRV_SPLIT_SEQ , LPT_PE.GPBR_CPF_ID , LPT_PE.GPBR_DATE1 , LPT_IN.GPBR_REVENUE_CODE , LPT_IN.GPBR_ESOC_AMT_01 , LPT_PE.GPBR_ESOC_AMT_01 , LPT_PE.GPBR_ESOC_AMT_02 , LPT_PE.GPBR_ESOC_AMT_03 , LPT_PE.GPBR_ESOC_AMT_04 FROM %Table(GPBR_STG_LPT_PE) LPT_PE , %Table(GPBR_STG_LPT_IN) LPT_IN , %Table(GPBR_DRIVER_DAT) DRV WHERE LPT_PE.GPBR_DRIVER_SEQ = DRV.GPBR_DRIVER_SEQ AND LPT_PE.GPBR_DRV_SPLIT_SEQ = DRV.GPBR_DRV_SPLIT_SEQ AND DRV.GPBR_STATUS = 'XRDY' AND LPT_IN.GPBR_DRIVER_SEQ = LPT_PE.GPBR_DRIVER_SEQ AND LPT_IN.GPBR_DRV_SPLIT_SEQ = LPT_PE.GPBR_DRV_SPLIT_SEQ AND LPT_IN.GPBR_CPF_ID = LPT_PE.GPBR_CPF_ID AND LPT_IN.GPBR_DATE1 = LPT_PE.GPBR_DATE1

# 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_CPF_ID Character(11) VARCHAR2(11) NOT NULL eSocial National ID Number
4 GPBR_DATE1 Date(10) DATE Date 1
5 GPBR_REVENUE_CODE Character(6) VARCHAR2(6) NOT NULL Revenue Code.
6 GPBR_ESOC_AMT_01 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
7 GPBR_ESOC_AMT_02 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
8 GPBR_ESOC_AMT_03 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
9 GPBR_ESOC_AMT_04 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
10 GPBR_ESOC_AMT_05 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.