CT_CORE_AR_REFUND_EXP

Purpose of Query

AR Distribution for 50000 Accounts Only - This is union query of the CT_POSTED_ITEM and CT_DIR_JRNL_PY tables. It returns only those deposit items that reference a 50000 (Expenditure) Account.

Folder

AR

Tables

CTW_DIR_JRNL_PY - Direct Jrnl Pay Reporting Tbl

Union1 - CTW_POSTED_ITM - Posted Item Trans. Rpt Tbl

Note: A Union query combines the results of two or more queries into a single result set that includes all the rows that belong to all queries in the union. The two queries must have the same number of columns and compatible data types to unite.

Prompts

Deposit BU (Business Unit)

From Date (Accounting Date field)

To Date (Accounting Date field)

Criteria

ACCOUNT - Between 50000 AND 59999 (Expenditure Accounts)

Note: Runtime prompts are included as criteria.

Fields

Col / Record.Fieldname / Format / Ord / XLAT / Agg / Heading Text
1 / A.DEPOSIT_BU - Deposit Unit / Char5 / Unit
2 / A.DEPOSIT_ID - Deposit ID / Char15 / Deposit ID
3 / A.DEP_POST_STATUS - Posting Status / Char1 / N / Posted
4 / A.ENTRY_DT - Entry Date / Date / Entry Date
5 / A.DEPOSIT_STATUS - Deposit Status / Char1 / N / Status
6 / A.JRNL_LN_REF - Journal Line Reference / Char10 / Ref
7 / A.ACCOUNTING_DT - Accounting Date / Date / Acctg Date
8 / A.ACCOUNT - Account / Char10 / Acct
9 / A.DEPTID - Department / Char10 / DeptID
10 / A.FUND_CODE - Fund Code / Char5 / Fund
11 / A.CT_SID - SID / Char5 / SID
12 / A.PROGRAM_CODE - Program Code / Char5 / Program
13 / A.BUDGET_REF - Budget Reference / Char8 / Bud Ref
14 / A.PROJECT_ID - Project / Char15 / Project
15 / A.CHARTFIELD1 - Chartfield 1 / Char10 / Chartfield 1
16 / A.CHARTFIELD2 - Chartfield 2 / Char10 / ChartField 2
17 / A.MONETARY_AMOUNT - Monetary Amount / SNm25.3 / Amount
18 / A.DEBIT_CREDIT - Debit / Credit Indicator / Char2 / N / DR/CR
19 / A.PAYMENT_ID - Payment ID / Char15 / Payment ID