Data Feed 59 Release
Data Feed - 59 Release Notes
Data Feed
(EXTRACT-9236, EXTRACT-9447, EXTRACT-9357) Updates to the usage_record Logical Object Model (LOM)
The following fields have been added to the usage_record LOM:
- is_pre_invoice_tax_inclusive
- pre_invoice_taxation_status
- taxation_address
- internal_rate_history_sequence_no
- service
Sample Payload
"data": { "account": { "ids": { "account_no": 243426, "userid": "NVYHF" }, "type": "Account" }, "amount": 550, "billable_units": 10, "client_exclude_reason_cd": null, "client_usage_record_id": null, "comments": null, "exclude_tstamp": null, "exclude_user": null, "exclusion_comments": null, "internal_rate_history_sequence_no": 1680268, "invoice": null, "is_excluded": false, "is_pre_invoice_tax_inclusive": false, "plan": { "ids": { "client_plan_id": "Usage_3", "plan_no": 29410 }, "type": "Plan" }, "plan_instance": { "ids": { "client_plan_instance_id": "482226", "plan_instance_no": 482226 }, "type": "Plan_Instance" }, "pre_invoice_taxation_status": { "ids": { "taxation_status_no": 0 }, "type": "Taxation_Status" }, "qualifier_1": null, "qualifier_2": null, "qualifier_3": null, "qualifier_4": null, "rate": 55, "service": { "ids": { "client_service_id": "UT_R58_1", "service_no": 11086924 }, "type": "Service" }, "taxation_address": null, "telco_from": null, "telco_to": null, "units": 10, "usage_record_no": 110928, "usage_record_parent": null, "usage_tstamp": "2025-08-27T00:00:00+02:00", "usage_type": { "ids": { "usage_type_cd": "R51_SF_UT_1689922875", "usage_type_no": 10024522 }, "type": "Usage_Type" } }
(EXTRACT-9001) Plan Logical Object Model (LOM) modified with new fields
Two new fields have been added into the <service_details> array within the plan LOM.
- usage_rating_time_indicator
- usage_record_rating_level_indicator
"service_details": [ { "avalanche_earn_on_cancel": false, "billable_unit_usage_threshold": null, "has_single_line_proration": false, "has_usage_tier_multiplier": false, "is_fulfillment_based": false, "is_high_water": false, "is_tax_inclusive": false, "pool_child_billable_unit_thresholds": false, "service": { "ids": { "client_service_id": "UT_R58_1", "service_no": 11086924 }, "type": "Service" }, "tiered_pricing_rule": { "ids": { "rule_no": 1 }, "type": "Tiered_Pricing_Rule" }, "usage_rating_time_indicator": 1, "usage_record_rating_level_indicator": 0, "usage_thresholds": [] } ]
(EXTRACT-9356) Update made to VM_LOOKUPS
Previously missing lookup sets have been added. Values in thesharez.vm_
lookups
table have been corrected accordingly. Additionally, a separate table has been created, sharez.vm_lookup_references
, to display where the lookup set is used by LOMs, Tables, or Columns. There are also two new views:
-
sharez.vm_country_lookups
: This view shows all the various ISO associations for countries. -
sharez.vm_currency_lookups
: This view shows all the various ISO associations for currencies.
Snowflake
No updates were made for R59.
Universal Connector
No updates were made for R59.