ct_pc_vendor

Purpose of Query

Projects Vendor Information - Query provides purchasing and accounts payable information for charges against a project for a particular vendor (prompt on Projects Business Unit and Vendor ID).

Folder

PC

Tables

A CTW_PROJ_RESRCE - Project Resource

Join B CTW_PROJ_STATUS - Project Status Transaction

Join C CTW_PROJECT - Project

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 – (Equal To)

VENDOR_ID - Vendor – (Equal To)

Criteria

A.ANALYSIS_TYPE - Resource Analysis Type in list ('ACT','COM','REQ') – (Actual, Committed, Requisitioned)

B.EFFDT - Effective Date Eff Date <= Current Date (EffSeq = Last) – (Les thanb or equal to the current date)

C.EFF_STATUS - Status as of Effective Date in list ('A','I') – (Active, Inactive)

Note: Runtime prompts are included as criteria.

Fields

Col / Record.Fieldname / Format / Ord / XLAT / Agg / Heading Text
1 / A.VENDOR_ID - Vendor ID / Char10 / 1 / Vendor
2 / A.PROJECT_ID - Project / Char15 / 2 / Project
3 / B.PROJECT_STATUS - Status / Char1 / N / Status
4 / A.ACTIVITY_ID - Activity ID / Char15 / Activity
5 / A.ACCOUNT - Account / Char10 / Acct
6 / A.DEPTID - Department / Char10 / DeptID
7 / A.FUND_CODE - Fund Code / Char5 / Fund
8 / A.CLASS_FLD - Class Field / Char5 / Class
9 / A.PROGRAM_CODE - Program Code / Char5 / Program
10 / A.BUDGET_REF - Budget Reference / Char8 / Bud Ref
11 / A.CHARTFIELD1 - Chartfield 1 / Char10 / Chartfield 1
12 / A.CHARTFIELD2 - Chartfield 2 / Char10 / ChartField 2
13 / A.ANALYSIS_TYPE - Resource Analysis Type / Char3 / 3 / An Type
14 / A.ACCOUNTING_DT - Accounting Date / Date / Acctg Date
15 / A.TRANS_DT - Transaction Date / Date / Trans Date
16 / A.VOUCHER_ID - Voucher ID / Char8 / Voucher
17 / A.PO_ID - Purchase Order / Char10 / PO
18 / A.REQ_ID - Requisition ID / Char10 / Req ID
19 / A.RESOURCE_AMOUNT - Resource Amount / SNm25.3 / Amount