Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Sample Lot Fields: Import Preparation

The following table contains specific information about setting up your CSV file before importing sample lots into Oracle CRM On Demand. This information supplements the guidelines given in the topic Field Type Guidelines for Importing Data. First, you must review the following information before performing an import.

NOTE: The Default Field column in this table contains only the initial (default) name for each field. It does not contain any names that have been changed for your company in Oracle CRM On Demand. Therefore, if you do not see a specific field when you try to import your data, check with your company administrator to determine the new name for the field.

Default Sample Lot Field Name

Data Type

Maximum Length

Comments

Cutoff Date

Date

7

This date is calculated. The calculation is based on the expiration date minus the value provide in the Short Days field. of the short days. For example, if the expiration date is January 31 and the value in the Short Days field is 30, Cutoff Date is January 1. This indicates that the sample lot must be used in the immediate future or to return them to the head office.

Description

Text

255

The lot description.

Expiration Date

Date

7

The expiration date of the sample lot.

Inventory By Lot

Boolean

1

This field indicates whether the inventory is tracked at the lot level or product level.

Lot#

Text

100

The lot name.

Orderable

Boolean

1

This field indicates whether the lot can be ordered.

Product Level

Number

22

None

Sample

Text

15

The product name.

Short Days

Number

22

The number of lead days.

Start Date

Date

7

The sample lot start date.

UoM

Text

30

The unit of measure.

Related Topics

See the following topics for related information:


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.