FIELD NAME

DESCRIPTION

Code

A code used to link this community with other tables

Description

A use description of the community

External No. Search Order

An option to define what search term should be used when there is ambiguity.

• CARDNO
• MEMBERNO
• MEMBERSHIPNO
• ALL

External Membership No. Series

Number series to generate the external membership identity

External Member No. Series

Number series to generate the external member identity

Member Unique Identity

The member value that must be used to uniquely identify a member;

• NONE
• EMAIL
• PHONENO*
• SSN (Social Security Number)

Create Member UI Violation

When a member is created and the unique identity is violated the system can react with in the following ways;

• ERROR – An hard error is thrown
• CONFIRM – A confirm question is issued to challenge the entered value. The user will has the chance to ERROR or REUSE.
• REUSE – will block the old member and create a new member

Member Logon Credentials

Defined what term to use for logon credentials when a 3^rd party member management soft is used;

• NA
• MEMBER_UNIQUE_ID
• MEMBER_NUMBER
• CUSTOM

Membership to Cust. Rel.

This is field is used when memberships are linked with customers. This is required in the following scenarios;

• When members have access to specific discount and price structures.
• When members have access to their account on the web and can/must link their purchases with the membership account number.

Create Renewal Notification

Create a notification when membership requires renewal

FIELD NAME

DESCRIPTION

Code

A code used to link this community with other tables

Description

A use description of the membership

Membership Type

Controls how members and memberships are related.

• COMMUNITY – This is simple type of membership where all members are put into one big group. This is practical when the "membership" is informal and like in email register f.ex. Members may still have a member card and there may be benefits for the individual members.
• GROUP – Similar to the COMMUNITY mode. In this mode the membership time-frame plays a predominant role. Number of members in a group can me limited. The members can have individual roles.
• INDIVIDUAL – One membership – one member.

Loyalty Card

For future use.

Customer Template Code

This code identifies a template for how the customer associated with the membership will be created. This field is required when the "Membership to Cust. Rel." field on community is checked.

Member Information

How the member entity should be treated.

• NAMED – The member must exist
• ANONYMOUS - Membership can be anonymous – there is no member, just the card (Membership Type COMMUNITY)

Blocked

The setup is blocked from usage

Blocked At

Time of block

Perpetual

The membership validity can be perpetual (everlasting)

Member Role Assignment

How members are assigned their role in the membership

• MEMBERS_ONLY
• FIRST_IS_ADMIN
• ALL_ADMINS

Membership Member Cardinality

Maximum members in a GROUP membership

Community Code

A link to the community this membership belongs to

Create Renewal Notification

Create a notification when membership requires renewal

Create Welcome Notification

Create a notification when member is created

Receipt Print Object Type

The type of object used for generating printing for the receipt

Receipt Print Object ID

The object ID used for generating the printout. The system supplied codeunit for printing is

Account Print Object Type

The type of object used for generating printing for the account information

Account Print Object ID

Allow Membership Delete

This options allow memberships to be deleted.

Confirm Member On Card Scan

When a POS function requires the member card to be scanned, the member card will pop up for visual confirm.

The following fields defined how the member card number should be handled. The member card number is public and should not be a sequential number only.

Card Number Scheme

Who responsible of creating the member card number

• NA
• GENERATED
• EXTERNAL

Card Number Prefix

Specific prefixes can be defined (or generated by the number series)

Card Number Length

The length is used to pad a number that is too short

Card Number Validation

If there should be a check digit appended to end of the generated number

Card Number No. Series

The number series used generated the base of member card number

Card Number Valid Until

For how long a member card should be valid

Card Number Pattern

A patter can be entered to control how the card number should be generated. A pattern consists of keywords that will create a number that is a bit more difficult to guess. Available keywords are listed below and must be included between [ and ].

• MA - Member Account Number
• MS – Membership Number
• S – The number generated by the number series
• N – A random number
• A – A random character
• X – A random alphanumeric character.
  
  
  N, A, X can be suffixed by a * and number to repeat it, that number of times.
  The default pattern is [X*4][MA][X*4][MS][S]
  
  Which would generated a member card number similar to:
  RQ41MM-00147VBH7MS-0013100087

Card Print Object Type

The type of object used for generating printing for the member card

Card Print Object ID

FIELD NAME

DESCRIPTION

Type

An option to define what type of "item" we are selling.

• ITEM
• ACCOUNT – This option is reserved for future use. Currently a membership sales must be an item

No.

The Item or Account used for membership sales

Membership Code

Links the Membership Setup table. The item sold will create a membership of this type.

Blocked

Blocked At

Valid From Base

An option to define how the membership time frame start date should be calculated.

• SALESDATE
• DATEFORMULA

Sales Cut-Off Date Calculation

Reserved for future use.

Valid From Date Calculation

Date formula for activation date

Valid Until Calculation

An option to define the duration of the membership. Options are;

• DATEFORMULA
• END_OF_TIME

Duration Formula

Date formula for duration

FIELD NAME

DESCRIPTION

Alteration Type

The type of alteration describe, options are:

• CANCEL
• RENEW
• UPGRADE
• EXTEND

From Membership Code

Links to Membership Setup. The type of membership we intend to change.

Sales Item No.

The sales item used in the POS and accounting to capture the event.

Description

The description used in POS

To Membership Code

The target membership code

Alteration Activate From

Options to define the start date calculation of this change, options are:

• As soon as possible (TODAY)
• Date Formula

Alteration Date Formula

Date formula calculate the start date, e.g. CM+1 to calculate the first of next month.

Activate Grace Period

Activate the grace period filters. Allows for filtering out unwanted change paths in relation to the current state of the membership validity. (E.g. it should not be possible to RENEW membership until 1 month prior to it expires)

Grace Period Relates To

Which date the grace period should operate on. Options are:

• Start Date
• End Date

Grace Period Before

A date formula (such as "14D") to define the time frame BEFORE the grace date which this alteration is valid.

Grace Period After

A date formula (such as "14D") to define the time frame AFTER the grace date which this alteration is valid.

Membership Duration

The duration of the new membership time frame

Price Calculation

How the price should be calculated. Options are:

• UNIT_PRICE – Item Unit Price is suggested
• PRICE_DIFFERENCE – The value difference of the overlapping time period is calculated and the fraction of the extended value is added together
• TIME_DIFFERENCE – only the fraction of the extend value is considered.
  
  
  Not all calculations apply to every alteration type

Stacking Allowed

Defines if multiple RENEWs are possible.

FIELD NAME

DESCRIPTION

Code

Primary Key

Description

A useful description

Type

Option to determine type of notification

• WELCOME
• RENEWAL

Days Before

Used with type renewals, this will create a notification X days before the membership needs to be renewed

Days Past

Used with WELCOME and NONVISIT. Number of days since member was created or members' previous visit.

Template Filter Value

This value is passed on the email processing and the intention is to simply notification template selection.

Community Code

This notification belongs to stated Community Code. May be blank to be independent of membership code.

Membership Code

This notification belongs to stated Membership Code. May be blank to be independent of membership code.

Next Notification Code

Unless the notification is canceled when processed, it will create a new notification with this code.

Cancel Overdue Notif. (Days)

Is a safeguard to not send notifications that are overdue, stated by number of days. A zero indicates no safeguard.

Target Member Role

Who among the membership members is the target of the notification;

• FIRST ADMIN
• ALL ADMINS
• ALL MEMBERS
  
  
  The welcome notification e.g. might be intended for admin members only.

FIELD NAME

DESCRIPTION

Membership Code

This rule is for the stated membership code

Admission Code

This rule is for the stated admission code. Works with webservie not POS (yet)

Constraint Type

Options are

• Relative Time - now minus the seconds (last hour)
• Fixed Time - between certain times of day (lunch time)(rush hour)
• Dateformula - similar to relative time but uses date formula

Constraint Source

Options are

• Membership
• Member
• Membercard
  
  Defines whether rule is applied to the memberships, members or
  member cards. Memberships can have many members and every
  member could have multiple cards. When the relationship is 1:1:1
  this does really matter

Constraint Seconds

No. of seconds when constraint type is Relative Time

Constraint From Time

Constraint start time when constraint type is Fixed Time

Constraint Until Time

Constraint end time when constraint type is Fixed Time

Constraint Dateformula

Date formula when constraint type is Dateformula

Event Limit

The access limit per event

POS Response Action

Options are

• Error
• Confirm
• Message
• Allow

POS Response Message

Response message to display depending on the POS response action
selected

WS Response Action

Options are

• Error
• Allow

WS Deny Message

Message when WS response action is Error

Response Code

Unique code for each response

Blocked

Block rule when not in use

FIELD NAME

DESCRIPTION

Entry No.

Primary Key

External Membership No.

The external membership identification

Description

Membership description

Company Name

A corporate membership belongs to a named company

Blocked

Enables blocking a membership without interrupting the membership time frame

Blocked At

When it was blocked

Blocked By

Initials of user that blocked membership.

Community Code

A link to the membership community table

Customer No.

A link to the customer table

Membership Code

A link to membership setup table

Issued Date

Date of creation

Document ID

(Web Service) A reference to the message that created this membership

FIELD NAME

DESCRIPTION

Membership Entry No.

(Primary Key field) Foreign key to membership table

Member Role

(Primary Key field)
The role member has in this membership, options are:

• ADMIN
• MEMBER

Member Entry No

(Primary Key field) Foreign key to member table

Blocked

Enables blocking a membership without interrupting the membership time frame

Blocked At

When it was blocked

Blocked By

Initials of user that blocked membership.

Community Code

A link to the membership community table

User Logon ID

Credentials for 3^rd party member management software

Password SHA1

Credentials for 3^rd party member management software

External Member No.

(Flow field)

Member Display Name

(Flow field)

External Membership No.

(Flow field)

Membership Code

(Flow field)

Company Name

(Flow field)

DESCRIPTION

Entry No.

Primary Key

External Member No.

The external member identification number

First Name

Middle Name

Last Name

Blocked

Enables blocking a membership without interrupting the membership time frame

Blocked At

When it was blocked

Blocked By

Initials of user that blocked member.

Phone No.

Social Security No.

Address

Post Code Code

City

Country Code

Country

Gender

Options are:

• NOT_SPECIFIED
• MALE
• FEMALE
• OTHER

Birthday

Picture

E-Mail Address

E-Mail News Letter

Options are:

• NOT_SPECIFIED
• YES
• NO

Created Datetime

Display Name

Contact No.

Document ID

(Web Service) A reference to the message that created this member

FIELD NAME

DESCRIPTION

Entry No.

Primary Key

External Card No.

The external member card identification number

External Card No. Last 4

Pin Code

Valid Until

When this member card is used, the valid until date is checked. Expired cards are not valid

Blocked

Enables blocking a membership without interrupting the membership time frame

Blocked At

When it was blocked

Blocked By

Initials of user that blocked member card.

Block Reason

This option to specify why card was blocked. Options are;

• UNKNOWN
• EXPIRED
• USER_REQUEST
• INTERNAL

Membership Entry No.

Foreign key to membership table

Member Entry No.

Foreign key to member table

External Member No.

(Flow field)

Member Blocked

(Flow field)

Display Name

(Flow field)

E-Mail Address

(Flow field)

External Membership No.

(Flow field)

Membership Blocked

(Flow field)

Company Name

(Flow field)

Document ID

(Web Service) A reference to the message that created this member card

FIELD NAME

DESCRIPTION

Entry No.

Primary Key

Membership Entry No.

Foreign key to membership table

Valid From Date

Time frame start date (inclusive)

Valid Until Date

Time frame end date (inclusive)

Created At

Context

The context in which this entry was created. Option are;

• NEW
• CANCEL
• RENEW
• UPGRADE
• EXTEND

Blocked

Enables blocking a membership without interrupting the membership time frame

Blocked At

When it was blocked

Blocked By

Initials of user that blocked membership entry.

Item No.

Item used in sales

Description

Description used in sales

Membership Code

The membership code membership should have code in this time frame. The membership code on membership correctly reflects the current membership code.

Closed By Entry No.

The time frame may be altered by another entry as the consequence of RENEW, UPGRADE, EXTEND. The causing entry is linked on the CANCEL entry

Duration Dateformula

The original duration, as per entry creation

Unit Price

Unit Price (from Item Card)

Amount

Amount (discounts applied)

Amount Incl VAT

Amount Incl VAT

Receipt No.

NPR Reference. POS Receipt number of sales

Line No.

NPR Reference. POS Receipt line number of sales

Source Type

NAV reference of origin. Reserved for future use. Options are:

• SALESORDER

Document Type

NAV reference of origin. Reserved for future use. Option mirror the type of creating document

Document No.

NAV reference of origin. Reserved for future use.

Document Line No.

NAV reference of origin. Reserved for future use.

Import Entry Document ID

(Web Service) A reference to the message that created this member card

FIELD NAME

DESCRIPTION

Entry No.

Primary Key

Membership Entry No.

Foreign Key to membership

Member Entry No.

Foreign Key to member.

• May be non-zero when notification is intended to a specific membership member.
• Target member role rule is also obeyed

Notification Code

Foreign Key to Member Notification Setup

Date To Notify

The date when notification is to be executed.

Notification Status

Process state;

• PENDING
• PROCESSED
• CANCELED

Notification Processed At

Date time of last processing time

Notification Processed By User

Who executed notification

Blocked

Prevents notification from being processed

Blocked At

Date time of the block

Blocked By User

Blocked by user

Notification Trigger

From Member Notification Setup

Template Filter Value

From Member Notification Setup

Target Member Role

From Member Notification Setup

FIELD NAME

DESCRIPTION

Notification Entry No.

Primary Key, Foreign key to Members Notification

Member Entry No.

Primary Key, Foreign key to Member

Membership Entry No.

Foreign key to Membership

Notification Code

From Member Notification

Date To Notify

From Member Notification

Notification Send Status

Process state;

• PENDING
• SENT
• CANCELED
• FAILED

Notification Sent At

Date time

Notification Sent By User

Sent by user

Blocked

Blocked

Blocked At

Blocked at

Blocked By User

Blocked by

Notification Trigger

From Member Notification

Template Filter Value

From Member Notification

Target Member Role

From Member Notification

Notification Method

Option of Notification Method (Should be inherited From Member)

• E-MAIL

External Member No.

From Member

External Membership No.

From Membership

E-Mail Address

From Member

Phone No.

From Member

First Name

From Member

Middle Name

From Member

Last Name

From Member

Display Name

From Member

Address

From Member

Post Code Code

From Member

City

From Member

Country Code

From Member

Country

From Member

Birthday

From Member

Community Code

From Member

Membership Code

From Membership

Membership Valid From

From Membership Entry

Membership Valid Until

From Membership Entry

External Member Card No.

From Member Card

Card Valid Until

From Member Card

Pin Code

From Member Card

Failed With Message

If the send should fail, and if the send implementation returned a reason, it will be here.

Parameter

description

MEMBER_ARRIVAL

The will ask for the member card and register arrival on the default admission code associated with the item specified on the Membership Sales Setup

MEMBER_ARRIVAL:: <ADMISSIONCODE>

As above, but selection the admission code after the double colon. This requires that the ticket is valid for multiple locations and the admission code is valid for the ticket.

SET_MEMBERNUMBER

This function will ask for the member card and extract the customer number from the membership and set it in the POS. Subsequent item registrations will enjoy the benefits derived from price / discount structures defined for the customer.

EDIT_MEMBERINFO

Operates on the POS sales line. If it is a membership POS new sales item, the information may be edited.

LOOKUP_MS_ENTRIES

This function will ask for the member card and show all the time frames the membership has

REGRET_MS_ENTRY

This function will ask for the member card and regret the most recent time frame.

RENEW_MEMBERSHIP

This function will ask for the member card and show a list of the renew products that the membership is entitled to. The list contains prices and calculated dates illustrating the time frame that will result from the change.

EXTEND_MEMBERSHIP

This function will ask for the member card and show a list of the extend products that the membership is entitled to. The list contains prices and calculated dates illustrating the time frame that will result from the change.

UPGRADE_MEMBERSHIP

This function will ask for the member card and show a list of the upgrade products that the membership is entitled to. The list contains prices and calculated dates illustrating the time frame that will result from the change.

CANCEL_MEMBERSHIP

The cancel function will terminate the membership on date specified by the date formula.

Services

DESCRIPTION

CreateMembership

This web service creates an empty membership using a sales item from the membership sales setup table

AddMembershipMember

Adds members to an existing membership

UpdateMember

Updates an existing member

UpdateMemberImages

Updates an existing members picture

BlockMembership

Blocks an existing membership

Services

DESCRIPTION

GetMembership

Searches and returns Membership information

GetMembershipMembers

Searches and returns the Member connected to a membership

GetMemberImage

Get the image for a member

MembershipValidation

Checks if membership is active

MemberValidation

Checks if member is blocked and membership is active

MemberCardNumberValidation

Checks if member card is valid and membership is active

MemberEmailExists

Check if the email address has been used on an already created and active member.

Services

DESCRIPTION

GetMembershipChangeItemsList

This service returns a list of items that can be used to alter the membership. The membership time frame and price is calculated in context of the active membership.

ChangeMembership

This service executes the change to the membership as described by one of the items from the list in GetMembershipChangeItemsList service

Services

DESCRIPTION

GetMembershipTicketList

This service returns a list of valid ticket items that the member can select from, to accommodate a self-service check-in for himself including guests.

(This is a 2 step process)
Second half (registering ticket and arrival) is provided by the ticket management web service

MemberCardRegisterArrival

This services is intended for handling self-service scanning of member card number, and allowing member entry.
(This is a one step process)

MemberRegisterArrival

This services is intended for handling self-service scanning of member number, and allowing member entry.
(This is a one step process)

FIELD NAME

DESCRIPTION

Code

BK - A code used to link this community with other tables

Description

Bamse Klubben - A use description of the community

External No. Search Order

CARDNO - An option to define what search term should be used when there is ambiguity

External Membership No. Series

NPR_MSHIP - Number series to generate the external membership identity

External Member No. Series

NPR_MEMBER - Number series to generate the external member identity

Member Unique Identity

EMAIL - The member value that must be used to uniquely identify a member

Create Member UI Violation

When a member is created and the unique identity is violated the system can react with in the following ways;

• ERROR – An hard error is thrown

Member Logon Credentials

NA - Defined what term to use for logon credentials when a 3rd party member management soft is used

Membership to Cust. Rel.

Check On - This is field is used when memberships are linked with customers. This is required in the following scenarios;

• When members have access to specific discount and price structures.
• When members have access to their account on the web and can/must link their purchases with the membership account number.

Create Renewal Notification

Check On - Create a notification when membership requires renewal;

Code

A code used to identify the scheme;
e.g. ADVANCED, PROGRESSIVE, SIMPLE

Description

Description of the scheme

Collection Period

The period which determines when the customer is eligible to accumulate points. Hence the computation of the points will be based on the period for which the point will be collected;

• As You Go – There is no fixed period, the points will be collected as and when the purchase is done
• Fixed – A defined period is established for collection of points

Fixed Period Start

The Date formula in NAV is used to defined the period starting point based on the purchase date.
(see table below for example of date formula in NAV)

Collection Period Length

The Date formula in NAV is used to defined the period length in which the points will be collected.
(see table below for example of date formula in NAV)

Expired Uncollected Points

This field determine if any uncollected points will have expired and not taken into the calculation of the points for collection.

Voucher Point Source

It is the basis to collect the points to use in the calculation of the reward.

• Uncollected Points – Unused points
• Previous Period – points from previous period

Voucher Point Threshold

The minimum number of points to start the calculation for the loyalty program.

Voucher Creation

The method to be used to create the Discount Voucher or Coupon;

• Note: Currently we are developing the program to create the coupon – so far we have the solution to compute the points, but not the conversion of the points into coupons.

Base Point

It is the base to calculate the value for the Discount Voucher or Coupon;

• Amount – The calculation of points to be allocated will be based on amount purchase.
• Item Point Setup – The calculation of points will be based on a predefine points for the purchase of a particular item
• Amount and Item Point Setup – A combination of both of the above

Amount Base

The base amount is to include or exclude VAT amount in it calculation when converting to Loyalty Currency.
For example, if the amount including 25% of VAT is 125, then the base will be on:

• Including VAT – 125.
• Excluding VAT – 100

Point on Discounted Sales

If the check box is ticked, then we will use discounted amount to calculate the points or else, it will not be taken into the calculation.

CW

9/29/13 (Sunday)

Returns the last date of the current week

CM

9/30/13 (Monday)

Returns the last date of the current month

CQ

9/30/13 (Monday)

Returns the last date of the current quarter

D15

10/15/13 (Tuesday)

Returns the next 15th of the month

D15 + 1M

11/15/13 (Friday)

Returns 1 month after the next 15th of the month

Same result as 1M + D15

1M + D15

11/15/13 (Friday)

Returns 15th day after the date is advanced 1 month

Same result as D15 + 1M

1M – 15D

10/10/13

Returns the date 15 days less than a full month after reference date

1M + 15D

11/9/2013

Returns the date 15 days more than a full month after reference date

CM +1D

10/1/13 (Tuesday)

Returns the 1st of the following month

CM+1M

10/30/13 (Wednesday)

Returns the last date of the current month advanced by one month

If the reference date had been 02/23/2013 the returned date would be 03/28/13

CM + D10 + 90D

1/8/2014 (Wednesday)

Returns a date 90 days after the next 10th of the month

1M+CM

10/31/13 (Thursday)

Returns the last date of the following month

If the reference date had been 02/23/2013 the returned date would be 03/31/13

CW+1D
or
CW+WD1

9/30/13 (Monday)

Returns the Monday of Next Week

CW+5D
or
CW+WD5

10/4/2013 (Friday)

Returns the Friday of Next Week

CW+1D+3W

10/21/2013 (Monday)

Returns 3 Weeks from Next Monday

CW-1D

9/28/2013 (Saturday)

Returns Saturday of This Week

If the reference date had been 09/29/2013 (Sunday) the returned date would still be 09/28/2013. The week starts on Monday in NAV.

D15+WD1

10/21/13 (Monday)

Returns the Monday after the next 15th of the month

WD4 + 6W

11/7/13 (Thursday)

Returns the Thursday 6 weeks after the next Thursday.

Imagine a vendor that ships only once a week with a long time in transit.

MEMBERSHIP SETUP

Code

CLUB-VIP - A code used to identify this community

Description

Bamse klubben - A use description of the membership

Membership Type

Controls how members and memberships are related.

• COMMUNITY – This is simple type of membership where all members are put into one big group. This is practical when the "membership" is informal and like in email register f.ex. Members may still have a member card and there may be benefits for the individual members.
• GROUP – Similar to the COMMUNITY mode. In this mode the membership time-frame plays a predominant role. Number of members in a group can be limited. The members can have individual roles.
• INDIVIDUAL – One membership – one member.

Community Code

BK - A link to the community this membership belongs to

Loyalty Code

ADVANCED – This code determines which Loyalty Reward Program is attached to the Community Code.

Loyalty Card

Define whether a Loyalty Card is to be issued to the member or not. It is in this screen that we make the relationship between the Community (Member Community) & the Loyalty Reward Program (Loyalty Setup)

Customer Template Code

WEB - This code identifies a template for how the customer associated with the membership will be created. This field is required when the "Membership to Cust. Rel." field on community is checked.
Note: The customer template is defined the Configuration Template which is the new standard for Navision as from version 2016 onwards.

Member Information

How the member entity should be treated.

• NAMED – The member must exist
• ANONYMOUS - Membership can be anonymous – there is no member, just the card (Membership Type COMMUNITY)

Blocked

The setup is blocked from usage

Blocked At

Time of block

Perpetual

The membership validity can be perpetual (everlasting)

Member Role Assignment

How members are assigned their role in the membership

• MEMBERS_ONLY
• FIRST_IS_ADMIN
• ALL_ADMINS

Create Renewal Notification

Create a notification when membership requires renewal

Create Welcome Notification

Create a notification when member is created

Membership Member Cardinality

Maximum members in a GROUP membership

Allow Membership Delete

This options allow memberships to be deleted.

Confirm Member On Card Scan

When a POS function requires the member card to be scanned, the member card will pop up for visual confirm.

Account Print Object Type

The type of object used for generating printing for the account information

Account Print Object ID

The Object ID to be developed

Receipt Print Object Type

The type of object used for generating printing for the receipt

Receipt Print Object ID

The object ID used for generating the printout.

The following fields defined how the member card number should be handled. The member card number is public and should not be a sequential number only.

Card Number Scheme

Who responsible of creating the member card number

• NA
• GENERATED
• EXTERNAL

Card Number Prefix

Specific prefixes can be defined (or generated by the number series)

Card Number Length

The length is used to pad a number that is too short

Card Number Validation

If there should be a check digit appended to end of the generated number

Card Number No. Series

The number series used generated the base of member card number

Card Number Valid Until

For how long a member card should be valid

Card Number Pattern

A patter can be entered to control how the card number should be generated. A pattern consists of keywords that will create a number that is a bit more difficult to guess. Available keywords are listed below and must be included between [ and ].

• MA - Member Account Number
• MS – Membership Number
• S – The number generated by the number series
• N – A random number
• A – A random character
• X – A random alphanumeric character.
  
  
  N, A, X can be suffixed by a * and number to repeat it, that number of times.
  The default pattern is [X*4][MA][X*4][MS][S]
  
  Which would generate a member card number similar to:
  RQ41MM-00147VBH7MS-0013100087

Card Print Object Type

The type of object used for generating printing for the member card

Card Print Object ID

The object ID used for generating the printout.

Ticket Item Barcode

This barcode is created as a sales line in environment of Ticketing. It is not used for Loyalty purpose.
E.g 2900000311015 is an item on the POS which in a scenario where that this item can be given free to the member. It is used as a quick sales item on a specific button in the POS. When scanning the membership number, it will trigger a sales line for that ticket or item number (2900000311015).

Type

An option to define what type of "item" we are selling.

• ITEM
• ACCOUNT – This option is reserved for future use. Currently a membership sale must be an item

No.

The Item or Account used for membership sales

Membership Code

Links the Membership Setup table. The item sold will create a membership of this type.

Blocked

If parameter is not used, then it is blocked

Blocked At

Date the block was done

Valid From Base

An option to define how the membership time frame start date should be calculated.

• SALESDATE
• DATEFORMULA

Sales Cut-Off Date Calculation

Reserved for future use.

Valid From Date Calculation

Date formula for activation date

Valid Until Calculation

An option to define the duration of the membership. Options are;

• DATEFORMULA
• END_OF_TIME

Duration Formula

Date formula for duration

Assign Loyalty Points On Sale

Determine whether points should be assigned when sales are done on this membership type

Issue Coupon Module

Issuing module needs to be Member_Loyalty

Auto-Renew To

Item to Auto-Renew To