TR_HV_DTL_FG_VW

(SQL View)
Index Back

SELECT DTL.BUSINESS_UNIT ,DTL.PARTY_SETID ,DTL.PARTY_ID ,DTL.BANK_SETID ,DTL.BANK_CD ,DTL.PYMNT_METHOD ,DTL.FORMAT_ID ,DTL.AMOUNT_CURRENCY_CD ,DTL.AMOUNT ,DTL.NAME1 ,DTL.PMT_ID FROM PS_PMT_DETAIL_TBL DTL WHERE DTL.PYMNT_DT = %CurrentDateIn AND DTL.PMT_STATUS IN ('E', 'H', 'L') AND DTL.PYMNT_METHOD <> 'DD'

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