RCN_EVENT_TBL (SQL Table)	Index Back
Reconciliatiton Event table Reconciliation Event table

RCN_EVENT_TBL

(SQL Table)

Reconciliatiton Event table

Reconciliation Event table

# 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_EVENT_NAME Character(16) VARCHAR2(16) NOT NULL Reconciliation Event Name field
Default Value: RCN_EVENT_HDR.RCN_EVENT_NAME
Prompt Table: RCN_EVENT_VW

5 RCN_LOOP Number(1,0) SMALLINT NOT NULL For reconciliation, this field indicates which loop that the event is executed in.

6 RCN_SOURCE_NAMED Character(1) VARCHAR2(1) NOT NULL Is the source named or mapped?
Y/N Table Edit

7 RCN_STATUS Character(4) VARCHAR2(4) NOT NULL Reconciliation Status field
Prompt Table: RCN_STATUS_TBL

8 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

9 RCN_EVENT_ACT Character(3) VARCHAR2(3) NOT NULL Event Action for reconciliation
DEL=Delete
INS=Insert
TRC=Truncate
UPD=Update

10 RCN_EVENT_TBL Character(15) VARCHAR2(15) NOT NULL Event Record for Reconciliation
Prompt Table: RCN_RECORD_TBL

11 RCN_CONDITION_FLAG Character(1) VARCHAR2(1) NOT NULL Conditional or Unconditional
N=Unconditional
Y=Conditional
Default Value: N

12 RCN_OPTION_CODE Character(5) VARCHAR2(5) NOT NULL Option Code
Prompt Table: RCN_USR_OPTIONS

13 RCN_ATTR_AMT Character(1) VARCHAR2(1) NOT NULL Allow amount tolerances in performing reconciliation
Y/N Table Edit
Default Value: N

14 RCN_ATTR_DT Character(1) VARCHAR2(1) NOT NULL Allow Date tolerances in performing reconciliation
Y/N Table Edit
Default Value: N

15 RCN_ATTR_COMPARE Character(1) VARCHAR2(1) NOT NULL Compare transactions and statement lines in reconciliation
0=One transaction/one line
1=Many transactions/one line
2=Many transactions/many lines
3=One transaction/many lines
Default Value: 0

16 DESCRLONG Long Character CLOB Long Description

#	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_EVENT_NAME	Character(16)	VARCHAR2(16) NOT NULL	Reconciliation Event Name field Default Value: RCN_EVENT_HDR.RCN_EVENT_NAME Prompt Table: RCN_EVENT_VW
5	RCN_LOOP	Number(1,0)	SMALLINT NOT NULL	For reconciliation, this field indicates which loop that the event is executed in.
6	RCN_SOURCE_NAMED	Character(1)	VARCHAR2(1) NOT NULL	Is the source named or mapped? Y/N Table Edit
7	RCN_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Reconciliation Status field Prompt Table: RCN_STATUS_TBL
8	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
9	RCN_EVENT_ACT	Character(3)	VARCHAR2(3) NOT NULL	Event Action for reconciliation DEL=Delete INS=Insert TRC=Truncate UPD=Update
10	RCN_EVENT_TBL	Character(15)	VARCHAR2(15) NOT NULL	Event Record for Reconciliation Prompt Table: RCN_RECORD_TBL
11	RCN_CONDITION_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Conditional or Unconditional N=Unconditional Y=Conditional Default Value: N
12	RCN_OPTION_CODE	Character(5)	VARCHAR2(5) NOT NULL	Option Code Prompt Table: RCN_USR_OPTIONS
13	RCN_ATTR_AMT	Character(1)	VARCHAR2(1) NOT NULL	Allow amount tolerances in performing reconciliation Y/N Table Edit Default Value: N
14	RCN_ATTR_DT	Character(1)	VARCHAR2(1) NOT NULL	Allow Date tolerances in performing reconciliation Y/N Table Edit Default Value: N
15	RCN_ATTR_COMPARE	Character(1)	VARCHAR2(1) NOT NULL	Compare transactions and statement lines in reconciliation 0=One transaction/one line 1=Many transactions/one line 2=Many transactions/many lines 3=One transaction/many lines Default Value: 0
16	DESCRLONG	Long Character	CLOB	Long Description