BD_LED_FLDS_VW

(SQL View)
 Index Back

Budget Ledger Chartfields


SELECT DISTINCT A.SETID , A.LEDGER , B.CF_ORDER , A.FIELD_SEQUENCE , A.CHARTFIELD , ' ' , A.RECNAME FROM PS_LED_FLDS_TBL A , PS_FS_CF_TEMPLATE B WHERE A.CHARTFIELD = B.FIELDNAME (+) AND A.CHARTFIELD NOT IN ('BUSINESS_UNIT','CURRENCY_CD') AND A.CHARTFIELD NOT IN ( SELECT FIELDNAME FROM PS_FS_CF_TEMPLATE WHERE CF_ACTIVE_STATUS <> 'A' OR DELETE_CF = 'Y')

  • Parent record: LED_DEFN_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    3 CF_ORDER Number(2,0) SMALLINT NOT NULL ChartField Sequence Order
    4 FIELD_SEQUENCE Number(3,0) SMALLINT NOT NULL Field Sequence Number
    5 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
    6 CHARTFIELD_VALUE Character(30) VARCHAR2(30) NOT NULL ChartField Value

    Prompt Table: %EDITTABLE2

    7 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).