VRM_CUSTOMER_CONTRACT_HEADERS
This table contains the header attributes of the customer contract.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
VRM_CUST_CONTRACT_HDRS_PK |
CUSTOMER_CONTRACT_HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Yes | Customer contract header unique identifier. | ||
| CUSTOMER_CONTRACT_NUMBER | NUMBER | 18 | Yes | Customer contract number. This is a running sequence number. | ||
| CUSTOMER_CONTRACT_DATE | DATE | Yes | Customer contract date. | |||
| 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 | Yes | 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. | |||
| 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. | |||
| ALLOCATION_TYPE | VARCHAR2 | 30 | Type of the allocation. Values are derived from lookup type ORA_ALLOCATION_TYPE. | |||
| CONTRACT_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Contract 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_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. | ||||
| PAYMENT_CONFIRM_FLAG | VARCHAR2 | 1 | Indicates whether this contract requires a payment confirmation. | |||
| CONTRACT_PAYMENT_AMOUNT | NUMBER | Contract payment amount. It is the sum of all payments received against this contract. | ||||
| 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. | ||||
| 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. | |||
| LEDGER_ID | NUMBER | 18 | Yes | Unique identifier of a ledger. | ||
| COMMENTS | VARCHAR2 | 1000 | User entered comments. | |||
| CONTRACT_HASH_CODE | VARCHAR2 | 100 | Contract processing unique identifier. | |||
| REV_REC_ENQUEUE_MSG_ID | RAW | 16 | Yes | Message identifier of the latest enqueued payload into the revenue side processing queue. | Obsolete | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| CREATED_FROM | VARCHAR2 | 30 | Yes | The process or user interface from which this row is created.. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| 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. | |||
| ALLOCATION_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that allocated/exempted this contract. | |||
| PROCESSED_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that updated an existing contract. | |||
| 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. | |||
| LATEST_REVISION_INTENT_CODE | VARCHAR2 | 30 | Revision intent of the last performance obligation revision of the contract. Values are from the lookup type ORA_VRM_REVISION_INTENT_TYPE. | |||
| LATEST_VERSION_DATE | DATE | Date of the most recent version of the contract's underlying performance obligation. | ||||
| 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. | ||||
| 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. | ||||
| CONTRACT_GROUP_NUMBER | VARCHAR2 | 320 | Concatenation of the original customer contract's source document number and customer contract number for the recurring line. | |||
| CONTR_CUR_MOD_DATE_CARVE_AMT | NUMBER | Discounted amount in the contract currency as of the contract revision date. | ||||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| VRM_CUSTOMER_CONTRACT_HEADERS | vrm_contract_rules_b | CONTRACT_RULE_ID |
| VRM_CUSTOMER_CONTRACT_HEADERS | vrm_price_eff_periods_b | EFFECTIVITY_PERIOD_ID |
| VRM_CUSTOMER_CONTRACT_HEADERS | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
| VRM_CUSTOMER_CONTRACT_HEADERS | gl_ledgers | LEDGER_ID |
| vrm_create_event_dists_interim | vrm_customer_contract_headers | CUSTOMER_CONTRACT_HEADER_ID |
| vrm_reference_currency_details | vrm_customer_contract_headers | CUSTOMER_CONTRACT_HEADER_ID |
| vrm_perf_obligation_lin_dists | vrm_customer_contract_headers | CUSTOMER_CONTRACT_HEADER_ID |
| vrm_perf_obligations | vrm_customer_contract_headers | CUSTOMER_CONTRACT_HEADER_ID |
| vrm_po_immaterial_details | vrm_customer_contract_headers | CUSTOMER_CONTRACT_HEADER_ID |
| vrm_perf_obligation_lines | vrm_customer_contract_headers | CUSTOMER_CONTRACT_HEADER_ID |
| vrm_contr_carveout_hdrs | vrm_customer_contract_headers | CUSTOMER_CONTRACT_HEADER_ID |
| vrm_contr_carveout_hdrs | vrm_customer_contract_headers | PREV_CONTR_CARVEOUT_HEADER_ID |
| vrm_customer_contract_audit | vrm_customer_contract_headers | CUSTOMER_CONTRACT_HEADER_ID |
| vrm_pol_immaterial_details | vrm_customer_contract_headers | CUSTOMER_CONTRACT_HEADER_ID |
| vrm_contract_activities | vrm_customer_contract_headers | CUSTOMER_CONTRACT_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_CUST_CONTRACT_HDRS_N1 | Non Unique | Default | REQUEST_ID |
| VRM_CUST_CONTRACT_HDRS_N2 | Non Unique | Default | CONTRACT_HASH_CODE |
| VRM_CUST_CONTRACT_HDRS_N3 | Non Unique | Default | ALLOCATION_STATUS, CUSTOMER_CONTRACT_FREEZE_DATE, REVIEW_STATUS, LEDGER_ID |
| VRM_CUST_CONTRACT_HDRS_N4 | Non Unique | Default | STANDALONE_SALES_FLAG |
| VRM_CUST_CONTRACT_HDRS_N5 | Non Unique | Default | ALLOCATION_PENDING_REASON, CUSTOMER_CONTRACT_FREEZE_DATE, ALLOCATION_STATUS, LEDGER_ID |
| VRM_CUST_CONTRACT_HDRS_N6 | Non Unique | Default | CONTRACT_GROUP_NUMBER |
| VRM_CUST_CONTRACT_HDRS_N7 | Non Unique | Default | FULL_SATISFACTION_DATE, ADJUSTMENT_STATUS_CODE, EXCL_FROM_AUTO_WRITEOFF_FLAG |
| VRM_CUST_CONTRACT_HDRS_U1 | Unique | Default | CUSTOMER_CONTRACT_HEADER_ID |