BANK_RCN_SAGG_V(SQL View) |
Index Back |
|---|---|
Bank Recon Statement Aggregate |
| SELECT RECON_SOURCE , RULE_ID_RECON , RECNAME , RCN_FIELD_ALIAS , FIELDNAME , RCN_RECORD_TYPE FROM PS_BANK_RECON_AGG WHERE RCN_RECORD_TYPE = '0' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RECON_SOURCE |
Character(2) | VARCHAR2(2) NOT NULL |
Represents the source system table(s) for reconciling items.
00=Bank Statement 01=Receivables Deposits 02=Payables 03=Treasury 04=Receivables Drafts 05=External Transactions 06=Receivables Payments 07=Direct Debits |
| 2 | RULE_ID_RECON |
Character(20) | VARCHAR2(20) NOT NULL | Reconciliation Rules Id |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: RCN_STMT_REC_V |
| 4 | RCN_FIELD_ALIAS |
Character(30) | VARCHAR2(30) NOT NULL |
Reconciliation field/record alias name -- user or system defined
Prompt Table: RCN_FLD_ALIAS_V |
| 5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 6 | RCN_RECORD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
For reconciliation, this is either a transaction or a statement line
0=Statement 1=Transaction 2=Event Record 3=App Engine Temporary Record 4=Event Record 5=AE Temporary Table |