freshservice_agentfreshservice_agent_rolefreshservice_announcementfreshservice_assetfreshservice_asset_componentfreshservice_asset_contractfreshservice_asset_typefreshservice_business_hourfreshservice_changefreshservice_change_notefreshservice_contractfreshservice_contract_typefreshservice_departmentfreshservice_locationfreshservice_problemfreshservice_problem_notefreshservice_problem_taskfreshservice_problem_timeentryfreshservice_productfreshservice_purchase_orderfreshservice_releasefreshservice_release_notefreshservice_release_taskfreshservice_release_timeentryfreshservice_requesterfreshservice_servicefreshservice_sla_policyfreshservice_softwarefreshservice_software_installationfreshservice_software_userfreshservice_solution_articlefreshservice_solution_categoryfreshservice_solution_folderfreshservice_ticketfreshservice_ticket_conversationfreshservice_ticket_taskfreshservice_ticket_timeentryfreshservice_vendor
Table: freshservice_purchase_order
Obtain information on Purchase Orders raised in the FreshService instance.
Examples
List all purchase orders
select *from freshservice_purchase_order;
List purchase orders from a specific vendor
select *from freshservice_purchase_orderwhere vendor_id = 20591913;
Schema for freshservice_purchase_order
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. |