Oracle Data Loader On Demand Guide > Sample Files >

Sample Map File


The following sample map file is for account objects:

"Oracle CRM On Demand Field","Import File Field"

"ZText_33","Owner_Full_Name"

"Indexed Boolean 0","IndexedBoolean0"

"Public Company","PublicCompany"

"Account Industry - Translation","Industry"

"ZText_32","Row_Id"

"Annual Revenues","Annual Revenues"

"Account Status","Status"

"Indexed Number 0","IndexedNumbr0"

"ZPhone_0","Custom_Phone_0"

"Indexed Long Text 0","IndexedLongText0"

"ZText_30","Primary_Contact"

"ZText_0","Custom_Text_Long_0"

"Bill To City","Bill City"

"Main Phone Number","Main Phone #"

"ZNum_20","Custom_Percent_0"

"ZNum_0","Custom_Number_0"

"ZDate_25","Custom_Date_0"

"Currency Code","Account Currency"

"ZText_1","Modified_by_Email_Address"

"Bill To Country","Bill Country"

"ZDate_0","Custom_DateTime_0"

"ZText_31","Indexed_Short_Text_1"

"Ship To Postal Code","Ship PostalCode"

"ZCur_0","Custom_Currency_0"

"External System Id","Unique External ID"

"Indexed Currency 0","IndexedCurrency0"

"ZMSPick_0","Custom_MultiSelect_Picklist_0"

"Indexed Pick 0","IndexedPick0"

"Ship To Street Address 2","Ship StreetAddress2"

"Type","Account Type"

"Ship To Country","Ship Country"

"Bill To Street Address","Bill StreetAddress"

"Number of Employees","Number of Employees"

"Home Page","Web Site"

"Ship To Street Address","Ship StreetAddress"

"Bill To Postal Code","Bill PostalCode"

"Source Code","Custom_Integer_0"

"Number of Physicians","NumberOfPhysicians"

"Main Fax Number","Main Fax #"

"ZText_34","Custom_Text_Short_0"

"Bill To Street Address 2","Bill treetAddress2"

"Priority","Priority"

"Location","Location"

"ZPick_0","Custom_Picklist_0"

"Description","Description"

"Region","Region"

"Name","Account Name"

"ZBool_0","Custom_Checkbox_0"

"Ship To City","Ship City"

Oracle Data Loader On Demand Guide, Release 37 Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.