Power BI Connector for ServiceNow

Build 25.0.9454

ast_contract

Stores contract records for managed assets, including start dates, vendors, and terms of agreement.

Columns

Name Type ReadOnly References Description
vendor String False

Lists the vendor associated with the contract, identifying the external supplier or service provider.

renewable String False

Indicates whether the contract can be renewed after its expiration date.

tax_rate String False

Specifies the tax rate applied to the contract's financial calculations.

contract_model String False

Defines the contract model that determines structure and compliance rules for the agreement.

state String False

Lists the current state of the contract, such as draft, active, or expired.

sys_class_name String False

Identifies the system class name assigned to the contract record in ServiceNow.

ends Datetime False

Specifies the date and time when the contract ends or reaches its expiration point.

total_cost String False

Displays the total cost of the contract, including all associated expenses and taxes.

contract_administrator String False

Specifies the person responsible for managing and overseeing the contract.

cost_center String False

Defines the financial cost center to which the contract's expenses are allocated.

expiration String False

Lists the expiration status or date for the contract's validity period.

description String False

Provides a detailed explanation or notes about the contract's terms, coverage, or scope.

cost_adjustment_type String False

Specifies the type of cost adjustment applied to the contract, such as discount or surcharge.

payment_schedule String False

Defines the schedule outlining when payments for the contract are due.

renewal_options String False

Lists available options for renewing the contract, such as automatic or manual renewal.

license_type String False

Specifies the type of license covered under the contract, such as per-user or site-based.

vendor_account String False

Lists the vendor's account identifier associated with the contract record.

cost_adjustment_percentage String False

Displays the percentage value used for adjusting the contract's cost.

payment_amount String False

Specifies the amount due for each payment according to the contract terms.

renewal_end_date Datetime False

Indicates the date when the contract's renewal term concludes.

process String False

Lists the process or workflow associated with the contract's lifecycle.

ratecard String False

References the rate card that defines standard pricing used in the contract's calculation.

cost_per_unit String False

Specifies the cost of a single unit under the contract, such as per device or per user.

monthly_cost String False

Displays the recurring monthly cost associated with maintaining the contract.

sys_mod_count String False

Tracks the number of times the contract record has been modified since creation.

commitment String False

Lists the level of financial or service commitment defined in the contract.

sys_created_by String False

Shows the user or process that originally created the contract record.

approval_history String False

Provides a record of all approval actions taken during the contract's lifecycle.

sys_updated_by String False

Shows the user or system process that last updated the contract record.

number String False

Displays the unique contract number assigned for identification and tracking.

active String False

Indicates whether the contract is currently active and enforceable.

sales_tax String False

Specifies the sales tax amount or percentage applied to the contract total.

renewal_contact String False

Lists the contact person responsible for handling contract renewals.

license_quantity_entitled String False

Specifies the number of licenses entitled under the terms of the contract.

starts Datetime False

Specifies the date and time when the contract term begins.

sub_total_cost String False

Displays the subtotal cost before applying taxes or additional adjustments.

location String False

Lists the location or business unit associated with the contract.

po_number String False

Specifies the purchase order (PO) number linked to the contract transaction.

sys_domain String False

Identifies the domain associated with the contract record for multi-domain configurations.

short_description String False

Provides a concise summary describing the purpose or content of the contract.

cost_adjustment_reason String False

Lists the reason or justification for a cost adjustment applied to the contract.

tax_cost String False

Displays the total tax amount calculated for the contract.

invoice_payment_terms String False

Specifies the payment terms defined in the contract's invoicing policy.

terms_and_conditions String False

Stores the detailed terms and conditions governing the contract agreement.

vendor_contract String False

References the vendor's original contract or external contract identifier.

cost_adjustment String False

Displays the calculated amount by which the contract cost has been adjusted.

tax_exempt String False

Indicates whether the contract is exempt from taxes.

renewal_date Datetime False

Specifies the date when the contract renewal becomes effective.

substate String False

Lists the substate providing additional detail on the contract's progress or condition.

approver String False

Lists the user responsible for approving the contract during the workflow process.

lifetime_cost String False

Displays the total cost incurred over the entire lifetime of the contract.

yearly_cost String False

Shows the annual cost of maintaining the contract, calculated based on total value and duration.

sys_created_on Datetime False

Displays the date and time when the contract record was first created in ServiceNow.

discount String False

Specifies the discount applied to the contract value, expressed as an amount or percentage.

sys_updated_on Datetime False

Displays the date and time when the contract record was last updated.

application_model String False

Lists the application model associated with the contract, linking it to software or service assets.

sys_id [KEY] String False

Defines the system identifier (sys_id) that uniquely identifies the contract record in ServiceNow.

sys_domain_path String False

Specifies the hierarchical domain path representing where the contract record resides.

ItemURL String True

Provides the URL that links directly to the contract record in the ServiceNow user interface (UI).

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454