| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPPosition Budgeting and Control |
1 | HRFPM_FPM_POS | HRFPM: FPM Documents - Items | 48 | DB_ACTION | Action to Be Performed with Commit | nvarchar | 1 | 0 | | |
TOPProduction and Revenue Accounting |
2 | OIUREP_ENTTY_LOG | Log table for master data entity changes | 13 | DB_ACTION | Type of change (Insert, Delete or Update) | nvarchar | 1 | 0 | | |
3 | OIUREP_OWNER_LOG | Log for master Data Owner Changes | 8 | DB_ACTION | Type of change (Insert, Delete or Update) | nvarchar | 1 | 0 | | |
4 | OIUREP_PRFL_LOG | Log for master data profile changes | 9 | DB_ACTION | Type of change (Insert, Delete or Update) | nvarchar | 1 | 0 | | |
5 | OIUX1_RPT_LOG | Tax reporting log table for rpt | 8 | DB_ACTION | Type of change (Insert, Delete or Update) | nvarchar | 1 | 0 | | |
6 | OIUX2_LNK_LOG | Tax Reporting log table for the link | 14 | DB_ACTION | Type of change (Insert, Delete or Update) | nvarchar | 1 | 0 | | |
7 | OIUX2_PUIDLOG | Tax Reporting PUID log | 8 | DB_ACTION | Type of change (Insert, Delete or Update) | nvarchar | 1 | 0 | | |
8 | OIUX2_RE_LOG | Tax Reporting log table for the Log | 13 | DB_ACTION | Type of change (Insert, Delete or Update) | nvarchar | 1 | 0 | | |
9 | OIUX2_RSG_LOG | Tax reporting log table for rpt | 8 | DB_ACTION | Type of change (Insert, Delete or Update) | nvarchar | 1 | 0 | | |
TOPRoyalty Reporting |
10 | OIUREP_ROY_LOG | Changes to master data for reporting | 9 | DB_ACTION | Type of change (Insert, Delete or Update) | nvarchar | 1 | 0 | | |
TOPTax Reporting |
11 | OIUX1_FLD_VALL | Log for field level data | 10 | DB_ACTION | Type of change (Insert, Delete or Update) | nvarchar | 1 | 0 | | |
12 | OIUX1_RPT_MSTRL | Log for master data changes | 9 | DB_ACTION | Type of change (Insert, Delete or Update) | nvarchar | 1 | 0 | | |
13 | OIUX2_BA_LOG | Cross ref. betwn PRA prod/purchaser no. and its tax payer | 8 | DB_ACTION | Type of change (Insert, Delete or Update) | nvarchar | 1 | 0 | | |