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 Text1 / 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