VRM_CONTRACT_ALLOC_GT
This table temporarily contains contract allocation processing-related information.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
VRM_CONTRACT_ALLOC_GT_PK |
PERF_OBLIGATION_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_LINE_ID | NUMBER | 18 | Source document line. | ||
| ADJUSTMENT_METHOD_CODE | VARCHAR2 | 30 | Discount method used in allocation. | ||
| PARENT_LINE_ID | NUMBER | 18 | Oracle internal use only. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| WORKER_NUMBER | NUMBER | 3 | Oracle internal use only. | ||
| BATCH_NUMBER | NUMBER | 18 | The batch to be processed. | ||
| FMV_LINE_ID | NUMBER | 18 | Revenue price line. | ||
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Customer contract header. | ||
| POB_EXCHANGE_RATE | NUMBER | Conversion rate for converting amounts from the entered currency to the ledger currency. | |||
| POB_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type used for converting amounts from the entered currency to the ledger currency. | ||
| POB_EXCHANGE_RATE_DATE | DATE | Conversion rate date used for converting amounts from the entered currency to the ledger currency. | |||
| PERF_OBLIGATION_ID | NUMBER | 18 | Performance obligation. | ||
| CONTRACT_AMT | NUMBER | Total contract transaction price in the ledger currency | |||
| POL_FMV_AMT | NUMBER | Derived FMV amount for a performance obligation line. | |||
| POB_FMV_AMT | NUMBER | Derived FMV amount for a performance obligation. | |||
| ALLOC_CONTRACT_AMT | NUMBER | Contract amount eligible for allocation. | |||
| EXEMPT_FLAG | VARCHAR2 | 1 | Indicates if this performance obligation is exempt from allocation. | ||
| POL_TOTAL_FMV_AMT | NUMBER | Sum of fair market values of lines under a unique performance obligation. | |||
| POL_TOTAL_NET_CONSIDER_AMT | NUMBER | Sum of line net consideration amounts under a unique performance obligation. | |||
| POB_LINES_WITHOUT_FMV_COUNT | NUMBER | The count of lines without an FMV under a unique performance obligation. | |||
| POL_NET_CONSIDER_AMT | NUMBER | Performance obligation line net consideration amount. | |||
| POB_NET_CONSIDER_AMT | NUMBER | Performance obligation net consideration amount. | |||
| PERF_OBLIGATION_LINE_ID | NUMBER | 18 | Yes | Performance obligation line. | |
| CONTRACT_CURRENCY_CODE | VARCHAR2 | 15 | Contract currency code. | ||
| POB_CURRENCY_CODE | VARCHAR2 | 15 | Performance obligation currency code. | ||
| REMOVED_FLAG | VARCHAR2 | 1 | Indicates if the performance obligation line is removed from the performance obligation. | ||
| ALLOCATION_STATUS | VARCHAR2 | 30 | Allocation status of the customer contract. Values are derived from lookup type ORA_VRM_CONTRACT_ALLOCN_STATUS. | ||
| BASE_PRICE | NUMBER | Base price per unit of measure of the inventory item or memo line. | |||
| FAIR_MARKET_VALUE | NUMBER | A fair market value of an item, item group, or memo line in entered currency. | |||
| FMV_REPRESENTATION_TYPE | VARCHAR2 | 30 | FMV price representation type. The value is derived from the VRM_FMV_REPRESENTATIONS lookup type. | ||
| FMV_TOLERANCE_CODE | VARCHAR2 | 30 | The fair market value tolerance range level used to calculate the discount amount. | ||
| FMV_TOLERANCE_HIGH | NUMBER | High price percentage of the FMV tolerance range. | |||
| FMV_TOLERANCE_LOW | NUMBER | Low price percentage of the FMV tolerance range. | |||
| FMV_REVIEW_STATUS_CODE | VARCHAR2 | 30 | Status of VSOE value review. Values are from the lookup VRM_VSOE_VALUE_REVIEW_STATUS. | ||
| LINE_NET_CONSIDER_AMT | NUMBER | Net consideration amount of the performance obligation line. | |||
| MANUAL_REVIEW_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates if contract review should be queued for manual review. Possible values are Y or N. | ||
| QUANTITY | NUMBER | Quantity of the performance obligaton line. | |||
| REVISED_COST | NUMBER | Adjusted cost of sale after the document is revised. | |||
| TOTAL_LINE_FMV_AMOUNT | NUMBER | Revenue price amount in the entered currency. | |||
| UNIT_LIST_PRICE | NUMBER | Unit list price used to validate the revenue price value of a line. | |||
| UNIT_PRICE | NUMBER | Unit price represented by the unit selling price, discount percent, or any other representation type. | |||
| PRICE_EFF_PERIOD_ID | NUMBER | 18 | VSOE price effectivity period unique identifier. | ||
| ITEM_TYPE_ID | NUMBER | 18 | Item type unique identifier. Value populated in this column is related to the primary key of the entity provided in ITEM_TYPE. | ||
| ITEM_TYPE | VARCHAR2 | 10 | Indicates the type of a source document items. The valid values are ITEM, MEMO_LINE and ITEM_GROUP. | ||
| UOM_CODE | VARCHAR2 | 200 | Unit of measure of inventory item or memo line on source document line. | ||
| PRICING_COMBINATION_ID | NUMBER | 18 | Pricing dimension combination identifier. | ||
| FMV_IN_USE_FLAG | VARCHAR2 | 1 | Indicates whether the FMV line has been used in compliance process. Possible values are Yes or No. | ||
| IS_TEMPLATE_BASED_OBLIG_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| LINE_STATUS | VARCHAR2 | 30 | Oracle internal use only. | ||
| POL_IMMATERIAL_DETAIL_ID | NUMBER | 18 | Promised detail line level immaterial details unique identifier. | ||
| PO_IMMATERIAL_DETAIL_ID | NUMBER | 18 | Performance obligation level immaterial details unique identifier. | ||
| 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. | ||
| SERVICE_DURATION | NUMBER | Duration of the service item in terms of the service unit of measure. | |||
| SSP_LOW | NUMBER | The low point of the acceptable standalone selling price ranges. This value is used to determine the unit standalone selling price in accordance with the Standalone Selling Price policy for ranges. | |||
| SSP_MID | NUMBER | The mid point of the acceptable standalone selling price ranges. This value is used to determine the unit standalone selling price in accordance with the Standalone Selling Price policy for ranges. | |||
| SSP_HIGH | NUMBER | The high point of the acceptable standalone selling price ranges. This value is used to determine the unit standalone selling price in accordance with the Standalone Selling Price policy for ranges. | |||
| PUBLISHED_SALES_POINT | NUMBER | The price determined and published by the business as published sales point of an item or service. | |||
| BELOW_RANGE_SSP_RULE_CODE | VARCHAR2 | 30 | The rule to be used in accordance with the Standalone Selling Price policy of the business when the actual value is below the SSP Low Point. Valid values are from the lookup type ORA_VRM_SSP_RANGE_CODE. | ||
| IN_RANGE_SSP_RULE_CODE | VARCHAR2 | 30 | The rule to be used in accordance with the Standalone Selling Price policy of the business when the actual value is between the SSP Low and SSP High Points. Valid values are from the lookup type ORA_VRM_SSP_RANGE_CODE. | ||
| ABOVE_RANGE_SSP_RULE_CODE | VARCHAR2 | 30 | The rule to be used in accordance with the Standalone Selling Price policy of the business when the actual value is above the SSP High Point. Valid values are from the lookup type ORA_VRM_SSP_RANGE_CODE. | ||
| SSP_RANGE_TOLERANCE_PERCENT | NUMBER | The tolerance percentage in accordance with the Standalone Selling Price policy of the business. The SSP Low Point and SSP High Point are calculated by the application when the SSP tolerance percentage and SSP midpoint are provided for an item or service. | |||
| ABS_SSP_PO | NUMBER | The absolute value of unit standalone selling Price for an item or service. | |||
| PO_SSP_RANGE_RULE_CODE | VARCHAR2 | 30 | The rule that is applied to the performance obligation template in accordance with the Standalone Selling Price policy. Valid values are from the lookup type ORA_VRM_SSP_RANGE_RULE. | ||
| PO_SSP_RULE_RESULT_CODE | VARCHAR2 | 30 | The result of the rule that is applied to the performance obligation template in accordance with the Standalone Selling Price policy. Valid values are from the lookup type ORA_VRM_SSP_RANGE_CODE. | ||
| ABS_SSP_POL | NUMBER | The absolute value of the unit standalone selling price for an item or service. | |||
| POL_SSP_RANGE_RULE_CODE | VARCHAR2 | 30 | The rule that is applied to the promised detail in accordance with the Standalone Selling Price policy. Valid values are from the lookup type ORA_VRM_SSP_RANGE_RULE. | ||
| POL_SSP_RULE_RESULT_CODE | VARCHAR2 | 30 | The result of the rule that is applied to the promised detail in accordance with the Standalone Selling Price policy. Valid values are from the lookup type ORA_VRM_SSP_RANGE_CODE. | ||
| REFERENCE_CURRENCY_CODE | VARCHAR2 | 15 | Currency used as the reference currency for converting entered currency amounts to the reference currency. | ||
| REFERENCE_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Rate type used to convert entered currency amounts to reference currency. | ||
| REFERENCE_EXCHANGE_RATE_DATE | DATE | Date used for converting amounts from the entered currency to the reference currency. | |||
| REFERENCE_EXCHANGE_RATE | NUMBER | Rate used for converting amounts from the entered currency to the reference currency. | |||
| OBLIGATION_CURRENCY_UNIT_SSP | NUMBER | The unit standalone selling price in obligation currency. | |||
| 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_CONTRACT_ALLOC_GT_N1 | Non Unique | LINE_STATUS, ALLOCATION_STATUS, FMV_IN_USE_FLAG |
| VRM_CONTRACT_ALLOC_GT_N2 | Non Unique | CUSTOMER_CONTRACT_HEADER_ID |
| VRM_CONTRACT_ALLOC_GT_N3 | Non Unique | IS_TEMPLATE_BASED_OBLIG_FLAG |
| VRM_CONTRACT_ALLOC_GT_N4 | Non Unique | PERF_OBLIGATION_ID |
| VRM_CONTRACT_ALLOC_GT_U1 | Unique | PERF_OBLIGATION_LINE_ID |