| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPCheck Input |
| 1 | OIUCI_PDX | Purchaser DOI Cross Reference | 11 | SYS_NO | Purchaser to Property/DOI Xref System Number | decimal | 18 | 0 | | |
| TOPCheck Write |
| 2 | OIU_CW_SUM_PAY | Summarized Payable Table for Check Write | 14 | SYS_NO | OIUH_DEC18 | decimal | 18 | 0 | | |
| TOPProduction and Revenue Accounting |
| 3 | OIUREP_EMPBACKUP | Exemptions for skipped tax records | 2 | SYS_NO | Severance tax number | nvarchar | 20 | 0 | | |
| 4 | OIUREP_MKTBACKUP | Marketing cost for skipped tax records | 2 | SYS_NO | Severance tax number | nvarchar | 20 | 0 | | |
| 5 | OIUREP_TAXBACKUP | Backup tax table for old tax reporting SOL | 2 | SYS_NO | Severance tax number | nvarchar | 20 | 0 | | |
| 6 | OIUREP_TIKBACKUP | Backup tik table for old tax reporting SOL | 2 | SYS_NO | Severance tax number | nvarchar | 20 | 0 | | |
| TOPRevenue |
| 7 | OIUAR_BAL_TRFR | Accounts Receivable Balance Transfer | 2 | SYS_NO | OIUH_DEC18 | decimal | 18 | 0 | | |
| 8 | OIUAR_REC_BAL | Accounts Receivable Balance | 2 | SYS_NO | OIUH_DEC18 | decimal | 18 | 0 | | |
| 9 | OIUAR_REC_BAL_H | Accounts Receivable Balance History | 2 | SYS_NO | OIUH_DEC18 | decimal | 18 | 0 | | |
| 10 | OIUE1_LSSL_SUM | Legal Suspense Summary | 13 | SYS_NO | SYSTEM NUMBER | decimal | 18 | 0 | | |
| 11 | OIUE2_ESCH_DTL | Proc 2.0 - Escheat - Owner Details | 14 | SYS_NO | SYSTEM NUMBER | decimal | 18 | 0 | | |
| 12 | OIUE2_ESCH_DTLH | Proc 2.0 - Escheat - Owner Detail History | 14 | SYS_NO | SYSTEM NUMBER | decimal | 18 | 0 | | |
| 13 | OIUE2_ESCROW_DTL | Proc 2.0 - WY Escrow - Owner Details | 14 | SYS_NO | SYSTEM NUMBER | decimal | 18 | 0 | | |
| 14 | OIU_RV_MKTG | Journal Entry Marketing Detail | 2 | SYS_NO | OIUH_DEC18 | decimal | 18 | 0 | | |
| 15 | OIU_RV_MKTG_H | Journal Entry Marketing Detail | 2 | SYS_NO | OIUH_DEC18 | decimal | 18 | 0 | | |
