Commerce Business Objects

The following Commerce business objects are commonly used in commerce-related queries. Review the descriptions to see how each can be joined with other business objects and what properties they include.

CsOrderHistory

Contains product order history information. There are likely multiple rows per iMIS ID in this BO, one row for each order. Order history is only generated after order payments and batches have been processed.

Common joins

Some common joins include:

Table 60: Viewing common joins for CsOrderHistory

Properties

Table 61: Viewing properties for CsOrderHistory

CsOrderLines

Stores data on the line items of open and closed orders. Includes the order number, order line number, item name, quantity sold, amount, discount code, status, and ship to contact ID.

Common joins

Some common joins include:

Table 62: Viewing common joins for CsOrderHistory

Properties

Table 63: Viewing properties for CsOrderHistory

CsOrders

Contains order level details. CsOrders is commonly used to create an invoice or receipt, view order details (amounts paid or outstanding balances), and details on promotion codes.

Common joins

Some common joins include:

Table 64: Viewing common joins for CsOrders

Properties

Table 65: Viewing properties for CsOrders

CsProduct

Contains information about products in iMIS, including dues, certifications, meetings, chapters, committees, and more.

Product contains varying types of products. ProductCode is a concatenation of the type of product and the individual product code in order to create a unique identifier for each row (e.g. COMMITTEE/BOARD). Use product minor for the specific item’s code (e.g. BOARD) but be aware if you have other products that use that code you may get inaccurate results.

Common joins

Some common joins include:

Table 66: Viewing common joins for CsProduct

Properties

Viewing 67: Viewing properties for CsProduct

CsProductCategory

Contains the product categories (Settings > Commerce > Product categories) for products created at Commerce > Add product.

Common joins

Some common joins include:

Table 68: Viewing common joins for CsProductCategory

Properties

Table 69: Viewing properties for CsProductCategory

CsProductType

Contains Product Types for items in the Product table.

Common joins

Some common joins include:

Table 70: Viewing common joins for CsProductType

Properties

Table 71: Viewing properties for CsProductType

CommerceProduct

Stores data on commerce-specific products. Includes fair market value, shipping and handling charges, weight, standard price, discounted price, and other commerce data.

Properties

Table 72: Viewing properties for CommerceProduct

OrdersWithPromotions

Displays all orders and invoices where promotions were applied at checkout.

📘

Note

Membership promotions do not have an order number, and orders which have not yet been invoiced do not have values for invoice properties.

Common joins

Some common joins include:

Table 73: Viewing common joins for OrdersWithPromotions

Properties

Table 74: Viewing properties for OrdersWithPromotions

PromotionUsageByItem

Contains line items from orders and invoices where a promotion was applied.

📘

Note

Membership promotions do not have an order number, and orders which have not yet been invoiced do not have values for invoice properties.

Common joins

Some common joins include:

Table 75: Viewing common joins for PromotionUsageByItem

Properties

Table 76: Viewing properties for PromotionUsageByItem

📘

Note

The following properties contain order or invoice level information, which comes from the parent order or invoice instead of single line items:

• OrderPromotionName
• OrderPromotionCode
• OrderUndiscountedTotal
• Total Charges

The following properties contain single line-item information:

• ItemId
• ItemName
• ItemPromotionCode
• ItemPromotionName
• LineNumber