1. Tables and Views for Financials
  2. VRM_REVENUE_RULES

VRM_REVENUE_RULES

The VRM_RULES table stores invoicing and accounting rules. Receivables creates one row in this table for each invoicing and accounting rule that you define. . Receivables uses invoicing rules to determine when to recognize a receivable for invoices that span more than one accounting period. Assign invoicing rules to invoices that are manually entered or imported into Receivables through AutoInvoice. Receivables provides two invoicing rules: the Bill in Advance rule tells Receivables to recognize your receivable immediately, while the Bill in Arrears rule tells Receivables to recognize the receivable at the end of the revenue recognition schedule. . Receivables uses accounting rules to determine revenue recognition schedules for invoice lines. Receivables stores revenue recognition schedules in the RA_RULE_SCHEDULES table. Use accounting rules to specify the number of periods and the percentage of the total revenue to recognize in each period. . The primary key for this table is RULE_ID.

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

VRM_REVENUE_RULES_PK

REVENUE_RULE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
REVENUE_RULE_ID NUMBER 18 Yes Unique identifier or a revenue scheduling rule. Active
NAME VARCHAR2 30 Yes Name of a revenue scheduling rule. Active
TYPE VARCHAR2 30 Yes Type of the revenue scheduling rule. Active
STATUS VARCHAR2 1 Yes Status of a revenue scheduling rule. Active
FREQUENCY VARCHAR2 15 Revenue scheduling rule frequency, such as daily or weekly. Active
OCCURRENCES NUMBER Number of accounting dates to recognize revenue. Active
DESCRIPTION VARCHAR2 80 Revenue scheduling rule description. Active
DEFERRED_REVENUE_FLAG VARCHAR2 1 Flag that determines the deferred option. Active
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
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
SET_ID NUMBER 18 Yes Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs. Active
MID_PERIOD_FLAG VARCHAR2 1 Flag that indicates if the rule used is mid period logic. Active
REVENUE_RECOGNITION VARCHAR2 30 Revenue recognition type to recognize revenue. The values are first day of the month, last day of the month, or as per the rule date (BLANK). 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
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
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.

Foreign Keys

Table Foreign Table Foreign Key Column
vrm_revenue_doc_lines_all vrm_revenue_rules REVENUE_RULE_ID
vrm_revenue_rule_schedules vrm_revenue_rules REVENUE_RULE_ID

Indexes

Index Uniqueness Tablespace Columns Status
VRM_REVENUE_RULES_U1 Unique FUSION_TS_SEED REVENUE_RULE_ID Active