VR_DTL_AR_VW (SQL View)	Index Back
OpenVoucher Detail View For AR

VR_DTL_AR_VW

(SQL View)

OpenVoucher Detail View For AR

SELECT a.vendor_setid , a.vendor_id , a.business_unit , a.voucher_id , a.invoice_id , a.invoice_dt , a.due_dt , a.vendor_name_short , a.name1 , a.post_status_ap , b.pymnt_gross_amt , b.txn_currency_cd , b.gross_amt_bse , b.base_currency FROM ps_voucher_ar_vw a , PS_PYMNT_VCHR_XREF b WHERE a.business_unit = b.business_unit AND a.voucher_id = b.voucher_id AND b.pymnt_selct_status = 'N' AND a.POST_STATUS_AP <>'U'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: VENDOR_AR

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

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

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

6 INVOICE_DT Date(10) DATE Invoice Date

7 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

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

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

10 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
N=Payment Not Applied
P=Posted
U=Unposted

11 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount

12 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

13 GROSS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Amount

14 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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_AR
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
5	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
6	INVOICE_DT	Date(10)	DATE	Invoice Date
7	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
8	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
9	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
10	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted
11	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
12	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
13	GROSS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Amount
14	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. "