PMT_DETAIL_TEO3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PMT_ID	Character(15)	VARCHAR2(15) NOT NULL	Payment id Prompt Table: PMT_DETAIL_TBL
3	PMT_SOURCE	Character(10)	VARCHAR2(10) NOT NULL	Source System Name
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	SRC_REF_ID	Character(20)	VARCHAR2(20) NOT NULL	Source ref id
6	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
7	AMOUNT_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	PYMNT_DT	Date(10)	DATE	Payment Date
9	VALUE_DT	Date(10)	DATE	Equivalent to a deal transaction's settlement date.
10	ESTIMATED_DUE_DATE	Date(10)	DATE	Estimated due date
11	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
12	PMT_LAST_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Last Status C=Canceled E=Error H=Flagged for Hold L=Awaiting Dispatch P=Paid R=Received by Bank S=Dispatched to Bank SC=In Process
13	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
14	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
15	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
16	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
17	ACCT_BUS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	The general ledger business unit associated with a given bank/counterparty account.
18	FROM_BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	From Bank ID Number
19	FROM_BNK_ACCT_NUM	Character(35)	VARCHAR2(35) NOT NULL	From Bank Account #
20	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
21	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
22	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
23	FORMAT_ID	Character(10)	VARCHAR2(10) NOT NULL	Format ID
24	CAN_LAYOUT	Character(10)	VARCHAR2(10) NOT NULL	Format ID
25	PMT_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
26	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
27	ORG_PMT_ID	Character(15)	VARCHAR2(15) NOT NULL	Original Transaction / Payment ID - used for reversal process.
28	RVL_LAYOUT	Character(10)	VARCHAR2(10) NOT NULL	Format ID
29	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
30	PRENOTE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Flag
31	PAY_IMMEDIATELY	Character(1)	VARCHAR2(1) NOT NULL	Pay Immediately
32	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
33	BANK_ID_QUAL	Character(3)	VARCHAR2(3) NOT NULL	"A bank/counterparty attribute that determines Prompt Table: BNK_ID_QUAL_VW
34	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
35	BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	The local branch office identifier associated with a given bank/counterparty.
36	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
37	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
38	CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
39	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
40	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
41	BANK_NAME	Character(30)	VARCHAR2(30) NOT NULL	Bank Name
42	BANK_NAME_AC	Character(30)	VARCHAR2(30) NOT NULL	Alternate Character Set field for BENEFICIARY_BANK
43	BRANCH_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Branch Description
44	BRANCH_NAME_AC	Character(30)	VARCHAR2(30) NOT NULL	Branch Alternate Char
45	IBAN_CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	IBAN Check Digit
46	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
47	PARTY_ID_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Party Type BENE=Beneficiary CPTY=Counterparty CUST=Customer EMPL=Employee VNDR=Supplier
48	PARTY_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
49	PARTY_ID	Character(30)	VARCHAR2(30) NOT NULL	Payee ID
50	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
51	NAME1_AC	Character(40)	VARCHAR2(40) NOT NULL	Name 1 Alternate Char Set
52	NAME2	Character(40)	VARCHAR2(40) NOT NULL	Name 2
53	STD_ID_NUM	Character(35)	VARCHAR2(35) NOT NULL	ID Number
54	STD_ID_NUM_QUAL	Character(3)	VARCHAR2(3) NOT NULL	Standard ID Number
55	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
56	EFT_RTNG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Complex Routing D=Use DFI ID N=None R=Use Complex Routing Default Value: D
57	EFT_RTNG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Routing Status C=Complete I=Incomplete Default Value: I
58	EFT_TRANS_HANDLING	Character(1)	VARCHAR2(1) NOT NULL	Transaction Handling D=Payment Only P=Prenotification X=Payment and Advice Default Value: X
59	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
60	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
61	EFT_CROSSED_CHECK	Character(1)	VARCHAR2(1) NOT NULL	Crossed Check Y/N Table Edit Default Value: N
62	EFT_CHECK_FWRD_CD	Character(1)	VARCHAR2(1) NOT NULL	Check Forwarding 1=Payer's Bank 2=Payer 3=Payee 4=Payee's Bank
63	EFT_CHECK_DRAW_CD	Character(1)	VARCHAR2(1) NOT NULL	Bank Check Drawn On 1=Payer's Bank 2=Payee's Bank
64	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
65	EFT_PAY_INST_CD2	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 2 Prompt Table: EFT_PAY_INST_VW
66	EFT_PAY_INST_CD3	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 3 Prompt Table: EFT_PAY_INST_VW
67	EFT_PAY_INST_CD4	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 4 Prompt Table: EFT_PAY_INST_VW
68	EFT_PAY_INST_REF1	Character(40)	VARCHAR2(40) NOT NULL	Payment Instruction Ref 1
69	EFT_PAY_INST_REF2	Character(40)	VARCHAR2(40) NOT NULL	Payment Instruction Ref 2
70	ADDENDA_VALUE	Character(254)	VARCHAR2(254) NOT NULL	Addend Value use for Bank Statement Accounting
71	REPETITVE_TRNFR_CD	Character(15)	VARCHAR2(15) NOT NULL	Repetitive Transfer Code assigned by customers Bank
72	DRAWDOWN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Drawdown Transfer Flag, either yes or no. N=No Y=Yes
73	CREATED_BY_USER	Character(30)	VARCHAR2(30) NOT NULL	Created By
74	PMT_FIELD1	Character(30)	VARCHAR2(30) NOT NULL	Payment field
75	PMT_FIELD2	Character(30)	VARCHAR2(30) NOT NULL	Payment field
76	PMT_FIELD3	Character(30)	VARCHAR2(30) NOT NULL	Payment field
77	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
78	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
79	PMT_MSG_ID	Character(15)	VARCHAR2(15) NOT NULL	Payment Message ID
80	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
81	BATCH_NAME	Character(30)	VARCHAR2(30) NOT NULL	Batch Name
82	PMT_FILE_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment File ID
83	BANK_REF_ID	Character(16)	VARCHAR2(16) NOT NULL	A reference identifier associated with a given bank/counterparty transaction.
84	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.
85	PMTRUNINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process ID
86	PAYEE_VIOLATION	Character(1)	VARCHAR2(1) NOT NULL	States that a payee potentially violates the financial sanction list. Indicates that a warning be displayed to the user that they are clearing the payment regardless of the potential violation. N=No Y=Yes Default Value: N
87	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
88	MANDATE_BU	Character(5)	VARCHAR2(5) NOT NULL	Mandate Business Unit
89	PMT_MANDATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Mandate direct debit
90	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
91	CAN_FILE_ID	Character(8)	VARCHAR2(8) NOT NULL	Cancellation Payment File ID
92	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