PYMNT_VCHR_VW2 (SQL View)	Index Back
Voucher Scheduled Payment View

PYMNT_VCHR_VW2

(SQL View)

Voucher Scheduled Payment View

select a.business_unit ,a.voucher_id ,a.pymnt_cnt ,a.ledger_group ,a.ledger ,a.paid_amt_bse ,a.rate_mult ,a.rate_div ,a.cur_rt_type_pymnt ,a.pymnt_rate_mult ,a.pymnt_rate_div ,a.paid_amt_gross_bse ,a.paid_amt_dscnt_bse ,a.base_currency ,a.primary_ledger from PS_PYMNT_VCHR_BOOK a where a.primary_ledger='Y'

Parent record: PYMNT_VCHR_VW3

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments

4 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

5 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

6 PAID_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Paid Amount

7 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

8 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

9 CUR_RT_TYPE_PYMNT Character(5) VARCHAR2(5) NOT NULL Payment Currency Rate Type

10 PYMNT_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange rate is stored

11 PYMNT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determining whether a currency exchange rate is store

12 PAID_AMT_GROSS_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Payment Amount

13 PAID_AMT_DSCNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Paid 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. "

15 PRIMARY_LEDGER Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
4	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
5	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
6	PAID_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Paid Amount
7	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
8	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
9	CUR_RT_TYPE_PYMNT	Character(5)	VARCHAR2(5) NOT NULL	Payment Currency Rate Type
10	PYMNT_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is stored
11	PYMNT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	An internal convention utilized for determining whether a currency exchange rate is store
12	PAID_AMT_GROSS_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Payment Amount
13	PAID_AMT_DSCNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Discount Paid 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. "
15	PRIMARY_LEDGER	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.