| # |
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
Default Value: 1
|
| 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 |
RCN_STMT_REC |
Character(15) |
VARCHAR2(15) NOT NULL |
Reconciliation Statement Record
Default Value: RCN_WRK.RCN_STMT_REC
|
| 9 |
RCN_TRAN_REC |
Character(15) |
VARCHAR2(15) NOT NULL |
Reconciliation Transaction Record
Default Value: RCN_WRK.RCN_EVENT_TBL
|
| 10 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 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 |
RCN_FIELD1_ALIAS |
Character(30) |
VARCHAR2(30) NOT NULL |
Reconciliation field/record alias name -- user or system defined
Prompt Table:
%EDITTABLE
|
| 13 |
FIELDNAME1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name 1
|
| 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 |
RCN_FIELD2_ALIAS |
Character(30) |
VARCHAR2(30) NOT NULL |
Reconciliation field/record alias name -- user or system defined
Prompt Table:
%EDITTABLE2
|
| 17 |
RCN_FIELD2_CONST |
Character(254) |
VARCHAR2(254) NOT NULL |
Reconciliation field/record alias name -- user or system defined
|
| 18 |
FIELDNAME2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname 2
|
| 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
|
| 23 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|