Skip to main content
Aria Knowledge Central

Data Feed 65 Release

Installment (EXTRACT-10156)

(Snowflake)

In Release 64 the Installment object was introduced to Data Feed and the Universal Connector, with the exception of the snowflake modifications. In release 65, the installment table was incorporated into Snowflake.

Snowflake Table / views
vm_installments
vc_installments

Installment Tax (EXTRACT-9736, EXTRACT-10158, EXTRACT-10161, EXTRACT-10467, EXTRACT-11328, EXTRACT-11064)

(Data Feed, Snowflake, Universal Connector)

In the data feed stream, the LOM object for installment tax is appended, as are the tax lines related to the installment. The subscription of this object will occur automatically the moment the installment schedule object is subscribed.
An additional outcome of the installment schedule will be the creation of an installment tax object.
Below is the Sample LOM how it looks in the stream

{ "action": "load", "client_no": 7000219, "data": { "charge_transaction": { "ids": { "transaction_no": 4671523 }, "type": "Transaction" }, "created_tstamp": "2025-05-21T09:42:20+02:00", "due_amount": 0.05, "installment": { "ids": { "installment_no": 5108, "seq_no": 19 }, "type": "Installment" }, "installment_no": 5108, "installment_schedule": { "ids": { "installment_no": 5108 }, "type": "Installment_Schedule" }, "installment_seq_no": 19, "status": { "ids": { "status_no": 2 }, "type": "Installment_Status" }, "tax_transaction": { "ids": { "transaction_no": 4671524 }, "type": "Transaction" }, "tax_transaction_no": 4671524, "updated_tstamp": "2025-05-21T09:42:30+02:00" }, "date": "2025-05-23T15:21:31+02:00", "ref": { "ids": { "installment_no": 5108, "installment_seq_no": 19, "tax_transaction_no": 4671524 }, "type": "Installment_Tax" }, "scn": 35877352797, "scnHandling": "FreshScn" }

Snowflake Table
vm_installment_taxes
vc_installment_taxes

Installment Application (EXTRACT-10785, EXTRACT-10786, EXTRACT-10788, EXTRACT-10789, EXTRACT-10799, EXTRACT-10992)

(Data Feed, Snowflake, Universal Connector)

Installment Application occurs whenever a payment is applied or not applied for an installment. The installment application will be automatically subscribed whenever the installment schedule is subscribed.
We have two events: one for the application of installments and another for the unapplication of installments.
When a payment is applied, the installment application object will be generated, and when the payment is unapplied for that installment, the delete object will be transmitted.
The Installment update object will be transmitted in conjunction with the installment application, as the status of the installment will be altered in the event of an application.

Sample Installment Application Creation

{ "action": "create", "client_no": 7000219, "data": { "account": { "ids": { "account_no": 280390, "client_account_id": "phiMb5qeBHNzCY2JeB6JZjMVriRBjn1folbFrTG1B2sFS6NcI5", "userid": "UEG5DNTBJ8R4T7Pa2n70UjdJehbfLNOH" }, "type": "Account" }, "application_no": 663434, "applied_amount": 0.29, "charge_transaction": { "ids": { "transaction_no": 4670150 }, "type": "Transaction" }, "charge_transaction_no": 4670150, "created_tstamp": "2025-05-16T15:11:44+02:00", "installment": { "ids": { "installment_no": 5016, "seq_no": 0 }, "type": "Installment" }, "installment_no": 5016, "installment_seq_no": 0, "payment_transaction": { "ids": { "transaction_no": 4670145 }, "type": "Transaction" }, "payment_transaction_no": 4670145 }, "date": "2025-05-16T15:11:58+02:00", "ref": { "ids": { "application_no": 663434, "charge_transaction_no": 4670150, "installment_no": 5016, "installment_seq_no": 0, "payment_transaction_no": 4670145 }, "type": "Installment_Application" }, "schemaVersion": { "isSnapshot": false, "major": 65, "minor": 8, "patch": 0 }, "scn": 35825441734, "scnHandling": "FreshScn", }

Sample Installment Application Deletion

{ "action": "delete", "client_no": 7000219, "data": {}, "date": "2025-05-22T17:32:58+02:00", "ref": { "ids": { "application_no": 663985, "charge_transaction_no": 4673340, "installment_no": 5376, "installment_seq_no": 4, "payment_transaction_no": 4673341 }, "type": "Installment_Application" }, "schemaVersion": { "isSnapshot": false, "major": 65, "minor": 8, "patch": 0 }, "scn": 35869529206, "scnHandling": "FreshScn", }

Snowflake Table
vm_installment_applications
vc_installment_applications

Installment Tax Application (EXTRACT-10800, EXTRACT-10801, EXTRACT-10802, EXTRACT-10803, EXTRACT-10804, EXTRACT-10805, EXTRACT-11322)

(Data Feed, Snowflake, Universal Connector)

The application of installment tax occurs whenever a payment is applied or unapplied for an installment tax line. When the installment schedule is subscribed, the Installment Tax application will be automatically subscribed.
We have two events: one for the application of installment taxes and another for the unapplication of installment taxes.
The installment tax application object will be generated upon the application of the payment, and the delete object will be conveyed upon the unapplication of the payment for that installment tax.
The application for installment tax will be accompanied by the installment tax update object, as the status of the installment tax will be altered in the event of an application.

Sample Installment tax application Object

{ "action": "create", "client_no": 7000219, "data": { "account": { "ids": { "account_no": 280404, "client_account_id": "rhfOuHfiTlFEmBFoGGi3whY4DRxkgnwe16Lp2BvPc4baUzEGPl", "userid": "QvQguyTWhKmy2vorhYF3ZsyGQKCjSP3s" }, "type": "Account" }, "application_no": 663473, "applied_amount": 0.2, "charge_transaction": { "ids": { "transaction_no": 4670590 }, "type": "Transaction" }, "charge_transaction_no": 4670590, "created_tstamp": "2025-05-19T12:45:00+02:00", "installment_no": 5029, "installment_seq_no": 1, "installment_tax": { "ids": { "installment_no": 5029, "installment_seq_no": 1, "tax_transaction_no": 4670594 }, "type": "Installment_Tax" }, "payment_transaction": { "ids": { "transaction_no": 4670589 }, "type": "Transaction" }, "payment_transaction_no": 4670589, "tax_transaction": { "ids": { "transaction_no": 4670594 }, "type": "Transaction" }, "tax_transaction_no": 4670594 }, "date": "2025-05-19T12:45:19+02:00", "ref": { "ids": { "application_no": 663473, "charge_transaction_no": 4670590, "installment_no": 5029, "installment_seq_no": 1, "payment_transaction_no": 4670589, "tax_transaction_no": 4670594 }, "type": "Installment_Tax_Application" }, "schemaVersion": { "isSnapshot": false, "major": 65, "minor": 8, "patch": 0 }, "scn": 35845900357, "scnHandling": "FreshScn", }


Sample Installment tax unapplication Object

{ "action": "delete", "client_no": 7000219, "data": {}, "date": "2025-05-22T16:40:43+02:00", "ref": { "ids": { "application_no": 663953, "charge_transaction_no": 4673248, "installment_no": 5365, "installment_seq_no": 0, "payment_transaction_no": 4673260, "tax_transaction_no": 4673249 }, "type": "Installment_Tax_Application" }, "schemaVersion": { "isSnapshot": false, "major": 65, "minor": 8, "patch": 0 }, "scn": 35869228000, "scnHandling": "FreshScn", }

Snowflake Tables
vm_installment_tax_applications
vc_installment_tax_applications

Subscription page for Installment Schedule, Installment, Installment Application, Installment Tax, and Installment Tax Application.

subscriptionpageforinstallmentschedule.png

Dashboard for Init Load

7af1fb5f-cbde-4fbc-9ac0-3f6a212ed256.png

Service Credits LOM (EXTRACT-10106)

(Data Feed, Snowflake, Universal Connector)

Corrected the typo in the column name and adjusted the column AMOUNT_RESERVED_FOR_ANNIVERSARY TO AMOUNT_REVERSED_FOR_ANNIVERSARY

 

  • Was this article helpful?