INVOICE_ID_VW

(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'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FROM_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL From 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	FROM_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	From 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