| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP38: Agreement Management |
1 | F38111 | Agreements Transaction Ledger | 61 | DZ | RECS | Reconciled (Y/N) | Character | UDC | 1 | 0 |
TOP41B: Bulk Stock Management |
2 | F41511 | Bulk Product Transaction File | 82 | PA | RECS | Reconciled (Y/N) | Character | UDC | 1 | 0 |
3 | F41515 | Multi-Meter Readings | 13 | PQ | RECS | Reconciled (Y/N) | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 41B / RP (Reconciled Flag) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | I | In Process | | N |
2 | N | Not Reconciled | | N |
3 | P | In Process - Error Condition | | N |
4 | Y | Completely Reconciled | | N |