How does the XLA_DISTRIBUTION_LINKS table map to the Payables Subledger?

How does the XLA_DISTRIBUTION_LINKS table map to the Payables Subledger?

Module: Payables

Column – EVENT_ID:

Invoice/Payment

  1. In case of invoice it will be Invoice transaction event id.
  2. In case of payment it will be Payment transaction event id.

Column – AE_HEADER_ID:

Invoice/Payment

  1. In case of invoice it will be Invoice transaction ae header id.
  2. In case of payment it will be Payment transaction ae header id.

Column – AE_LINE_NUM:

Invoice/Payment

  1. AE_LINE_NUM helps to link XLA_AE_LINES  AE_LINE_NUM

Column – SOURCE_DISTRIBUTION_ID_NUM_1:

Invoice

  1. In case of Invoice it will be Invoice transaction invoice_distribution_id from ap_invoice_distributions_all table.

Payment

  1. In case of Payment it will be payment transaction payment_hist_dist_id from ap_payment_hist_dists table.  

Column – REF_AE_HEADER_ID:

Invoice

  1. In case of Invoice it will be Invoice transaction ae_header_id (or upstream transaction ae_header_id)

Payment

  1. In case of Payment it will be Invoice transaction ae_header_id

Column – REF_EVENT_ID:

Invoice

  1. In case of Invoice it will be Invoice transaction event_id (or upstream transaction event_id)

Payment

  1. In case of Payment it will be Invoice transaction event_id

Column – APPLIED_TO_ENTITY_CODE:

Invoice/Payment

  1. The entity code of the upstream/invoice transaction, e.g.

          ‘PURCHASE_ORDER’
‘AP_INVOICES’
‘AP_PAYMENTS’

  1. In case of invoice it will be “AP_INVOICES”
  2. In case of payment entered transaction mean when (Liability and Cash Clearing getting accounted) it will be “AP_INVOICES”.
  3. In case of payment cleared transaction mean when (Cash and Cash Clearing getting accounted) it will be “AP_PAYMENTS”.

Column – APPLIED_TO_ENTITY_ID:

Invoice/Payment

  1. The entity_id of the invoice/upstream transaction
  2. In case of invoice it will be null irrespective of accounting class(expense or liability)
  3. In case of payment entered transaction mean when (Liability and Cash Clearing getting accounted) when accounting class is “Cash Clearing” it will be null.
  4. In case of payment entered transaction mean when (Liability and Cash Clearing getting accounted) when accounting class “Liability” it will be invoice transaction entity_id.
  5. In case of payment cleared transaction mean when (Cash and Cash Clearing getting accounted) and accounting class is “Cash” it will be null.
  6. In case of payment cleared transaction mean when (Cash and Cash Clearing getting accounted) and accounting class is “Cash Clearing” it will be payment transaction entity_id.

Column – APPLIED_TO_SOURCE_ID_NUM_1:

Invoice/Payment

  1. In case of invoice it will be invoice_id
  2. In case of payment entered transaction mean when (Liability and Cash Clearing getting accounted) it will still be invoice_id from invoice transaction.
  3. In case of payment cleared transaction mean when (Cash and Cash Clearing getting accounted) it will be check_id from payment transaction.

Column – APPLIED_TO_DISTRIBUTION_TYPE:

Invoice/Payment

  1. The upstream transaction distribution type, e.g.,

‘PO_DISTRIBUTIONS_ALL’
‘AP_INV_DIST’
‘AP_PMT_DIST’

  1. In case of invoice it will be ‘AP_INV_DIST’.
  2. In case of payment entered transaction mean when (Liability and Cash Clearing getting accounted) it will still be ‘AP_INV_DIST’.
  3. In case of payment cleared transaction mean when (Cash and Cash Clearing getting accounted) it will be ‘AP_PMT_DIST’.

Column – APPLIED_TO_DIST_ID_NUM_1:

Invoice/Payment

  1. The upstream transaction distribution id.
  2. In case of invoice it will be invoice_distribution_id.
  3. In case of payment entered transaction mean when (Liability and Cash Clearing getting accounted) it will still be invoice_distribution_id.
  4. In case of payment cleared transaction mean when (Cash and Cash Clearing getting accounted) it will be payment_hist_dist_id from ap_payment_hist_dists table.

The ref_event_id is populated for JLTs that have Business flow Method = Prior Entry. 
The ref_event_id is referencing the upstream accounting that the downstream JLT needs to pull the account from.

Ref: Doc ID 813968.1

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s