| # |
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 |
NATURE_DCLARER_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Declarer's Nature for Brazil's Company Table
00=Individual/Legal Ent. Priv Law
01=Agencies, Federal Public Admin
02=Agencies, St/Municipal Pub Adm
03=Institution with Funds Admin
04=MixC/PubFedCo.Inv.Fun/ClubAdm
05=MixC/PubFedCo(-)Inv.Fun/CluAdm
06=MixC/StMunCo.Inv.Fun/ClubAdm
07=MixC/St.Mun.Co(-)InvFun/ClbAdm
08=Other
09=Legal Entity - Organization
Default Value: 04
|
| 4 |
SIMPLES_OPTION_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Option Simples Brazil
01=Non Opting
02=Opting
03=Opting + 1.200.000,00 Annual
04=Non Opting + 1.200.000,00 Annl
05=No Opting Company with Injunc
06=Opting + 1.200.000 with Injunc
Default Value: 02
|
| 5 |
REG_NUM_MTHD_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Last Registration Number Method
01=Company
02=Establishment ID
Default Value: 01
|
| 6 |
LAST_REG_NUM_BRA |
Number(11,0) |
DECIMAL(11) NOT NULL |
Used to keep the last employee registry number for an establishment
Default Value: 1
|
| 7 |
ESOC_NUM_MTHD_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
eSocial Number Method
01=DRT Number
02=Specific to eSocial
Default Value: 02
|
| 8 |
LAST_REG_ESOC_BRA |
Character(30) |
VARCHAR2(30) NOT NULL |
Las Reg Number
|
| 9 |
MULT_TBL_ED_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Earn/Ded Tables
N=No
Y=Yes
Default Value: N
|
| 10 |
ID_TBL_ED_BRA |
Character(8) |
VARCHAR2(8) NOT NULL |
Earn/ Ded ID Table
Prompt Table:
%EDITTABLE
|