COMPANYEFFDTDefault Value: %date
ESTAB_ASOC_BRAGET_CNPJ_VW_BRA(SQL View) |
Index Back |
|---|---|
List Establishment-CNPJ BrazilList Establishment-CNPJ Brazil |
| SELECT B.COMPANY ,A.EFFDT ,A.ESTABID ,A.ESTAB_ID_BRA ,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 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | ESTAB_ASOC_BRA |
Character(12) | VARCHAR2(12) NOT NULL | Establishment CNPJ Asociated |
| 4 | ESTAB_ID_BRA | Character(20) | VARCHAR2(20) NOT NULL | Establishment ID Brazil |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |