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.

SOURCE_TABLE

SOURCE_ID

SOURCE_TYPE

CRH

AR_CASH_RECEIPT_HISTORY_ALL.

CASH_RECEIPT_HISTORY_ID

  • CONFIRMATION

  • REMITTANCE

  • CASH

  • FACTOR

  • SHORT_TERM_DEBT

  • BANK_CHARGES

RA

AR_RECEIVABLE_APPLICATIONS_ALL.

RECEIVABLE_APPLICATION_ID

  • 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 non-recoverable earned discounts

  • UNEDISC_NON_REC for non-recoverable unearned discounts

  • EXCH_GAIN for exchange gain

  • EXCH_LOSS for exchange loss

  • CURR_ROUND for currency rounding

ADJ

AR_ADJUSTMENTS_ALL.ADJUSTMENT_ID

  • REC for receivable accounts

  • ADJ for adjustment accounts

  • FINCHRG for finance charges

  • ADJ_NON_REC for non-recoverable adjustments

  • FINCHRG_NON_REC for non-recoverable finance charges

MCD

AR_MISC_CASH_DISTRIBUTIONS_ALL.

MISC_CASH_DISTRIBUTIONS_ID

  • MISCCASH for cash accounts

  • TAX for tax

TH

AR_TRANSACTION_HISTORY_ALL.

TRANSACTION_HISTORY_ID

  • DEFERRED_TAX for deferred tax

  • FACTOR for factor

  • REC for receivable

  • REMITTANCE for remittance

  • TAX for tax

  • UNPAIDREC for unpaid bills


arrow
arrow
    全站熱搜
    創作者介紹
    創作者 Somebaby 的頭像
    Somebaby

    Oracle eBS經驗分享

    Somebaby 發表在 痞客邦 留言(0) 人氣()