Party Contact Points
The party contact point view object contains the electronic methods of communication with parties such as Electronic Data Interchange or EDI, e-mail, phone, telex, and the Internet. Each media or method is stored as a separate record in this view.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.PartyContactPointExtractPVO
Primary Keys : ContactPointId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ActualContentSource | The additional content source type column for backward compatibility. |
| Attribute1 | A segment for the party contact point descriptive flexfield. |
| Attribute10 | A segment for the party contact point descriptive flexfield. |
| Attribute11 | A segment for the party contact point descriptive flexfield. |
| Attribute12 | A segment for the party contact point descriptive flexfield. |
| Attribute13 | A segment for the party contact point descriptive flexfield. |
| Attribute14 | A segment for the party contact point descriptive flexfield. |
| Attribute15 | A segment for the party contact point descriptive flexfield. |
| Attribute16 | A segment for the party contact point descriptive flexfield. |
| Attribute17 | A segment for the party contact point descriptive flexfield. |
| Attribute18 | A segment for the party contact point descriptive flexfield. |
| Attribute19 | A segment for the party contact point descriptive flexfield. |
| Attribute2 | A segment for the party contact point descriptive flexfield. |
| Attribute20 | A segment for the party contact point descriptive flexfield. |
| Attribute21 | A segment for the party contact point descriptive flexfield. |
| Attribute22 | A segment for the party contact point descriptive flexfield. |
| Attribute23 | A segment for the party contact point descriptive flexfield. |
| Attribute24 | A segment for the party contact point descriptive flexfield. |
| Attribute25 | A segment for the party contact point descriptive flexfield. |
| Attribute26 | A segment for the party contact point descriptive flexfield. |
| Attribute27 | A segment for the party contact point descriptive flexfield. |
| Attribute28 | A segment for the party contact point descriptive flexfield. |
| Attribute29 | A segment for the party contact point descriptive flexfield. |
| Attribute3 | A segment for the party contact point descriptive flexfield. |
| Attribute30 | A segment for the party contact point descriptive flexfield. |
| Attribute4 | A segment for the party contact point descriptive flexfield. |
| Attribute5 | A segment for the party contact point descriptive flexfield. |
| Attribute6 | A segment for the party contact point descriptive flexfield. |
| Attribute7 | A segment for the party contact point descriptive flexfield. |
| Attribute8 | A segment for the party contact point descriptive flexfield. |
| Attribute9 | A segment for the party contact point descriptive flexfield. |
| AttributeCategory | The context name for the party contact point descriptive flexfield. |
| AttributeDate1 | A date segment for the party contact point descriptive flexfield. |
| AttributeDate10 | A date segment for the party contact point descriptive flexfield. |
| AttributeDate11 | A date segment for the party contact point descriptive flexfield. |
| AttributeDate12 | A date segment for the party contact point descriptive flexfield. |
| AttributeDate2 | A date segment for the party contact point descriptive flexfield. |
| AttributeDate3 | A date segment for the party contact point descriptive flexfield. |
| AttributeDate4 | A date segment for the party contact point descriptive flexfield. |
| AttributeDate5 | A date segment for the party contact point descriptive flexfield. |
| AttributeDate6 | A date segment for the party contact point descriptive flexfield. |
| AttributeDate7 | A date segment for the party contact point descriptive flexfield. |
| AttributeDate8 | A date segment for the party contact point descriptive flexfield. |
| AttributeDate9 | A date segment for the party contact point descriptive flexfield. |
| AttributeNumber1 | A number segment for the party contact point descriptive flexfield. |
| AttributeNumber10 | A number segment for the party contact point descriptive flexfield. |
| AttributeNumber11 | A number segment for the party contact point descriptive flexfield. |
| AttributeNumber12 | A number segment for the party contact point descriptive flexfield. |
| AttributeNumber2 | A number segment for the party contact point descriptive flexfield. |
| AttributeNumber3 | A number segment for the party contact point descriptive flexfield. |
| AttributeNumber4 | A number segment for the party contact point descriptive flexfield. |
| AttributeNumber5 | A number segment for the party contact point descriptive flexfield. |
| AttributeNumber6 | A number segment for the party contact point descriptive flexfield. |
| AttributeNumber7 | A number segment for the party contact point descriptive flexfield. |
| AttributeNumber8 | A number segment for the party contact point descriptive flexfield. |
| AttributeNumber9 | A number segment for the party contact point descriptive flexfield. |
| ContactPointId | The unique primary key identifier for the contact point. |
| ContactPointPurpose | The purpose of the contact point, such as business or personal. |
| ContactPointType | The type of the contact point type, such as phone or e-mail. |
| CreatedBy | The user who created the record. |
| CreatedByModule | The module through which the party contact point was created. |
| CreationDate | The date and time of creating the record. |
| EdiEceTpLocationCode | The trading partner location code for EDI Gateway. |
| EdiIdNumber | The EDI trading partner number for the supplier site. |
| EdiPaymentFormat | Indicates type of information being transmitted with the funds if using EDI_PAYMENT_METHOD ACH. The list of accepted values are CCD, CCP, CHZ, CTX, PPD, and PPP. |
| EdiPaymentMethod | Indicates how a payment is to be made through EDI. The list of accepted values are ACH and BOP. |
| EdiRemittanceInstruction | Indicates who will send the remittance advice. The list of accepted values are Banks or Payables systems. |
| EdiRemittanceMethod | Indicates how remittance advice are sent to the supplier. |
| EdiTpHeaderId | The unique identifier of the EDI transaction header. |
| EdiTransactionHandling | The ANSI standard code for EDI transaction type. |
| EftPrintingProgramId | The printing program identifier. |
| EftSwiftCode | The EFT swift code information. |
| EftTransmissionProgramId | The transmission program identifier. |
| EftUserNumber | The number that identifies you as a user of electronic funds transfer service for your bank or clearing organization. |
| EmailAddress | The email address of the contact point. |
| EmailFormat | Indicates the preferred format for email addressed to this address. For example, HTML or ASCII. |
| EndDate | Indicates the date till which the entity is active. This date is inclusive and the status of the entity is dependent on this. |
| InstantMessagingAddress | The instant messaging information address. |
| InstantMessengerType | The type of the instant messenger type, such as Yahoo, MSN or ICQ. |
| LastContactDtTime | The last time when the contact point was contacted. |
| LastUpdateDate | The date and time of last update of the record. |
| LastUpdateLogin | The login of the user who last updated the record. |
| LastUpdatedBy | The user who last updated the record. |
| OrigSystemReference | The identifier for the record from the original system. |
| OverallPrimaryFlag | Indicates whether this is the primary contact point of this contact irrespective of the context. Y for primary contact, N for all others. |
| OwnerTableId | The unique identifier for a record in the owner table. |
| OwnerTableName | The Trading Community Architecture tables that have source system reference column. |
| PagerTypeCode | 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. |
| PartyUsageCode | The usage context of a party's contact point. |
| PhoneAreaCode | The area code prefix for the phone number. |
| PhoneCountryCode | The country code prefix for the phone number. For example, 33 for France. |
| PhoneExtension | Additional number addressed after initial connection to an internal phone system. |
| PhoneLineType | The lookup code for the type of phone line. For example, general, fax, inbound, or outbound. |
| PhoneNumber | The phone number in the local format. The number must not include area code, country code, or extension. |
| PhoneType | Indicates the type of phone like work, home, mobile, and so on. |
| PrimaryByPurpose | Indicates whether this is the primary contact point of the contact point purpose for the party or site. The value Y indicates that the contact point is the primary contact point. A party or site can have only one contact point with value Y. |
| PrimaryFlag | Indicator to specify if this is the primary contact point of the contact point type for referenced party, site, or location. Y stands for primary contact and N for all others. |
| PrimaryPerPhoneType | Indicates whether this is the primary phone of the phone type. Y for primary contact, N for all others. |
| RawPhoneNumber | The unformatted phone number. |
| RelationshipId | The relationship identifier for the record. |
| StartDate | Indicates the date from which this entity is active. This date is inclusive and the status of an entity is dependent on this. |
| Status | Indicates the status of the contact point status. Typically values are active, inactive, delete. |
| TelexNumber | The telex reference number which is usually a phone number of the organization. |
| TimezoneCode | The contact point's time zone. It's a foreign key to FND_TIMEZONES_B.TIMEZONE_CODE. |
| TransposedPhoneNumber | This column stores the concatenation of PHONE_COUNTRY_CODE, PHONE_AREA_CODE, and PHONE_NUMBER in reverse order. For example, if PHONE_COUNTRY_CODE is 1, PHONE_AREA_CODE is 650 and PHONE_NUMBER is 5065747, this column stores 74756050561. This column is used for building an index to search for any combination of the above three columns. |
| Url | Indicates the URL associated with the contact point. |
| UserLastUpdateDate | The date and time when the contact point row was last updated. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database such as a different mobile database or the server. |
| WebType | The prefix class to a web address. Typically this is either FTP or HTTP. |