steampipe plugin install theapsgroup/freshservicesteampipe plugin install theapsgroup/freshservice

Table: freshservice_purchase_order

Obtain information on Purchase Orders raised in the FreshService instance.

Examples

select
  *
from
  freshservice_purchase_order;

select
  *
from
  freshservice_purchase_order
where
  vendor_id = 20591913;

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
billing_address	text		Address to which the order should be billed.
billing_same_as_shipping	boolean		Set to true if billing address is same as shipping address.
conversion_rate	double precision		Conversion rate to convert selected currency unit to helpdesk currency.
created_at	timestamp with time zone		Timestamp when the purchase order was created.
created_by	bigint		User ID of the agent who created the purchase order.
currency_code	text		Currency unit used in the transaction.
department_id	bigint		ID of the department.
discount_percentage	double precision		Percentage of discount on the order.
expected_delivery_date	timestamp with time zone		Timestamp when delivery is expected for the purchase order.
id	bigint	=	ID of the purchase order.
name	text		Title of the purchase order.
po_number	text		Unique purchase order number.
purchase_items	jsonb		Items to be ordered.
shipping_address	text		Address to which the order should be shipped.
shopping_cost	double precision		Total cost of shipping the order.
status	bigint		Status of the purchase order.
tax_percentage	double precision		Percentage of tax on the order.
updated_at	timestamp with time zone		Timestamp when the purchase order was last updated.
vendor_details	text		Details of the vendor with whom the order is placed.
vendor_id	bigint		ID of the vendor associated with the purchase order.