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

• CsOrderHistory.ID = NetContactData.Id: Gets details about a specific order. Filter on product code to see specific product details of an order.

Properties

• ActivityType
• Amount
• CompanyId
• ProductName
• ID
• MemberType
• ProductCode
• Quantity
• SequenceNumber
• SourceCode
• TransactionDate

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

• CsOrderLine.Product Code = CsProduct.Product Code
• CsOrder.Order Number = CsOrderLine.Order Number
• CsOrderLines.Product Code = CsFunction.Product Code

Properties

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

• CsOrders.ST_ID = NetContactData.Id: Gets contact details about a specific ID. ST_ID represents the Ship To ID.
• CsOrders.BT_ID = NetContactData.Id: Gets contact details about a specific billing ID. BT_ID represents the Bill To ID.

Properties

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

• CsProduct.ProductCode = CsOrderLines.ProductCode

Properties

CsProductCategory

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

Common joins

• CsProductCategory.ProductCategory = CsProduct.ProductCategory

Properties

• Description
• ProductCategory
• UserDefinedField1
• UserDefinedField2
• UserDefinedField3
• UserDefinedField4

CsProductType

Contains Product Types for items in the Product table.

Common joins

• CsProductType.ProductType = CsProduct.ProductType

Properties

• ProductType
• Description

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

OrdersWithPromotions

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

Common joins

• CsOrders.Order Number = OrdersWithPromotions.Order_Number
• OrdersWithPromotions.Invoice Id = InvoiceSummary.Invoice ID

Properties

• FULL_NAME
• BT_ID
• ORDER_DATE
• OrderPromotionName
• DISCOUNT_CODE
• UNDISCOUNTED_TOTAL
• LINE_TOTAL
• ORDER_NUMBER
• DiscountAmount
• ORDER_TYPE_CODE
• SOURCE_SYSTEM
• InvoiceID
• InvoiceNumber
• InvoiceReferenceNumber
• TotalCharges

PromotionUsageByItem

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

Common joins

• PromotionUsageByItem.Invoice Number = CsOrders.Invoice Number
• InvoiceSummary PromotionUsageByItem.InvoiceId = InvoiceSummary.Invoice ID

Properties

• Amount
• BillToPartyId
• DiscountAmount
• EventName
• InvoiceId
• InvoiceNumber
• InvoiceReferenceNumber
• ItemId
• ItemName
• ItemPromotionCode
• ItemPromotionName
• LineNumber
• OrderNumber
• OrderPromotionCode
• OrderPromotionName
• OrderUndiscountedTotal
• SourceSystem
• TransactionDate
• UndiscountedAmount