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_CASH_BASIS_DISTS_ALL

Object Details

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

This table stores distribution information for Cash Basis accounting. Oracle Receivables loads this table when you post to your 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 first automatically prorates the receipt to pay off all invoice lines, and then prorates tax, freight, and receivables charges. One record is created for each distribution.
.
For example, if you have an invoice with 5 lines, each for $10 and you apply a $50 payment, you create 5 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 key for this table is CASH_BASIS_DISTRIBUTION_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_CASH_BASIS_DISTRIBUTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CASH_BASIS_DISTRIBUTION_ID
AR_CASH_BASIS_DISTRIBUTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_SCHEDULE_ID TYPE
AR_CASH_BASIS_DISTRIBUTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSTING_CONTROL_ID
AR_CASH_BASIS_DISTRIBUTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECEIVABLE_APPLICATION_ID SOURCE SOURCE_ID TYPE POSTING_CONTROL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
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 is a distribution of an ar_adjustments record or ra_cust_trx_line_gl_dist record
SOURCE_ID	NUMBER	(15)	Yes	Identifier of ar_adjustments record, or ra_cust_trx_line_gl_dist
TYPE	VARCHAR2	(15)	Yes	Indicates whether this is a distribution of Lines, Tax, Freight, Charges, or Invoice
PAYMENT_SCHEDULE_ID	NUMBER	(15)	Yes	Payment Schedule to which application was made
GL_DATE	DATE		Yes	General ledger date
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency of distribution
AMOUNT	NUMBER		Yes	Amount posted
ACCTD_AMOUNT	NUMBER		Yes	Equivalent amount in functional currency
CODE_COMBINATION_ID	NUMBER	(15)	Yes	General Ledger code combination (account)
POSTING_CONTROL_ID	NUMBER	(15)	Yes	ID of general ledger posting process
GL_POSTED_DATE	DATE		Yes	Accounting date the distribution amount was posted
RECEIVABLE_APPLICATION_ID_CASH	NUMBER	(15)		Application that triggered the posting of a Credit Memo Application
ORG_ID	NUMBER	(15)		Organization identifier
ACTIVITY_BUCKET	VARCHAR2	(30)		Amount bucket to each this distribution is associated
REF_ACCOUNT_CLASS	VARCHAR2	(30)		Account Class to each this distribution is affected
REF_CUSTOMER_TRX_ID	NUMBER	(15)		transaction identifyer
REF_CUSTOMER_TRX_LINE_ID	NUMBER	(15)		transaction line identifyer
REF_CUST_TRX_LINE_GL_DIST_ID	NUMBER	(15)		transaction line distribution identifyer
REF_LINE_ID	NUMBER	(15)		eference to another distribution created via an adjustment
FROM_AMOUNT	NUMBER			distribution amount in the from document currency
FROM_ACCTD_AMOUNT	NUMBER			distribution accounted amount in the from document currency
LEDGER_ID	NUMBER	(15)		ledger ID of the base ledger
BASE_CURRENCY	VARCHAR2	(30)		functional currency

Query Text

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


SELECT 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
,      ACTIVITY_BUCKET
,      REF_ACCOUNT_CLASS
,      REF_CUSTOMER_TRX_ID
,      REF_CUSTOMER_TRX_LINE_ID
,      REF_CUST_TRX_LINE_GL_DIST_ID
,      REF_LINE_ID
,      FROM_AMOUNT
,      FROM_ACCTD_AMOUNT
,      LEDGER_ID
,      BASE_CURRENCY
FROM AR.AR_CASH_BASIS_DISTS_ALL;

Dependencies

[top of page]

AR.AR_CASH_BASIS_DISTS_ALL does not reference any database object

AR.AR_CASH_BASIS_DISTS_ALL is referenced by following:

APPS: AR_CASH_BASIS_DISTRIBUTIONS; AR_CASH_BASIS_DISTS_ALL