PMT_MSG_ID_VW

(SQL View)
 Index Back

View of dtl stg, ref stg

View of PMT_DETAIL_STG, PMT_REF_STG

SELECT DISTINCT A.PMT_SOURCE , A.PMT_MSG_ID , A.PMT_SEQ_NUM , A.PMT_ID , A.PMT_STATUS , 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.CREATED_BY_USER , %subrec(PMT_REFKEYS_SBR , B) 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_SOURCE Character(10) VARCHAR2(10) NOT NULL Source System Name
2 PMT_MSG_ID Character(15) VARCHAR2(15) NOT NULL Payment Message ID
3 PMT_SEQ_NUM Number(15,0) DECIMAL(15) NOT NULL Sequence Number
4 PMT_ID Character(15) VARCHAR2(15) NOT NULL Payment id
5 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
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
8 AMOUNT_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
10 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
11 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
12 FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID
13 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
14 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
15 KEY_CHAR_40_01 Character(40) VARCHAR2(40) NOT NULL Key Char 40/01
16 KEY_CHAR_40_02 Character(40) VARCHAR2(40) NOT NULL Key Char 40/02
17 KEY_CHAR_40_03 Character(40) VARCHAR2(40) NOT NULL Key Char 40/03
18 KEY_CHAR_40_04 Character(40) VARCHAR2(40) NOT NULL Key Char 40/04
19 KEY_CHAR_40_05 Character(40) VARCHAR2(40) NOT NULL Key Char 40/05
20 KEY_CHAR_40_06 Character(40) VARCHAR2(40) NOT NULL Key_Char 40/06
21 KEY_CHAR_40_07 Character(40) VARCHAR2(40) NOT NULL Key Char 40/07
22 KEY_CHAR_40_08 Character(40) VARCHAR2(40) NOT NULL Key Char 40/08
23 KEY_CHAR_40_09 Character(40) VARCHAR2(40) NOT NULL Key Char 40/09
24 KEY_CHAR_40_10 Character(40) VARCHAR2(40) NOT NULL Key Char 40/10
25 KEY_CHAR_40_11 Character(40) VARCHAR2(40) NOT NULL Key Char 40/11
26 KEY_CHAR_40_12 Character(40) VARCHAR2(40) NOT NULL Key Char 40/12
27 KEY_CHAR_40_13 Character(40) VARCHAR2(40) NOT NULL Key Char 40/13
28 KEY_CHAR_40_14 Character(40) VARCHAR2(40) NOT NULL Key Char 40/14
29 KEY_CHAR_40_15 Character(40) VARCHAR2(40) NOT NULL Key Char 40/15
30 KEY_DATE_01 Date(10) DATE Key Date 01
31 KEY_DATE_02 Date(10) DATE Key Date 02
32 KEY_DATE_03 Date(10) DATE Key Date 03
33 KEY_DATE_04 Date(10) DATE Key Date 04
34 KEY_DATE_05 Date(10) DATE Key Date 05
35 KEY_DTTM_01 DateTime(26) TIMESTAMP Key Date Time 01
36 KEY_DTTM_02 DateTime(26) TIMESTAMP Key Date Time 02
37 KEY_DTTM_03 DateTime(26) TIMESTAMP Key Date Time 03
38 KEY_DTTM_04 DateTime(26) TIMESTAMP Key Date Time 04
39 KEY_DTTM_05 DateTime(26) TIMESTAMP Key Date Time 05
40 KEY_SIGN_01 Signed Number(17,2) DECIMAL(15,2) NOT NULL Key Signed Number 01
41 KEY_SIGN_02 Signed Number(17,2) DECIMAL(15,2) NOT NULL Key Signed Number 02
42 KEY_SIGN_03 Signed Number(17,2) DECIMAL(15,2) NOT NULL Key Signed Number 03
43 KEY_SIGN_04 Signed Number(17,2) DECIMAL(15,2) NOT NULL Key Signed Number 04
44 KEY_SIGN_05 Signed Number(17,2) DECIMAL(15,2) NOT NULL Key Signed Number 05