Data Feed 66 Release
- Installment Term Locale Enhancement (EXTRACT-10797)
- Added <coupon_assignment_level> to Plan Instance Coupon (EXTRACT-11213)
- Additional Fields added for Installment Schedule Including Fields From installment_term_installment_schedule (EXTRACT-11214)
- Surcharge Functionality Added To Installments (EXTRACT-11216)
- Surcharge Functionality Added To Tax Installments (EXTRACT-11217)
- Statement LOM Billing Group Reference Does Not Have <client_billing_group_id> Field (EXTRACT-10976)
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