KK_XCP_SL_CF_VW

(SQL View)
 Index Back

Budget Chartfield fieldnames

The order by clause is necessary for the field values retrieved to match the order of the keys in the subrecord.

SELECT FIELDNUM , FIELDNAME FROM PSRECFIELD WHERE RECNAME = 'CFCC2_AN_SBR'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).