| Print Open PDF Version of Online Help

##### 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 administrator to determine the new name for the field.
Default Sample Lot Field Name | Data Type | Maximum Length | Comments
--- | --- | --- | ---
CutOff Date | Text | 255 | The text version of the CutOff_Date field.
Cutoff_Date | Date | 10 | 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 if the value in the Short Days field is 30, then the value in the Cutoff_Date field is January 1. This date indicates that the sample lot must be used in the immediate future or returned to the head office.
Description | Text | 255 | The lot description.
Division | Text | 50 | None
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.
Picklist Value Group | Text | 50 | None
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: Field Type Guidelines for Importing Data Importing Your Data Sample Lots

Published 5/23/2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.