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: TableAR.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_MC_CASH_BASIS_DISTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
ColumnCASH_BASIS_DISTRIBUTION_ID
AR_MC_CASH_BASIS_DISTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYMENT_SCHEDULE_ID
ColumnTYPE
AR_MC_CASH_BASIS_DISTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSTING_CONTROL_ID
AR_MC_CASH_BASIS_DISTS_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
ColumnRECEIVABLE_APPLICATION_ID
ColumnSOURCE
ColumnSOURCE_ID
ColumnTYPE
ColumnPOSTING_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:

SchemaAR
ViewAR_MC_CASH_BASIS_DISTS_ALL#