*
1
*
*
1
*
1
1
*
1
*
1
*
1
1
1
1
1
*
1
*
*
1
1
*
1
*
*
1
*
expireDate
verifyHash
emailAddress*
EmailAddressVerification
1
*
*
1
*
1
1
*
1
*
*
1
1
*
*
1
attrValue
attrName*
contactMechId*
ContactMechAttribute
contactMechIdTo*
contactMechIdFrom*
ContactMechLink
PartyContactMechPurpose
ContactMechTypePurpose
description
contactMechPurposeTypeId*
ContactMechPurposeType
attrName*
contactMechTypeId*
ContactMechTypeAttr
contactMechPurposeTypeId*
contactMechTypeId*
ContactMechTypePurpose
thruDate
fromDate*
contactMechPurposeTypeId*
contactMechId*
partyId*
PartyContactMechPurpose
contactMechTypeId*
roleTypeId*
ValidContactMechRole
CommEventContentAssoc
description
commContentAssocTypeId*
CommContentAssocType
communicationEventId*
productId *
CommunicationEventProduct
description
communicationEventId*
communicationEventPrpTypId*
CommunicationEventPurpose
roleTypeId *
partyId *
communicationEventId*
CommunicationEventRole
PostalAddress
PartyContactMechPurpose
PartyContactMech
ToContactMechLink
FromContactMechLink
ContactMechAttribute
infoString
contactMechTypeId
contactMechId*
TelecomNumber
ContactMech
PartyContactMech
askForName
contactNumber
areaCode
countryCode
contactMechId*
PartyContactMechPurpose
TelecomNumber
PostalAddressBounda
ry
PartyContactMechPurpose
PartyContactMech
postalCodeGeoId
countyGeoId
stateProvinceGeoId
countryGeoId
postalCodeExt
postalCode
city
directions
address2
address1
attnName
toName
contactMechId*
PostalAddressBoundary
PostalAddress
yearsWithContactMech
comments
verified
extension
allowSolicitation
roleTypeId
thruDate
fromDate*
contactMechId*
partyId*
monthsWithContactMech
PartyContactMech
messageId
bccString
ccString
toString
fromString
headerString
contactListId
reasonEnumId
note
content
contentMimeTypeId
subject
datetimeEnded
datetimeStarted
entryDate
partyIdTo
partyIdFrom
roleTypeIdTo
roleTypeIdFrom
contactMechIdTo
contactMechIdFrom
contactMechTypeId
statusId
parentCommEventId
origCommEventId
communicationEventTypeId
communicationEventId*
CommunicationEventPurpose
CommunicationEventProduct
CommEventContentAssoc
CommunicationEventRole
CommunicationEvent
ChildCommunicationEventType
CommunicationEvent
description
parentTypeId
communicationEventTypeId*
hasTable
CommunicationEventType
sequenceNum
thruDate
fromDate*
communicationEventId*
contentId *
commContentAssocTypeId
CommEventContentAssoc
CommunicationEventPurpose
ChildCommunicationEventPrpTyp
description
parentTypeId
communicationEventPrpTypId*
hasTable
CommunicationEventPrpTyp
DOMAIN_NAME Internet Domain Name
ELECTRONIC_ADDRESS Electronic Address
EMAIL_ADDRESS Email Address
IP_ADDRESS Internet IP Address
POSTAL_ADDRESS Postal Address
TELECOM_NUMBER Phone Number
WEB_ADDRESS Web URL/Address
BILLING_EMAIL Billing (AP) Email
BILLING_LOCATION Billing (AP) Address
FAX_NUMBER Main Fax Number
FAX_NUMBER_SEC Secondary Fax Number
GENERAL_LOCATION General Correspondence Address
ORDER_EMAIL Order Notification Email Address
OTHER_EMAIL Other Email Address
PAYMENT_EMAIL Payment (AR) Email
PAYMENT_LOCATION Payment (AR) Address
PHONE_ASSISTANT Assistant's Phone Number
PHONE_BILLING Billing (AP) Phone Number
PHONE_DID Direct Inward Dialing Phone Number
PHONE_HOME Main Home Phone Number
PHONE_MOBILE Main Mobile Phone Number
PHONE_PAYMENT Payment (AR) Phone Number
PHONE_QUICK Quick Calls Phone Number
PHONE_SHIP_ORIG Shipping Origin Phone Number
PHONE_SHIPPING Shipping Destination Phone Number
PHONE_WORK Main Work Phone Number
PHONE_WORK_SEC Secondary Work Phone Number
PREVIOUS_LOCATION Previous Address
PRIMARY_EMAIL Primary Email Address
PRIMARY_LOCATION Primary Address
PRIMARY_PHONE Primary Phone Number
PRIMARY_WEB_URL Primary Website URL
PUR_RET_LOCATION Purchase Return Address
SHIP_ORIG_LOCATION Shipping Origin Address
SHIPPING_LOCATION Shipping Destination Address
AUTO_EMAIL_COMM Auto Email
COMMENT_NOTE Comment/Note
EMAIL_COMMUNICATION Email
FACE_TO_FACE_COMMUNI Face-To-Face
FAX_COMMUNICATION Fax
LETTER_CORRESPONDENC Letter
PHONE_COMMUNICATION Phone
WEB_SITE_COMMUNICATI Web Site
ACTIVITY_REQUEST Activity Reuest
CONFERENCE Conference
CUSTOMER_SERVICE_CAL Customer Service Call
INQUIRY Inquiry
MEETING Meeting
SALES_FOLLOW_UP Sales Follow Up
SEMINAR Seminar
SUPPORT_CALL Support Call
COM_EVENT_STATUS
COM_CANCELLED Cancelled
COM_COMPLETE Complete
COM_ENTERED Entered
COM_IN_PROGRESS In-Progress
COM_PENDING Pending
COM_READ Read
COM_REFERRED Referred
COM_RESOLVED Resolved
COM_UNKNOWN_PARTY Unknown Party
ContactMechTypePurpose
ChildContactMechType
ContactMech
description
hasTable
parentTypeId
contactMechTypeId*
ValidContactMechRole
ContactMechType
ContactMechTypeAttr
geoId *
contactMechId*
PostalAddressBoundary
Detail Party: Contact Entities
Detail Party: Communication Entities
*
*
*
1
*
1
*
1
1
*
*
1
1
UserLoginSecurityGroup
SecurityGroupPermission
description
groupId*
SecurityGroup
permissionId*
groupId*
SecurityGroupPermission
SecurityGroupPermission
description
permissionId*
SecurityPermission
contactMechId *
UserLoginSecurityGroup
UserLoginPasswordHistory
UserLoginHistory
partyId
successiveFailedLogins
disabledDateTime
lastTimeZone
lastLocale
lastCurrencyUom
requirePasswordChange
hasLoggedOut
enabled
isSystem
passwordHint
currentPassword
userLoginId*
UserLoginSession
UserLogin
successfulLogin
passwordUsed
thruDate
fromDate*
visitId
userLoginId*
partyId
UserLoginHistory
currentPassword
thruDate
fromDate*
userLoginId*
UserLoginPasswordHistory
thruDate
fromDate*
groupId*
userLoginId*
UserLoginSecurityGroup
sessionData
savedDate
userLoginId*
UserLoginSession
1
Detail Party: User Login, Security, and Permissions Entities
Page 9