CAL_OPEN_DYS_VW

(SQL View)
Index Back

Calendar Open Days (From/To)


SELECT B.BUSINESS_UNIT , O.TRANSACTION_TYPE , O.OPEN_FROM_DATE , O.OPEN_TO_DATE FROM PS_BUS_UNIT_TBL_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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 TRANSACTION_TYPE Character(3) VARCHAR2(3) NOT NULL Transaction Type
3 OPEN_FROM_DATE Date(10) DATE First Open Day
4 OPEN_TO_DATE Date(10) DATE Last Open Day