Data Feed 60 Release

(EXTRACT-7438) Variant Column Child View Association

(Snowflake)

A new view field has been added to Snowflake. The new secure view sharez.vm_child_views shows the table and variant column combinations associations with their child view with the data cardinality broken out separately.

(EXTRACT-9114) Order and Order Line changes

(Data Feed, Universal Connector, Snowflake)

Added Suppfields in the Order LOM are available in the Snowflake view vm_order_supp_fields.

A new option has been added that allows you to create qualifiers on the order level. The qualifiers are displayed within the name of suppfields in Order LOM with the LOM structured as follows:

"order_no": 146982, "order_supp_fields": [ { "field_name": "78kg9RoX625vMUVjQUgNvpvKeRw7MyBZt5GT2rxWeiw2cMBYS5KXnPpD50fx3ZgtpQ0luDVjvatIuO4RHOdz7fKfmR6AH4cSbLTr", "field_value": "78kg9RoX625vMUVjQUgNvpvKeRw7MyBZt5GT2rxWeiw2cMBYS5KXnPpD50fx3ZgtpQ0luDVjvatIuO4RHOdz7fKfmR6AH4cSbLTr" }, { "field_name": "g25izY3mYgFgW4L7wwUwcc8lg7kCrnzQAMJY8lsMOdr5r4oFamZS2Vj2l8s9dMCb4xVFLI1aGiiisNTLpthl2QYfMXi4WB2Saby9", "field_value": "g25izY3mYgFgW4L7wwUwcc8lg7kCrnzQAMJY8lsMOdr5r4oFamZS2Vj2l8s9dMCb4xVFLI1aGiiisNTLpthl2QYfMXi4WB2Saby9" } ]

Added Client_order_line_id field in the Order_Lines LOM

We included the <client_order_line_id> field in the Order_Line LOM. This will field will also be a part of the 'ref' reference in Order_Line LOM wherever the LOM is referenced (Example transaction, etc).

The field in <client_order_line_id> in the Order_Line object will appear as follows:

"data": { "alt_label": "QA-NSO-SF-Test", "client_order_line_id": "3iWagdBJZxVt0KCGbuFASBoueso0rwfS8qlha7lprFFKqy7PWG9wWUyCWIa2fQNdH0GAborgZGScYzqEjFniX29t5gQ6cybcAn33", "destination_contact": null, "is_custom_rated": null, "label": "QA-NSO-SF-Test", "line_amount": 1, "line_comments": null, "line_no": 1, "long_description": "QA-NSO-SF-Test-Description", "nonsubscription_offering": { "ids": { "client_sku": "QA-NSO-SF-Test", "nonsubscription_offering_no": 6969 }, "type": "NonSubscription_Offering" }, "order": { "ids": { "order_no": 146982 }, "type": "Order" }, "service_location": null, "unit_amount": 1, "units": 1 }

Reference of the order line LOM will appear as follows:

"ref": { "ids": { "client_order_line_id": "3iWagdBJZxVt0KCGbuFASBoueso0rwfS8qlha7lprFFKqy7PWG9wWUyCWIa2fQNdH0GAborgZGScYzqEjFniX29t5gQ6cybcAn33", "line_no": 1, "order_no": 146982 }, "type": "Order_Line" }

The LOM objects that use the order line as reference are Order, Transaction, and Pending_invoice.

The changes listed above in the Added Client_order_line_id in Order_Lines LOM are available in the snowflake table vm_order_lines.client_order_line_id.

(EXTRACT-9580) Change in Contract Duration Data Store to Support Days/Weeks

(Data Feed, Universal Connector, Snowflake)

A new field <contract_interval> has been added to the Contract LOM. This new field holds the interval type and value that were previously held within the <contract_months> field. Currently, the existing <contract_months> field is being maintained in the Contract LOM for backward compatibility.

"contract_interval": { "interval_type": { "ids": { "type_no": 2 }, "type": "Contract_Interval_Type" }, "value": 1 }, "contract_months": null,

The addition of the <contract_interval> field is available in snowflake vm_contracts.contract_interval_type_no and vm_contracts.contract_interval_value with the maintenance of <contract_months> remaining.

(EXTRACT-9386) New field added in client dunning proc LOM

(Data Feed, Universal Connector, Snowflake)

A new field <include_all_subscriptions> has been added to the Dunning Process LOM. This field is a boolean used to support the “Include all Subscriptions for Dunning” option while creating a dunning process.

"include_all_subscriptions": true

The <include_all_subscriptions> field addition is available in vm_dunning_process.include_all_subscriptions.

(EXTRACT-9108) Adding <mandate_auth_date> in payment_method LOM (billing info table) 

(Data Feed, Universal Connector, Snowflake)

Multiple APIs now support <mandate_signature_data> input fields. This update ensures that the fields and events are populated correctly in Data Feed when we create or update objects from those APIs.