[Home] [Help] [Dependency Information]
Object Name: | HZ_CONTACT_POINTS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_CONTACT_POINTS |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_CONTACT_POINTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CONTACT_POINT_ID |
HZ_CONTACT_POINTS_N10 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EDI_ECE_TP_LOCATION_CODE |
HZ_CONTACT_POINTS_N11 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EFT_SWIFT_CODE |
HZ_CONTACT_POINTS_N12 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TIMEZONE_ID |
HZ_CONTACT_POINTS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PHONE_NUMBER |
HZ_CONTACT_POINTS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PHONE_AREA_CODE
PHONE_NUMBER PHONE_EXTENSION |
HZ_CONTACT_POINTS_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ORIG_SYSTEM_REFERENCE |
HZ_CONTACT_POINTS_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
OWNER_TABLE_ID
OWNER_TABLE_NAME CONTACT_POINT_TYPE PRIMARY_FLAG |
HZ_CONTACT_POINTS_N7 | FUNCTION-BASED NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UPPER("EMAIL_ADDRESS") |
HZ_CONTACT_POINTS_N8 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSPOSED_PHONE_NUMBER |
HZ_CONTACT_POINTS_N9 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EDI_ID_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTACT_POINT_ID | NUMBER | (15) | Yes | Unique identifier of this contact point |
CONTACT_POINT_TYPE | VARCHAR2 | (30) | Yes | Contact point type, such as phone or e-mail. Valid value from COMMUNICATION_TYPE lookup type. |
STATUS | VARCHAR2 | (30) | Yes | Lookup: contact_point_status. Typically, active, inactive, delete. |
OWNER_TABLE_NAME | VARCHAR2 | (30) | Yes | Table that stores the owner of the contact point |
OWNER_TABLE_ID | NUMBER | (15) | Yes | Foreign key to OWNER_TABLE_NAME identifies the owner of the contact point |
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. | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
WH_UPDATE_DATE | DATE | Date when the record was entered or changed in a data warehouse | ||
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Not currently used | |
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Not currently used | |
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Not currently used | |
EDI_TRANSACTION_HANDLING | VARCHAR2 | (25) | ANSI standard code for EDI transaction type | |
EDI_ID_NUMBER | VARCHAR2 | (30) | EDI trading partner number for the supplier site | |
EDI_PAYMENT_METHOD | VARCHAR2 | (30) | Indicates how a payment is to be made through EDI. Valid methods are ACH and BOP. | |
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. | |
EDI_REMITTANCE_METHOD | VARCHAR2 | (30) | Indicates how remittance advice are sent to the supplier. | |
EDI_REMITTANCE_INSTRUCTION | VARCHAR2 | (30) | Indicates who will send the remittance advice. Valid values are Banks or Payables systems. | |
EDI_TP_HEADER_ID | NUMBER | (15) | EDI transaction header unique identifier | |
EDI_ECE_TP_LOCATION_CODE | VARCHAR2 | (40) | Trading partner location code for EDI Gateway | |
EMAIL_FORMAT | VARCHAR2 | (30) | Indicates the preferred format for e-mail addressed to this address. For example, HTML or ASCII. | |
EMAIL_ADDRESS | VARCHAR2 | (2000) | E-mail address of the contact point | |
BEST_TIME_TO_CONTACT_START | DATE | No Longer Used | ||
BEST_TIME_TO_CONTACT_END | DATE | No Longer Used | ||
PHONE_CALLING_CALENDAR | VARCHAR2 | (30) | The name or code for a calling calendar used with this telephone number. | |
CONTACT_ATTEMPTS | NUMBER | No Longer Used | ||
CONTACTS | NUMBER | No Longer Used | ||
DECLARED_BUSINESS_PHONE_FLAG | VARCHAR2 | (1) | No Longer Used | |
DO_NOT_USE_FLAG | VARCHAR2 | (1) | No Longer Used | |
DO_NOT_USE_REASON | VARCHAR2 | (60) | No Longer Used | |
LAST_CONTACT_DT_TIME | DATE | Date and time of last contact placed to this contact point. | ||
PHONE_PREFERRED_ORDER | NUMBER | No Longer Used. | ||
PRIORITY_OF_USE_CODE | VARCHAR2 | (30) | No Longer Used. | |
TELEPHONE_TYPE | VARCHAR2 | (30) | No Longer Used. | |
TIME_ZONE | NUMBER | Time zone expressed as the deviation or difference in hours from Greenwich Mean Time(GMT). | ||
PHONE_TOUCH_TONE_TYPE_FLAG | VARCHAR2 | (1) | No Longer Used | |
PHONE_AREA_CODE | VARCHAR2 | (10) | The area code within a country code. | |
PHONE_COUNTRY_CODE | VARCHAR2 | (10) | International country code for a telephone number. For example, 33 for France. | |
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. | |
URL | VARCHAR2 | (2000) | Uniform resource locator | |
CONTENT_SOURCE_TYPE | VARCHAR2 | (30) | Yes | Source of data content |
RAW_PHONE_NUMBER | VARCHAR2 | (60) | Unformatted telephone number | |
OBJECT_VERSION_NUMBER | NUMBER | This column is used for locking purposes | ||
CREATED_BY_MODULE | VARCHAR2 | (150) | TCA Who column | |
APPLICATION_ID | NUMBER | TCA Who column | ||
TIMEZONE_ID | NUMBER | Time zone identifier. Foreign key to HZ_TIMEZONES | ||
CONTACT_POINT_PURPOSE | VARCHAR2 | (30) | Contact point type, such as business or personal. Uses the CONTACT_POINT_PURPOSE lookup. | |
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. | |
EFT_TRANSMISSION_PROGRAM_ID | NUMBER | (15) | Transmission program identifier | |
EFT_PRINTING_PROGRAM_ID | NUMBER | (15) | Printing program identifier | |
EFT_USER_NUMBER | VARCHAR2 | (30) | The number that identifier you as a user of electronic funds transfer service to your bank or clearing organization. | |
EFT_SWIFT_CODE | VARCHAR2 | (30) | EFT Swift Code | |
ACTUAL_CONTENT_SOURCE | VARCHAR2 | (30) | Yes | Additional Content Source Type column for backward compatibility. |
Cut, paste (and edit) the following text to query this object:
SELECT CONTACT_POINT_ID
, CONTACT_POINT_TYPE
, STATUS
, OWNER_TABLE_NAME
, OWNER_TABLE_ID
, PRIMARY_FLAG
, ORIG_SYSTEM_REFERENCE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, WH_UPDATE_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, EDI_TRANSACTION_HANDLING
, EDI_ID_NUMBER
, EDI_PAYMENT_METHOD
, EDI_PAYMENT_FORMAT
, EDI_REMITTANCE_METHOD
, EDI_REMITTANCE_INSTRUCTION
, EDI_TP_HEADER_ID
, EDI_ECE_TP_LOCATION_CODE
, EMAIL_FORMAT
, EMAIL_ADDRESS
, BEST_TIME_TO_CONTACT_START
, BEST_TIME_TO_CONTACT_END
, PHONE_CALLING_CALENDAR
, CONTACT_ATTEMPTS
, CONTACTS
, DECLARED_BUSINESS_PHONE_FLAG
, DO_NOT_USE_FLAG
, DO_NOT_USE_REASON
, LAST_CONTACT_DT_TIME
, PHONE_PREFERRED_ORDER
, PRIORITY_OF_USE_CODE
, TELEPHONE_TYPE
, TIME_ZONE
, PHONE_TOUCH_TONE_TYPE_FLAG
, PHONE_AREA_CODE
, PHONE_COUNTRY_CODE
, PHONE_NUMBER
, PHONE_EXTENSION
, PHONE_LINE_TYPE
, TELEX_NUMBER
, WEB_TYPE
, URL
, CONTENT_SOURCE_TYPE
, RAW_PHONE_NUMBER
, OBJECT_VERSION_NUMBER
, CREATED_BY_MODULE
, APPLICATION_ID
, TIMEZONE_ID
, CONTACT_POINT_PURPOSE
, PRIMARY_BY_PURPOSE
, TRANSPOSED_PHONE_NUMBER
, EFT_TRANSMISSION_PROGRAM_ID
, EFT_PRINTING_PROGRAM_ID
, EFT_USER_NUMBER
, EFT_SWIFT_CODE
, ACTUAL_CONTENT_SOURCE
FROM AR.HZ_CONTACT_POINTS;
AR.HZ_CONTACT_POINTS does not reference any database object
AR.HZ_CONTACT_POINTS is referenced by following:
|
|
|