CL_IMP_HEAD_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 Default Value: I
4	LN_HEADER_NBR	Number(3,0)	SMALLINT NOT NULL	Loan Header Nbr
5	CL_FILE_ID_CD	Character(5)	VARCHAR2(5) NOT NULL	File Identifier Code
6	CL_BATCH_ID	Character(12)	VARCHAR2(12) NOT NULL	CommonLine Batch ID
7	CL_FILE_CREA_DATE	Date(10)	DATE	File Create Date
8	CL_FILE_CREATE_TM	Character(6)	VARCHAR2(6) NOT NULL	File Create Time
9	CL_FILE_TRANS_DT	Date(10)	DATE	File Transmission Date
10	CL_FILE_TRANS_TIME	Character(6)	VARCHAR2(6) NOT NULL	File Transmission Time
11	CL_SOURCE_NAME	Character(32)	VARCHAR2(32) NOT NULL	Source Name
12	CL_SOURCE_ID	Character(6)	VARCHAR2(6) NOT NULL	Source ID
13	CL_RECIP_NAME	Character(32)	VARCHAR2(32) NOT NULL	Recipient Name
14	CL_RECIP_ID	Character(6)	VARCHAR2(6) NOT NULL	Recipient ID
15	CL_RECIP_BRCH_ID	Character(2)	VARCHAR2(2) NOT NULL	Recipient ED Branch ID
16	CL_SRC_ED_BRCH_ID	Character(2)	VARCHAR2(2) NOT NULL	Source ED Branch ID
17	LOAN_TRANS_DTTM	DateTime(26)	TIMESTAMP	Loan Trans Date/Time
18	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).