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:
CONFIRMATION
REMITTANCE
CASH
FACTOR
SHORT_TERM_DEBT
BANK_CHARGES
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:
REC for receivable accounts
EDISC for earned discounts
UNEDISC for unearned discounts
TAX for collectable tax
DEFERRED_TAX for deferred tax,
EDISC_NON_REC for non-recoverable earned discounts
UNEDISC_NON_REC for non-recoverable unearned discounts
EXCH_GAIN for exchange gain
EXCH_LOSS for exchange loss
CURR_ROUND for currency rounding
For adjustment records, the SOURCE_TABLE is ADJ and the SOURCE_ID is AR_ADJUSTMENTS_ALL.ADJUSTMENT_ID. The SOURCE_TYPE can be:
REC for receivable accounts
ADJ for adjustment accounts
FINCHRG for finance charges
ADJ_NON_REC for non-recoverable adjustments
FINCHRG_NON_REC for non-recoverable finance charges
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:
MISCCASH for cash accounts
TAX for tax
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:
DEFERRED_TAX for deferred tax
FACTOR for factor
REC for receivable
REMITTANCE for remittance
TAX for tax
UNPAIDREC for unpaid bills
The primary keys for this table are SOURCE_ID, SOURCE_TABLE, and SOURCE_TYPE.
The accounting code combinations stored in this table is meta data for creating accounting entries in Subledger Accounting. Receivables provides the code combinations stored in this table to Subledger Accounting as a source for accounting attributes for deriving the accounting code combinations. Subledger Accounting generates the final accounting entries that are posted to General Ledger. The accounting code combination used in the final accounting entries can be same as that stored in AR_DISTRIBUTIONS_ALL table or can be different depending on the rules setup in Subledger Accounting. The XLA_AE_HEADERS and XLA_AE_LINES tables in Subledger Accounting stores the accounting entries posted to General Ledger.

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

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_ID	NUMBER	(15)	Yes	Internal identifier of the distribution record and primary key for this table.
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	Internal identifier of the General Ledger account code. It is the account that will be debited or credited.
AMOUNT_DR	NUMBER			Journal line debit amount in entered currency.
AMOUNT_CR	NUMBER			Journal line credit amount entered in currency.
ACCTD_AMOUNT_DR	NUMBER			Journal line debit amount in functional currency.
ACCTD_AMOUNT_CR	NUMBER			Journal line credit amount in functional currency.
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.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column. User who last updated this row.
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.
ORG_ID	NUMBER	(15)		Operating unit identifier
SOURCE_TABLE_SECONDARY	VARCHAR2	(10)		This column will always store the value �RA�
SOURCE_ID_SECONDARY	NUMBER	(15)		This column is populated for the UNAPP rows and stores the receivable application id of the APP row in AR_RECEIVABLE_APPLICATIONS_ALL table.
CURRENCY_CODE	VARCHAR2	(15)		Currency code for the journal entry.
CURRENCY_CONVERSION_RATE	NUMBER			Exchange rate used for foreign currency journal entry
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Conversion type used for foreign currency journal entry
CURRENCY_CONVERSION_DATE	DATE			Date used to derive the currency exchange rate
TAXABLE_ENTERED_DR	NUMBER			For distributions which are prorated over transaction tax lines, stores the taxable amount debit (prorated) for the current accounted distribution amount in entered currency of transaction
TAXABLE_ENTERED_CR	NUMBER			For distributions which are prorated over transaction tax lines, stores the taxable amount credit (prorated) for the current accounted distribution amount in entered currency of transaction
TAXABLE_ACCOUNTED_DR	NUMBER			For distributions which are prorated over transaction tax lines, stores the taxable amount debit (prorated) for the current accounted distribution amount in functional currency
TAXABLE_ACCOUNTED_CR	NUMBER			For distributions which are prorated over transaction tax lines, stores the taxable amount credit (prorated) for the current accounted distribution amount in functional currency
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)		No longer in use
LOCATION_SEGMENT_ID	NUMBER	(15)		No longer in use
SOURCE_TYPE_SECONDARY	VARCHAR2	(30)		Source Type Secondary
TAX_GROUP_CODE_ID	NUMBER	(15)		No longer in use
REF_CUSTOMER_TRX_LINE_ID	NUMBER	(15)		Used in Multi Fund Accounts Receivables feature. Stores the internal identifier of the applied transaction line.
REF_CUST_TRX_LINE_GL_DIST_ID	NUMBER	(15)		Used in Multi Fund Accounts Receivables feature. Stores the internal identifier of the applied transaction distribution line.
REF_ACCOUNT_CLASS	VARCHAR2	(30)		Used in Multi Fund Accounts Receivables feature. Stores the account class of the applied transaction distribution line.
ACTIVITY_BUCKET	VARCHAR2	(30)		Represents the bucket, which the current distribution hits along with the type of activity like ADJ_CHRG, ADJ_LINE, ADJ_TAX, APP_FRT, APP_LINE, APP_TAX, etc.
REF_LINE_ID	NUMBER	(15)		Reference to another distribution created via an adjustment
FROM_AMOUNT_DR	NUMBER			Stores the debit amount in the currency of the receipt or credit memo.
FROM_AMOUNT_CR	NUMBER			Stores the credit amount in the currency of the receipt or credit memo.
FROM_ACCTD_AMOUNT_DR	NUMBER			Stores the debit amount in the functional currency.
FROM_ACCTD_AMOUNT_CR	NUMBER			Stores the credit amount in the currency of 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.

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
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:

APPS: AR_DISTRIBUTIONS; AR_DISTRIBUTIONS_ALL