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_EndTimeOfTheDay |
Time(22) |
No |
- |
- |
CCP_LoyaltyTier_ID |
Table Direct(22) |
Yes |
- |
- |
CCP_LoyaltyTierPromRule_ID |
ID(22) |
No |
- |
- |
CCP_LoyaltyTierPromRule_UU |
String(36) |
No |
- |
- |
CCP_PromRule_ID |
Table Direct(22) |
Yes |
- |
- |
CCP_StartTimeOfTheDay |
Time(22) |
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 |
EndDate |
Date+Time(7) |
No |
- |
Last effective date (inclusive) |
IsActive |
Yes-No(1) |
No |
Y |
The record is active in the system |
SeqNo |
Integer(22) |
Yes |
@SQL=SELECT COALESCE(MAX(SeqNo),0)+10 AS DefaultValue FROM CCP_LoyaltyTierPromRule WHERE CCP_LoyaltyTier_ID=@CCP_LoyaltyTier_ID@ |
Method of ordering records; lowest number comes first |
StartDate |
Date+Time(7) |
No |
- |
First effective day (inclusive) |
Updated |
Date+Time(7) |
No |
SYSDATE |
Date this record was updated |
UpdatedBy |
Search(22) |
No |
- |
User who updated this records |