| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIUX8_NM_CTAFOVR | Tax 2.0 - NM - Contract Type Level Affiliation Cd Override | 2 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
TOPCheck Input |
2 | OIUCI_JE | Incoming Check Journalized. Temporary hold | 44 | CT_TYPE_CD | Contract Type code | nvarchar | 2 | 0 | | |
TOPCheck Write |
3 | OIUCW_PAYMENT | Payment Details from Payment Run | 32 | CT_TYPE_CD | Contract Type code | nvarchar | 2 | 0 | | |
4 | OIU_CW_SUM_PAY | Summarized Payable Table for Check Write | 20 | CT_TYPE_CD | Contract Type code | nvarchar | 2 | 0 | | |
TOPOwnership |
5 | OIUOW_DOACC | DOI Owner Override Account Codes | 7 | CT_TYPE_CD | Contract type code | nvarchar | 2 | 0 | | |
6 | OIUOW_DOACC_WK | DOI Owner Override Account Codes Worktable | 7 | CT_TYPE_CD | Contract type code | nvarchar | 2 | 0 | | |
TOPProduction and Revenue Accounting |
7 | OIU_CM_CTTYP | Contract Type (TBLCS007) | 1 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
8 | OIU_CM_CTTYPGRP | Contract Type Group | 3 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
9 | OIU_CM_CTTYP_TX | Contract Type Text | 2 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
10 | OIU_RV_CTTYPGRP | Contract type group table maintained by SAP | 2 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
11 | OIU_RV_CTX | PRA Contract Type Cross Reference | 2 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
12 | OIU_RV_VLTXNS | Valuation Transactions | 27 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
TOPRevenue |
13 | OIUE1_LSSL_SUM | Legal Suspense Summary | 24 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
14 | OIUE2_ESCH_DTL | Proc 2.0 - Escheat - Owner Details | 25 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
15 | OIUE2_ESCH_DTLH | Proc 2.0 - Escheat - Owner Detail History | 25 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
16 | OIUE2_ESCROW_DTL | Proc 2.0 - WY Escrow - Owner Details | 25 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
17 | OIUE2_JEINTF | Proc 2.0 - JE Interface Table | 45 | CT_TYPE_CD | Contract Type code | nvarchar | 2 | 0 | | |
18 | OIUH_RV_ARINTF | PRA Journal Entries to A/R interface table | 43 | CT_TYPE_CD | Contract Type code | nvarchar | 2 | 0 | | |
19 | OIUH_RV_CT | Contract | 3 | CT_TYPE_CD | TYPE CODE | nvarchar | 2 | 0 | | |
20 | OIUH_RV_JEINTF | PRA Journal Entries | 44 | CT_TYPE_CD | Contract Type code | nvarchar | 2 | 0 | | |
21 | OIURV03_DTL_BK | Valuation Transactions Level 1 - Vltxns | 27 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
22 | OIURV03_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 17 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
TOPTax Reporting |
23 | OIUX3_JEINTF | Tax Reporting - JE Interface Table | 24 | CT_TYPE_CD | Contract Type code | nvarchar | 2 | 0 | | |
24 | OIUX7_WY_GSALES | Tax 2.0 - WYGP Sales | 14 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
25 | OIUX7_WY_GSALHST | Tax 2.0 - WYGP Sales History | 13 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
26 | OIUX7_WY_GSALTXN | Tax 2.0 - WYGP Sales | 13 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
TOPValuation |
27 | OIURV_DOC_DTL_BK | Valuation Transactions Level 1 - Vltxns | 27 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
28 | OIURV_DOC_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 17 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |
29 | OIURV_DOC_JEINTF | Revenue Document Concept - JEINTF temp table | 46 | CT_TYPE_CD | Contract Type code | nvarchar | 2 | 0 | | |
30 | OIURV_DOC_RDSUM | RD summary(VL interface records to RD) | 336 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | | |