[Home] [Help] [Dependency Information]

TABLE: AR.RA_CUST_TRX_LINE_GL_DIST_ALL

Object Details

Object Name:	RA_CUST_TRX_LINE_GL_DIST_ALL
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.RA_CUST_TRX_LINE_GL_DIST_ALL
Subobject Name:
Status:	VALID

The RA_CUST_TRX_LINE_GL_DIST_ALL table stores the accounting records for revenue, unearned revenue, and unbilled receivables for each invoice or credit memo line. Oracle Receivables creates one row for each accounting distribution, and at least one accounting distribution must exist for each invoice or credit memo line. Each row in this table includes the General Ledger account and the amount of the accounting entry. The AMOUNT column is required even though this column is null allowed. Receivables uses this information to post the proper amounts to General Ledger.
.
If your invoice or credit memo has a transaction type where Post to GL is set to No, Receivables assigns Null to the GL_DATE column. If AutoAccounting is unable to complete your General Ledger default accounts using the AutoAccounting rules that you defined, incomplete General Ledger accounts are stored in the CONCATENATED_SEGMENTS column. If you are importing a transaction through AutoInvoice and the General Ledger date of your transaction is in a closed accounting period, AutoInvoice uses the General Ledger date of the first open accounting period and stores the original General Ledger date in the ORIGINAL_GL_DATE column.
.
The ACCOUNT_CLASS column defines this distribution row type. A REC value in the ACCOUNT_CLASS column represents the receivable account and contains the total invoice amount. At most, two REC rows may exist: one row with the ACCOUNT_SET_FLAG column set to Y, and one row with the ACCOUNT_SET_FLAG column set to N. The LATEST_REC_FLAG column joins the row that is set to N.
.
The ACCOUNT_SET_FLAG column is Y if this row is part of an account set. An account set, which is a set of rows that represents a model distribution, is used for invoices with rules. The rows in an account set indicate how Receivables should create the actual distribution rows and what percentage of the actual distribution Receivables should allocate to each account. For invoices with rules, Receivables does not create the distributions when the invoice is initially created. Instead, Receivables creates the invoices when the Revenue Recognition program is run.
.
The primary key for this table is CUST_TRX_LINE_GL_DIST_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RA_CUST_TRX_LINE_GL_DIST_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUST_TRX_LINE_GL_DIST_ID
RA_CUST_TRX_LINE_GL_DIST_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_LINE_ID ACCOUNT_SET_FLAG GL_DATE ACCOUNT_CLASS
RA_CUST_TRX_LINE_GL_DIST_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID CUSTOMER_TRX_LINE_ID ACCOUNT_SET_FLAG
RA_CUST_TRX_LINE_GL_DIST_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_DATE ACCOUNT_CLASS LATEST_REC_FLAG ORG_ID COGS_REQUEST_ID
RA_CUST_TRX_LINE_GL_DIST_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_TRX_LINE_SALESREP_ID
RA_CUST_TRX_LINE_GL_DIST_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID POSTING_CONTROL_ID GL_DATE
RA_CUST_TRX_LINE_GL_DIST_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_ID ACCOUNT_CLASS LATEST_REC_FLAG CODE_COMBINATION_ID
RA_CUST_TRX_LINE_GL_DIST_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
RA_CUST_TRX_LINE_GL_DIST_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REVENUE_ADJUSTMENT_ID
RA_CUST_TRX_LINE_GL_DIST_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_ID

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT CUST_TRX_LINE_GL_DIST_ID
,      CUSTOMER_TRX_LINE_ID
,      CODE_COMBINATION_ID
,      SET_OF_BOOKS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PERCENT
,      AMOUNT
,      GL_DATE
,      GL_POSTED_DATE
,      CUST_TRX_LINE_SALESREP_ID
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CONCATENATED_SEGMENTS
,      ORIGINAL_GL_DATE
,      POST_REQUEST_ID
,      POSTING_CONTROL_ID
,      ACCOUNT_CLASS
,      RA_POST_LOOP_NUMBER
,      CUSTOMER_TRX_ID
,      ACCOUNT_SET_FLAG
,      ACCTD_AMOUNT
,      USSGL_TRANSACTION_CODE
,      USSGL_TRANSACTION_CODE_CONTEXT
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LATEST_REC_FLAG
,      ORG_ID
,      MRC_ACCOUNT_CLASS
,      MRC_CUSTOMER_TRX_ID
,      MRC_AMOUNT
,      MRC_GL_POSTED_DATE
,      MRC_POSTING_CONTROL_ID
,      MRC_ACCTD_AMOUNT
,      COLLECTED_TAX_CCID
,      COLLECTED_TAX_CONCAT_SEG
,      REVENUE_ADJUSTMENT_ID
,      REV_ADJ_CLASS_TEMP
,      REC_OFFSET_FLAG
,      EVENT_ID
,      USER_GENERATED_FLAG
,      ROUNDING_CORRECTION_FLAG
,      COGS_REQUEST_ID
,      CCID_CHANGE_FLAG
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE21
,      GLOBAL_ATTRIBUTE22
,      GLOBAL_ATTRIBUTE23
,      GLOBAL_ATTRIBUTE24
,      GLOBAL_ATTRIBUTE25
,      GLOBAL_ATTRIBUTE26
,      GLOBAL_ATTRIBUTE27
,      GLOBAL_ATTRIBUTE28
,      GLOBAL_ATTRIBUTE29
,      GLOBAL_ATTRIBUTE30
,      GLOBAL_ATTRIBUTE_CATEGORY
FROM AR.RA_CUST_TRX_LINE_GL_DIST_ALL;

Dependencies

[top of page]

AR.RA_CUST_TRX_LINE_GL_DIST_ALL does not reference any database object

AR.RA_CUST_TRX_LINE_GL_DIST_ALL is referenced by following:

AR

RA_CUST_TRX_LINE_GL_DIST_ALL#