RECON_RULE_SRCH(SQL View) |
Index Back |
|---|---|
Recon Rule Search |
| SELECT RECON_SOURCE , S.XLATLONGNAME , RULE_ID_RECON , RULE_NAME_ALIAS , RCN_RULE_STATUS , RECON_RULE_TYPE , T.XLATLONGNAME , DESCR100 , LAST_MAINT_DTTM , LAST_MAINT_OPRID FROM PS_BANK_RECON_RULE LEFT OUTER JOIN PSXLATITEM S ON S.FIELDNAME = 'RECON_SOURCE' AND S.FIELDVALUE = RECON_SOURCE LEFT OUTER JOIN PSXLATITEM T ON T.FIELDNAME = 'RECON_RULE_TYPE' AND T.FIELDVALUE = RECON_RULE_TYPE |
| # | 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 | DESCR3 | Character(30) | VARCHAR2(30) NOT NULL | Reconciliation Source |
| 3 | RULE_ID_RECON |
Character(20) | VARCHAR2(20) NOT NULL | Reconciliation Rules Id |
| 4 | RULE_NAME_ALIAS | Character(30) | VARCHAR2(30) NOT NULL | Reconciliation Rule Alias |
| 5 | RCN_RULE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Recon Rule Status - Active/Inactive
A=Active I=Inactive Default Value: A |
| 6 | RECON_RULE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Reconciliation Rule Type
1=One to One 2=One to Many 3=Many to One 4=Many to Many Default Value: 1 |
| 7 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 9 | LAST_MAINT_DTTM | DateTime(26) | TIMESTAMP |
A system generated value that reflects the date and time a transaction was last modified
Default Value: %Datetime |
| 10 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |