| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPRevenue |
1 | OIUH_RV_APSL | Journal Entry Accounts Payable Subledger Table | 16 | SL_GR_OTH_MK_AM | Local amount | decimal | 11 | 2 | | |
2 | OIUH_RV_APSL_H | Oil and Gas appl table | 16 | SL_GR_OTH_MK_AM | Local amount | decimal | 11 | 2 | | |
3 | OIUH_RV_EXSL | Journal Entry Expense Subledger Table | 22 | SL_GR_OTH_MK_AM | Local amount | decimal | 11 | 2 | | |
4 | OIUH_RV_EXSL_H | Oil and Gas appl table | 22 | SL_GR_OTH_MK_AM | Local amount | decimal | 11 | 2 | | |
5 | OIUH_RV_INSL | Journal Entry Income Subledger Table | 31 | SL_GR_OTH_MK_AM | Local amount | decimal | 11 | 2 | | |
6 | OIUH_RV_INSL_H | Oil and Gas appl table | 31 | SL_GR_OTH_MK_AM | Local amount | decimal | 11 | 2 | | |
7 | OIUH_RV_LSSL | Journal Entry Legal Suspense Subledger Table | 37 | SL_GR_OTH_MK_AM | Local amount | decimal | 11 | 2 | | |
8 | OIUH_RV_LSSL_H | Oil and Gas appl table | 37 | SL_GR_OTH_MK_AM | Local amount | decimal | 11 | 2 | | |
9 | OIUH_RV_MSSL | Journal Entry Miscellaneous Subledger Table | 46 | SL_GR_OTH_MK_AM | Local amount | decimal | 11 | 2 | | |
10 | OIUH_RV_MSSL_H | Oil and Gas appl table | 46 | SL_GR_OTH_MK_AM | Local amount | decimal | 11 | 2 | | |
11 | OIUH_RV_OPSL | Journal Entry Owner Payable Subledger Table | 37 | SL_GR_OTH_MK_AM | Local amount | decimal | 11 | 2 | | |
12 | OIUH_RV_OPSL_H | Oil and Gas OPSL History Table | 37 | SL_GR_OTH_MK_AM | Local amount | decimal | 11 | 2 | | |
13 | OIUH_RV_STSL | Journal Entry Statistical Subledger Table | 34 | SL_GR_OTH_MK_AM | Local amount | decimal | 11 | 2 | | |
14 | OIUH_RV_STSL_H | Oil and Gas appl table | 34 | SL_GR_OTH_MK_AM | Local amount | decimal | 11 | 2 | | |
TOPRoyalty Reporting |
15 | OIUH_TEMP_OPSL | Journal Entry Owner Payable Subledger Table | 37 | SL_GR_OTH_MK_AM | Local amount | decimal | 11 | 2 | | |
16 | OIUREP_XTRCT_ROY | Extract Royaty Data for the current reporting period | 53 | SL_GR_OTH_MK_AM | Local amount | decimal | 11 | 2 | | |