CT_CORE_JOURNAL_ENTRY
Purpose of Query
Journal Entry Query - Query will provide Journal information for a Department ID or range of Department IDs based upon journal date range, Ledger, and Department ID.
Folder
GL
Tables
CTW_JRNL_TRN - Journal Transaction Rpt
Prompts
JOURNAL_DATE - Begin Date / JOURNAL_DATE - End Date – (between condition)
LEDGER - Ledger – (Equal To – MOD_ACCRL, MOD_CASH)
DEPTID - DeptID (%) – (Wildcard enabled)
Criteria
.BUSINESS_UNIT - Business Unit equal to STATE (GL business unit)
A.JRNL_HDR_STATUS - Journal Header Status equal to P – (Posted)
A.BUDGET_HDR_STATUS - Budget Checking Header Status equal to V – (Valid budget check)
A.JRNL_LINE_STATUS - Journal Line Status equal to 0 – (OK, 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