| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0911 | Account Ledger | 95 | GL | ALTY | ID Type | String | UDC | 2 | 0 |
TOP09: General Accounting |
2 | F0911P | Purge - Account Ledger | 95 | GL | ALTY | ID Type | String | UDC | 2 | 0 |
3 | F0911R | WF - Acct Ledger File for 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 |
TOP42: Sales Management |
7 | F42800G1 | Sales Update G Batch Detail Workfile | 89 | DG | ALTY | ID Type | String | UDC | 2 | 0 |
TOPD3N: dcLINK (data collection) - DSI |
8 | FD3N903 | TranPrint - Transaction By Script Variable - Table | 9 | LP | ALTY | ID Type | String | UDC | 2 | 0 |
9 | FD3N904 | TranPrint - Error By Script Variable - Table | 9 | LE | 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.
TOPUDC 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 | | |