DL_HDR_12_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	DL_HEADER_ID	Character(10)	VARCHAR2(10) NOT NULL	DL Header ID Default Value: DL HEADER
6	DL_REC_LNGTH_O	Number(4,0)	SMALLINT NOT NULL	Record Length
7	DL_MSG_CLASS	Character(8)	VARCHAR2(8) NOT NULL	DL Message Class
8	DL_BATCH_ID_00	Character(23)	VARCHAR2(23) NOT NULL	DL Batch ID
9	DL_HDR_CREATE_DT_O	Date(10)	DATE	DL Create Date
10	DL_CREATE_TIME	Character(6)	VARCHAR2(6) NOT NULL	DL Create Time
11	DL_BATCH_RJCT	Character(2)	VARCHAR2(2) NOT NULL	Direct Loan Batch Reject Code
12	DL_REBUILD_TYPE	Character(2)	VARCHAR2(2) NOT NULL	DL Rebuild File Type
13	DL_PROVIDER_ID	Character(3)	VARCHAR2(3) NOT NULL	DL Software Provider ID
14	DL_PROVIDER_VER	Character(6)	VARCHAR2(6) NOT NULL	DL Software Provider Version
15	LOAN_TRANS_DTTM	DateTime(26)	TIMESTAMP	Loan Trans Date/Time
16	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
17	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
18	DL_RECORD_LENGTH	Character(4)	VARCHAR2(4) NOT NULL	Loan Record Length