| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIUY3_TX_OWNOVR | Royalty 2.0 - TX GLO/TAMU Owner Level Reporting Override | 6 | OWN_SEQ_NO | Sequence Number | nvarchar | 2 | 0 | | |
TOPCheck Input |
2 | OIUCI_DOC_CIREJ | Contains VL/RD rejects to be reported to Check Input | 7 | OWN_SEQ_NO | Owner Sequence Number | nvarchar | 2 | 0 | | |
3 | OIUCI_JE | Incoming Check Journalized. Temporary hold | 31 | OWN_SEQ_NO | Owner Sequence Number | nvarchar | 2 | 0 | | |
4 | OIUCI_SPC_DIST | Purchaser DOI Cross Reference | 9 | OWN_SEQ_NO | Owner Sequence Number | nvarchar | 2 | 0 | | |
TOPCheck Write |
5 | OIUCW_EXTD | Extended Details from Payment Run | 5 | OWN_SEQ_NO | Business Associate Sequence Nr. | nvarchar | 2 | 0 | | |
6 | OIUCW_OWNER_SEQ | Owner/Sequence List for Payment Runs | 5 | OWN_SEQ_NO | Business Associate Sequence Nr. | nvarchar | 2 | 0 | | |
7 | OIUCW_PAYMENT | Payment Details from Payment Run | 5 | OWN_SEQ_NO | Business Associate Sequence Nr. | nvarchar | 2 | 0 | | |
8 | OIUCW_REJECTS | Payments Not Made in the Run | 5 | OWN_SEQ_NO | Business Associate Sequence Nr. | nvarchar | 2 | 0 | | |
9 | OIU_CW_SUM_PAY | Summarized Payable Table for Check Write | 4 | OWN_SEQ_NO | Business Associate Sequence Nr. | nvarchar | 2 | 0 | | |
TOPRevenue |
10 | OIUE1_LSSL_SUM | Legal Suspense Summary | 3 | OWN_SEQ_NO | Owner Sequence Number | nvarchar | 2 | 0 | | |
11 | OIUE2_CW_REJECTS | Proc 2.0 - Check Write Rejects | 6 | OWN_SEQ_NO | Business Associate Sequence Nr. | nvarchar | 2 | 0 | | |
12 | OIUE2_ESCH_BA | Proc 2.0 - Escheat - BA | 3 | OWN_SEQ_NO | Sequence Number | nvarchar | 2 | 0 | | |
13 | OIUE2_ESCH_DTL | Proc 2.0 - Escheat - Owner Details | 4 | OWN_SEQ_NO | Owner Sequence Number | nvarchar | 2 | 0 | | |
14 | OIUE2_ESCH_DTLH | Proc 2.0 - Escheat - Owner Detail History | 4 | OWN_SEQ_NO | Owner Sequence Number | nvarchar | 2 | 0 | | |
15 | OIUE2_ESCH_RPDTP | Proc 2.0 - Escheat - Report Detail - Property | 5 | OWN_SEQ_NO | Owner Sequence Number | nvarchar | 2 | 0 | | |
16 | OIUE2_ESCH_SUM | Proc 2.0 - Escheat - Owner Summary | 4 | OWN_SEQ_NO | Owner Sequence Number | nvarchar | 2 | 0 | | |
17 | OIUE2_ESCH_SUMH | Proc 2.0 - Escheat - Owner Summary History | 4 | OWN_SEQ_NO | Owner Sequence Number | nvarchar | 2 | 0 | | |
18 | OIUE2_ESCROW_DTL | Proc 2.0 - WY Escrow - Owner Details | 4 | OWN_SEQ_NO | Owner Sequence Number | nvarchar | 2 | 0 | | |
19 | OIUE2_JEINTF | Proc 2.0 - JE Interface Table | 32 | OWN_SEQ_NO | Owner Sequence Number | nvarchar | 2 | 0 | | |
20 | OIUH_RV_ARINTF | PRA Journal Entries to A/R interface table | 30 | OWN_SEQ_NO | Owner Sequence Number | nvarchar | 2 | 0 | | |
21 | OIUH_RV_JEINTF | PRA Journal Entries | 31 | OWN_SEQ_NO | Owner Sequence Number | nvarchar | 2 | 0 | | |
TOPTax Reporting |
22 | OIUX3_JEINTF | Tax Reporting - JE Interface Table | 44 | OWN_SEQ_NO | Owner Sequence Number | nvarchar | 2 | 0 | | |
TOPValuation |
23 | OIURV_DOC_JEINTF | Revenue Document Concept - JEINTF temp table | 33 | OWN_SEQ_NO | Owner Sequence Number | nvarchar | 2 | 0 | | |