CL_CHX_TRAL4_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	CL_CHG_DTL1_CNT	Character(6)	VARCHAR2(6) NOT NULL	Change @1 Record Count
5	CL_UNQ_SUP_REC_CNT	Character(6)	VARCHAR2(6) NOT NULL	Unique Supp Detail Rec Count
6	CL_FILE_CREA_DATE	Date(10)	DATE	File Create Date
7	CL_FILE_CREATE_TM	Character(6)	VARCHAR2(6) NOT NULL	File Create Time
8	CL_FILE_ID_CD	Character(5)	VARCHAR2(5) NOT NULL	File Identifier Code
9	CL_SOURCE_NAME	Character(32)	VARCHAR2(32) NOT NULL	Source Name
10	CL_SOURCE_ID_V3	Character(8)	VARCHAR2(8) NOT NULL	CommonLine Source ID Ver 3
11	CL_SRC_NON_ED_BRCH	Character(4)	VARCHAR2(4) NOT NULL	Source Non ED Branch ID
12	CL_RECIP_NAME	Character(32)	VARCHAR2(32) NOT NULL	Recipient Name
13	CL_RECIP_ID_V3	Character(8)	VARCHAR2(8) NOT NULL	CommonLine Recipient ID
14	CL_RECIP_NON_BRCH	Character(4)	VARCHAR2(4) NOT NULL	Recipient Non ED Branch ID
15	CL_DUNS_SOURCE_ID	Character(9)	VARCHAR2(9) NOT NULL	DUNS Source ID
16	CL_DUNS_RECIP_ID	Character(9)	VARCHAR2(9) NOT NULL	DUNS Recipient ID