BANK_STAT_TMP1

(SQL Table)

# 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 DRAWEE_ACCT_NUM Character(11) VARCHAR2(11) NOT NULL Drawee Account Number

3 DRAWER_REF Character(10) VARCHAR2(10) NOT NULL Drawer Reference

4 DRAFT_DUE_DT Date(10) DATE Draft Due Date

5 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.

6 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

#	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	DRAWEE_ACCT_NUM	Character(11)	VARCHAR2(11) NOT NULL	Drawee Account Number
3	DRAWER_REF	Character(10)	VARCHAR2(10) NOT NULL	Drawer Reference
4	DRAFT_DUE_DT	Date(10)	DATE	Draft Due Date
5	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.
6	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