BNK_FLOAT_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	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
7	LOADED_SW	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates whether a given treasury transaction successfully has been imp Y/N Table Edit
8	BAL_LOADED_SW	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that designates whether a given bank balance has been loaded into the sys
9	STMT_BAL_FLOAT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bank Statement balance float. Used for Cash Float Analysis, a Treasury Cash Management feature for R8.
10	STMT_BAL_FLOAT_DT	Date(10)	DATE	Float date. Used for Cash Float Analysis, a Treasury Cash Management feature for R8.