RUN_GL_TRN_DET(SQL Table) |
Index Back |
---|---|
PS/GL Ledger Rpt RequestPS/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 |