BANK_ANS2_EC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	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)
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	PYMNT_DT	Date(10)	DATE	Payment Date
5	CURRENCY_INDEX	Character(1)	VARCHAR2(1) NOT NULL	Currency Index
6	ISSUER_BANK_ID_NUM	Character(5)	VARCHAR2(5) NOT NULL	Issuer Bank ID Number
7	ISSUER_BRANCH_ID	Character(5)	VARCHAR2(5) NOT NULL	Issuer Branch ID
8	DRAWER_ACCT_NUM	Character(11)	VARCHAR2(11) NOT NULL	Drawer Acct Num
9	DRAWER_NAME	Character(24)	VARCHAR2(24) NOT NULL	Drawer Name
10	DRAFT_DUE_DT	Date(10)	DATE	Draft Due Date
11	RECV_CHIEF_CODE	Character(5)	VARCHAR2(5) NOT NULL	Receiving Chief Code
12	RECV_BANK_ID_NUM	Character(5)	VARCHAR2(5) NOT NULL	Bank ID
13	DRAWEE_BRANCH_ID	Character(5)	VARCHAR2(5) NOT NULL	Drawee Branch ID
14	DRAWEE_ACCT_NUM	Character(11)	VARCHAR2(11) NOT NULL	Drawee Account Number
15	DRAWEE_NAME	Character(24)	VARCHAR2(24) NOT NULL	Drawee Name
16	REMIT_PERSON_REF	Character(8)	VARCHAR2(8) NOT NULL	Remit Person Reference
17	BRIEF_DESCR	Character(24)	VARCHAR2(24) NOT NULL	Brief Description
18	DRAFT_CREATE_DT	Date(10)	DATE	Draft Creation Date
19	ACCEPT_CODE	Character(1)	VARCHAR2(1) NOT NULL	Accept Code
20	DRAWER_REF	Character(10)	VARCHAR2(10) NOT NULL	Drawer Reference
21	DRAWEE_REF	Character(10)	VARCHAR2(10) NOT NULL	Drawee Reference
22	CREATE_DATE	Date(10)	DATE	Creation Date
23	REJECT_CODE	Character(2)	VARCHAR2(2) NOT NULL	Reject Code 13=Draft ID not clear enough 19=Remitted to another bank 39=Do not pay non-appv draft 70=Litigation 71=Already Paid 72=Wrong Acceptance code 73=Amount Disputed 74=Disagreement on Due date 75=Extended due date request 76=Late Claim 90=Partial payment of the drawee
24	TOTAL_NONPAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Reject Total
25	BANK_ORDER_NUM	Character(8)	VARCHAR2(8) NOT NULL	Bank Order Number
26	DRAFT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a draft payment. This field is maintained by the Draft Creation process.