VRM_REV_ADJ_TEMP_ALL
The VRM_REV_ADJ_TEMP_ALL table contains information about revenue adjustments on transactions for online query, audit, and reporting.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
VRM_REV_ADJ_TEMP_ALL_PK |
REVENUE_DOCUMENT_ID, REQUEST_IDENTIFIER, ADJUSTMENT_TYPE, FROM_REVENUE_DOCUMENT_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REVENUE_DOCUMENT_ID | NUMBER | 18 | Yes | Revenue document unique identifier. | |
| REQUEST_IDENTIFIER | NUMBER | Yes | Request identifier. | ||
| ADJUSTMENT_TYPE | VARCHAR2 | 15 | Yes | Revenue adjustment type. | |
| FROM_REVENUE_DOCUMENT_LINE_ID | NUMBER | 18 | Yes | Revenue document line identifier from that revenue is adjusted from. | |
| DOCUMENT_NUMBER | VARCHAR2 | 20 | Document number of a source document. | ||
| FROM_SALESREP_ID | NUMBER | 18 | From salesperson unique identifier. | ||
| FROM_SALESREP_NUMBER | VARCHAR2 | 30 | From salesperson number. | ||
| TO_SALESREP_ID | NUMBER | 18 | To salesperson unique identifier. | ||
| TO_SALESREP_NUMBER | VARCHAR2 | 30 | To salesperson number. | ||
| FROM_SALESGROUP_ID | NUMBER | Sales group unique identifier that revenue is adjusted from. | |||
| TO_SALESGROUP_ID | NUMBER | Sales group unique identifier that revenue is adjusted to. | |||
| SALES_CREDIT_TYPE | VARCHAR2 | 15 | Indicates type of sales credit that is adjusted. | ||
| AMOUNT_MODE | VARCHAR2 | 15 | Specifies whether an amount, percentage or all revenue is to be adjusted. | ||
| AMOUNT | NUMBER | Credit amount of a revenue document. | |||
| PERCENT | NUMBER | Percentage of revenue that is adjusted. | |||
| LINE_SELECTION_MODE | VARCHAR2 | 15 | Identifies revenue document lines selection mode for adjustment. | ||
| FROM_CATEGORY_ID | NUMBER | 18 | Item category unique identifier that revenue is adjusted from. | ||
| TO_CATEGORY_ID | NUMBER | 18 | Item category unique identifier that revenue is adjusted to. | ||
| FROM_INVENTORY_ITEM_ID | NUMBER | 18 | Item unique identifier that revenue is adjusted from. | ||
| TO_INVENTORY_ITEM_ID | NUMBER | 18 | Item unique identifier that revenue is adjusted to. | ||
| FROM_LINE_NUMBER | NUMBER | 18 | Line number that revenue is adjusted from. | ||
| TO_REVENUE_DOCUMENT_LINE_ID | NUMBER | 18 | Revenue document line identifier that revenue is adjusted to. | ||
| TO_LINE_NUMBER | NUMBER | 18 | Line number that revenue is adjusted to. | ||
| ACCOUNTING_DATE | DATE | Accounting date of the revenue document. | |||
| REASON_CODE | VARCHAR2 | 30 | Indicates the reason for the revenue adjustment. | ||
| COMMENTS | VARCHAR2 | 2000 | User entered comments. | ||
| SOURCE | VARCHAR2 | 30 | Indicates source application. The examples are Order Management, Contracts etc. | ||
| SESSION_ID | NUMBER | Oracle internal use only. | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| FROM_RESOURCE_SALESREP_ID | NUMBER | 18 | Salesperson unique identifier that revenue is adjusted from. | ||
| TO_RESOURCE_SALESREP_ID | NUMBER | 18 | Salesperson unique identifier that revenue is adjusted to. | ||
| 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_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_REV_ADJ_TEMP_U1 | Unique | Default | REVENUE_DOCUMENT_ID, REQUEST_IDENTIFIER, ADJUSTMENT_TYPE, FROM_REVENUE_DOCUMENT_LINE_ID |