| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPJoint Venture und Production Sharing Accounting |
1 | T8J8D | Project Level Stepped Rate Parameters | 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
2 | T8J8F | Drilling Statistical Ratio Assignment | 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
3 | T8J8H | Producing Statistical Ratio Assignment | 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
4 | T8J8I | Assigned Producing Statistical Ratio Thresholds | 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
5 | T8J8J | Parent Company Overheads | 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
6 | T8J9A | Equity Group - JOA level | 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
7 | T8J9B | Equity Group Description - JOA level | 4 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
8 | T8J9C | Joint operating agreement partner shares | 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
9 | T8JLP | Penalty Category Recovery Percentages | 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
10 | T8JLP2 | Penalty Category Recovery Percentages* | 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
11 | T8JOH_JOAS | List of JOA level parameters in Overhead Organizer | 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
12 | T8JOH_OHTEXT | Text for each overhead key in different languages | 4 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
13 | T8JOH_OH_DETAILS | Overhead general detail | 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
14 | T8JOH_OVERHEADS | List of all overheads in each company | 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
15 | T8JOH_RUNS | List of run information for each <company, joa> | 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
16 | T8JOH_VENTURES | List of Venture Level parameters in Overhead Organizer | 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
17 | T8JOVRP | Overhead burden rate percentages | 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
18 | T8JU | Joint Operating Agreement | 3 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
19 | T8JUT | Joint Operating Agreement Description | 4 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |
20 | T8JV | Joint Venture | 18 | JOA | Joint Operating Agreement | nvarchar | 6 | 0 | | |