VRM_CONTRACT_ALLOC_INTERIM
This table 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_INTERIM_PK |
PERF_OBLIGATION_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_LINE_ID | NUMBER | 18 | Source document line. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code of a performance obligation line. | |
| TOTAL_LINE_FMV_AMOUNT | NUMBER | Fair market value amount of a performance obligation line. | |||
| FMV_TOLERANCE_LOW | NUMBER | Low price of the tolerance range. | |||
| FMV_TOLERANCE_HIGH | NUMBER | High price of the tolerance range. | |||
| FAIR_MARKET_VALUE | NUMBER | Fair market value of an item, item group, or memo line in the entered currency. | |||
| DOCUMENT_DATE | DATE | Date of the source document. | |||
| UNIT_REVENUE_PRICE | NUMBER | Unit revenue price of a line to be recognized by a revenue recognition process. | |||
| FMV_REPRESENTATION_TYPE | VARCHAR2 | 30 | FMV price representation type. The value is derived from the VRM_FMV_REPRESENTATIONS lookup type. | ||
| QUANTITY | NUMBER | Quantity of a revenue line. | |||
| UNIT_SELLING_PRICE | NUMBER | Unit selling price of the source document. | |||
| DISCOUNT_PERCENTAGE | NUMBER | Discount percentage of the source document. | |||
| UNIT_SELLING_PCT_BASE_PRICE | NUMBER | Unit selling price represented as a percentage of base price. | |||
| 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. | ||
| 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. | ||
| FMV_TOLERANCE_CODE | VARCHAR2 | 30 | The fair market value tolerance range level used to calculate the discount amount. | ||
| BATCH_NUMBER | NUMBER | 18 | The batch to be processed. | ||
| FMV_LINE_ID | NUMBER | 18 | Fair market value line. | ||
| REVISED_COST | NUMBER | Adjusted cost of sale after the document is revised | |||
| REVIEW_STATUS | VARCHAR2 | 30 | Review status of the VSOE value. Values are from the lookup VRM_VSOE_VALUE_REVIEW_STATUS. | ||
| UNIT_PRICE | NUMBER | Unit price represented by the unit selling price, discount percent, or any other representation type. | |||
| BASE_PRICE | NUMBER | Base price used to validate the revenue price value of a line. | |||
| UNIT_LIST_PRICE | NUMBER | Unit list price percentage used to validate the revenue price value of a line. | |||
| NET_UNIT_SALES_PRICE | NUMBER | Unit selling price after adjusting return amount. | |||
| NET_DISCOUNT_PCT | NUMBER | Discount percentage after adjusting the return amount. | |||
| NET_UNIT_SALES_PCT_BASE_PRICE | NUMBER | 18 | Unit sales percentage base price after adjusting the return amount. | ||
| REVISED_GROSS_MARGIN_PCT | NUMBER | Adjusted gross margin of sales after the document is revised. | |||
| NET_LINE_AMOUNT | NUMBER | Line amount after adjusting the return amount. | |||
| DELIVERED_FLAG | VARCHAR2 | 1 | Indicates the delivery status of a source document. | ||
| ELEMENT_TYPE | VARCHAR2 | 30 | Element is a deliverable or separate unit of accounting. Used to group element types for FMV sets. Values are from the lookup VRM_ELEMENT_TYPE. | ||
| DELIVERY_DATE | DATE | Fulfillment date of a source document line. | |||
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Customer contract header unique identifier. | ||
| LINE_NET_CONSIDER_AMT | NUMBER | Net consideration amount of the performance obligation line. | |||
| 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 for converting amounts from the entered currency to the ledger currency. | ||
| POB_EXCHANGE_RATE_DATE | DATE | Conversion date for converting amounts from the entered currency to the ledger currency. | |||
| PERF_OBLIGATION_ID | NUMBER | 18 | Performance obligation. | ||
| ALLOCATION_STATUS | VARCHAR2 | 30 | Allocation status of the customer contract. Values are from the lookup ORA_VRM_CONTRACT_ALLOCN_STATUS. | ||
| PERF_OBLIGATION_LINE_ID | NUMBER | 18 | Yes | Performance obligation line. | |
| REMOVED_FLAG | VARCHAR2 | 1 | Indicates if the performance obligation line is removed from the performance obligation. | ||
| MANUAL_REVIEW_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates if contract review should be queued for manual review. Possible values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_CONT_ALLOC_INTERIM_N1 | Non Unique | Default | REQUEST_ID, BATCH_NUMBER |
| VRM_CONT_ALLOC_INTERIM_N2 | Non Unique | Default | REQUEST_ID, ALLOCATION_STATUS |
| VRM_CONT_ALLOC_INTERIM_N3 | Non Unique | Default | CUSTOMER_CONTRACT_HEADER_ID |
| VRM_CONT_ALLOC_INTERIM_U1 | Unique | Default | PERF_OBLIGATION_LINE_ID |