Benefit Template

Controls the active/inactive status of the benefit template record.

• Default Value: Checked (True)
• User Entry: User can Toggle On/Off
• Mandatory: No

• Toggled On (True): Template is Active and available for assignment to ADP Plans.
• Toggled Off (False): Template is Inactive and cannot be assigned to new plans.

• emaADPPlanBenefitTemplateHDR → Active (bit)

Unique name to identify the benefit template.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes
• Allowed Characters: Alphanumeric

Must be unique. Duplicate name should trigger an inline error: "Template name already exists."

• emaADPPlanBenefitTemplateHDR → Name (nvarchar)

Optional free-text description of the benefit template.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: No
• Allowed Characters: Alphanumeric

• emaADPPlanBenefitTemplateHDR → Decription (nvarchar)

Defines how the ADP plan collects contributions — by fixed installments or open contributions.

• Default Value: —
• Data Source: admMasterDataValueDTL
• Filter Condition:
  • Active = True, listed from MasterDataValueID
  • MasterDataCategory = ADPPlanStructureType
• User Entry: Selection from dropdown
• Mandatory: Yes
• Options:
  • Installment-Based — Plan collects contributions in fixed periodic installments.
  • Open Contribution — Plan allows flexible contribution amounts at any time.

• If Installment-Based → Slab section shows From Installment / To Installment fields.
• If Open Contribution → Rotation field becomes visible/applicable.

• emaADPPlanBenefitTemplateHDR → MasterDataValueID_ADPPlanStructureType

Determines the criteria used to evaluate benefit eligibility within each slab.

• Default Value: —
• Data Source: admMasterDataValueDTL
• Filter Condition:
  • Active = True, listed from MasterDataValueID
  • MasterDataCategory = ADPBenefitEligibilityType
• User Entry: Selection from dropdown
• Mandatory: Yes
• Options:
  • Installment Count — Benefit slab is defined by From/To installment number range.
  • Days From Joining — Benefit slab is defined by From/To days range from plan enrollment date.
  • Collection Count — Benefit slab is defined by From/To collection count range.

• Controls which range fields are shown in the Slab section:
  • Installment Count → Shows From Installment, To Installment, Min Days Completed.
  • Days From Joining → Shows From Days, To Days, Min Installments Paid.
  • Collection Count → Shows From Collection, To Collection, Min Days Completed.

• emaADPPlanBenefitTemplateHDR → MasterDataValueID_ADPBenefitEligibilityType

Specifies one or more modes through which plan benefits are settled at maturity.

• Default Value: —
• Data Source: admMasterDataValueDTL
• Filter Condition:
  • Active = True, listed from MasterDataValueID
  • MasterDataCategory = ADPBenefitSettlementMode
• User Entry: Multi-selection from dropdown
• Mandatory: Yes
• Options:
  • Invoice Adjustment — Benefit applied directly against invoice at billing.
  • Customer Advance Credit — Benefit credited to customer's advance account.
  • Order Advance Adjustment — Benefit adjusted against an existing order advance.
  • Collection Adjustment — Benefit adjusted within the collection itself.
  • Enrollment Benefit — Benefit granted at the time of plan enrollment.
  • CDU Collection Adjustment — Benefit adjustment through CDU channel collection.

• emaADPPlanBenefitTemplateSettlementModeDTL → MasterDataValueID_ADPBenefitSettlementMode (one row per selected mode)

Defines the rotation count applicable for the plan template.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: No
• Allowed Characters: Numeric (integer)

• emaADPPlanBenefitTemplateHDR → Rotation (int)

Minimum wastage percentage allowed for plan benefit calculation.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: No
• Allowed Characters: Numeric (decimal)

Must be less than or equal to Max Wastage %.

Enabled when "Wastage Waiver" is selected in Benefit Applied On.

• emaADPPlanBenefitTemplateHDR → MinWastagePercent (decimal)

Maximum wastage percentage allowed for plan benefit calculation.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: No
• Allowed Characters: Numeric (decimal)

Must be greater than or equal to Min Wastage %.

Enabled when "Wastage Waiver" is selected in Benefit Applied On.

• emaADPPlanBenefitTemplateHDR → MaxWastagePercent (decimal)

Minimum making charge amount allowed for plan benefit calculation.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: No
• Allowed Characters: Numeric (decimal)

Must be less than or equal to Max Making Amount.

Enabled when "Making Charge Waiver" is selected in Benefit Applied On.

• emaADPPlanBenefitTemplateHDR → MinMakingAmount (decimal)

Maximum making charge amount allowed for plan benefit calculation.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: No
• Allowed Characters: Numeric (decimal)

Must be greater than or equal to Min Making Amount.

Enabled when "Making Charge Waiver" is selected in Benefit Applied On.

• emaADPPlanBenefitTemplateHDR → MaxMakingAmount (decimal)

A grid listing all available benefit types. User selects which benefit types apply to this template and optionally sets a priority order for applicable items.

• Default Value: Unchecked (False) for each row
• User Entry: User can Check/Uncheck per row; enter Priority for priority-eligible rows
• Mandatory: At least one benefit item must be selected before Save
• Data Source: admMasterDataValueDTL
• Filter Condition:
  • Active = True, listed from MasterDataValueID
  • MasterDataCategory = ADPBenefitAppliedOn
• Columns: Checkbox, Applied On (label), Priority (input — applicable rows only)

• Bonus Percentage — No priority input
• Bonus Amount — No priority input
• Bonus Weight — No priority input
• Making Charge Waiver — No priority input
• Wastage Waiver — No priority input
• Tax Waiver — No priority input
• Interest Benefit — No priority input
• Stone Value Discount — Priority input shown. Mandatory when checked. Must be a unique integer (e.g., 1, 2, 3). Duplicate priority values not allowed.
• Diamond Value Discount — Priority input shown. Mandatory when checked. Must be a unique integer (e.g., 1, 2, 3). Duplicate priority values not allowed.
• Fixed Stone Rate — Priority input shown. Mandatory when checked. Must be a unique integer (e.g., 1, 2, 3). Duplicate priority values not allowed.
• Metal Rate Discount — No priority input
• Average Metal Rate — No priority input

• Checking Wastage Waiver → Enables Min Wastage % and Max Wastage % fields in header.
• Checking Making Charge Waiver → Enables Min Making Amount and Max Making Amount fields in header.
• Checking Stone Value Discount or Diamond Value Discount or Fixed Stone Rate → Makes the corresponding Stone/Diamond Discount panel available in the Slab section.

• emaADPPlanBenefitTemplateBenefitAppliedOnDTL → MasterDataValueID_ADPBenefitAppliedOn, PriorityOrder (one row per checked item)

Starting installment number of the slab range.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes (when Benefit Eligibility Type = Installment Count)
• Allowed Characters: Numeric (integer)

Visible only when Benefit Eligibility Type = Installment Count.

Must be less than To Installment. Slabs must not overlap.

• emaADPPlanBenefitTemplateSlabDTL → FromInstallmentNo

Ending installment number of the slab range.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes (when Benefit Eligibility Type = Installment Count)
• Allowed Characters: Numeric (integer)

Visible only when Benefit Eligibility Type = Installment Count.

Must be greater than From Installment. Slabs must not overlap.

• emaADPPlanBenefitTemplateSlabDTL → ToInstallmentNo

Starting day number (from plan joining date) of the slab range.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes (when Benefit Eligibility Type = Days From Joining)
• Allowed Characters: Numeric (integer)

Visible only when Benefit Eligibility Type = Days From Joining.

Must be less than To Days. Slabs must not overlap.

• emaADPPlanBenefitTemplateSlabDTL → FromDays

Ending day number (from plan joining date) of the slab range.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes (when Benefit Eligibility Type = Days From Joining)
• Allowed Characters: Numeric (integer)

Visible only when Benefit Eligibility Type = Days From Joining.

Must be greater than From Days. Slabs must not overlap.

• emaADPPlanBenefitTemplateSlabDTL → ToDays

Starting collection count of the slab range.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes (when Benefit Eligibility Type = Collection Count)
• Allowed Characters: Numeric (integer)

Visible only when Benefit Eligibility Type = Collection Count.

Must be less than To Collection. Slabs must not overlap.

• emaADPPlanBenefitTemplateSlabDTL → FromCollectionCount

Ending collection count of the slab range.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes (when Benefit Eligibility Type = Collection Count)
• Allowed Characters: Numeric (integer)

Visible only when Benefit Eligibility Type = Collection Count.

Must be greater than From Collection. Slabs must not overlap.

• emaADPPlanBenefitTemplateSlabDTL → ToCollectionCount

Minimum number of days the customer must have been enrolled before this slab benefit applies.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: No
• Allowed Characters: Numeric (integer)

Visible when Benefit Eligibility Type = Installment Count or Collection Count.

• emaADPPlanBenefitTemplateSlabDTL → MinDaysCompleted

Minimum number of installments the customer must have paid for this slab benefit to apply.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: No
• Allowed Characters: Numeric (integer)

Visible only when Benefit Eligibility Type = Days From Joining.

• emaADPPlanBenefitTemplateSlabDTL → MinInstallmentsPaid

Amount that can be deferred/adjusted for the customer under this slab.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: No
• Allowed Characters: Numeric (decimal)

• emaADPPlanBenefitTemplateSlabDTL → DeferralAmount

Fixed bonus amount awarded to the customer under this slab.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes (when Benefit Applied On includes Bonus Amount)
• Allowed Characters: Numeric (decimal)

• emaADPPlanBenefitTemplateSlabDTL → BonusAmount

Bonus awarded as a percentage of the plan value under this slab.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes (when Benefit Applied On includes Bonus Percent)
• Allowed Characters: Numeric (decimal)

• emaADPPlanBenefitTemplateSlabDTL → BonusPercentage

Bonus awarded in weight units (e.g., grams) under this slab.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes (when Benefit Applied On includes Bonus Weight)
• Allowed Characters: Numeric (decimal)

• emaADPPlanBenefitTemplateSlabDTL → BonusWeight

Interest benefit percentage applicable for this slab.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes (when Benefit Applied On includes Interest Benefit)
• Allowed Characters: Numeric (decimal)

• emaADPPlanBenefitTemplateSlabDTL → InterestPercent

Discount percentage applied on metal rate under this slab.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes (when Benefit Applied On includes Metal Rate Discount)
• Allowed Characters: Numeric (decimal)

• emaADPPlanBenefitTemplateSlabDTL → MetalRateDiscountPercent

Discount percentage applied on Total stone value under this slab.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes (when Benefit Applied On includes Stone Value Discount)
• Allowed Characters: Numeric (decimal)

• emaADPPlanBenefitTemplateSlabDTL → StoneValueDiscountPercent

Wastage percentage to be waived under this slab.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes (when Benefit Applied On includes Wastage Waiver)
• Allowed Characters: Numeric (decimal)

• emaADPPlanBenefitTemplateSlabDTL → WaiverWastagePercent

Making charge percentage to be waived under this slab.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes (when Benefit Applied On includes Making Charge Waiver)
• Allowed Characters: Numeric (decimal)

• emaADPPlanBenefitTemplateSlabDTL → WaiverMakingPercent

Adds the currently entered slab data as a row in the slab grid.

• User Entry: Manual click by user
• Mandatory: No — at least one slab row is required before Save

• Validates all mandatory slab fields before adding.
• Validates slab range does not overlap with existing slabs.
• On success: appends slab as an inline row in the slab grid with a Remove option.
• On failure: shows inline validation error.
• Multiple slabs can be added (multiple adding supported).

Determines the level at which diamond discount is configured.

• Default Value: —
• Data Source: admMasterDataValueDTL
• Filter Condition:
  • Active = True, listed from MasterDataValueID
  • MasterDataCategory = VendorStoneRateSetUpType
• User Entry: Selection from dropdown
• Mandatory: Yes (when Diamond Value Discount is selected)
• Options:
  • Stone Group — Discount defined at the stone group (type) level.
  • Stone Category — Discount defined at the category level within a stone group.
  • Stone Sub Category — Discount defined at the sub-category level.
  • Stone Attribute Wise — Discount defined per stone attribute (e.g., color, clarity).
  • Stone Article — Discount defined per individual stone article catalog entry.

• Stone Group → Shows: Stone Group (multi-select), Diamond Discount %.
• Stone Category → Shows: Stone Group (multi-select), Stone Category (multi-select), Diamond Discount %.
• Stone Sub Category → Shows: Stone Group (multi-select), Stone Category (multi-select), Stone Sub Category (multi-select), Diamond Discount %.
• Stone Attribute Wise → Shows: Stone Attribute Type (single-select), Stone Group (multi-select), Stone Category (multi-select), Stone Sub Category (multi-select), Attribute Value (multi-select), Diamond Discount %.
• Stone Article → Shows: Stone Article (multi-select), Diamond Discount %. All other fields are for filtration only.

• emaADPPlanBenefitTemplateDiamondStoneDiscountDTL → MasterDataValueID_VendorStoneRateSetUpType (Stone Group)
• emaADPPlanBenefitTemplateDiamondStoneCategoryDiscountDTL → MasterDataValueID_VendorStoneRateSetUpType (Stone Category)
• emaADPPlanBenefitTemplateDiamondStoneSubCategoryDiscountDTL → MasterDataValueID_VendorStoneRateSetUpType (Stone Sub Category)
• emaADPPlanBenefitTemplateDiamondStoneAttributeDiscountDTL → MasterDataValueID_VendorStoneRateSetUpType (Stone Attribute Wise)
• emaADPPlanBenefitTemplateDiamondStoneArticleDiscountDTL → MasterDataValueID_VendorStoneRateSetUpType (Stone Article)

Selects the stone group(s) for which the diamond discount applies.

• Default Value: —
• Data Source: invStone & invStoneArticleCatalog
• Filter Condition:
  • Active = True, listed from StoneID
  • Linked Stone Article Configuration
  • MasterDataValueID_Stone = Diamond
• User Entry: Multi-selection from dropdown
• Mandatory: Yes

• emaADPPlanBenefitTemplateDiamondStoneDiscountDTL → StoneID (Stone Group)
• emaADPPlanBenefitTemplateDiamondStoneCategoryDiscountDTL → StoneID (Stone Category)
• emaADPPlanBenefitTemplateDiamondStoneSubCategoryDiscountDTL → StoneID (Stone Sub Category)
• emaADPPlanBenefitTemplateDiamondStoneAttributeDiscountDTL → StoneID (Stone Attribute Wise)
• emaADPPlanBenefitTemplateDiamondStoneArticleDiscountDTL → StoneID (Stone Article)

Selects the stone category(ies) under the selected stone group for which the diamond discount applies.

• Default Value: —
• Data Source: invStoneCategory & invStoneArticleCatalog
• Filter Condition:
  • Active = True, listed from StoneCategoryID
  • Filtered by selected StoneID (Stone Group)
  • Linked Stone Article Configuration
  • MasterDataValueID_Stone = Diamond
• User Entry: Multi-selection from dropdown
• Mandatory: Yes (when Stone Setup Type = Stone Category, Stone Sub Category, or Stone Attribute Wise)

Visible only when Stone Setup Type = Stone Category, Stone Sub Category, or Stone Attribute Wise.

• emaADPPlanBenefitTemplateDiamondStoneCategoryDiscountDTL → StoneCategoryID (Stone Category)
• emaADPPlanBenefitTemplateDiamondStoneSubCategoryDiscountDTL → StoneCategoryID (Stone Sub Category)
• emaADPPlanBenefitTemplateDiamondStoneAttributeDiscountDTL → StoneCategoryID (Stone Attribute Wise)

Selects the stone sub-category(ies) under the selected stone category for which the diamond discount applies.

• Default Value: —
• Data Source: invStoneSubCategory & invStoneArticleCatalog
• Filter Condition:
  • Active = True, listed from StoneSubCategoryID
  • Filtered by selected StoneCategoryID (Stone Category)
  • Linked Stone Article Configuration
  • MasterDataValueID_Stone = Diamond
• User Entry: Multi-selection from dropdown
• Mandatory: Yes (when Stone Setup Type = Stone Sub Category or Stone Attribute Wise)

Visible only when Stone Setup Type = Stone Sub Category or Stone Attribute Wise.

• emaADPPlanBenefitTemplateDiamondStoneSubCategoryDiscountDTL → StoneSubCategoryID (Stone Sub Category)
• emaADPPlanBenefitTemplateDiamondStoneAttributeDiscountDTL → StoneSubCategoryID (Stone Attribute Wise)

Selects the attribute type (e.g., Color, Clarity) used to further classify the stone for diamond discount.

• Default Value: —
• Data Source: admMasterDataValueDTL
• Filter Condition:
  • Active = True, listed from MasterDataValueID
  • MasterDataCategory = StoneAttributeType (1 to 15 dynamic categories)
• User Entry: Single selection from dropdown
• Mandatory: Yes (when Stone Setup Type = Stone Attribute Wise)

Visible only when Stone Setup Type = Stone Attribute Wise. Drives the values available in the Stone Attribute dropdown.

• emaADPPlanBenefitTemplateDiamondStoneAttributeDiscountDTL → MasterDataValueID_StoneAttributeType

Selects the specific attribute value(s) (e.g., D color, VVS clarity) under the selected attribute type for diamond discount.

• Default Value: —
• Data Source: invStoneAttribute & invStoneArticleCatalog
• Filter Condition:
  • Active = True, listed from StoneAttributeID
  • Filtered by selected MasterDataValueID_StoneAttributeType
  • Linked Stone Article Configuration
  • MasterDataValueID_Stone = Diamond
• User Entry: Multi-selection from dropdown
• Mandatory: Yes (when Stone Setup Type = Stone Attribute Wise)

Visible only when Stone Setup Type = Stone Attribute Wise.

• emaADPPlanBenefitTemplateDiamondStoneAttributeDiscountDTL → StoneAttributeID (one row per selection)

Selects the specific stone article catalog entry(ies) for which the diamond discount applies.

• Default Value: —
• Data Source: invStoneArticleCatalog
• Filter Condition:
  • Active = True, listed from StoneArticleCatalogID
  • Filtered by selected StoneID, StoneCategoryID, StoneSubCategoryID (for filtration only)
  • Linked Stone Article Configuration
  • MasterDataValueID_Stone = Diamond
• User Entry: Multi-selection from dropdown
• Mandatory: Yes (when Stone Setup Type = Stone Article)

Visible only when Stone Setup Type = Stone Article.

• emaADPPlanBenefitTemplateDiamondStoneArticleDiscountDTL → StoneArticleCatalogID (one row per selection)

The discount percentage to be applied on diamond/stone value.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes
• Allowed Characters: Numeric (decimal)

• Respective Diamond Discount DTL → DiamondDiscountPercent

Determines the level at which the fixed stone rate is configured.

• Default Value: —
• Data Source: admMasterDataValueDTL
• Filter Condition:
  • Active = True, listed from MasterDataValueID
  • MasterDataCategory = VendorStoneRateSetUpType
• User Entry: Selection from dropdown
• Mandatory: Yes (when Fixed Stone Rate is selected)
• Options:
  • Stone Group — Rate defined at the stone group (type) level.
  • Stone Category — Rate defined at the category level within a stone group.
  • Stone Sub Category — Rate defined at the sub-category level.
  • Stone Attribute Wise — Rate defined per stone attribute (e.g., color, clarity).
  • Stone Article — Rate defined per individual stone article catalog entry.

• Stone Group → Shows: Stone Group (multi-select), Stone Rate.
• Stone Category → Shows: Stone Group (multi-select), Stone Category (multi-select), Stone Rate.
• Stone Sub Category → Shows: Stone Group (multi-select), Stone Category (multi-select), Stone Sub Category (multi-select), Stone Rate.
• Stone Attribute Wise → Shows: Stone Attribute Type (single-select), Stone Group (multi-select), Stone Category (multi-select), Stone Sub Category (multi-select), Attribute Value (multi-select), Stone Rate.
• Stone Article → Shows: Stone Article (multi-select), Stone Rate. All other fields are for filtration only.

• emaADPPlanBenefitTemplateStoneRateDTL → MasterDataValueID_VendorStoneRateSetUpType (Stone Group)
• emaADPPlanBenefitTemplateStoneCategoryRateDTL → MasterDataValueID_VendorStoneRateSetUpType (Stone Category)
• emaADPPlanBenefitTemplateStoneSubCategoryRateDTL → MasterDataValueID_VendorStoneRateSetUpType (Stone Sub Category)
• emaADPPlanBenefitTemplateStoneAttributeDiscountDTL → MasterDataValueID_VendorStoneRateSetUpType (Stone Attribute Wise)
• emaADPPlanBenefitTemplateStoneArticleRateDTL → MasterDataValueID_VendorStoneRateSetUpType (Stone Article)

Selects the stone group(s) for which the fixed stone rate applies.

• Default Value: —
• Data Source: invStone & invStoneArticleCatalog
• Filter Condition:
  • Active = True, listed from StoneID
  • Linked Stone Article Configuration
• User Entry: Multi-selection from dropdown
• Mandatory: Yes

• emaADPPlanBenefitTemplateStoneRateDTL → StoneID (Stone Group)
• emaADPPlanBenefitTemplateStoneCategoryRateDTL → StoneID (Stone Category)
• emaADPPlanBenefitTemplateStoneSubCategoryRateDTL → StoneID (Stone Sub Category)
• emaADPPlanBenefitTemplateStoneAttributeDiscountDTL → StoneID (Stone Attribute Wise)
• emaADPPlanBenefitTemplateStoneArticleRateDTL → StoneID (Stone Article)

Selects the stone category(ies) under the selected stone group for which the fixed stone rate applies.

• Default Value: —
• Data Source: invStoneCategory & invStoneArticleCatalog
• Filter Condition:
  • Active = True, listed from StoneCategoryID
  • Filtered by selected StoneID (Stone Group)
  • Linked Stone Article Configuration
• User Entry: Multi-selection from dropdown
• Mandatory: Yes (when Stone Setup Type = Stone Category, Stone Sub Category, or Stone Attribute Wise)

Visible only when Stone Setup Type = Stone Category, Stone Sub Category, or Stone Attribute Wise.

• emaADPPlanBenefitTemplateStoneCategoryRateDTL → StoneCategoryID (Stone Category)
• emaADPPlanBenefitTemplateStoneSubCategoryRateDTL → StoneCategoryID (Stone Sub Category)
• emaADPPlanBenefitTemplateStoneAttributeDiscountDTL → StoneCategoryID (Stone Attribute Wise)

Selects the stone sub-category(ies) under the selected stone category for which the fixed stone rate applies.

• Default Value: —
• Data Source: invStoneSubCategory & invStoneArticleCatalog
• Filter Condition:
  • Active = True, listed from StoneSubCategoryID
  • Filtered by selected StoneCategoryID (Stone Category)
  • Linked Stone Article Configuration
• User Entry: Multi-selection from dropdown
• Mandatory: Yes (when Stone Setup Type = Stone Sub Category or Stone Attribute Wise)

Visible only when Stone Setup Type = Stone Sub Category or Stone Attribute Wise.

• emaADPPlanBenefitTemplateStoneSubCategoryRateDTL → StoneSubCategoryID (Stone Sub Category)
• emaADPPlanBenefitTemplateStoneAttributeDiscountDTL → StoneSubCategoryID (Stone Attribute Wise)

Selects the attribute type (e.g., Color, Clarity) used to further classify the stone for fixed stone rate.

• Default Value: —
• Data Source: admMasterDataValueDTL
• Filter Condition:
  • Active = True, listed from MasterDataValueID
  • MasterDataCategory = StoneAttributeType (1 to 15 dynamic categories)
• User Entry: Single selection from dropdown
• Mandatory: Yes (when Stone Setup Type = Stone Attribute Wise)

Visible only when Stone Setup Type = Stone Attribute Wise. Drives the values available in the Stone Attribute dropdown.

• emaADPPlanBenefitTemplateStoneAttributeDiscountDTL → MasterDataValueID_StoneAttributeType

Selects the specific attribute value(s) (e.g., D color, VVS clarity) under the selected attribute type for fixed stone rate.

• Default Value: —
• Data Source: invStoneAttribute & invStoneArticleCatalog
• Filter Condition:
  • Active = True, listed from StoneAttributeID
  • Filtered by selected MasterDataValueID_StoneAttributeType
  • Linked Stone Article Configuration
• User Entry: Multi-selection from dropdown
• Mandatory: Yes (when Stone Setup Type = Stone Attribute Wise)

Visible only when Stone Setup Type = Stone Attribute Wise.

• emaADPPlanBenefitTemplateStoneAttributeDiscountDTL → StoneAttributeID (one row per selection)

Selects the specific stone article catalog entry(ies) for which the fixed stone rate applies.

• Default Value: —
• Data Source: invStoneArticleCatalog
• Filter Condition:
  • Active = True, listed from StoneArticleCatalogID
  • Filtered by selected StoneID, StoneCategoryID, StoneSubCategoryID (for filtration only)
  • Linked Stone Article Configuration
• User Entry: Multi-selection from dropdown
• Mandatory: Yes (when Stone Setup Type = Stone Article)

Visible only when Stone Setup Type = Stone Article.

• emaADPPlanBenefitTemplateStoneArticleRateDTL → StoneArticleCatalogID (one row per selection)

Fixed rate amount to be applied on the stone for benefit calculation.

• Default Value: Empty
• User Entry: Manual input by user
• Mandatory: Yes
• Allowed Characters: Numeric (decimal)

• Respective Stone Rate DTL → StoneRate

Validates all form data and persists the benefit template record.

• User Entry: Manual click by user
• Mandatory: Yes

• Validates all mandatory fields across header, slab, and stone/diamond panels.
• Inserts HDR record + all applicable DTL records.
• Sets ApprovalStatus = Pending on HDR.
• On failure: displays inline validation errors without closing the form.

Resets all form fields to their default state without saving.

• User Entry: Manual click by user
• Mandatory: No

• Clears all header fields, slab grid rows, and stone/diamond panel entries.
• No data is saved. Form returns to blank Add mode.