BANK_STATIN2_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	BANK_OPER_NUM	Character(2)	VARCHAR2(2) NOT NULL	Operation Number
5	PYMNT_DT	Date(10)	DATE	Payment Date
6	CURRENCY_INDEX	Character(1)	VARCHAR2(1) NOT NULL	Currency Index
7	ISSUER_BANK_ID_NUM	Character(5)	VARCHAR2(5) NOT NULL	Issuer Bank ID Number
8	ISSUER_BRANCH_ID	Character(5)	VARCHAR2(5) NOT NULL	Issuer Branch ID
9	DRAWER_ACCT_NUM	Character(11)	VARCHAR2(11) NOT NULL	Drawer Acct Num
10	DRAWER_NAME	Character(24)	VARCHAR2(24) NOT NULL	Drawer Name
11	DRAFT_DUE_DT	Date(10)	DATE	Draft Due Date
12	RECV_CHIEF_CODE	Character(5)	VARCHAR2(5) NOT NULL	Receiving Chief Code
13	RECV_BANK_ID_NUM	Character(5)	VARCHAR2(5) NOT NULL	Bank ID
14	DRAWEE_BRANCH_ID	Character(5)	VARCHAR2(5) NOT NULL	Drawee Branch ID
15	DRAWEE_ACCT_NUM	Character(11)	VARCHAR2(11) NOT NULL	Drawee Account Number
16	DRAWEE_NAME	Character(24)	VARCHAR2(24) NOT NULL	Drawee Name
17	REMIT_PERSON_REF	Character(8)	VARCHAR2(8) NOT NULL	Remit Person Reference
18	BRIEF_DESCR	Character(24)	VARCHAR2(24) NOT NULL	Brief Description
19	DRAFT_CREATE_DT	Date(10)	DATE	Draft Creation Date
20	ACCEPT_CODE	Character(1)	VARCHAR2(1) NOT NULL	Accept Code
21	DRAWER_REF	Character(10)	VARCHAR2(10) NOT NULL	Drawer Reference
22	DRAWEE_REF	Character(10)	VARCHAR2(10) NOT NULL	Drawee Reference
23	BANK_ORDER_NUM	Character(8)	VARCHAR2(8) NOT NULL	Bank Order Number
24	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.
25	BANK_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Sequence Number
26	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
27	NEW_AMT_REM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	New Payment Amt Remaing