| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 09: General Accounting | ||||||||||
| 1 | F09610 | Electronic Bank Statement Staging Header | 27 | SG | RECCODE | Reconciliation Code | Character | UDC | 1 | 0 |
| 2 | F09611 | Electronic Bank Statement Staging Detail | 7 | BG | RECCODE | Reconciliation Code | Character | UDC | 1 | 0 |
| 3 | F09616 | Auto Bank Statement Header | 6 | GN | RECCODE | Reconciliation Code | Character | UDC | 1 | 0 |
| 4 | F09617 | Auto Bank Statement Detail | 8 | GM | RECCODE | Reconciliation Code | Character | UDC | 1 | 0 |
| 5 | F09626 | Auto Reconciliation Rules Setup | 5 | GR | RECCODE | Reconciliation Code | Character | UDC | 1 | 0 |
| 6 | F09UI618 | Auto Bank Statement Process Work Table | 32 | NB | RECCODE | Reconciliation Code | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
UDC 09 / RC (Reconciliation Codes) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | 1 | Reconciled One for One Match | 01 | N |
| 2 | A | Bank Statement - Approved | Y | |
| 3 | B | Consldtd Bank Stmnt/No GL | N | |
| 4 | C | Consldtd GL and/or Bank Stmnt | N | |
| 5 | D | Bank Statement - Processed | Y | |
| 6 | G | Consldtd GL/No Bank Stmnt | N | |
| 7 | M | Manual Reconciliation | N | |
| 8 | R | Reconciled One for One Match | 01 | Y |
| 9 | T | Difference Within Tolerance | N | |
| 10 | V | Voided Check | N |