Table 186. Retrieve Contact ASI Fields
Name
|
XML Tag
|
Data Type
|
Length
|
Req.
|
Notes
|
Contact
|
Contact
|
|
|
|
User key fields:
- First Name
- Last Name
- Middle Name
- Party UId
|
Account Id
|
AccountId
|
DTYPE_ID
|
15
|
|
|
Alias
|
Alias
|
DTYPE_TEXT
|
50
|
|
|
Assistant
|
Assistant
|
DTYPE_TEXT
|
50
|
|
|
Assistant Phone #
|
AssistantPhone
|
DTYPE_TEXT
|
40
|
|
|
Cellular Phone #
|
CellularPhone
|
DTYPE_TEXT
|
40
|
|
|
Conflict Id
|
ConflictId
|
DTYPE_ID
|
15
|
|
This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.
|
Created
|
Created
|
DTYPE_DATETIME
|
7
|
|
This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.
|
Email Address
|
ContactEmailAddress1
|
DTYPE_TEXT
|
50
|
|
|
Email Address 2
|
ContactEmailAddress2
|
DTYPE_TEXT
|
50
|
|
|
Fax Phone #
|
FaxPhone
|
DTYPE_TEXT
|
40
|
|
|
First Name
|
FirstName
|
DTYPE_TEXT
|
50
|
Y
|
User key field for Contact.
|
Home Phone #
|
HomePhone
|
DTYPE_TEXT
|
40
|
|
|
Id
|
Id
|
DTYPE_ID
|
15
|
|
This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.
|
Integration Id
|
IntegrationId
|
DTYPE_TEXT
|
30
|
|
|
Job Title
|
JobTitle
|
DTYPE_TEXT
|
75
|
|
|
Language Code
|
LanguageCode
|
DTYPE_TEXT
|
20
|
|
|
Language Id
|
LanguageId
|
DTYPE_ID
|
15
|
|
|
Last Name
|
LastName
|
DTYPE_TEXT
|
50
|
Y
|
User key field for Contact.
|
M/F
|
MF
|
DTYPE_TEXT
|
255
|
|
Bound by SEX_MF LOV.
|
M/M
|
MM
|
DTYPE_TEXT
|
15
|
|
Bound by MR_MS LOV.
|
Maiden Name
|
MaidenName
|
DTYPE_TEXT
|
50
|
|
|
Middle Name
|
MiddleName
|
DTYPE_TEXT
|
50
|
|
User key field for Contact.
|
Mod Id
|
ModId
|
DTYPE_ID
|
15
|
|
This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.
|
Party UId
|
PartyUId
|
DTYPE_TEXT
|
30
|
Y
|
Pre Default Value: Field: 'Id'.
User key field for Contact.
|
Person UId
|
PersonUId
|
DTYPE_TEXT
|
100
|
Y
|
Pre Default Value: Field: 'Id'.
|
Personal Contact
|
PersonalContact
|
DTYPE_BOOL
|
1
|
|
|
Preferred Communication Method
|
PreferredCommunicationMethod
|
DTYPE_TEXT
|
20
|
|
Bound by COMM_METHOD LOV.
|
Primary Group/Household Id
|
PrimaryGroupHouseholdId
|
DTYPE_ID
|
15
|
|
|
Primary Personal Address Id
|
PrimaryPersonalAddressId
|
DTYPE_ID
|
15
|
|
|
Primary Position Id
|
PrimaryPositionId
|
DTYPE_ID
|
15
|
|
|
Social Security Number
|
SocialSecurityNumber
|
DTYPE_TEXT
|
20
|
|
|
Status
|
Status
|
DTYPE_TEXT
|
30
|
|
Bound by CONTACT_STATUS.
|
Suppress All Calls
|
SuppressAllCalls
|
DTYPE_BOOL
|
1
|
|
|
Suppress All Emails
|
SuppressAllEmails
|
DTYPE_BOOL
|
1
|
|
|
Suppress All Faxes
|
SuppressAllFaxes
|
DTYPE_BOOL
|
1
|
|
|
Suppress All Mailings
|
SuppressAllMailings
|
DTYPE_BOOL
|
1
|
|
|
Suppress Share
|
SuppressShare
|
DTYPE_BOOL
|
1
|
|
|
Time Zone Id
|
TimeZoneId
|
DTYPE_ID
|
15
|
|
|
Updated
|
Updated
|
DTYPE_DATETIME
|
7
|
|
This read-only field is automatically populated by the Siebel application on insertion and cannot be updated.
|
Work Phone #
|
WorkPhone
|
DTYPE_TEXT
|
40
|
|
|
Work Phone Extension
|
WorkPhoneExtension
|
DTYPE_TEXT
|
10
|
|
|
Operation
|
Operation
|
DTYPE_TEXT
|
30
|
|
System field.
|
Searchspec
|
Searchspec
|
DTYPE_TEXT
|
250
|
|
System field.
|
Contact_Account
|
ContactAccount
|
|
|
|
Integration component.
User key field: Account Row Id.
|
Account
|
Account
|
DTYPE_TEXT
|
100
|
|
|
Account Location
|
AccountLocation
|
DTYPE_TEXT
|
50
|
|
|
Account Party UId
|
AccountPartyUId
|
DTYPE_TEXT
|
30
|
|
|
Account Row Id
|
AccountRowId
|
DTYPE_ID
|
15
|
|
User key field for Contact Account.
|
Account Status
|
AccountStatus
|
DTYPE_TEXT
|
30
|
|
Bound by ACCOUNT_STATUS.
|
IsPrimaryMVG
|
IsPrimaryMVG
|
DTYPE_TEXT
|
1
|
|
System field.
|
Operation
|
Operation
|
DTYPE_TEXT
|
30
|
|
System field.
|
Searchspec
|
Searchspec
|
DTYPE_TEXT
|
250
|
|
System field.
|
Contact_Household
|
ContactHousehold
|
|
|
|
Integration component.
User key field: Household Id.
|
Household Id
|
HouseholdId
|
DTYPE_ID
|
15
|
|
User key field for Contact Household.
|
Household Integration Id
|
HouseholdIntegrationId
|
DTYPE_TEXT
|
100
|
|
|
Household Number
|
HouseholdNumber
|
DTYPE_TEXT
|
100
|
|
|
Household Party UId
|
HouseholdPartyUId
|
DTYPE_TEXT
|
30
|
|
|
Household Status
|
HouseholdStatus
|
DTYPE_TEXT
|
30
|
|
Bound by HOUSEHOLD_STATUS.
|
Households
|
Households
|
DTYPE_TEXT
|
50
|
|
|
IsPrimaryMVG
|
IsPrimaryMVG
|
DTYPE_TEXT
|
1
|
|
System field.
|
Operation
|
Operation
|
DTYPE_TEXT
|
30
|
|
System field.
|
Searchspec
|
Searchspec
|
DTYPE_TEXT
|
250
|
|
System field.
|
Contact_INS Personal Address
|
|
|
|
|
Integration component.
User key field: INS Personal Address Id.
|
INS Personal Address Id
|
INSPersonalAddressId
|
DTYPE_ID
|
15
|
|
User key field for Contact INS Personal Address.
|
INS Personal Address Name
|
INSPersonalAddressName
|
DTYPE_TEXT
|
100
|
|
|
INS Personal Address Type
|
INSPersonalAddressType
|
DTYPE_TEXT
|
30
|
|
|
INS Personal City
|
INSPersonalCity
|
DTYPE_TEXT
|
50
|
|
|
INS Personal Country
|
INSPersonalCountry
|
DTYPE_TEXT
|
50
|
|
|
INS Personal County
|
INSPersonalCounty
|
DTYPE_TEXT
|
50
|
|
Bound by COUNTRY LOV.
|
INS Personal Integration Id
|
INSPersonalIntegrationId
|
DTYPE_TEXT
|
30
|
|
|
INS Personal Postal Code
|
INSPersonalPostalCode
|
DTYPE_TEXT
|
30
|
|
|
INS Personal State
|
INSPersonalState
|
DTYPE_TEXT
|
10
|
|
Bound by STATE_ABBREV LOV.
|
INS Personal Street Address
|
ContactINSPersonalStreetAddress1
|
DTYPE_TEXT
|
200
|
|
|
INS Personal Street Address2
|
ContactINSPersonalStreetAddress2
|
DTYPE_TEXT
|
100
|
|
|
IsPrimaryMVG
|
IsPrimaryMVG
|
DTYPE_TEXT
|
1
|
|
System field.
|
Operation
|
Operation
|
DTYPE_TEXT
|
30
|
|
System field.
|
Searchspec
|
Searchspec
|
DTYPE_TEXT
|
250
|
|
System field.
|
Contact_Communication Address
|
|
|
|
|
Integration component.
User key fields:
- Alternate Email Address
- Communication Address Medium Type
- Communication Address Name.
|
Alternate Email Address
|
AlternateEmailAddress
|
DTYPE_TEXT
|
100
|
|
User key field for Contact Communication Address.
|
Communication Address Id
|
CommunicationAddressId
|
DTYPE_ID
|
15
|
|
|
Communication Address Integration Id
|
CommunicationAddressIntegrationId
|
DTYPE_TEXT
|
30
|
|
|
Communication Address Medium Type
|
CommunicationAddressMediumType
|
DTYPE_TEXT
|
30
|
|
User key field for Contact Communication Address.
|
Communication Address Name
|
CommunicationAddressName
|
DTYPE_TEXT
|
10
|
|
User key field for Contact Communication Address.
|
Communication Address Person Id
|
CommunicationAddressPersonId
|
DTYPE_ID
|
15
|
|
|
IsPrimaryMVG
|
IsPrimaryMVG
|
DTYPE_TEXT
|
1
|
|
System field.
|
Operation
|
Operation
|
DTYPE_TEXT
|
30
|
|
System field.
|
Searchspec
|
Searchspec
|
DTYPE_TEXT
|
250
|
|
System field.
|
