DL_DISSUM_03_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) Default Value: DSLF03OP
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	DL_DTL_SEQ_NBR_0	Number(3,0)	SMALLINT NOT NULL	Detail Sequence Number
6	DL_REC_CNTSEQ_NBR0	Number(6,0)	INTEGER NOT NULL	Record Count Sequence #
7	DL_REC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Statement Record Type
8	DL_BATCH_ID_00	Character(23)	VARCHAR2(23) NOT NULL	DL Batch ID
9	CPS_SCHOOL_CODE	Character(6)	VARCHAR2(6) NOT NULL	CPS School Code. Also known as Title IV School Code
10	DL_REGION_CD	Character(2)	VARCHAR2(2) NOT NULL	Region Code
11	DL_STATE_CD	Character(2)	VARCHAR2(2) NOT NULL	State Code
12	DL_END_DATE_0	Date(10)	DATE	DL End Date
13	DL_PROCESS_DATE_0	Date(10)	DATE	DL Process Date
14	DL_DISB_SUM_TYPE	Character(2)	VARCHAR2(2) NOT NULL	DL Disbursement Summary Type
15	DL_BOOK_GROSS_11_0	Number(11,0)	DECIMAL(11) NOT NULL	DL Booked Gross Amount
16	DL_BOOK_FEE_11_0	Number(11,0)	DECIMAL(11) NOT NULL	DL Booked Fee Amount
17	DL_BOOK_REBATE_110	Number(11,0)	DECIMAL(11) NOT NULL	DL Booked Rebate Amount
18	DL_BOOK_NET_11_0	Number(11,0)	DECIMAL(11) NOT NULL	DL Booked Net Amount
19	DL_UNBK_GROSS_11_0	Number(11,0)	DECIMAL(11) NOT NULL	DL Unbooked Gross Amount
20	DL_UNBK_FEE_11_0	Number(11,0)	DECIMAL(11) NOT NULL	DL Unbooked Fee Amount
21	DL_UNBK_REBATE_110	Number(11,0)	DECIMAL(11) NOT NULL	DL Unbooked Rebate Amount
22	DL_UNBK_NET_11_0	Number(11,0)	DECIMAL(11) NOT NULL	DL Unbooked Net Amount
23	DL_FILLER_74	Character(74)	VARCHAR2(74) NOT NULL	DL Filler 74
24	DL_REC_CNT_SEQ_NBR	Character(6)	VARCHAR2(6) NOT NULL	Record Count Sequence #