BS_STMT_EC_C

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_CASE	Character(30)	VARCHAR2(30) NOT NULL	BTF Test Case
2	COMPARE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Compare report type 1=Delta (Results v.s Expected) 2=Expected data not in Results 3=Unexpected data in Results
3	COMPARE_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Compare data source (Actuals or Expected results). A=Actuals E=Expected
4	STATEMENT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Statement ID for bank statements, key on Bank Statement Header
5	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
6	RESPONSE	Character(2)	VARCHAR2(2) NOT NULL	Response Code
7	SENDER	Character(20)	VARCHAR2(20) NOT NULL	Sender will be used in bank statements
8	RECEIVER	Character(20)	VARCHAR2(20) NOT NULL	Receiver is used in bank reconciliation
9	BSP_PRCS_DT	Date(10)	DATE	Bank Statement Process Date
10	BNK_LOAD_DTTM	DateTime(26)	TIMESTAMP	The time and date a bank statement is loaded into the system.
11	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: OPR_DEF_TBL_FS.OPRID
12	FILE_CREATE_DT	Date(10)	DATE	File Creation Date
13	FILE_CREATE_TIME	Time(15)	TIMESTAMP	File Creation Time
14	FILE_ID	Character(30)	VARCHAR2(30) NOT NULL	File Identifier
15	DESCRLONG	Long Character	CLOB	Long Description
16	LOADED_SW	Character(1)	VARCHAR2(1) NOT NULL	An internal work field that indicates whether a given treasury transaction successfully has been imp
17	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.
18	IMPORT_FILE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Import File ID