VNDR_PYINQ_VW

(SQL View)
 Index Back

Supplier Payment Information


select a.setid, a.vendor_id, b.bank_setid, b.bank_cd, b.bank_acct_key, b.pymnt_id_ref, b.pymnt_id, a.vendor_name_short, a.ar_num, a.name1, b.pymnt_dt, b.recon_type from ps_vendor a, PS_PAYMENT_TBL b where a.setid = b.remit_setid and a.vendor_id = b.remit_vendor and b.pymnt_status not in ('A','O')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

Default Value: OPR_REMIT_VW_AP.REMIT_SETID

Prompt Table: SP_SETRMT_NONVW

2 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor

Prompt Table: REMIT_LOOK_VW

3 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

Default Value: OPR_BANK_VW_AP.BANK_SETID

Prompt Table: SP_SETBNK_NONVW

4 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

Prompt Table: BANK_CD_VW2

5 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

Prompt Table: BANK_ACCT_VW

6 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference
7 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
8 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

Prompt Table: VENDOR_SHRT_VW2

9 AR_NUM Character(15) VARCHAR2(15) NOT NULL Our Customer Number

Prompt Table: VNDR_AR_VW2

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

Prompt Table: VNDR_NAME1_VW2

11 PYMNT_DT Date(10) DATE Payment Date
12 RECON_TYPE Character(1) VARCHAR2(1) NOT NULL Represents a series of options as to how a treasury wishes to perform reconciliation for a given bank
A=Automatically Reconciled
B=Balance System(s) to BankTran
F=Forced to Reconcile
M=Manually Reconciled
S=Semi Manual
U=Unreconciled