SP_BU_LGD_NONVW

(SQL View)
Index Back

Sec Vw - Ledger Group prompt

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