BS_STMT_EC_S

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_CASE	Character(30)	VARCHAR2(30) NOT NULL	BTF Test Case
2	STATEMENT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Statement ID for bank statements, key on Bank Statement Header
3	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
4	RESPONSE	Character(2)	VARCHAR2(2) NOT NULL	Response Code
5	SENDER	Character(20)	VARCHAR2(20) NOT NULL	Sender will be used in bank statements
6	RECEIVER	Character(20)	VARCHAR2(20) NOT NULL	Receiver is used in bank reconciliation
7	BSP_PRCS_DT	Date(10)	DATE	Bank Statement Process Date
8	BNK_LOAD_DTTM	DateTime(26)	TIMESTAMP	The time and date a bank statement is loaded into the system.
9	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: OPR_DEF_TBL_FS.OPRID
10	FILE_CREATE_DT	Date(10)	DATE	File Creation Date
11	FILE_CREATE_TIME	Time(15)	TIMESTAMP	File Creation Time
12	FILE_ID	Character(30)	VARCHAR2(30) NOT NULL	File Identifier
13	DESCRLONG	Long Character	CLOB	Long Description
14	LOADED_SW	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates whether a given treasury transaction successfully has been imp
15	EVENT_TRACKING_ID	Number(10,0)	DECIMAL(10) NOT NULL	The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.
16	IMPORT_FILE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Import File ID