PMT_DTL_REF_VW1

(SQL View)
 Index Back

View of Detail + Ref

View of PMT_DETAIL_TBL, PMT_REF_TBL

SELECT A.PMT_ID , A.PMT_STATUS , A.PMT_MSG_ID , A.PMT_SEQ_NUM , A.PMT_SOURCE , %subrec(PMT_REFKEYS_SBR , B) , A.BUSINESS_UNIT , A.AMOUNT , A.AMOUNT_CURRENCY_CD , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.FORMAT_ID , A.PYMNT_METHOD , A.SRC_REF_ID , A.CREATED_BY_USER FROM PS_PMT_DETAIL_TBL A , PS_PMT_REF_TBL B WHERE A.PMT_ID = B.PMT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PMT_ID Character(15) VARCHAR2(15) NOT NULL Payment id
2 PMT_STATUS Character(2) VARCHAR2(2) NOT NULL Payment status
C=Canceled
CM=Cancelled with Message
E=Error
H=Flagged for Hold
L=Awaiting Dispatch
N=Not Processed
P=Paid
PC=Pending Cancellation
PR=Pending Reversal
R=Received by Bank
RM=Reversed with Message
S=Dispatched to Bank
SC=In Process
3 PMT_MSG_ID Character(15) VARCHAR2(15) NOT NULL Payment Message ID
4 PMT_SEQ_NUM Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 PMT_SOURCE Character(10) VARCHAR2(10) NOT NULL Source System Name
6 KEY_CHAR_40_01 Character(40) VARCHAR2(40) NOT NULL Key Char 40/01
7 KEY_CHAR_40_02 Character(40) VARCHAR2(40) NOT NULL Key Char 40/02
8 KEY_CHAR_40_03 Character(40) VARCHAR2(40) NOT NULL Key Char 40/03
9 KEY_CHAR_40_04 Character(40) VARCHAR2(40) NOT NULL Key Char 40/04
10 KEY_CHAR_40_05 Character(40) VARCHAR2(40) NOT NULL Key Char 40/05
11 KEY_CHAR_40_06 Character(40) VARCHAR2(40) NOT NULL Key_Char 40/06
12 KEY_CHAR_40_07 Character(40) VARCHAR2(40) NOT NULL Key Char 40/07
13 KEY_CHAR_40_08 Character(40) VARCHAR2(40) NOT NULL Key Char 40/08
14 KEY_CHAR_40_09 Character(40) VARCHAR2(40) NOT NULL Key Char 40/09
15 KEY_CHAR_40_10 Character(40) VARCHAR2(40) NOT NULL Key Char 40/10
16 KEY_CHAR_40_11 Character(40) VARCHAR2(40) NOT NULL Key Char 40/11
17 KEY_CHAR_40_12 Character(40) VARCHAR2(40) NOT NULL Key Char 40/12
18 KEY_CHAR_40_13 Character(40) VARCHAR2(40) NOT NULL Key Char 40/13
19 KEY_CHAR_40_14 Character(40) VARCHAR2(40) NOT NULL Key Char 40/14
20 KEY_CHAR_40_15 Character(40) VARCHAR2(40) NOT NULL Key Char 40/15
21 KEY_DATE_01 Date(10) DATE Key Date 01
22 KEY_DATE_02 Date(10) DATE Key Date 02
23 KEY_DATE_03 Date(10) DATE Key Date 03
24 KEY_DATE_04 Date(10) DATE Key Date 04
25 KEY_DATE_05 Date(10) DATE Key Date 05
26 KEY_DTTM_01 DateTime(26) TIMESTAMP Key Date Time 01
27 KEY_DTTM_02 DateTime(26) TIMESTAMP Key Date Time 02
28 KEY_DTTM_03 DateTime(26) TIMESTAMP Key Date Time 03
29 KEY_DTTM_04 DateTime(26) TIMESTAMP Key Date Time 04
30 KEY_DTTM_05 DateTime(26) TIMESTAMP Key Date Time 05
31 KEY_SIGN_01 Signed Number(17,2) DECIMAL(15,2) NOT NULL Key Signed Number 01
32 KEY_SIGN_02 Signed Number(17,2) DECIMAL(15,2) NOT NULL Key Signed Number 02
33 KEY_SIGN_03 Signed Number(17,2) DECIMAL(15,2) NOT NULL Key Signed Number 03
34 KEY_SIGN_04 Signed Number(17,2) DECIMAL(15,2) NOT NULL Key Signed Number 04
35 KEY_SIGN_05 Signed Number(17,2) DECIMAL(15,2) NOT NULL Key Signed Number 05
36 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
37 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
38 AMOUNT_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
39 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
40 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
41 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
42 FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID
43 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
44 SRC_REF_ID Character(20) VARCHAR2(20) NOT NULL Source ref id
45 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By