| 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 | | |