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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- cl 3 application for clinical lab license
- central connecticut state university
- check number by vendor name us
- state of connecticut
- background check info by state regent university
- ray connecticut
- expenditures by sid cfda number us
- inspection check list for state regulators
- environmental condition assessment form ecaf
Related searches
- check stocks by symbol
- us treasury check number located
- check number on us treasury check
- check if a business name is available
- us treasury check number location
- python check number is not null
- alphabetizing by last name rules
- check zoning by address
- average social security check 2020 by state
- obituary search by last name only
- check title by vin free
- check number on a us treasury check