GPFR_DA_FORGN_COMPGPFR_FGNCMPCD_V(SQL View) |
Index Back |
|---|---|
Forign Company Details ViewForign Company Details View |
| SELECT DISTINCT GPFR_DA_CODE ,%Substring(DESCR254 ,1 ,100) FROM PS_GPFR_DT_VALUES A WHERE COUNTRY='FRA' AND GPFR_AF_APPL='DSN' AND GPFR_DA_DATTYP = 'DSN06.012' AND GPFR_DA_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_DA_FORGN_COMP |
Character(2) | VARCHAR2(2) NOT NULL | Foreign Establishkent |
| 2 | GPFR_FORGN_CMP_DES | Character(100) | VARCHAR2(100) NOT NULL | Description |