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 |
CONTACT_POINT_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | 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 | Yes | Contact point type, such as phone or e-mail. Valid value from COMMUNICATION_TYPE lookup type. | Contact Point (HZ_CONTACT_POINTS) | Active | |
STATUS | VARCHAR2 | 30 | Yes | 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. | Contact Point (HZ_CONTACT_POINTS) | |||
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 | Yes | Who column: indicates the date and time of the creation of the row. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Contact Point (HZ_CONTACT_POINTS) | 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. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
OWNER_TABLE_NAME | VARCHAR2 | 30 | Yes | Table that stores the owner of the contact point | Active | ||
OWNER_TABLE_ID | NUMBER | 18 | Yes | 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 | Contact Point (HZ_CONTACT_POINTS) | Active | ||
EDI_ID_NUMBER | VARCHAR2 | 30 | EDI trading partner number for the supplier site | Contact Point (HZ_CONTACT_POINTS) | Active | ||
EDI_PAYMENT_METHOD | VARCHAR2 | 30 | Indicates how a payment is to be made through EDI. Valid methods are ACH and BOP. | Contact Point (HZ_CONTACT_POINTS) | 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. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
EDI_REMITTANCE_METHOD | VARCHAR2 | 30 | Indicates how remittance advice are sent to the supplier. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
EDI_REMITTANCE_INSTRUCTION | VARCHAR2 | 30 | Indicates who will send the remittance advice. Valid values are Banks or Payables systems. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
EDI_TP_HEADER_ID | NUMBER | 18 | EDI transaction header unique identifier | Contact Point (HZ_CONTACT_POINTS) | Active | ||
EDI_ECE_TP_LOCATION_CODE | VARCHAR2 | 40 | Trading partner location code for EDI Gateway | Contact Point (HZ_CONTACT_POINTS) | Active | ||
EMAIL_FORMAT | VARCHAR2 | 30 | Indicates the preferred format for e-mail addressed to this address. For example, HTML or ASCII. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
EMAIL_ADDRESS | VARCHAR2 | 320 | E-mail address of the contact point | Contact Point (HZ_CONTACT_POINTS) | 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. | Contact Point (HZ_CONTACT_POINTS) | |||
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. | Contact Point (HZ_CONTACT_POINTS) | |||
PHONE_NUMBER | VARCHAR2 | 40 | A telephone number formatted in the local format. The number should not include area code, country code, or extension. | Contact Point (HZ_CONTACT_POINTS) | |||
PHONE_EXTENSION | VARCHAR2 | 20 | Additional number addressed after initial connection to an internal telephone system. | Contact Point (HZ_CONTACT_POINTS) | |||
PHONE_LINE_TYPE | VARCHAR2 | 30 | Lookup code for the type of phone line. For example, general, fax, inbound, or outbound. | Contact Point (HZ_CONTACT_POINTS) | |||
TELEX_NUMBER | VARCHAR2 | 50 | Reference number (usually a telephone number) that TELEX messages are sent to. | Contact Point (HZ_CONTACT_POINTS) | |||
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. | Contact Point (HZ_CONTACT_POINTS) | |||
RAW_PHONE_NUMBER | VARCHAR2 | 60 | Unformatted telephone number | Active | |||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | 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 | Contact Point (HZ_CONTACT_POINTS) | 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. | Contact Point (HZ_CONTACT_POINTS) | 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. | Contact Point (HZ_CONTACT_POINTS) | |||
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 | Yes | 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. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | Active | ||
ATTRIBUTE30 | VARCHAR2 | 255 | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | 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. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_NUMBER11 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_NUMBER12 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_DATE11 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
ATTRIBUTE_DATE12 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Contact Point (HZ_CONTACT_POINTS) | ||||
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 |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
svc_channel_via | hz_contact_points | CONTACT_POINT_ID |
zpm_partner_profiles | hz_contact_points | PUBLIC_PHONE_ID |
zpm_partner_profiles | hz_contact_points | PUBLIC_FAX_ID |
zpm_partner_profiles | hz_contact_points | PUBLIC_EMAIL_ID |
psc_pbl_contact_pt | hz_contact_points | CONTACT_POINT_ID |
zca_s_acct_contact_points | hz_contact_points | CONTACT_POINT_ID |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
HZ_CONTACT_POINTS_N1 | Non Unique | Default | RELATIONSHIP_ID, OWNER_TABLE_ID, CONTACT_POINT_TYPE, PRIMARY_FLAG, OWNER_TABLE_NAME, STATUS, CONTACT_POINT_PURPOSE, PRIMARY_BY_PURPOSE, OVERALL_PRIMARY_FLAG | |
HZ_CONTACT_POINTS_N10 | Non Unique | Default | EFT_SWIFT_CODE | |
HZ_CONTACT_POINTS_N11 | Non Unique | Default | UPPER("EMAIL_ADDRESS") | |
HZ_CONTACT_POINTS_N12 | Non Unique | Default | "LAST_UPDATE_DATE", CONTACT_POINT_ID, STATUS | |
HZ_CONTACT_POINTS_N13 | Non Unique | Default | CONTACT_POINT_TYPE, UPPER("URL") | |
HZ_CONTACT_POINTS_N14 | Non Unique | Default | CONTACT_POINT_TYPE, UPPER("INSTANT_MESSAGING_ADDRESS") | |
HZ_CONTACT_POINTS_N15 | Non Unique | Default | UPPER(CASE WHEN NVL("PERSONAL_CONTACT_POINT_FLAG",'N')<>'Y' THEN "EMAIL_ADDRESS" ELSE NULL END ) | |
HZ_CONTACT_POINTS_N16 | Non Unique | Default | CASE WHEN NVL("PERSONAL_CONTACT_POINT_FLAG",'N')<>'Y' THEN "TRANSPOSED_PHONE_NUMBER" ELSE NULL END | |
HZ_CONTACT_POINTS_N17 | Non Unique | Default | REQUEST_ID | |
HZ_CONTACT_POINTS_N18 | Non Unique | Default | CASE WHEN NVL("PERSONAL_CONTACT_POINT_FLAG",'N')<>'M' THEN "TRANSPOSED_PHONE_NUMBER" ELSE NULL END | |
HZ_CONTACT_POINTS_N19 | Non Unique | Default | CASE WHEN (NVL("PERSONAL_CONTACT_POINT_FLAG",'N')<>'Y' AND NVL("PERSONAL_CONTACT_POINT_FLAG",'N')<>'M') THEN "TRANSPOSED_PHONE_NUMBER" ELSE NULL END | |
HZ_CONTACT_POINTS_N20 | Non Unique | Default | OWNER_TABLE_ID, OWNER_TABLE_NAME, STATUS, CONTACT_POINT_TYPE, PHONE_TYPE, PRIMARY_PER_PHONE_TYPE | |
HZ_CONTACT_POINTS_N3 | Non Unique | Default | PHONE_NUMBER, START_DATE | Active |
HZ_CONTACT_POINTS_N4 | Non Unique | Default | PHONE_COUNTRY_CODE, PHONE_AREA_CODE, PHONE_NUMBER, PHONE_EXTENSION, START_DATE | Active |
HZ_CONTACT_POINTS_N5 | Non Unique | Default | ORIG_SYSTEM_REFERENCE | Active |
HZ_CONTACT_POINTS_N6 | Non Unique | Default | OWNER_TABLE_ID, CONTACT_POINT_TYPE, OWNER_TABLE_NAME, PRIMARY_FLAG, CONTACT_POINT_PURPOSE, PRIMARY_BY_PURPOSE, START_DATE, OVERALL_PRIMARY_FLAG | Active |
HZ_CONTACT_POINTS_N7 | Non Unique | Default | TRANSPOSED_PHONE_NUMBER | |
HZ_CONTACT_POINTS_N8 | Non Unique | Default | EDI_ID_NUMBER | |
HZ_CONTACT_POINTS_N9 | Non Unique | Default | EDI_ECE_TP_LOCATION_CODE | |
HZ_CONTACT_POINTS_N21 | Non Unique | Default | PRIMARY_BY_PURPOSE, STATUS, OWNER_TABLE_NAME, OWNER_TABLE_ID | |
HZ_CONTACT_POINTS_PK | Unique | Default | CONTACT_POINT_ID |