4 Appendix: Table Details

This topic provides the table details information.

This section provides the list of new and modified tables introduced in this release.

Table 4-1 New Table

Table Name Archive Table Name
ACCOUNT_TAX_DUES O/OO/X_/ACCOUNT_TAX_DUES
ACCOUNT_TAX_DUE_DATE_HISTORY O/OO/X_/ACCOUNT_TAX_DUE_DATE_HISTORY
API_ACCOUNT_TAX_DUE_DT_HISTORY NA
IACCOUNT_TAX_DUE_DT_HISTORY NA

Table 4-2 Modified Tables

Table Name Archive Table Name New Column Added Data Type
TXNS_TEMP O/OO/X_/TXNS_TEMP TXN_ASE_UPGRADE_IND VARCHAR2(30)
TXNS O/OO/X_/TXNS TXN_RESIDUAL_VALUATION_CD VARCHAR2(30)
TXNS_TEMP O/OO/X_/TXNS_TEMP TXN_RESIDUAL_VALUATION_CD VARCHAR2(30)
TXNS O/OO/X_/TXNS TXN_ASE_VALUE_AMT NUMBER
TXNS_TEMP O/OO/X_/TXNS_TEMP TXN_ASE_VALUE_AMT NUMBER
TXNS O/OO/X_/TXNS TXN_ASE_UPGRADE_FEE_AMT NUMBER
TXNS_TEMP O/OO/X_/TXNS_TEMP TXN_ASE_UPGRADE_FEE_AMT NUMBER
TXNS O/OO/X_/TXNS TXN_ASE_VAL_EVG_IND VARCHAR2(30)
TXNS_TEMP O/OO/X_/TXNS_TEMP TXN_ASE_VAL_EVG_IND VARCHAR2(30)
TXNS O/OO/X_/TXNS TXN_INFLATION_RATE_PER NUMBER
TXNS_TEMP O/OO/X_/TXNS_TEMP TXN_INFLATION_RATE_PER NUMBER
TXNS O/OO/X_/TXNS TXN_EVG_RENEW_CYCLE NUMBER
TXNS_TEMP O/OO/X_/TXNS_TEMP TXN_EVG_RENEW_CYCLE NUMBER
TXNS_NON_MONETARY_TEMP O/OO/X_/TXNS_NON_MONETARY_TEMP TXN_ASE_UPGRADE_IND VARCHAR2(30)
TXNS_NON_MONETARY_TEMP O/OO/X_/TXNS_NON_MONETARY_TEMP TNM_ASE_VALUE_AMT NUMBER
TXNS_NON_MONETARY_TEMP O/OO/X_/TXNS_NON_MONETARY_TEMP TNM_ASE_UPGRADE_FEE_AMT NUMBER
TXNS_NON_MONETARY_TEMP O/OO/X_/TXNS_NON_MONETARY_TEMP TNM_ASE_VAL_EVG_IND VARCHAR2(30)
TXNS_NON_MONETARY_TEMP O/OO/X_/TXNS_NON_MONETARY_TEMP TNM_INFLATION_RATE_PER NUMBER
TXNS_NON_MONETARY_TEMP O/OO/X_/TXNS_NON_MONETARY_TEMP TNM_EVG_RENEW_CYCLE NUMBER
ACCOUNT_REVENUE_SCHEDULE O/OO/ACCOUNT_REVENUE_SCHEDULE ARU_SET_ID NUMBER
ACCOUNT_REVENUE_SCHEDULE O/OO/ACCOUNT_REVENUE_SCHEDULE ARU_PARENT_SET_ID NUMBER