BNK_GRP_HDR_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	ECACTIONCD	Character(3)	VARCHAR2(3) NOT NULL	EC Action Code
5	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
6	ASOFDATE	Date(10)	DATE	As of Date
7	ASOFTIME	Time(15)	TIMESTAMP	As of Time
8	RECEIVER	Character(20)	VARCHAR2(20) NOT NULL	Receiver is used in bank reconciliation
9	TRANSACTION_REF	Character(16)	VARCHAR2(16) NOT NULL	Represents a deal transaction reference or identifier.
10	STMT_NUMBER	Number(5,0)	INTEGER NOT NULL	A sequential number that indicates the processing queue number for a given bank statement and given ban
11	PAGE_NUMBER	Number(3,0)	SMALLINT NOT NULL	Page Number is used in bank reconciliation