GTAS_RUN_FEDRPT

(SQL Table)
Index Back

Federal Transaction Register

GL Transaction Register (Federal version of Journal Entry detail report)

# 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 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
6 PERIOD_FROM Number(3,0) SMALLINT NOT NULL From Period
7 PERIOD_TO Number(3,0) SMALLINT NOT NULL To Period
8 SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.

Prompt Table: SOURCE_TBL

9 TREE_GRP Character(10) VARCHAR2(10) NOT NULL FACTS Tree Group

Prompt Table: GTAS_TREE_GRP

10 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.

Prompt Table: JRNL_ID_NPS_DVW

11 SHOW_DESCR Character(1) VARCHAR2(1) NOT NULL Show Description on Report