EM_PYMNT_INQ_VW

(SQL View)
 Index Back

eS Payment Search Record


SELECT PAYMENT.BANK_SETID , PAYMENT.BANK_CD , PAYMENT.BANK_ACCT_KEY , PAYMENT.PYMNT_METHOD , PAYMENT.PYMNT_ID_REF , PAYMENT.PYMNT_ID , SUPP_USER.OPRID , PAYMENT.PYMNT_AMT , PAYMENT.CURRENCY_PYMNT , PAYMENT.PYMNT_DT , PAYMENT.NAME1 , PAYMENT.REMIT_SETID , PAYMENT.REMIT_VENDOR , PAYMENT.BANK_ACCOUNT_NUM , PAYMENT.RECON_TYPE , PAYMENT.PAY_CYCLE , PAYMENT.PAY_CYCLE_SEQ_NUM FROM PS_PAYMENT_TBL PAYMENT , PS_VENDOR_USER SUPP_USER WHERE PAYMENT.PYMNT_STATUS NOT IN ('X') AND PAYMENT.REMIT_SETID = SUPP_USER.SETID AND PAYMENT.REMIT_VENDOR = SUPP_USER.VENDOR_ID

# 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
8 PYMNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount
9 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
10 PYMNT_DT Date(10) DATE Payment Date
11 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
12 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

Prompt Table: SP_SETRMT_NONVW

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

Prompt Table: VNDR_RMT_VW2

14 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

15 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
16 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
17 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number