Revenue Scheduling Rule

The revenue scheduling rule view object contains information about invoicing and revenue scheduling rules, including rule names, business unit, reference set, type, active option, and number of periods. Invoicing rules determine when to recognize revenue on transactions. There are two invoicing rules: In Advance - recognize revenue immediately, In Arrears - recognize revenue according to the revenue scheduling rule assigned to the transaction. Revenue scheduling rules determine the accounting period or periods in which to record revenue distributions.

Data Store Key : FscmTopModelAM.FinExtractAM.ArBiccExtractAM.DistributionRuleExtractPVO

Primary Keys : DistributionRuleRuleId

Initial Extract Date : DistributionRuleCreationDate

Incremental Extract Date : DistributionRuleLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
DistributionRuleAttribute1 A segment of the Revenue Scheduling Rule descriptive flexfield 1.
DistributionRuleAttribute10 A segment of the Revenue Scheduling Rule descriptive flexfield 10.
DistributionRuleAttribute11 A segment of the Revenue Scheduling Rule descriptive flexfield 11.
DistributionRuleAttribute12 A segment of the Revenue Scheduling Rule descriptive flexfield 12.
DistributionRuleAttribute13 A segment of the Revenue Scheduling Rule descriptive flexfield 13.
DistributionRuleAttribute14 A segment of the Revenue Scheduling Rule descriptive flexfield 14.
DistributionRuleAttribute15 A segment of the Revenue Scheduling Rule descriptive flexfield 15.
DistributionRuleAttribute2 A segment of the Revenue Scheduling Rule descriptive flexfield 2.
DistributionRuleAttribute3 A segment of the Revenue Scheduling Rule descriptive flexfield 3.
DistributionRuleAttribute4 A segment of the Revenue Scheduling Rule descriptive flexfield 4.
DistributionRuleAttribute5 A segment of the Revenue Scheduling Rule descriptive flexfield 5.
DistributionRuleAttribute6 A segment of the Revenue Scheduling Rule descriptive flexfield 6.
DistributionRuleAttribute7 A segment of the Revenue Scheduling Rule descriptive flexfield 7.
DistributionRuleAttribute8 A segment of the Revenue Scheduling Rule descriptive flexfield 8.
DistributionRuleAttribute9 A segment of the Revenue Scheduling Rule descriptive flexfield 9.
DistributionRuleAttributeCategory The descriptive flexfield context name of the Revenue Scheduling Rule descriptive flexfield.
DistributionRuleCreatedBy The user who created the revenue scheduling rule.
DistributionRuleCreationDate The date and time the revenue scheduling rule was created.
DistributionRuleDeferredRevenueFlag The option that indicates whether to defer revenue on transactions that use the In Advance invoicing rule.
DistributionRuleDescription The description of the revenue scheduling rule.
DistributionRuleFrequency The frequency, such as weekly or monthly, to assign to the periods of a fixed or variable revenue scheduling rule.
DistributionRuleLastUpdateDate The date and time the revenue scheduling rule was last updated.
DistributionRuleLastUpdateLogin The session login of the user who last updated the revenue scheduling rule.
DistributionRuleLastUpdatedBy The user who last updated the revenue scheduling rule.
DistributionRuleModuleId Seed Data Framework: indicates the module that owns the revenue scheduling rule 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 isn't specified, then the Seed Data Framework won't extract the row as seed data.
DistributionRuleName The name of the revenue scheduling rule.
DistributionRuleObjectVersionNumber The number 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 revenue scheduling rule to detect whether another session has updated the row since it was queried.
DistributionRuleOccurrences The number of accounting dates over which to recognize revenue for the revenue scheduling rule.
DistributionRuleRuleId The identifier of the revenue scheduling rule.
DistributionRuleSeedDataSource The source of the revenue scheduling rule seed data record. A value of BULK_SEED_DATA_SCRIPT indicates that the record was uploaded in bulk. Otherwise, it specifies the name of the seed data file.
DistributionRuleSetId The revenue scheduling rule reference set.
DistributionRuleStatus The option that indicates the revenue scheduling rule status. A list of accepted values is defined in the lookup type CODE_STATUS.
DistributionRuleType The rule type of the revenue scheduling rule. Valid values are Daily Revenue Rate All Periods, Daily Revenue Rate Partial Periods, Variable Schedule, and Fixed Schedule.