AR_REVENUE_ADJUSTMENTS_GT

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

Details

• Schema: FUSION

• Object owner: AR

• Object type: TABLE

Columns

Name

REVENUE_ADJUSTMENT_IDNUMBER18YesOracle internal use only. REVENUE_ADJUSTMENT_NUMBERVARCHAR220YesOracle internal use only. CUSTOMER_TRX_IDNUMBER18YesOracle internal use only. APPLICATION_DATEDATEOracle internal use only. AMOUNT_MODEVARCHAR215Oracle internal use only. AMOUNTNUMBEROracle internal use only. PERCENTNUMBEROracle internal use only. LINE_SELECTION_MODEVARCHAR215Oracle internal use only. FROM_CATEGORY_IDNUMBER18Oracle internal use only. TO_CATEGORY_IDNUMBER18Oracle internal use only. FROM_INVENTORY_ITEM_IDNUMBER18Oracle internal use only. TO_INVENTORY_ITEM_IDNUMBER18Oracle internal use only. FROM_CUST_TRX_LINE_IDNUMBER18Oracle internal use only. TO_CUST_TRX_LINE_IDNUMBER18Oracle internal use only. GL_DATEDATEOracle internal use only. TYPEVARCHAR215Oracle internal use only. REASON_CODEVARCHAR215Oracle internal use only. COMMENTSVARCHAR22000Oracle internal use only. STATUSVARCHAR230Oracle 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. 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. 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. PROGRAM_APPLICATION_IDNUMBER18Oracle internal use only. PROGRAM_IDNUMBER18Oracle internal use only. PROGRAM_UPDATE_DATEDATEOracle internal use only. REQUEST_IDNUMBER18Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. ORG_IDNUMBER18YesIndicates the identifier of the business unit associated to the row. FROM_SALESGROUP_IDNUMBEROracle internal use only. TO_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. FROM_RESOURCE_SALESREP_IDNUMBEROracle internal use only. TO_RESOURCE_SALESREP_IDNUMBEROracle internal use only. SALES_CREDIT_TYPEVARCHAR215Oracle internal use only. SESSION_IDNUMBER18Oracle internal use only.