RUN_GL_TRN_DET

(SQL Table)
Index Back

PS/GL Ledger Rpt Request

PS/GL Ledger Rpt Request

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_GL_NONVW

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

Default Value: OPR_DEF_TBL_FS.LEDGER

Prompt Table: SP_BULEDD_NONVW

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

Prompt Table: LEDGER_CODE_TBL

7 BAL_SHEET_IND Character(2) VARCHAR2(2) NOT NULL Balance Sheet Indicator
BS=Balance Sheet
OB=Off Balance Sheet
8 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
9 PERIOD_FROM Number(3,0) SMALLINT NOT NULL From Period
10 PERIOD_TO Number(3,0) SMALLINT NOT NULL To Period
11 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: STAT_RPT_LBL_VW

12 ACCT_FR Character(10) VARCHAR2(10) NOT NULL From

Prompt Table: %EDITTABLE

13 ACCT_TO Character(10) VARCHAR2(10) NOT NULL To

Prompt Table: %EDITTABLE

14 JRNL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates the processing status of a journal entry.
D=Deleted
E=Journal Has Errors
I=Posting Incomplete
M=Valid SJE Model -- Do Not Post
N=No Status - Needs to be Edited
P=Posted to Ledger(s)
T=Journal Entry Incomplete
U=Unposted
V=Valid Journal - Edits Complete
X=Cancelled
Z=Upgrade Journal - Can't Unpost

Default Value: P

15 SUB_TOTAL_OPT1 Number(1,0) SMALLINT NOT NULL Subtotalling Option 1
16 SUB_TOTAL_OPT2 Number(1,0) SMALLINT NOT NULL Subtotalling Option 2
17 SHOW_ERRORS_ONLY Character(1) VARCHAR2(1) NOT NULL Show Only Errors

Y/N Table Edit

Default Value: N

18 SHOW_DETAIL_JRNL Character(1) VARCHAR2(1) NOT NULL Show Journal Detail

Y/N Table Edit

Default Value: N

19 CURRENCY_OPTION3 Character(1) VARCHAR2(1) NOT NULL Currency Option
B=Base Currency
F=Foreign Currency
M=Multi-Currency

Default Value: M

20 PAGE_BREAK_OPTION Character(1) VARCHAR2(1) NOT NULL Page Break Option

Y/N Table Edit

Default Value: Y

21 HDR_OR_LINE_SEL Character(1) VARCHAR2(1) NOT NULL Header or Line View Selection
H=Header
L=Line

Default Value: L

22 INCLUDE_UNPOSTED Character(1) VARCHAR2(1) NOT NULL Include Unposted Journals

Y/N Table Edit

Default Value: Y

23 PB_SELECT_DOC_SEQ Character(1) VARCHAR2(1) NOT NULL Select Document Seq Options
24 DISPLAY_26_DIGITS Character(1) VARCHAR2(1) NOT NULL Display Full Numeric Field
N=No
Y=Yes

Y/N Table Edit

Default Value: N

25 ADJ_PER_FROM Number(3,0) SMALLINT NOT NULL Adjustment Period From
26 ADJ_PER_TO Number(3,0) SMALLINT NOT NULL Adjustment Period To
27 OPTION_FIN2003 Character(1) VARCHAR2(1) NOT NULL Option for Contra Account
1=First Line
2=Highest Amount
3=Match Entries
28 SUB_TOTAL_PD Character(1) VARCHAR2(1) NOT NULL Subtotals by Period

Y/N Table Edit

Default Value: N