Oracle® Social CRM Applications Administration Guide > File Mapping for Records >

File Mapping for Order Records


Table 8 describes the CSV file mapping for order records.

Table 8. Data Types for Order Records
Column
Data Type
Maximum Length
Required
Description

ORDER_ID

String

30 characters

Yes

Order header identifier.

CUSTOMER_ID

String

30 characters

Yes

Identifies the customer on this order.

NOTE:  CUSTOMER_ID is a foreign key to the CUSTOMERS table.

Table 9.

The sample file is ORDERS.csv.

Example of an Order Records File

The following is an example of an order records file:

ORDER_ID, CUSTOMER_ID
ORDER-01, CUST-01
ORDER-02, CUST-02

Oracle® Social CRM Applications Administration Guide Copyright © 2009, Oracle. All rights reserved.