Search Results ja_cn_dff_assignments




Overview
Explore in AI Chat

Overview

The JA_CN_DFF_ASSIGNMENTS table is a localization configuration object owned by the JA schema (Asia/Pacific Localizations). It stores the context codes and attribute column mappings for every Descriptive Flexfield (DFF) consumed by the CNAO (China National Accounting Office) reporting programs. Each row identifies a single Descriptive Flexfield by its application identifier and flexfield name, then maps a specific context and attribute segment to its underlying database column. In practice, this table functions as a metadata registry that allows CNAO processes to locate the appropriate flexfield segment values without hard-coding column names.

Under the heuristic Data Vault classification supplied in the ETRM metadata, this object is treated as standalone. In Data Vault modeling terms it is best understood as a reference satellite around the chart of accounts, since its only documented foreign key points to GL_MGT_SEG_UPGRADE_H. It carries descriptive mapping attributes rather than transaction facts, and it does not behave as a transaction hub or link.

Key Information Stored

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

The unique index JA_CN_DFF_ASSIGNMENTS_U1 on (CHART_OF_ACCOUNTS_ID, DFF_TITLE_CODE) is the documented business-key candidate, allowing one assignment per chart of accounts and flexfield title. No separate surrogate primary-key column is documented in the metadata; the composite unique index effectively acts as the identifier.

Common Use Cases and Queries

The primary use case is dynamic flexfield resolution inside CNAO reporting routines. Reports and interfaces join this table to flexfield value tables using APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_NAME, and CONTEXT_CODE to recover the correct ATTRIBUTE_COLUMN before reading the segment value.

A typical lookup query is:

  • SELECT context_code, attribute_column FROM ja.ja_cn_dff_assignments WHERE chart_of_accounts_id = :coa_id AND dff_title_code = :title;

Reporting use cases include reconciling which flexfields are configured for a given chart of accounts, auditing changes to flexfield assignments over time using the audit columns, and troubleshooting CNAO extraction failures where an expected context or attribute column is missing.

Related Objects

The documented foreign key links this table to GL_MGT_SEG_UPGRADE_H through CHART_OF_ACCOUNTS_ID. Other objects that interact with it in practice include: