AR_MISC_CASH_DISTRIBUTIONS_ALL
The AR_MISC_CASH_DISTRIBUTIONS_ALL table stores all accounting entries for your miscellaneous cash applications. Miscellaneous cash is non-revenue income such as stock revenue, interest income, and investment income. . The AR_CASH_RECEIPTS_ALL table stores one record for each payment while the AR_MISC_CASH_DISTRIBUTIONS_ALL table stores one record for each receipt distribution. . The primary key for this table is MISC_CASH_DISTRIBUTION_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AR_MISC_CASH_DISTRIBUTIONS_PK |
MISC_CASH_DISTRIBUTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| MISC_CASH_DISTRIBUTION_ID | NUMBER | 18 | Yes | Primary key for miscellaneous cash distributions | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CASH_RECEIPT_ID | NUMBER | 18 | Yes | Identifier for the cash receipt of the miscellaneous cash | ||
| CODE_COMBINATION_ID | NUMBER | 18 | Yes | General Ledger code combination account | ||
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | General Ledger Set of Books that is used, only one currently supported | ||
| GL_DATE | DATE | Yes | Accounting date. | |||
| PERCENT | NUMBER | 19 | Percent of the distribution that is attributed to this record | |||
| AMOUNT | NUMBER | Yes | Amount of the distribution | |||
| COMMENTS | VARCHAR2 | 240 | User-entered comment for the distribution. | |||
| GL_POSTED_DATE | DATE | Date that this line was posted to General Ledger | ||||
| APPLY_DATE | DATE | Yes | The application date of the line | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Accounting Distributions (AR_MISC_CASH_DISTRIBUTIONS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Accounting Distributions (AR_MISC_CASH_DISTRIBUTIONS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Accounting Distributions (AR_MISC_CASH_DISTRIBUTIONS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Accounting Distributions (AR_MISC_CASH_DISTRIBUTIONS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Accounting Distributions (AR_MISC_CASH_DISTRIBUTIONS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Accounting Distributions (AR_MISC_CASH_DISTRIBUTIONS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Accounting Distributions (AR_MISC_CASH_DISTRIBUTIONS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Accounting Distributions (AR_MISC_CASH_DISTRIBUTIONS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Accounting Distributions (AR_MISC_CASH_DISTRIBUTIONS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Accounting Distributions (AR_MISC_CASH_DISTRIBUTIONS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Accounting Distributions (AR_MISC_CASH_DISTRIBUTIONS) | ||
| POSTING_CONTROL_ID | NUMBER | Yes | Receivables posting batch identifier, -1, -2, and -4 for posted in previous releases and -3 for not posted | |||
| ACCTD_AMOUNT | NUMBER | Yes | Amount of journal entries | |||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Accounting Distributions (AR_MISC_CASH_DISTRIBUTIONS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Accounting Distributions (AR_MISC_CASH_DISTRIBUTIONS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Accounting Distributions (AR_MISC_CASH_DISTRIBUTIONS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Accounting Distributions (AR_MISC_CASH_DISTRIBUTIONS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Accounting Distributions (AR_MISC_CASH_DISTRIBUTIONS) | ||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |||
| PROGRAM_ID | NUMBER | 18 | 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). | ||||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Not currently used. | Government Distributions (AR_MISC_CASH_DISTRIBUTIONS_GOV) | ||
| USSGL_TRANSACTION_CODE_CONTEXT | VARCHAR2 | 30 | Context value for the USSGL Transaction Code Flexfield | Government Distributions (AR_MISC_CASH_DISTRIBUTIONS_GOV) | ||
| CREATED_FROM | VARCHAR2 | 30 | Yes | Populated by code that points to form or program that created this row | ||
| REVERSAL_GL_DATE | DATE | Populated for records that were reversed and for the reversing record, limits the number of records that are reversed by rate adjustments and receipt reversal | ||||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| MRC_GL_POSTED_DATE | VARCHAR2 | 2000 | Not currently used. | |||
| MRC_POSTING_CONTROL_ID | VARCHAR2 | 2000 | Not currently used. | |||
| MRC_ACCTD_AMOUNT | VARCHAR2 | 2000 | Not currently used. | |||
| EVENT_ID | NUMBER | 18 | Subledger accounting event identifier. | |||
| CASH_RECEIPT_HISTORY_ID | NUMBER | 18 | Cash receipt history identifier for activity accounting distribution | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| BUDGETARY_CONTROL_FLAG | VARCHAR2 | 1 | Option that indicates whether budgeting is enabled on the ledger associated with the standard receipt, and if its details should be interfaced to Budgetary Control. Valid values are Y and N. | |||
| SUBLEDGER_BC_COMPLETE_FLAG | VARCHAR2 | 1 | Option that indicates whether to interface standard receipt accounting information from General Ledger to Budgetary Control. This value is passed by Budgetary Control to General Ledger through the accounting information from Receivables. | |||
| DATA_SET_ID | NUMBER | 18 | Unique identifier of the batch that groups receipt data for interface to Budgetary Control. | |||
| FUNDS_STATUS_CODE | VARCHAR2 | 30 | Status of the funds update on the miscellaneous cash distributions. Valid values are mapped to the lookup ORA_XCC_FUNDS_STATUS. | |||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE21 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE22 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE23 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE24 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE25 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE26 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE27 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE28 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE29 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE30 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_MISC_CASH_DISTRIBUTIONS_ALL | ar_cash_receipts_all | CASH_RECEIPT_ID |
| AR_MISC_CASH_DISTRIBUTIONS_ALL | gl_code_combinations | CODE_COMBINATION_ID |
| AR_MISC_CASH_DISTRIBUTIONS_ALL | xla_events | EVENT_ID, PROGRAM_APPLICATION_ID |
| AR_MISC_CASH_DISTRIBUTIONS_ALL | ar_cash_receipt_history_all | CASH_RECEIPT_HISTORY_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_MISC_CASH_DISTRIBUTIONS_N1 | Non Unique | Default | CASH_RECEIPT_ID |
| AR_MISC_CASH_DISTRIBUTIONS_N2 | Non Unique | Default | GL_DATE |
| AR_MISC_CASH_DISTRIBUTIONS_N3 | Non Unique | Default | GL_POSTED_DATE |
| AR_MISC_CASH_DISTRIBUTIONS_N4 | Non Unique | Default | POSTING_CONTROL_ID, GL_DATE |
| AR_MISC_CASH_DISTRIBUTIONS_N5 | Non Unique | Default | EVENT_ID |
| AR_MISC_CASH_DISTRIBUTIONS_U1 | Unique | Default | MISC_CASH_DISTRIBUTION_ID |