VCHR_PST_VW4

(SQL View)

SELECT DISTINCT a.business_unit , a.invoice_id , a.voucher_id , a.invoice_dt , a.vendor_setid , b.vendor_name_short , a.vendor_id , b.name1 , a.base_currency FROM PS_VOUCHER a , ps_vendor b , ps_vchr_acctg_line c WHERE a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id AND a.entry_status IN ('P','R') AND a.business_unit = c.business_unit AND a.voucher_id = c.voucher_id

Related Language Record: VCHR_PST_LG_VW2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AP_NONVW

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

3 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

4 INVOICE_DT Date(10) DATE Invoice Date

5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

6 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

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

9 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AP_NONVW
2	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
3	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
4	INVOICE_DT	Date(10)	DATE	Invoice Date
5	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
6	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
7	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
8	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
9	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "