AR_DETAILED_DISTRIBUTIONS_ALL
This table contains the prorated detailed accounting distributions derived from the AR_DISTRIBUTIONS_ALL table, along with their account balances.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AR_DETAILED_DISTRIBUTIONS_PK |
DETAILED_DIST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DETAILED_DIST_ID | NUMBER | 18 | Yes | Unique identifier of a record in this table that represents detailed distributions. | |
| SOURCE_DIST_ID | NUMBER | 18 | Yes | Unique identifier of the source distribution for which the detailed distributions are created. This is a foreign key to the table AR_DISTRIBUTIONS_ALL. | |
| PRIOR_DETAILED_DIST_ID | NUMBER | 18 | Unique identifier of the original detailed distribution entry in this table, used to create the reversal entry. | ||
| AMOUNT_DR | NUMBER | Distribution accounted debit amount. | |||
| AMOUNT_CR | NUMBER | Distribution accounted credit amount. | |||
| ACCTD_AMOUNT_DR | NUMBER | Journal entry accounted debit amount. | |||
| ACCTD_AMOUNT_CR | NUMBER | Journal entry accounted credit amount. | |||
| FROM_AMOUNT_DR | NUMBER | Debit amount in the currency of the cash receipt. | |||
| FROM_AMOUNT_CR | NUMBER | Credit amount in the currency of the cash receipt. | |||
| FROM_ACCTD_AMOUNT_DR | NUMBER | Debit amount in the ledger currency based on the receipt. | |||
| FROM_ACCTD_AMOUNT_CR | NUMBER | Credit amount in the ledger currency based on the receipt. | |||
| BALANCE_AMOUNT | NUMBER | Balance amount in the ledger currency that is available against the distribution account represented by this record after performing the current activity. | |||
| BALANCE_ACCTD_AMOUNT | NUMBER | Balance amount in the ledger currency that is available against the distribution account represented by this record after performing the current activity. | |||
| ASSOCIATED_DIST_ID | NUMBER | 18 | Yes | Unique identifier of the distribution that is used to prorate the activity amount on this split distribution. | |
| LATEST_ACTIVITY_FLAG | VARCHAR2 | 1 | Indicates whether the record represents the latest balance against the distribution account. | ||
| SOURCE_ID | NUMBER | 18 | Identifier of the record in the SOURCE_TABLE that created this prorated distribution. | ||
| SOURCE_TABLE | VARCHAR2 | 10 | 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 | Account type of transaction for which distribution is posted. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| 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. | ||
| 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. | |
| APP_SOURCE_ID | NUMBER | 18 | Unique identifier of the receivable application that is used on a receipt or credit memo. | ||
| CASH_RECEIPT_HISTORY_ID | NUMBER | 18 | Cash receipt history identifier. | ||
| AMOUNT_APPLIED | NUMBER | Total amount applied in the currency of the receipt and the transaction for prorating the amounts on detailed distributions. | |||
| AMOUNT_APPLIED_FROM | NUMBER | Total amount applied in the currency of the receipt for prorating the amounts on detailed distributions. This applies to cross-currency applications only. | |||
| EARNED_DISCOUNT_TAKEN | NUMBER | Amount of earned discount taken on the transaction while applying the receipt. | |||
| UNEARNED_DISCOUNT_TAKEN | NUMBER | Amount of unearned discount taken on the transaction while applying the receipt. | |||
| ACCTD_AMOUNT_APPLIED_FROM | NUMBER | Receipt amount in the ledger currency derived using the receipt conversion rate. | |||
| ACCTD_AMOUNT_APPLIED_TO | NUMBER | Receipt amount in the ledger currency applied to the transaction derived using the transaction conversion rate. | |||
| ACCTD_UNEARNED_DISCOUNT_TAKEN | NUMBER | Amount of earned discount in the ledger currency derived using the transaction conversion rate. | |||
| ACCTD_EARNED_DISCOUNT_TAKEN | NUMBER | Amount of unearned discount in the ledger currency derived using the transaction conversion rate. | |||
| REF_CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Referenced transaction line identifier. | ||
| REF_CUST_TRX_LINE_GL_DIST_ID | NUMBER | 18 | Transaction line distribution identifier. | ||
| REF_ACCOUNT_CLASS | VARCHAR2 | 30 | Account class associated with the split distribution. Possible values are FREIGHT for Freight account class, REC for Receivable account class, REV for Revenue account class, TAX for Tax account class, UNBILL for Unbilled Receivable account class, UNEARN for Unearned Revenue account class, ROUND for Rounding account class and SUSPENSE for Suspense account class. | ||
| ACTIVITY_BUCKET | VARCHAR2 | 30 | Amount bucket associated with the split distribution. | ||
| FROM_TO_CODE | VARCHAR2 | 1 | Indicates whether the record is for an Invoice, credit memo, or receipt. Used for internal program processing. | ||
| TAXABLE_ENTERED_DR | NUMBER | Debit taxable amount in transaction currency that is applicable on the activity. | |||
| TAXABLE_ENTERED_CR | NUMBER | Credit taxable amount in transaction currency that is applicable on the activity. | |||
| TAXABLE_ACCOUNTED_DR | NUMBER | Debit taxable amount in ledger currency that is applicable on the activity. | |||
| TAXABLE_ACCOUNTED_CR | NUMBER | Credit taxable amount in ledger currency that is applicable on the activity. | |||
| REF_DIST_CCID | NUMBER | 18 | Accounting code combination identifier used at the time of transaction application. This value optimizes performance when the code combination identifier comes from a distribution line outside of Receivables. | ||
| DETAILED_DIST_ENTRY | VARCHAR2 | 30 | Indicates whether the distribution requires multifund accounting. | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_DETAILED_DISTRIBUTIONS_ALL | ar_distributions_all | SOURCE_DIST_ID |
| AR_DETAILED_DISTRIBUTIONS_ALL | ar_cash_receipt_history_all | CASH_RECEIPT_HISTORY_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_DETAILED_DISTRIBUTIONS_N1 | Non Unique | Default | SOURCE_DIST_ID |
| AR_DETAILED_DISTRIBUTIONS_N2 | Non Unique | Default | ASSOCIATED_DIST_ID, LATEST_ACTIVITY_FLAG |
| AR_DETAILED_DISTRIBUTIONS_N3 | Non Unique | Default | CASH_RECEIPT_HISTORY_ID |
| AR_DETAILED_DISTRIBUTIONS_U1 | Unique | Default | DETAILED_DIST_ID |