| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIUX8Y_NM_MASTER | Tax 2.0 - NM - Master Data PPN | 12 | PUN | Tax 2.0 - NM - PUN | nvarchar | 7 | 0 | | |
2 | OIUX8_NM_ASUE_DT | Tax 2.0 NM - Auto Suspend Exception Detail | 9 | PUN | Tax 2.0 - NM - PUN | nvarchar | 7 | 0 | | |
3 | OIUX8_NM_ASU_DT | Tax 2.0 - NM - Auto Suspend Detail | 9 | PUN | Tax 2.0 - NM - PUN | nvarchar | 7 | 0 | | |
4 | OIUX8_NM_JC_MST | Tax 2.0 - NM - Jicarilla Credit Master | 2 | PUN | Tax 2.0 - NM - PUN | nvarchar | 7 | 0 | | |
5 | OIUX8_NM_MASTER | Tax 2.0 - NM - Master Data | 11 | PUN | Tax 2.0 - NM - PUN | nvarchar | 7 | 0 | | |
6 | OIUX8_NM_OOSHST | Tax 2.0 - NM - Out-Of-Statute Transaction History | 56 | PUN | Tax 2.0 - NM - PUN | nvarchar | 7 | 0 | | |
7 | OIUX8_NM_OOSTXN | Tax 2.0 - NM - Out-Of-Statute Transactions | 56 | PUN | Tax 2.0 - NM - PUN | nvarchar | 7 | 0 | | |
8 | OIUX8_NM_PRDT | Tax 2.0 - NM - PRA Detail Transactions | 58 | PUN | Tax 2.0 - NM - PUN | nvarchar | 7 | 0 | | |
9 | OIUX8_NM_RPDT | Tax 2.0 - NM - Report Detail | 6 | PUN | Tax 2.0 - NM - PUN | nvarchar | 7 | 0 | | |
10 | OIUX8_NM_RPDT_H | Tax 2.0 - NM Tax Report Detail - State History | 6 | PUN | Tax 2.0 - NM - PUN | nvarchar | 7 | 0 | | |
11 | OIUX8_NM_SOLEDT | Tax 2.0 - NM - Statute of Limitation Exception Detail | 3 | PUN | Tax 2.0 - NM - PUN | nvarchar | 7 | 0 | | |
12 | OIUX8_NM_TAXHST | Tax 2.0 - NM - Tax Transaction History | 56 | PUN | Tax 2.0 - NM - PUN | nvarchar | 7 | 0 | | |
13 | OIUX8_NM_TAXSTG | Tax 2.0 - NM - Tax Transactions (Staging) | 56 | PUN | Tax 2.0 - NM - PUN | nvarchar | 7 | 0 | | |
14 | OIUX8_NM_TAXTXN | Tax 2.0 - NM - Tax Transactions | 56 | PUN | Tax 2.0 - NM - PUN | nvarchar | 7 | 0 | | |
TOPTax Reporting |
15 | OIUX5Y_OK_MASTER | Tax 2.0 - Oklahoma Master Data PPN | 11 | PUN | Tax 2.0 - Oklahoma Production Unit Number | nvarchar | 11 | 0 | | |
16 | OIUX5_OK_ASU_DT | Tax 2.0 - Oklahoma Auto Suspend Detail | 9 | PUN | Tax 2.0 - Oklahoma Production Unit Number | nvarchar | 11 | 0 | | |
17 | OIUX5_OK_CONFL | Tax 2.0 - Oklahoma Exempt Decimal Conflict | 8 | PUN | Tax 2.0 - Oklahoma Production Unit Number | nvarchar | 11 | 0 | | |
18 | OIUX5_OK_MASTER | Tax 2.0 - Oklahoma Master Data | 10 | PUN | Tax 2.0 - Oklahoma Production Unit Number | nvarchar | 11 | 0 | | |
19 | OIUX5_OK_OOSHST | Tax 2.0 - Oklahoma Out Of Statute Transactions History | 54 | PUN | Tax 2.0 - Oklahoma Production Unit Number | nvarchar | 11 | 0 | | |
20 | OIUX5_OK_OOSTXN | Tax 2.0 - Oklahoma Out Of Statute Transactions | 54 | PUN | Tax 2.0 - Oklahoma Production Unit Number | nvarchar | 11 | 0 | | |
21 | OIUX5_OK_PRDT | Tax 2.0 - Oklahoma PRA Detail Tax Transactions | 56 | PUN | Tax 2.0 - Oklahoma Production Unit Number | nvarchar | 11 | 0 | | |
22 | OIUX5_OK_PRDTC | Tax 2.0 - Oklahoma PRA Detail Tax Transactions Multi Count | 58 | PUN | Tax 2.0 - Oklahoma Production Unit Number | nvarchar | 11 | 0 | | |
23 | OIUX5_OK_RPDT | Tax 2.0 - Oklahoma Gross Prod Report Detail | 8 | PUN | Tax 2.0 - Oklahoma Production Unit Number | nvarchar | 11 | 0 | | |
24 | OIUX5_OK_SOLEDT | Tax 2.0 - Statute of Limitation Exception Detail | 3 | PUN | Tax 2.0 - Oklahoma Production Unit Number | nvarchar | 11 | 0 | | |
25 | OIUX5_OK_TAXHST | Tax 2.0 - Oklahoma Tax Transactions History | 54 | PUN | Tax 2.0 - Oklahoma Production Unit Number | nvarchar | 11 | 0 | | |
26 | OIUX5_OK_TAXHSTC | Tax 2.0 - Oklahoma Tax Transactions History Multi-Counties | 56 | PUN | Tax 2.0 - Oklahoma Production Unit Number | nvarchar | 11 | 0 | | |
27 | OIUX5_OK_TAXSTG | Tax 2.0 - Oklahoma Tax Transactions Staging | 54 | PUN | Tax 2.0 - Oklahoma Production Unit Number | nvarchar | 11 | 0 | | |
28 | OIUX5_OK_TAXTXN | Tax 2.0 - Oklahoma Tax Transactions | 54 | PUN | Tax 2.0 - Oklahoma Production Unit Number | nvarchar | 11 | 0 | | |
29 | OIUX5_OK_TAXTXNC | Tax 2.0 - Oklahoma Tax Transactions Multiple Counties | 56 | PUN | Tax 2.0 - Oklahoma Production Unit Number | nvarchar | 11 | 0 | | |
30 | OIUX5_OK_ZVOL | Tax 2.0 - Oklahoma Zero Volume Reporting Master | 3 | PUN | Tax 2.0 - Oklahoma Production Unit Number | nvarchar | 11 | 0 | | |