RECNAMERCN_FIELD_ALIASRCN_UPDSTAT_VW(SQL View) |
Index Back |
|---|---|
Recon view between Stat/FieldsReconciliation view between rcn_event_upd and rcn_field_tbl to link alias with fieldname |
| SELECT A.RECNAME , A.RCN_FIELD_ALIAS , A.RCN_SOURCE_NAME , A.RCN_EVENT_SEQ , A.RCN_EVENT_NAME , A.RCN_LOOP , A.RCN_EVENT_ID , A.RCN_SOURCE_NAMED , B.FIELDNAME , A.RCN_UPDATE_VALUE FROM PS_RCN_EVENT_UPD A , PS_RCN_FIELD_TBL B WHERE A.RECNAME = B.RECNAME AND A.RCN_FIELD_ALIAS = B.RCN_FIELD_ALIAS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 2 | RCN_FIELD_ALIAS |
Character(30) | VARCHAR2(30) NOT NULL | Reconciliation field/record alias name -- user or system defined |
| 3 | RCN_SOURCE_NAME | Character(20) | VARCHAR2(20) NOT NULL | This field contains the reconciliation source that reconcile with a bank statement line |
| 4 | RCN_EVENT_SEQ | Number(4,0) | SMALLINT NOT NULL | Event Sequence Number |
| 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_EVENT_ID | Number(3,0) | SMALLINT NOT NULL | Reconciliation event id number |
| 8 | RCN_SOURCE_NAMED | Character(1) | VARCHAR2(1) NOT NULL | Is the source named or mapped? |
| 9 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 10 | RCN_UPDATE_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Update value for reconciliation |