ISIR_ER_BAT_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
4	ISIR_SEQ_NO	Number(5,0)	INTEGER NOT NULL	Sequence Number
5	IWD_REJECT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Reject Type
6	IWD_BATCH_NBR	Character(23)	VARCHAR2(23) NOT NULL	Batch Number
7	ORIG_SSN	Character(9)	VARCHAR2(9) NOT NULL	Original SSN
8	NAME_CD	Character(2)	VARCHAR2(2) NOT NULL	Name Code
9	IWD_TRANS_NBR	Character(2)	VARCHAR2(2) NOT NULL	Transaction Number
10	IWD_DEST_NBR	Character(7)	VARCHAR2(7) NOT NULL	TG Number
11	IWD_TRANS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Type
12	IWD_CREATE_DATE	Date(10)	DATE	File Create Date
13	IWD_AWARD_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Award Year
14	IWD_REJECT_MSG	Character(49)	VARCHAR2(49) NOT NULL	Rejection Message