VRM_RECUR_SRC_DATA_GT
VRM_RECUR_SRC_DATA_GT contains information about recurring source data during the renewal processing.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_LINE_ID | NUMBER | 18 | Yes | System-generated unique key for the source document line. Examples of source document lines include sales order lines, invoice lines, project lines, and service contract lines. | |
| DOCUMENT_ID | NUMBER | 18 | Source document identifier of the line. | ||
| DOCUMENT_GROUP_ID | NUMBER | 18 | Source document group identifier used to group the initial recurring source document header and system-generated recurring source document headers. Value is the source document identifier for the original source document. | ||
| DOCUMENT_DATE | DATE | Date of the source document, such as the book date for a sales order, or the invoice date for an invoice. | |||
| PLAN_START_DATE | DATE | Revenue recoginition start date for revenue rule types, such as daily revenue rate, all periods or daily revenue rate, and partial periods. | |||
| PLAN_END_DATE | DATE | Revenue recoginition end date for revenue rule types, such as daily revenue rate, all periods or daily revenue rate, and partial periods. | |||
| LINE_AMOUNT | NUMBER | Selling amount on a source document line. | |||
| QUANTITY | NUMBER | Quantity of inventory item or memo line on a source document line. | |||
| UNIT_SELLING_PRICE | NUMBER | Selling price per unit of measure of the inventory item or memo line. | |||
| COST_AMOUNT | NUMBER | Cost of inventory item or memo line. This column is used to calculate the gross margin percentage. | |||
| GROSS_MARGIN_PERCENT | NUMBER | Gross margin percentage for the source document line. This column is used in standalone selling price computation for the gross margin percentage standalone selling price representation type. | |||
| UOM_CODE | VARCHAR2 | 200 | Code indicating the measure of the inventory item or memo line. | ||
| ACCOUNTING_RULE_DURATION | NUMBER | Number of periods in which revenue is to be recognized. | |||
| ACCOUNTING_RULE_ID | NUMBER | 18 | Revenue scheduling rule identifier on the source document line. The revenue scheduling rule determines the timing of revenue recognition. | ||
| ACCOUNTING_RULE_NAME | VARCHAR2 | 30 | Revenue scheduling rule name on the source document line. The revenue scheduling rule determines the timing of revenue recognition. | ||
| RECURRING_PATTERN_CODE | VARCHAR2 | 30 | Recurring frequency of the line. Valid values are from the lookup type VRM_RECUR_PATTERN_CODE. | ||
| RECURRING_AMOUNT | NUMBER | Selling amount per frequency for the recurring line. | |||
| RECURRING_FREQUENCY | NUMBER | Frequency number of the recurring pattern. | |||
| TERMINATION_DATE | DATE | Date the line was terminated and will no longer recur automatically. | |||
| LINE_TYPE_CODE | VARCHAR2 | 30 | Source document recurring line type. Valid values are Terminated Line if the line has a past termination date, Active Line if the termination date is in the future, or blank. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifier of source document. | ||
| CONTRACT_GROUP_NUMBER | VARCHAR2 | 320 | Concatenation of the original customer contract's source document number and customer contract number for the recurring line. | ||
| RECUR_HEADER_COPY_NUM | NUMBER | 18 | Number of times the recurring source document header was copied. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code of the source document line. The value corresponds with the currency code values available in Oracle Fusion General Ledger. | ||
| DOC_LINE_ID_INT_1 | NUMBER | First numeric column of the key that identifies source document line in source application. | |||
| DOC_LINE_ID_INT_2 | NUMBER | Second numeric column of the key that identifies source document line in source application. | |||
| DOC_LINE_ID_INT_3 | NUMBER | Third numeric column of the key that identifies source document line in source application. | |||
| DOC_LINE_ID_INT_4 | NUMBER | Fourth numeric column of the key that identifies source document line in source application. | |||
| DOC_LINE_ID_INT_5 | NUMBER | Fifth numeric column of the key that identifies source document line in source application. | |||
| DOC_LINE_ID_CHAR_1 | VARCHAR2 | 30 | First character column of the key that identifies source document line in source application. | ||
| DOC_LINE_ID_CHAR_2 | VARCHAR2 | 30 | Second character column of the key that identifies source document line in source application. | ||
| DOC_LINE_ID_CHAR_3 | VARCHAR2 | 2030 | Third character column of the key that identifies source document line in source application. | ||
| DOC_LINE_ID_CHAR_4 | VARCHAR2 | 30 | Fourth character column of the key that identifies source document line in source application. | ||
| DOC_LINE_ID_CHAR_5 | VARCHAR2 | 30 | Fifth character column of the key that identifies source document line in source application. | ||
| DOCUMENT_TYPE_ID | NUMBER | 18 | Source document type identifier of various source systems which integrate with revenue management. | ||
| SOURCE_SYSTEM | VARCHAR2 | 120 | Source application of document data to identify source document sub line. Each integrating application has a unique value, such as EBIZ. | ||
| RECUR_LINE_COPY_NUM | NUMBER | 18 | Sequence number of the recurring source document line. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_RECUR_SRC_DATA_GT_N1 | Non Unique | DOCUMENT_GROUP_ID, DOCUMENT_DATE, RECUR_HEADER_COPY_NUM, LINE_TYPE_CODE |
| VRM_RECUR_SRC_DATA_GT_N2 | Non Unique | LINE_TYPE_CODE |
| VRM_RECUR_SRC_DATA_GT_U1 | Unique | DOCUMENT_LINE_ID |