RCN_EVENT_UPD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RCN_SOURCE_NAME	Character(20)	VARCHAR2(20) NOT NULL	This field contains the reconciliation source that reconcile with a bank statement line
2	RCN_EVENT_SEQ	Number(4,0)	SMALLINT NOT NULL	Event Sequence Number
3	RCN_EVENT_ID	Number(3,0)	SMALLINT NOT NULL	Reconciliation event id number
4	RCN_FIELD_ALIAS	Character(30)	VARCHAR2(30) NOT NULL	Reconciliation field/record alias name -- user or system defined Prompt Table: RCN_FLD_ALIAS_V
5	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Default Value: RCN_EVENT_TBL.RCN_EVENT_TBL
6	SQL_UPDATE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Determine type of UPDATE to generate 1=Constant 2=Bind Variable 3=SQL Object 4=SQL Text Default Value: 1
7	RCN_UPDATE_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Update value for reconciliation Prompt Table: %EDITTABLE
8	SQLID	Character(30)	VARCHAR2(30) NOT NULL	SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE SQLTYPE = 0: SQL object name SQLTYPE = 1: Application Engine Step Identifier SQLTYPE = 2: RECNAME SQLTYPE = 6: Application Engine XSLT (XML definition) Prompt Table: %EDITTABLE
9	SQL_STMT_254	Character(254)	VARCHAR2(254) NOT NULL	An internal work field that contains SQL text that is to be utilized in treasury application p
10	SQL_STATEMENT	Long Character	CLOB	SQL Statement
11	RCN_EVENT_NAME	Character(16)	VARCHAR2(16) NOT NULL	Reconciliation Event Name field Prompt Table: RCN_EVENT_VW
12	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
13	RCN_LOOP	Number(1,0)	SMALLINT NOT NULL	For reconciliation, this field indicates which loop that the event is executed in.
14	RCN_SOURCE_NAMED	Character(1)	VARCHAR2(1) NOT NULL	Is the source named or mapped? Y/N Table Edit