The following is a list of fields that must be included in a table called CC_Master_User_List
created in a folder called CC in Responsys. The first list is the system fields for the table, and the second list is the custom fields for the table.
Field Name | Field Type |
---|---|
RIID_ | Integer Field |
CREATED_SOURCE_IP_ | Text Field (to 255 chars) |
CUSTOMER_ID_ | Text Field (to 255 chars) |
EMAIL_ADDRESS_ | Text Field (to 500 chars) |
EMAIL_DOMAIN_ | Text Field (to 255 chars) |
EMAIL_ISP_ | Text Field (to 255 chars) |
EMAIL_FORMAT_ | Single character field |
EMAIL_PERMISSION_STATUS_ | Single character field |
EMAIL_DELIVERABILITY_STATUS_ | Single character field |
EMAIL_PERMISSION_REASON_ | Text Field (to 255 chars) |
EMAIL_MD5_HASH_ | Text Field (to 50 chars) |
EMAIL_SHA256_HASH_ | Text Field (to 100 chars) |
MOBILE_NUMBER_ | Text Field (to 50 chars) |
MOBILE_COUNTRY_ | Text Field (to 25 chars) |
MOBILE_PERMISSION_STATUS_ | Single character field |
MOBILE_DELIVERABILITY_STATUS_ | Single character field |
MOBILE_PERMISSION_REASON_ | Text Field (to 255 chars) |
POSTAL_STREET_1_ | Text Field (to 255 chars) |
POSTAL_STREET_2_ | Text Field (to 255 chars) |
CITY_ | Text Field (to 50 chars) |
STATE_ | Text Field (to 50 chars) |
POSTAL_CODE_ | Text Field (to 25 chars) |
COUNTRY_ | Text Field (to 50 chars) |
POSTAL_PERMISSION_STATUS_ | Single character field |
POSTAL_DELIVERABILITY_STATUS_ | Single character field |
POSTAL_PERMISSION_REASON_ | Text Field (to 255 chars) |
CREATED_DATE_ | Time Stamp Field (date + time) |
MODIFIED_DATE_ | Time Stamp Field (date + time) |
Field Name | Field Type |
---|---|
LOCALE | Text Field (to 25 chars) |
FIRST_NAME | Text Field (to 100 chars) |
LAST_NAME | Text Field (to 100 chars) |
COMMERCE_REGISTRATION_DATE | Time Stamp Field (date + time) |
COMMERCE_LAST_ACTIVITY | Time Stamp Field (date + time) |
AGE | Number Field |
PROFILEATTRIBUTE | Text Field (to 100 chars) |