ECTRANSSET_EC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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)
2	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.
3	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
4	EC_PACKAGE_CNTL_NB	Character(10)	VARCHAR2(10) NOT NULL	EC Package Control ID
5	EC_PACKAGE_VER	Character(6)	VARCHAR2(6) NOT NULL	EC Package Version
6	EC_TRANS_GROUP_NBR	Character(18)	VARCHAR2(18) NOT NULL	EC Transaction Group Cntl Nbr
7	EC_TRANS_GROUP_VER	Character(6)	VARCHAR2(6) NOT NULL	EC Transaction Group Version
8	EC_QUEUE_CNTL_NBR	Character(32)	VARCHAR2(32) NOT NULL	EC Queue Control Number
9	ECRELATEDTRANSID	Character(15)	VARCHAR2(15) NOT NULL	EC Related Transaction ID
10	ECRELATEDINOUTSW	Character(1)	VARCHAR2(1) NOT NULL	EC Related In/Out Switch
11	ECCUSTVNDRVAL	Character(15)	VARCHAR2(15) NOT NULL	PS Customer/Vendor Number
12	ECENTITYCD_EXT	Character(8)	VARCHAR2(8) NOT NULL	Ec Entity Code for External ID Prompt Table: ECENTITYCDS