Check Number by Vendor Name .us



CT_CORE_FIN_CHECK_BY_VNDR_NAME

Purpose of Query

Check Number by Vendor Name - This query gives the check number, vendor name, and vendor short name (FEIN) for a date range. The search allows the use of wild cards in the vendor name field. The query output includes chartfield values. This means that for each time a chartfield value changes, a new row if information will be added. A voucher may appear multiple times if there are multiple chartfield rows.

Related to: CT_CORE_FIN_CHECK_BY_FEIN, CT_CORE_FIN_CHK_VNDR

Folder

AP

Tables

A CTW_VCHR_TRANS - Voucher Transactions Rpt Tbl

Join B CTW_PAYVC_XREF - Pay Voucher XRef Reporting Tbl

Join C CTW_PAYMNT_TRN - Payment Transactions Rpt Tbl

Join D CTW_VNDR_INFO - Vendor Info. Reporting Tbl

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 – (Wildcard enabled)

CT_VNDR_NAME1 - Vendor Name – (Wildcard enabled)

ACCOUNTING_DT - From Date / ACCOUNTING_DT - To Date - (Between condition)

Note: Vendor Name is the actual name of the vendor. When you run this query, be sure to use the wildcard (%) both before and after the search criteria. For example, lawn% will only show those vendors whose names begin with the word lawn, whereas %lawn% will show all vendors who have the word lawn anywhere in their name.

Note: Runtime prompts are included as criteria

[pic]

Criteria

D.EFFDT - Effective Date Eff Date ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download