GPBR_STG_LPTNVW (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.

GPBR_STG_LPTNVW

(SQL View)

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_INSS.GPBR_DRIVER_SEQ , LPT_INSS.GPBR_DRV_SPLIT_SEQ , LPT_INSS.GPBR_CPF_ID , LPT_INSS.GPBR_DATE1 , LPT_INSS.GPBR_REVENUE_CODE , LPT_INSS.GPBR_ESOC_AMT_01 FROM %Table(GPBR_STG_LPT_IN) LPT_INSS , %Table(GPBR_DRIVER_DAT) DRV WHERE LPT_INSS.GPBR_DRIVER_SEQ = DRV.GPBR_DRIVER_SEQ AND LPT_INSS.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 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.
Prompt Table: GPBR_REV_CD_TBL

6 GPBR_ESOC_AMT_01 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.

#	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. Prompt Table: GPBR_REV_CD_TBL
6	GPBR_ESOC_AMT_01	Number(17,2)	DECIMAL(16,2) NOT NULL	eSocial generic amount.