| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP09: General Accounting |
| 1 | F0917 | Bank Statement Detail | 9 | GD | STRN | Bank Statement Transaction Code | String | UDC | 3 | 0 |
| 2 | F09617 | Auto Bank Statement Detail | 10 | GM | STRN | Bank Statement Transaction Code | String | UDC | 3 | 0 |
| 3 | F09621 | Bank Account Cross Reference | 4 | GS | STRN | Bank Statement Transaction Code | String | UDC | 3 | 0 |
| 4 | F09622 | Transaction Type Cross Reference | 2 | TT | STRN | Bank Statement Transaction Code | String | UDC | 3 | 0 |
| 5 | F09626 | Auto Reconciliation Rules Setup | 2 | GR | STRN | Bank Statement Transaction Code | String | UDC | 3 | 0 |
| 6 | F09UI618 | Auto Bank Statement Process Work Table | 5 | NB | STRN | Bank Statement Transaction 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 / BJ (Bank Statement Transactions) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | BK | Self Reconciling | | N |
| 2 | CK | Payment Clear | | N |
| 3 | CR | Cash Receipt Clear | | N |
| 4 | CRE | Cash Receipt - Batch | | N |
| 5 | CRI | Cash Receipt - Interactive | | N |
| 6 | DP | Draft Paid to Supplier | | N |
| 7 | DR | Draft Collected from Customer | | N |
| 8 | JE | Journal Entry | | N |
| 9 | PWM | Manual Payments w/ Match | | N |
| 10 | PWO | Manual Payments w/o Match | | N |
