GCNP_VW_BRA_LNG

(SQL View)
 Index Back

Establ -CNPJ Brazil Rel Lng

List Establishment-CNPJ Brazil Related language View

SELECT B.COMPANY ,A.ESTABID ,A.ESTAB_ID_BRA ,A.EFFDT ,D.LANGUAGE_CD ,D.DESCR FROM PS_ESTAB_ID_BRA A ,PS_ESTAB_TBL B , PS_ESTAB_TBL_BRA C , PS_ESTAB_TBL_LANG D 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 AND B.ESTABID = D.ESTABID AND B.EFFDT = D.EFFDT

  • Related Language Record for GET_CNPJ_VW_BRA

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description