1. Tables and Views for Sales and Fusion Service
  2. HZ_CONTACT_POINTS_

HZ_CONTACT_POINTS_

Electronic methods of communication with parties The HZ_CONTACT_POINTS table stores information about how to communicate to parties or party sites using electronic media or methods such as Electronic Data Interchange (EDI), e-mail, telephone, telex, and the Internet. For example, telephone-related data can include the type of telephone line, a touch tone indicator, a country code, the area code, the telephone number, and an extension number to a specific handset. NOTE: Each media or method should be stored as a separate record in this table. For example, the attributes of a complete telephone connection should be stored in a record, while EDI information should be stored in a different record. The primary key for this table is CONTACT_POINT_ID.

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

HZ_CONTACT_POINTS_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, CONTACT_POINT_ID

Columns

Name Datatype Length Precision Not-null Comments Status
CONTACT_POINT_ID NUMBER 18 Yes Unique identifier for a contact point. System generated from a sequence. Primary Key. Active
PRIMARY_PER_PHONE_TYPE VARCHAR2 1 Indicates if this is the primary phone of the phone type. Y for primary contact, N for all others.
PHONE_TYPE VARCHAR2 30 Indicates the Type of Phone like Work, Home, Mobile etc.
TIMEZONE_CODE VARCHAR2 64 Foreign key to FND_TIMEZONES_B.TIMEZONE_CODE
CONTACT_POINT_TYPE VARCHAR2 30 Contact point type, such as phone or e-mail. Valid value from COMMUNICATION_TYPE lookup type. Active
STATUS VARCHAR2 30 Lookup: contact_point_status. Typically values: active, inactive, delete. It is validated against AR lookup type REGISTRY_STATUS. Default value is A. Active
PRIMARY_FLAG VARCHAR2 1 Indicates if this is the primary contact point of this contact point type for referenced party, site, or location. Y for primary contact, N for all others.
ORIG_SYSTEM_REFERENCE VARCHAR2 240 Identifier for this record from foreign or legacy system. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
OWNER_TABLE_NAME VARCHAR2 30 Table that stores the owner of the contact point Active
OWNER_TABLE_ID NUMBER 18 Foreign key to OWNER_TABLE_NAME identifies the owner of the contact point Active
EDI_TRANSACTION_HANDLING VARCHAR2 25 ANSI standard code for EDI transaction type Active
EDI_ID_NUMBER VARCHAR2 30 EDI trading partner number for the supplier site Active
EDI_PAYMENT_METHOD VARCHAR2 30 Indicates how a payment is to be made through EDI. Valid methods are ACH and BOP. Active
EDI_PAYMENT_FORMAT VARCHAR2 30 Indicates type of information being transmitted with the funds if using EDI_PAYMENT_METHOD ACH. Valid values are CCD, CCP, CHZ, CTX, PPD, and PPP. Active
EDI_REMITTANCE_METHOD VARCHAR2 30 Indicates how remittance advice are sent to the supplier. Active
EDI_REMITTANCE_INSTRUCTION VARCHAR2 30 Indicates who will send the remittance advice. Valid values are Banks or Payables systems. Active
EDI_TP_HEADER_ID NUMBER 18 EDI transaction header unique identifier Active
EDI_ECE_TP_LOCATION_CODE VARCHAR2 40 Trading partner location code for EDI Gateway Active
EMAIL_FORMAT VARCHAR2 30 Indicates the preferred format for e-mail addressed to this address. For example, HTML or ASCII. Active
EMAIL_ADDRESS VARCHAR2 320 E-mail address of the contact point Active
PHONE_CALLING_CALENDAR VARCHAR2 30 The name or code for a calling calendar used with this telephone number. This aatribute is no longer used in Fusion.
LAST_CONTACT_DT_TIME DATE Date and time of last contact placed to this contact point. Active
PHONE_AREA_CODE VARCHAR2 20 The area code within a country code.
PHONE_NUMBER VARCHAR2 40 A telephone number formatted in the local format. The number should not include area code, country code, or extension.
PHONE_EXTENSION VARCHAR2 20 Additional number addressed after initial connection to an internal telephone system.
PHONE_LINE_TYPE VARCHAR2 30 Lookup code for the type of phone line. For example, general, fax, inbound, or outbound.
TELEX_NUMBER VARCHAR2 50 Reference number (usually a telephone number) that TELEX messages are sent to.
WEB_TYPE VARCHAR2 60 The prefix class to a web address. Typically this is either FTP or HTTP. Active
URL VARCHAR2 2000 Uniform resource locator Active
PHONE_COUNTRY_CODE VARCHAR2 10 International country code for a telephone number. For example, 33 for France.
RAW_PHONE_NUMBER VARCHAR2 60 Unformatted telephone number Active
OBJECT_VERSION_NUMBER NUMBER 9 Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
CREATED_BY_MODULE VARCHAR2 30 TCA Who column Active
TIMEZONE_ID NUMBER This column is obsolete in fusion V1
CONTACT_POINT_PURPOSE VARCHAR2 30 Contact point type, such as business or personal. Uses the CONTACT_POINT_PURPOSE lookup. Active
PRIMARY_BY_PURPOSE VARCHAR2 30 Y indicates that this is the primary contact point of the contact point purpose for the party or site. A party or site can have only one contact point with a value of Y.
TRANSPOSED_PHONE_NUMBER VARCHAR2 60 This column stores the concatenation of PHONE_COUNTRY_CODE, PHONE_AREA_CODE, and PHONE_NUMBER in reverse. e.g. If PHONE_COUNTRY_CODE=1, PHONE_AREA_CODE=650 and PHONE_NUMBER=5065747, this column stores 74756050561. This column is used in building an index to search on any combination of the above three columns. Active
EFT_TRANSMISSION_PROGRAM_ID NUMBER 18 Transmission program identifier Active
EFT_PRINTING_PROGRAM_ID NUMBER 18 Printing program identifier Active
EFT_USER_NUMBER VARCHAR2 30 The number that identifier you as a user of electronic funds transfer service to your bank or clearing organization. Active
EFT_SWIFT_CODE VARCHAR2 30 EFT Swift Code Active
ACTUAL_CONTENT_SOURCE VARCHAR2 30 Additional Content Source Type column for backward compatibility. Active
RELATIONSHIP_ID NUMBER 18 Column to store the party's contact point in the context of a relationship Active
PARTY_USAGE_CODE VARCHAR2 30 Usage context of a party's contact point.
INSTANT_MESSENGER_TYPE VARCHAR2 30 Instant messaging type such as Yahoo, MSN or ICQ Active
INSTANT_MESSAGING_ADDRESS VARCHAR2 200 Instant messaging ID Active
PAGER_TYPE_CODE VARCHAR2 30 The PAGER_TYPE_CODE column stores the lookup code for the type of pager. The type of pager determines how the page is received. For example, Tone, Number, Alphanumeric or Two-way alphanumeric.
CONFLICT_ID NUMBER 18 Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). Active
USER_LAST_UPDATE_DATE TIMESTAMP Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). Active
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE30 VARCHAR2 255 Descriptive Flexfield: segment of the user descriptive flexfield. Active
START_DATE DATE Indicates the date from which this entity is active. This date is inclusive. The status of an entity is dependent on this. Active
END_DATE DATE Indicates the date till which this entity is active. This date is inclusive. The status of an entity is dependent on this Active
CPDRF_VER_SOR NUMBER 9 Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version in System of Record (SOR) pillar when a record change is replicated to subscribing pillars by the replication flows.
CPDRF_VER_PILLAR NUMBER 9 Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version when a record is changed by replication flows
CPDRF_LAST_UPD VARCHAR2 15 Cross Pillar Data Replication Framework (CPDRF) system column for tracking source pillar name when a record is changed by the replication flows.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE11 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE12 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
OVERALL_PRIMARY_FLAG VARCHAR2 1 Indicates if this is the primary contact point of this contact irrespective of the Context. Y for primary contact, N for all others.
PERSONAL_CONTACT_POINT_FLAG VARCHAR2 1 Indicates if this is the personal contact point of the contact.
VERIFICATION_STATUS VARCHAR2 30 Status of the validation processed by the email and phone verification service or by the user. The value for this attribute should be predefined in the lookup type HZ_CP_VALIDATION_STATUS_TYPE. The values can be VALID, INVALID, and so on.
VERIFICATION_DATE TIMESTAMP Date at which the validation of the phone or email was done by the email and phone verification service or by the user. Active
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.

Indexes

Index Uniqueness Tablespace Columns
HZ_CONTACT_POINTSN1_ Non Unique Default CONTACT_POINT_ID
HZ_CONTACT_POINTS_PK_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, CONTACT_POINT_ID