This appendix covers the following topics:
The following sections describe the fields which can be used in list import. There are four sections B2B List Import, B2C List Import, Event Import and Lead Import.
Field in Import File | Data Type | Table Name | Import Requires Entry | Column Name |
ADDRESS LINES PHONETIC | VARCHAR2(150) | HZ_LOCATIONS | No | ADDRESS LINES PHONETIC |
ADDRESS1 | VARCHAR2(150) | HZ_LOCATIONS | No | ADDRESS1 |
ADDRESS2 | VARCHAR2(150) | HZ_LOCATIONS | No | ADDRESS2 |
ADDRESS3 | VARCHAR2(150) | HZ_LOCATIONS | No | ADDRESS3 |
ADDRESS4 | VARCHAR2(150) | HZ_LOCATIONS | No | ADDRESS4 |
ANALYSIS_FY | VARCHAR2 | HZ_ORGANIZATION_PROFILES | No | ANALYSIS_FY |
CATEGORY CODE | VARCHAR2 | HZ_PARTIES | No | CATEGORY CODE |
CEO NAME | VARCHAR2(50) | HZ_ORGANIZATION_PROFILES | No | CEO NAME |
CITY | VARCHAR2(60) | HZ_LOCATIONS | No | CITY |
COUNTRY | VARCHAR2(60) | HZ_LOCATIONS | No | COUNTRY |
COUNTY | VARCHAR2(60) | HZ_LOCATIONS | No | - |
'COUNTRY' | - | - | - | - |
CREATED BY | NUMBER | HZ_PARTIES | No | CREATED BY |
CREATION DATE | DATE | HZ_PARTIES | No | CREATION DATE |
CURR FY POTENTIAL REVENUE | NUMBER | HZ_ORGANIZATION_PROFILES | No | CURR FY POTENTIAL REVENUE |
DECISION MAKER FLAG | VARCHAR2(1) | HZ_ORG_CONTACTS | No | DECISION MAKER FLAG |
DEDUPE KEY | VARCHAR2(150) | HZ_PARTIES | No | DEDUPE KEY |
DEPARTMENT | VARCHAR2(60) | HZ_ORG_CONTACTS | No | DEPARTMENT |
DUNS NUMBER | NUMBER | HZ_ORGANIZATION_PROFILES | No | DUNS NUMBER |
EMAIL ADDRESS | VARCHAR2(150) | HZ_CONTACT_POINTS | No | EMAIL ADDRESS |
EMPLOYEES TOTAL | NUMBER | HZ_ORGANIZATION_PROFILES | No | EMPLOYEES TOTAL |
FISCAL YEAREND MONTH | VARCHAR2(30) | HZ_PARTIES | No | FISCAL YEAREND MONTH |
FLOOR | VARCHAR2 | HZ_LOCATIONS | No | FLOOR |
GSA INDICATOR FLAG | VARCHAR2 | HZ_PARTIES | No | GSA INDICATOR FLAG |
HOUSE NUMBER | VARCHAR2 | HZ_LOCATIONS | No | HOUSE NUMBER |
IMPORT LIST HEADER ID | NUMBER | AMS_IMP_SOURCE_LINES | No | IMPORT LIST HEADER ID |
IMPORT SOURCE LINE ID | NUMBER | AMS_IMP_SOURCE_LINES | No | IMPORT SOURCE LINE ID |
JGZZ FISCAL CODE | VARCHAR2 | HZ_PARTIES | No | JGZZ FISCAL CODE |
JOB TITLE | VARCHAR2(60) | HZ_ORG_CONTACTS | No | JOB TITLE |
LAST UPDATE DATE | DATE | AMS_IMP_SOURCE_LINES | No | LAST UPDATE DATE |
LAST UPDATE LOGIN | NUMBER | AMS_IMP_SOURCE_LINES | No | LAST UPDATE LOGIN |
LAST UPDATED BY | NUMBER | AMS_IMP_SOURCE_LINES | No | LAST UPDATED BY |
LEGAL STATUS | VARCHAR2(30) | HZ_PARTIES | No | LEGAL STATUS |
LINE OF BUSINESS | VARCHAR2(30) | HZ_PARTIES | No | LINE OF BUSINESS |
MISSING STATEMENT | VARCHAR2 | HZ_PARTIES | No | MISSING STATEMENT |
NEXT FY POTENTIAL REVENUE | NUMBER | HZ_PARTIES | No | NEXT FY POTENTIAL REVENUE |
NOTES | VARCHAR2(4000) | AMS_IMP_SOURCE_LINES | No | NOTES |
ORGANIZATION NAME PHONETIC | VARCHAR2 | HZ_PARTIES | No | ORGANIZATION NAME PHONETIC |
PARTY NAME | VARCHAR2(150) | HZ_PARTIES | Yes | PARTY NAME |
PERSON FIRST NAME | VARCHAR2(150) | HZ_PARTIES | No | PERSON FIRST NAME |
PERSON LAST NAME | VARCHAR2(150) | HZ_PARTIES | No | PERSON LAST NAME |
PERSON MIDDLE NAME | VARCHAR2(60) | HZ_PARTIES | No | PERSON MIDDLE NAME |
PERSON NAME SUFFIX | VARCHAR2(30) | HZ_PARTIES | No | PERSON NAME SUFFIX |
PERSON TITLE | VARCHAR2(60) | HZ_PARTIES | No | PERSON TITLE |
PHONE AREA CODE | VARCHAR2(10) | HZ_CONTACT_POINTS | No | PHONE AREA CODE |
PHONE COUNTRY CODE | VARCHAR2(10) | HZ_CONTACT_POINTS | No | PHONE COUNTRY CODE |
PHONE EXTENTION | VARCHAR2(20) | HZ_CONTACT_POINTS | No | PHONE EXTENTION |
PHONE NUMBER | VARCHAR2(40) | HZ_CONTACT_POINTS | No | PHONE NUMBER |
PO BOX NUMBER | - | HZ_LOCATIONS | No | PO BOX NUMBER |
POSTAL CODE | VARCHAR2(60) | HZ_LOCATIONS | No | POSTAL CODE |
POSTAL PLUS4 CODE | - | HZ_LOCATIONS | No | POSTAL PLUS4 CODE |
PROVINCE | VARCHAR2(60) | HZ_LOCATIONS | No | PROVINCE |
SALES AGENT LOGIN ID | VARCHAR2(2000) | AMS_IMP_SOURCE_LINES | No | SALES AGENT LOGIN ID |
SIC CODE | VARCHAR2 | HZ_ORGANIZATION_PROFILES | No | SIC CODE |
SIC CODE TYPE | VARCHAR2 | HZ_ORGANIZATION_PROFILES | No | SIC CODE TYPE |
SITE USE TYPE | VARCHAR2 | HZ_ORGANIZATION_PROFILES | No | SITE USE TYPE |
STATE | VARCHAR2(60) | HZ_LOCATIONS | No | STATE |
STATE | ||||
STREET | VARCHAR2 | HZ_LOCATIONS | No | STREET |
STREET NUMBER | VARCHAR2 | HZ_LOCATIONS | No | STREET NUMBER |
STREET SUFFIX | VARCHAR2 | HZ_LOCATIONS | No | STREET SUFFIX |
SUITE | VARCHAR2 | HZ_LOCATIONS | No | SUITE |
TAX REFERENCE | VARCHAR2(50) | HZ_PARTIES | No | TAX REFERENCE |
VEHICLE REPONSE CODE | VARCHAR2(30) | AMS_IMP_SOURCE_LINES | No | VEHICLE REPONSE CODE |
YEAR ESTABLISHED | NUMBER(4) | HZ_PARTIES | No | YEAR ESTABLISHED |
ADDRESS EFFECTIVE DATE | DATE | HZ_LOCATIONS | - | ADDRESS EFFECTIVE DATE |
ADDRESS EXPIRATION DATE | DATE | HZ_LOCATIONS | - | ADDRESS EXPIRATION DATE |
BRANCH FLAG | VARCHAR | HZ_ORGANIZATION_PROFILES | - | BRANCH FLAG |
BUSINESS LINE | VARCHAR | HZ_ORGANIZATION_PROFILES | - | BUSINESS LINE |
BUSINESS SCOPE | VARCHAR | HZ_ORGANIZATION_PROFILES | - | BUSINESS SCOPE |
CHIEF EXECUTIVE TITLE | VARCHAR | HZ_ORGANIZATION_PROFILES | - | CHIEF EXECUTIVE TITLE |
CONGRESSIONAL DISTRICT CODE | VARCHAR | HZ_ORGANIZATION_PROFILES | - | CONGRESSIONAL DISTRICT CODE |
CONTROL YEAR | NUMBER | HZ_ORGANIZATION_PROFILES | - | CONTROL YEAR |
CORPORATION CLASS | VARCHAR | HZ_ORGANIZATION_PROFILES | - | CORPORATION CLASS |
CREDIT SCORE | VARCHAR | HZ_ORGANIZATION_PROFILES | - | CREDIT SCORE |
CREDIT SCORE COMMENTARY | VARCHAR | HZ_ORGANIZATION_PROFILES | - | CREDIT SCORE COMMENTARY |
DB RATING | VARCHAR | HZ_ORGANIZATION_PROFILES | - | DB RATING |
DATE OF BIRTH | DATE | HZ_PERSON_PROFILES | - | DATE OF BIRTH |
DATE OF DEATH | DATE | HZ_PERSON_PROFILES | - | DATE OF DEATH |
DEBARMENTS COUNT | NUMBER | HZ_ORGANIZATION_PROFILES | - | DEBARMENTS COUNT |
DEBARTMENTS DATE | DATE | HZ_ORGANIZATION_PROFILES | - | DEBARTMENTS DATE |
DECLARED ETHNICITY | VARCHAR | HZ_PERSON_PROFILES | - | DECLARED ETHNICITY |
DEBARTMENT INDICATOR | VARCHAR | HZ_ORGANIZATION_PROFILES | - | DEBARTMENT INDICATOR |
DESCRIPTION | VARCHAR | HZ_LOCATIONS | - | DESCRIPTION |
DISADVANTAGED INDICATOR | VARCHAR | HZ_ORGANIZATION_PROFILES | - | DISADVANTAGED INDICATOR |
ENQUIRY DUNS | VARCHAR | HZ_ORGANIZATION_PROFILES | - | ENQUIRY DUNS |
EXPORT INDICATOR | VARCHAR | HZ_ORGANIZATION_PROFILES | - | EXPORT INDICATOR |
FAILURE SCORE | VARCHAR | HZ_ORGANIZATION_PROFILES | - | FAILURE SCORE |
FAILURE SCORE COMMENTARY | VARCHAR | HZ_ORGANIZATION_PROFILES | - | FAILURE SCORE COMMENTARY |
FAILURE SCORE NATL PERCENTILE | VARCHAR | HZ_ORGANIZATION_PROFILES | - | FAILURE SCORE NATL PERCENTILE |
FAILURE SCORE OVERRIDE CODE | VARCHAR | HZ_ORGANIZATION_PROFILES | - | FAILURE SCORE OVERRIDE CODE |
FISCAL CODE | VARCHAR | HZ_PARTIES | - | FISCAL CODE |
GLOBAL FAILURE SCORE | VARCHAR | HZ_ORGANIZATION_PROFILES | - | GLOBAL FAILURE SCORE |
HEADQUARTER BRANCH INDICATOR | VARCHAR | HZ_ORGANIZATION_PROFILES | - | HEADQUARTER BRANCH INDICATOR |
HEAD OF HOUSEHOLD FLAG | VARCHAR | HZ_PERSON_PROFILES | - | HEAD OF HOUSEHOLD FLAG |
HOUSEHOLD SIZE | VARCHAR | HZ_PERSON_PROFILES | - | HOUSEHOLD SIZE |
IMPORT INDICATOR | VARCHAR | HZ_ORGANIZATION_PROFILES | - | IMPORT INDICATOR |
ORGANIZATION KNOWN AS | VARCHAR | HZ_PARTIES | - | ORGANIZATION KNOWN AS |
ORGANIZATION KNOWN AS2 | VARCHAR | HZ_PARTIES | - | ORGANIZATION KNOWN AS2 |
ORGANIZATION KNOWN AS3 | VARCHAR | HZ_PARTIES | - | ORGANIZATION KNOWN AS3 |
ORGANIZATION KNOWN AS4 | VARCHAR | HZ_PARTIES | - | ORGANIZATION KNOWN AS4 |
ORGANIZATION KNOWN AS5 | VARCHAR | HZ_PARTIES | - | ORGANIZATION KNOWN AS5 |
PERSON KNOWN AS | VARCHAR | HZ_PARTIES | - | PERSON KNOWN AS |
PERSON KNOWN AS2 | VARCHAR | HZ_PARTIES | - | PERSON KNOWN AS2 |
PERSON KNOWN AS3 | VARCHAR | HZ_PARTIES | - | PERSON KNOWN AS3 |
PERSON KNOWN AS4 | VARCHAR | HZ_PARTIES | - | PERSON KNOWN AS4 |
PERSON KNOWN AS5 | VARCHAR | HZ_PARTIES | - | PERSON KNOWN AS5 |
LABOR SURPLUS INDICATOR | VARCHAR | HZ_ORGANIZATION_PROFILES | - | LABOR SURPLUS INDICATOR |
LOCAL ACTIVITY CODE | VARCHAR | HZ_ORGANIZATION_PROFILES | - | LOCAL ACTIVITY CODE |
LOCAL ACTIVITY CODE TYPE | VARCHAR | HZ_ORGANIZATION_PROFILES | - | LOCAL ACTIVITY CODE TYPE |
LOCATION DIRECTIONS | VARCHAR | HZ_LOCATIONS | - | LOCATION DIRECTIONS |
LOCATION STATUS | VARCHAR | HZ_LOCATIONS | - | LOCATION STATUS |
MARITAL STATUS | VARCHAR | HZ_PERSON_PROFILES | - | MARITAL STATUS |
MARITAL STATUS EFFECTIVE DATE | DATE | HZ_PERSON_PROFILES | - | MARITAL STATUS EFFECTIVE DATE |
MINORITY OWNED INDICATOR | VARCHAR | HZ_ORGANIZATION_PROFILES | - | MINORITY OWNED INDICATOR |
MINORITY OWNED TYPE | VARCHAR | HZ_ORGANIZATION_PROFILES | - | MINORITY OWNED TYPE |
ORGANIZATION ALIAS | VARCHAR | HZ_PARTIES | - | ORGANIZATION ALIAS |
ORGANIZATION TYPE | VARCHAR | HZ_PARTIES | - | ORGANIZATION TYPE |
ORGANIZATION URL | VARCHAR | HZ_PARTIES | - | ORGANIZATION URL |
OUT OF BUSINESS INDICATOR | VARCHAR | HZ_ORGANIZATION_PROFILES | - | OUT OF BUSINESS INDICATOR |
PERSONAL INCOME | NUMBER | HZ_PERSON_PROFILES | - | PERSONAL INCOME |
PERSON ACADEMIC TITLE | VARCHAR | HZ_PERSON_PROFILES | - | PERSON ACADEMIC TITLE |
PERSON FIRST NAME PHONETIC | VARCHAR | HZ_PARTIES | - | PERSON FIRST NAME PHONETIC |
PERSON LAST NAME PHONETIC | VARCHAR | HZ_PARTIES | - | PERSON LAST NAME PHONETIC |
MIDDLE NAME PHONETIC | VARCHAR | HZ_PARTIES | - | MIDDLE NAME PHONETIC |
PERSON NAME PHONETIC | VARCHAR | HZ_PARTIES | - | PERSON NAME PHONETIC |
PERSON PREVIOUS TITLE NAME | VARCHAR | HZ_PARTIES | - | PERSON PREVIOUS TITLE NAME |
PLACE OF BIRTH | VARCHAR | HZ_PERSON_PROFILES | - | PLACE OF BIRTH |
PRINCIPAL NAME | VARCHAR | HZ_ORGANIZATION_PROFILES | - | PRINCIPAL NAME |
PRINCIPAL TITLE | VARCHAR | HZ_ORGANIZATION_PROFILES | - | PRINCIPAL TITLE |
PUBLIC PRIVATE OWNERSHIP FLAG | VARCHAR | HZ_ORGANIZATION_PROFILES | - | OWNERSHIP FLAG |
RENT OWNED INDICATOR | VARCHAR | HZ_PERSON_PROFILES | - | RENT OWNED INDICATOR |
SECOND TITLE | VARCHAR | HZ_PERSON_PROFILES | - | PERSON ACADEMIC TITLE |
SHORT DESCRIPTION | VARCHAR | HZ_LOCATIONS | - | SHORT DESCRIPTION |
SMALL BUSINESS INDICATOR | VARCHAR | HZ_ORGANIZATION_PROFILES | - | SMALL BUSINESS INDICATOR |
TAX ID | VARCHAR | HZ_PERSON_PROFILES | - | TAX REFERENCE |
WOMAN OWNED INDICATOR | VARCHAR | HZ_ORGANIZATION_PROFILES | - | WOMAN OWNED INDICATOR |
ORGANIZATION ATTRIBUTE 1 - 15 | VARCHAR | HZ_ORGANIZATION_PROFILES | - | ATTRIBUTE 1-15 |
ORG CONTACT ATTRIBUTE 1-15 | VARCHAR | HZ_ORG_CONTACTS | - | ATTRIBUTE 1-15 |
ADDRESS ATTRIBUTE1-15 | VARCHAR | HZ_LOCATIONS | - | ATTRIBUTE1-15 |
FAX COUNTRY CODE | VARCHAR | HZ_CONTACT_POINTS | - | FAX COUNTRY CODE |
FAX AREA CODE | VARCHAR | HZ_CONTACT_POINTS | - | FAX AREA CODE |
FAX NUMBER | VARCHAR | HZ_CONTACT_POINTS | - | FAX NUMBER |
ORG ATTRIBUTE CATEGORY | VARCHAR | HZ_ORGANIZATION_PROFILES | - | ORG ATTRIBUTE CATEGORY |
ORG CONTACT ATTRIBUTE CATEGORY | VARCHAR | HZ_ORG_CONTACTS | - | ORG CONTACT ATTRIBUTE CATEGORY |
ADDRESS ATTRIBUTE CATEGORY | VARCHAR | HZ_LOCATIONS | - | ADDRESS ATTRIBUTE CATEGORY |
PARTY SITE USE | VARCHAR | HZ_PARTY_SITE_USES | - | PARTY SITE USE |
ORIGINAL SYSTEM REFERENCE | VARCHAR | HZ_PARTIES | - | ORIG SYSTEM REFERENCE |
The following table indicates B2C List Import Fields.
Table Column / Field in Import File | Data Type | Table Requires Entry | Import Requires Entry | Valid Values | Comments |
---|---|---|---|---|---|
ADDRESS_LINES_PHONETIC | VARCHAR2 | No | No | - | - |
ADDRESS1 | VARCHAR2(150) | No | No | - | Required every time if address is required. |
ADDRESS2 | VARCHAR2(150) | No | No | - | - |
ADDRESS3 | VARCHAR2 | No | No | - | - |
ADDRESS4 | VARCHAR2 | No | No | - | - |
CITY | VARCHAR2(60) | No | No | Select distinct location_segment_description, location_segment_user_value from ar_location_values where location_segment_qualifier = ‘CITY' |
- |
COUNTRY | VARCHAR2(60) | No | No | Select territory_short_name, territory_code, description from fnd_territories_vl | Required only if any of address columns are provided in the data file. |
COUNTY | VARCHAR2(60) | No | No | Select distinct location_segment_description, location_segment_user_value from ar_location_values where location_segment_qualifier = ‘COUNTRY' |
- |
CREATED_BY | NUMBER | Yes | No | - | Populated by the list import program. |
CREATION_DATE | DATE | Yes | No | - | Populated by the list import program. |
DEDUPE_KEY | VARCHAR2(150) | No | No | - | Populated by the list import program. |
EMAIL_ADDRESS | VARCHAR2(150) | No | No | - | - |
FLOOR | No | No | - | - | |
GENDER | VARCHAR2(30) | No | No | - | - |
HOUSE_NUMBER | No | No | - | - | |
HOUSEHOLD_INCOME | NUMBER | No | No | - | - |
IMPORT_LIST_HEADER_ID | NUMBER | Yes | No | - | Auto Generated |
IMPORT_SOURCE_LINE_ID | NUMBER | Yes | No | - | Auto Generated |
IMPORT_SUCCESSFUL_FLAG | VARCHAR2(1) | No | No | - | |
LAST_UPDATE_DATE | DATE | Yes | No | - | Populated by the list import program. |
LAST_UPDATE_LOGIN | NUMBER | Yes | No | - | Populated by the list import program. |
LAST_UPDATED_BY | NUMBER | Yes | No | - | Populated by the list import program. |
NOTES | VARCHAR2(4000) | No | No | - | - |
OBJECT_VERSION_NUMBER | NUMBER | Yes | No | - | Populated by the list import program. |
PERSON_FIRST_NAME | VARCHAR2(150) | No | Yes | - | This is a required column in the data file for B2C type of data |
PERSON_LAST_NAME | VARCHAR2(150) | No | Yes | - | This is a required column in the data file for B2C type of data |
PERSON_MIDDLE_NAME | VARCHAR2(60) | No | No | - | - |
PERSON_NAME_SUFFIX | VARCHAR2(30) | No | No | - | - |
PERSON_PRE_NAME_ADJUNCT | No | No | - | - | |
PERSON_TITLE | VARCHAR2(60) | No | No | - | - |
PHONE_AREA_CODE | VARCHAR2(10) | No | No | - | - |
PHONE_COUNTRY_CODE | VARCHAR2(10) | No | No | - | - |
PHONE_EXTENTION | VARCHAR2(20) | No | No | - | - |
PHONE_NUMBER | VARCHAR2(40) | No | No | - | Required if any of the phone information is provided. |
PO_BOX_NUMBER | VARCHAR2 | No | No | - | - |
POSTAL_CODE | VARCHAR2(60) | No | No | Select min(p.from_postal_code), Max(p.to_postal_code) from Ar_postal_code_ranges_v p, Ar_location_values a where p.location_segment_id = a.location_segment_id and a.location_segment_qualifier = ‘CITY' and a.location_segment_value like ‘X%' |
- |
POSTAL_PLUS4_CODE | No | No | - | - | |
PROVINCE | VARCHAR2(60) | No | No | Select distinct location_segment_description, location_segment_user_value from ar_location_values where location_segment_qualifier = ‘PROVINCE' |
- |
SALES_AGENT_LOGIN_ID | VARCHAR2(2000) | No | No | - | - |
SALUTATION | VARCHAR2 | No | No | - | - |
SITE_USE_TYPE | VARCHAR2 | No | No | - | - |
STATE | VARCHAR2(60) | No | No | Select distinct location_segment_description, location_segment_user_value from ar_location_values where location_segment_qualifier = ‘STATE' |
- |
STREET | VARCHAR2 | No | No | - | - |
STREET_NUMBER | VARCHAR2 | No | No | - | - |
STREET_SUFFIX | VARCHAR2 | No | No | - | - |
SUITE | VARCHAR2 | No | No | - | - |
VEHICLE_RESPONSE_CODE | VARCHAR2(30) | No | No | - | Based on lookup AMS_Vehicle_Response_Code |
Following table shows the mapping for Event registration import. Note that only Event Source code is a required field. But many other fields are conditionally required.
If the Party ID and Contact ID are provided in the csv file, the import will not create party but will use the ids provided in the csv and register them.
If the Party ID and Contact ID are not provided, then registrant first name, last name and email address are required as the import program will use those fields to create the party and register them. If the Attendant first name, last name and email address are not provided in the csv file, the import program will use the details from the registrant fields for attendant information.
Table Column / Field in Import File | Data Type | Valid Values | Comments | Table Name | Column Name |
---|---|---|---|---|---|
EVENT_SOURCE_CODE/ Event Source Code Table Entry Required: Yes Import Entry Required: Yes |
VARCHAR2 (100) | Source code for Event - how the Event being registered for is identified. | ams_Event_registrations | SOURCE_CODE | |
REGISTRATION_SOURCE_TYPE/ Registration Source Type | VARCHAR2(30) | Lookup AMS_EVENT_REG_SOURCE | How the party registered for the Event (Web, phone, etc.). | ams_Event_registrations | REG_SOURCE_TYPE_CODE |
ATTENDANCE_FLAG/ Attendance Flag | VARCHAR2(1) | Y/N | Whether or not the party has attended the Event. | ams_Event_registrations | ATTENDED_FLAG |
WAITLISTED_FLAG/ Waitlisted Flag | VARCHAR2(1) | Y/N | Whether or not to force the system to waitlist the party or not waitlist the party. If null, the system will waitlist if registrations are full. | ams_Event_registrations | SYSTEM_STATUS_CODE (If the waitlisted_flag is "Y" then registration status will be Waitlisted). |
CANCELLATION_FLAG/ Cancellation Flag | VARCHAR2(1) | Y/N | Whether or not to cancel the party's registration. | ams_Event_registrations | SYSTEM_STATUS_CODE (If the cancellation flag is "Y" then registration status will be cancelled). |
CANCELLATION REASON_CODE/ Cancellation Reason | VARCHAR2(30) | Lookup AMS_EVNT_REG_CANCEL_REASON | The reason for cancellation. | ams_Event_registrations | CANCELLATION_REASON_CODE |
CONFIRMATION_CODE/ Confirmation Code | VARCHAR2(30) | - | This code will uniquely identify any registration. | ams_Event_registrations | CONFIRMATION_CODE |
ORIGINAL_SYSTEM_REFERENCE/ Original System Reference | VARCHAR2 (240) | - | The original system reference of the registration | hz_parties | ORG_SYSTEM_REFERENCE |
REG_PARTY_ID/ Registrant Party ID Table Entry Required: Yes |
NUMBER | - | The party id corresponding to the registrant (B2C) or the registrant's company (B2B). | hz_parties | PARTY_ID |
REG_PARTY_TYPE/ Registrant Party Type | VARCHAR2(30) | Fnd_Lookups_Party_Type | The Party Type of the registrant's company | hz_parties | PARTY_TYPE |
REG_CONTACT_ID/ Registrant Contact ID Table Entry Required: Yes |
NUMBER | - | The party ID corresponding to the registrant | hz_parties | PARTY_ID |
REG_PARTY_NAME/ Registrant Party Name | VARCHAR2 (360) | - | The name of the registrant's company (forces B2B). | hz_parties | PARTY_NAME |
REG_TITLE/ Registrant Title | VARCHAR2(30) | - | Title (Mr. Ms.) of the registrant | hz_org_contacts | TITLE |
REG_FIRST_NAME/ Registrant First Name Table Entry Required: Yes |
VARCHAR2 (150) | - | First Name of registrant | hz_parties | PERSON_FIRST_NAME |
REG_MIDDLE_NAME/ Registrant Middle Name | VARCHAR2(60) | - | Middle name of registrant | hz_parties | PERSON_MIDDLE NAME |
REG_LAST_NAME/ Registrant Last Name Table Entry Required: Yes |
VARCHAR2 (150) | - | Last Name of registrant | hz_parties | PERSON_LAST_NAME |
REG_ADDRESS1/ Registrant Address1 | VARCHAR2 (240)F | - | Address (first line) of the registrant | hz_parties | ADDRESS1 |
REG_ADDRESS2/ Registrant Address1 | VARCHAR2 (240)F | - | Address (second line) of the registrant | hz_parties | ADDRESS2 |
REG_ADDRESS3/ Registrant Address1 | VARCHAR2 (240)F | - | Address (third line) of the registrant | hz_parties | ADDRESS3 |
REG_ADDRESS4/ Registrant Address1 | VARCHAR2 (240)F | - | Address (fourth line) of the registrant | hz_parties | ADDRESS4 |
REG_GENDER/ Registrant Gender | VARCHAR2(30) | - | Gender of the registrant | hz_person_profiles | GENDER |
REG_ADDRESS_LINE_PHONETIC/ Registrant Address Line Phonetic | VARCHAR2 (360) | - | Phonetic address of the registrant | hz_locations | ADDRESS_LINES_PHONETIC |
REG_ANALYSIS_FY/ Registrant Analysis FY | VARCHAR2(5) | - | FY analysis for the registrant | hz_parties | ANALYSIS _FY |
REG_APT_FLAG/ Registrant Apt Flag | VARCHAR2(1) | - | Whether or not the registrant's address is an apartment | hz_locations | APARTMENT_FLAG |
REG_BEST_TIME_CONTACT_BEGIN/ Registrant Best Time Contact Begin | DATE | - | Best time to begin contacting the registrant | hz_person_profiles | BEST_TIME_CONTACT_BEGIN |
REG_BEST_TIME_CONTACT_END Registrant Best Time Contact End |
DATE | - | Best time to stop contacting the registrant | hz_person_profiles | BEST_TIME_CONTACT_END |
REG_CATEGORY_CODE/ Registrant Category Code | VARCHAR2(30) | - | Category code of the registrant | hz_parties | CATEGORY_CODE |
REG_CEO_NAME/ Registrant CEO Name | VARCHAR2 (360) | - | CEO of the registrant's company | hz_organization_profiles | CEO_NAME |
REG_CITY/ Registrant City | VARCHAR2(60) | - | City of the Registrant's Address | hz_parties | CITY |
REG_CONTACT_ME_FLAG/ Registrant Contact Me Flag | VARCHAR2(1) | Y/N | Whether or not it is OK to contact the registrant (Do or Do Not Contact) | hz_contact_preferences | PREFERENCE_CODE (if Contact_Type is ALL) |
REG_COUNTRY/ Registrant Country | VARCHAR2(60) | - | Country of the registrant's address This is mandatory only if any of the address columns are provided in the data file. |
hz_parties | COUNTRY |
REG_COUNTY/ Registrant County | VARCHAR2(60) | - | County of the registrant's address. Required only if any of the address columns are provided in the import data file. | hz_parties | COUNTY |
REG_CURRENT_FY_POTENTIAL_REV/ Registrant Current FY Potential Revenue | NUMBER | - | Current fiscal year potential revenue of the registrant's company | hz_parties | CURR_FY_POTENTIAL_REVENUE |
REG_NEXT_FY_POTANTIAL_REV/ Registrant Next FY Potential Revenue | NUMBER | - | Next fiscal year potential revenue of the registrant's company | hz_parties | NEXT_FY_POTENTIAL_REVENUE |
REG_HOUSEHOLD_INCOME/ Registrant Household Income | NUMBER | - | Household income of the registrant | hz_person_profiles | HOUSEHOLD_INCOME |
REG_DECISION_MAKER_FLAG/ Registrant Decision Maker Flag | VARCHAR2(1) | Y/N | Whether or not the registrant is a decision maker | hz_org_contacts | DECISION_MAKER_FLAG |
REG_DEPARTMENT/ Registrant Department | VARCHAR2 (360) | - | The registrant's company department | hz_org_contacts | DEPARTMENT |
REG_DUN_NO_C/ Registrant Dun No. | VARCHAR2(30) | - | The Duns Number of the registrant's company | hz_parties | DUNS_NUMBER |
REG_EMAIL_ADDRESS/ Registrant email address Table Entry Required: Yes |
VARCHAR2 (2000) | - | Email address of the registrant | hz_parties | EMAIL_ADDRESS |
REG_EMAIL_OK_FLAG/ Registrant Email OK Flag | VARCHAR2(1) | Y/N | Whether or not it is OK to email the registrant | hz_contact_preferences | PREFERENCE_CODE (if Contact_Type is EMAIL) |
REG_EMPLOYEE_TOTAL/ Registrant Employee Total | NUMBER | - | Employee total of the registrant's company | hz_parties | EMPLOYEES_TOTAL |
REG_FY_END_MONTH/ Registrant FY End Month | VARCHAR2(30) | - | The month in which the registrant's company's fiscal year ends | hz_parties | FISCAL_YEAREND_MONTH |
REG_FLOOR/ Registrant's Floor | VARCHAR2(50) | - | The floor (address) of the registrant | hz_locations | FLOOR |
REG_GSA_INDICATOR_FLAG/ Registrant GSA Indicator Flag | VARCHAR2(30) | - | The GSA Indicator Flag of the registrant's company | hz_parties | GSA_INDICATOR_FLAG |
REG_HOUSE_NUMBER/ Registrant House Number | NUMBER | - | The house number of the registrant's address | hz_locations | HOUSE_NUMBER |
REG_IDENTIFYING_ADDRESS_FLAG/ Registrant Identifying Address Flag | VARCHAR2(1) | Y/N | Whether or not this is the registrant's primary address | hz_party_sites | IDENTIFYING_ADDRESS_FLAG |
REG_JGZZ_FISCAL_CODE/ Registrant JGZZ FISCAL Code | VARCHAR2(20) | - | The JGZZ Fiscal Code of the registrant's company | hz_parties | JGZZ_FISCAL_CODE |
REG_JOB_TITLE/ Registrant Job Title | VARCHAR2 (100) | - | The job title of the registrant | hz_org_contacts | JOB_TITLE |
REG_LAST_ORDER_DATE/ Registrant Last Order Date | DATE | - | Deprecated | hz_parties | LAST_ORDERED_DATE |
REG_ORG_LEGAL_STATUS/ Registrant Org Legal Status | VARCHAR2(30) | - | The legal status of the registrant's company | hz_organization_profiles | LEGAL_STATUS |
REG_LINE_OF_BUSINESS/ Registrant Line of Business | VARCHAR2 (240) | - | The line of business with which the registrant is associated | hz_organization_profiles | LINE_OF_BUSINESS |
REG_MISSION_STATEMENT/ Registrant Mission Statement | VARCHAR2 (2000) | - | The mission statement for the registrant's company | hz_parties | MISSION_STATEMENT |
REG_ORG_NAME_PHONETIC/ Registrant Org Name Phonetic | VARCHAR2 (320) | - | The phonetic name of the registrant's company | hz_parties | ORGANIZATION_NAME_PHONETIC |
REG_OVERSEAS_ADDRESS_FLAG/ Registrant Overseas Address Flag | VARCHAR2(1) | Y/N | Whether or not the address is overseas | hz_locations | OVERSEAS_ADDRESS_FLAG |
REG_NAME_SUFFIX/ Registrant Name Suffix | VARCHAR2(30) | - | The suffix of the registrant (Jr., M.D., etc.) | hz_parties | PERSON_NAME_SUFFIIX |
REG_PHONE_AREA_CODE/ Registrant Phone Area Code | VARCHAR2(10) | - | The area code of the registrant's phone number | hz_contact_points | PHONE_AREA_CODE |
REG_PHONE_COUNTRY_CODE/ Registrant Phone Country Code | VARCHAR2(10) | - | The country code of the registrant's phone number | hz_contact_points | PHONE_COUNTRY_CODE |
REG_PHONE_EXTENSION/ Registrant Phone Extension | VARCHAR2(20) | - | The extension of the registrant's phone number | hz_contact_points | PHONE_EXTENSION |
REG_PHONE_NUMBER/ Registrant Phone Number | VARCHAR2(40) | - | The registrant's phone number | hz_contact_points | PHONE_NUMBER |
REG_POSTAL_CODE/ Registrant Postal Code | VARCHAR2(60) | - | The postal code of the registrant's address | hz_parties | POSTAL_CODE |
REG_POSTAL_PLUS4_CODE/ Registrant Postal plus4 Code | VARCHAR2(4) | - | The postal plus-four code of the registrant's address | hz_locations | POSTAL_PLUS4_CODE |
REG_PO_BOX_NO/ Registrant PO Box No | VARCHAR2(50) | - | The PO Box number of the registrant's address | hz_locations | PO_BOX_NUMBER |
REG_PROVINCE/ Registrant Province | VARCHAR2(60) | - | The province of the registrant's address | hz_locations, hz_parties | PROVINCE |
REG_RURAL_ROUTE_NO/ Registrant Rural Route No | VARCHAR2(50) | - | The rural route number of the registrant's address | hz_locations | RURAL_ROUTE_NUMBER |
REG_RURAL_ROUTE_TYPE / Registrant Rural Route Type | VARCHAR2(30) | - | The rural route type of the registrant's address | hz_locations | RURTAL_ROUTE_TYPE |
REG_SECONDARY_SUFFIX_ELEMENT/ Registrant Secondary Suffix Element | VARCHAR2(30) | - | The secondary suffix (such as Jr. or M.D.) of the registrant | hz_locations | SECONDARY_SUFFIX_ELEMENT |
REG_SIC_CODE/ Registrant SIC Code | VARCHAR2(30) | - | The SIC Code of the registrant's company | hz_parties | SIC_CODE |
REG_SIC_CODE_TYPE/ Registrant SIC Code Type | VARCHAR2(30) | - | The SIC Code Type of the registrant's company | hz_parties | SIC_CODE_TYPE |
REG_SITE_USE_CODE/ Registrant Site Use Code | VARCHAR2(30) | - | The site use code of the registrant's address | Not Used | Not Used |
REG_STATE/ Registrant State | VARCHAR2(60) | - | The state of the registrant's address | hz_locations, hz_parties | STATE |
REG_STREET/ Registrant Street | VARCHAR2(50) | - | The street of the registrant's address | hz_locations | STREET |
REG_STREET_NUMBER/ Registrant Street Number | VARCHAR2(50) | - | The street number of the registrant's address | hz_locations | STREET_NUMBER |
REG_STREET_SUFFIX/ Registrant Street Suffix | VARCHAR2(50) | - | The street suffix of the registrant's address | hz_locations | STREET_SUFFIX |
REG_SUITE/ Registrant Suite | VARCHAR2(50) | - | The suite of the registrant's address | hz_locations | SUITE |
REG_TAX_NAME/ Registrant Tax Name | VARCHAR2(30) | - | The tax name of the registrant's company | hz_parties | TAX_NAME |
REG_TAX_REFERENCE/ Registrant Tax Reference | VARCHAR2(50) | - | The tax reference of the registrant's company | hz_parties | TAX_REFERENCE |
REG_TIME_ZONE/ Registrant Time Zone | NUMBER | - | The timezone of the registrant's address | hz_locations | TIME_ZONE |
REG_TOTAL_NO_OF_ORDER/ Registrant Total Number of Orders | NUMBER | - | Deprecated | hz_parties | TOTAL_NUM_OF_ORDERS |
REG_TOTAL_ORDER_AMOUNT/ Registrant Total Order Amount | NUMBER | - | Deprecated | hz_parties | TOTAL_ORDERED_AMOUNT |
REG_YEAR_ESTABLISHED/ Registrant Year Established | NUMBER | - | The year the registrant's company was established | hz_parties | YEAR_ESTABLISHED |
REG_URL/ Registrant URL | VARCHAR2 (2000) | - | The URL of the registrant's company | hz_contact_points, hz_parties | URL |
ATT_PARTY_ID/ attendant Party ID Table Entry Required: Yes |
NUMBER | - | The party id corresponding to the attendant (B2C) or the attendant's company (B2B). | hz_parties | PARTY_ID |
ATT_PARTY_TYPE/ Attendant Party Type | VARCHAR2(30) | - | The Party Type of the attendant's company | hz_parties | PARTY_TYPE |
ATT_CONTACT_ID/ Attendant Contact ID Table Entry Required: Yes |
NUMBER | - | The party ID corresponding to the attendant | hz_parties | PARTY_ID |
ATT_PARTY_NAME/ Attendant Party Name | VARCHAR2 (360) | - | The name of the attendant's company (forces B2B). | hz_parties | PARTY_NAME |
ATT_TITLE/ Attendant Title | VARCHAR2(30) | - | Title (Mr. Ms.) of the attendant | hz_org_contacts | TITLE |
ATT_FIRST_NAME/ Attendant First Name Table Entry Required: Yes |
VARCHAR2 (150) | - | First Name of attendant | hz_parties | PERSON_FIRST_NAME |
ATT_MIDDLE_NAME/ Attendant Middle Name | VARCHAR2(60) | - | Middle name of attendant | hz_parties | PERSON_MIDDLE NAME |
ATT_LAST_NAME/ Attendant Last Name Table Entry Required: Yes |
VARCHAR2 (150) | - | Last Name of attendant | hz_parties | PERSON_LAST_NAME |
ATT_ADDRESS1/ Attendant Address1 | VARCHAR2 (240)F | - | Address (first line) of the attendant | hz_parties | ADDRESS1 |
ATT_ADDRESS2/ Attendant Address1 | VARCHAR2 (240)F | - | Address (second line) of the attendant | hz_parties | ADDRESS2 |
ATT_ADDRESS3/ Attendant Address1 | VARCHAR2 (240)F | - | Address (third line) of the attendant | hz_parties | ADDRESS3 |
ATT_ADDRESS4/ Attendant Address1 | VARCHAR2 (240)F | - | Address (fourth line) of the attendant | hz_parties | ADDRESS4 |
ATT_GENDER/ Attendant Gender | VARCHAR2(30) | - | Gender of the attendant | hz_person_profiles | GENDER |
ATT_ADDRESS_LINE_PHONETIC/ Attendant Address Line Phonetic | VARCHAR2 (360) | - | Phonetic address of the attendant | hz_locations | ADDRESS_LINES_PHONETIC |
ATT_ANALYSIS_FY/ Attendant Analysis FY | VARCHAR2(5) | - | FY analysis for the attendant | hz_parties | ANALYSIS _FY |
ATT_APT_FLAG/ Attendant Apt Flag | VARCHAR2(1) | Y/N | Whether or not the attendant's address is an apartment | hz_locations | APARTMENT_FLAG |
ATT_BEST_TIME_CONTACT_BEGIN/ Attendant Best Time Contact Begin | DATE | - | Best time to begin contacting the attendant | hz_person_profiles | BEST_TIME_CONTACT_BEGIN |
ATT_BEST_TIME_CONTACT_END Attendant Best Time Contact End |
DATE | - | Best time to stop contacting the attendant | hz_person_profiles | BEST_TIME_CONTACT_END |
ATT_CATEGORY_CODE/ Attendant Category Code | VARCHAR2(30) | - | Category code of the attendant | hz_parties | CATEGORY_CODE |
ATT_CEO_NAME/ Attendant CEO Name | VARCHAR2 (360) | - | CEO of the attendant's company | hz_organization_profiles | CEO_NAME |
ATT_CITY/ Attendant City | VARCHAR2(60) | - | City of the attendant's Address | hz_parties | CITY |
ATT_CONTACT_ME_FLAG/ Attendant Contact Me Flag | VARCHAR2(1) | Y/N | Whether or not it is OK to contact the attendant (Do or Do Not Contact) | hz_contact_preferences | PREFERENCE_CODE (if Contact_Type is ALL) |
ATT_COUNTRY/ Attendant Country | VARCHAR2(60) | - | Country of the attendant's address | hz_parties | COUNTRY |
ATT_COUNTY/ Attendant County | VARCHAR2(60) | - | County of the attendant's address | hz_parties | COUNTY |
ATT_CURRENT_FY_POTENTIAL_REV/ Attendant Current FY Potential Revenue | NUMBER | - | Current fiscal year potential revenue of the attendant's company | hz_parties | CURR_FY_POTENTIAL_REVENUE |
ATT_NEXT_FY_POTANTIAL_REV/ Attendant Next FY Potential Revenue | NUMBER | - | Next fiscal year potential revenue of the attendant's company | hz_parties | NEXT_FY_POTENTIAL_REVENUE |
ATT_HOUSEHOLD_INCOME/ Attendant Household Income | NUMBER | Household income of the attendant | hz_person_profiles | HOUSEHOLD_INCOME | |
ATT_DECISION_MAKER_FLAG/ Attendant Decision Maker Flag | VARCHAR2(1) | Y/N | Whether or not the attendant is a decision maker | hz_org_contacts | DECISION_MAKER_FLAG |
ATT_DEPARTMENT/ Attendant Department | VARCHAR2 (360) | - | The attendant's company department | hz_org_contacts | DEPARTMENT |
ATT_DUN_NO_C/ Attendant Dun No. | VARCHAR2(30) | - | The Duns Number of the attendant's company | hz_parties | DUNS_NUMBER |
ATT_EMAIL_ADDRESS/ Attendant email address Table Entry Required: Yes |
VARCHAR2 (2000) | - | Email address of the attendant | hz_parties | EMAIL_ADDRESS |
ATT_EMAIL_OK_FLAG/ Attendant Email OK Flag | VARCHAR2(1) | Y/N | Whether or not it is OK to email the attendant | hz_contact_preferences | PREFERENCE_CODE (if Contact_Type is EMAIL) |
ATT_EMPLOYEE_TOTAL/ Attendant Employee Total | NUMBER | - | Employee total of the attendant's company | hz_parties | EMPLOYEES_TOTAL |
ATT_FY_END_MONTH/ Attendant FY End Month | VARCHAR2(30) | - | The month in which the attendant's company's fiscal year ends | hz_parties | FISCAL_YEAREND_MONTH |
ATT_FLOOR/ Attendant's Floor | VARCHAR2(50) | - | The floor (address) of the attendant | hz_locations | FLOOR |
ATT_GSA_INDICATOR_FLAG/ Attendant GSA Indicator Flag | VARCHAR2(30) | - | The GSA Indicator Flag of the attendant's company | hz_parties | GSA_INDICATOR_FLAG |
ATT_HOUSE_NUMBER/ Attendant House Number | NUMBER | - | The house number of the attendant's address | hz_locations | HOUSE_NUMBER |
ATT_IDENTIFYING_ADDRESS_FLAG/ Attendant Identifying Address Flag | VARCHAR2(1) | Y/N | Whether or not this is the attendant's primary address | hz_party_sites | IDENTIFYING_ADDRESS_FLAG |
ATT_JGZZ_FISCAL_CODE/ Attendant JGZZ FISCAL Code | VARCHAR2(20) | - | The JGZZ Fiscal Code of the attendant's company | hz_parties | JGZZ_FISCAL_CODE |
ATT_JOB_TITLE/ Attendant Job Title | VARCHAR2 (100) | - | The job title of the attendant | hz_org_contacts | JOB_TITLE |
ATT_LAST_ORDER_DATE/ Attendant Last Order Date | DATE | - | Deprecated | hz_parties | LAST_ORDERED_DATE |
ATT_ORG_LEGAL_STATUS/ Attendant Org Legal Status | VARCHAR2(30) | - | The legal status of the attendant's company | hz_organization_profiles | LEGAL_STATUS |
ATT_LINE_OF_BUSINESS/ Attendant Line of Business | VARCHAR2 (240) | - | The line of business with which the attendant is associated | hz_organization_profiles | LINE_OF_BUSINESS |
ATT_MISSION_STATEMENT/ Attendant Mission Statement | VARCHAR2 (2000) | - | The mission statement for the attendant's company | hz_parties | MISSION_STATEMENT |
ATT_ORG_NAME_PHONETIC/ Attendant Org Name Phonetic | VARCHAR2 (320) | - | The phonetic name of the attendant's company | hz_parties | ORGANIZATION_NAME_PHONETIC |
ATT_OVERSEAS_ADDRESS_FLAG/ Attendant Overseas Address Flag | VARCHAR2(1) | Y/N | Whether or not the address is overseas | hz_locations | OVERSEAS_ADDRESS_FLAG |
ATT_NAME_SUFFIX/ Attendant Name Suffix | VARCHAR2(30) | - | The suffix of the attendant (Jr., M.D., etc.) | hz_parties | PERSON_NAME_SUFFIIX |
ATT_PHONE_AREA_CODE/ Attendant Phone Area Code | VARCHAR2(10) | - | The area code of the attendant's phone number | hz_contact_points | PHONE_AREA_CODE |
ATT_PHONE_COUNTRY_CODE/ Attendant Phone Country Code | VARCHAR2(10) | - | The country code of the attendant's phone number | hz_contact_points | PHONE_COUNTRY_CODE |
ATT_PHONE_EXTENSION/ Attendant Phone Extension | VARCHAR2(20) | - | The extension of the attendant's phone number | hz_contact_points | PHONE_EXTENSION |
ATT_PHONE_NUMBER/ Attendant Phone Number | VARCHAR2(40) | - | The attendant's phone number | hz_contact_points | PHONE_NUMBER |
ATT_POSTAL_CODE/ Attendant Postal Code | VARCHAR2(60) | - | The postal code of the attendant's address | hz_parties | POSTAL_CODE |
ATT_POSTAL_PLUS4_CODE/ Attendant Postal plus4 Code | VARCHAR2(4) | - | The postal plus-four code of the attendant's address | hz_locations | POSTAL_PLUS4_CODE |
ATT_PO_BOX_NO/ Attendant PO Box No | VARCHAR2(50) | - | The PO Box number of the attendant's address | hz_locations | PO_BOX_NUMBER |
ATT_PROVINCE/ Attendant Province | VARCHAR2(60) | - | The province of the attendant's address | hz_locations, hz_parties | PROVINCE |
ATT_RURAL_ROUTE_NO/ Attendant Rural Route Number | VARCHAR2(50) | - | The rural route number of the attendant's address | hz_locations | RURAL_ROUTE_NUMBER |
ATT_RURAL_ROUTE_TYPE/ Attendant Rural Route Type | VARCHAR2(30) | - | The rural route type of the attendant's address | hz_locations | RURTAL_ROUTE_TYPE |
ATT_SECONDARY_SUFFIX_ELEMENT/ Attendant Secondary Suffix Element | VARCHAR2(30) | - | The secondary suffix (such as Jr. or M.D.) of the attendant | hz_locations | SECONDARY_SUFFIX_ELEMENT |
ATT_SIC_CODE/ Attendant SIC Code | VARCHAR2(30) | - | The SIC Code of the attendant's company | hz_parties | SIC_CODE |
ATT_SIC_CODE_TYPE/ Attendant SIC Code Type | VARCHAR2(30) | - | The SIC Code Type of the attendant's company | hz_parties | SIC_CODE_TYPE |
ATT_SITE_USE_CODE/ Attendant Site Use Code | VARCHAR2(30) | - | The site use code of the attendant's address | Not Used | Not Used |
ATT_STATE/ Attendant State | VARCHAR2(60) | - | The state of the attendant's address | hz_locations, hz_parties | STATE |
ATT_STREET/ Attendant Street | VARCHAR2(50) | - | The street of the attendant's address | hz_locations | STREET |
ATT_STREET_NUMBER/ Attendant Street Number | VARCHAR2(50) | - | The street number of the attendant's address | hz_locations | STREET_NUMBER |
ATT_STREET_SUFFIX/ Attendant Street Suffix | VARCHAR2(50) | - | The street suffix of the attendant's address | hz_locations | STREET_SUFFIX |
ATT_SUITE/ Attendant Suite | VARCHAR2(50) | - | The suite of the attendant's address | hz_locations | SUITE |
ATT_TAX_NAME/ Attendant Tax Name | VARCHAR2(30) | - | The tax name of the attendant's company | hz_parties | TAX_NAME |
ATT_TAX_REFERENCE/ Attendant Tax Reference | VARCHAR2(50) | - | The tax reference of the attendant's company | hz_parties | TAX_REFERENCE |
ATT_TIME_ZONE/ Attendant Time Zone | NUMBER | - | The timezone of the attendant's address | hz_locations | TIME_ZONE |
ATT_TOTAL_NO_OF_ORDER/ Attendant Total Number of Orders | NUMBER | - | Deprecated | hz_parties | TOTAL_NUM_OF_ORDERS |
ATT_TOTAL_ORDER_AMOUNT/ Attendant Total Order Amount | NUMBER | - | Deprecated | hz_parties | TOTAL_ORDERED_AMOUNT |
ATT_YEAR_ESTABLISHED/ Attendant Year Established | NUMBER | - | The year the attendant's company was established | hz_parties | YEAR_ESTABLISHED |
ATT_URL/ Attendant URL | VARCHAR2 (2000) | - | The URL of the attendant's company | hz_contact_points, hz_parties | URL |
PERSON_INITIALS
Obsolete columns:
CUSTOMER_KEY
ADDRESS_KEY
CONTACT_KEY
Table Column / Field in Import File | Data Type | Table Requires Entry | Import Requires Entry | Valid Values | Comments |
---|---|---|---|---|---|
ACCEPT_FLAG | - | - | - | - | - |
ACTIVE_FLAG | VARCHAR2(1) | - | - | - | - |
ADDRESS_EFFECTIVE_DATE | VARCHAR2 | - | - | - | - |
ADDRESS_KEY | VARCHAR2 | - | - | - | Stores the Address Key generated |
ADDRESS_LINES_PHONETIC | VARCHAR2 | - | - | - | - |
ADDRESS_STYLE | VARCHAR2 | - | - | - | - |
ADDRESSEE | VARCHAR2 | - | - | - | - |
ASSIGN_DATE | VARCHAR2 | - | - | - | - |
ASSIGN_SALES_GROUP_ID | VARCHAR2 | - | - | - | - |
ASSIGN_TO_PERSON_ID | VARCHAR2 | - | - | - | - |
ASSIGN_TO_SALESFORCE_ID | VARCHAR2 | - | - | - | - |
ATTENDANCE_FAILURE_REASON | VARCHAR2(30) | - | - | AMS_EVENT_ATTENDANCE_FAILURE_CODE LOOKUP | - |
ATTENDANCE_RESULT_CODE | VARCHAR2(30) | - | - | - | - |
ATTENDANT_ACCOUNT_ID | NUMBER | - | - | CUSTOMER_ACCOUNT_ID | - |
ATTENDANT_CONTACT_ID | NUMBER | Yes | CONTACT_ID | - | |
ATTENDANT_LANGUAGE | VARCHAR2(30) | - | - | - | - |
ATTENDANT_PARTY_ID | NUMBER | - | - | PARTY_ID | - |
ATTENDED_FLAG | VARCHAR2(1) | - | - | - | - |
ATTRIBUTE_CATEGORY | VARCHAR2(30) | - | - | - | - |
ATTRIBUTE1 | VARCHAR2(150) | - | - | - | - |
ATTRIBUTE10 | VARCHAR2(150) | - | - | - | - |
ATTRIBUTE11 | VARCHAR2(150) | - | - | - | - |
ATTRIBUTE12 | VARCHAR2(150) | - | - | - | - |
ATTRIBUTE13 | VARCHAR2(150) | - | - | - | - |
ATTRIBUTE14 | VARCHAR2(150) | - | - | - | - |
ATTRIBUTE15 | VARCHAR2(150) | - | - | - | - |
ATTRIBUTE2 | VARCHAR2(150) | - | - | - | - |
ATTRIBUTE3 | VARCHAR2(150) | - | - | - | - |
ATTRIBUTE4 | VARCHAR2(150) | - | - | - | - |
ATTRIBUTE5 | VARCHAR2(150) | - | - | - | - |
ATTRIBUTE6 | VARCHAR2(150) | - | - | - | - |
ATTRIBUTE7 | VARCHAR2(150) | - | - | - | - |
ATTRIBUTE8 | VARCHAR2(150) | - | - | - | - |
ATTRIBUTE9 | VARCHAR2(150) | - | - | - | - |
AUTO_ASSIGNMENT_TYPE | VARCHAR2 | - | - | - | - |
AUTO_REGISTER_FLAG | VARCHAR2(1) | - | - | - | - |
BUDGET_AMOUNT | NUMBER | - | - | - | - |
BUDGET_AMOUNT_1 | NUMBER | - | - | - | - |
BUDGET_AMOUNT_2 | NUMBER | - | - | - | - |
BUDGET_AMOUNT_3 | NUMBER | - | - | - | - |
BUDGET_AMOUNT_4 | NUMBER | - | - | - | - |
BUDGET_AMOUNT_5 | NUMBER | - | - | - | - |
BUDGET_STATUS_CODE | VARCHAR2 | - | - | - | - |
CANCELLATION_CODE | NUMBER | - | - | - | - |
CANCELLATION_REASON_CODE | VARCHAR2(30) | - | - | AMS_EVENT_REG_CANCEL_REASON LOOKUP | - |
CHANNEL_CODE | VARCHAR2 | - | - | - | - |
CLOSE_REASON | VARCHAR2 | - | - | - | - |
CNT_PNT_CONTENT_SOURCE_TYPE | VARCHAR2 | - | - | - | This is a mandatory column in HZ_CONTACT_POINTS, but if not given, default it to 'USER_ENTERED' |
CNT_PNT_TIME_ZONE | VARCHAR2 | - | - | - | - |
CONFIRMED_FLAG | VARCHAR2(1) | - | - | - | - |
CONTACT_KEY | VARCHAR2 | - | - | - | Stores the Contact Key generated |
CONTACT_NUMBER | VARCHAR2 | - | - | - | - |
CONTACT_PARTY_ID | NUMBER | - | - | - | - |
CONTACT_ROLE_CODE | VARCHAR2 | - | - | - | - |
CONTENT_SOURCE_TYPE | VARCHAR2 | - | - | - | This is a mandatory column in HZ_LOCATIONS, but if not given, default it to 'USER_ENTERED' |
CREATED_BY | NUMBER | Yes | - | - | Populated by the list import program. |
CREATION_DATE | DATE | Yes | - | - | Populated by the list import program. |
CURRENCY_CODE | VARCHAR2 | - | - | - | - |
CUSTOMER_KEY | VARCHAR2 | - | - | - | Stores the customer Key generated |
DATE_REGISTRATION_PLACED | DATE | - | - | - | - |
DECISION_MAKER_FLAG | VARCHAR2 | - | - | - | - |
DECISION_TIMEFRAME_CODE | VARCHAR2 | - | - | - | - |
DELETED_FLAG | VARCHAR2 | - | - | - | - |
DEPARTMENT | VARCHAR2 | - | - | - | - |
DEPARTMENT_CODE | VARCHAR2 | - | - | - | - |
DESCRIPTION | VARCHAR2 | - | - | - | - |
DESCRIPTION | VARCHAR2 | - | - | - | - |
DO_NOT_EMAIL_FLAG | VARCHAR2 | - | - | - | If 'Y' then no emails sent to Contact. |
DO_NOT_FAX_FLAG | VARCHAR2 | - | - | - | If 'Y' then no fax sent to Contact. |
DO_NOT_PHONE_FLAG | VARCHAR2 | - | - | - | If 'Y' then no phone calls to Contact. |
DUNS_NUMBER | VARCHAR2 | - | - | - | - |
EMAIL_FORMAT | VARCHAR2 | - | - | - | - |
EVALUATED_FLAG | VARCHAR2(1) | - | - | - | - |
EVENT_OFFER_ID | NUMBER | - | Yes | AMS_EVENT_OFFERS_ALL_B | - |
FA_LOCATION_ID | NUMBER | - | - | - | - |
FAX_AREA_CODE | VARCHAR2 | - | - | - | - |
FAX_COUNTRY_CODE | VARCHAR2 | - | - | - | - |
FAX_EXTENSION | VARCHAR2 | - | - | - | - |
FAX_NUMBER | VARCHAR2 | - | - | - | - |
FLOOR | VARCHAR2 | - | - | - | - |
GROUP_TYPE | VARCHAR2 | - | - | - | - |
GSA_INDICATOR_FLAG | VARCHAR2 | - | - | - | - |
HOUSE_NUMBER | VARCHAR2 | - | - | - | - |
HQ_BRANCH_IND | NUMBER | - | - | - | - |
IMPORT_FLAG | NUMBER | - | - | - | - |
IMPORT_LIST_HEADER_ID | NUMBER | Yes | - | - | Auto Generated |
IMPORT_SOURCE_LINE_ID | NUMBER | Yes | - | - | Auto Generated |
IMPORT_SUCCESSFUL_FLAG | VARCHAR2(1) | - | - | - | Populated by the list import program. |
INBOUND_CHANNEL_ID | NUMBER | - | - | - | - |
INBOUND_MEDIA_ID | NUMBER | - | - | - | - |
INCUMBENT_PARTNER_PARTY_ID | NUMBER | - | - | - | Partner specific |
INCUMBENT_PARTNER_RESOURCE_ID | NUMBER | - | - | - | Partner specific |
INTEREST_TYPE_ID_1 | NUMBER | - | - | - | - |
INTEREST_TYPE_ID_2 | NUMBER | - | - | - | - |
INTEREST_TYPE_ID_3 | NUMBER | - | - | - | - |
INTEREST_TYPE_ID_4 | NUMBER | - | - | - | - |
INTEREST_TYPE_ID_5 | NUMBER | - | - | - | - |
INVENTORY_ITEM_ID_1 | NUMBER | - | - | - | - |
INVENTORY_ITEM_ID_2 | NUMBER | - | - | - | - |
INVENTORY_ITEM_ID_3 | NUMBER | - | - | - | - |
INVENTORY_ITEM_ID_4 | NUMBER | - | - | - | - |
INVENTORY_ITEM_ID_5 | NUMBER | - | - | - | - |
INVITE_ONLY_OVERRIDE_FLAG | VARCHAR2(1) | - | - | - | - |
JGZZ_FISCAL_CODE | VARCHAR2 | - | - | - | - |
JOB_TITLE_CODE | VARCHAR2 | - | - | - | Stores the job title code |
KEEP_FLAG | VARCHAR2 | - | - | - | - |
KNOWN_AS | VARCHAR2 | - | - | - | - |
KNOWN_AS2 | VARCHAR2 | - | - | - | - |
KNOWN_AS3 | VARCHAR2 | - | - | - | - |
KNOWN_AS4 | VARCHAR2 | - | - | - | - |
KNOWN_AS5 | VARCHAR2 | - | - | - | - |
LANGUAGE | VARCHAR2 | - | - | - | - |
LANGUAGE_NAME | VARCHAR2 | - | - | - | - |
LAST_ORDERED_DATE | VARCHAR2 | - | - | - | - |
LAST_REG_STATUS_DATE | DATE | - | - | Date when the registration closed. | - |
LAST_UPDATE_LOGIN | NUMBER | Yes | - | - | Populated by the list import program. |
LAST_UPDATED_BY | NUMBER | Yes | - | - | Populated by the list import program. |
LEAD_DATE | DATE | - | - | - | - |
LEAD_NUMBER | VARCHAR2 | - | - | - | - |
LEAD_RANK_ID | NUMBER | - | - | - | Stores the sales lead rank id. Need not supply if supplied will get validated |
LOAD_ERROR_MESSAGE | VARCHAR2 | - | - | - | Currently, not used. To find the error messages, query from ams_errors |
LOC_DESCRIPTION | VARCHAR2 | - | - | - | - |
LOC_HIERARCHY_ID | NUMBER | - | - | - | - |
LOC_VALIDATED_FLAG | VARCHAR2 | - | - | - | - |
LOCATION_DIRECTIONS | VARCHAR2 | - | - | - | - |
LOCATION_ID | NUMBER | - | - | - | Location ID to which address information is mapped |
MAIL_STOP | VARCHAR2 | - | - | - | - |
MAILSTOP | VARCHAR2 | - | - | - | - |
MARKETING_SCORE | NUMBER | - | - | - | - |
MAX_ATTENDEE_OVERRIDE_FLAG | VARCHAR2(1) | - | - | - | - |
MIDDLE_INITIAL | VARCHAR2 | - | - | - | - |
MISSION_STATEMENT | VARCHAR2 | - | - | - | - |
NET_WORTH | VARCHAR2 | - | - | - | free text format |
NEW_CON_FLAG | VARCHAR2 | - | - | - | << DO NOT POPULATE >> if 1 - new contact, 0- existing Contact |
NEW_LOC_FLAG | VARCHAR2 | - | - | - | << DO NOT POPULATE >> if 1 - this is a new location. If 0- this is already existing. |
NEW_PARTY_FLAG | VARCHAR2 | - | - | - | << DO NOT POPULATE >> If 1 - party is newly created. If 0, existing party is used. |
NEW_PS_FLAG | VARCHAR2 | - | - | - | << DO NOT POPULATE >> if 1 - new PS, if 0 - PS already existing |
NEW_REL_FLAG | VARCHAR2 | - | - | - | << DO NOT POPULATE >> if 1 - new relationship, 0- existing Rel |
OBJECT_VERSION_NUMBER | NUMBER | Yes | - | - | Populated by the list import program. |
OFFER_ID | NUMBER | - | - | - | - |
OFFER_ID_1 | NUMBER | - | - | - | - |
OFFER_ID_2 | NUMBER | - | - | - | - |
OFFER_ID_3 | NUMBER | - | - | - | - |
OFFER_ID_4 | NUMBER | - | - | - | - |
OFFER_ID_5 | NUMBER | - | - | - | - |
ORDER_HEADER_ID | NUMBER | - | - | - | - |
ORDER_LINE_ID | NUMBER | - | - | - | - |
ORG_CNT_COMMENTS | VARCHAR2 | - | - | - | - |
ORG_CNT_TITLE | VARCHAR2 | - | - | - | - |
ORGANIZATION_ID_1 | NUMBER | - | - | - | - |
ORGANIZATION_ID_2 | NUMBER | - | - | - | - |
ORGANIZATION_ID_3 | NUMBER | - | - | - | - |
ORGANIZATION_ID_4 | NUMBER | - | - | - | - |
ORGANIZATION_ID_5 | NUMBER | - | - | - | - |
ORGANIZATION_NAME_PHONETIC | VARCHAR2 | - | - | - | - |
ORIG_SYSTEM_CODE | VARCHAR2 | - | - | - | Source application code where the lead originated example OTN |
ORIG_SYSTEM_REFERENCE | VARCHAR2 | - | - | - | May be populated as <orig_system_code > <identifier> example OTN10100 |
ORIGINAL_REGISTRANT_CONTACT_ID | NUMBER | - | Yes | - | - |
OWNER_USER_ID | NUMBER | - | Yes | - | - |
PARENT_PROJECT | VARCHAR2 | - | - | - | - |
PARTIES_VALIDATED_FLAG | VARCHAR2 | - | - | - | - |
PARTY_ID | NUMBER | - | - | - | Party ID to which the customer information is mapped |
PARTY_NUMBER | VARCHAR2 | - | - | - | - |
PARTY_REFERENCE_USE_FLAG | VARCHAR2 | - | - | - | - |
PARTY_SITE_ID | NUMBER | - | - | - | Party Site ID to which the party and location information is mapped |
PARTY_SITE_NAME | VARCHAR2 | - | - | - | - |
PARTY_SITE_NUMBER | VARCHAR2 | - | - | - | Can be populated ONLY when profile "HZ Generate Party Number" set to 'N' |
PARTY_TYPE | VARCHAR2 | - | - | - | - |
PAYMENT_STATUS_CODE | VARCHAR2(30) | - | - | - | - |
PERSON_FIRST_NAME_PHONETIC | VARCHAR2 | - | - | - | - |
PERSON_IDEN_TYPE | VARCHAR2 | - | - | - | - |
PERSON_IDENTIFIER | VARCHAR2 | - | - | - | - |
PERSON_LAST_NAME_PHONETIC | VARCHAR2 | - | - | - | - |
PERSON_NAME_SUFFIX | VARCHAR2 | - | - | - | - |
PERSON_PREVIOUS_LAST_NAME | VARCHAR2 | - | - | - | - |
PHONE_CALLING_CALENDAR | VARCHAR2 | - | - | - | - |
PHONE_COUNTRY_CODE | VARCHAR2 | - | - | - | - |
PHONE_ID | NUMBER | - | - | - | DO NOT POPULATE |
PO_BOX_NUMBER | VARCHAR2 | - | - | - | - |
LOCATION_POSITION | - | - | - | - | |
POSTAL_PLUS4_CODE | VARCHAR2 | - | - | - | - |
PRIMARY_CONTACT_FLAG | VARCHAR2 | - | - | - | - |
PRIMARY_CONTACT_PER_ROLE_TYPE | VARCHAR2 | - | - | - | 'Y' or 'N' |
PRIMARY_INTEREST_CODE_ID_1 | NUMBER | - | - | - | - |
PRIMARY_INTEREST_CODE_ID_2 | NUMBER | - | - | - | - |
PRIMARY_INTEREST_CODE_ID_3 | NUMBER | - | - | - | - |
PRIMARY_INTEREST_CODE_ID_4 | NUMBER | - | - | - | - |
PRIMARY_INTEREST_CODE_ID_5 | NUMBER | - | - | - | - |
PRIMARY_PER_TYPE | VARCHAR2 | - | - | - | 'Y' or 'N' |
PRM_ASSIGNMENT_TYPE | VARCHAR2 | - | - | - | - |
PRM_EXEC_SPONSOR_FLAG | VARCHAR2 | - | - | - | Partner specific |
PRM_IND_CLASSIFICATION_CODE | VARCHAR2 | - | - | - | Partner specific |
PRM_PRJ_LEAD_IN_PLACE_FLAG | VARCHAR2 | - | - | - | Partner specific |
PRM_SALES_LEAD_TYPE | VARCHAR2 | - | - | - | Partner specific |
PROGRAM_APPLICATION_ID | NUMBER | - | - | - | - |
PROGRAM_APPLICATION_ID | NUMBER | - | - | - | DO NOT POPULATE |
PROGRAM_ID | NUMBER | - | - | - | - |
PROGRAM_ID | - | - | - | Concurrent process generated | |
PROGRAM_UPDATE_DATE | DATE | - | - | - | - |
PROGRAM_UPDATE_DATE | DATE | - | - | - | - |
PROMOTION_CODE | VARCHAR2 | - | - | - | If given and promotion_id is not provided, then this will be transferred to promotion_id. |
PROMOTION_ID | NUMBER | - | - | - | If given, this is used for creating the sales lead header. |
PROSPECT_FLAG | VARCHAR2(1) | - | - | - | - |
PS_USES_COMMENTS | VARCHAR2 | - | - | - | - |
QUALIFIED_FLAG | VARCHAR2 | - | - | - | - |
QUANTITY_1 | NUMBER | - | - | - | - |
QUANTITY_2 | NUMBER | - | - | - | - |
QUANTITY_3 | NUMBER | - | - | - | - |
QUANTITY_4 | NUMBER | - | - | - | - |
QUANTITY_5 | NUMBER | - | - | - | - |
RANK | VARCHAR2 | - | - | - | - |
RAW_PHONE_NUMBER | VARCHAR2 | - | - | - | - |
REG_SOURCE_TYPE_CODE | VARCHAR2(30) | - | - | AMS_EVENT_REG_SOURCE_TYPE LOOKUP | - |
REGISTRANT_ACCOUNT_ID | NUMBER | - | Yes | CUSTOMER_ACCOUNT_ID | - |
REGISTRANT_CONTACT_ID | NUMBER | - | Yes | CONTACT_ID | - |
REGISTRANT_PARTY_ID | NUMBER | - | Yes | PARTY_ID | - |
REGISTRATION_GROUP_ID | NUMBER | - | Yes | - | - |
REGISTRATION_SOURCE_ID | NUMBER | - | - | - | - |
REJECT_REASON_CODE | VARCHAR2 | - | - | - | - |
REL_PARTY_ID | NUMBER | - | - | - | Relationship's party ID to which the relationship is mapped. |
REQUEST_ID | NUMBER | - | - | - | - |
REQUEST_ID | NUMBER | - | - | - | - |
ROLE_LEVEL | VARCHAR2 | - | - | - | - |
SALES_LEAD_ID | NUMBER | - | - | - | << DO NOT POPULATE >> Sales Lead ID to which the sales lead information is mapped. |
SALES_TAX_GEOCODE | VARCHAR2 | - | - | - | - |
SALES_TAX_INSIDE_CITY_LIMITS | VARCHAR2 | - | - | - | - |
SALESREP_ID | NUMBER | - | - | - | - |
SCORECARD_ID | NUMBER | - | - | - | - |
SECONDARY_INTEREST_CODE_ID_1 | NUMBER | - | - | - | - |
SECONDARY_INTEREST_CODE_ID_2 | NUMBER | - | - | - | - |
SECONDARY_INTEREST_CODE_ID_3 | NUMBER | - | - | - | - |
SECONDARY_INTEREST_CODE_ID_4 | NUMBER | - | - | - | - |
SECONDARY_INTEREST_CODE_ID_5 | NUMBER | - | - | - | - |
SECURITY_GROUP_ID | NUMBER | - | - | - | - |
SECURITY_GROUP_ID | NUMBER | - | - | - | - |
SHORT_DESCRIPTION | VARCHAR2 | - | - | - | - |
SIC_CODE_TYPE | VARCHAR2 | - | - | - | - |
SITE_USE_TYPE | VARCHAR2 | - | - | - | This is a mandatory column for HZ_PARTY_SITE_USES. But if not given, it will be defaulted to 'BILL_TO' |
SOURCE_CODE | VARCHAR2(30) | - | Yes | AMS_EVENT_OFFERS_ALL_B | - |
SOURCE_PROMOTION_ID_1 | NUMBER | - | - | - | - |
SOURCE_PROMOTION_ID_2 | NUMBER | - | - | - | - |
SOURCE_PROMOTION_ID_3 | NUMBER | - | - | - | - |
SOURCE_PROMOTION_ID_4 | NUMBER | - | - | - | - |
SOURCE_PROMOTION_ID_5 | NUMBER | - | - | - | - |
STREET | VARCHAR2 | - | - | - | - |
STREET_NUMBER | VARCHAR2 | - | - | - | - |
STREET_SUFFIX | VARCHAR2 | - | - | - | - |
SUITE | VARCHAR2 | - | - | - | - |
SYSTEM_STATUS_CODE | VARCHAR2(30) | - | - | AMS_EVENT_REG_STATUS LOOKUP | - |
TARGET_LIST_ID | NUMBER | - | - | - | - |
TAX_NAME | VARCHAR2 | - | - | - | - |
TIME_ZONE | VARCHAR2 | - | - | - | - |
TOTAL_NUM_OF_ORDERS | NUMBER | - | - | - | - |
TOTAL_ORDERED_AMOUNT | NUMBER | - | - | - | - |
UOM_CODE_1 | NUMBER | - | - | - | - |
UOM_CODE_2 | NUMBER | - | - | - | - |
UOM_CODE_3 | NUMBER | - | - | - | - |
UOM_CODE_4 | NUMBER | - | - | - | - |
UOM_CODE_5 | NUMBER | - | - | - | - |
URGENT_FLAG | VARCHAR2 | - | - | - | - |
USER_STATUS_ID | NUMBER | - | Yes | AMS_USER_STATUS LOOKUP | - |
VEHICLE_RESPONSE_CODE | VARCHAR2 | - | - | - | - |
WAITLISTED_PRIORITY | VARCHAR2(30) | - | - | - | - |