Transactions

1min

x_fct_trans_transactions
Name
Description
Applied Gift Card Amount
Dollar value of the gift card at time of issuance.
Applied Gift Card Amount Used
Amount used from the initial gift card amount.
Applied Gift Card Currency
Currency of the gift card amount.
Applied Gift Card Gift Message
Gift card's custom message from the purchaser to the recipient.
Applied Gift Card Id
Unique key generated by Chord that uniquifies a gift card.
Applied Gift Card Is Redeemable
Flag that determines whether or not the gift card is redeemable.
Applied Gift Card Purchaser Name
Gift card's purchaser name as inputed by the gift card's purchaser.
Applied Gift Card Recipient Email
Gift card's recipient email.
Applied Gift Card Recipient Name
Gift card's recipient name as inputed by the gift card's purchaser.
Applied Gift Card Redemption Code
Gift card's redemption code.
Order Adjustment Types
List of distinct adjustment reasons for adjustments made to the order.
Order Admin Url
The Admin URL of pointing to the order.
Order Applied Discount Codes
List of promotion codes applied to the order.
Order Applied Discount Codes Count
Count of promotion codes applied to the order.
Order Applied Discount Ids
List of promotion ids applied to the order.
Order Applied Discount Names
List of promotion names applied to the order.
Order Applied Discount Names Count
Count of promotion names applied to the order.
Order Cart Url
Url of the cart which contains the order.
Order Channel
The channel from which the order is created.
Order Completed Order Rank By Subscription
Allows to rank completed orders by completion date for a subscription.
Order Completed Order Rank By User
Allows to rank completed orders by completion date for a user.
Order Contains Refund
Whether or not the order contains refund adjustments or refunds that are processed outside of the Chord OMS adjustment systems (for example via RMAs or cancellations).
Order Contains Replacement
Whether or not the order contains replacement adjustments or shipped replacement items (following an RMA authorization).
Order Contains Return
Whether or not the order contains returns (authorized RMAs).
Order Contains Rma Refund
Whether or not the order contains RMA refunds (refunds issued after an RMA was requested and authorized).
Order Contains Rma Store Credits
This column is not documented.
Order Currency
The currency for this order.
Order Customer Lifetime Month
Number of months between the current order's completion date and the user's first order completion date. First orders have a value of 1.
Order Customer Lifetime Week
Number of weeks between the current order's completion date and the user's first order completion date. First orders always have a value of 1.
Order Email
The email address of the customer that made the order.
Order Financial State
The current payment state of the order.
Order Fulfillment Ids
Array of unique keys generated by Chord to identify the unique shipments for an order.
Order Fulfillment Numbers
The unique identifier for this shipment.
Order Fulfillment State
The current shipment state of the order.
Order Has Discount
Whether or not the order has promotions applied to it.
Order Has Order Tags
Whether or not that order has tags.
Order Hours From Order To First Fulfillment
Number of hours between order completion and first order shipment; how long it takes a company to get the initial product out to a customer.
Order Hours From Order To Last Fulfillment
Number of hours between order completion and last order shipment.
Order Id
Unique key generated by Chord to identify a unique order.
Order Is Canceled
Whether or not the order is canceled. The order is considered canceled when the canceled_at date is not null.
Order Is Completed
Whether or not that order is completed. The order is considered completed when the completed_at date is not null. This means that the order does not necessarily have a state = 'complete', since states can change after the order completion (for example in the case of a refund).
Order Is First Completed Order
Whether or not that order was the first completed order for a user.
Order Is First Order
Whether or not that order was the first order for a user.
Order Is First Subscription Completed Order
Whether or not that order was the first completed order for a subscription.
Order Is First Subscription Order
Whether or not that order was the first order for a subscription.
Order Is Fulfilled
Whether or not that order has shipped.
Order Is Part Of Subscription
Whether or not that order is part of a subscription.
Order Is Pre Paid Purchase
Whether the order the orderincludes the purchase of a pre-payment; this could be a gift subscription, pre-pay subscription, or gift card.
Order Is Pre Paid Redemption
Whether the order included the redemption of a pre-payment; this could be the redemption of a gift subscription, pre-pay subscription, or gift card.
Order Is Referred By Affiliate
Whether or not the user is referred by an affiliate.
Order Is Referred By Referrer
Whether or not the user is referred by a referrer.
Order Is Replacement
True when the order is a replacement order.
Order Is Suspicious Referral Conversion
Wether this represents a suspicous referral conversions or not.
Order Number
Human-readable unique key generated by Solidus that identifies an order. It begins with a set of Tenant-Store defined letters and ends in a nine-digit number (for example, CHORD-123456789). This number is shown to the users in various places. These combinations are unique for a given Store.
Order Oms Order Id
Unique key generated by Solidus that identifies an order.
Order Rank By User
Allows to rank completed orders by completion date for a user.
Order Tags
List of tags associated to the order.
Order Tags Count
Number of tags associated to the order.
Order Referral Conversion Suspicious Reasons
A list of reasons explaining why the referral conversion is suspicious.
Order Referrer User Email
The email address of the customer identified with the referral.
Order Special Instructions
Any special shipping instructions that have been specified by the customer during checkout.
Order State
The current state of the order.
Order Subscription Customer Lifetime Month
Number of months between the current order's completion date and the user's first subscription order completion date. First orders have a value of 1.
Order Subscription Customer Lifetime Week
Number of weeks between the current order's completion date and the user's first subscription order completion date. First orders always have a value of 1.
Order User Referral Code
Unique key generated by Solidus that represents the user's referral code.
Order Website Locale
Locale of website. This will either be collected from the url or from the drop-down link on the store.
Purchased Gift Card Amount
Dollar value of the gift card at time of issuance.
Purchased Gift Card Amount Used
Amount used from the initial gift card amount.
Purchased Gift Card Currency
Currency of the gift card amount.
Purchased Gift Card Gift Message
Gift card's custom message from the purchaser to the recipient.
Purchased Gift Card Id
Unique key generated by Chord that uniquifies a gift card.
Purchased Gift Card Is Redeemable
Flag that determines whether or not the gift card is redeemable.
Purchased Gift Card Purchaser Name
Gift card's purchaser name as inputed by the gift card's purchaser.
Purchased Gift Card Recipient Email
Gift card's recipient email.
Purchased Gift Card Recipient Name
Gift card's recipient name as inputed by the gift card's purchaser.
Purchased Gift Card Redemption Code
Gift card's redemption code.
Store Id
Unique key generated by our models that uniquifies a store.
Store Name
The name of the store.
Store Oms Admin Url
The Admin URL of that OMS.
Store Oms Id
Unique key generated by Chord that uniquifies an OMS.
Store Oms Store Id
Unique key generated by our models that uniquifies a store.
Store Oms Type
The type of the OMS.
Store Id
Unique key generated by our models that uniquifies a store.
Store Tenant Id
Unique key generated by Chord that uniquifies a tenant.
Store Url
The Storefront URL of of the store.
Transaction Id
Unique key generated by Chord that uniquifies a transaction.
Transaction Payment Method
Represents the transaction's payment method. May include values such as 'Stripe', 'Venmo', etc.
Transaction Payment Type
Represents the transaction's payment type. May include values such as 'Money', 'Store Credit', 'Referral credit applied', etc.
Transaction Reason
Represents the transaction reason. May include values such as 'Return processing', 'Order canceled', 'Order', 'Order Not Received', etc.
Transaction Type
Represents the transaction type. Its value is either 'Payment' or 'Refund'.
User Completed Oms Order Ids
List of completed OMS order ids by a user.
User Completed Order Ids
List of completed order ids by a user.
User Credit Category Basket
Array of credit categories (Gift Card, Reimbursement, Referral Credits, Prepaid Subscription, GMA) issued per user.
User Email
Email address of the user.
User First Completed Oms Order Id
OMS order id of the first order completed by a user.
User First Completed Order Id
Unique order id of the first order completed by a user.
User First Order Unique Ordered Products
Unique products ordered by the user in their first completed order.
User First Order Unique Ordered Skus
Unique SKUs ordered by the user in their first completed order.
User Has Ordered A La Carte
Whether or not the user has had at least one order that is not part of a subscription.
User Has Promo Applied In First Order
Whether or not the user has a promo applied to their first completed order.
User Has Subscription In First Order
Whether or not the user's first order is linked to a subscription.
User Id
Unique key generated by Chord to identify a unique user.
User Is Active Subscriber
Whether or not the user has an active subscription with at least one completed subscription order. An active subscription is one that is not cancelled or paused.
User Is Customer
Whether or not the user is a customer.
User Is New Customer
Whether or not the user is a new customer.
User Is Not Customer
Whether or not the user is not a customer.
User Is Returning Customer
Whether or not the user is a returning customer.
User Is Subscriber
Whether or not the user has completed at least one subscription order.
User Login
The login email address of the user.
User Name
Full name of the user.
User Number Of Completed A La Carte Orders
Total amount of orders completed by a user that are a la carte.
User Number Of Completed Subscription Orders
Total amount of orders completed by a user that was part of a subscription.
User Number Of Orders With Promos
The count of completed orders with a promo applied.
User Number Of Subscriptions
Total amount of subscriptions linked to a user.
User Oms User Id
Unique key generated by Solidus that identifies a user.
User Phone
Phone number of the user.
User Total Completed Order Count
Total amount of orders completed by a user.
User Unique Ordered Products
Unique products ordered by the user across all orders.
User Unique Ordered Skus
Unique SKUs ordered by the user across all orders.
Applied Gift Card Applied At (Universal)
Timestamp that represents the time at which gift card was last applied as a payment method on an order - Universal Time Zone.
Applied Gift Card Created At (Universal)
Timestamp that represents the time at which gift card was created - Universal Time Zone.
Applied Gift Card Deactivated At (Universal)
Timestamp that represents the time at which gift card was deactivated - Universal Time Zone.
Applied Gift Card Sent At (Universal)
Timestamp that represents the time at which gift card was sent to its recipient - Universal Time Zone.
Applied Gift Card Updated At (Universal)
Timestamp that represents the time at which gift card was last updated - Universal Time Zone.
Order Approved At (Universal)
Reflects when the entity was approved in Solidus - Universal Time Zone.
Order Canceled At (Universal)
Reflects when the order was cancelled - Universal Time Zone.
Order Completed At (Central)
Reflects when the entity was moved to the 'completed' state - Cental Time Zone.
Order Completed At (Eastern)
Reflects when the entity was moved to the 'completed' state - Eastern Time Zone.
Order Completed At (Mountain)
Reflects when the entity was moved to the 'completed' state - Mountain Time Zone.
Order Completed At (Pacific)
Reflects when the entity was moved to the 'completed' state - Pacific Time Zone.
Order Completed At (Universal)
Reflects when the entity was moved to the 'completed' state - Universal Time Zone.
Order Created At (Central)
Reflects when the entity was first created in Solidus - Cental Time Zone.
Order Created At (Eastern)
Reflects when the entity was first created in Solidus - Eastern Time Zone.
Order Created At (Mountain)
Reflects when the entity was first created in Solidus - Mountain Time Zone.
Order Created At (Pacific)
Reflects when the entity was first created in Solidus - Pacific Time Zone.
Order Created At (Universal)
Reflects when the entity was first created in Solidus - Universal Time Zone.
Order First Fulfillment Fulfilled At (Universal)
Timestamp at which the first shipment for that order was shipped - Universal Time Zone.
Order Last Adjustment Refund At (Universal)
Timestamp of the last return adjustment for an order - Universal Time Zone.
Order Last Adjustment Replacement At (Universal)
Timestamp of the last replacement adjustment for an order - Universal Time Zone.
Order Last Fulfillment Fulfilled At (Universal)
Timestamp at which the last shipment for that order was shipped - Universal Time Zone.
Order Updated At (Universal)
Reflects when the entity was last updated in Solidus - Universal Time Zone.
Purchased Gift Card Applied At (Universal)
Timestamp that represents the time at which gift card was last applied as a payment method on an order - Universal Time Zone.
Purchased Gift Card Created At (Universal)
Timestamp that represents the time at which gift card was created - Universal Time Zone.
Purchased Gift Card Deactivated At (Universal)
Timestamp that represents the time at which gift card was deactivated - Universal Time Zone.
Purchased Gift Card Sent At (Universal)
Timestamp that represents the time at which gift card was sent to its recipient - Universal Time Zone.
Purchased Gift Card Updated At (Universal)
Timestamp that represents the time at which gift card was last updated - Universal Time Zone.
Transaction Ts (Central)
Timestamp that represents the time at which the transaction was last updated - Cental Time Zone.
Transaction Ts (Eastern)
Timestamp that represents the time at which the transaction was last updated - Eastern Time Zone.
Transaction Ts (Mountain)
Timestamp that represents the time at which the transaction was last updated - Mountain Time Zone.
Transaction Ts (Pacific)
Timestamp that represents the time at which the transaction was last updated - Pacific Time Zone.
Transaction Ts (Universal)
Timestamp that represents the time at which the transaction was last updated - Universal Time Zone.
User Created At (Universal)
Timestamp at which the users row was created - Universal Time Zone.
User Date Of Birth (Universal)
Date of birth of the user - Universal Time Zone.
User Deleted At (Universal)
Timestamp at which the user's account was deleted - Universal Time Zone.
User First Order Completed At (Universal)
The timestamp of the user's first completed order - Universal Time Zone.
User First Subscription Order Completed At (Universal)
The timestamp of the user's first completed subscription order, regardless of subsequent subscriptions - Universal Time Zone.
User Last Order Completed At (Universal)
The timestamp of the user's last completed order - Universal Time Zone.
User Last Sign In At (Universal)
The last sign in timestamp for the user - Universal Time Zone.
User Updated At (Universal)
Timestamp at which the users row was last updated - Universal Time Zone.
Average Net Revenue
This column is not documented.
Average Transaction Amount
Full amount of transaction. The value will be positive if the transaction is a payment, and negative if the transaction is a refund.
Net Revenue
This column is not documented.
Transaction Amount
Full amount of transaction. The value will be positive if the transaction is a payment, and negative if the transaction is a refund.
﻿

Name	Description
Applied Gift Card Amount	Dollar value of the gift card at time of issuance.
Applied Gift Card Amount Used	Amount used from the initial gift card amount.
Applied Gift Card Currency	Currency of the gift card amount.
Applied Gift Card Gift Message	Gift card's custom message from the purchaser to the recipient.
Applied Gift Card Id	Unique key generated by Chord that uniquifies a gift card.
Applied Gift Card Is Redeemable	Flag that determines whether or not the gift card is redeemable.
Applied Gift Card Purchaser Name	Gift card's purchaser name as inputed by the gift card's purchaser.
Applied Gift Card Recipient Email	Gift card's recipient email.
Applied Gift Card Recipient Name	Gift card's recipient name as inputed by the gift card's purchaser.
Applied Gift Card Redemption Code	Gift card's redemption code.
Order Adjustment Types	List of distinct adjustment reasons for adjustments made to the order.
Order Admin Url	The Admin URL of pointing to the order.
Order Applied Discount Codes	List of promotion codes applied to the order.
Order Applied Discount Codes Count	Count of promotion codes applied to the order.
Order Applied Discount Ids	List of promotion ids applied to the order.
Order Applied Discount Names	List of promotion names applied to the order.
Order Applied Discount Names Count	Count of promotion names applied to the order.
Order Cart Url	Url of the cart which contains the order.
Order Channel	The channel from which the order is created.
Order Completed Order Rank By Subscription	Allows to rank completed orders by completion date for a subscription.
Order Completed Order Rank By User	Allows to rank completed orders by completion date for a user.
Order Contains Refund	Whether or not the order contains refund adjustments or refunds that are processed outside of the Chord OMS adjustment systems (for example via RMAs or cancellations).
Order Contains Replacement	Whether or not the order contains replacement adjustments or shipped replacement items (following an RMA authorization).
Order Contains Return	Whether or not the order contains returns (authorized RMAs).
Order Contains Rma Refund	Whether or not the order contains RMA refunds (refunds issued after an RMA was requested and authorized).
Order Contains Rma Store Credits	This column is not documented.
Order Currency	The currency for this order.
Order Customer Lifetime Month	Number of months between the current order's completion date and the user's first order completion date. First orders have a value of 1.
Order Customer Lifetime Week	Number of weeks between the current order's completion date and the user's first order completion date. First orders always have a value of 1.
Order Email	The email address of the customer that made the order.
Order Financial State	The current payment state of the order.
Order Fulfillment Ids	Array of unique keys generated by Chord to identify the unique shipments for an order.
Order Fulfillment Numbers	The unique identifier for this shipment.
Order Fulfillment State	The current shipment state of the order.
Order Has Discount	Whether or not the order has promotions applied to it.
Order Has Order Tags	Whether or not that order has tags.
Order Hours From Order To First Fulfillment	Number of hours between order completion and first order shipment; how long it takes a company to get the initial product out to a customer.
Order Hours From Order To Last Fulfillment	Number of hours between order completion and last order shipment.
Order Id	Unique key generated by Chord to identify a unique order.
Order Is Canceled	Whether or not the order is canceled. The order is considered canceled when the canceled_at date is not null.
Order Is Completed	Whether or not that order is completed. The order is considered completed when the completed_at date is not null. This means that the order does not necessarily have a state = 'complete', since states can change after the order completion (for example in the case of a refund).
Order Is First Completed Order	Whether or not that order was the first completed order for a user.
Order Is First Order	Whether or not that order was the first order for a user.
Order Is First Subscription Completed Order	Whether or not that order was the first completed order for a subscription.
Order Is First Subscription Order	Whether or not that order was the first order for a subscription.
Order Is Fulfilled	Whether or not that order has shipped.
Order Is Part Of Subscription	Whether or not that order is part of a subscription.
Order Is Pre Paid Purchase	Whether the order the orderincludes the purchase of a pre-payment; this could be a gift subscription, pre-pay subscription, or gift card.
Order Is Pre Paid Redemption	Whether the order included the redemption of a pre-payment; this could be the redemption of a gift subscription, pre-pay subscription, or gift card.
Order Is Referred By Affiliate	Whether or not the user is referred by an affiliate.
Order Is Referred By Referrer	Whether or not the user is referred by a referrer.
Order Is Replacement	True when the order is a replacement order.
Order Is Suspicious Referral Conversion	Wether this represents a suspicous referral conversions or not.
Order Number	Human-readable unique key generated by Solidus that identifies an order. It begins with a set of Tenant-Store defined letters and ends in a nine-digit number (for example, CHORD-123456789). This number is shown to the users in various places. These combinations are unique for a given Store.
Order Oms Order Id	Unique key generated by Solidus that identifies an order.
Order Rank By User	Allows to rank completed orders by completion date for a user.
Order Tags	List of tags associated to the order.
Order Tags Count	Number of tags associated to the order.
Order Referral Conversion Suspicious Reasons	A list of reasons explaining why the referral conversion is suspicious.
Order Referrer User Email	The email address of the customer identified with the referral.
Order Special Instructions	Any special shipping instructions that have been specified by the customer during checkout.
Order State	The current state of the order.
Order Subscription Customer Lifetime Month	Number of months between the current order's completion date and the user's first subscription order completion date. First orders have a value of 1.
Order Subscription Customer Lifetime Week	Number of weeks between the current order's completion date and the user's first subscription order completion date. First orders always have a value of 1.
Order User Referral Code	Unique key generated by Solidus that represents the user's referral code.
Order Website Locale	Locale of website. This will either be collected from the url or from the drop-down link on the store.
Purchased Gift Card Amount	Dollar value of the gift card at time of issuance.
Purchased Gift Card Amount Used	Amount used from the initial gift card amount.
Purchased Gift Card Currency	Currency of the gift card amount.
Purchased Gift Card Gift Message	Gift card's custom message from the purchaser to the recipient.
Purchased Gift Card Id	Unique key generated by Chord that uniquifies a gift card.
Purchased Gift Card Is Redeemable	Flag that determines whether or not the gift card is redeemable.
Purchased Gift Card Purchaser Name	Gift card's purchaser name as inputed by the gift card's purchaser.
Purchased Gift Card Recipient Email	Gift card's recipient email.
Purchased Gift Card Recipient Name	Gift card's recipient name as inputed by the gift card's purchaser.
Purchased Gift Card Redemption Code	Gift card's redemption code.
Store Id	Unique key generated by our models that uniquifies a store.
Store Name	The name of the store.
Store Oms Admin Url	The Admin URL of that OMS.
Store Oms Id	Unique key generated by Chord that uniquifies an OMS.
Store Oms Store Id	Unique key generated by our models that uniquifies a store.
Store Oms Type	The type of the OMS.
Store Id	Unique key generated by our models that uniquifies a store.
Store Tenant Id	Unique key generated by Chord that uniquifies a tenant.
Store Url	The Storefront URL of of the store.
Transaction Id	Unique key generated by Chord that uniquifies a transaction.
Transaction Payment Method	Represents the transaction's payment method. May include values such as 'Stripe', 'Venmo', etc.
Transaction Payment Type	Represents the transaction's payment type. May include values such as 'Money', 'Store Credit', 'Referral credit applied', etc.
Transaction Reason	Represents the transaction reason. May include values such as 'Return processing', 'Order canceled', 'Order', 'Order Not Received', etc.
Transaction Type	Represents the transaction type. Its value is either 'Payment' or 'Refund'.
User Completed Oms Order Ids	List of completed OMS order ids by a user.
User Completed Order Ids	List of completed order ids by a user.
User Credit Category Basket	Array of credit categories (Gift Card, Reimbursement, Referral Credits, Prepaid Subscription, GMA) issued per user.
User Email	Email address of the user.
User First Completed Oms Order Id	OMS order id of the first order completed by a user.
User First Completed Order Id	Unique order id of the first order completed by a user.
User First Order Unique Ordered Products	Unique products ordered by the user in their first completed order.
User First Order Unique Ordered Skus	Unique SKUs ordered by the user in their first completed order.
User Has Ordered A La Carte	Whether or not the user has had at least one order that is not part of a subscription.
User Has Promo Applied In First Order	Whether or not the user has a promo applied to their first completed order.
User Has Subscription In First Order	Whether or not the user's first order is linked to a subscription.
User Id	Unique key generated by Chord to identify a unique user.
User Is Active Subscriber	Whether or not the user has an active subscription with at least one completed subscription order. An active subscription is one that is not cancelled or paused.
User Is Customer	Whether or not the user is a customer.
User Is New Customer	Whether or not the user is a new customer.
User Is Not Customer	Whether or not the user is not a customer.
User Is Returning Customer	Whether or not the user is a returning customer.
User Is Subscriber	Whether or not the user has completed at least one subscription order.
User Login	The login email address of the user.
User Name	Full name of the user.
User Number Of Completed A La Carte Orders	Total amount of orders completed by a user that are a la carte.
User Number Of Completed Subscription Orders	Total amount of orders completed by a user that was part of a subscription.
User Number Of Orders With Promos	The count of completed orders with a promo applied.
User Number Of Subscriptions	Total amount of subscriptions linked to a user.
User Oms User Id	Unique key generated by Solidus that identifies a user.
User Phone	Phone number of the user.
User Total Completed Order Count	Total amount of orders completed by a user.
User Unique Ordered Products	Unique products ordered by the user across all orders.
User Unique Ordered Skus	Unique SKUs ordered by the user across all orders.
Applied Gift Card Applied At (Universal)	Timestamp that represents the time at which gift card was last applied as a payment method on an order - Universal Time Zone.
Applied Gift Card Created At (Universal)	Timestamp that represents the time at which gift card was created - Universal Time Zone.
Applied Gift Card Deactivated At (Universal)	Timestamp that represents the time at which gift card was deactivated - Universal Time Zone.
Applied Gift Card Sent At (Universal)	Timestamp that represents the time at which gift card was sent to its recipient - Universal Time Zone.
Applied Gift Card Updated At (Universal)	Timestamp that represents the time at which gift card was last updated - Universal Time Zone.
Order Approved At (Universal)	Reflects when the entity was approved in Solidus - Universal Time Zone.
Order Canceled At (Universal)	Reflects when the order was cancelled - Universal Time Zone.
Order Completed At (Central)	Reflects when the entity was moved to the 'completed' state - Cental Time Zone.
Order Completed At (Eastern)	Reflects when the entity was moved to the 'completed' state - Eastern Time Zone.
Order Completed At (Mountain)	Reflects when the entity was moved to the 'completed' state - Mountain Time Zone.
Order Completed At (Pacific)	Reflects when the entity was moved to the 'completed' state - Pacific Time Zone.
Order Completed At (Universal)	Reflects when the entity was moved to the 'completed' state - Universal Time Zone.
Order Created At (Central)	Reflects when the entity was first created in Solidus - Cental Time Zone.
Order Created At (Eastern)	Reflects when the entity was first created in Solidus - Eastern Time Zone.
Order Created At (Mountain)	Reflects when the entity was first created in Solidus - Mountain Time Zone.
Order Created At (Pacific)	Reflects when the entity was first created in Solidus - Pacific Time Zone.
Order Created At (Universal)	Reflects when the entity was first created in Solidus - Universal Time Zone.
Order First Fulfillment Fulfilled At (Universal)	Timestamp at which the first shipment for that order was shipped - Universal Time Zone.
Order Last Adjustment Refund At (Universal)	Timestamp of the last return adjustment for an order - Universal Time Zone.
Order Last Adjustment Replacement At (Universal)	Timestamp of the last replacement adjustment for an order - Universal Time Zone.
Order Last Fulfillment Fulfilled At (Universal)	Timestamp at which the last shipment for that order was shipped - Universal Time Zone.
Order Updated At (Universal)	Reflects when the entity was last updated in Solidus - Universal Time Zone.
Purchased Gift Card Applied At (Universal)	Timestamp that represents the time at which gift card was last applied as a payment method on an order - Universal Time Zone.
Purchased Gift Card Created At (Universal)	Timestamp that represents the time at which gift card was created - Universal Time Zone.
Purchased Gift Card Deactivated At (Universal)	Timestamp that represents the time at which gift card was deactivated - Universal Time Zone.
Purchased Gift Card Sent At (Universal)	Timestamp that represents the time at which gift card was sent to its recipient - Universal Time Zone.
Purchased Gift Card Updated At (Universal)	Timestamp that represents the time at which gift card was last updated - Universal Time Zone.
Transaction Ts (Central)	Timestamp that represents the time at which the transaction was last updated - Cental Time Zone.
Transaction Ts (Eastern)	Timestamp that represents the time at which the transaction was last updated - Eastern Time Zone.
Transaction Ts (Mountain)	Timestamp that represents the time at which the transaction was last updated - Mountain Time Zone.
Transaction Ts (Pacific)	Timestamp that represents the time at which the transaction was last updated - Pacific Time Zone.
Transaction Ts (Universal)	Timestamp that represents the time at which the transaction was last updated - Universal Time Zone.
User Created At (Universal)	Timestamp at which the users row was created - Universal Time Zone.
User Date Of Birth (Universal)	Date of birth of the user - Universal Time Zone.
User Deleted At (Universal)	Timestamp at which the user's account was deleted - Universal Time Zone.
User First Order Completed At (Universal)	The timestamp of the user's first completed order - Universal Time Zone.
User First Subscription Order Completed At (Universal)	The timestamp of the user's first completed subscription order, regardless of subsequent subscriptions - Universal Time Zone.
User Last Order Completed At (Universal)	The timestamp of the user's last completed order - Universal Time Zone.
User Last Sign In At (Universal)	The last sign in timestamp for the user - Universal Time Zone.
User Updated At (Universal)	Timestamp at which the users row was last updated - Universal Time Zone.
Average Net Revenue	This column is not documented.
Average Transaction Amount	Full amount of transaction. The value will be positive if the transaction is a payment, and negative if the transaction is a refund.
Net Revenue	This column is not documented.
Transaction Amount	Full amount of transaction. The value will be positive if the transaction is a payment, and negative if the transaction is a refund.

Updated 20 Sep 2024

Did this page help you?

Subscriptions

Users