Membership Business Objects

Related videos

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

In This Article 

CsDuesHistory

Contains the history of dues information. There are likely multiple rows per iMIS ID in this BO, one row for each dues payment. Dues history is only generated after dues payments and batches have been processed.

Common joins

Some common joins include:

Table 19: Viewing common joins for CsDuesHistory
Business Object Relation
NetContactData CsDuesHistory.ID = NetContactData.Id

Properties

Table 20: Viewing properties for CsDuesHistory
Properties
ActivityType ProductCode
Amount SequenceNumber
CompanyId SourceCode
Description PaidThru
EffectiveDate TransactionDate
ID  

CsSubscriptions

Contains details of subscriptions for each ID including current dues and various other subscription information. There will be one row per subscription item which may result in multiple rows per iMIS ID.

Common joins

Some common joins include:

Table 21: Viewing common joins for CsSubscriptions
Business Object Relation
NetContactData ScSubscriptions.Id = NetContactData.ID
CsProductType CsSubscriptions.ProductType = CsProductType.Prod Type
CsProduct CsSubscriptions.ProductCode = CsProduct.Product Code

Properties

Table 22: Viewing properties for CsSubscriptions
  Properties
AppealCode Complimentary LastIssueDate ProductCode
Balance Copies LastPaidThrough ReminderCount
BeginDate CopiesPaid EntityCode ReminderDate
BillAmount FairMarketValue PaidThrough RenewMonths
BillCopies FutureCopies PaymentAmount SourceCode
BillDate FutureCredits PaymentDate Status
BillThrough ID BillAddressNumber BillBegin
BillType InvoiceLineNumber MailAddressNumber CancelledAsOf
BillToId InvoiceReferenceNumber PreviousBalance AdjustmentAmount
CampaignCode IsFRItem PriorYears Is_Membership_Component
CancelReason LastIssue ProductType BillingLogKey

CsSubscriptionsChapters

Contains the subscriptions for chapters. One row per Chapter subscription which may mean more than one row per iMIS ID depending on the number of Chapter subscriptions.

Common joins

Some common joins include:

Table 23: Viewing common joins for CsSubscriptionChapters
Business Object Relation
CsSubscriptions CsSubscriptionsChapters.Id = CsSubscriptions.Id

Properties

Table 24: Viewing properties for CsSubscriptionChapters
Properties
ID
Status
Product_Code
Product_Minor