PYMNT_INQ_VW (SQL View)	Index Back
AP Payment Search Record

PYMNT_INQ_VW

(SQL View)

AP Payment Search Record

SELECT bank_setid , bank_cd , bank_acct_key , pymnt_method , pymnt_id_ref , pymnt_id , pymnt_amt , currency_pymnt , pymnt_dt , name1 , remit_setid , remit_vendor , bank_account_num , recon_type , pay_cycle , pay_cycle_seq_num FROM PS_PAYMENT_TBL WHERE pymnt_status NOT IN ('X')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
Prompt Table: BANK_CD_VW2

3 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

4 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer

5 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference

6 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number

7 PYMNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount

8 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency

9 PYMNT_DT Date(10) DATE Payment Date

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

11 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
Prompt Table: SP_SETRMT_NONVW

12 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
Prompt Table: VNDR_RMT_VW2

13 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
Prompt Table: BANK_ACCT_VW

14 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

15 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle

16 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_CD_VW2
3	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
4	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer
5	PYMNT_ID_REF	Character(20)	VARCHAR2(20) NOT NULL	Payment Reference
6	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
7	PYMNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amount
8	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
9	PYMNT_DT	Date(10)	DATE	Payment Date
10	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
11	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID Prompt Table: SP_SETRMT_NONVW
12	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor Prompt Table: VNDR_RMT_VW2
13	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account. Prompt Table: BANK_ACCT_VW
14	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
15	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
16	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number