CNAO_BU_LG_VW

(SQL View)
Index Back

Ledger Group prompt view

Ledger Group prompt view for CNAO Adjustment Periods Setup

SELECT DISTINCT business_unit ,ledger_group FROM PS_BU_LED_GRP_TBL WHERE ledger_type='D'

# 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