VR_BAL_AR_BS_VW (SQL View)	Index Back
Supplier Bal View - Base Crncy

VR_BAL_AR_BS_VW

(SQL View)

Supplier Bal View - Base Crncy

SELECT a.vendor_setid , a.vendor_id , a.base_currency , a.business_unit , SUM(b.gross_amt_bse) , COUNT(*) FROM PS_VOUCHER_AR a , ps_pymnt_xref_ar 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' GROUP BY a.vendor_setid, a.vendor_id, a.base_currency, a.business_unit

# 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 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. "

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

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

6 VCHR_COUNT Number(6,0) INTEGER NOT NULL Count of Vouchers

#	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	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. "
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	GROSS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Amount
6	VCHR_COUNT	Number(6,0)	INTEGER NOT NULL	Count of Vouchers