AR_REV_ADJ_LINE_CONTS

Details

Schema: FUSION
Object owner: AR
Object type: TABLE

Columns

Name
CUSTOMER_TRX_LINE_IDNUMBERYesOracle internal use only. CONTINGENCY_CODEVARCHAR230YesOracle internal use only. EXPIRATION_DATEDATEOracle internal use only. EXPIRATION_DAYSNUMBEROracle internal use only. COMPLETED_FLAGVARCHAR21Oracle internal use only. ORG_IDNUMBER18YesIndicates the identifier of the business unit associated to the row. REQUEST_IDNUMBER18Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. 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. EXPIRATION_EVENT_DATEDATEOracle internal use only. REASON_REMOVAL_DATEDATEOracle internal use only. COMPLETED_BYNUMBEROracle internal use only. DEFAULTED_IN_AR_FLAGVARCHAR21Oracle internal use only. CONTINGENCY_IDNUMBER18YesOracle 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. COMMENTSVARCHAR22000Oracle internal use only.

Name

CUSTOMER_TRX_LINE_IDNUMBERYesOracle internal use only.

CONTINGENCY_CODEVARCHAR230YesOracle internal use only.

EXPIRATION_DATEDATEOracle internal use only.

EXPIRATION_DAYSNUMBEROracle internal use only.

COMPLETED_FLAGVARCHAR21Oracle internal use only.

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

REQUEST_IDNUMBER18Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.

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.

EXPIRATION_EVENT_DATEDATEOracle internal use only.

REASON_REMOVAL_DATEDATEOracle internal use only.

COMPLETED_BYNUMBEROracle internal use only.

DEFAULTED_IN_AR_FLAGVARCHAR21Oracle internal use only.

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

COMMENTSVARCHAR22000Oracle internal use only.