PMT_FILE_PMT_VW

(SQL View)
 Index Back

Payment Detail Entry

Financial Gateway - Payment Detail Entry

SELECT A.PMT_ID , A.PMT_SOURCE , A.BUSINESS_UNIT , A.AMOUNT , A.AMOUNT_CURRENCY_CD , A.PYMNT_DT , A.VALUE_DT , A.PMT_STATUS , A.PMT_TYPE , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.FROM_BNK_ID_NBR , A.FROM_BNK_ACCT_NUM , A.FROM_DFI_ID_NUM , A.FROM_DFI_ID_QUAL , A.PYMNT_METHOD , A.FORMAT_ID , A.PRENOTE_FLAG , A.PAY_IMMEDIATELY , A.COUNTRY , A.BANK_ID_QUAL , A.BNK_ID_NBR , A.BRANCH_ID , A.BANK_ACCT_TYPE , A.BANK_ACCOUNT_NUM , A.CHECK_DIGIT , A.DFI_ID_QUAL , A.DFI_ID_NUM , A.BANK_NAME , A.BANK_NAME_AC , A.BRANCH_DESCR , A.BRANCH_NAME_AC , A.IBAN_CHECK_DIGIT , A.IBAN_ID , A.PARTY_ID_TYPE , A.PARTY_SETID , A.PARTY_ID , A.NAME1 , A.NAME1_AC , A.NAME2 , A.STD_ID_NUM , A.STD_ID_NUM_QUAL , A.EFT_PYMNT_FMT_CD , A.EFT_RTNG_FLG , A.EFT_RTNG_STATUS , A.EFT_TRANS_HANDLING , A.EFT_DOM_COSTS_CD , A.EFT_CORR_COSTS_CD , A.EFT_CROSSED_CHECK , A.EFT_CHECK_FWRD_CD , A.EFT_CHECK_DRAW_CD , A.EFT_PAY_INST_CD1 , A.EFT_PAY_INST_CD2 , A.EFT_PAY_INST_CD3 , A.EFT_PAY_INST_CD4 , A.EFT_PAY_INST_REF1 , A.EFT_PAY_INST_REF2 , A.ADDENDA_VALUE , A.REPETITVE_TRNFR_CD , A.DRAWDOWN_FLG , A.EVENT_TRACKING_ID , A.PMT_MSG_ID , A.IN_PROCESS_FLG , A.BATCH_NAME , A.SRC_REF_ID , A.PMTRUNINSTANCE , B.PMT_FILE_ID , A.BANK_REF_ID FROM PS_PMT_DETAIL_TBL A , PS_PMT_FILE_XREF 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

Prompt Table: PMT_DETAIL_TBL

2 PMT_SOURCE Character(10) VARCHAR2(10) NOT NULL Source System Name
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
5 AMOUNT_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
6 PYMNT_DT Date(10) DATE Payment Date
7 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.
8 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
9 PMT_TYPE Character(4) VARCHAR2(4) NOT NULL Payment type
BAX=Bank Transfer
BON=Bonus
COLL=Collection
DEAL=Deal Cash Flow
EFTR=EFT Request
EXAD=Exp Advance
EXPN=Expense Sheet
FEE=Fee
GR=General Recipient Deduction
IR=Individual Recipient Deduction
NP=Net Pay Distribution
OTHR=Other
SAL=Salary
VCHR=Voucher
10 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
11 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
12 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
13 FROM_BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL From Bank ID Number
14 FROM_BNK_ACCT_NUM Character(35) VARCHAR2(35) NOT NULL From Bank Account #
15 FROM_DFI_ID_NUM Character(12) VARCHAR2(12) NOT NULL A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
16 FROM_DFI_ID_QUAL Character(2) VARCHAR2(2) NOT NULL A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number
02=Swift ID
03=CHIPS Participant ID
04=Canadian Bank Branch/Institute
05=CHIPS Universal ID
ZZ=Mutually Defined
17 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
18 FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID
19 PRENOTE_FLAG Character(1) VARCHAR2(1) NOT NULL Prenotification Flag
20 PAY_IMMEDIATELY Character(1) VARCHAR2(1) NOT NULL Pay Immediately
21 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
22 BANK_ID_QUAL Character(3) VARCHAR2(3) NOT NULL "A bank/counterparty attribute that determines

Prompt Table: BNK_ID_QUAL_VW

23 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
24 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.
25 BANK_ACCT_TYPE Character(2) VARCHAR2(2) NOT NULL An account attribute that describes the ostensible purposes of a given bank/counterparty account.
01=Time Deposit
03=Checking Account
05=Stock
06=Bond
07=Life Insurance Value
08=Retirement Account
10=Business Account
11=Trust Fund Account
12=Stock & Bond Account
13=Life Insurance Acct
CA=Current Account
CH=Charges Account
DA=Demand Deposit
LN=Loan
RD=Return Items on DDA
RS=Return Items-Savings
SA=Settlement Account
SV=Savings Account
Z=Mutually Defined
26 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
27 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
28 DFI_ID_QUAL Character(2) VARCHAR2(2) NOT NULL A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number
02=Swift ID/BIC
03=CHIPS Participant ID
04=Canadian Bank Branch/Institute
05=CHIPS Universal ID
ZZ=Mutually Defined
29 DFI_ID_NUM Character(12) VARCHAR2(12) NOT NULL A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
30 BANK_NAME Character(30) VARCHAR2(30) NOT NULL Bank Name
31 BANK_NAME_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character Set field for BENEFICIARY_BANK
32 BRANCH_DESCR Character(30) VARCHAR2(30) NOT NULL Branch Description
33 BRANCH_NAME_AC Character(30) VARCHAR2(30) NOT NULL Branch Alternate Char
34 IBAN_CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL IBAN Check Digit
35 IBAN_ID Character(34) VARCHAR2(34) NOT NULL IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders
36 PARTY_ID_TYPE Character(4) VARCHAR2(4) NOT NULL Party Type
BENE=Beneficiary
CPTY=Counterparty
CUST=Customer
EMPL=Employee
VNDR=Supplier
37 PARTY_SETID Character(5) VARCHAR2(5) NOT NULL SetID
38 PARTY_ID Character(30) VARCHAR2(30) NOT NULL Payee ID
39 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
40 NAME1_AC Character(40) VARCHAR2(40) NOT NULL Name 1 Alternate Char Set
41 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
42 STD_ID_NUM Character(35) VARCHAR2(35) NOT NULL ID Number
43 STD_ID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number
44 EFT_PYMNT_FMT_CD Character(3) VARCHAR2(3) NOT NULL Payment Format
00=Standard SWIFT transfer
10=Urgent SWIFT
15=Euro-Transfer
21=Check, w/ receipt confirmation
22=Check, Urgent
23=Check, urgent w/ receipt
40=Postal Order
CTX=Corp Trade Exchange
PBC=Check, standard
PPD=Prearranged Pay & Deposit
WRT=Wire Transfer
45 EFT_RTNG_FLG Character(1) VARCHAR2(1) NOT NULL Complex Routing
D=Use DFI ID
N=None
R=Use Complex Routing

Default Value: D

46 EFT_RTNG_STATUS Character(1) VARCHAR2(1) NOT NULL Routing Status
C=Complete
I=Incomplete

Default Value: I

47 EFT_TRANS_HANDLING Character(1) VARCHAR2(1) NOT NULL Transaction Handling
D=Payment Only
P=Prenotification
X=Payment and Advice

Default Value: X

48 EFT_DOM_COSTS_CD Character(1) VARCHAR2(1) NOT NULL Domestic Costs
1=Payer's Domestic Account
2=Payer's Foreign Account
3=Payee's Account
4=Trans Exp to Pyr, other to Pye
49 EFT_CORR_COSTS_CD Character(1) VARCHAR2(1) NOT NULL Correspondent's Costs
1=Payer's Domestic Account
2=Payer's Foreign Account
3=Payee's Account
50 EFT_CROSSED_CHECK Character(1) VARCHAR2(1) NOT NULL Crossed Check

Y/N Table Edit

Default Value: N

51 EFT_CHECK_FWRD_CD Character(1) VARCHAR2(1) NOT NULL Check Forwarding
1=Payer's Bank
2=Payer
3=Payee
4=Payee's Bank
52 EFT_CHECK_DRAW_CD Character(1) VARCHAR2(1) NOT NULL Bank Check Drawn On
1=Payer's Bank
2=Payee's Bank
53 EFT_PAY_INST_CD1 Character(3) VARCHAR2(3) NOT NULL Payment Instruction 1
ACC=/ACC/
BEN=/BENONLY/
CHK=/CHECK/
COR=/CORPTRAD/
HLD=/HOLD/
INT=/INT/
IRR=PAYMENT IRREVOCABLE
PHB=/PHONEBEN/
PHI=/PHONIBK/
PHN=/PHON/
RC1=ADV BEN W/CHARGES
RC2=ADV BEN W/O CHARGES
RCB=/RCB/
REC=/REC/
REJ=/REJT/
RET=BEN UNKNOWN RETURN
TEB=/TELEBEN/
TEI=/TELEIBK/
TEL=/TELE/
XFR=INTERCOMPANY TRANSFER

Prompt Table: EFT_PAY_INST_VW

54 EFT_PAY_INST_CD2 Character(3) VARCHAR2(3) NOT NULL Payment Instruction 2

Prompt Table: EFT_PAY_INST_VW

55 EFT_PAY_INST_CD3 Character(3) VARCHAR2(3) NOT NULL Payment Instruction 3

Prompt Table: EFT_PAY_INST_VW

56 EFT_PAY_INST_CD4 Character(3) VARCHAR2(3) NOT NULL Payment Instruction 4

Prompt Table: EFT_PAY_INST_VW

57 EFT_PAY_INST_REF1 Character(40) VARCHAR2(40) NOT NULL Payment Instruction Ref 1
58 EFT_PAY_INST_REF2 Character(40) VARCHAR2(40) NOT NULL Payment Instruction Ref 2
59 ADDENDA_VALUE Character(254) VARCHAR2(254) NOT NULL Addend Value use for Bank Statement Accounting
60 REPETITVE_TRNFR_CD Character(15) VARCHAR2(15) NOT NULL Repetitive Transfer Code assigned by customers Bank
61 DRAWDOWN_FLG Character(1) VARCHAR2(1) NOT NULL Drawdown Transfer Flag, either yes or no.
N=No
Y=Yes
62 EVENT_TRACKING_ID Number(10,0) DECIMAL(10) NOT NULL The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.
63 PMT_MSG_ID Character(15) VARCHAR2(15) NOT NULL Payment Message ID
64 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
65 BATCH_NAME Character(30) VARCHAR2(30) NOT NULL Batch Name
66 SRC_REF_ID Character(20) VARCHAR2(20) NOT NULL Source ref id
67 PMTRUNINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process ID
68 PMT_FILE_ID Character(8) VARCHAR2(8) NOT NULL Payment File ID
69 BANK_REF_ID Character(16) VARCHAR2(16) NOT NULL A reference identifier associated with a given bank/counterparty transaction.