CT_CORE_FIN_PO_RECV_REQ

Purpose of Query

POs with receiving required- POs with receipt required, but receipt status not equal to R, prompts on business unit.

Folder

PO

Tables

CTW_PO_TRANS - Purchase Order Transaction Rpt

Prompts

BUSINESS_UNIT - Business Unit – (Equal To)

PO_DT - PO Date From / PO_DT - PO Date to – (Between condition)

Criteria

A.RECV_REQ - Receiving Required equal to Y – (Yes)

A.RECV_STATUS - Receipt Status not equal to R – (Received)

A.CANCEL_STATUS - Cancel Status not in list ('C','X') – (Complete, Canceled)

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.PO_ID - Purchase Order / Char10 / PO
3 / A.LINE_NBR - Line Number / Num5.0 / PO Line
4 / A.SCHED_NBR - Schedule Number / Num3.0 / PO Sched Num
5 / A.DST_ACCT_TYPE - Accounting Entry Type / Char4 / N / Type
6 / A.DISTRIB_LINE_NUM - Distribution Line Number / Num5.0 / PO Distrib Line
7 / A.PO_TYPE - PO Type / Char4 / N / PO Type
8 / A.HOLD_STATUS - Hold From Further Processing / Char1 / PO Hold Status
9 / A.RECV_STATUS - Receipt Status / Char1 / N / Receipt Status
10 / A.DISP_METHOD - Dispatch Method / Char3 / N / Dispatch Method
11 / A.CT_HDR_CHNGE_STAT - Header Change Order Status / Char1 / N / Hdr Chng Stat
12 / A.PO_DT - Purchase Order Date / Date / PO Date
13 / A.VENDOR_ID - Vendor ID / Char10 / Vendor
14 / A.CT_VNDR_NAME1 - Vendor Name 1 / Char40 / Vendor Name 1
15 / A.BUYER_ID - Buyer Name / Char30 / Buyer
16 / A.ORIGIN - Origin / Char3 / Origin
17 / A.CT_HDR_CHNG_ORD_SQ - Header Change Order Sequence / Num3.0 / Hdr Chg Ord Seq
18 / A.OPRID_ENTERED_BY - Entered By / Char30 / Entered By
19 / A.ENTERED_DT - Entered on / Date / Entered Date
20 / A.OPRID_APPROVED_BY - Approved By / Char30 / Approved By
21 / A.APPROVAL_DT - Date of Approval / Date / Approval Date
22 / A.LAST_DTTM_UPDATE - Last Change Date / DateTm / Last Change Date
23 / A.INV_ITEM_ID - Item ID / Char18 / Item
24 / A.CT_ITMCAT_DESCR - Item Catalog Description / Char30 / Itm Catalg Desc
25 / A.CATEGORY_CD - Category Code / Char18 / Category
26 / A.UNIT_OF_MEASURE - Unit of Measure / Char3 / UOM
27 / A.CNTRCT_ID - Contract Id / Char25 / Contract
28 / A.VERSION_NBR - Contract Version / Num5.0 / Version
29 / A.CNTRCT_LINE_NBR - Buying Agreement Line Nbr / Num5.0 / Contract Line
30 / A.RECV_REQ - Receiving Required / Char1 / Recv Reqd
31 / A.WTHD_SW - Withholding Applicable / Char1 / Withholding
32 / A.CT_PO_LINE_DM254 - PO Line Description / Char254 / PO Line Desc
33 / A.CT_PO_AUTHORITY - Purchasing Authority / Char4 / N / Purch. Auth.
34 / A.DUE_DT - Due Date / Date / Due Date
35 / A.SHIPTO_ID - Ship To Location / Char10 / Ship To
36 / A.CT_SHIPTO_DESCR - Ship To Description / Char30 / Ship To Desc
37 / A.QTY_PO - Purchase Order Quantity / Num12.4 / PO Qty
38 / A.MONETARY_AMOUNT - Monetary Amount / SNm25.3 / Amount
39 / A.ACCOUNT - Account / Char10 / Acct
40 / A.DEPTID - Department / Char10 / DeptID
41 / A.FUND_CODE - Fund Code / Char5 / Fund
42 / A.CT_SID - SID / Char5 / SID
43 / A.PROGRAM_CODE - Program Code / Char5 / Program
44 / A.BUDGET_REF - Budget Reference / Char8 / Bud Ref
45 / A.PROJECT_ID - Project / Char15 / Project
46 / A.CHARTFIELD1 - Chartfield 1 / Char10 / Chartfield 1
47 / A.CHARTFIELD2 - Chartfield 2 / Char10 / ChartField 2
48 / A.REQ_ID - Requisition ID / Char10 / Req ID
49 / A.REQ_LINE_NBR - Requisition Line Number / Num5.0 / Req Line
50 / A.REQ_SCHED_NBR - Requisition Schedule Number / Num3.0 / Req Sched
51 / A.REQ_DISTRIB_NBR - Requisition Distrib Number / Num5.0 / Req Distr
52 / A.BUDGET_HDR_STATUS - Budget Checking Header Status / Char1 / N / Budget Status
53 / A.PO_STATUS - PO Status / Char2 / N / PO Status