BSP_BKBAL_PD_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_EURO_INDEX	Character(1)	VARCHAR2(1) NOT NULL	Calculation Index for Euro for AFB statements
10	BSP_FORMAT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Original format of bank statement. 01=AFB 02=SWIFT 03=BAI 1=AFB 2=SWIFT 3=BAI BA=BAI
11	BSP_PRCS_DT	Date(10)	DATE	Bank Statement Process Date
12	BSP_STMT_DT	Date(10)	DATE	Bank Statement Date
13	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	BSP_AMT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Defines the bank statements' amount type. + for Debit, - for Credit. +=Debit -=Credit
16	BSP_CALC_MODE	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate the method of balance calculation used on the bank statement. 0=From Index 1=From File 2=Original Total
17	STMT_BAL_OPEN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The bank statement opening balance as submitted by the bank.
18	STMT_BAL_OPEN_DT	Date(10)	DATE	The bank statement opening balance date as submitted by the bank.
19	STMT_BAL_CLOSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The bank statement closing balance as submitted by the bank.
20	STMT_BAL_CLOSE_DT	Date(10)	DATE	The bank statement closing balance date as submitted by the bank.
21	STMT_BAL_FWD	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The bank statement available forward balance as submitted by the bank.
22	STMT_BAL_FWD_DT	Date(10)	DATE	The bank statement available forward balance date as submitted by the bank.
23	STMT_BAL_AVAIL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The bank statement available balance as submitted by the bank.
24	LOADED_SW	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates whether a given treasury transaction successfully has been imp