1. User Guide
  2. Object Management
  3. Adding Management Ledger Class tables
  4. Unique Index

3.6.5 Unique Index

Ledger Class tables require unique index on the following columns:

  • IDENTITY_CODE
  • FISCAL_YEAR
  • CONSOLIDATION_CD
  • ISO_CURRENCY_CD
  • LEGAL_ENTITY_ID
  • BALANCE_TYPE_CD
  • FISCAL_MONTH
  • Key dimension columns

This unique index needs to be created on the custom Ledger Class table, post-model upload operation.