Sales Order Source View
This table explains the nodes and fields most commonly used for a sales order query and the types of information they provide.
Node Name |
Description |
---|---|
Sales Orders |
This is the top node in a sales order query and contains information about the actual order itself. Contains information found on the overall constituent record and on the Personal Info tab, such as the amount of the overall order, sales method, refund status, etc. Commonly Used Fields
|
Address |
Pulls the information about the address associated with a sales order. For example, the address the patron entered during their online transaction, even if it's not their primary address. Commonly Used Fields
|
Application User
|
Pulls details about the application user that processed the order in Altru. For example, use this when you need to see the name of the user that processed the order. Commonly Used Fields
|
Constituent |
Pulls details about the constituent who is listed as the patron on the order. You can also expand this node to drill down further into details about that constituent. Commonly Used Fields
|
Email Address |
Pulls the information about the email address associated with the sales order. For example, the email address the patron entered during their online transaction, even if it's not their primary email. Commonly Used Fields
|
Notes |
Pulls details about any notes that were added to the Documentation tab of the order or added via the Comments field on an online donation form. Commonly Used Fields
|
Phone |
Pulls the information about the phone number associated with the sales order. For example, the phone number a patron entered during their online transaction, even it's not their primary phone number. Commonly Used Fields
|
Refunds |
Pulls information about refunds made from a sales order, such as the refund method or which items were part of the refund. Note: Use this field when pulling refund details about an entire order. Commonly Used Fields
|
Reservation |
Pulls information about a group sales reservation. Note: Includes the same nodes as a reservation query. Commonly Used Fields
|
Sales Order Item |
Pulls information about what was purchased on a sales order. Note: This is the most frequently used node when building a sales order query and you will often expand and drill further to find more details about specific items on the order. Commonly Used Fields
|
Sales Order Payment |
Pulls information about a payment or payments accepted for an order. For example, use this node to find which payment method was used for an order or whether the payment is in an open drawer. Commonly Used Fields
|