1. Extract Data Stores for Financials
  2. Revenue Adjustment

Revenue Adjustment

The revenue adjustment view object contains information about revenue adjustments, including business unit, name, revenue adjusted transaction, revenue adjustment date, adjusted amount, adjusted percentage, revenue category adjustment, transaction line, accounting date, revenue adjustment type, revenue adjustment status, revenue adjustment reason, salesperson, and sales credit type.

Data Store Key : FscmTopModelAM.FinExtractAM.ArBiccExtractAM.RevenueAdjustmentExtractPVO

Primary Keys : ArRevenueAdjustmentRevenueAdjustmentId

Initial Extract Date : ArRevenueAdjustmentCreationDate

Incremental Extract Date : ArRevenueAdjustmentLastUpdateDate

Attributes

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

Name Description
ArRevenueAdjustmentAmount The amount of revenue adjusted in the transaction currency.
ArRevenueAdjustmentAmountMode The revenue amount adjusted on the transaction. Valid values are: T - Total revenue amount, A - Specific revenue amount, and P - Percentage of the total revenue amount.
ArRevenueAdjustmentApplicationDate The revenue adjustment date.
ArRevenueAdjustmentAttribute1 A segment of the Revenue Adjustment descriptive flexfield 1.
ArRevenueAdjustmentAttribute10 A segment of the Revenue Adjustment descriptive flexfield 10.
ArRevenueAdjustmentAttribute11 A segment of the Revenue Adjustment descriptive flexfield 11.
ArRevenueAdjustmentAttribute12 A segment of the Revenue Adjustment descriptive flexfield 12.
ArRevenueAdjustmentAttribute13 A segment of the Revenue Adjustment descriptive flexfield 13.
ArRevenueAdjustmentAttribute14 A segment of the Revenue Adjustment descriptive flexfield 14.
ArRevenueAdjustmentAttribute15 A segment of the Revenue Adjustment descriptive flexfield 15.
ArRevenueAdjustmentAttribute2 A segment of the Revenue Adjustment descriptive flexfield 2.
ArRevenueAdjustmentAttribute3 A segment of the Revenue Adjustment descriptive flexfield 3.
ArRevenueAdjustmentAttribute4 A segment of the Revenue Adjustment descriptive flexfield 4.
ArRevenueAdjustmentAttribute5 A segment of the Revenue Adjustment descriptive flexfield 5.
ArRevenueAdjustmentAttribute6 A segment of the Revenue Adjustment descriptive flexfield 6.
ArRevenueAdjustmentAttribute7 A segment of the Revenue Adjustment descriptive flexfield 7.
ArRevenueAdjustmentAttribute8 A segment of the Revenue Adjustment descriptive flexfield 8.
ArRevenueAdjustmentAttribute9 A segment of the Revenue Adjustment descriptive flexfield 9.
ArRevenueAdjustmentAttributeCategory The descriptive flexfield context name of the Revenue Adjustment descriptive flexfield.
ArRevenueAdjustmentComments The user-entered comments about the revenue adjustment.
ArRevenueAdjustmentCreatedBy The user who created the revenue adjustment.
ArRevenueAdjustmentCreationDate The date and time the revenue adjustment was created.
ArRevenueAdjustmentCustomerTrxId The identifier of the transaction that had revenue adjusted.
ArRevenueAdjustmentFromCategoryId The identifier of the transaction line item category, such as Software or Hardware, from which revenue is adjusted. The item is associated to the category when the transaction line is created.
ArRevenueAdjustmentFromCustTrxLineId The identifier of the transaction line that had revenue adjusted.
ArRevenueAdjustmentFromInventoryItemId The identifier of the inventory transaction line that had revenue adjusted.
ArRevenueAdjustmentFromResourceSalesrepId The identifier of an individual salesperson that had sales credits transferred.
ArRevenueAdjustmentFromSalesgroupId The identifier of a group of salespersons that had sales credits transferred.
ArRevenueAdjustmentGlDate The default accounting date for revenue adjustment accounting.
ArRevenueAdjustmentLastUpdateDate The date and time the revenue adjustment was last updated.
ArRevenueAdjustmentLastUpdateLogin The session login of the user who last updated the revenue adjustment.
ArRevenueAdjustmentLastUpdatedBy The user who last updated the revenue adjustment.
ArRevenueAdjustmentLineSelectionMode The value that indicates the part of the transaction has revenue adjusted. Valid values are: A - ALL_LINES, C - SPEC_CAT, I - SPEC_ITEM, and S - SPEC_LINE.
ArRevenueAdjustmentObjectVersionNumber 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 adjustment to detect whether another session has updated the row since it was queried.
ArRevenueAdjustmentOrgId The identifier of the business unit associated with the revenue adjustment.
ArRevenueAdjustmentPercent The percentage of revenue that is adjusted.
ArRevenueAdjustmentProgramApplicationId The identifier of the application that last updated the revenue adjustment (foreign key to FND_APPLICATION.APPLICATION_ID).
ArRevenueAdjustmentProgramId The identifier of the process that last updated the revenue adjustment (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
ArRevenueAdjustmentProgramUpdateDate The date when a process last updated the revenue adjustment.
ArRevenueAdjustmentReasonCode The reason for the revenue adjustment.
ArRevenueAdjustmentRequestId The request identifier of the process that created or last updated the revenue adjustment.
ArRevenueAdjustmentRevenueAdjustmentId The identifier of the Receivable transaction revenue adjustment.
ArRevenueAdjustmentRevenueAdjustmentNumber The revenue adjustment reference number.
ArRevenueAdjustmentSalesCreditType The type of sales credit applied to the transaction. Valid values are: N - Nonrevenue Sales Credits, R - Revenue Sales Credits, B - Both Revenue and Nonrevenue Sales Credits.
ArRevenueAdjustmentStatus The status of the revenue adjustment.
ArRevenueAdjustmentToCategoryId The identifier of the transaction line item category that the revenue adjustment is transferred to.
ArRevenueAdjustmentToCustTrxLineId The identifier of the transaction line that the revenue adjustment is associated with (primary key of RA_CUSTOMER_TRX_LINES_ALL).
ArRevenueAdjustmentToInventoryItemId The identifier of the transaction line inventory item that the revenue adjustment is transferred to.
ArRevenueAdjustmentToResourceSalesrepId The identifier of the salesperson to whom sales credits are transferred for the revenue adjustment.
ArRevenueAdjustmentToSalesgroupId The identifier of the group of salespersons to whom sales credits are transferred for the revenue adjustment.
ArRevenueAdjustmentType The type of revenue adjustment. Valid types are: EA - Scheduled Revenue, UN - Unscheduled Revenue, SA - Sales Credits Transfer, and NR - Add Nonrevenue Sales Credits.