PMT_CA3_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
3	PMT_MANDATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Mandate direct debit Default Value: NEXT
4	PMT_MANDATE_REF	Character(40)	VARCHAR2(40) NOT NULL	Mandate direct debit
5	CREATION_DT	Date(10)	DATE	Creation Date
6	PMT_MANDATE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Mandate direct debit A=Amended C=Cancelled I=Issued
7	PMT_APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Mandate direct debit A=Approved N=Need Correction O=No Action P=Pending For Approval R=Denied
8	CANCEL_DT	Date(10)	DATE	Date Cancelled
9	PMT_CANCELLED_BY	Character(30)	VARCHAR2(30) NOT NULL	User whose cancelled mandate.
10	PMT_CANCEL_REMARK	Character(100)	VARCHAR2(100) NOT NULL	Mandate direct debit Cancel reason description
11	PMT_DEBTOR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Mandate direct debit B=Treasury Counterparty C=Customer
12	PMT_DEBTOR_NAME	Character(15)	VARCHAR2(15) NOT NULL	Mandate direct debit
13	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
14	CUSTOMER_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
15	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
16	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1