| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP09: General Accounting |
| 1 | F09617 | Auto Bank Statement Detail | 44 | GM | REASCODE | Reason Code | String | UDC | 3 | 0 |
| 2 | F09UI618 | Auto Bank Statement Process Work Table | 33 | NB | REASCODE | Reason Code | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 09 / UR (Unreconciled Reason Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | ANC | Auto Batch Rec Not Created | 20 | Y |
| 2 | ANE | Amounts Not Equal | 30 | Y |
| 3 | CLD | Cleared Date Prior To GL Date | 40 | Y |
| 4 | CNV | Customer/Supplier Not Valid | 50 | Y |
| 5 | DPN | Draft Paid Not Found In F0411 | 120 | Y |
| 6 | IAC | Invalid Bank Account | 60 | Y |
| 7 | IGO | Invalid G/L Offset Account | 160 | Y |
| 8 | IVA | Invalid Variance Account | 150 | Y |
| 9 | JE | JE Creation Not Successful | 70 | Y |
| 10 | NMJ | No Matching JE In G/L | 105 | Y |
| 11 | NMP | No Matching Payment In G/L | 90 | Y |
| 12 | NMR | No Matching Receipt In G/L | 100 | Y |
| 13 | OEN | Offsetting Entries Not Created | 140 | Y |
| 14 | PEC | Posted Edit Code Invalid | 110 | Y |
| 15 | VNT | Variance Not Within Tolerance | 130 | Y |
