fct_purchase_order_items

The unique ID of the purchase order item. E.g. 8571.

The ID of the associated purchase order. E.g. 918.

The multiplier for the price when calculating the cost of the purchase order. E.g. 1.0.

The price, in cents, of one unit of the purchase order. E.g. 5600.

The currency the price is in. E.g. AUD.

The gross amount, in cents, that the purchase order costs. price_cents * quantity. E.g. 8200.

The currency the gross amount is in. E.g. AUD.

The tax amount, in cents, that the purchase order includes. E.g. 1500.

The currency the tax amount is in. E.g. AUD.

The date and time the purchase order item was created (in UTC). E.g. 2021-03-02 12:00:00.

The date and time the purchase order item was updated (in UTC). E.g. 2021-03-02 12:00:00.

The invoice ID generated by the supplier. E.g. 16590.

The date the product or service is expected to be delivered to the client. E.g. 2025-01-01.

The date the product or service was actually delivered to the client. E.g. 2025-01-01.

A True or False value, which says if the date of delivery of this PO line is after the 1st of July. E.g. True. Below is the logic to see whether delivery is happening after 1st July 2025 when source.actual_delivery_date >= “2025-07-01” then True when source.actual_delivery_date < “2025-07-01” then False when source.estimated_delivery_date >= “2025-07-01” then True when beginning_at >= “2025-07-01” then True when isnull(source.estimated_delivery_date) then True otherwise False

The start time of the purchase order. E.g. 15:00.

The end time of the purchase order. E.g. 16:00.

If the service lasted the whole day. True or False. E.g. True.

The date and time of the start of the service. E.g. 2024-11-29 04:00.

The date and time of the end of the service. E.g. 2024-11-29 04:00.

The ID of the membership associated with the purchase order item. E.g. 1989.

Whether the membership associated with the purchase order is a current one. True or False. E.g. True.

Whether the membership associated with the purchase order is a current one, and has a HCP funding scheme. E.g. True.

Whether the ticket associated with the purchase order is open. E.g. True

Amount in cents that a client pays towards the corresponding purchase order line amount. E.g. 500.

The currency code for client contribution amount. E.g. AUD.

There are different product_ids that this can refer to. They can be support at home codes, or product_ids if the membership funding scheme type is hcp. E.g. SERV-0001.

The date and time created in the company timezone. E.g.: 2021-03-02 00:12:59.

The date and time updated in the company timezone. E.g.: 2021-03-02 00:12:59.

The date and time the service begins in the company timezone. E.g.: 2021-03-02 00:12:59.

The date and time the services ends in the company timezone. E.g.: 2021-03-02 00:12:59.

The company ID. E.g.: 345.