BU_LED_ADB_VW

(SQL View)
 Index Back

Ledgers for a Business Unit


SELECT A.BUSINESS_UNIT ,A.LEDGER ,A.LEDGER_GROUP ,B.ADB_REPORTING FROM PS_BU_LED_TBL A , PS_BU_LED_GRP_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.LEDGER_GROUP = B.LEDGER_GROUP AND B.LEDGER_TYPE = 'D'

  • Parent record: BU_LED_GRP_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    3 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
    4 ADB_REPORTING Character(1) VARCHAR2(1) NOT NULL Report Average Balances