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_CouponCode |
String(255) |
No |
- |
- |
CCP_Coupon_ID |
ID(22) |
No |
- |
- |
CCP_CouponProgram_ID |
Table Direct(22) |
Yes |
- |
- |
CCP_Coupon_UU |
String(36) |
No |
- |
- |
CCP_MaxRedemptionsPerBP |
Integer(14) |
No |
- |
- |
CCP_MaxRedemptionsTotal |
Integer(14) |
No |
- |
- |
CCP_RedemptionsCounter |
Integer(14) |
Yes |
0 |
- |
CCP_Reference |
String(255) |
No |
- |
- |
CCP_Status |
List(2) |
Yes |
DR |
- |
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 |
StartDate |
Date+Time(7) |
No |
- |
First effective day (inclusive) |
UPC |
String(30) |
No |
- |
Bar Code (Universal Product Code or its superset European Article Number) |
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 |