BSP_FLOAT_SD_EC (SQL Table)	Index Back
Bank Balance Float Bank Balance Float. Used to import float data via EDI Manager for the purpose of float analysis, a Treasury Cash Management feature for R8.

BSP_FLOAT_SD_EC

(SQL Table)

Bank Balance Float

Bank Balance Float. Used to import float data via EDI Manager for the purpose of float analysis, a Treasury Cash Management feature for R8.

Parent record: BSP_BKBAL_SD_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 ECFILEROWID Character(3) VARCHAR2(3) NOT NULL Electronic Commerce File Row ID. Used in EDI Manager. There must be one work record for every PeopleSoft Business Document file. The first field in the record is the Record_Id and the rest of the fields must match the corresponding business document, in the same order and length.

3 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)

4 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

5 ECACTIONCD Character(3) VARCHAR2(3) NOT NULL EC Action Code

6 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

7 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.

8 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

9 BSP_STMT_DT Date(10) DATE Bank Statement Date

10 STMT_BAL_FLOAT_DT Date(10) DATE Float date. Used for Cash Float Analysis, a Treasury Cash Management feature for R8.

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

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

13 LOADED_SW Character(1) VARCHAR2(1) NOT NULL An internal work field that indicates whether a given treasury transaction successfully has been imp

14 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

#	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	ECFILEROWID	Character(3)	VARCHAR2(3) NOT NULL	Electronic Commerce File Row ID. Used in EDI Manager. There must be one work record for every PeopleSoft Business Document file. The first field in the record is the Record_Id and the rest of the fields must match the corresponding business document, in the same order and length.
3	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)
4	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
5	ECACTIONCD	Character(3)	VARCHAR2(3) NOT NULL	EC Action Code
6	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
7	BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	The local branch office identifier associated with a given bank/counterparty.
8	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
9	BSP_STMT_DT	Date(10)	DATE	Bank Statement Date
10	STMT_BAL_FLOAT_DT	Date(10)	DATE	Float date. Used for Cash Float Analysis, a Treasury Cash Management feature for R8.
11	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.
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	LOADED_SW	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates whether a given treasury transaction successfully has been imp
14	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