AR_REV_ADJ_DEFERRED_LINES

Details

Schema: FUSION
Object owner: AR
Object type: TABLE

Columns

Name
CUSTOMER_TRX_LINE_IDNUMBERYesOracle internal use only. CUSTOMER_TRX_IDNUMBERYesOracle internal use only. ORIGINAL_COLLECTIBILITY_FLAGVARCHAR21YesOracle internal use only. LINE_COLLECTIBLE_FLAGVARCHAR21YesOracle internal use only. MANUAL_OVERRIDE_FLAGVARCHAR21Oracle internal use only. AMOUNT_DUE_ORIGINALNUMBEROracle internal use only. ACCTD_AMOUNT_DUE_ORIGINALNUMBEROracle internal use only. AMOUNT_RECOGNIZEDNUMBEROracle internal use only. ACCTD_AMOUNT_RECOGNIZEDNUMBEROracle internal use only. AMOUNT_PENDINGNUMBEROracle internal use only. ACCTD_AMOUNT_PENDINGNUMBEROracle internal use only. ATTRIBUTE_CATEGORYVARCHAR230Descriptive Flexfield: structure definition of the user descriptive flexfield. ATTRIBUTE1VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE2VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE3VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE4VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE5VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE6VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE7VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE8VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE9VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE10VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE11VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE12VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE13VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE14VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE15VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield. 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. PARENT_LINE_IDNUMBER18Oracle 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. SESSION_IDNUMBER18Oracle internal use only.

Name

CUSTOMER_TRX_LINE_IDNUMBERYesOracle internal use only.

CUSTOMER_TRX_IDNUMBERYesOracle internal use only.

ORIGINAL_COLLECTIBILITY_FLAGVARCHAR21YesOracle internal use only.

LINE_COLLECTIBLE_FLAGVARCHAR21YesOracle internal use only.

MANUAL_OVERRIDE_FLAGVARCHAR21Oracle internal use only.

AMOUNT_DUE_ORIGINALNUMBEROracle internal use only.

ACCTD_AMOUNT_DUE_ORIGINALNUMBEROracle internal use only.

AMOUNT_RECOGNIZEDNUMBEROracle internal use only.

ACCTD_AMOUNT_RECOGNIZEDNUMBEROracle internal use only.

AMOUNT_PENDINGNUMBEROracle internal use only.

ACCTD_AMOUNT_PENDINGNUMBEROracle internal use only.

ATTRIBUTE_CATEGORYVARCHAR230Descriptive Flexfield: structure definition of the user descriptive flexfield.

ATTRIBUTE1VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE2VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE3VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE4VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE5VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE6VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE7VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE8VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE9VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE10VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE11VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE12VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE13VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE14VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE15VARCHAR230Descriptive Flexfield: segment of the user descriptive flexfield.

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.

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

SESSION_IDNUMBER18Oracle internal use only.