VRM_CREATE_CARVEOUTS_INT
VRM_CREATE_CARVEOUTS_INT contains carve out adjustment information during carve out creation process.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
VRM_CREATE_CARVEOUTS_INT_PK |
DOCUMENT_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_LINE_ID | NUMBER | 18 | Yes | Internal unique identifier of a source document line. | |
| MEA_NUMBER | NUMBER | 18 | Yes | Unique number of a MEA transaction. | |
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code of the MEA transaction. | |
| ADJUSTMENT_METHOD | VARCHAR2 | 10 | Yes | Carve-out method that specifies a revenue complaince adjustment for a MEA. The valid values from VRM_MEA_CRAVEOUT_METHOD lookup are Relative and Residual. | |
| TOTAL_HDR_FMV_AMOUNT | NUMBER | Total fair market value amount of the MEA. | |||
| PARENT_LINE_ID | NUMBER | 18 | Unique identifier of a MEA parent line. | ||
| TOTAL_LINE_FMV_AMOUNT | NUMBER | Fair market value amount of the MEA 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 | A fair market value of an item, item group, or memo line in entered currency. | |||
| DOCUMENT_DATE | DATE | Date of source document. | |||
| UNIT_REVENUE_PRICE | NUMBER | Unit revenue price of a line to be recognized by a revenue recognition process. | |||
| DELIVERY_STATUS | VARCHAR2 | 30 | Delivery status of a source document. Values are from the lookup VRM_MEA_LINE_DELIVERY_STATUS. | ||
| FMV_REPRESENTATION_TYPE | VARCHAR2 | 30 | FMV price representation type. The value is derived from 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 in terms of percentage of base price. | |||
| LINE_AMOUNT | NUMBER | Line amount of the source document. | |||
| ADJ_REV_UNIT_PRICE | NUMBER | Unit revenue price after a carve out adjustment. | |||
| ADJ_REV_LINE_AMOUNT | NUMBER | Revenue line amount for a MEA line after a carve out adjustment. | |||
| ADJ_REV_UNIT_LIST_PRICE_DISC | NUMBER | Unit list price discount percentage after a carve out adjustment. | |||
| ADJ_REV_BASE_PRICE_PERCENT | NUMBER | Base price percentage after a carve out adjustment. | |||
| REQUEST_ID | NUMBER | 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 | 10 | Indicates the fair market value tolerance range level used to calculate the carve-out adjustment. | ||
| BATCH_NUMBER | NUMBER | Identifies the batch to be processed. | |||
| FMV_LINE_ID | NUMBER | 18 | Fair market value line identifier. | ||
| 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 in terms of unit selling price, discount percent, or any other representation type. | |||
| COMPLIANCE_STATUS | VARCHAR2 | 30 | Compliance status of a MEA. Values are from the lookup VRM_MEA_COMPLIANCE_STATUS. | ||
| BASE_PRICE | NUMBER | Base price used to validate the VSOE value of a MEA line. | |||
| UNIT_LIST_PRICE | NUMBER | Unit list price percent used to validate the VSOE value of a MEA line. | |||
| MFMV_LINE_ID | NUMBER | 18 | MEA fair market value line identifier. | ||
| NET_UNIT_SALES_PRICE | NUMBER | Unit selling price after adjusting return amount. | |||
| NET_DISCOUNT_PCT | NUMBER | Discount percentage after adjusting return amount. | |||
| NET_UNIT_SALES_PCT_BASE_PRICE | NUMBER | 18 | Unit sales percent base price after adjusting 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 return amount. | |||
| DELIVERED_FLAG | VARCHAR2 | 1 | Flag that indicates a delivery status of a source document. | ||
| MEA_ID | NUMBER | 18 | MEA transaction unique identifier. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_CREATE_CARVEOUTS_INT_N1 | Non Unique | Default | REQUEST_ID, BATCH_NUMBER |
| VRM_CREATE_CARVEOUTS_INT_U1 | Unique | Default | DOCUMENT_LINE_ID |