CT_CORE_AR_DIR_JRNL_BDGT_ERROR

Purpose of Query

Direct Journals in Budget Error - Query returns all direct journal entries in the status of Budget Error. Normally the query will return rows.

Folder

AR

Tables

A.CTW_PAYMENT - Financial Payment Rpt

Join B.CTW_DIR_JRNL_PY - Direct Journal Payment Rpt

Note: A JOIN is an SQL command that is used to relate two or more data tables (Records in PeopleSoft) based on the use of related (key) fields from one table to the next. Once joined, data can be retrieved without repeating all of the data in every table.

Prompts

ACCOUNTING_DT - Acctg Date <= - (Less than or Equal To)

Sample Results

Please note, due to page size limitations, sample results may be incomplete

Criteria

A.BUDGET_HDR_STATUS - Budget Checking Header Status =’E’ – (Error)

Note: Runtime prompts are included as criteria.

Fields

Col / Record.Fieldname / Format / Ord / XLAT / Agg / Heading Text
1 / A.DEPOSIT_BU - Deposit Unit / Char5 / Deposit Business Unit
2 / A.DEPOSIT_ID - Deposit ID / Char15 / Deposit ID
3 / A.ACCOUNTING_DT - Accounting Date / Date / Acctg Date
4 / A.BUDGET_HDR_STATUS - Budget Checking Header Status / Char1 / N / Budget Status
5 / B.PAYMENT_SEQ_NUM - Payment Sequence / Num6.0 / Seq
6 / B.DST_SEQ_NUM - Distribution Sequence / Num3.0 / Line
7 / B.ACCOUNT - Account / Char10 / Acct
8 / B.DEPTID - Department / Char10 / DeptID
9 / B.FUND_CODE - Fund Code / Char5 / Fund
10 / B.CT_SID - SID / Char5 / SID
11 / B.PROGRAM_CODE - Program Code / Char5 / Program
12 / B.PROJECT_ID - Project / Char15 / Project
13 / B.BUDGET_REF - Budget Reference / Char8 / Bud Ref
14 / B.CHARTFIELD1 - Chartfield 1 / Char10 / Chartfield 1
15 / B.CHARTFIELD2 - Chartfield 2 / Char10 / ChartField 2
16 / B.MONETARY_AMOUNT - Monetary Amount / SNm25.3 / Amount