How does the XLA_DISTRIBUTION_LINKS table map to the Payables Subledger?

How does the XLA_DISTRIBUTION_LINKS table map to the Payables Subledger?

This table contains the link between transactions and subledger journal entry lines.

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

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

Payment

2. 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’

2. In case of invoice it will be “AP_INVOICES”
3. In case of payment entered transaction mean when (Liability and Cash Clearing getting accounted) it will be “AP_INVOICES”.
4. 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’

2. In case of invoice it will be ‘AP_INV_DIST’.
3. In case of payment entered transaction mean when (Liability and Cash Clearing getting accounted) it will still be ‘AP_INV_DIST’.
4. 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