COMP_TBL_BRA(SQL Table) |
Index Back |
|---|---|
eSocial Company Table BRACompany Table BRA to store eSocial company related data. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | TAX_CLASSIF_BRA | Character(2) | VARCHAR2(2) NOT NULL |
Tax Classification Field.
Prompt Table: TAX_CLASSIF_BRA |
| 4 | IND_COOPER_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Cooperative Indicator for Brazil Company.
0=Non Cooperative Society 1=Cooperative Work 2=Cooperative Production 3=Other type Default Value: 0 |
| 5 | IND_CONSTRUC_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Construction Indicator for Brazil Company.
Y/N Table Edit Default Value: N |
| 6 | OSTEN_PARTNER_BRA | Character(1) | VARCHAR2(1) NOT NULL |
To Track Ostensive Partner for Brazil Company.
Y/N Table Edit Default Value: N |
| 7 | SPCL_PARTNER_BRA | Character(1) | VARCHAR2(1) NOT NULL |
To track Special Partnership Company Situation.
0=Normal Situation 1=Extinction 2=Merger 3=Split 4=Incorporation Default Value: 0 |
| 8 | EDUC_ENT_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Education Entity Contract
N=No Y=Yes |
| 9 | ORG_CONV_DT_BRA | Date(10) | DATE | Date Conversion to Profit Organization |
| 10 | PIS_COFINS_TAX_BRA | Character(1) | VARCHAR2(1) NOT NULL |
PIS/COFINS Tax Indicator.
Y/N Table Edit |