1. Tables and Views for Financials
  2. AR_TRX_DIST_GT

AR_TRX_DIST_GT

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

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

Columns

Name

TRX_HEADER_IDNUMBER18Oracle internal use only

TRX_DIST_IDNUMBER18Oracle internal use only

TRX_LINE_IDNUMBER18Oracle internal use only

ACCOUNT_CLASSVARCHAR220Oracle internal use only

AMOUNTNUMBEROracle internal use only

ACCTD_AMOUNTNUMBEROracle internal use only

PERCENTNUMBEROracle internal use only

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

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

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

SET_OF_BOOKS_IDNUMBER18Oracle internal use only

GL_DATEDATEOracle internal use only

GL_POSTED_DATEDATEOracle internal use only

CUSTOMER_TRX_IDNUMBER18Oracle internal use only

CUSTOMER_TRX_LINE_IDNUMBER18Oracle internal use only

CUST_TRX_LINE_SALESREP_IDNUMBER18Oracle internal use only

ACCOUNT_SET_FLAGVARCHAR21Oracle internal use only

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

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.

COMMENTSVARCHAR2240Oracle internal use only

SEGMENT1VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT2VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT3VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT4VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT5VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT6VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT7VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT8VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT9VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT10VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT11VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT12VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT13VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT14VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT15VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT16VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT17VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT18VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT19VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT20VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT21VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT22VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT23VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT24VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT25VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT26VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT27VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT28VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT29VARCHAR225Key Flexfield: segment of the key flexfield.

SEGMENT30VARCHAR225Key Flexfield: segment of the key flexfield.