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).