PMT_DETAIL_MAP(SQL Table) |
Index Back |
---|---|
Payment Detail EntryPayment 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 |