TR_HV_PAY_VW

(SQL View)
Index Back

SELECT TH.OPRID , DTL.BUSINESS_UNIT , DTL.PARTY_SETID , DTL.PARTY_ID , DTL.BANK_SETID , DTL.BANK_CD , DTL.PYMNT_METHOD , DTL.EFT_LAYOUT_CD , DTL.CURRENCY_CD , DTL.AMOUNT , DTL.NAME1 , DTL.DESCR30 FROM PS_TR_HV_DTL_AL_VW DTL , PS_TR_HV_CUR_THOLD TH WHERE DTL.CURRENCY_CD = TH.CURRENCY_CD AND DTL.AMOUNT > TH.AMOUNT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PARTY_SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 PARTY_ID Character(30) VARCHAR2(30) NOT NULL Payee ID
5 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
6 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
7 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
8 EFT_LAYOUT_CD Character(10) VARCHAR2(10) NOT NULL EFT Layout Code
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
11 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
12 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description