PMT_VCR_XREF_VW

(SQL View)
Index Back

SELECT DISTINCT A.BUSINESS_UNIT , A.VOUCHER_ID , B.PYMNT_CNT , B.REMIT_SETID , B.REMIT_VENDOR , A.INVOICE_ID FROM PS_VOUCHER A , PS_PYMNT_VCHR_XREF B WHERE %Join(COMMON_KEYS, VOUCHER A, PYMNT_VCHR_XREF B)

# 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 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
5 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
6 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number