TSE_TRDTL_FLD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TSE_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	TSE Run ID
2	TSE_JOBID	Character(10)	VARCHAR2(10) NOT NULL	TSE Job Identifier
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	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
7	TRANSACTION_LINE	Number(3,0)	SMALLINT NOT NULL	The separate and distinct base instrument type components of a given deal transaction.
8	ECTRANSID	Character(15)	VARCHAR2(15) NOT NULL	Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
9	ECTRANSINOUTSW	Character(1)	VARCHAR2(1) NOT NULL	Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound. I=Inbound O=Outbound
10	ECACTIONCD	Character(3)	VARCHAR2(3) NOT NULL	EC Action Code
11	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
12	TREAS_HEADER_ID	Character(12)	VARCHAR2(12) NOT NULL	The unique key identifier for a given deal transaction.