FIN_OPNPER_TMP

(SQL Table)
Index Back

Open Periods by Products

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 OPR_SESSION Number(6,0) INTEGER NOT NULL Operator Session
3 PSFT_PRODUCT Character(2) VARCHAR2(2) NOT NULL PeopleSoft Product

Prompt Table: PROD_SEP_CAL_VW

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

Prompt Table: SP_BU_FS_NONVW

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

Prompt Table: SP_LGRPNS_NONVW

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

Prompt Table: TRANS_TYPE_TBL

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

Prompt Table: LEDGER_CODE_TBL
Set Control Field: BUSINESS_UNIT

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

Prompt Table: ADJUST_TYPE_TBL
Set Control Field: BUSINESS_UNIT

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

Prompt Table: CAL_FY_NOSET_VW

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

Default Value: 998

Prompt Table: CAL_ADJP_ALL_VW

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

Prompt Table: CAL_FY_NOSET_VW

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

Prompt Table: CAL_DETP_ALL_VW

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

Prompt Table: CAL_FY_NOSET_VW

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

Prompt Table: CAL_DETP_ALL_VW

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