AR_REV_ADJ_TRX_LINE_SREPS_GT

This is a temporary table which is used internally by Oracle.

Details

• Schema: FUSION

• Object owner: AR

• Object type: TABLE

Columns

Name

CUST_TRX_LINE_SALESREP_IDNUMBER18YesOracle internal use only. CREATED_BYVARCHAR264YesWho column: indicates the user who created the row. CREATION_DATETIMESTAMPYesWho column: indicates the date and time of the creation of the row. LAST_UPDATED_BYVARCHAR264YesWho column: indicates the user who last updated the row. LAST_UPDATE_DATETIMESTAMPYesWho column: indicates the date and time of the last update of the row. LAST_UPDATE_LOGINVARCHAR232Who column: indicates the session login associated to the user who last updated the row. CUSTOMER_TRX_IDNUMBER18YesOracle internal use only. SALESREP_IDNUMBER18Oracle internal use only. CUSTOMER_TRX_LINE_IDNUMBER18Oracle internal use only. REVENUE_AMOUNT_SPLITNUMBEROracle internal use only. NON_REVENUE_AMOUNT_SPLITNUMBEROracle internal use only. ATTRIBUTE_CATEGORYVARCHAR230Descriptive Flexfield: structure definition of the user descriptive flexfield. ATTRIBUTE1VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE2VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE3VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE4VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE5VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE6VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE7VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE8VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE9VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE10VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. REQUEST_IDNUMBER18Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. PROGRAM_APPLICATION_IDNUMBER18Oracle internal use only. PROGRAM_IDNUMBER18Oracle internal use only. PROGRAM_UPDATE_DATEDATEOracle internal use only. NON_REVENUE_PERCENT_SPLITNUMBEROracle internal use only. REVENUE_PERCENT_SPLITNUMBEROracle internal use only. ORIGINAL_LINE_SALESREP_IDNUMBER18Oracle internal use only. PREV_CUST_TRX_LINE_SALESREP_IDNUMBER18Oracle internal use only. ATTRIBUTE11VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE12VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE13VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE14VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE15VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield. ORG_IDNUMBER18YesIndicates the identifier of the business unit associated to the row. WH_UPDATE_DATEDATEOracle internal use only. REVENUE_ADJUSTMENT_IDNUMBER18Oracle internal use only. REVENUE_SALESGROUP_IDNUMBEROracle internal use only. NON_REVENUE_SALESGROUP_IDNUMBEROracle internal use only. OBJECT_VERSION_NUMBERNUMBER9YesUsed 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. RESOURCE_SALESREP_IDNUMBER18YesOracle internal use only. SESSION_IDNUMBER18Oracle internal use only.