| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPTax Reporting |
1 | OIUX5Y_OK_MASTER | Tax 2.0 - Oklahoma Master Data PPN | 16 | NGPA_CD | Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code) | nvarchar | 3 | 0 | | |
2 | OIUX5_OK_CONFL | Tax 2.0 - Oklahoma Exempt Decimal Conflict | 13 | NGPA_CD | Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code) | nvarchar | 3 | 0 | | |
3 | OIUX5_OK_MASTER | Tax 2.0 - Oklahoma Master Data | 15 | NGPA_CD | Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code) | nvarchar | 3 | 0 | | |
4 | OIUX5_OK_OOSHST | Tax 2.0 - Oklahoma Out Of Statute Transactions History | 59 | NGPA_CD | Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code) | nvarchar | 3 | 0 | | |
5 | OIUX5_OK_OOSTXN | Tax 2.0 - Oklahoma Out Of Statute Transactions | 59 | NGPA_CD | Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code) | nvarchar | 3 | 0 | | |
6 | OIUX5_OK_PRDT | Tax 2.0 - Oklahoma PRA Detail Tax Transactions | 61 | NGPA_CD | Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code) | nvarchar | 3 | 0 | | |
7 | OIUX5_OK_PRDTC | Tax 2.0 - Oklahoma PRA Detail Tax Transactions Multi Count | 63 | NGPA_CD | Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code) | nvarchar | 3 | 0 | | |
8 | OIUX5_OK_RPDT | Tax 2.0 - Oklahoma Gross Prod Report Detail | 13 | NGPA_CD | Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code) | nvarchar | 3 | 0 | | |
9 | OIUX5_OK_TAXHST | Tax 2.0 - Oklahoma Tax Transactions History | 59 | NGPA_CD | Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code) | nvarchar | 3 | 0 | | |
10 | OIUX5_OK_TAXHSTC | Tax 2.0 - Oklahoma Tax Transactions History Multi-Counties | 61 | NGPA_CD | Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code) | nvarchar | 3 | 0 | | |
11 | OIUX5_OK_TAXSTG | Tax 2.0 - Oklahoma Tax Transactions Staging | 59 | NGPA_CD | Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code) | nvarchar | 3 | 0 | | |
12 | OIUX5_OK_TAXTXN | Tax 2.0 - Oklahoma Tax Transactions | 59 | NGPA_CD | Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code) | nvarchar | 3 | 0 | | |
13 | OIUX5_OK_TAXTXNC | Tax 2.0 - Oklahoma Tax Transactions Multiple Counties | 61 | NGPA_CD | Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code) | nvarchar | 3 | 0 | | |