The following is a list of fields that must be included in a list extension table called CC_Submit_Order
created in a folder called CC in Responsys.
Field Name | Field Type |
---|---|
RIID_ | Integer Field |
ORDER_ID | Text Field (to 25 chars) |
NUMBER_OF_ITEMS | Number Field |
ORDER_DETAILS_URL | Text Field (to 100 chars) |
ORDER_CURRENCY | Text Field (to 25 chars) |
ORDER_SUBMIT_TIME | Time Stamp Field (date + time) |
ORDER_SHIPPING_ADDRESS1 | Text Field (to 100 chars) |
ORDER_SHIPPING_ADDRESS2 | Text Field (to 100 chars) |
ORDER_SHIPPING_CITY | Text Field (to 25 chars) |
ORDER_SHIPPING_STATE | Text Field (to 25 chars) |
ORDER_SHIPPING_COUNTRY | Text Field (to 25 chars) |
ORDER_SHIPPING_POSTAL | Text Field (to 25 chars) |
ORDER_TOTAL | Text Field (to 25 chars) |
ORDER_SHIPPING_MOBILE | Text Field (to 25 chars) |
ORDER_ITEM_NAMES | Text Field (to 50 chars) |
CREATED_DATE_ | Time Stamp Field (date + time) |
MODIFIED_DATE_ | Time Stamp Field (date + time) |
SITE_ID | Text Field (to 25 chars) |
SITE_NAME | Text Field (to 500 chars) |