BU_LED_FVW

(SQL View)
 Index Back

Chartfield & Recname View


SELECT A.SETID , A.CHARTFIELD , A.RECNAME FROM PS_LED_GRP_FLD_TBL A , PS_BU_LED_GRP_TBL B WHERE DEFAULT_LEDGER_GRP = 'Y' AND A.LEDGER_GROUP = B.LEDGER_GROUP GROUP BY A.SETID, A.CHARTFIELD, A.RECNAME

  • 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 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).