| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPPerformance Assessment Workbench |
1 | SLS_PRES | PAW - Person Results Structure | 28 | PUID | PAW - Internal Performance Unit Identificator | nvarchar | 8 | 0 | | |
2 | SLS_PU | PAW - Performance Unit | 2 | PUID | PAW identifier | nvarchar | 8 | 0 | | |
3 | SLS_PUTEST | PAW - Performance Unit of a test | 3 | PUID | PAW - Internal Performance Unit Identificator | nvarchar | 8 | 0 | | |
4 | SLS_RTEST | PAW - Participant's Aggregated Test Results | 6 | PUID | PAW identifier | nvarchar | 8 | 0 | | |
5 | SLS_TSTRU | PAW - Test Structure | 4 | PUID | PAW identifier | nvarchar | 8 | 0 | | |
6 | SLS_YTEST | PAW - Participant's Aggregated Test Results | 6 | PUID | PAW identifier | nvarchar | 8 | 0 | | |
TOPProduction and Revenue Accounting |
7 | OIUX1_ARCH_MKTH | Reporting history for marketing costs for reporting | 7 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
8 | OIUX1_ARCH_TAXH | Tax transaction header for reporting | 7 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
9 | OIUX1_ARCH_VOLH | Reported Volume Data by PUID | 7 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
10 | OIUX1_ARCH_XMPH | Reporting history for tax exemptions | 7 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
11 | OIUX2_LNK_LOG | Tax Reporting log table for the link | 11 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
12 | OIUX2_PUIDLOG | Tax Reporting PUID log | 5 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
13 | OIUX2_PUID_MKTH | Reporting history for marketing costs for reporting | 7 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
14 | OIUX2_PUID_TAXH | Tax transaction header for reporting | 7 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
15 | OIUX2_PUID_XMPH | Reporting history for tax exemptions | 7 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
TOPTax Reporting |
16 | OIUX1_LNK_REPUB | PUID and reporting entities link | 11 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
17 | OIUX1_PRD_UIDB | Base table for Production Units/Leases | 5 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
18 | OIUX1_PRD_UNITTX | Text table for Production Units/Leases | 4 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
19 | OIUX1_PROD_UNIT | Production Units/Leases | 3 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
20 | OIUX1_PUID_MKTH | Reporting history for marketing costs for reporting | 7 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
21 | OIUX1_PUID_TAXH | Tax transaction header for reporting | 7 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
22 | OIUX1_PUID_VOLH | Reported Volume Data by PUID | 7 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
23 | OIUX1_PUID_XMPH | Reporting history for tax exemptions | 7 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |
24 | OIUX2_PUID_VOLH | Reported Volume Data by PUID | 7 | PUID | Production Unit ID for tax reporting | nvarchar | 20 | 0 | | |