RCN_CRITERIA_DF(SQL Table) |
Index Back |
|---|---|
Recon criteria for eventsReconciliation criteria for events 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_CRITERIA_ID |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | RCN_EVENT_NAME | Character(16) | VARCHAR2(16) NOT NULL | Reconciliation Event Name field |
| 6 | RCN_LOOP | Number(1,0) | SMALLINT NOT NULL | For reconciliation, this field indicates which loop that the event is executed in. |
| 7 | RCN_SOURCE_NAMED | Character(1) | VARCHAR2(1) NOT NULL |
Is the source named or mapped?
Y/N Table Edit |
| 8 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 9 | RCN_STMT_REC | Character(15) | VARCHAR2(15) NOT NULL | Reconciliation Statement Record |
| 10 | RCN_TRAN_REC | Character(15) | VARCHAR2(15) NOT NULL | Reconciliation Transaction Record |
| 11 | RCN_FLD1_SQL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
For reconciliation, this is either a transaction or a statement line or run control or a part of a sql statement.
0=Statement 1=Transaction 2=Event Record 3=Add SQL 4=Add SQL (start of SQL object) 5=Add SQL (end of SQL object) |
| 12 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |
| 13 | RCN_FIELD1_ALIAS | Character(30) | VARCHAR2(30) NOT NULL | Reconciliation field/record alias name -- user or system defined |
| 14 | RCN_OPERATOR | Character(1) | VARCHAR2(1) NOT NULL |
Arithmetic Operators for reconciliation
1=<> 2=<= 3=>= 4=IN 5=SQL <=< === >=> Default Value: = |
| 15 | RCN_FIELD2_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
For reconciliation, this is either a transaction or a statement line
0=Statement 1=Transaction 2=Constant |
| 16 | FIELDNAME2 | Character(18) | VARCHAR2(18) NOT NULL | Fieldname 2 |
| 17 | RCN_FIELD2_ALIAS | Character(30) | VARCHAR2(30) NOT NULL | Reconciliation field/record alias name -- user or system defined |
| 18 | RCN_FIELD2_CONST | Character(254) | VARCHAR2(254) NOT NULL | Reconciliation field/record alias name -- user or system defined |
| 19 | RCN_ATTR_AMT | Character(1) | VARCHAR2(1) NOT NULL |
Allow amount tolerances in performing reconciliation
Y/N Table Edit Default Value: N |
| 20 | RCN_ATTR_DT | Character(1) | VARCHAR2(1) NOT NULL |
Allow Date tolerances in performing reconciliation
Y/N Table Edit Default Value: N |
| 21 | RCN_FREE_FORM_SQL | Character(1) | VARCHAR2(1) NOT NULL |
Reconciliation flag for free form sql compare field
Y/N Table Edit Default Value: N |
| 22 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |