GPBR_STG_LCTN

(SQL Table)
Index Back

Basic Table - Tax Location Tab

eSocial Stage Table This record is used to generate informations for eSocial layout S-1020 - Basic Table - Tax Location Table

# 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_TP_ENV Character(1) VARCHAR2(1) NOT NULL eSocial Environment Identification
4 GPBR_ISSUER Number(1,0) SMALLINT NOT NULL eSocial Issuer
5 GPBR_COMP_INS_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Company Inscription Type
6 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
7 GPBR_COD_LOCAT Character(30) VARCHAR2(30) NOT NULL eSocial Location Code
8 BEGIN_DT Date(10) DATE Begin Date
9 GPBR_PER_END_DT Date(10) DATE Period End Date -- Vacations Brazil
10 TP_LOCAT_BRA Character(2) VARCHAR2(2) NOT NULL Location Type
01=Regular / Construction
02=Partial Contract
03=Partial Contract
11=Different FPAS/Third
90=Location Outside Country
11 GPBR_COM_INS_TYPEE Character(2) VARCHAR2(2) NOT NULL Company Inscription Type
12 GPBR_ESTAB_ID_EST Character(20) VARCHAR2(20) NOT NULL Establishment ID
13 FPAS_CD_BRA Number(3,0) SMALLINT NOT NULL FPAS Social Assistant & Prevision Code
14 GPBR_THIRD_PARTY Character(4) VARCHAR2(4) NOT NULL eSocial Third Party Code
15 GPBR_TAKE_INS_TYPE Character(1) VARCHAR2(1) NOT NULL Service Taker Inscription Type
1=Juridic Person National Reg
2=INSS Special Register
3=Phisic Person National Reg
16 GPBR_TAKER_INSCR Character(14) VARCHAR2(14) NOT NULL Service Taker Inscription
17 GPBR_OWNER_TP Number(1,0) SMALLINT NOT NULL eSocial Number Process Judicial
18 GPBR_CNO_OWNER Character(14) VARCHAR2(14) NOT NULL eSocial Owner Inscription
19 GPBR_INI_VAL_DATE Date(10) DATE Initial Validity Date
20 GPBR_END_VAL_DATE Date(10) DATE End Validity Date
21 THIRD_PT_SUS_BRA Number(4,0) SMALLINT NOT NULL Third Party Code Susp.