PMT_DETAIL_MAP

(SQL Table)
Index Back

Payment Detail Entry

Payment Detail Entry

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HEADER_ID Character(8) VARCHAR2(8) NOT NULL Header_id
2 BATCH_SEQ_NUM Number(15,0) DECIMAL(15) NOT NULL Batch Number
3 PYMNT_REF_ID Character(20) VARCHAR2(20) NOT NULL Payment ID
4 PMT_SOURCE Character(10) VARCHAR2(10) NOT NULL Source System Name
5 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
6 AMOUNT_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 PYMNT_DT Date(10) DATE Payment Date
8 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.
9 ESTIMATED_DUE_DATE Date(10) DATE Estimated due date
10 PAY_IMMEDIATELY Character(1) VARCHAR2(1) NOT NULL Pay Immediately
11 PRENOTE_FLAG Character(1) VARCHAR2(1) NOT NULL Prenotification Flag
12 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
13 EFT_RTNG_FLG Character(1) VARCHAR2(1) NOT NULL Complex Routing
D=Use DFI ID
N=None
R=Use Complex Routing

Default Value: D

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

Default Value: I

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

Default Value: X

16 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
17 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
18 EFT_CROSSED_CHECK Character(1) VARCHAR2(1) NOT NULL Crossed Check

Y/N Table Edit

Default Value: N

19 EFT_CHECK_FWRD_CD Character(1) VARCHAR2(1) NOT NULL Check Forwarding
1=Payer's Bank
2=Payer
3=Payee
4=Payee's Bank
20 EFT_CHECK_DRAW_CD Character(1) VARCHAR2(1) NOT NULL Bank Check Drawn On
1=Payer's Bank
2=Payee's Bank
21 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

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

Prompt Table: EFT_PAY_INST_VW

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

Prompt Table: EFT_PAY_INST_VW

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

Prompt Table: EFT_PAY_INST_VW

25 EFT_PAY_INST_REF1 Character(40) VARCHAR2(40) NOT NULL Payment Instruction Ref 1
26 EFT_PAY_INST_REF2 Character(40) VARCHAR2(40) NOT NULL Payment Instruction Ref 2
27 ADDENDA_VALUE Character(254) VARCHAR2(254) NOT NULL Addend Value use for Bank Statement Accounting
28 REPETITVE_TRNFR_CD Character(15) VARCHAR2(15) NOT NULL Repetitive Transfer Code assigned by customers Bank
29 DRAWDOWN_FLG Character(1) VARCHAR2(1) NOT NULL Drawdown Transfer Flag, either yes or no.
N=No
Y=Yes
30 CAN_LAYOUT Character(10) VARCHAR2(10) NOT NULL Format ID
31 CAN_REASON Character(34) VARCHAR2(34) NOT NULL Cancellation Reason - used when payments are cancelled. Will store Cancellation Reason Code. Reason Codes: AGNT - IncorrectAgent CURR - IncorrectCurrency CUST - RequestedByCustomer DUPL - DuplicatePayment SUSP - SuspiciousPayment UPAY - UnduePayment
32 ORG_PMT_ID Character(15) VARCHAR2(15) NOT NULL Original Transaction / Payment ID - used for reversal process.
33 RVL_LAYOUT Character(10) VARCHAR2(10) NOT NULL Format ID
34 RVL_REASON Character(34) VARCHAR2(34) NOT NULL Reversal Reason - used when payments are reversed. Will store Reversal Reason Code. Reason Codes: AC04 - ClosedAccountNumber AG02 - InvalidBankOperationCode AM05 - Duplication MD01 - NoMandate MD05 - CollectionNotDue
35 SEQUENCE_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies the direct debit sequence, eg, first, recurrent, final or one-off.
F=First Payment
N=Final Payment
O=OneOff Payment
R=Recurring Payment
36 SEQTP Character(5) VARCHAR2(5) NOT NULL Sequence Type
37 CD Character(30) VARCHAR2(30) NOT NULL Code
38 PRTRY Character(30) VARCHAR2(30) NOT NULL Proprietary
39 INSTRPRTY Character(4) VARCHAR2(4) NOT NULL InstrPrty