RUN_GL_JNCLO_ST

(SQL Table)
Index Back

Year End Closing Status Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_GL_NONVW

4 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

Default Value: OPR_DEF_TBL_FS.LEDGER

Prompt Table: SP_BULEDD_NONVW

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

Default Value: OPR_DEF_TBL_FS.LEDGER_GROUP

Prompt Table: SP_LGRP_A_NONVW

6 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
7 BEGIN_DT Date(10) DATE Begin Date
8 END_DT Date(10) DATE End Date
9 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

Prompt Table: CLOSE_STAT_VW

10 CLOSE_LOG_TBL_FLAG Character(1) VARCHAR2(1) NOT NULL Select From Closing Log Table
N=No
Y=Yes

Default Value: N

11 DISPLAY_26_DIGITS Character(1) VARCHAR2(1) NOT NULL Display Full Numeric Field
N=No
Y=Yes

Default Value: N

12 SHOW_CFS_OPTION Character(1) VARCHAR2(1) NOT NULL Report ChartFields Option
1=Show Account Only
2=Show All Chartfields
3=Show Some Chartfields
13 RPT_CLOSE_STATUS Character(1) VARCHAR2(1) NOT NULL Report Closing Status
A=All Closing Status Types
C=Closed Journals
E=All Except Not Processed
N=Not Processed
U=Unclosed Journals

Default Value: A

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

Prompt Table: LEDGER_CODE_TBL