INVOICE_ID_VW3

(SQL View)

SELECT A.BUSINESS_UNIT , A.INVOICE_ID , a.invoice_dt , a.vendor_setid , b.vendor_name_short , a.vendor_id , b.name1 FROM PS_VOUCHER a , ps_vendor b WHERE a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id AND a.entry_status <> 'X' AND A.VOUCHER_STYLE IN ('REG','ADJ') AND EXISTS ( SELECT 'X' FROM PS_PYMNT_VCHR_XREF XREF WHERE XREF.BUSINESS_UNIT = A.BUSINESS_UNIT AND XREF.VOUCHER_ID = A.VOUCHER_ID AND XREF.PYMNT_TYPE = 'R' AND XREF.PYMNT_SELCT_STATUS = 'N')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number

3 INVOICE_DT Date(10) DATE Invoice Date

4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

5 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
Prompt Table: VENDOR_SHRT_VW

6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: VNDR_ACTIVE_VW

7 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
3	INVOICE_DT	Date(10)	DATE	Invoice Date
4	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
5	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name Prompt Table: VENDOR_SHRT_VW
6	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VNDR_ACTIVE_VW
7	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1