COMPANY_TBL_BRA

(SQL Table)
 Index Back

Brazil specific Company Table

Brazil specific Company Table Fields

  • Parent record: COMPANY_TBL

    • # 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

    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