FSAH_OPN_PRD_VW

(SQL View)
 Index Back

Open Periods for FSAH

FSAH

SELECT A.PSFT_PRODUCT , A.BUSINESS_UNIT , A.LEDGER_GROUP , A.TRANSACTION_TYPE , A.LEDGER_CODE , A.GL_ADJUST_TYPE , A.CALENDAR_ID , D.FISCAL_YEAR , D.ACCOUNTING_PERIOD , A.OPEN_YEAR_FROM , A.OPEN_PERIOD_FROM , A.BEGIN_LAG_DAYS , C.BEGIN_DT , A.OPEN_YEAR_TO , A.OPEN_PERIOD_TO , A.END_LAG_DAYS , B.END_DT FROM PS_FIN_OPEN_PERIOD A , PS_CAL_DETP_TBL B , PS_CAL_DETP_TBL C , PS_FIN_OPEN_ADJ D WHERE A.CALENDAR_ID = B.CALENDAR_ID AND A.OPEN_YEAR_TO = B.FISCAL_YEAR AND A.OPEN_PERIOD_TO = B.ACCOUNTING_PERIOD AND B.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = A.BUSINESS_UNIT AND RECNAME = 'CAL_DETP_TBL') AND A.CALENDAR_ID = C.CALENDAR_ID AND A.OPEN_YEAR_FROM = C.FISCAL_YEAR AND A.OPEN_PERIOD_FROM = C.ACCOUNTING_PERIOD AND C.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = A.BUSINESS_UNIT AND RECNAME = 'CAL_DETP_TBL') AND D.PSFT_PRODUCT = A.PSFT_PRODUCT AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.LEDGER_GROUP = A.LEDGER_GROUP AND D.DEFAULT_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSFT_PRODUCT Character(2) VARCHAR2(2) NOT NULL PeopleSoft Product

Prompt Table: PROD_SEP_CAL_VW

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_FS_NONVW

3 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

Prompt Table: SP_LGRPNS_NONVW

4 TRANSACTION_TYPE Character(3) VARCHAR2(3) NOT NULL Transaction Type

Prompt Table: TRANS_TYPE_TBL

5 LEDGER_CODE Character(10) VARCHAR2(10) NOT NULL Ledger Code

Prompt Table: LEDGER_CODE_TBL
Set Control Field: BUSINESS_UNIT

6 GL_ADJUST_TYPE Character(4) VARCHAR2(4) NOT NULL Adjustment Type

Prompt Table: ADJUST_TYPE_TBL
Set Control Field: BUSINESS_UNIT

7 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
8 OPEN_CLOSING_YEAR Number(4,0) SMALLINT NOT NULL Adjustment Year

Prompt Table: CAL_FY_NOSET_VW

9 ADJUSTING_PERIOD Number(3,0) SMALLINT NOT NULL Adjustment Period

Default Value: 998

Prompt Table: CAL_ADJP_ALL_VW

10 OPEN_YEAR_FROM Number(4,0) SMALLINT NOT NULL Open Year From

Prompt Table: CAL_FY_NOSET_VW

11 OPEN_PERIOD_FROM Number(3,0) SMALLINT NOT NULL Open Period From

Prompt Table: CAL_DETP_ALL_VW

12 BEGIN_LAG_DAYS Signed Number(3,0) DECIMAL(2) NOT NULL Lag Days for the Begin Date
13 OPEN_FROM_DATE Date(10) DATE First Open Day
14 OPEN_YEAR_TO Number(4,0) SMALLINT NOT NULL Open Year To

Prompt Table: CAL_FY_NOSET_VW

15 OPEN_PERIOD_TO Number(3,0) SMALLINT NOT NULL Open Period To

Prompt Table: CAL_DETP_ALL_VW

16 END_LAG_DAYS Signed Number(3,0) DECIMAL(2) NOT NULL Lag Days for the End Date
17 OPEN_TO_DATE Date(10) DATE Last Open Day