UPG_INQ1_TMP

(SQL Table)
Index Back

Inquiry Criteria 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: OPERATOR_VW

2 INQUIRY Character(10) VARCHAR2(10) NOT NULL Inquiry Name
3 LEDGER_CLASS Character(1) VARCHAR2(1) NOT NULL Classification
A=Actuals Ledger
B=Budgets Ledger
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

Prompt Table: SP_BUL_NKK_NONV

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

Prompt Table: LEDGER_CODE_TBL

7 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

Prompt Table: CAL_DETP_FY_VW

8 PERIOD_FROM Number(3,0) SMALLINT NOT NULL From Period

Prompt Table: CAL_DETP_PER_VW

9 PERIOD_TO Number(3,0) SMALLINT NOT NULL To Period

Prompt Table: CAL_DETP_PER_VW

10 INCLUDE_BAL_FRWD Character(1) VARCHAR2(1) NOT NULL Include Balance Forward

Y/N Table Edit

Default Value: N

11 INCLUDE_ADJ_PER Character(1) VARCHAR2(1) NOT NULL Include Adjustment Period(s)

Y/N Table Edit

Default Value: N

12 INCLUDE_CLOSE_PER Character(1) VARCHAR2(1) NOT NULL Include Closing Adjustments
N=No Adjustment Period
S=Specify Adjustment Period
Y=Adjustment Period 998
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CUR_CD_ALL_VW

14 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

Prompt Table: STAT_ALL_VW

15 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_ALL_ID_VW

16 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

Prompt Table: %EDITTABLE4

17 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
18 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

19 SUSP_RECON_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not there are suspense transactions in a journal, and if so, whether or not they have been corrected and posted.
0=No Suspense Transactions
1=Suspense Transactions
2=Correction Journal Created
3=Correction Journal Posted
20 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.

Prompt Table: DOC_TYPE_VW2

21 ADJ_PER_FROM Number(3,0) SMALLINT NOT NULL Adjustment Period From

Default Value: 998

22 ADJ_PER_TO Number(3,0) SMALLINT NOT NULL Adjustment Period To

Default Value: 998

23 OPRID2 Character(30) VARCHAR2(30) NOT NULL A user's ID

Prompt Table: OPERATOR_VW

24 DOC_SEQ_NBR Character(12) VARCHAR2(12) NOT NULL Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.