| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIUX8_NM_OOSWO | Tax 2.0 - New Mexico Out Of Statute Write Off | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
2 | OIUY3_TX_INTSTG | Royalty 2.0 - TX GLO - Royalty Trans Interface Staging | 2 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
3 | OIUY3_TX_INTTXN | Royalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface | 2 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
4 | OIUY3_TX_OOSWO | Royalty 2.0 - Texas GLO Out Of Statute Write Off | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
5 | OIUY6_WY_INTSTG | Royalty 2.0 - WY - Royalty Transaction Interface (Staging) | 2 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
6 | OIUY6_WY_INTTXN | Royalty 2.0 - WY - Royalty Transaction Interface | 2 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
7 | OIUY6_WY_OOSWO | Royalty 2.0 - Wyoming Out Of Statute Write Off | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
TOPCheck Input |
8 | OIUCI_JE | Incoming Check Journalized. Temporary hold | 2 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
9 | OIUCI_PDX | Purchaser DOI Cross Reference | 29 | OR_LVL_1_NO | Organization level 1 number (Company Code) | nvarchar | 3 | 0 | | |
TOPRevenue |
10 | OIUE1_LSSL_SUM | Legal Suspense Summary | 14 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
11 | OIUE2_ESCH_DTL | Proc 2.0 - Escheat - Owner Details | 15 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
12 | OIUE2_ESCH_DTLH | Proc 2.0 - Escheat - Owner Detail History | 15 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
13 | OIUE2_ESCROW_DTL | Proc 2.0 - WY Escrow - Owner Details | 15 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
14 | OIUE2_JEINTF | Proc 2.0 - JE Interface Table | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
15 | OIUE2_RUN_JE | Proc 2.0 - Process Run JE Batch Info | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
16 | OIUH_RV_ARINTF | PRA Journal Entries to A/R interface table | 2 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
17 | OIUH_RV_JEINTF | PRA Journal Entries | 2 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
18 | OIUH_RV_TAXHA | New Mexico Tax History For Affiliated Txns | 19 | OR_LVL_1_NO | OIUH_CHAR3 | nvarchar | 3 | 0 | | |
19 | OIUH_RV_TAXHN | New Mexico Tax History For Non-Affiliated Txns | 19 | OR_LVL_1_NO | OIUH_CHAR3 | nvarchar | 3 | 0 | | |
20 | OIU_RV_CMKT | Check Detail Marketing Deductions | 2 | OR_LVL_1_NO | OIUH_CHAR3 | nvarchar | 3 | 0 | | |
TOPTax Reporting |
21 | OIUX3_JEINTF | Tax Reporting - JE Interface Table | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
22 | OIUX3_RUN_JE | Tax Reporting - Report Run JE Batch Info | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
23 | OIUX3_TX_OOSWO | Tax Reporting - Texas Out Of Statute Write Off | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
24 | OIUX5_OOSWO | Tax 2.0 - Out Of Statute Write Off | 5 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
25 | OIUX6_WY_OOSWO | Tax 2.0 - Wyoming Out Of Statute Write Off | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
TOPValuation |
26 | OIURV_DOC_BCN | Revenue Document Concept - Batch Control Number | 4 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
27 | OIURV_DOC_JEINTF | Revenue Document Concept - JEINTF temp table | 4 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |