| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPOwnership |
1 | OIUOW_PP | Ownership Production Payment | 3 | COMB_PD_CD | Combined product code | nvarchar | 3 | 0 | | |
2 | OIUOW_PUC_WK | Property Unit Use Control - work table | 4 | COMB_PD_CD | Combined product code | nvarchar | 3 | 0 | | |
3 | OIUOW_UNIT_JV | Unit Venture Information | 4 | COMB_PD_CD | Combined product code | nvarchar | 3 | 0 | | |
4 | OIUOW_UNIT_JV_WK | Unit Venture Information Work table | 4 | COMB_PD_CD | Combined product code | nvarchar | 3 | 0 | | |
TOPProduction and Revenue Accounting |
5 | OIUCM_COMB_PD_CD | Combined Product Code | 2 | COMB_PD_CD | Combined product code | nvarchar | 3 | 0 | | |
6 | OIUCM_COMB_PD_TX | Combined Product Code Text | 3 | COMB_PD_CD | Combined product code | nvarchar | 3 | 0 | | |
7 | OIU_CM_CPDC | Combined Product Code/Major Product Code (TBLRV031) | 2 | COMB_PD_CD | Combined product code | nvarchar | 3 | 0 | | |
8 | OIU_CM_CPDC_TX | Combined Product Code/Major Product Code Text (TBLRV031) | 3 | COMB_PD_CD | Combined product code | nvarchar | 3 | 0 | | |
9 | OIU_DO_DI | Base Venture/DOI Relationship | 7 | COMB_PD_CD | Combined product code | nvarchar | 3 | 0 | | |
10 | OIU_DO_DPIC | DOI Product Interest Control | 5 | COMB_PD_CD | Combined product code | nvarchar | 3 | 0 | | |
11 | OIU_DO_DPIC_WK | DOI Product Interest Control | 5 | COMB_PD_CD | Combined product code | nvarchar | 3 | 0 | | |
12 | OIU_DO_PUC | Property Unit Use Control | 4 | COMB_PD_CD | Combined product code | nvarchar | 3 | 0 | | |