VRM_CUSTOMER_CONTRACT_HDRS_GT
Oracle internal use only. This global temporary table is used in identify customer contracts job during internal processing.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Yes | Customer contract header unique identifier. | |
| CUSTOMER_CONTRACT_NUMBER | NUMBER | 18 | Customer contract number. This is a running sequence number. | ||
| CUSTOMER_CONTRACT_DATE | DATE | Customer contract date. Used for deriving price effectivity period of the customer contract. | |||
| CUSTOMER_CONTRACT_FREEZE_DATE | DATE | The date on which the contract will be frozen for automatic inclusion of new lines by the Identify Customer Contracts program. The value will be defaulted by adding the freeze period defined in the contract identification rule to the contract date. | |||
| CONTRACT_CLASSIFICATION_CODE | VARCHAR2 | 30 | Classification code of a contract. Values are derived from lookup type ORA_VRM_CONTRACT_CLASSIF_CODE. | ||
| CONTRACT_RULE_ID | NUMBER | 18 | Internal identifier of the customer contract identification rule. | ||
| EFFECTIVITY_PERIOD_ID | NUMBER | 18 | Unique identifier of a standard sales price effectivity period. Derived using the customer contract date. | ||
| REVIEW_STATUS | VARCHAR2 | 30 | Review status of the customer contract. Values are derived from lookup type ORA_VRM_CONTRACT_REVIEW_STATUS. | ||
| REVIEW_REQUIRED_REASON_CODE | VARCHAR2 | 30 | Reason for which contract is pending for review. Values are from the lookup ORA_REVIEW_REQUIRED_REASON. Possible values are ORA_SOURCE_HOLD, ORA_TRANS_PRICE_THRESHOLD, ORA_MANUAL_HOLD. | ||
| ALLOCATION_STATUS | VARCHAR2 | 30 | Allocation status of the customer contract. Values are derived from lookup type ORA_VRM_CONTRACT_ALLOCN_STATUS. | ||
| ALLOCATION_PENDING_REASON | VARCHAR2 | 30 | If the allocation of the contract is pending, then this attribute captures the reason it is pending. Values are derived from lookup type ORA_ALLOCATION_PENDING_REASON. | ||
| CONTRACT_CURRENCY_CODE | VARCHAR2 | 15 | Contract currency code. Populated with ledger currency code. | ||
| CONTR_CUR_TRANSACTION_PRICE | NUMBER | Total contract amount (transaction price) in the contract currency. It is the sum of the net consideration amount of all obligations. | |||
| CONTR_CUR_NONEXEMPT_TRX_PRICE | NUMBER | Total nonexempt transaction price in the contract currency. The value is derived from the transaction price after excluding the exempt perfomance obligation amounts. | |||
| CONTR_CUR_TOTAL_RECOG_REV_AMT | NUMBER | Total revenue recognized of all the performance obligations in the contract currency. | |||
| CONTR_CUR_TOTAL_BILLED_AMT | NUMBER | Total billed amount of all the performance obligations in the contract currency. | |||
| EXCHANGE_RATE | NUMBER | Conversion rate for converting amounts from contract currency to ledger currency. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type of the contract. | ||
| EXCHANGE_RATE_DATE | DATE | Conversion date to be used for conversion. | |||
| LEDGER_ID | NUMBER | 18 | Ledger identifer of the customer contract. | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Legal entity of the customer contract. | ||
| SINGLE_OBLIGATION_FLAG | VARCHAR2 | 1 | Indicates whether contract has single or multiple obligations. Y means single obligation contract and N means multiple obligation contract. | ||
| STANDALONE_SALES_FLAG | VARCHAR2 | 1 | Identifies whether the contract is included for observed standalone selling price calculation. | ||
| IS_EXCH_RATE_INFO_AVAILABLE | VARCHAR2 | 1 | Oracle internal use only. | ||
| CREATED_FROM | VARCHAR2 | 30 | The process or user interface from which this row is created.. | ||
| CONTRACT_HASH_CODE | VARCHAR2 | 100 | Contract processing unique identifier. | ||
| REFERENCE | VARCHAR2 | 1000 | User entered contract reference or grouping attribute values used to identify the contract as derived by enabling the Copy to Reference option in the Contract Identification rule. | ||
| CONTRACT_STATUS_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| LATEST_IMMATERIAL_CHANGE_CODE | VARCHAR2 | 30 | Latest immaterial change type processed on this customer contract. Valid values are from the lookup type ORA_IMMATERIAL_CHANGE_TYPE. | ||
| CONTRACT_MODIFICATION_DATE | DATE | Date on which the revenue contract was modified. | |||
| CONTR_CUR_MOD_DATE_ALLOC_AMT | NUMBER | Allocated amount as of the contract modification date in the contract currency. | |||
| CONTR_CUR_MOD_DATE_CARVE_AMT | NUMBER | Discounted amount in the contract currency as of the contract revision date. | |||
| CONTRACT_GROUP_NUMBER | VARCHAR2 | 320 | Concatenation of the original customer contract's source document number and customer contract number for the recurring line. | ||
| ADJUSTMENT_STATUS_CODE | VARCHAR2 | 30 | Contract's eligibility for adjustment by the Residual Account Balance Write Off process. Values are from the lookup type ORA_ADJUSTMENT_STATUS. | ||
| EXCL_FROM_AUTO_WRITEOFF_FLAG | VARCHAR2 | 1 | Indicates whether the contract will be excluded from processing by the Residual Account Balance Write Off process. Values are from the lookup type VRM_YES/NO. | ||
| LAST_ACTIVITY_DATE | DATE | Date on which the last activity was performed on the contract. | |||
| SATISFACTION_STATUS | VARCHAR2 | 30 | Overall satisfaction status of the contract. When all of the performance obligations in the contract are fully satisfied, the status is set to Fully Satisfied and the Satisfaction Date is set to Max (Satisfaction Date) of all the performance obligations of the contract. When at least performance obligation in the contract is not fully satisfied, then the status is set to Not Satisfied. Values are derived from the lookup type ORA_VRM_SATISFACTION_STATUS. | ||
| FULL_SATISFACTION_DATE | DATE | Latest satisfaction date for all of the performance obligations within a contract when all performance obligations in the contract are fully satisified. Use in conjunction with the SATISFACTION_STATUS column. | |||
| ALLOCATION_METHOD_CODE | VARCHAR2 | 30 | The allocation currency basis used to allocate and recognize revenue for a contract. Valid values are from the lookup type ORA_VRM_ALLOCATION_METHOD. | ||
| ENTER_CURR_MOD_DATE_ALLOC_AMT | NUMBER | Allocated amount as of the contract modification date in the entered currency. | |||
| ENTER_CURR_MOD_DATE_CARVE_AMT | NUMBER | Discounted amount in the entered currency as of the contract revision date. | |||
| ENTERED_CURRENCY_CODE | VARCHAR2 | 15 | The transaction currency code used for revenue contract. | ||
| ENTER_CURR_TRANSACTION_PRICE | NUMBER | Total contract amount (transaction price) in the entered currency, which is the sum of the net consideration amount of all obligations. | |||
| ENTER_CURR_TOTAL_RECOG_REV_AMT | NUMBER | Total revenue recognized for all the performance obligations in the entered currency. | |||
| ENTER_CURR_TOTAL_BILLED_AMT | NUMBER | Total billed amount for all the performance obligations in the entered currency. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_CUST_CONTR_HDRS_GT_N1 | Non Unique | CONTRACT_HASH_CODE, CONTRACT_RULE_ID |
| VRM_CUST_CONTR_HDRS_GT_N2 | Non Unique | CONTRACT_STATUS_CODE |