RULE_ID_RECONA=Amount
D=Date
N=None
P=Percent
Default Value: D
BANK_TOLER_DAY(SQL Table) |
Index Back |
|---|---|
Day Tolerance |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RULE_ID_RECON |
Character(20) | VARCHAR2(20) NOT NULL | Reconciliation Rules Id |
| 2 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 3 | BNK_ACTIVE_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
This field determines the type of tolerance on a transaction's amount
A=Amount D=Date N=None P=Percent Default Value: D |
| 4 | BNK_LIMIT_LOW_DAY | Number(3,0) | SMALLINT NOT NULL | Lower Day Limit |
| 5 | BNK_LIMIT_HIGH_DAY | Number(3,0) | SMALLINT NOT NULL | Upper Day Limit |
| 6 | LAST_MAINT_DTTM | DateTime(26) | TIMESTAMP | A system generated value that reflects the date and time a transaction was last modified |
| 7 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 8 | SYSTEM_MAINTAINED | Character(1) | VARCHAR2(1) NOT NULL | System Maintained |