GPBR_STG_LPT_VW

(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 LP_TAX.GPBR_DRIVER_SEQ , LP_TAX.GPBR_DRV_SPLIT_SEQ , DRV.GPBR_EVENT_ID , LP_TAX.GPBR_RECT , LP_TAX.GPBR_RECEIPT_NUM , LP_TAX.GPBR_TP_ENV , LP_TAX.GPBR_ISSUER , LP_TAX.GPBR_VERSION , LP_TAX.GPBR_COMP_INS_TYPE , LP_TAX.ESTAB_ID_BRA , LP_TAX.GPBR_PROC_NUM , LP_TAX.GPBR_DATE1 , LP_TAX.GPBR_COMMENTS FROM %Table(GPBR_STG_LP_TAX) LP_TAX , %Table(GPBR_DRIVER_DAT) DRV WHERE LP_TAX.GPBR_DRIVER_SEQ = DRV.GPBR_DRIVER_SEQ AND LP_TAX.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_EVENT_ID Character(40) VARCHAR2(40) NOT NULL eSocial - Generate ID Number Governant
4 GPBR_RECT Number(30,0) DECIMAL(30) NOT NULL eSocial Ind Calculation
5 GPBR_RECEIPT_NUM Character(40) VARCHAR2(40) NOT NULL Receipt Num
6 GPBR_TP_ENV Character(1) VARCHAR2(1) NOT NULL eSocial Environment Identification
7 GPBR_ISSUER Number(1,0) SMALLINT NOT NULL eSocial Issuer
8 GPBR_VERSION Character(9) VARCHAR2(9) NOT NULL eSocial version
9 GPBR_COMP_INS_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Company Inscription Type
10 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
11 GPBR_PROC_NUM Character(30) VARCHAR2(30) NOT NULL Proceeding Number
12 GPBR_DATE1 Date(10) DATE Date 1
13 GPBR_COMMENTS Long Character CLOB Comments.