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_ExecutionsCounter |
Integer(22) |
No |
- |
- |
CCP_MaxExecutions |
Integer(22) |
No |
- |
- |
CCP_Promotion_ID |
ID(22) |
No |
- |
- |
CCP_Promotion_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 |
Name |
String(255) |
Yes |
- |
Alphanumeric identifier of the entity |
SeqNo |
Integer(22) |
Yes |
@SQL=SELECT COALESCE(MAX(SeqNo),0)+100 AS DefaultValue FROM CCP_Promotion WHERE AD_Client_ID=@AD_Client_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 |
Value |
String(40) |
No |
- |
Search key for the record in the format required - must be unique |