| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 00: Foundation Environment | ||||||||||
| 1 | F0911 | Account Ledger | 95 | GL | ALTY | ID Type | String | UDC | 2 | 0 |
| 09: General Accounting | ||||||||||
| 2 | F0911P | Purge - Account Ledger | 95 | GL | ALTY | ID Type | String | UDC | 2 | 0 |
| 3 | F0911R | WF - Account Ledger Reconciliation | 53 | GL | ALTY | ID Type | String | UDC | 2 | 0 |
| 4 | F0911Z1 | Journal Entry Transactions - Batch File | 112 | VN | ALTY | ID Type | String | UDC | 2 | 0 |
| 5 | F0911Z4 | F0911 Interoperability Table | 117 | SZ | ALTY | ID Type | String | UDC | 2 | 0 |
| 6 | F09UI015 | Indexed Computations Multi-Tiered Entries | 95 | GL | ALTY | ID Type | String | UDC | 2 | 0 |
| 42: Sales Management | ||||||||||
| 7 | F42800G1 | Sales Update G Batch Detail Workfile | 89 | DG | ALTY | ID Type | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
UDC 00 / AL (Alternate Lease Number Type) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | AP | API Well Numbers | N | |
| 2 | C | Business Unit | N | |
| 3 | CC | Contract to Contract X-Ref | N | |
| 4 | CL | Contract to Lease/Unit X-Ref | N | |
| 5 | CW | Contract to Well X-Ref | N | |
| 6 | DI | Dwights Numbers for wells | N | |
| 7 | F | Purchaser`s Alt. Facility I.D. | N | |
| 8 | F1 | MMS Facility I.D. | N | |
| 9 | F2 | State Facility I.D. | N | |
| 10 | F3 | Transporter/Gatherer Facil ID | N | |
| 11 | M2 | OCS Block Number | N | |
| 12 | M3 | MMS Agreement Number | N | |
| 13 | M4 | MMS Operator Number | N | |
| 14 | O | Old To New Lease Number | N | |
| 15 | OL | Outsider`s Lease Number | ||
| 16 | P | Purchaser Lease Number | ||
| 17 | S | State Lease Number | ||
| 18 | T1 | Texas RRC District Number | ||
| 19 | T2 | Texas Oil Lease Number | ||
| 20 | T3 | Texas Gas Well Number | ||
| 21 | T4 | Texas RRC ID Number | ||
| 22 | T5 | Texas Lease Name 1 | ||
| 23 | T6 | Texas Lease Name 2 | ||
| 24 | U | Unit to Lease X-Reference | ||
| 25 | W | Well to Lease X-Reference |