CT_CORE_FIN_REQ_BY_FLAG_DATE

Purpose of Query

Requisitions by contract w/o vendor suffix, DOIT Flag, requisition date.

Folder

REQ

Tables

Top Level:

A.CTW_REQ_TYP_TBL - REQ Type Reporting Table

B.CTW_PO_TRANS- Purchase Order Transaction Rpt

E.CTW_REQ_TRN_TBL-Requisition Transaction Rpt

Union 1:

C CTW_CORE10-Core-10 Reporting Table

E CTW_REQ_TRN_TBL

Prompts

CT_DOIT_FLG –Req Type =

REQ_DT - Req Date From

REQ_DT - Req Date To

BUSINES_UNIT Like(%) –utilizes the wildcard

Sample results:

Please note, due to page size limitations, sample results may be incomplete.

Criteria

LINE_NBR - Line Number=1

REQ_STATUS not equal to X

Union 1, does not exist subquery on CTW_PO_TRANS.

Note: Runtime prompts are included as criteria.

Fields

Col / Record.Fieldname / Format / Ord / XLAT / Agg / Heading Text
1 / CASE WHEN A.CT_DOIT_FLG ='1' THEN 'ITD-10'
WHEN A.CT_DOIT_FLG ='3' THEN 'TSR-Equipment'
WHEN A.CT_DOIT_FLG ='4' THEN 'DAS-BID'
WHEN A.CT_DOIT_FLG ='5' THEN 'TSR-MACR'
WHEN A.CT_DOIT_FLG ='6' THEN 'Requisition'
WHEN A.CT_DOIT_FLG ='8' THEN 'Product Schedule'
ENDA.BUSINESS_UNIT - Business Unit / Char20 / DOIT Flag
2 / A.BUSINESS_UNIT - Business Unit / Char5 / Business Unit
3 / A.REQ_ID - Requisition ID / Char10 / Req ID
4 / A.REQ_DT - Requisition Date / Date / Req Date
5 / E.CT_REQ_LINE_DM254 - Requisition Line Description / Char254 / Req Line Descr
6 / B.PO_ID - Purchase Order / Char10 / Purchase Order
7 / B.PO_DT - Purchase Order Date / Date / PO Date
8 / A.REQUESTOR_ID - Requester Name / Char30 / Requester
9 / B.CT_BUYER_NAME - Buyer ID Name / Char30 / Buyer ID Name
10 / A.CT_BIDNUM_TXT - Bid ID / Char10 / Bid ID
11 / B.CNTRCT_ID - Contract Id / Char25 / Contract Id
12 / B.CT_VNDR_NAME1 - Vendor Name 1 / Date / Plan Start Date
13 / B.VENDOR_ID - Vendor ID / Char10 / Vendor

Note: Field 1 is an Expression. Expressions are calculations that PeopleSoft Query performs as part of a query. Use them when you must calculate a value that PeopleSoft Query does not provide by default—for example, to add the values from two fields together or to multiply a field value by a constant.

You can work with an expression as if it were a field in the query: select it for output, change its column heading, or choose it as an “order by” column.

In Query Manager, you can use expressions in two ways:

As comparison values in selection criteria.

As columns in the query output.

Do Not copy, modify, or delete