Results for “ja_au_bal_chg_source”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JA_AU_BAL_CHG_SOURCE is a transaction table in the JA (Asia/Pacific Localizations) product family, holding balancing charge source information for Australian asset accounting. Balancing charges arise when an asset is disposed of at a value that differs from its tax written-down value, and the difference must be adjusted for tax purposes. This table records the source records that contribute to a balancing charge computation, capturing the asset, its depreciation book, and the retirement event that triggered the charge. It functions as an operational detail table used by the Australian localizations for asset balancing charge reporting.

From a data modeling perspective, the foreign key structure (relationships to FA_BOOK_CONTROLS, FA_ADDITIONS_B, and FA_RETIREMENTS) suggests this table behaves as a link entity. It resolves a many-to-many style association between depreciation books, assets, and retirements, with each row representing a discrete balancing charge source event. The surrogate primary key, BAL_CHG_ID, uniquely identifies each row, while the business-key candidate composition is defined by the unique index JA_AU_BAL_CHG_SOURCE_U2 over BOOK_TYPE_CODE, ASSET_ID, and RETIREMENT_ID.

Key Information Stored

The table contains 29 documented columns. The most significant are:

• BAL_CHG_ID — Surrogate primary key, generated from JA_AU_BAL_CHG_SOURCE_PK. It also backs unique index JA_AU_BAL_CHG_SOURCE_U1.
• BOOK_TYPE_CODE — Identifies the depreciation book in FA_BOOK_CONTROLS that the balancing charge applies to.
• ASSET_ID — References the asset in FA_ADDITIONS_B whose retirement generated the charge.
• RETIREMENT_ID — References the specific retirement transaction in FA_RETIREMENTS.
• BAL_CHG_AMOUNT — The calculated balancing charge amount for the source record.
• BAL_CHG_APPLIED — Indicates whether the balancing charge has been applied or posted.
• BAL_CHG_STATUS — Current processing status of the balancing charge source record.
• DATE_RETIRED — The retirement date associated with the charge.
• ATTRIBUTE_CATEGORY_CODE and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield columns supporting localization-specific extensions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — Standard EBS audit/who columns maintained automatically by the application.

The combination of BOOK_TYPE_CODE, ASSET_ID, and RETIREMENT_ID forms the documented business-key candidate (JA_AU_BAL_CHG_SOURCE_U2), enforcing one source row per book, asset, and retirement combination.

Common Use Cases and Queries

Typical use cases center on Australian tax balancing charge reporting and reconciliation. Common queries include retrieving all balancing charge sources for a specific retirement, reconciling charges against the assets and books they reference, and reporting unapplied charges (BAL_CHG_APPLIED is null or zero) for a period. A representative pattern joining the key dimensions:

• Join to FA_ADDITIONS_B on ASSET_ID to obtain asset number and description.
• Join to FA_BOOK_CONTROLS on BOOK_TYPE_CODE to obtain the book name.
• Join to FA_RETIREMENTS on RETIREMENT_ID to obtain retirement details and proceeds.
• Filter by BAL_CHG_STATUS or BAL_CHG_APPLIED to isolate pending versus processed records.
• Aggregate BAL_CHG_AMOUNT by book and period for statutory reporting.

Related Objects

• FA_BOOK_CONTROLS — Referenced via BOOK_TYPE_CODE; defines the depreciation book.
• FA_ADDITIONS_B — Referenced via ASSET_ID; the asset master whose retirement triggers the charge.
• FA_RETIREMENTS — Referenced via RETIREMENT_ID; the retirement event producing the source record.
• JA_AU_BAL_CHG_SOURCE_PK / U1 / U2 — Primary and unique indexes enforcing row identity and the business key.
• JA_AU_BAL_CHG_* related tables — Other balancing charge processing tables in the JA schema that consume BAL_CHG_ID for further calculation and posting.