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_MC_CASH_BASIS_DISTS_ALL

Object Details

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

The AR_MC_CASH_BASIS_DISTS_ALL table stores distribution information for cash basis accounting. Oracle Receivables loads this table when you post to General Ledger. This table shows the distribution of receipt amounts over the revenue accounts of an invoice. If you do not specify an invoice line for a receipt, Oracle Receivables automatically prorates the receipt to pay off all invoice
lines and then tax, freight, and receivables charges.
.
Oracle Receivables creates one record for each distribution. For example, if you have an invoice with five lines, each for $10, and you apply a $50 payment, you create five records in this table. Oracle Receivables uses the CUSTOMER_TRX_ID, CODE_COMBINATION_ID, and CUSTOMER_TRX_LINE_ID columns to store tax distribution information.
.
The primary keys for this table are SET_OF_BOOKS_ID and CASH_BASIS_DISTRIBUTION_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_MC_CASH_BASIS_DISTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID CASH_BASIS_DISTRIBUTION_ID
AR_MC_CASH_BASIS_DISTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_SCHEDULE_ID TYPE
AR_MC_CASH_BASIS_DISTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSTING_CONTROL_ID
AR_MC_CASH_BASIS_DISTS_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID RECEIVABLE_APPLICATION_ID SOURCE SOURCE_ID TYPE POSTING_CONTROL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
CASH_BASIS_DISTRIBUTION_ID	NUMBER	(15)	Yes	Identifier of the distribution item
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
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).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
RECEIVABLE_APPLICATION_ID	NUMBER	(15)	Yes	Identifier of the record used to determine the application of payments or credit memos associated with this distribution item
SOURCE	VARCHAR2	(3)	Yes	Indicates whether this distribution is related to an AR_ADJUSTMENTS or RA_CUST_TRX_LINE_GL_DIST record
SOURCE_ID	NUMBER	(15)	Yes	Identifier of AR_ADJUSTMENTS or RA_CUST_TRX_LINE_GL_DIST record
TYPE	VARCHAR2	(15)	Yes	Distribution type, Lines, Tax, Freight, Charges, or Invoice
PAYMENT_SCHEDULE_ID	NUMBER	(15)	Yes	Payment schedule that application was made to
GL_DATE	DATE		Yes	General Ledger date
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency of distribution
AMOUNT	NUMBER		Yes	Amount posted
ACCTD_AMOUNT	NUMBER		Yes	Functional currency equivalent of amount
CODE_COMBINATION_ID	NUMBER	(15)	Yes	General Ledger account code combination
POSTING_CONTROL_ID	NUMBER	(15)	Yes	General Ledger posting process identifier
GL_POSTED_DATE	DATE		Yes	Accounting date that distribution amount was posted
RECEIVABLE_APPLICATION_ID_CASH	NUMBER	(15)		Application that triggered posting of credit memo application
ORG_ID	NUMBER	(15)		Organization identifier

Query Text

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


SELECT SET_OF_BOOKS_ID
,      CASH_BASIS_DISTRIBUTION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RECEIVABLE_APPLICATION_ID
,      SOURCE
,      SOURCE_ID
,      TYPE
,      PAYMENT_SCHEDULE_ID
,      GL_DATE
,      CURRENCY_CODE
,      AMOUNT
,      ACCTD_AMOUNT
,      CODE_COMBINATION_ID
,      POSTING_CONTROL_ID
,      GL_POSTED_DATE
,      RECEIVABLE_APPLICATION_ID_CASH
,      ORG_ID
FROM AR.AR_MC_CASH_BASIS_DISTS_ALL;

Dependencies

[top of page]

AR.AR_MC_CASH_BASIS_DISTS_ALL does not reference any database object

AR.AR_MC_CASH_BASIS_DISTS_ALL is referenced by following:

AR: AR_MC_CASH_BASIS_DISTS_ALL#