TSE_CC_CF_FLD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TSE_JOBID	Character(10)	VARCHAR2(10) NOT NULL	TSE Job Identifier
2	TSE_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	TSE Run ID
3	TSE_SET_NBR	Number(6,0)	INTEGER NOT NULL	TSE Set Number
4	TSE_EDIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	TSE Edit Type A=Application Edit D=Date Range Edit P=Prompt Table Edit R=Required Field Edit X=Translate Table Edit Y=Yes/No Edit
5	TSE_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	TSE Field Name
6	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
7	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
8	MESSAGE_PARM	Character(254)	VARCHAR2(254) NOT NULL	Message Parameter Text
9	MESSAGE_PARM2	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 2
10	MESSAGE_PARM3	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 3
11	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
12	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
13	CREDIT_CARD_VENDOR	Character(5)	VARCHAR2(5) NOT NULL	Corporate Card Vendor
14	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
15	TRANS_NBR	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
16	TRANS_DT	Date(10)	DATE	Transaction Date
17	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
18	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
19	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
20	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line