| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIUX8_NM_SUFFXRF | Tax 2.0 - New Mexico Suffix and tax rate x-ref | 12 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
TOPProduction and Revenue Accounting |
2 | OIUREP_TAXBACKUP | Backup tax table for old tax reporting SOL | 18 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
3 | OIUREP_TIKBACKUP | Backup tik table for old tax reporting SOL | 18 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
4 | OIU_CM_SCHDCD | School district code | 2 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
5 | OIU_CM_SCHDCD_TX | School district code description | 3 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
6 | OIU_RV_TCLD | Tax Class | 13 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
7 | OIU_RV_VLTXNS | Valuation Transactions | 14 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
TOPRevenue |
8 | OIURV03_DOCMPXRF | VL Doc to MP XRef | 7 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
9 | OIURV03_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 20 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
10 | OIURV03_MPWC_XRF | MP to Well Completion Split Out XRef | 6 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
11 | OIURV03_VOLDTL | Valuation Transaction Level 2 -Volume | 9 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
TOPTax Reporting |
12 | OIUX1_ADJ_MKTC | Tax adjustments marketing costs for reporting | 4 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
13 | OIUX1_ADJ_TAXDC | Tax adjustments detail for reporting | 4 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
14 | OIUX1_ADJ_XMPC | Tax adjustment exemptions for reporting | 4 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
15 | OIUX1_TRN_MKTC | Tax transaction marketing costs for reporting | 4 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
16 | OIUX1_TRN_MKTL | Tax transaction marketing costs for reporting | 4 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
17 | OIUX1_TRN_TAXDC | Tax transaction detail for reporting | 4 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
18 | OIUX1_TRN_TAXDL | Tax transaction detail for reporting | 4 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
19 | OIUX1_TRN_XMPC | Tax transaction exemptions for reporting | 4 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
20 | OIUX1_TRN_XMPL | Tax transaction exemptions for reporting | 4 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
21 | OIUX1_TXCD_XREF | Cross reference between state tax codes and PRA entities | 6 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
TOPValuation |
22 | OIURV_DOC_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 20 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
23 | OIURV_DOC_VOLDTL | Valuation Transaction Level 2 -Volume | 9 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
24 | OIURV_DOC_VOLUNT | Valuation Document Concept - Volume Unit | 9 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
25 | OIUVL_SEV | Severance tax | 11 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
26 | OIUVL_STTR | State Tax Rates | 8 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
27 | OIUVL_TCJV | Tax Class - Venture DOI's | 9 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
28 | OIUVL_TCMP | Tax Class Measurement Points | 7 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |
29 | OIUVL_TCWC | Tax Class - Well Completion | 10 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | | |