| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction and Revenue Accounting |
1 | OIUP_SB_ENTMP | MP level owner entitlements (PDM Shadow) | 15 | MK_REP_NO | Marketing Representative No | nvarchar | 10 | 0 | | |
2 | OIUP_SB_ENTWC | WC level owner entitlements (PDM Shadow) | 16 | MK_REP_NO | Marketing Representative No | nvarchar | 10 | 0 | | |
3 | OIU_SB_AVD | Availability Detail | 9 | MK_REP_NO | Marketing Representative No | nvarchar | 10 | 0 | | |
4 | OIU_SB_ENTMP | MP level owner entitlements | 14 | MK_REP_NO | Marketing Representative No | nvarchar | 10 | 0 | | |
5 | OIU_SB_ENTMP_T | MP level owner entitlements | 15 | MK_REP_NO | Marketing Representative No | nvarchar | 10 | 0 | | |
6 | OIU_SB_ENTWC | WC level owner entitlements | 15 | MK_REP_NO | Marketing Representative No | nvarchar | 10 | 0 | | |
7 | OIU_SB_ENTWC_T | WC level owner entitlements | 16 | MK_REP_NO | Marketing Representative No | nvarchar | 10 | 0 | | |
8 | OIU_SB_MGDD | Marketing Group Determination Detail | 8 | MK_REP_NO | Marketing Representative No | nvarchar | 10 | 0 | | |
9 | OIU_SB_MGKW | Marketing Group Keep Whole | 3 | MK_REP_NO | Marketing Representative No | nvarchar | 10 | 0 | | |
10 | OIU_SB_MGOPMP | Marketing Group Owner Percent MP | 13 | MK_REP_NO | Marketing Representative No | nvarchar | 10 | 0 | | |
11 | OIU_SB_MGOPMP_T | Marketing Group Owner Percent MP | 13 | MK_REP_NO | Marketing Representative No | nvarchar | 10 | 0 | | |
12 | OIU_SB_MGOPWC | Marketing Group Owner Percent WC | 14 | MK_REP_NO | Marketing Representative No | nvarchar | 10 | 0 | | |
13 | OIU_SB_MGOPWC_T | Marketing Group Owner Percent WC | 14 | MK_REP_NO | Marketing Representative No | nvarchar | 10 | 0 | | |
14 | OIU_SB_NIMB | Marketing representative imbalance volumes | 6 | MK_REP_NO | Marketing Representative No | nvarchar | 10 | 0 | | |
15 | OIU_SB_OAD | Owner Availability Detail | 7 | MK_REP_NO | Marketing Representative No | nvarchar | 10 | 0 | | |
16 | OIU_SB_SRC | Allocation Percentage | 5 | MK_REP_NO | Marketing Representative No | nvarchar | 10 | 0 | | |