RCN_SOURCE_NAMERCN_EVENT_SEQRCN_EVENT_VW(SQL View) |
Index Back |
|---|---|
Reconciliatiton Event viewReconciliation Event view for prompting |
| SELECT RCN_SOURCE_NAME , RCN_EVENT_SEQ , RCN_EVENT_NAME , DESCR FROM PS_RCN_EVENT_HDR |
| # | 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_NAME | Character(16) | VARCHAR2(16) NOT NULL | Reconciliation Event Name field |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |