CT_CORE_FIN_JOURNAL_ENTRY
Purpose of Query
Journal Entry Query - Query will provide Journal Entry information for Business Unit, journal date range, and Ledger the user prompts on for transactions where Budget Header line and status are Valid and Journal Header Status is Posted and Journal Line status = 0 or 'OK'.
Folder
GL
Tables
CTW_JRNL_TRN - Journal Transaction Rpt
Prompts
JOURNAL_DATE - Begin Date / JOURNAL_DATE - End Date (Between condition)
LEDGER - Ledger – (Equal To)
DEPTID - Department is like (%) – (Wildcard enabled)
Criteria
A.JRNL_HDR_STATUS - Journal Header Status equal to P – (Posted to Journals)
A.BUDGET_HDR_STATUS - Budget Checking Header Status equal to V – (Valid Budget Check)
A.JRNL_LINE_STATUS - Journal Line Status equal to 0 – (No Errors)
A.BUDGET_LINE_STATUS - Budget Checking Line Status equal to V – (Valid Budget Check)
Note: Runtime prompts are included as criteria.
Fields
Col / Record.Fieldname / Format / Ord / XLAT / Agg / Heading Text /1 / A.BUSINESS_UNIT - Business Unit / Char5 / 1 / Unit
2 / A.JOURNAL_ID - Journal ID / Char10 / Journal ID
3 / A.JOURNAL_DATE - Journal Date / Date / Date
4 / A.UNPOST_SEQ - UnPost Sequence / Num2.0 / Seq
5 / A.JOURNAL_LINE - GL Journal Line Number / Num9.0 / Line
6 / A.LEDGER - Ledger / Char10 / Ledger
7 / A.ADJUSTING_ENTRY - Adjusting Entry / Char1 / Adj Entry
8 / A.FISCAL_YEAR - Fiscal Year / Num4.0 / 2 / Year
9 / A.ACCOUNTING_PERIOD - Accounting Period / Num3.0 / 3 / Period
10 / A.LEDGER_GROUP - Ledger Group / Char10 / Ledger Grp
11 / A.SOURCE - Source / Char3 / Source
12 / A.SYSTEM_SOURCE - System Source / Char3 / N / Sys Source
13 / A.CT_HEADER_DESCR - Journal Header Description / Char30 / Jrnl Hdr Descr
14 / A.BUDGET_PERIOD - Budget Period / Char8 / Budget Period
15 / A.MONETARY_AMOUNT - Monetary Amount / SNm25.3 / Amount
16 / A.CURRENCY_CD - Currency Code / Char3 / Currency
17 / A.STATISTIC_AMOUNT - Statistic Amount / SNm15.2 / Stat Amt
18 / A.STATISTICS_CODE - Statistics Code / Char3 / Stat
19 / A.LINE_DESCR - Journal Line Description / Char30 / Line Descr
20 / A.JRNL_LN_REF - Journal Line Reference / Char10 / Ref
21 / A.ACCOUNT - Account / Char10 / Acct
22 / A.CT_GL_ACC_DESCR - GL Account Description / Char30 / GL Acct Descr
23 / A.DEPTID - Department / Char10 / 4 / DeptID
24 / A.CT_DEPT_DESCR - Department Description / Char30 / Deptid Descr
25 / A.FUND_CODE - Fund Code / Char5 / Fund
26 / A.CT_FUND_DESCR - Fund Code Description / Char30 / Fund Descr
27 / A.CT_SID - SID / Char5 / SID
28 / A.CT_SID_DESCR - SID Description / Char30 / SID Description
29 / A.PROGRAM_CODE - Program Code / Char5 / Program
30 / A.CT_PRGRM_DESCR - Program Code Description / Char30 / Program Descr
31 / A.BUDGET_REF - Budget Reference / Char8 / Bud Ref
32 / A.PROJECT_ID - Project / Char15 / Project
33 / A.CT_PROJCT_DESCR - Project ID Description / Char30 / Project Descr
34 / A.CHARTFIELD1 - Chartfield 1 / Char10 / Chartfield 1
35 / A.CT_CHRTF1_DESCR - Chartfield One Description / Char30 / Chrtfld1 Descr
36 / A.CHARTFIELD2 - Chartfield 2 / Char10 / ChartField 2
37 / A.CT_CHRTF2_DESCR - Chartfield Two Description / Char30 / ChrtFld2 Descr
38 / A.JRNL_HDR_STATUS - Journal Header Status / Char1 / N / Status
39 / A.BUDGET_HDR_STATUS - Budget Checking Header Status / Char1 / N / Budget Status
40 / A.JRNL_LINE_STATUS - Journal Line Status / Char1 / N / Status
41 / A.BUDGET_LINE_STATUS - Budget Checking Line Status / Char1 / N / Budget Status