The following is a list of fields that must be included in a table called CC_Submit_Order created in a folder called CC in Oracle Marketing Cloud.
Field Name | Field Type |
|---|---|
RIID_ | Integer Field |
EMAIL_ADDRESS | Text Field (to 100 chars) |
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) |
CREATED_DATE_ | Time Stamp Field (date + time) |
MODIFIED_DATE_ | Time Stamp Field (date + time) |
ORDER_ITEM_NAMES | Text Field (to 50 chars) |
