| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction and Revenue Accounting |
1 | OIUREP_TAXBACKUP | Backup tax table for old tax reporting SOL | 20 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
2 | OIUREP_TIKBACKUP | Backup tik table for old tax reporting SOL | 20 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
3 | OIU_CM_PPARSN | Prior Period Adjustments - TBLCM028 | 2 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
4 | OIU_CM_PPARSN_TX | Prior Period Adjustment Reason Codes - TBLCM028 - TEXT | 3 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
5 | OIU_RV_RVT | Rejected Valuation Transactions | 17 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
6 | OIU_RV_VLRPT | Valuation Reporting | 14 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
7 | OIU_RV_VLRVS | Valuation Reversal Notificaton | 13 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
8 | OIU_RV_VLTXNS | Valuation Transactions | 21 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
9 | OIU_RV_VPPN | Valuation Prior Period Notification | 12 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
10 | OIU_RV_VPPNM | Manually Created Valuation Prior Period Notifications | 12 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
11 | OIU_RV_VPPNU | Valuation Prior Period Notification | 12 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
TOPRevenue |
12 | OIURV03_DTL_BK | Valuation Transactions Level 1 - Vltxns | 21 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
13 | OIURV03_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 34 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
TOPTax Reporting |
14 | OIUX1_ADJ_TAXHC | Tax adjustments header for reporting | 22 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
15 | OIUX1_TRN_TAXHC | Tax transaction header for reporting | 19 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
16 | OIUX1_TRN_TAXHL | Tax transaction header for reporting | 19 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
TOPValuation |
17 | OIURV_DOC_DTL_BK | Valuation Transactions Level 1 - Vltxns | 21 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
18 | OIURV_DOC_DTL_RV | Valuation Reversal Notificaton | 16 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
19 | OIURV_DOC_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 34 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
20 | OIURV_SSTD | Settlement statement detail | 12 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
21 | OIUVL_PPN_REJSEL | PPN - Reject Selection | 4 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
22 | OIUVL_SCAUDIT | Settlement statement batch | 81 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |
23 | OIUVL_SEV | Severance tax | 13 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | | |