GL_INQ_CF01_SEL

(SQL Table)
Index Back

Chartfield Value Selector

CF selector table used in GL inquiry pages to support ChartField Value Sets.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 INQUIRY_ID Character(3) VARCHAR2(3) NOT NULL Inquiry ID
3 CFV_SET Character(20) VARCHAR2(20) NOT NULL ChartField Value Set
4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
5 RANGE_FROM Character(30) VARCHAR2(30) NOT NULL Lower boundary for detail value that contains a range of values
6 RANGE_TO Character(30) VARCHAR2(30) NOT NULL Upper boundary for detail value that contains a range of values