How does the XLA_DISTRIBUTION_LINKS table map to the Fixed Asset Subledger

How does the XLA_DISTRIBUTION_LINKS table map to the Fixed Asset Subledger?

For transactions like Additions, Adjustments, and Retirements etc. the mapping is:

XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_1 = FA_ADJUSTMENTS.TRANSACTION_HEADER_ID

XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_2 = FA_ADJUSTMENTS.ADJUSTMENT_LINE_ID

For Depreciation event transaction rows:

XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_CHAR_4 = FA_DEPRN_DETAIL.BOOK_TYPE_CODE

XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_1 = FA_DEPRN_DETAIL.ASSET_ID

XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_2 = FA_DEPRN_DETAIL.PERIOD_COUNTER

XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_3 = FA_DEPRN_DETAIL.DEPRN_RUN_ID

XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_5 = FA_DEPRN_DETAIL.DISTRIBUTION_ID

Reference: Doc ID 2002464.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 )

Facebook photo

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

Connecting to %s