BANK_ANS1_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	BANK_REPORT_NUM	Character(8)	VARCHAR2(8) NOT NULL	Bank Report Number
6	CURRENCY_INDEX	Character(1)	VARCHAR2(1) NOT NULL	Currency Index
7	BANK_VALUE_DT	Date(10)	DATE	Bank Value Date
8	CREATE_DATE	Date(10)	DATE	Creation Date
9	SIREN_NUM	Character(14)	VARCHAR2(14) NOT NULL	Siren Number of the drawee
10	RECV_CHIEF_CODE	Character(5)	VARCHAR2(5) NOT NULL	Receiving Chief Code
11	RECV_BANK_ID_NUM	Character(5)	VARCHAR2(5) NOT NULL	Bank ID
12	DRAWEE_BRANCH_ID	Character(5)	VARCHAR2(5) NOT NULL	Drawee Branch ID
13	DRAWEE_ACCT_NUM	Character(11)	VARCHAR2(11) NOT NULL	Drawee Account Number
14	DRAWEE_NAME	Character(24)	VARCHAR2(24) NOT NULL	Drawee Name
15	PROC_CENTER	Character(6)	VARCHAR2(6) NOT NULL	Processing Center
16	TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount