CL_APR_MSG4_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	LN_DTL_NBR	Number(5,0)	INTEGER NOT NULL	Loan Detail Line Number
5	LN_MSG_NBR	Number(3,0)	SMALLINT NOT NULL	Loan Message Detail Record Num
6	CL_UNIQUE_ID4	Character(17)	VARCHAR2(17) NOT NULL	CL Loan Unique Identifier
7	CL_MESSAGE_1	Character(160)	VARCHAR2(160) NOT NULL	CL3 Special Message 1
8	CL_MESSAGE_2	Character(160)	VARCHAR2(160) NOT NULL	CL3 Special Message 2
9	CL_MESSAGE_3	Character(160)	VARCHAR2(160) NOT NULL	CL3 Special Message 3
10	CL_MESSAGE_4	Character(160)	VARCHAR2(160) NOT NULL	CL3 Special Message 4
11	CL_MESSAGE_5	Character(160)	VARCHAR2(160) NOT NULL	CL3 Special Message 5