COPY OF: beth01

Description

Columns: Vendor Id, Last Update Date, Last Updated By, Vendor Name, Vendor Name Alt, Segment1, Summary Flag, Enabled Flag, Segment2, Segment3 ... Columns: Vendor Id, Last Update Date, Last Updated By, Vendor Name, Vendor Name Alt, Segment1, Summary Flag, Enabled Flag, Segment2, Segment3, Segment4, Segment5, Last Update Login, Creation Date, Created By, Employee Id, Vendor Type Lookup Code, Customer Num, One Time Flag, Parent Vendor Id, Min Order Amount, Ship To Location Id, Bill To Location Id, Ship Via Lookup Code, Freight Terms Lookup Code, Fob Lookup Code, Terms Id, Set Of Books Id, Credit Status Lookup Code, Credit Limit, Always Take Disc Flag, Pay Date Basis Lookup Code, Pay Group Lookup Code, Payment Priority, Invoice Currency Code, Payment Currency Code, Invoice Amount Limit, Exchange Date Lookup Code, Hold All Payments Flag, Hold Future Payments Flag, Hold Reason, Distribution Set Id, Accts Pay Code Combination Id, Disc Lost Code Combination Id, Disc Taken Code Combination Id, Expense Code Combination Id, Prepay Code Combination Id, Num 1099, Type 1099, Withholding Status Lookup Code, Withholding Start Date, Organization Type Lookup Code, Vat Code, Start Date Active, End Date Active, Minority Group Lookup Code, Payment Method Lookup Code, Bank Account Name, Bank Account Num, Bank Num, Bank Account Type, Women Owned Flag, Small Business Flag, Standard Industry Class, Hold Flag, Purchasing Hold Reason, Hold By, Hold Date, Terms Date Basis, Price Tolerance, Inspection Required Flag, Receipt Required Flag, Qty Rcv Tolerance, Qty Rcv Exception Code, Enforce Ship To Location Code, Days Early Receipt Allowed, Days Late Receipt Allowed, Receipt Days Exception Code, Receiving Routing Id, Allow Substitute Receipts Flag, Allow Unordered Receipts Flag, Hold Unmatched Invoices Flag, Exclusive Payment Flag, Ap Tax Rounding Rule, Auto Tax Calc Flag, Auto Tax Calc Override, Amount Includes Tax Flag, Tax Verification Date, Name Control, State Reportable Flag, Federal Reportable Flag, Attribute Category, Attribute1, Attribute2, Attribute3, Attribute4, Attribute5, Attribute6, Attribute7, Attribute8, Attribute9, Attribute10, Attribute11, Attribute12, Attribute13, Attribute14, Attribute15, Request Id, Program Application Id, Program Id, Program Update Date, Offset Vat Code, Vat Registration Num, Auto Calculate Interest Flag, Validation Number, Exclude Freight From Discount, Tax Reporting Name, Check Digits, Bank Number, Allow Awt Flag, Awt Group Id, Global Attribute1, Global Attribute2, Global Attribute3, Global Attribute4, Global Attribute5, Global Attribute6, Global Attribute7, Global Attribute8, Global Attribute9, Global Attribute10, Global Attribute11, Global Attribute12, Global Attribute13, Global Attribute14, Global Attribute15, Global Attribute16, Global Attribute17, Global Attribute18, Global Attribute19, Global Attribute20, Global Attribute Category, Edi Transaction Handling, Edi Payment Method, Edi Payment Format, Edi Remittance Method, Edi Remittance Instruction, Bank Charge Bearer, Bank Branch Type, Match Option, Future Dated Payment Ccid, Create Debit Memo Flag, Offset Tax Flag, Party Id, Parent Party Id, Ni Number, Tca Sync Num 1099, Tca Sync Vendor Name, Tca Sync Vat Reg Num, Individual 1099, Unique Tax Reference Num, Partnership Utr, Partnership Name, Cis Enabled Flag, First Name, Second Name, Last Name, Salutation, Trading Name, Work Reference, Company Registration Number, National Insurance Number, Verification Number, Verification Request Id, Match Status Flag, Cis Verification Date, Pay Awt Group Id, Cis Parent Vendor Id, Bus Class Last Certified Date, Bus Class Last Certified By

Copy

select
*
from 
ap_suppliers aps
Where 
1=1

Parameter Name

SQL text

Validation

Supplier

aps.vendor_name=:vendor_name

LOV

Supplier Number

aps.segment1=:supplier_number

LOV

Download

Related Blitz Reports

JA India - Open Transactions Report for Prior-GST (XML Publisher) JE Portuguese Periodic VAT JE Portuguese Annual VAT JE Italian Payables Summary VAT JE Israeli Withholding Tax File to Tax Authority JE Israeli Withholding Tax Reconciliation JE Israeli Withholding Tax Summary/Detail JE Israeli Summary VAT to Tax Authorities JE Israeli VAT File Related to 835 JE Belgian VAT Monthly VAT Preparation

Blitz Report In Action

Blitz Report™

Blitz Report™ provides multiple benefits:

Perfectly formatted Excel reports
Create new or ad-hoc reports in minutes
User configurable reports
Includes seeded reports for all core areas
Toolkits for tuning, management and support
Data governance and audit tracking
Central report repository & version control
Imports BI-Publisher and Discoverer reports
EBS forms interface for user adoption

Find out more

Features

Download

FAQ