AR_DISTRIBUTIONS_ALL
The AR_DISTRIBUTIONS_ALL table stores the accounting distributions for cash receipts, miscellaneous receipts, adjustments, credit memo applications, cash receipt applications, and bills receivable transactions. The records are joined to the AR_CASH_RECEIPT_HISTORY_ALL, AR_MISC_CASH_DISTRIBUTIONS_ALL, AR_ADJUSTMENTS, AR_RECEIVABLE_APPLICATIONS_ALL, and AR_TRANSACTION_HISTORY_ALL tables. . For cash receipt headers, the SOURCE_TABLE is CRH and the SOURCE_ID is AR_CASH_RECEIPT_HISTORY_ALL.CASH_RECEIPT_HISTORY_ID. The SOURCE_TYPE can be: CONFIRMATION, REMITTANCE, CASH, FACTOR, SHORT_TERM_DEBT and BANK_CHARGES. For receivable applications records, the SOURCE_TABLE is RA and the SOURCE_ID is AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID. The SOURCE_TYPE can be: REC for receivable accounts, EDISC for earned discounts, UNEDISC for unearned discounts, TAX for collectable tax, DEFERRED_TAX for deferred tax, EDISC_NON_REC for nonrecoverable earned discounts, UNEDISC_NON_REC for nonrecoverable unearned discounts, EXCH_GAIN for exchange gain, EXCH_LOSS for exchange loss and CURR_ROUND for currency rounding. For adjustment records, the SOURCE_TABLE is ADJ and the SOURCE_ID is AR_ADJUSTMENTS_ALL.ADJUSTMENT_ID. The SOURCE_TYPE can be: REC for receivable accounts, ADJ for adjustment accounts, FINCHRG for finance charges, ADJ_NON_REC for non-recoverable adjustments and FINCHRG_NON_REC for nonrecoverable finance charges. For miscellaneous receipt records, the SOURCE_TABLE is MCD and the SOURCE_ID is AR_MISC_CASH_DISTRIBUTIONS_ALL.MISC_CASH_DISTRIBUTIONS_ID. The SOURCE_TYPE can be MISCCASH for cash accounts and TAX for tax. For bills receivable records, the SOURCE_TABLE is TH and the SOURCE_ID is AR_TRANSACTION_HISTORY_ALL.TRANSACTION_HISTORY_ID. The SOURCE_TYPE can be DEFERRED_TAX for deferred tax, FACTOR for factor, REC for receivable, REMITTANCE for remittance, TAX for tax, and UNPAIDREC for unpaid bills. The primary keys for this table are SOURCE_ID, SOURCE_TABLE, and SOURCE_TYPE.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AR_DISTRIBUTIONS_PK |
LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LINE_ID | NUMBER | 18 | Yes | Uniquely identifier for rows in this table - primarily when these rows are passed to General Ledger | |
| SOURCE_ID | NUMBER | 18 | Yes | Identifier for record in SOURCE_TABLE that created this distribution. | |
| SOURCE_TABLE | VARCHAR2 | 10 | Yes | 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 | Yes | Account type of transaction for which distribution is posted. | |
| CODE_COMBINATION_ID | NUMBER | 18 | Yes | Foreign key to GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. It is the account to create the journals for. | |
| 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 | |||
| 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. | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| SOURCE_TABLE_SECONDARY | VARCHAR2 | 10 | Abbreviation that represents another table | ||
| SOURCE_ID_SECONDARY | NUMBER | 18 | Foreign key for entity in the SOURCE_TABLE_SECONDARY column | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Code defined for a currency | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Conversion rate. | |||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Supports multiple currency exchange rates for the same date | ||
| CURRENCY_CONVERSION_DATE | DATE | Date the currency was converted using the given exchange rate | |||
| TAX_ID | NUMBER | 18 | Tax identifier. | ||
| TAXABLE_ENTERED_DR | NUMBER | Taxable debit that lines of type Tax apply to | |||
| TAXABLE_ENTERED_CR | NUMBER | Taxable credit that lines of type Tax apply to | |||
| TAXABLE_ACCOUNTED_DR | NUMBER | Accounted taxable debit amount | |||
| TAXABLE_ACCOUNTED_CR | NUMBER | Accounted taxable credit amount | |||
| TAX_LINK_ID | NUMBER | 18 | Links tax and taxable lines within the AR_DISTRIBUTIONS table | ||
| REVERSAL_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| THIRD_PARTY_ID | NUMBER | 18 | Bill-to customer ID for transactions, paid-from customer ID for receipts | ||
| THIRD_PARTY_SUB_ID | NUMBER | 18 | Bill-to site use ID for transactions, customer site use ID for receipts | ||
| REVERSED_SOURCE_ID | NUMBER | 18 | The source ID that the reversal record was created from. Used for receipt application (APP) records to get the debit/credit for the gain/loss account. | ||
| TAX_CODE_ID | NUMBER | 18 | Foreign key to the AR_VAT_TAX table | ||
| LOCATION_SEGMENT_ID | NUMBER | 18 | Foreign key to the AR_LOCATION_VALUES table | ||
| SOURCE_TYPE_SECONDARY | VARCHAR2 | 30 | Oracle internal use only. | ||
| TAX_GROUP_CODE_ID | NUMBER | 18 | Foreign key to the AR_TAX_GROUP_CODES table to identify the tax code's tax group | ||
| REF_CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Transaction line identifier. | ||
| REF_CUST_TRX_LINE_GL_DIST_ID | NUMBER | 18 | Transaction line distribution identifier. | ||
| REF_ACCOUNT_CLASS | VARCHAR2 | 30 | Account Class to each this distribution is affected | ||
| ACTIVITY_BUCKET | VARCHAR2 | 30 | Amount bucket to each this distribution is associated | ||
| REF_LINE_ID | NUMBER | 18 | Reference to another distribution created via an adjustment | ||
| 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 functional currency based on the receipt | |||
| FROM_ACCTD_AMOUNT_CR | NUMBER | credit amount in the functional currency based on the receipt | |||
| REF_MF_DIST_FLAG | VARCHAR2 | 1 | Indicate if the distribution is created based on a Public Sector Financials distribution | ||
| REF_DIST_CCID | NUMBER | 18 | Maintains accounting code combination ID at time of application. Optimizes performance when code combination ID comes from distribution outside Receivables. | ||
| 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. | |
| REF_PREV_CUST_TRX_LINE_ID | NUMBER | 18 | Invoice line indentifier of credit memo |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_DISTRIBUTIONS_ALL | hz_cust_accounts | THIRD_PARTY_ID |
| AR_DISTRIBUTIONS_ALL | gl_code_combinations | CODE_COMBINATION_ID |
| ar_detailed_distributions_all | ar_distributions_all | SOURCE_DIST_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_DISTRIBUTIONS_N1 | Non Unique | Default | SOURCE_ID, SOURCE_TABLE, SOURCE_TYPE |
| AR_DISTRIBUTIONS_N2 | Non Unique | Default | SOURCE_ID_SECONDARY, SOURCE_TABLE_SECONDARY, SOURCE_TYPE_SECONDARY |
| AR_DISTRIBUTIONS_U2 | Unique | Default | LINE_ID |