CL_DSB_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_EFT_DTL_REC_CNT	Character(6)	VARCHAR2(6) NOT NULL	EFT Detail Record count
5	CL_TOT_NET_DSB_AMT	Character(14)	VARCHAR2(14) NOT NULL	Total Net Disbursement Amt
6	CL_TOT_NET_EFT_AMT	Character(14)	VARCHAR2(14) NOT NULL	Total Net EFT Amount
7	CL_TOT_NON_EFT_AMT	Character(14)	VARCHAR2(14) NOT NULL	Total Net Non EFT Amount
8	CL_TOT_REISSUE_AMT	Character(14)	VARCHAR2(14) NOT NULL	Total Reissue Amount
9	CL_UNQ_SUP_REC_CNT	Character(6)	VARCHAR2(6) NOT NULL	Unique Supp Detail Rec Count
10	CL_SPC_MSG_REC_CNT	Character(6)	VARCHAR2(6) NOT NULL	Special Messages Det Rec Count
11	CL_FILE_CREA_DATE	Date(10)	DATE	File Create Date
12	CL_FILE_CREATE_TM	Character(6)	VARCHAR2(6) NOT NULL	File Create Time
13	CL_SOURCE_ID_V3	Character(8)	VARCHAR2(8) NOT NULL	CommonLine Source ID Ver 3
14	CL_SRC_NON_ED_BRCH	Character(4)	VARCHAR2(4) NOT NULL	Source Non ED Branch ID
15	CL_TOT_CNCL_AMT	Character(14)	VARCHAR2(14) NOT NULL	Total Cancellation Amount
16	CL_TOT_DEFCIT_AMT	Character(14)	VARCHAR2(14) NOT NULL	Total Deficit Amount
17	CL_DUNS_SOURCE_ID	Character(9)	VARCHAR2(9) NOT NULL	DUNS Source ID