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

File Mapping for Order Line Records


Table 10 describes the CSV file mapping for order line records.

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

ORDER_LINE_ID

String

30 characters

Yes

Order line identifier.

ORDER_ID

String

30 characters

Yes

Order identifier.

NOTE:  ORDER_ID is a foreign key to the ORDERS table.

PRODUCT_ID

String

30 characters

Yes

PRODUCT_ID references a product in the PRODUCT table.

NOTE:  PRODUCT_ID is a foreign key to the PRODUCTS table.

QUANTITY

Number

15 digits with 2 decimal places

No

Quantity sold on this order line.

AMOUNT

Number

15 digits with 2 decimal places

No

The order line amount.

CLOSE_DATE

Date

None

No

The date when the product sale is closed.

Format: YYYY-MM-DD.

LEAD_DATE

Date

None

No

The date when the lead that results in this order line was originally recorded or received.

Format: YYYY-MM-DD.

The sample file is ORDER_LINES.csv.

Example of an Order Line Records File

The following is an example of an order line records file:

ORDER_LINE_ID, ORDER_ID, PRODUCT_ID, QUANTITY, AMOUNT, CLOSE_DATE, LEAD_DATE
ORDER_LN-01, ORDER-01, PROD-01, 10, 10, 2008-07-6, 2008-02-15
ORDER_LN-02, ORDER-02, PROD-02, 50, 50, 2008-03-9, 2007-08-15

ORDER_LINE_ID, ORDER_ID, PRODUCT_ID, QUANTITY, AMOUNT, CLOSE_DATE, LEAD_DATE
ORDER_LN-01, ORDER-01, PROD-01, 10, 10, 2007-02-6, 2008-02-15
ORDER_LN-02, ORDER-02, PROD-02, 50, 50, 2007-03-9, 2009-02-15

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