FS_CF_TMPLFLDVW

(SQL View)
 Index Back

Chartfield Template Table

Chartfield Te

SELECT FIELDNAME ,CF_ORDER ,ORIG_CF_NAME FROM PS_FS_CF_TEMPLATE UNION SELECT FIELDNAME , 99 , FIELDNAME FROM PS_ACCT_ATTRIB_TBL WHERE FIELDNAME = 'BOOK_CODE' AND ACTIVE_FLAG <> 'Y' UNION SELECT FIELDNAME , ( SELECT COUNT(CF_ORDER)+1 FROM PS_FS_CF_TEMPLATE WHERE CF_ACTIVE_STATUS = 'A') , FIELDNAME FROM PS_ACCT_ATTRIB_TBL WHERE FIELDNAME = 'BOOK_CODE' AND ACTIVE_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
2 CF_ORDER Number(2,0) SMALLINT NOT NULL ChartField Sequence Order
3 ORIG_CF_NAME Character(18) VARCHAR2(18) NOT NULL Holds the Original Chartfield Name. This will not change!