Data Feed 59 Release

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_lookupstable 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:

1. sharez.vm_country_lookups: This view shows all the various ISO associations for countries.

2. 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.