FPY_CMP_VW(SQL View) |
Index Back |
|---|---|
Position ViewPosition view |
| SELECT COMPANY , DESCR , FPY_LEGALENTITY_ID , FPY_MODE FROM PS_FPY_COMPANY_STG WHERE FPY_BYPASS_FLG <>'Y' AND FPY_PROCESSED_FLG <> 'Y' GROUP BY COMPANY , FPY_LEGALENTITY_ID , FPY_MODE, DESCR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | FPY_LEGALENTITY_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field to hold the value of Company coming from Fusion. |
| 4 | FPY_MODE | Character(1) | VARCHAR2(1) NOT NULL | FPY_MODE |