Clubs (Membership) Lookup

The Membership Clubs Lookup is used to search for entities who also joined a particular membership club.

 

How Do I Perform a Template Lookup?

 

How Do I Perform an Advanced Lookup?

 

 

Data Fields:

 

Memb Number

The ID number of the entity holding the membership (individual or organization) that you wish to look up.

Assigned Num

The alternate membership ID number you wish to look up.

Club Code

The code of the club to be connected to the membership for the entity you wish to look up. Values in this drop-down list are validated against the tms_memb_club table (MA).

Rate Code

The rate code (dues) for the club you wish to look up. Values in this drop-down list are validated against the  tms_memb_rate table (M3).

Comment

A general comment about the club you wish to look up.

Operator Name

The name of the operator that last modified the row that you wish to look up.

User Group

The name of the user group that last modified the row that you wish to look up.

Amount

The club cost you wish to look up.

Orig Amt

The original cost amount you wish to look up.

Date Added

The date that the row that you wish to look up was added.

Date Modified

The date that the row that you wish to look up was last modified.