AR_REV_ADJ_TRX_LINE_GL_DIST

Details

Schema: FUSION
Object owner: AR
Object type: TABLE

Columns

Name
CUST_TRX_LINE_GL_DIST_IDNUMBER18YesOracle internal use only. CUSTOMER_TRX_LINE_IDNUMBER18YesOracle internal use only. CODE_COMBINATION_IDNUMBER18YesOracle internal use only. SET_OF_BOOKS_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. PERCENTNUMBEROracle internal use only. AMOUNTNUMBEROracle internal use only. GL_DATEDATEOracle internal use only. GL_POSTED_DATEDATEOracle internal use only. CUST_TRX_LINE_SALESREP_IDNUMBER18Oracle internal use only. COMMENTSVARCHAR2240Oracle 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. CONCATENATED_SEGMENTSVARCHAR2240Oracle internal use only. ORIGINAL_GL_DATEDATEOracle internal use only. POST_REQUEST_IDNUMBER18Oracle internal use only. POSTING_CONTROL_IDNUMBER18YesOracle internal use only. ACCOUNT_CLASSVARCHAR220YesOracle internal use only. RA_POST_LOOP_NUMBERNUMBER18Oracle internal use only. CUSTOMER_TRX_IDNUMBER18YesOracle internal use only. ACCOUNT_SET_FLAGVARCHAR21YesOracle internal use only. ACCTD_AMOUNTNUMBEROracle 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. LATEST_REC_FLAGVARCHAR21Oracle internal use only. ORG_IDNUMBER18YesIndicates the identifier of the business unit associated to the row. COLLECTED_TAX_CCIDNUMBER18Oracle internal use only. COLLECTED_TAX_CONCAT_SEGVARCHAR2240Oracle internal use only. REVENUE_ADJUSTMENT_IDNUMBER18Oracle internal use only. REV_ADJ_CLASS_TEMPVARCHAR230Oracle internal use only. REC_OFFSET_FLAGVARCHAR21Oracle internal use only. EVENT_IDNUMBER18Oracle internal use only. USER_GENERATED_FLAGVARCHAR21Oracle 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. ROUNDING_CORRECTION_FLAGVARCHAR24Oracle internal use only. SESSION_IDNUMBER18Oracle internal use only.

Name

CUST_TRX_LINE_GL_DIST_IDNUMBER18YesOracle internal use only.

CUSTOMER_TRX_LINE_IDNUMBER18YesOracle internal use only.

CODE_COMBINATION_IDNUMBER18YesOracle internal use only.

SET_OF_BOOKS_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.

PERCENTNUMBEROracle internal use only.

AMOUNTNUMBEROracle internal use only.

GL_DATEDATEOracle internal use only.

GL_POSTED_DATEDATEOracle internal use only.

CUST_TRX_LINE_SALESREP_IDNUMBER18Oracle internal use only.

COMMENTSVARCHAR2240Oracle 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.

CONCATENATED_SEGMENTSVARCHAR2240Oracle internal use only.

ORIGINAL_GL_DATEDATEOracle internal use only.

POST_REQUEST_IDNUMBER18Oracle internal use only.

POSTING_CONTROL_IDNUMBER18YesOracle internal use only.

ACCOUNT_CLASSVARCHAR220YesOracle internal use only.

RA_POST_LOOP_NUMBERNUMBER18Oracle internal use only.

CUSTOMER_TRX_IDNUMBER18YesOracle internal use only.

ACCOUNT_SET_FLAGVARCHAR21YesOracle internal use only.

ACCTD_AMOUNTNUMBEROracle 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.

LATEST_REC_FLAGVARCHAR21Oracle internal use only.

ORG_IDNUMBER18YesIndicates the identifier of the business unit associated to the row.

COLLECTED_TAX_CCIDNUMBER18Oracle internal use only.

COLLECTED_TAX_CONCAT_SEGVARCHAR2240Oracle internal use only.

REVENUE_ADJUSTMENT_IDNUMBER18Oracle internal use only.

REV_ADJ_CLASS_TEMPVARCHAR230Oracle internal use only.

REC_OFFSET_FLAGVARCHAR21Oracle internal use only.

EVENT_IDNUMBER18Oracle internal use only.

USER_GENERATED_FLAGVARCHAR21Oracle 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.

ROUNDING_CORRECTION_FLAGVARCHAR24Oracle internal use only.

SESSION_IDNUMBER18Oracle internal use only.