CT_CORE_FIN_BI_PART_OPENBILL

Purpose of Query

Partial payments, open invoice - Facilitates identification of all open, partial payments received by business unit.

Folder

AR

Tables

A CTW_POSTED_ITM - Posted Item Transaction Rpt

B CTW_BI_INVOICE - Bill Invoice 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

BUSINESS_UNIT - Business Unit is Like – (Wildcard enabled)

ACCOUNTING_DT - Acctg Date from / ACCOUNTING_DT - Acctg Date To – (Between condition()

Sample Results:

Criteria

A.ITEM_STATUS - Item Status equal to O – (Ordered)

Note: Runtime prompts are included as criteria.

Fields

Col / Record.Fieldname / Format / Ord / XLAT / Agg / Heading Text
1 / B.BUSINESS_UNIT - Business Unit / Char5 / Business Unit
2 / B.INVOICE - Invoice / Char22 / Invoice
3 / B.LINE_SEQ_NUM - Sequence / Num5.0 / Seq
4 / B.LINE_DST_SEQ_NUM - Revenue Sequence Number / Num3.0 / Rev Seq
5 / A.PAYMENT_AMT - Payment Amount / SNm25.3 / Payment Amount
6 / A.BAL_AMT - Customer Balance / SNm25.3 / Balance
7 / A.ORIG_ITEM_AMT - Original Item Amount / SNm25.3 / Orig Item Amt
8 / A.ITEM_STATUS - Item Status / Char1 / N / Item Status
9 / B.INVOICE_AMOUNT - Invoice Amount / SNm25.3 / Inv Amt
10 / A.LEDGER - Ledger / Char10 / Ledger
11 / B.ACCOUNT - Account / Char10 / Acct
12 / B.FUND_CODE - Fund Code / Char5 / Fund
13 / A.CT_SID - SID / Char5 / SID
14 / A.ACCOUNTING_DT - Accounting Date / Date / Acctg Date
15 / A.PAYMENT_ID - Payment ID / Char15 / Payment ID
16 / A.ITEM_LINE - Item Line / Num6.0 / Line
17 / B.FINAL_FF_EXT_IND - Final Run Indicator / Char1 / Final
18 / B.TARGET_PYMT_DT - Target Payment Date / Date / Target Date
19 / A.BUDGET_DT - Budget Date / Date / Budg Dt