CAL_OPN_DYS2_VW

(SQL View)
 Index Back

Calendar Open Days (From/To)


SELECT b.business_unit , o.open_from_date , o.open_to_date FROM ps_bu_edit_vw_ar b , PS_FIN_OPEN_PERIOD o WHERE o.business_unit = b.business_unit AND o.psft_product = 'AR'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
2 OPEN_FROM_DATE Date(10) DATE First Open Day
3 OPEN_TO_DATE Date(10) DATE Last Open Day