GET_CNPJ_VW_BRA

(SQL View)
 Index Back

List Establishment-CNPJ Brazil

List Establishment-CNPJ Brazil

SELECT B.COMPANY ,A.ESTABID ,A.ESTAB_ID_BRA ,A.EFFDT ,B.DESCR FROM PS_ESTAB_ID_BRA A , PS_ESTAB_TBL B , PS_ESTAB_TBL_BRA C WHERE A.ESTAB_ID_TYPE_BRA = 'CNPJ' AND A.COUNTRY = 'BRA' AND B.ESTABID = A.ESTABID AND B.EFFDT = A.EFFDT AND C.ESTABID = A.ESTABID AND C.EFFDT = A.EFFDT

  • Related Language Record: GCNP_VW_BRA_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 ESTAB_ASOC_BRA Character(12) VARCHAR2(12) NOT NULL Establishment CNPJ Asociated
    3 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description