Skip to main content
Aria Knowledge Central

Data Feed 66 Release

Installment Term Locale Enhancement (EXTRACT-10797)

(Data Feed, Snowflake, Universal Connector)

A new field called <locale_details> has been added to the Installment Term object.

Sample <local_details> payload

"locale_details": [ { "description": "InstallmentTerm_Description_B5erVlg6huf37Zsse6Vn2mK7cZmUIy3T4Ccc7LmWhFH5nwRSc0Z3p5mNdVpQFGRqRCwmQsTj0EWCSRisZPuD656JGpLO4PN6o6EThaQgPngN4acINjH01usJQV5G8DhhRlpVtMpPkwG7HLDzjRybxSMTbNIgOCzkEbOr4s3fD4EwUvwfSnjEH6n45H0vZWrVKmybWCLXje5tZiB0g7NhNB4LD9thGi5TCkOzohGCGt4eOxrQn8YrjxPZPcBYXm5RFMIr9t4Siq5nSzcd", "locale": { "ids": { "locale_no": 10001 }, "type": "Locale" }, "name": "InstallmentTerm_Name_Z6OQvIdq7EfXkmvVgbFBaarg92DpcWKSiInO3aEgGPtHcvNL59pybDnNvipLFGkERnmepjzeVIJc9iA" }, { "description": "Tamil_InstallmentTerm_UPDATED_Description_B5erVlg6huf37Zsse6Vn2mK7cZmUIy3T4Ccc7LmWhFH5nwRSc0Z3p5mNdVpQFGRqRCwmQsTj0EWCSRisZPuD656JGpLO4PN6o6EThaQgPngN4acINjH01usJQV5G8DhhRlpVtMpPkwG7HLDzjRybxSMTbNIgOCzkEbOr4s3fD4EwUvwfSnjEH6n45H0vZWrVKmybWCLXje5tZiB0g7NhNB4LD9thGi5TCkOzohGCGt4eOxrQn8YrjxPZPcBYXm5RFMIr9t4Siq5nSzcd", "locale": { "ids": { "locale_no": 100101 }, "type": "Locale" }, "name": "TA_UP_lmentTerm_Name_Z6OQvIdq7EfXkmvVgbFBaarg92DpcWKSiInO3aEgGPtHcvNL59pybDnNvipLFGkERnmepjzeVIJc9iA" } 

Snowflake Tables

sharez.vm_it_locale_details
sharez.vc_it_locale_details

Added <coupon_assignment_level> to Plan Instance Coupon (EXTRACT-11213)

(Data Feed, Snowflake, Universal Connector)

A new field called <assignment_scope> has been added to Plan Instance Coupon Assignment object. Below are the available values for the <assignment_scope> field.

Value Description
1 'MPI Stack level (NULL- ensuring backward compatibility).'
2 'Specific Plan Instance level.'
3 'Specific Plan Instance level to given PI and also to its mandatory child plans.'

Sample Field Payload

"assignment_scope": { "ids": { "scope_no": 2 }, "type": "Assignment_Scope" }

Snowflake Tables

sharez.vm_plan_instance_coupon_assignment
sharez.vc_plan_instance_coupon_assignments

Additional Fields added for Installment Schedule Including Fields From installment_term_installment_schedule (EXTRACT-11214)

(Data Feed, Snowflake, Universal Connector)

In the core added few new fields in installment_schedule to support installment schedule update.

Added fields

  • surcharge_transaction
  • total_surcharge_amount
  • total_surcharge_tax_amount
  • is_modified
  • interval_type
  • interval_value
  • days_til_notify
  • days_til_due
  • order_line
  • installment_amount_threshold

Sample Payload

{ "account": { "ids": { "account_no": 293182, "userid": "BDAWJ" }, "type": "Account" }, "aligned_master_plan_instance": { "ids": { "client_plan_instance_id": "594662", "plan_instance_no": 594662 }, "type": "Plan_Instance" }, "billing_group": { "ids": { "billing_group_no": 306526, "client_billing_group_id": "306526" }, "type": "Billing_Group" }, "charge_transaction": { "ids": { "transaction_no": 5033737 }, "type": "Transaction" }, "created_tstamp": "2025-07-16T22:50:56+02:00", "days_til_due": 3, "days_til_notify": 2, "installment_amount_threshold": null, "installment_no": 6590, "installment_term": { "ids": { "client_term_id": "LumpSum_MwRoqphIE55fwnbK0IOsVXqWsIntgnhgf0FbYotyHDGct5pP87PugZ4VDLSDraFPoge44FWu3BnHWNaFIqCkMzoeu_Up", "term_no": 925 }, "type": "Installment_Term" }, "interval_type": { "ids": { "type_no": 1 }, "type": "Installment_Term_Interval_Type" }, "interval_value": 10, "invoice": { "ids": { "invoice_no": 1293128 }, "type": "Invoice" }, "is_aligned": false, "is_modified": false, "lump_sum": { "allocation": { "ids": { "type_cd": "P" }, "type": "Lump_Sum_Allocation" }, "amount": 150, "days_til_due": 3, "days_til_notify": 3, "is_aligned": false }, "number_of_installments": 6, "order_line": { "ids": { "line_no": 1, "order_no": 174920 }, "type": "Order_Line" }, "payment_status": { "ids": { "status_no": 1 }, "type": "Installment_Schedule_Payment_Status" }, "previous_installment_schedule": null, "status": { "ids": { "status_no": 0 }, "type": "Installment_Schedule_Status" }, "status_comment": null, "status_updated_tstamp": "2025-07-16T22:50:56+02:00", "surcharge_transaction": null, "total_charge_amount": 12, "total_surcharge_amount": 0, "total_surcharge_tax_amount": 0, "total_tax_amount": 0 }

Snowflake Tables
sharez.vm_installment_schedules
sharez.vc_installment_schedules

Surcharge Functionality Added To Installments (EXTRACT-11216)

(Data Feed, Snowflake, Universal Connector)

New fields have been added to the Installments object to support surcharge changes.

Added Fields

  • <due_charge_amount>
  • <due_surcharge_amount>
  • <surcharge_transaction>
  • <charge_transaction>

Note: The <due_amount> field has been deprecated and replaced with <due_charge_amount>.

Sample Payload

{ "charge_transaction": { "ids": { "transaction_no": 5033737 }, "type": "Transaction" }, "created_tstamp": "2025-07-16T22:50:56+02:00", "due_amount": 2, "due_charge_amount": 2, "due_date": "2025-09-09", "due_surcharge_amount": 0, "installment_no": 6590, "installment_schedule": { "ids": { "installment_no": 6590 }, "type": "Installment_Schedule" }, "is_closed": false, "notification": null, "notify_date": "2025-09-06", "seq_no": 6, "statement": null, "status": { "ids": { "status_no": 1 }, "type": "Installment_Status" }, "surcharge_transaction": null, "updated_tstamp": null }

Snowflake Tables

sharez.vm_installments
sharez.vc_installments

Surcharge Functionality Added To Tax Installments (EXTRACT-11217)

(Data Feed, Snowflake, Universal Connector)

New fields have been added to the Tax Installments object to support surcharge changes.

Added Fields

  • <due_charge_amount>
  • <due_surcharge_amount>
  • <surcharge_transaction>

Note: The <due_amount> field has been deprecated and replaced with <due_charge_amount>.

Sample Payload

{ "charge_transaction": { "ids": { "transaction_no": 3604819 }, "type": "Transaction" }, "created_tstamp": "2025-09-05T03:58:40+02:00", "due_amount": 0.01, "due_charge_amount": 0.01, "due_surcharge_amount": 0, "installment": { "ids": { "installment_no": 678, "seq_no": 9 }, "type": "Installment" }, "installment_no": 678, "installment_schedule": { "ids": { "installment_no": 678 }, "type": "Installment_Schedule" }, "installment_seq_no": 9, "status": { "ids": { "status_no": 1 }, "type": "Installment_Status" }, "surcharge_transaction": null, "tax_transaction": { "ids": { "transaction_no": 3604823 }, "type": "Transaction" }, "tax_transaction_no": 3604823, "updated_tstamp": null }

Snowflake Tables

sharez.vm_tax_installments
sharez.vc_tax_installments

Statement LOM Billing Group Reference Does Not Have <client_billing_group_id> Field (EXTRACT-10976)

(Data Feed, Snowflake, Universal Connector)

The field <client_billing_group_id> has been added as the billing group reference in the Statement LOM object. Previously, this field had been missing from the Statement LOM.

Sample Payload

"billing_group": { "ids": { "billing_group_no": 306657, "client_billing_group_id": "306657" },

Snowflake Tables

sharez.vm_statements

 

  • Was this article helpful?