DL_LNDTL_01_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: DSAS01OP
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_LN_DTL_SEQ_0	Number(6,0)	INTEGER NOT NULL	Loan Detail Sequence
7	DL_REC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Statement Record Type Default Value: L
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_END_DATE_0	Date(10)	DATE	DL End Date
11	DL_PROCESS_DATE_0	Date(10)	DATE	DL Process Date
12	DL_LOAN_ID	Character(21)	VARCHAR2(21) NOT NULL	DL Loan ID
13	DL_FILLER_1	Character(1)	VARCHAR2(1) NOT NULL	DL Filler 1
14	DL_DISB_NBR2_0	Number(2,0)	SMALLINT NOT NULL	Disbursement Number
15	DL_FILLER_1A	Character(1)	VARCHAR2(1) NOT NULL	DL Filler 1
16	DL_TRANS_TYPE_DISB	Character(1)	VARCHAR2(1) NOT NULL	Transaction Type-Disbursement
17	DL_FILLER_1B	Character(1)	VARCHAR2(1) NOT NULL	DL Filler 1
18	DL_TRANS_DATE_0	Date(10)	DATE	Transaction Date
19	DL_FILLER_1C	Character(1)	VARCHAR2(1) NOT NULL	DL Filler 1
20	DL_DISB_SEQ_NBR_O	Number(2,0)	SMALLINT NOT NULL	Disbursement Sequence Number
21	DL_FILLER_1D	Character(1)	VARCHAR2(1) NOT NULL	DL Filler 1
22	DL_FILLER_5	Character(5)	VARCHAR2(5) NOT NULL	DL Filler 5
23	DL_FILLER_5A	Character(5)	VARCHAR2(5) NOT NULL	DL Filler 5
24	DL_FILLER_5B	Character(5)	VARCHAR2(5) NOT NULL	DL Filler 5
25	DL_FILLER_6	Character(6)	VARCHAR2(6) NOT NULL	DL Filler 6
26	DL_DISB_GRS_SVCR_O	Number(6,0)	INTEGER NOT NULL	DL Disbt Servicer Actual Gross
27	DL_DISB_FEE_SVCR_O	Number(5,0)	INTEGER NOT NULL	DL Disbt Servicer Actual Fee
28	DL_DISB_NET_SVCR_O	Number(6,0)	INTEGER NOT NULL	DL Disbt Servicer Actual Net
29	DL_DISB_ADJ_SVCR_O	Number(7,0)	INTEGER NOT NULL	DL Disbt Servicer Actual Adj
30	LN_BOOK_STAT	Character(1)	VARCHAR2(1) NOT NULL	Direct Lending Booked Status A=Booked R=Unbooked
31	DL_DISB_BKDT_LOC_0	Date(10)	DATE	Disbursement Book Date at LOC
32	DL_FILLER_78	Character(78)	VARCHAR2(78) NOT NULL	DL Filler 78
33	DL_REC_CNTSEQ_NBR0	Number(6,0)	INTEGER NOT NULL	Record Count Sequence #