RECON_SOURCE00=Bank Statement
01=Receivables Deposits
02=Payables
03=Treasury
04=Receivables Drafts
05=External Transactions
06=Receivables Payments
07=Direct Debits
RULE_ID_RECONBANK_RECON_MSQL(SQL Table) |
Index Back |
|---|---|
Bank Recon MatchStore matching fields for Recon Rules |
| # | 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 | MSQL_STMT | Long Character(8192) | CLOB | Matching SQL Text |