CT_CORE_FIN_BI_AR_PNDITM

Purpose of Query

Billing AR Pending Item - Billing AR Pending Item 5/14/07 query reconstructed to add back in date prompt and remove criteria on account.

Folder

AR

Tables

CTW_BI_AR_PNDIT - Bill AR Pending Item Rpt

Prompts

BUSINESS_UNIT - Business Unit – (Equal to)

ASOF_DT - As Of Date > – (Greater than a date – This would be one day greater than the date entered)

Sample Results:

Criteria

No hard coded criteria

Note: Runtime prompts are included as criteria.

Fields

Col / Record.Fieldname / Format / Ord / XLAT / Agg / Heading Text
1 / A.BUSINESS_UNIT - Business Unit / Char5 / Business Unit
2 / A.CUST_ID - Customer ID / Char15 / Customer
3 / A.ITEM - Item ID / Char30 / Item ID
4 / A.ITEM_LINE - Item Line / Num6.0 / Item Line
5 / A.LEDGER - Ledger / Char10 / Ledger
6 / A.DST_SEQ_NUM - Distribution Sequence / Num3.0 / Dist Seq Num
7 / A.CUST_NAME - Name / Char40 / Customer Name
8 / A.ACCOUNT - Account / Char10 / Acct
9 / A.DEPTID - Department / Char10 / DeptID
10 / A.FUND_CODE - Fund Code / Char5 / Fund
11 / A.CLASS_FLD - Class Field / Char5 / Class
12 / A.PROGRAM_CODE - Program Code / Char5 / Program
13 / A.BUDGET_REF - Budget Reference / Char8 / Bud Ref
14 / A.CHARTFIELD1 - Chartfield 1 / Char10 / Chartfield 1
15 / A.CHARTFIELD2 - Chartfield 2 / Char10 / ChartField 2
16 / A.PROJECT_ID - Project / Char15 / Project
17 / A.MONETARY_AMOUNT - Monetary Amount / SNm25.3 / Amount
18 / A.ACCOUNTING_DT - Accounting Date / Date / Acctg Date
19 / A.ENTRY_AMT - Entry Amount / SNm25.3 / Amount
20 / A.ASOF_DT - As Of Date / Date / As Of Date
21 / A.POST_DT - Posted Date / Date / Posted Date
22 / A.DUE_DT - Due Date / Date / Due Date
23 / A.PAYMENT_AMT - Payment Amount / SNm25.3 / Payment Amount
24 / A.CONTRACT_NUM - Contract Number / Char25 / Contract #
25 / A.DEPOSIT_BU - Deposit Unit / Char5 / Deposit BU
26 / A.DEPOSIT_ID - Deposit ID / Char15 / Deposit ID
27 / A.PAYMENT_SEQ_NUM - Payment Sequence / Num6.0 / Payment Seq Num
28 / A.PAYMENT_ID - Payment ID / Char15 / Payment ID
29 / A.BUDGET_DT - Budget Date / Date / Budg Dt