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

Primary Key

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