BANK_ANS3_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	BANK_VALUE_DT	Date(10)	DATE	Bank Value Date
7	CREATE_DATE	Date(10)	DATE	Creation Date
8	RECV_CHIEF_CODE	Character(5)	VARCHAR2(5) NOT NULL	Receiving Chief Code
9	RECV_BANK_ID_NUM	Character(5)	VARCHAR2(5) NOT NULL	Bank ID
10	DRAWEE_BRANCH_ID	Character(5)	VARCHAR2(5) NOT NULL	Drawee Branch ID
11	DRAWEE_ACCT_NUM	Character(11)	VARCHAR2(11) NOT NULL	Drawee Account Number
12	DRAWEE_NAME	Character(24)	VARCHAR2(24) NOT NULL	Drawee Name
13	PROC_CENTER	Character(6)	VARCHAR2(6) NOT NULL	Processing Center
14	TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount
15	TOTAL_NONPAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Reject Total
16	TOTAL_PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Paid Amount
17	TOTAL_AMT_APPLIED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total applied