| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIUX8_NM_REJ | Tax 2.0 - NM - Reject Codes | 2 | REJ_CD | Tax 2.0 - NM - Reject Code | nvarchar | 2 | 0 | | |
2 | OIUX8_NM_REJT | Tax 2.0 - NM - Reject Code Text | 3 | REJ_CD | Tax 2.0 - NM - Reject Code | nvarchar | 2 | 0 | | |
3 | OIUX8_NM_TAXSTG | Tax 2.0 - NM - Tax Transactions (Staging) | 72 | REJ_CD | Tax 2.0 - NM - Reject Code | nvarchar | 2 | 0 | | |
4 | OIUX8_NM_TAXTXN | Tax 2.0 - NM - Tax Transactions | 72 | REJ_CD | Tax 2.0 - NM - Reject Code | nvarchar | 2 | 0 | | |
5 | OIUY3_TX_REJ | Royalty 2.0 - TX GLO/TAMU - Reject Codes | 2 | REJ_CD | Royalty 2.0 - Texas GLO - Reject Code | nvarchar | 2 | 0 | | |
6 | OIUY3_TX_REJT | Royalty 2.0 - Texas GLO - Reject Code Text | 3 | REJ_CD | Royalty 2.0 - Texas GLO - Reject Code | nvarchar | 2 | 0 | | |
7 | OIUY3_TX_ROYSTG | Royalty 2.0 - TX GLO - Royalty Transactions (Staging) | 70 | REJ_CD | Royalty 2.0 - Texas GLO - Reject Code | nvarchar | 2 | 0 | | |
8 | OIUY3_TX_ROYTXN | Royalty 2.0 - TX GLO - Royalty Transactions | 70 | REJ_CD | Royalty 2.0 - Texas GLO - Reject Code | nvarchar | 2 | 0 | | |
9 | OIUY3_TX_ROYTXNA | Royalty 2.0 - TX GLO - Royalty Transactions (Allocated) | 71 | REJ_CD | Royalty 2.0 - Texas GLO - Reject Code | nvarchar | 2 | 0 | | |
10 | OIUY6_WY_REJ | Royalty 2.0 - WY - Reject Codes | 2 | REJ_CD | Royalty 2.0 - WY - Reject Code | nvarchar | 2 | 0 | | |
11 | OIUY6_WY_REJT | Royalty 2.0 - WY - Reject Code Text | 3 | REJ_CD | Royalty 2.0 - WY - Reject Code | nvarchar | 2 | 0 | | |
12 | OIUY6_WY_ROYSTG | Royalty 2.0 - WY - Royalty Transactions (Staging) | 67 | REJ_CD | Royalty 2.0 - WY - Reject Code | nvarchar | 2 | 0 | | |
13 | OIUY6_WY_ROYTXN | Royalty 2.0 - WY - Royalty Transactions | 67 | REJ_CD | Royalty 2.0 - WY - Reject Code | nvarchar | 2 | 0 | | |
14 | OIUY6_WY_ROYTXNA | Royalty 2.0 - WY - Royalty Transactions (Allocated) | 68 | REJ_CD | Royalty 2.0 - WY - Reject Code | nvarchar | 2 | 0 | | |
TOPTax Reporting |
15 | OIUX3_TX_REJ | Tax Reporting - Texas Reject Codes | 2 | REJ_CD | Rejection Code | nvarchar | 2 | 0 | | |
16 | OIUX3_TX_REJT | Tax Reporting - Texas Reject Code Text | 3 | REJ_CD | Rejection Code | nvarchar | 2 | 0 | | |
17 | OIUX3_TX_TAXSTG | Tax Reporting - Texas Tax Transaction Staging | 53 | REJ_CD | Rejection Code | nvarchar | 2 | 0 | | |
18 | OIUX3_TX_TAXTXN | Tax Reporting - Texas Tax Transactions | 53 | REJ_CD | Rejection Code | nvarchar | 2 | 0 | | |
19 | OIUX5_OK_REJ | Tax 2.0 - Oklahoma Reject Codes | 2 | REJ_CD | Tax 2.0 - Oklahoma Rejection Code | nvarchar | 2 | 0 | | |
20 | OIUX5_OK_REJT | Tax 2.0 - Oklahoma Reject Code Text | 3 | REJ_CD | Tax 2.0 - Oklahoma Rejection Code | nvarchar | 2 | 0 | | |
21 | OIUX5_OK_TAXSTG | Tax 2.0 - Oklahoma Tax Transactions Staging | 75 | REJ_CD | Tax 2.0 - Oklahoma Rejection Code | nvarchar | 2 | 0 | | |
22 | OIUX5_OK_TAXTXN | Tax 2.0 - Oklahoma Tax Transactions | 75 | REJ_CD | Tax 2.0 - Oklahoma Rejection Code | nvarchar | 2 | 0 | | |
23 | OIUX5_OK_TAXTXNC | Tax 2.0 - Oklahoma Tax Transactions Multiple Counties | 77 | REJ_CD | Tax 2.0 - Oklahoma Rejection Code | nvarchar | 2 | 0 | | |
24 | OIUX6_WY_CTAXSTG | Tax 2.0 - Wyoming Conservation Tax Transactions Staging | 56 | REJ_CD | Rejection Code | nvarchar | 2 | 0 | | |
25 | OIUX6_WY_CTAXTXN | Tax 2.0 - Wyoming Conservation Tax Transactions | 56 | REJ_CD | Rejection Code | nvarchar | 2 | 0 | | |
26 | OIUX6_WY_GTAXSTG | Tax 2.0 - Wyoming Gross Prod Tax Transactions Staging | 69 | REJ_CD | Rejection Code | nvarchar | 2 | 0 | | |
27 | OIUX6_WY_GTAXTXN | Tax 2.0 - Wyoming Gross Prod Tax Transactions | 69 | REJ_CD | Rejection Code | nvarchar | 2 | 0 | | |
28 | OIUX6_WY_REJ | Tax 2.0 - Wyoming Reject Codes | 2 | REJ_CD | Rejection Code | nvarchar | 2 | 0 | | |
29 | OIUX6_WY_REJT | Tax Reporting - Texas Reject Code Text | 3 | REJ_CD | Rejection Code | nvarchar | 2 | 0 | | |
30 | OIUX6_WY_STAXSTG | Tax 2.0 - Wyoming Severance Tax Transactions Staging | 69 | REJ_CD | Rejection Code | nvarchar | 2 | 0 | | |
31 | OIUX6_WY_STAXTXN | Tax 2.0 - Wyoming Severance Tax Transactions | 69 | REJ_CD | Rejection Code | nvarchar | 2 | 0 | | |
32 | OIUX7_WY_GSALTXN | Tax 2.0 - WYGP Sales | 24 | REJ_CD | Rejection Code | nvarchar | 2 | 0 | | |
33 | OIUX7_WY_GVOLTXN | Tax 2.0 - WYGP Volumes | 14 | REJ_CD | Rejection Code | nvarchar | 2 | 0 | | |
34 | OIUX7_WY_REJ | Tax 2.0 - WYGP Reject Codes | 2 | REJ_CD | Rejection Code | nvarchar | 2 | 0 | | |
35 | OIUX7_WY_REJT | Tax 2.0 - WYGP Reject Code Text | 3 | REJ_CD | Rejection Code | nvarchar | 2 | 0 | | |