GPBR_STG_LCTN(SQL Table) |
Index Back |
---|---|
Basic Table - Tax Location TabeSocial 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. |