DL_PNOTE_ACK_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_LOAN_ID	Character(21)	VARCHAR2(21) NOT NULL	DL Loan ID
6	DL_PNOTE_ACPT_DT_O	Date(10)	DATE	DL Prom Note Accept Dt
7	DL_BATCH_ID	Character(2)	VARCHAR2(2) NOT NULL	DL Batch ID Default Value: #A
8	DL_BATCH_NBR	Character(15)	VARCHAR2(15) NOT NULL	DL Batch Nbr
9	DL_BATCH	Character(17)	VARCHAR2(17) NOT NULL	Direct Lending Batch
10	DL_PPR_PNOTE_STAT	Character(1)	VARCHAR2(1) NOT NULL	DL Paper PNote Status
11	DL_PNOTE_RJCT_1	Character(1)	VARCHAR2(1) NOT NULL	DL P Note Reject 1
12	DL_PNOTE_RJCT_2	Character(1)	VARCHAR2(1) NOT NULL	DL P Note Reject 2
13	DL_PNOTE_RJCT_3	Character(1)	VARCHAR2(1) NOT NULL	DL P Note Reject 3
14	DL_PNOTE_RJCT_4	Character(1)	VARCHAR2(1) NOT NULL	DL P Note Reject 4
15	DL_PNOTE_RJCT_5	Character(1)	VARCHAR2(1) NOT NULL	DL P Note Reject 5
16	DL_PNOTE_RJCT_6	Character(1)	VARCHAR2(1) NOT NULL	DL P Note Reject 6
17	DL_PNOTE_RJCT_7	Character(1)	VARCHAR2(1) NOT NULL	DL P Note Reject 7
18	DL_PNOTE_RJCT_8	Character(1)	VARCHAR2(1) NOT NULL	DL P Note Reject 8
19	DL_PNOTE_RJCT_9	Character(1)	VARCHAR2(1) NOT NULL	DL P Note Reject 9
20	DL_PNOTE_RJCT_10	Character(1)	VARCHAR2(1) NOT NULL	DL P Note Reject 10
21	DL_PNOTE_PRSEQ_O	Number(2,0)	SMALLINT NOT NULL	DL PNote Print Seq
22	DL_DSB1_ANTC_AMT_O	Number(5,0)	INTEGER NOT NULL	DL Antic 1st Disb Amt
23	DL_DSB2_ANTC_AMT_O	Number(5,0)	INTEGER NOT NULL	DL Antic 2nd Disb Amt
24	DL_DSB3_ANTC_AMT_O	Number(5,0)	INTEGER NOT NULL	DL Antic 3rd Disb Amt
25	DL_DSB4_ANTC_AMT_O	Number(5,0)	INTEGER NOT NULL	DL Antic 4th Disb Amt
26	DL_RECON_STAT	Character(1)	VARCHAR2(1) NOT NULL	Reconciliation Status
27	DL_RECON_RJCT_1	Character(2)	VARCHAR2(2) NOT NULL	Reconciliation Reject 1
28	DL_RECON_RJCT_2	Character(2)	VARCHAR2(2) NOT NULL	Reconciliation Reject 2
29	DL_RECON_RJCT_3	Character(2)	VARCHAR2(2) NOT NULL	Reconciliation Reject 3
30	DL_RECON_RJCT_4	Character(2)	VARCHAR2(2) NOT NULL	Reconciliation Reject 4
31	DL_RECON_RJCT_5	Character(2)	VARCHAR2(2) NOT NULL	Reconciliation Reject 5
32	DL_SRVCR_TOT_NET_O	Number(5,0)	INTEGER NOT NULL	DL SvcrCtr Tot Net Amt
33	DL_RECORD_SEQ	Number(5,0)	INTEGER NOT NULL	DL Record Sequence Nbr
34	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