Loyalty Tier

CCP_LoyaltyTier

Overview

Table NameCCP_LoyaltyTier
Access LevelClient Only
Entity TypeCLDE_CCP
Is DocumentNo
Is ViewNo
Has UUIDYes
Parent TableAD_Client
WikiView on iDempiere Wiki

Columns (19)

Column Type Required Default Description
AD_Client_ID Table Direct(22) No @#AD_Client_ID@ Tenant for this installation.
AD_Org_ID Table Direct(22) No @#AD_Org_ID@ Organizational entity within tenant
CCP_FromPointsMultiplyRate Number(14) Yes - -
CCP_FromQualifyingPoints Integer(14) Yes - -
CCP_LoyaltyCardType_ID Table Direct(22) Yes - -
CCP_Loyalty_ID Search(22) Yes - -
CCP_LoyaltyTier_ID ID(22) No - -
CCP_LoyaltyTier_UU String(36) No - -
CCP_PointsExpirationDays Integer(22) No 0 -
CCP_ToPointsMultiplyRate Number(22) Yes - -
CCP_ToQualifyingPoints Integer(14) Yes - -
Color Color(10) No - -
Created Date+Time(7) No SYSDATE Date this record was created
CreatedBy Search(22) No - User who created this records
Description String(255) No - Optional short description of the record
IsActive Yes-No(1) No Y The record is active in the system
Name String(255) Yes - Alphanumeric identifier of the entity
Updated Date+Time(7) No SYSDATE Date this record was updated
UpdatedBy Search(22) No - User who updated this records

Foreign Keys

Column References Description
AD_Client_ID AD_Client.AD_Client_ID Tenant for this installation.
AD_Org_ID AD_Org.AD_Org_ID Organizational entity within tenant
CCP_LoyaltyCardType_ID CCP_LoyaltyCardType.CCP_LoyaltyCardType_ID -
CCP_Loyalty_ID CCP_Loyalty.CCP_Loyalty_ID -

Generated on 2026-05-03T18:01:41.426856501Z