Results for “igi_dun_cust_letter_set_lines”

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

Overview

The IGI_DUN_CUST_LETTER_SET_LINES table resides in the IGI schema, which supports Public Sector Financials International. It stores the currency-level detail values for each dunning letter defined within a customer dunning letter set. Dunning letters are used to notify customers of overdue receivables, and this table allows a single letter configuration to carry distinct monetary values per currency, reflecting the multi-currency operating environments common in public sector implementations.

From a Data Vault modeling perspective, the metadata suggests this object is satellite-leaning. Its structure — a composite business key extended by descriptive and monetary measures, with foreign key dependencies to upstream letter and currency definitions — is consistent with a satellite attached to core hub/link structures rather than a standalone hub. This classification is a heuristic modeling suggestion derived from the foreign key topology, not a normative EBS designation.

Key Information Stored

The table contains fifteen documented columns. The primary key, IGI_DUN_CUST_LET_SET_LINES_PK, is the composite of CUSTOMER_PROFILE_ID, DUNNING_LETTER_SET_ID, DUNNING_LINE_NUM, and CURRENCY_CODE. A unique index, IGI_DUN_CUST_LET_SET_LINES_U1, mirrors the same four columns, which is the business-key candidate governing row uniqueness.

The most significant columns include:

• CUSTOMER_PROFILE_ID — Identifies the customer profile to which the dunning letter set applies; part of the composite key and a foreign key into IGI_DUN_CUST_LETTER_SET_CUR.
• DUNNING_LETTER_SET_ID — Identifies the parent dunning letter set; part of the composite key.
• DUNNING_LINE_NUM — The line sequence number within the letter set, a key component and the attribute most commonly searched (dunning_line_num).
• CURRENCY_CODE — The currency in which the letter values are expressed; part of the composite key and the second foreign key column referencing IGI_DUN_CUST_LETTER_SET_CUR.
• DUNNING_LETTER_ID — References AR_DUNNING_LETTERS_B, linking the line to the underlying dunning letter definition.
• CUSTOMER_ID and SITE_USE_ID — Customer and site identifiers qualifying the letter recipient.
• LETTER_CHARGE_AMOUNT — Monetary charge applied at the letter level for the given currency.
• INVOICE_CHARGE_AMOUNT — Monetary charge applied at the invoice level for the given currency.
• CUSTOMER_PROFILE_CLASS_ID — Classifies the customer profile context for the line.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns maintained by the application.

Common Use Cases and Queries

Typical usage centers on retrieving the configured monetary values for a given letter, set, and currency, or auditing how letter charges vary across currencies. A representative query filters by the searched attribute:

• SELECT dunning_line_num, currency_code, letter_charge_amount, invoice_charge_amount FROM igi_dun_cust_letter_set_lines WHERE dunning_letter_set_id = :set_id ORDER BY dunning_line_num, currency_code;
• Joining to AR_DUNNING_LETTERS_B for letter text and to IGI_DUN_CUST_LETTER_SET_CUR for currency setup.
• Reporting charge-amount comparisons across currencies for multi-currency public sector customers.
• Validating configuration completeness by counting lines per set, profile, and currency.

Related Objects

• IGI_DUN_CUST_LETTER_SET_CUR — Referenced on CUSTOMER_PROFILE_ID and CURRENCY_CODE; the currency setup parent.
• AR_DUNNING_LETTERS_B — Referenced on DUNNING_LETTER_ID; the base dunning letter definitions.
• IGI_DUN_CUST_LETTER_SET_LINES_PK and IGI_DUN_CUST_LET_SET_LINES_U1 — Key and unique constraints enforcing row identity.
• Dunning letter set and customer profile configuration tables in the IGI schema, which supply the header context for DUNNING_LETTER_SET_ID and CUSTOMER_PROFILE_ID.