1. Tables and Views for Financials
  2. VRM_REVENUE_ADJUSTMENTS_ALL

VRM_REVENUE_ADJUSTMENTS_ALL

The VRM_REVENUE_ADJUSTMENTS_ALL contains all information about revenue adjustments on transactions for on-line query, audit, and reporting. The primary key for this table is REVENUE_ADJUSTMENT_ID.

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

VRM_REVENUE_ADJUSTMENTS_A_PK

REVENUE_ADJUSTMENT_ID

Columns

Name Datatype Length Precision Not-null Comments Status
REVENUE_ADJUSTMENT_ID NUMBER 18 Yes Revenue adjustment unique identifier. Active
REVENUE_ADJUSTMENT_NUMBER VARCHAR2 20 Yes Revenue adjustment reference number. Active
REVENUE_DOCUMENT_ID NUMBER 18 Yes Revenue document unique identifier. Active
DOC_LINE_ID_INT_1 NUMBER 38 Not currently used. Active
DOC_LINE_ID_INT_2 NUMBER 38 Not currently used. Active
DOC_LINE_ID_INT_3 NUMBER 38 Not currently used. Active
DOC_LINE_ID_INT_4 NUMBER 38 Not currently used. Active
DOC_LINE_ID_INT_5 NUMBER 38 Not currently used. Active
DOC_LINE_ID_CHAR_1 VARCHAR2 30 Not currently used. Active
DOC_LINE_ID_CHAR_2 VARCHAR2 30 Not currently used. Active
DOC_LINE_ID_CHAR_3 VARCHAR2 30 Not currently used. Active
DOC_LINE_ID_CHAR_4 VARCHAR2 30 Not currently used. Active
DOC_LINE_ID_CHAR_5 VARCHAR2 30 Not currently used. Active
DOC_ID_INT_1 NUMBER 38 Not currently used. Active
DOC_ID_INT_2 NUMBER 38 Not currently used. Active
DOC_ID_INT_3 NUMBER 38 Not currently used. Active
DOC_ID_INT_4 NUMBER 38 Not currently used. Active
DOC_ID_INT_5 NUMBER 38 Not currently used. Active
DOC_ID_CHAR_1 VARCHAR2 30 Not currently used. Active
DOC_ID_CHAR_2 VARCHAR2 30 Not currently used. Active
DOC_ID_CHAR_3 VARCHAR2 30 Not currently used. Active
DOC_ID_CHAR_4 VARCHAR2 30 Not currently used. Active
DOC_ID_CHAR_5 VARCHAR2 30 Not currently used. Active
ADJUSTMENT_DATE DATE Date of the revenue adjustment. Active
AMOUNT_MODE VARCHAR2 15 Specifies whether an amount, percentage or all revenue is to be adjusted. Active
AMOUNT NUMBER Amount of revenue that is adjusted, in transaction currency. Active
ACCTD_AMOUNT NUMBER Amount of revenue that is adjusted, in functional currency. Active
PERCENT NUMBER Percentage of revenue that is adjusted. Active
LINE_SELECTION_MODE VARCHAR2 15 Determines how revenue document lines are selected for adjustment. Active
FROM_CATEGORY_ID NUMBER 18 Oracle internal use only.
TO_CATEGORY_ID NUMBER 18 Oracle internal use only.
FROM_INVENTORY_ITEM_ID NUMBER 18 Item unique identifier that revenue is adjusted from. Active
TO_INVENTORY_ITEM_ID NUMBER 18 Item unique identifier that revenue is adjusted to. Active
FROM_REV_DOC_LINE_ID NUMBER 18 Revenue document line unique identifier revenue is adjusted from. Active
TO_REV_DOC_LINE_ID NUMBER 18 Revenue document line unique identifier revenue is adjusted to. Active
ACCOUNTING_DATE DATE Accounting date of the revenue adjustment. Active
TYPE VARCHAR2 15 Indicates the type of revenue adjustment. Active
REASON_CODE VARCHAR2 15 Indicates the reason for the revenue adjustment. Active
COMMENTS VARCHAR2 2000 Further information to supplement revenue adjustment reason. Active
STATUS VARCHAR2 30 Indicates revenue adjustment status. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
FROM_SALESGROUP_ID NUMBER Sales group unique identifier that revenue is adjusted from. Active
TO_SALESGROUP_ID NUMBER Sales group unique identifier that revenue is adjusted to. Active
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. Active
FROM_RESOURCE_SALESREP_ID NUMBER Salesperson unique identifier that revenue is adjusted from. Active
TO_RESOURCE_SALESREP_ID NUMBER Salesperson unique identifier that revenue is adjusted to. Active
SALES_CREDIT_TYPE VARCHAR2 15 Indicates type of sales credit that is adjusted. Active
DESCRIPTION VARCHAR2 960 Description of the revenue adjustment.
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
LATEST_REC_FLAG VARCHAR2 1 Indicates the latest record with an account type of recognition status. Possible values are Yes or No.
REVENUE_REVERSAL_METHOD VARCHAR2 30 Revenue reversal method used to reverse the revenue.
UNIT_SELLING_PRICE NUMBER Unit selling price of the source document.
QUANTITY NUMBER Quantity of a revenue line.
RULE_START_DATE DATE Start date for revenue recognition when utilizing the Daily Revenue Rate, All Periods or Daily Revenue Rate, Partial Periods revenue rule types.
RULE_END_DATE DATE End date for revenue recognition when utilizing the Daily Revenue Rate, All Periods or Daily Revenue Rate, Partial Periods revenue rule types.
REVENUE_RULE_ID NUMBER 18 Revenue scheduling rule unique identifier.
RULE_DURATION NUMBER Duration for the revenue schedules when using a Variable Schedule rule type. Number of periods to recognize revenue.
UNIT_CARVE_OUT_PRICE NUMBER Unit carve-out price of a revenue line.
DEFAULT_CARVE_OUT_ADJ_PERCENT NUMBER Default carve-out adjustment percentage of a revenue line.
LATEST_CARVEOUT_ADJ_FLAG VARCHAR2 1 Indicates the last adjustment created by the revenue adjustment carve-out process. Possible values are Yes or No.
DOCUMENT_LINE_ID NUMBER 18 Document line unique identifier.
MEA_CARVEOUT_LINE_ID NUMBER 18 Carve-out line identifier created for the compliance adjustment.
CONTINGENCY_ID NUMBER 18 Revenue contingency unique identifier.

Foreign Keys

Table Foreign Table Foreign Key Column
VRM_REVENUE_ADJUSTMENTS_ALL vrm_revenue_documents_all REVENUE_DOCUMENT_ID
VRM_REVENUE_ADJUSTMENTS_ALL vrm_revenue_doc_lines_all FROM_REV_DOC_LINE_ID
VRM_REVENUE_ADJUSTMENTS_ALL vrm_revenue_doc_lines_all TO_REV_DOC_LINE_ID
VRM_REVENUE_ADJUSTMENTS_ALL jtf_rs_salesreps FROM_RESOURCE_SALESREP_ID
VRM_REVENUE_ADJUSTMENTS_ALL jtf_rs_salesreps TO_RESOURCE_SALESREP_ID

Indexes

Index Uniqueness Tablespace Columns
VRM_REVENUE_ADJUSTMENTS_ALL_U1 Unique Default REVENUE_ADJUSTMENT_ID
VRM_REVENUE_ADJUSTMENTS_N1 Non Unique Default FROM_REV_DOC_LINE_ID, TYPE
VRM_REVENUE_ADJUSTMENTS_N2 Non Unique Default REQUEST_ID
VRM_REVENUE_ADJUSTMENTS_N3 Non Unique Default REVENUE_DOCUMENT_ID
VRM_REVENUE_ADJUSTMENTS_N4 Non Unique Default MEA_CARVEOUT_LINE_ID