eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Lookup Type: CSV_INTERFACE_FIELDS

Product:	IMC - Customers Online
Meaning:	List of attributes that can be mapped for CSV load
Description:	Target Attributes that will be mapped against the Source Attributes

Quick Codes

Code	Meaning	Description
ADDRESS1	Address 1	Address 1
ADDRESS2	Address 2	Address 2
ADDRESS3	Address 3	Address 3
ADDRESS4	Address 4	Address 4
ADDRESS_LINES_PHONETIC	Address Pronuncitaion	Address Pronuncitaion
ANALYSIS_FY	Analysis Fiscal Year	Analysis Fiscal Year
BRANCH_FLAG	Branch Flag	Branch Flag
BUSINESS_SCOPE	Business Scope	Business Scope
CEO_NAME	Chief Executive Name	Chief Executive Name
CEO_TITLE	Chief Executive Title	Chief Executive Title
CITY	City	City
CLASS_CATEGORY	Classification Type	Classification Type
CLASS_CODE	Classification Code	Classification Code
CONTACT_POINT_PURPOSE	Contact Point Purpose	Contact Point Purpose
CONTACT_POINT_TYPE	Contact Method Type	Contact Method Type
CONTROL_YR	Control Year	Control Year
COUNTRY	Country	Country
COUNTY	County	County
DATE_OF_BIRTH	Date Of Birth	Date Of Birth
DATE_OF_DEATH	Date Of Death	Date Of Death
DECLARED_ETHNICITY	Declared Ethnicity	Declared Ethnicity
DESCRIPTION	Description	Description
DUNS_NUMBER_C	DUNS Number	DUNS Number
EMAIL_ADDRESS	Email Address	Email Address
EMAIL_FORMAT	Email Format	Email Format
EMPLOYEES_TOTAL	Total Number of Employees	Total Number of Employees
FISCAL_YEAREND_MONTH	Fiscal Year End Month	Fiscal Year End Month
GENDER	Gender	Gender
GSA_INDICATOR_FLAG	GSA Indicator	GSA Indicator
HOUSEHOLD_INCOME	Household Income	Household Income
HOUSEHOLD_SIZE	Household Size	Household Size
HQ_BRANCH_IND	Location Type	Location Type
INCORP_YEAR	Incorporation Year	Incorporation Year
JGZZ_FISCAL_CODE	Income Taxpayer ID	Income Taxpayer ID
KNOWN_AS	Alias	Alias
LANGUAGE	Language Used at the Party Site	Language Used at the Party Site
LEGAL_STATUS	Legal Status	Legal Status
LOCAL_BUS_IDENTIFIER	Local Business Identifier	Local Business Identifier
LOCAL_BUS_IDEN_TYPE	Local Business Identifier Type	Local Business Identifier Type
LOCAL_DIRECTIONS	Local Directions	Local Directions
MARITAL_STATUS	Marital Status	Marital Status
MARITAL_STATUS_EFFECTIVE_DATE	Marital Status Effective Date	Marital Status Effective Date
MISSION_STATEMENT	Mission Statement	Mission Statement
NEXT_FY_POTENTIAL_REVENUE	Potential Revenue	Potential Revenue
OOB_IND	Out Of Business Indicator	Out Of Business Indicator
ORGANIZATION_NAME	Organization Name	Organization Name
ORGANIZATION_TYPE	Organization Type	Organization Type
PARENT_SUB_IND	Parent/Subsidiary Indicator	Parent/Subsidiary Indicator
PARTY_SITE_NAME	Party Site Name	Party Site Name
PERSONAL_INCOME	Personal Income	Personal Income
PERSON_ACADEMIC_TITLE	Academic Title	Academic Title
PERSON_FIRST_NAME	First Name	First Name
PERSON_FIRST_NAME_PHONETIC	First Name Pronunciation	First Name Pronunciation
PERSON_IDENTIFIER	Personal Identification Number	Personal Identification Number
PERSON_IDEN_TYPE	Personal Identifier Type	Personal Identifier Type
PERSON_INITIALS	Name Initials	Name Initials
PERSON_LAST_NAME	Last Name	Last Name
PERSON_LAST_NAME_PHONETIC	Last Name Pronunciation	Last Name Pronunciation
PERSON_MIDDLE_NAME	Middle Name	Middle Name
PERSON_MIDDLE_NAME_PHONETIC	Middle Name Pronunciation	Middle Name Pronunciation
PERSON_NAME_PHONETIC	Full Name Pronunciation	Full Name Pronunciation
PERSON_NAME_SUFFIX	Name Suffix	Name Suffix
PERSON_PREVIOUS_LAST_NAME	Previous Last Name	Previous Last Name
PERSON_PRE_NAME_ADJUNCT	Name Prefix	Name Prefix
PERSON_TITLE	Person Title	Person Title
PHONE_AREA_CODE	Telephone Area Code	Telephone Area Code
PHONE_COUNTRY_CODE	Telephone Country Code	Telephone Country Code
PHONE_EXTENSION	Telephone Number Extension	Telephone Number Extension
PHONE_LINE_TYPE	Telephone Line Type	Telephone Line Type
PHONE_NUMBER	Telephone Number	Telephone Number
PLACE_OF_BIRTH	Place Of Birth	Place Of Birth
POSTAL_CODE	Postal Code	Postal Code
PO_BOX_NUMBER	PO Box Number	PO Box Number
PREF_FUNCTIONAL_CURRENCY	Preferred Currency	Preferred Currency
PRIMARY_FLAG	Primary Address Flag	Primary Address Flag
PRINCIPAL_NAME	Principal Name	Principal Name
PRINCIPAL_TITLE	Principal Title	Principal Title
PROVINCE	Province	Province
PUBLIC_PRIVATE_OWNERSHIP_FLAG	Publicly or Privately Held	Publicly or Privately Held
RAW_PHONE_NUMBER	Full Phone Number	Full Phone Number
REGISTRATION_TYPE	Registration Type	Registration Type
RENT_OWN_IND	Rent/Own	Rent/Own
SALES_TAX_GEOCODE	US Tax Jurisdiction Code	US Tax Jurisdiction Code
STATE	State	State
TAX_REFERENCE	Tax Registration Number	Tax Registration Number
TELEX_NUMBER	Telex Number	Telex Number
TOTAL_PAYMENTS	Total Payment Experiences	Total Payment Experiences
URL	URL	URL
WEB_TYPE	Internet Protocol	Internet Protocol
YEAR_ESTABLISHED	Year Established	Year Established