COMBO_CFDEFN_VW

(SQL View)
 Index Back

Combination CF Definition Vw

Combo Rule - Chartfield values - View

SELECT a.business_unit , a.ledger_group , b.setid , b.process_group , b.combination , c.combo_defn_name , d.field_sequence , d.chartfield , 'N' , f.length ,a.combo_tran_src_opt FROM ps_bu_led_comb_tbl a , ps_combo_grrul_tbl b , ps_combo_rule_tbl c , ps_combo_flds_tbl d , ps_set_cntrl_rec x , PSDBFIELD f WHERE a.process_group = b.process_group AND b.setid = x.setid AND x.setcntrlvalue = a.business_unit AND x.recname = 'COMBO_RULE_TBL' AND b.setid = c.setid AND b.combination= c.combination AND c.setid = d.setid AND c.combo_defn_name = d.combo_defn_name AND d.field_sequence = 1 AND f.fieldname = d.chartfield

  • Parent record: LED_DEFN_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    4 PROCESS_GROUP Character(10) VARCHAR2(10) NOT NULL Process Group
    5 COMBINATION Character(10) VARCHAR2(10) NOT NULL Combination Rule
    6 COMBO_DEFN_NAME Character(10) VARCHAR2(10) NOT NULL Combo CF Definition
    7 FIELD_SEQUENCE Number(3,0) SMALLINT NOT NULL Field Sequence Number
    8 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
    9 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
    N=No
    Y=Yes
    10 LENGTH Number(5,0) INTEGER NOT NULL Length
    11 COMBO_TRAN_SRC_OPT Character(1) VARCHAR2(1) NOT NULL Combo Edit Transaction Source Option
    A=All Transaction Sources
    V=Specific Transaction Source