DL_CHGACK_04_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: DIOC01OP
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_LOAN_ID	Character(21)	VARCHAR2(21) NOT NULL	DL Loan ID
6	DL_RECORD_SEQ	Number(5,0)	INTEGER NOT NULL	DL Record Sequence Nbr
7	DL_LOAN_ID_ERR_CD	Character(2)	VARCHAR2(2) NOT NULL	DL Loan ID Error Cd
8	DL_CHG_FLD_01	Character(4)	VARCHAR2(4) NOT NULL	DL Change Field 1
9	DL_CHG_VALUE_01_02	Character(50)	VARCHAR2(50) NOT NULL	DL Change Value 1
10	DL_RJCT_1	Character(4)	VARCHAR2(4) NOT NULL	Reject Code 1
11	DL_CHG_FLD_02	Character(4)	VARCHAR2(4) NOT NULL	DL Change Field 2
12	DL_CHG_VALUE_02_02	Character(50)	VARCHAR2(50) NOT NULL	DL Change Value 2
13	DL_RJCT_2	Character(4)	VARCHAR2(4) NOT NULL	Reject Code 2
14	DL_CHG_FLD_03	Character(4)	VARCHAR2(4) NOT NULL	DL Change Field 3
15	DL_CHG_VALUE_03_02	Character(50)	VARCHAR2(50) NOT NULL	DL Change Value 3
16	DL_RJCT_3	Character(4)	VARCHAR2(4) NOT NULL	Reject Code 3
17	DL_CHG_FLD_04	Character(4)	VARCHAR2(4) NOT NULL	DL Change Field 4
18	DL_CHG_VALUE_04_02	Character(50)	VARCHAR2(50) NOT NULL	DL Change Value 4
19	DL_RJCT_4	Character(4)	VARCHAR2(4) NOT NULL	Reject Code 4
20	DL_CHG_FLD_05	Character(4)	VARCHAR2(4) NOT NULL	DL Change Field 5
21	DL_CHG_VALUE_05_02	Character(50)	VARCHAR2(50) NOT NULL	DL Change Value 5
22	DL_RJCT_5	Character(4)	VARCHAR2(4) NOT NULL	Reject Code 5
23	DL_CHG_FLD_06	Character(4)	VARCHAR2(4) NOT NULL	DL Change Field 6
24	DL_CHG_VALUE_06_02	Character(50)	VARCHAR2(50) NOT NULL	DL Change Value 6
25	DL_RJCT_6	Character(4)	VARCHAR2(4) NOT NULL	Reject Code 6
26	DL_CHG_FLD_07	Character(4)	VARCHAR2(4) NOT NULL	DL Change Field 7
27	DL_CHG_VALUE_07_02	Character(50)	VARCHAR2(50) NOT NULL	DL Change Value 7
28	DL_RJCT_7	Character(4)	VARCHAR2(4) NOT NULL	Reject Code 7
29	DL_CHG_FLD_08	Character(4)	VARCHAR2(4) NOT NULL	DL Change Field 8
30	DL_CHG_VALUE_08_02	Character(50)	VARCHAR2(50) NOT NULL	DL Change Value 8
31	DL_RJCT_8	Character(4)	VARCHAR2(4) NOT NULL	Reject Code 8
32	DL_CHG_FLD_09	Character(4)	VARCHAR2(4) NOT NULL	DL Change Field 9
33	DL_CHG_VALUE_09_02	Character(50)	VARCHAR2(50) NOT NULL	DL Change Value 9
34	DL_RJCT_9	Character(4)	VARCHAR2(4) NOT NULL	Reject Code 9
35	DL_CHG_FLD_10	Character(4)	VARCHAR2(4) NOT NULL	DL Change Field 10
36	DL_CHG_VALUE_10_02	Character(50)	VARCHAR2(50) NOT NULL	DL Change Value 10
37	DL_RJCT_10	Character(4)	VARCHAR2(4) NOT NULL	Reject Code 10
38	DL_BATCH_ID_00	Character(23)	VARCHAR2(23) NOT NULL	DL Batch ID
39	LN_STG_PROC_STAT	Character(1)	VARCHAR2(1) NOT NULL	Loan Staging Record Proc Stat E=Error K=Skipped L=Loaded N=Not Processed S=Skip U=Unprocessed X=Suspended Y=Processed Default Value: N
40	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance