Extract day rate information from backup for use in Excel

Follow

Norm Schaeffer

• June 30, 2023 19:06

We have discovered that many pieces of new equipment where no day rate was entered when we added that equipment to inventory. I'd like to download a backup, import it into HeidiSQL and write a query to find equipment with a price of $0.00. I'd like to know what tables I need to join to extract that information. I'm guessing things like st_biz_managed_resources, st_biz_pricing_model, st_ivt_inventory_item. I've looked at these but cannot find a cost or day rate field. I have found purchase_cost, replacement_cost but that's not what I need. I'd like the cost found in the pricing tab on the item detail page.

0

• 

  Randy - Flex Staff

  • July 05, 2023 11:23

  Hi Norm,

  That data is in `st_biz_pricing_rule`. If you query against that table directly, you will need to supply it a `model_id` (pricing model), `resource_id` (some resource, be it an inventory item, serial unit, etc.), and a `currency_id`. 

  0

  Comment actions Permalink
• 

  Norm Schaeffer

  • July 05, 2023 14:58

  Hi Randy:

  Thanks for the information. I appreciate your response.

  Norm

  0

  Comment actions Permalink

Please sign in to leave a comment.