PMT_MANDATE_HDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW
2	PMT_MANDATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Mandate direct debit Default Value: NEXT Prompt Table: PMT_MANDATE_HDR
3	PMT_MANDATE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type Of Mandate - paper or electronic E=Electronic Mandate P=Paper Mandate Default Value: P
4	PMT_MANDATE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Mandate direct debit A=Amended C=Cancelled I=Issued Default Value: I
5	CANCEL_DT	Date(10)	DATE	Date Cancelled
6	PMT_CANCELLED_BY	Character(30)	VARCHAR2(30) NOT NULL	User whose cancelled mandate.
7	PMT_CANCEL_REMARK	Character(100)	VARCHAR2(100) NOT NULL	Mandate direct debit Cancel reason description
8	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
9	PMT_SIGNED_LOC	Character(30)	VARCHAR2(30) NOT NULL	Mandate direct debit
10	PMT_SIGNED_DT	Date(10)	DATE NOT NULL	Mandate direct debit Default Value: %date
11	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
12	PMT_CONTRACT_DSCR	Long Character	CLOB	Mandate direct debit Contract description
13	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
14	LAST_UPDATE_DATE	Date(10)	DATE	Date of last update