LED_INQ_CFV_SEL

(SQL Table)
Index Back

ChartField Value Selector

CF selector table used in RTBL Ledger Scenario Inquiry 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 SCE_ID Character(10) VARCHAR2(10) NOT NULL RTBL Scenario 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