AM_CON_ACTCH_VW(SQL View) |
Index Back |
---|---|
Consolidation Chartfields |
SELECT A.FIELDNAME FROM PSRECFIELDDB A WHERE A.RECNAME = 'ASSET_CON_WRK' AND EXISTS ( SELECT 'X' FROM PS_FS_CF_TEMPLATE C WHERE C.FIELDNAME = A.FIELDNAME AND (C.CF_ACTIVE_STATUS = 'I' OR C.CF_TYPE = 'A')) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |