| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCheck Input |
1 | OIUCI_JE | Incoming Check Journalized. Temporary hold | 86 | PU_PR_NO | Purchaser Property Number | nvarchar | 18 | 0 | | |
2 | OIUCI_PDX | Purchaser DOI Cross Reference | 4 | PU_PR_NO | Remitter Property | nvarchar | 18 | 0 | | |
TOPRevenue |
3 | OIUE2_JEINTF | Proc 2.0 - JE Interface Table | 87 | PU_PR_NO | Purchaser Property Number | nvarchar | 18 | 0 | | |
4 | OIUH_RV_ARINTF | PRA Journal Entries to A/R interface table | 85 | PU_PR_NO | Purchaser Property Number | nvarchar | 18 | 0 | | |
5 | OIUH_RV_JEINTF | PRA Journal Entries | 86 | PU_PR_NO | Purchaser Property Number | nvarchar | 18 | 0 | | |
TOPValuation |
6 | OIURV_DOC_DTL_BK | Valuation Transactions Level 1 - Vltxns | 38 | PU_PR_NO | Purchaser's Lease Number | nvarchar | 18 | 0 | | |
7 | OIURV_DOC_JEINTF | Revenue Document Concept - JEINTF temp table | 88 | PU_PR_NO | Purchaser Property Number | nvarchar | 18 | 0 | | |