| Imprimir Abrir versão PDF da ajuda online

##### User Fields: Import Preparation The following table contains specific information about setting up your CSV file before importing users into Oracle CRM On Demand. NOTE: To import user records, your role must include the Manage Users privilege. This information supplements the guidelines given in the topic Field Type Guidelines for Importing Data. First, you must review the following import information before performing an import. NOTA: A coluna Campo predefinido nesta tabela contém apenas o nome inicial (predefinido) para cada campo. Não contém quaisquer nomes que tenham sido alterados pela empresa no Oracle CRM On Demand. Assim, se não conseguir visualizar um campo específico ao tentar executar uma importação dos dados, consulte o administrador para determinar o novo nome do campo.
Default User Field Name | Data Type | Maximum Length | Comments
--- | --- | --- | ---
Alias | Text | 50 | Required field by default.
User Address 1 | Text | 200 | For a description of how to map address fields on a country-by-country basis, see About Countries and Address Mapping.
User Address 2, 3 | Text | 100 | For a description of how to map address fields on a country-by-country basis, see About Countries and Address Mapping.
User City | Text | 50 | None
User Country | Picklist | 30 | Default valid values are the names of all the countries in the world. The valid value for the U.S. is USA. The application does not allow modification of valid values for this field. Make sure the import data matches the valid values for this field before import (see About Countries and Address Mapping).
User PO Box/Sorting Code | Text | 30 | None
User Province | Text | 50 | For Canada, see About Countries and Address Mapping. However, this is not a picklist field.
User US State | Picklist | 2 | For the list of valid US state values, see About Countries and Address Mapping.
User Zip/Post Code | Text | 30 | None
Cellular Phone # | Phone | 40 | None
Currency | Text | 50 | This field is set at the company level, and, consequently, you cannot import this field or edit its picklist values.
Department | Text | 75 | None
Division | Text | 75 | None
Email | Text | 50 | Required field by default.
Email Temporary Password When I Click Save | Check box | Not applicable | If you select this check box and save, an email with a temporary password is sent to the user.
Employee Number | Number | 30 | None
External Unique ID | Text | 30 | Contains the External ID of the imported record.
First Name | Text | 50 | Required field by default.
Fund Approval Limit | Number | 22 | Specific to Oracle CRM On Demand High Tech Edition and Oracle CRM On Demand Partner Relationship Management Edition.
Integration ID | Text | 30 | Identifier used for integrating with external systems.
Language | Text | 50 | You are not able to edit this picklist. Therefore, the values you import must exactly match the standard valid values.
Last Name | Text | 50 | Required field by default.
Locale | Text | 50 | You are not able to edit this picklist. Therefore, the values you import must exactly match the valid values.
Middle Name | Text | 50 | None
Mr./Ms. | Picklist | 30 | None
Preserve Default Book | Check box | Not applicable | For more information on the Preserve Default Book field, see User Fields.
Reports To | Text | Not applicable | This is a calculated field, based on the manager's first and last name.
Reports To External ID | Text | 30 | None
Role | Picklist | 50 | Required field by default. Default valid values: Administrator, Executive, Field Sales Rep, Inside Sales Rep, Sales & Marketing Manager, Service Manager, Service Rep.
Status | Picklist | 30 | Required field by default. Default valid values: Active, Inactive.
Time Zone | Text and number | 100 | You are not able to edit this picklist. Therefore, the values you import must exactly match the valid values.
Work Fax # | Phone | 40 | None
Work Phone # | Phone | 40 | Required field by default.
#### Related Topics See the following topics for related information: Field Type Guidelines for Importing Data Importing Your Data User Fields

Publicado em Agosto 2022 | Copyright © 2005, 2022, Oracle e/ou respetivas associadas. Legal Notices.