[Home] [Help] [Dependency Information]

TABLE: AR.RA_INTERFACE_DISTRIBUTIONS_ALL

Object Details

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

The RA_INTERFACE_DISTRIBUTIONS_ALL table stores information about the accounting distributions for transactions that were imported using AutoInvoice. If you do not use AutoAccounting, you must enter accounting distributions for your transactions.
.
If your accounting distributions are for transactions that use accounting rules, you must enter the percentages instead of the amounts, for your distribution lines. If you enter the amounts, AutoInvoice ignores those values.
.
If your accounting distributions are for transactions that do not use accounting rules, you can enter either the percentages or amounts, depending on the value that you entered for your batch source. If you enter an amount, AutoInvoice requires that the sum of the distribution amounts equals the total amount of the transaction. If you enter a percent, AutoInvoice requires that the sum of the distribution percentages equals 100 for each account class that you pass.
.
Please refer to the appendix of the Oracle Receivables User Guide or online help for more detailed information on Open Interface table columns, including import validation and destination columns.
.
The primary key for this table is INTERFACE_DISTRIBUTION_ID.
Scope: public
Product: AR
Lifecycle: active
Display Name: AR Interface Distributions
Category: BUSINESS_ENTITY AR_INVOICE
Category: BUSINESS_ENTITY AR_DEBIT_MEMO
Category: BUSINESS_ENTITY AR_CREDIT_MEMO

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RA_INTERFACE_DISTRIBUTIONS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	INTERFACE_DISTRIBUTION_ID
RA_INTERFACE_DISTRIBUTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INTERFACE_LINE_ID
RA_INTERFACE_DISTRIBUTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID ACCOUNT_CLASS

Columns

Query Text

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

SELECT INTERFACE_DISTRIBUTION_ID
,      INTERFACE_LINE_ID
,      INTERFACE_LINE_CONTEXT
,      INTERFACE_LINE_ATTRIBUTE1
,      INTERFACE_LINE_ATTRIBUTE2
,      INTERFACE_LINE_ATTRIBUTE3
,      INTERFACE_LINE_ATTRIBUTE4
,      INTERFACE_LINE_ATTRIBUTE5
,      INTERFACE_LINE_ATTRIBUTE6
,      INTERFACE_LINE_ATTRIBUTE7
,      INTERFACE_LINE_ATTRIBUTE8
,      ACCOUNT_CLASS
,      AMOUNT
,      PERCENT
,      INTERFACE_STATUS
,      REQUEST_ID
,      CODE_COMBINATION_ID
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ACCTD_AMOUNT
,      INTERFACE_LINE_ATTRIBUTE10
,      INTERFACE_LINE_ATTRIBUTE11
,      INTERFACE_LINE_ATTRIBUTE12
,      INTERFACE_LINE_ATTRIBUTE13
,      INTERFACE_LINE_ATTRIBUTE14
,      INTERFACE_LINE_ATTRIBUTE15
,      INTERFACE_LINE_ATTRIBUTE9
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      INTERIM_TAX_CCID
,      INTERIM_TAX_SEGMENT1
,      INTERIM_TAX_SEGMENT2
,      INTERIM_TAX_SEGMENT3
,      INTERIM_TAX_SEGMENT4
,      INTERIM_TAX_SEGMENT5
,      INTERIM_TAX_SEGMENT6
,      INTERIM_TAX_SEGMENT7
,      INTERIM_TAX_SEGMENT8
,      INTERIM_TAX_SEGMENT9
,      INTERIM_TAX_SEGMENT10
,      INTERIM_TAX_SEGMENT11
,      INTERIM_TAX_SEGMENT12
,      INTERIM_TAX_SEGMENT13
,      INTERIM_TAX_SEGMENT14
,      INTERIM_TAX_SEGMENT15
,      INTERIM_TAX_SEGMENT16
,      INTERIM_TAX_SEGMENT17
,      INTERIM_TAX_SEGMENT18
,      INTERIM_TAX_SEGMENT19
,      INTERIM_TAX_SEGMENT20
,      INTERIM_TAX_SEGMENT21
,      INTERIM_TAX_SEGMENT22
,      INTERIM_TAX_SEGMENT23
,      INTERIM_TAX_SEGMENT24
,      INTERIM_TAX_SEGMENT25
,      INTERIM_TAX_SEGMENT26
,      INTERIM_TAX_SEGMENT27
,      INTERIM_TAX_SEGMENT28
,      INTERIM_TAX_SEGMENT29
,      INTERIM_TAX_SEGMENT30
,      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_INTERFACE_DISTRIBUTIONS_ALL;

Dependencies

[top of page]

AR.RA_INTERFACE_DISTRIBUTIONS_ALL does not reference any database object

AR.RA_INTERFACE_DISTRIBUTIONS_ALL is referenced by following:

AR

RA_INTERFACE_DISTRIBUTIONS_AL#