eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AR.AR_DISTRIBUTIONS_ALL

Object Details

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

The AR_DISTRIBUTIONS_ALL table stores the accounting distributions for cash receipts, miscellaneous receipts, adjustments, credit memo applications, cash receipt applications, and bills receivable transactions. The records are joined to the AR_CASH_RECEIPT_HISTORY_ALL, AR_MISC_CASH_DISTRIBUTIONS_ALL, AR_ADJUSTMENTS, AR_RECEIVABLE_APPLICATIONS_ALL, and AR_TRANSACTION_HISTORY_ALL tables.
.
For cash receipt headers, the SOURCE_TABLE is CRH and the SOURCE_ID is AR_CASH_RECEIPT_HISTORY_ALL.CASH_RECEIPT_HISTORY_ID. The SOURCE_TYPE can be:
{{"bul:1"}}CONFIRMATION
{{"bul:1"}}REMITTANCE
{{"bul:1"}}CASH
{{"bul:1"}}FACTOR
{{"bul:1"}}SHORT_TERM_DEBT
{{"bul:1"}}BANK_CHARGES
{{"bodytext"}}For receivable applications records, the SOURCE_TABLE is RA and the SOURCE_ID is AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID. The SOURCE_TYPE can be:
{{"bul:1"}}REC for receivable accounts
{{"bul:1"}}EDISC for earned discounts
{{"bul:1"}}UNEDISC for unearned discounts
{{"bul:1"}}TAX for collectable tax
{{"bul:1"}}DEFERRED_TAX for deferred tax,
{{"bul:1"}}EDISC_NON_REC for non-recoverable earned discounts
{{"bul:1"}}UNEDISC_NON_REC for non-recoverable unearned discounts
{{"bul:1"}}EXCH_GAIN for exchange gain
{{"bul:1"}}EXCH_LOSS for exchange loss
{{"bul:1"}}CURR_ROUND for currency rounding
{{"bodytext"}}For adjustment records, the SOURCE_TABLE is ADJ and the SOURCE_ID is AR_ADJUSTMENTS_ALL.ADJUSTMENT_ID. The SOURCE_TYPE can be:
{{"bul:1"}}REC for receivable accounts
{{"bul:1"}}ADJ for adjustment accounts
{{"bul:1"}}FINCHRG for finance charges
{{"bul:1"}}ADJ_NON_REC for non-recoverable adjustments
{{"bul:1"}}FINCHRG_NON_REC for non-recoverable finance charges
{{"bodytext"}}For miscellaneous receipt records, the SOURCE_TABLE is MCD and the SOURCE_ID is AR_MISC_CASH_DISTRIBUTIONS_ALL.MISC_CASH_DISTRIBUTIONS_ID. The SOURCE_TYPE can be:
{{"bul:1"}}MISCCASH for cash accounts
{{"bul:1"}}TAX for tax
{{"bodytext"}}For bills receivable records, the SOURCE_TABLE is TH and the SOURCE_ID is AR_TRANSACTION_HISTORY_ALL.TRANSACTION_HISTORY_ID. The SOURCE_TYPE can be:
{{"bul:1"}}DEFERRED_TAX for deferred tax
{{"bul:1"}}FACTOR for factor
{{"bul:1"}}REC for receivable
{{"bul:1"}}REMITTANCE for remittance
{{"bul:1"}}TAX for tax
{{"bul:1"}}UNPAIDREC for unpaid bills
{{"bodytext"}}The primary keys for this table are SOURCE_ID, SOURCE_TABLE, and SOURCE_TYPE.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_DISTRIBUTIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ID
AR_DISTRIBUTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_ID SOURCE_TABLE SOURCE_TYPE
AR_DISTRIBUTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_ID_SECONDARY SOURCE_TABLE_SECONDARY SOURCE_TYPE_SECONDARY
AR_DISTRIBUTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	THIRD_PARTY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_ID	NUMBER	(15)	Yes	Uniquely identifier for rows in this table - primarily when these rows are passed to General Ledger
SOURCE_ID	NUMBER	(15)	Yes	Identifier for record in SOURCE_TABLE that created this distribution.
SOURCE_TABLE	VARCHAR2	(10)	Yes	Possible values are CRH for the AR_CASH_RECEIPT_HISTORY_ALL table, RA for the AR_RECEIVABLE_APPLICATIONS_ALL table, ADJ for the AR_ADJUSTMENTS_ALL table, MCD for the AR_MISC_CASH_DISTRIBUTIONS_ALL table, or TH for the AR_TRANSACTION_HISTORY_ALL table.
SOURCE_TYPE	VARCHAR2	(30)	Yes	Account type of transaction for which distribution is posted.
CODE_COMBINATION_ID	NUMBER	(15)	Yes	Foreign key to GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. It is the account to create the journals for.
AMOUNT_DR	NUMBER			Journal entry debit amount
AMOUNT_CR	NUMBER			Journal entry credit amount
ACCTD_AMOUNT_DR	NUMBER			Journal entry accounted debit amount
ACCTD_AMOUNT_CR	NUMBER			Journal entry accounted credit amount
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ORG_ID	NUMBER	(15)		Organization identifier
SOURCE_TABLE_SECONDARY	VARCHAR2	(10)		Abbreviation that represents another table
SOURCE_ID_SECONDARY	NUMBER	(15)		Foreign key for entity in the SOURCE_TABLE_SECONDARY column
CURRENCY_CODE	VARCHAR2	(15)		Code defined for a currency
CURRENCY_CONVERSION_RATE	NUMBER			Exchange rate
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Supports multiple currency exchange rates for the same date
CURRENCY_CONVERSION_DATE	DATE			Date the currency was converted using the given exchange rate
TAXABLE_ENTERED_DR	NUMBER			Taxable debit that lines of type Tax apply to
TAXABLE_ENTERED_CR	NUMBER			Taxable credit that lines of type Tax apply to
TAXABLE_ACCOUNTED_DR	NUMBER			Accounted taxable debit amount
TAXABLE_ACCOUNTED_CR	NUMBER			Accounted taxable credit amount
TAX_LINK_ID	NUMBER	(15)		Links tax and taxable lines within the AR_DISTRIBUTIONS table
THIRD_PARTY_ID	NUMBER	(15)		Bill-to customer ID for transactions, paid-from customer ID for receipts
THIRD_PARTY_SUB_ID	NUMBER	(15)		Bill-to site use ID for transactions, customer site use ID for receipts
REVERSED_SOURCE_ID	NUMBER	(15)		The source ID that the reversal record was created from. Used for receipt application (APP) records to get the debit/credit for the gain/loss account.
TAX_CODE_ID	NUMBER	(15)		Foreign key to the AR_VAT_TAX table
LOCATION_SEGMENT_ID	NUMBER	(15)		Foreign key to the AR_LOCATION_VALUES table
SOURCE_TYPE_SECONDARY	VARCHAR2	(30)		Source Type Secondary
TAX_GROUP_CODE_ID	NUMBER	(15)		Foreign key to the AR_TAX_GROUP_CODES table to identify the tax code's tax group
REF_CUSTOMER_TRX_LINE_ID	NUMBER	(15)		transaction line identifyer
REF_CUST_TRX_LINE_GL_DIST_ID	NUMBER	(15)		transaction line distribution identifyer
REF_ACCOUNT_CLASS	VARCHAR2	(30)		Account Class to each this distribution is affected
ACTIVITY_BUCKET	VARCHAR2	(30)		Amount bucket to each this distribution is associated
REF_LINE_ID	NUMBER	(15)		Reference to another distribution created via an adjustment
FROM_AMOUNT_DR	NUMBER			Debit amount in the currency of the cash receipt
FROM_AMOUNT_CR	NUMBER			credit amount in the currency of the cash receipt
FROM_ACCTD_AMOUNT_DR	NUMBER			debit amount in the functional currency based on the receipt
FROM_ACCTD_AMOUNT_CR	NUMBER			credit amount in the functional currency based on the receipt
REF_MF_DIST_FLAG	VARCHAR2	(1)		Indicate if the distribution is created based on a PSA distribution
REF_DIST_CCID	NUMBER	(15)		Maintains accounting code combination ID at time of application. Optimizes performance when CCID comes from distribution outside AR, such as PSA multi-funded CCID.
REF_PREV_CUST_TRX_LINE_ID	NUMBER	(15)		Populated in case of regular Credit memos. Stores the line identifier of the invoice

Query Text

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


SELECT LINE_ID
,      SOURCE_ID
,      SOURCE_TABLE
,      SOURCE_TYPE
,      CODE_COMBINATION_ID
,      AMOUNT_DR
,      AMOUNT_CR
,      ACCTD_AMOUNT_DR
,      ACCTD_AMOUNT_CR
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      SOURCE_TABLE_SECONDARY
,      SOURCE_ID_SECONDARY
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      TAXABLE_ENTERED_DR
,      TAXABLE_ENTERED_CR
,      TAXABLE_ACCOUNTED_DR
,      TAXABLE_ACCOUNTED_CR
,      TAX_LINK_ID
,      THIRD_PARTY_ID
,      THIRD_PARTY_SUB_ID
,      REVERSED_SOURCE_ID
,      TAX_CODE_ID
,      LOCATION_SEGMENT_ID
,      SOURCE_TYPE_SECONDARY
,      TAX_GROUP_CODE_ID
,      REF_CUSTOMER_TRX_LINE_ID
,      REF_CUST_TRX_LINE_GL_DIST_ID
,      REF_ACCOUNT_CLASS
,      ACTIVITY_BUCKET
,      REF_LINE_ID
,      FROM_AMOUNT_DR
,      FROM_AMOUNT_CR
,      FROM_ACCTD_AMOUNT_DR
,      FROM_ACCTD_AMOUNT_CR
,      REF_MF_DIST_FLAG
,      REF_DIST_CCID
,      REF_PREV_CUST_TRX_LINE_ID
FROM AR.AR_DISTRIBUTIONS_ALL;

Dependencies

[top of page]

AR.AR_DISTRIBUTIONS_ALL does not reference any database object

AR.AR_DISTRIBUTIONS_ALL is referenced by following:

AR: AR_DISTRIBUTIONS_ALL#