Oracle Sales Cloud Connector Objects

note: This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms. If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at datacloud-connectors-beta@salesforce.com.

Objects Supported

Name	Description
AccountAddresses	The address resource is used to view, create, and update addresses of an account. An address represents the location information of an account.
AccountAddressPurposes	The address purpose resource is used to view, create, or modify the address purpose. The address purpose describes the use of an address, such as shipping address or billing address.
AccountAttachments	An attachment includes additional information about an account.
AccountContactPoints	The contact point resource is used to view, create, update, and delete contact points for an account. Contact points can be geographical addresses, phone numbers, e-mail IDs, URLs, messenger IDs, and so on.
AccountHierarchy	The account hierarchy summaries resource is used to view the account hierarchy information.
AccountNotes	The note resource is used to capture comments, information, or instructions for an account.
AccountOrganizationContacts	The account contacts resource is used to view, create, update, and delete an account contact. It refers to a person who functions as a contact for an account.
AccountPrimaryAddresses	The primary address resource is used to view, create, and update primary address of an account. A primary address is the default communication address of an account.
AccountRelationships	The relationship resource is used to view, create, and update account relationships.
AccountResources	The sales team member resource represents a resource party and is assigned to a sales account team. A sales account team member has a defined access role for the sales account.
Accounts	The sales team member resource represents a resource party and is assigned to a sales account team. A sales account team member has a defined access role for the sales account.
Activities	Table to capture task and appointment information.
ActivityAssignees	Table used to capture the assignees/resources associated to the activity.
ActivityAttachments	An attachment includes additional information about an activity
ActivityContacts	Table used to capture the contacts associated to the activity.
ActivityFunctionLookups	Usage information for the operation ActivityFunctionLookups.rsd.
ActivityNotes	Note data objects that capture comments, information or instructions for an Oracle Fusion Applications business object.
ActivityObjectives	Table used to capture the objectives associated to the activity.
Assets	Usage information for the operation Assets.rsd.
CatalogProductGroups	Usage information for the operation CatalogProductGroups.rsd.
CompetitorAccounts	The competitor accounts resource is used to view, create, and update a competitor account and manage competitor details.
ContactAddresses	Table that includes attributes used to store values while creating or updating an address. An address represents the location information of an account, contact or household.
ContactAddressPurposes	The address purpose resource is used to view, create, or modify the address purpose. The address purpose describes the use of an address, such as shipping address or billing address.
ContactAttachments	An attachment includes additional information about a contact.
ContactContactPoints	The contact point resource is used to view, create, update, and delete contact points for an account. Contact points can be geographical addresses, phone numbers, e-mail IDs, URLs, messenger IDs, and so on.
ContactNotes	The note resource is used to capture comments, information, or instructions for a contact.
ContactPrimaryAddresses	The primary address resource is used to view, create, or modify a primary address of a contact. A primary address is the default communication address of an entity.
ContactRelationships	The relationship resource includes attributes that are used to store values while viewing, creating, or updating a relationship.
Contacts	Table resource items include attributes used to store values while creating or updating a contact.
ContactSalesAccountResources	The sales team member resource represents a resource party and is assigned to a sales account team. A sales account team member has a defined access role for the sales account.
ContactsPictureAttachments	The contact picture attachment resource is used to view, create, and update the resource's picture.Get a resource's picture
EmployeeResourceAttachments	The contact picture attachment resource is used to view, create, and update the resource's picture.Get a resource's picture
EmployeeResources	The resources resource is used to view, create, and update a resource. A resource is a person within the deploying company who can be assigned work to accomplish business objectives, such as sales persons or partner members. The EmployeeResources is deprecated, please use Resources view to access resource data.
Leads	Usage information for the operation Leads.rsd.
LightboxDocuments	Usage information for the operation LightboxDocuments.rsd.
Opportunities	The opportunity competitor resource is used to view, create, and update the competitors for an opportunity. The opportunity competitors is used to store information about the competitors associated with the opportunity.
OpportunityAssessments	The assessments resource is used to view, create, update, and delete the assessment of an opportunity.
OpportunityAttachments	An attachment includes additional information about an opportunity.
OpportunityCampaigns	The opportunity campaigns resource is used to view, create, update, and delete campaigns associated with an opportunity.
OpportunityCompetitors	The opportunity competitor resource is used to view, create, and update the competitors for an opportunity. The opportunity competitors is used to store information about the competitors associated with the opportunity.
OpportunityContacts	The opportunity contact resource is used to view, create, and update the contacts of an opportunity.The contact associated with the opportunity. You can specify a contact's role, affinity, and influence level on an opportunity. A single contact can be marked as primary.
OpportunityDeals	A deal associated with the opportunity.
OpportunityLeads	The opportunity lead resource is used to view, create, and update the lead that resulted in an opportunity.
OpportunityNotes	The note resource is used to capture comments, information, or instructions for an opportunity.
OpportunityPartners	The opportunity partner resource is used to view, create, and update the partners associated with this opportunity.The opportunity partner is used to store information about partners who are contributing to the selling effort of the current opportunity.
OpportunityRevenueItems	The revenue items resource is used to view, create, and update revenue items of an opportunity. The revenue items associated with opportunities are products, services, or other items a customer might be interested in purchasing. You add revenue items by selecting a product group or product to associate with an opportunity.
OpportunityRevenueItemsChildSplitRevenue	The child split revenue resource is used to view, create, update, and delete a split revenue. The revenue or nonrevenue credit is allocated to the resource which has contributed to the selling effort for an opportunity revenue line.
OpportunityRevenueItemsRecurringRevenues	The recurring revenues resource is used to view, create, update, and delete a recurring revenue. The revenues that span over a period of time sourced from the same product on an opportunity.
OpportunityRevenueProductGroups	The product group resource is used to view, create, and update the product groups associated with an opportunity. The product group let you categorize products and services that you sell.
OpportunityRevenueProducts	The following table describes the default response for this task.
OpportunityRevenueTerritories	The opportunity revenue territories resource is used to view, create, and update the revenue territories of an opportunity. The territories assigned to an opportunity revenue line. The territories provide the rules for automatically assigning salespeople and other resources to customers, partners, leads, and opportunity line items.
OpportunitySources	The opportunity source resource is used to view, create, and update the source of an opportunity.The opportunity source is used to capture the marketing or sales campaign that resulted in this opportunity.
OpportunityTeamMembers	The opportunity team members resource is used to view, create, and update the team members associated with an opportunity. The opportunity team member of the deploying organization associated with the opportunity.
PartnerContacts	Usage information for the operation PartnerContacts.rsd.
PartnerProgramBenefits	Usage information for the operation PartnerProgramBenefits.rsd.
PartnerPrograms	Usage information for the operation PartnerPrograms.rsd.
Partners	Usage information for the operation Partners.rsd.
ProgramEnrollments	Usage information for the operation ProgramEnrollments.rsd.
Proposals	Usage information for the operation Proposals.rsd.
Resources	The resources resource is used to view, create, and update a resource. A resource is a person within the deploying company who can be assigned work to accomplish business objectives, such as sales persons or partner members.
ResourceUsers	The resource users REST resource is used to view, create, update, and delete a resource user. Note that this REST resource should be used only to work with Oracle CX Sales and B2B Service, and not for any other product family.
ResourceUsersResourceRoleAssignments	The resource role assignments resource is used to view the role assigned to a resource, such as implementer, reseller, and so on.
SalesLeadAttachments	The attachment resource is used to view, create, and update attachments of a sales lead.
SalesLeadContacts	The sales lead contacts resource is used to capture a contact associated with the sales lead.
SalesLeadResources	The sales lead resources data object (resource) is used to capture a resource associated with the sales lead team.
SalesLeads	The sales lead resource is used to view, create, or modify a lead. A lead is a transaction record created when a party has expressed an interest in a product or service. It represents a selling opportunity.
SalesLeadsLeadCampaigns	The lead campaign resource is used to view, create, update, and delete the association of a campaign with a lead.
SalesLeadsLeadCompetitors	The lead competitors resource is used to view, create, update, and delete the association of a campaign with a lead.
SalesLeadsLeadOpportunity	The opportunity resource is used to view, create, or modify an opportunity generated from a lead. An opportunity list associated with the lead represents leads that have already been converted to the list of opportunities.
SalesLeadsLeadQualifications	The assessments resource is used to view, create and update qualifications of a lead.
SalesLeadsLeadTeam	The lead teams resource is used to view the team members and territory team members associated with a lead.
SalesLeadsNotes	The note resource is used to capture comments, information, or instructions for a sales lead.
SalesLeadsProductGroups	The product groups resource is used to capture the name of the product group associated with the sales lead.
SalesLeadsProducts	The product resource is used to capture the name of the product associated with the sales lead.
SalesLeadTerritories	The sales lead territories resource is used to view the associated sales lead territories.
SalesOrders	Usage information for the operation SalesOrders.rsd.
ServiceDetails	Usage information for the operation ServiceDetails.rsd.
ServiceProviders	Usage information for the operation ServiceProviders.rsd.
Signatures	The signatures resource is used to view, create, update, and delete a signature for an agent
Territories	The sales territories resource represents the list of sales territories that the logged-in user can view. A sales territory is an organizational domain with boundaries defined by attributes of customers, products, services, resources, and so on. Sales territories can be created based on multiple criteria including postal code, area code, country, vertical market, size of company, product expertise, and geographical location. Sales territories form the fundamental infrastructure of sales management as they define the jurisdiction that salespeople have over sales accounts, or the jurisdiction that channel sales managers have over partners and partner transactions.
TerritoryForecasts	The forecasts resource is used to view or modify a forecast territory.
TerritoryResources	The resources resource is used to view the resources, such as owner or sales people associated with a sales territory.

AccountAddresses

Name	Type	ReadOnly	References	FilterOnly	Description
AddressNumber [KEY]	String	False		No	This is the primary key of the addresses table.
PartyNumber [KEY]	String	False	Accounts.PartyNumber	No	The unique alternate identifier for the account party. You can update the value if the profile option HZ_GENERATE_PARTY_NUMBER is set to True. The default value is a concatenation of the value specified in the profile option ZCA_PUID_PREFIX and a unique system generated sequence number.
AddrElementAttribute1	String	False		No	An additional address element to support flexible address format.
AddrElementAttribute2	String	False		No	An additional address element to support flexible address format.
AddrElementAttribute3	String	False		No	An additional address element to support flexible address format.
AddrElementAttribute4	String	False		No	An additional address element to support flexible address format.
AddrElementAttribute5	String	False		No	An additional address element to support flexible address format.
Address1	String	False		No	The first line for address.
Address2	String	False		No	The second line for address.
Address3	String	False		No	The third line for address.
Address4	String	False		No	The fourth line for address.
AddressId	Long	False		No	The unique identifier of the address.
AddressLinesPhonetic	String	False		No	The phonetic or Kana representation of the Kanji address lines. This is used for addresses in Japan.
Building	String	False		No	The building name or number in the address.
City	String	False		No	The city in the address.
ClliCode	String	False		No	The Common Language Location Identifier (CLLI) code of the address. The code is used within the North American to specify the location of the address.
Comments	String	False		No	The user-provided comments for the address.
CorpCurrencyCode	String	False		No	The corporate currency code used by the CRM Extensibility framework.
Country	String	False		No	The country code of the address. Review the list of country codes using the Manage Geographies task.
CreatedBy	String	False		No	The user who created the account record.
CreatedByModule	String	False		No	The module that created the account record.
CreationDate	Datetime	False		No	The date when the record was created.
CurcyConvRateType	String	False		No	The currency conversion rate type. This attribute is used by CRM Extensibility framework. A list of valid values are defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
CurrencyCode	String	False		No	The currency code. This attribute is used by CRM Extensibility framework. A list of valid values are defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
DateValidated	Date	False		No	The date when the address was last validated.
Description	String	False		No	The description of the location.
DoNotMailFlag	Boolean	False		No	Indicates whether the address should not be used for mailing.
EffectiveDate	Date	False		No	The date when the address becomes active.
EndDateActive	Date	False		No	The date after which the address becomes inactive.
FloorNumber	String	False		No	The floor number of the address.
FormattedAddress	String	False		No	The formatted version of the address.
FormattedMultilineAddress	String	False		No	The formatted multiline version of the address.
HouseType	String	False		No	Indicates the building type for the building in the address. A list of valid values are defined in the lookup HZ_HOUSE_TYPE. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
LastUpdateDate	Datetime	False		No	The date when the record was last updated.
LastUpdatedBy	String	False		No	The user who last updated the record.
LastUpdateLogin	String	False		No	The login of the user who last updated the record.
Latitude	Double	False		No	The latitude information for the address. The latitude information for the location is used for spatial proximity and containment purposes.
LocationDirections	String	False		No	The directions to the address location.
LocationId	Long	False		No	The unique identifier for the location.
Longitude	Double	False		No	The longitude information for the address. The longitude information for the location is used for spatial proximity and containment purposes.
Mailstop	String	False		No	The user-defined code that indicates a mail drop point within the organization.
ObjectVersionNumber	Long	False		No	The number used to implement 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 determine whether another session has updated the row.
PartyId	Long	False		No	The unique identifier of the account associated with the address.
PartySourceSystem	String	False		No	The name of external source system where the account, associated with the address, party is imported from. The values configured in setup task Trading Community Source System.
PartySourceSystemReferenceValue	String	False		No	The unique identifier for the account, associated with the address, from the external source system specified in the attribute PartySourceSystem.
PostalCode	String	False		No	The postal code of the address.
PostalPlus4Code	String	False		No	The four-digit extension to the United States Postal ZIP code for the address.
PrimaryFlag	Boolean	False		No	Indicates whether this is the primary address of the account. If the value is Y, this address is the primary address of the account. The default value is N.
Province	String	False		No	The province of the address.
SourceSystem	String	False		No	The name of external source system where the address is imported from. The values configured in setup task Trading Community Source System.
SourceSystemReferenceValue	String	False		No	The unique identifier for the address from the external source system specified in the attribute PartySourceSystem.
StartDateActive	Date	False		No	The date when the address becomes active.
State	String	False		No	The state of the address.
Status	String	False		No	The internal flag indicating status of the address. The status codes are defined by the lookup HZ_STATUS.
ValidatedFlag	Boolean	False		No	Indicates whether the location is validated. The value is internally set by system during address cleansing. If the value is Y, then the address is validated. The default value is N.
ValidationStartDate	Date	False		No	The date when the validation becomes active. The value is internally set by system during address cleansing.
ValidationStatusCode	String	False		No	A standardized status code describing the results of the validation. The value is internally set by system during address cleansing.
AccountLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
Finder	String	False		Yes	Input specifying the Finder type.
FocusPartyId	String	False		Yes	The unique identifier of the child account to be returned at the top by the Direct Accounts finder.
ParentPartyId	String	False		Yes	The unique identifier of the account used to search the direct child accounts.
BindUserPartyId	String	False		Yes	The unique identifier of the party. Used in MyAccounts finder.
OrganizationProfileId	String	False		Yes	The unique identifier of the organization.

Return to Top

AccountAddressPurposes

Name	Type	ReadOnly	References	FilterOnly	Description
AddressPurposeId [KEY]	Long	False		No	This is the primary key of the address purpose table.
PartyNumber [KEY]	String	False	Accounts.PartyNumber	No
AddressNumber [KEY]	String	False	AccountAddresses.AddressNumber	No
DeleteFlag	Boolean	False		No	Indicates whether the address purpose is to be deleted. If the value is Y, then the address purpose has to be deleted. The default value is N.
Purpose	String	False		No	The purpose of the address. A list of valid values is defined in the lookup PARTY_SITE_USE_CODE. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
AccountLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
SourceSystem	String	False		No	The name of external source system for the address purpose denoted by a code, which is defined by an administrator as part of system setup.
SourceSystemReferenceValue	String	False		No	The unique identifier for the address purpose from the external source.
Finder	String	False		Yes	Input specifying the Finder type.
FocusPartyId	String	False		Yes	The unique identifier of the child account to be returned at the top by the Direct Accounts finder.
ParentPartyId	String	False		Yes	The unique identifier of the account used to search the direct child accounts.
PartyId	String	False		Yes	The unique identifier of the account.
BindUserPartyId	String	False		Yes	The unique identifier of the party. Used in MyAccounts finder.
OrganizationProfileId	String	False		Yes	The unique identifier of the organization.

Return to Top

AccountAttachments

Name	Type	ReadOnly	References	FilterOnly	Description
AttachedDocumentId [KEY]	Long	True		No	The unique identifier of the attached document.
PartyNumber [KEY]	String	False	Accounts.PartyNumber	No	The unique alternate identifier for the account party.
AsyncTrackerId	String	False		No	Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files.
CategoryName	String	False		No	The category of the attachment.
ContentRepositoryFileShared	Bool	False		No	Indicates whether the attachment is shared
CreatedBy	String	True		No	The user who created the record.
CreatedByUserName	String	True		No	The user name who created the record.
CreationDate	Datetime	True		No	The date when the record was created.
DatatypeCode	String	False		No	A value that indicates the data type.
Description	String	False		No	The description of the attachment.
DmDocumentId	String	False		No	The document ID from which the attachment is created.
DmFolderPath	String	False		No	The folder path from which the attachment is created.
DmVersionNumber	String	False		No	The document version number from which the attachment is created.
DownloadInfo	String	False		No	JSON object represented as a string containing information used to programmatically retrieve a file attachment.
ErrorStatusCode	String	False		No	The error code, if any, for the attachment.
ErrorStatusMessage	String	False		No	The error message, if any, for the attachment.
ExpirationDate	Datetime	False		No	The expiration date of the contents in the attachment.
FileContents	String	False		No	The contents of the attachment.
FileName	String	False		No	The file name of the attachment.
FileUrl	String	False		No	The URI of the file.
FileWebImage	String	True		No	The base64 encoded image of the file displayed in .png format if the source is a convertible image.
LastUpdateDate	Datetime	True		No	The date when the record was last updated.
LastUpdatedBy	String	True		No	The user who last updated the record.
LastUpdatedByUserName	String	True		No	The user name who last updated the record.
PostProcessingAction	String	False		No	The name of the action that can be performed after an attachment is uploaded.
Title	String	False		No	The title of the attachment.
UploadedFileContentType	String	False		No	The content type of the attachment.
UploadedFileLength	Long	False		No	The size of the attachment file.
UploadedFileName	String	False		No	The name to assign to a new attachment file.
UploadedText	String	False		No	The text content for a new text attachment.
Uri	String	False		No	The URI of a Topology Manager type attachment.
Url	String	False		No	The URL of a web page type attachment.
UserName	String	True		No	The login credentials of the user who created the attachment.
AccountLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
Finder	String	False		Yes	Input specifying the Finder type.
FocusPartyId	String	False		Yes	The unique identifier of the child account to be returned at the top by the Direct Accounts finder.
ParentPartyId	String	False		Yes	The unique identifier of the account used to search the direct child accounts.
BindUserPartyId	String	False		Yes	The unique identifier of the party. Used in MyAccounts finder.
OrganizationProfileId	String	False		Yes	The unique identifier of the organization.
PartyId	String	False		Yes	The unique identifier of the party associated to the given account.
SourceSystem	String	False		Yes	Name of external source system.
SourceSystemReferenceValue	String	False		Yes	Identifier for this record from external source system.

Return to Top

AccountContactPoints

Name	Type	ReadOnly	References	FilterOnly	Description
ContactPointId [KEY]	Long	True		No	The unique identifier of the contact point.
PartyNumber [KEY]	String	False	Accounts.PartyNumber	No	The unique alternate identifier for the account party.
ConflictId	Long	False		No	The unique identifier of the conflict for the contact point record. This number is used by mobile or portable applications that consume the web service.
ContactPointType	String	False		No	The type of Contact Point record. The accepted values are defined in the lookup type COMMUNICATION_TYPE. Sample values include PHONE, EMAIL, and WEB.
CreatedBy	String	True		No	The user who created the contact point record.
CreatedByModule	String	False		No	The application module that created this contact point record. Defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. You can review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
CreationDate	Datetime	True		No	The date when the record was created.
DoContactPreferenceFlag	Bool	False		No	Indicates whether to use a particular contact method. Defaulted to false.
DoNotContactPreferenceFlag	Bool	False		No	Indicates whether the record can be contacted.
DoNotContactReason	String	False		No	The reason code for the contact preference.
EmailAddress	String	False		No	The email address of the contact point record of type email.
EmailPurpose	String	False		No	The purpose of using the EMAIL contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE. The values can be ASSISTANT, PERSONAL, HOME_BUSINESS, BUSINESS, and so on.
FormattedPhoneNumber	String	True		No	The formatted phone number of the contact point.
LastUpdateDate	Datetime	True		No	The date when the record was last updated.
LastUpdateLogin	String	True		No	The login of the user who last updated the record.
LastUpdatedBy	String	True		No	The user who last updated the contact point record.
ObjectVersionNumber	Int	False		No	The number used to implement optimistic locking for contact point record. This number is incremented every time 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.
PartySourceSystem	String	False		No	The name of external source system of the account, contact or household with which the contact point is associated. Part of alternate key for the account, contact or household record along with PartyourceSystemReferenceValue. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems.
PartySourceSystemReferenceValue	String	False		No	The unique identifier from external source system for the account, contact or household with which the address is associated. Part of alternate key along with PartySourceSystem. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated.
PhoneAreaCode	String	False		No	The area code for the phone number.
PhoneCountryCode	String	False		No	The country code of the phone number.
PhoneExtension	String	False		No	The extension number of the phone line number like office desk extension.
PhoneNumber	String	False		No	The phone number of the contact point.
PhonePurpose	String	False		No	Defines the purpose of using the PHONE contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE.Sample values: ASSISTANT,PERSONAL,HOME_BUSINESS,BUSINESS etc.
PhoneType	String	False		No	The type of phone contact point. The accepted values are defined in the lookup type ORA_HZ_PHONE_TYPE. The values can be WORK, HOME, FAX, and so on.
PreferenceRequestedBy	String	False		No	Indicates if the permission or restriction was created internally or requested by the party. The list of accepted values are defined in the REQUESTED_BY lookup.
PrimaryFlag	Bool	False		No	Indicates whether this is the primary contact point of the associated object. If the value is True, then this is the primary contact point. The default value is False. If this attribute isn't explicitly mentioned in the payload, then the value of this attribute is set to null.
RawPhoneNumber	String	False		No	The raw phone number on the contact point record of type phone.
SocialNetworkId	String	False		No	The unique identifier of the social network.
SocialNetworkName	String	False		No	The name of the social network.
SocialNetworkPurpose	String	False		No	Defines the purpose of using the IM contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE.Sample values: ASSISTANT,PERSONAL,HOME_BUSINESS,BUSINESS etc.
SourceSystem	String	False		No	The name of external source system, which is defined by an administrator as part of system setup. It's part of alternate key along with SourceSystemReference, and is mandatory if PK or partyNumberBusinessKey isn't passed in update.
SourceSystemReferenceValue	String	False		No	The unique identifier for the contacts party from the external source system specified in the attribute SourceSystem. It's part of alternate key along with SourceSystemReference, and is mandatory if PK or partyNumberBusinessKey isn't passed in update.
Status	String	False		No	Indicates the status of the contact point. The status codes are defined in the lookup HZ_STATUS. The default value is A.
URL	String	False		No	The URL of the contact point.
VerificationDate	Date	False		No	The date of verification of the phone or email contact point.
VerificationStatus	String	False		No	The status of the verification for phone or email contact points. Accepted values are defined in the standard lookup type ORA_HZ_VALIDATION_STATUS as ORA_VALID, ORA_INVALID and ORA_PARTIALLY_VALID. The value ORA_PARTIALLY_VALID is applicable only for email. Default value is blank which indicates that values aren't verified.
WebPurpose	String	False		No	Defines the purpose of using the WEB contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE_WEB.Sample values: HOMEPAGE,SALESURL,MARKETINGURL,SUPPORTURL,RSS_FEED etc.
AccountLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
Finder	String	False		Yes	Input specifying the Finder type.
FocusPartyId	String	False		Yes	The unique identifier of the child account to be returned at the top by the Direct Accounts finder.
PartyId	String	False		Yes	The unique identifier of the party associated to the given account.
ParentPartyId	String	False		Yes	The unique identifier of the account used to search the direct child accounts.
BindUserPartyId	String	False		Yes	The unique identifier of the party. Used in MyAccounts finder.
OrganizationProfileId	String	False		Yes	The unique identifier of the organization.

Return to Top

AccountHierarchy

Name	Type	ReadOnly	References	FilterOnly	Description
PartyId [KEY]	Long	True		No	The unique identifier of the party associated to the given account.
PartyNumber [KEY]	String	False	Accounts.PartyNumber	No	The unique alternate identifier for the account party.
CreatedBy	String	True		No	The user who created the account hierarchy summary.
CreationDate	Datetime	True		No	The date and time when the account hierarchy summary was created.
LastUpdateDate	Datetime	True		No	The date and time when the account hierarchy summary was last updated.
LastUpdatedBy	String	True		No	The user who last updated the account hierarchy summary.
ParentAccountList	String	True		No	List of all the parent accounts till the top node in the account hierarchy.
ParentAccountName	String	True		No	The parent account name of the given account.
ParentAccountPartyId	Long	True		No	The parent account identifier of the given account.
ParentAccountPartyNumber	String	True		No	The parent account registry identifier of given account.
PartyUniqueName	String	True		No	The unique party name of the party record.
TotalChildAccounts	Int	True		No	The total number of child accounts.
TotalImmediateChildAccounts	Int	True		No	Total number of immediate child of given account.
UltimateParentName	String	True		No	The ultimate parent account name of given account.
UltimateParentPartyId	Long	True		No	The ultimate parent account identifier of given account.
UltimateParentPartyNumber	String	True		No	The ultimate parent account registry identifier of given account.
AccountLastUpdateDate	Datetime	True		No	The date and time when the opportunity was last updated.
Finder	String	False		Yes	Input specifying the Finder type.
FocusPartyId	String	False		Yes	The unique identifier of the child account to be returned at the top by the Direct Accounts finder.
ParentPartyId	String	False		Yes	The unique identifier of the account used to search the direct child accounts.
BindUserPartyId	String	False		Yes	The unique identifier of the party. Used in MyAccounts finder.
OrganizationProfileId	String	False		Yes	The unique identifier of the organization.
SourceSystem	String	False		Yes	Name of external source system.
SourceSystemReferenceValue	String	False		Yes	Identifier for this record from external source system.

Return to Top

AccountNotes

Name	Type	ReadOnly	References	FilterOnly	Description
NoteId [KEY]	Long	False		No	This is the primary key of the notes table.
PartyNumber [KEY]	String	False	Accounts.PartyNumber	No	The unique alternate identifier for the account party. You can update the value if the profile option HZ_GENERATE_PARTY_NUMBER is set to True. The default value is a concatenation of the value specified in the profile option ZCA_PUID_PREFIX and a unique system generated sequence number.
ContactRelationshipId	Long	False		No	The relationship ID populated when the note is associated with a contact.
CorpCurrencyCode	String	False		No	Holds Corporate Currency Code from profile.
CreatedBy	String	False		No	Indicates the user who created the row.
CreationDate	Datetime	False		No	Indicates the date and time of the creation of the row.
CreatorPartyId	Long	False		No	This is Party Id for the Note Creator.
CurcyConvRateType	String	False		No	Holds Currency Conversion Rate Type from profile.
CurrencyCode	String	False		No	Holds currency code of a record.
LastUpdateDate	Datetime	False		No	Indicates the date and time of the last update of the row.
AccountLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
NoteTxt	String	False		No	This is the column which will store the actual note text.
NoteTypeCode	String	False		No	This is the note type code for categorization of note.
PartyId	Long	False		No	Party identifier.
PartyName	String	False		No	Name of this party.
SourceObjectCode	String	False		No	This is the source_object_code for the source object as defined in OBJECTS Metadata.
SourceObjectId	String	False		No	This is the source_object_Uid for the source object (such as Activities, Opportunities etc) as defined in OBJECTS Metadata.
VisibilityCode	String	False		No	This is the attribute to specify the visibility level of the note.
Finder	String	False		Yes	Input specifying the Finder type.
FocusPartyId	String	False		Yes	The unique identifier of the child account to be returned at the top by the Direct Accounts finder.
ParentPartyId	String	False		Yes	The unique identifier of the account used to search the direct child accounts.
BindUserPartyId	String	False		Yes	The unique identifier of the party. Used in MyAccounts finder.
SourceSystem	String	False		Yes	Name of external source system.
SourceSystemReferenceValue	String	False		Yes	Identifier for this record from external source system.
OrganizationProfileId	String	False		Yes	The unique identifier of the organization.

Return to Top

AccountOrganizationContacts

Name	Type	ReadOnly	References	FilterOnly	Description
AccountContactId [KEY]	Long	True		No	The unique identifier of the account contact.
PartyNumber [KEY]	String	False	Accounts.PartyNumber	No	The unique alternate identifier for the account party.
AccountName	String	True		No	The name of the account.
AccountPartyId	Long	False		No	The primary key identifier of the object in this relationship.AC Either one of ObjectPartyId, ObjectPartyNumber, and combination of ObjectSourceSystem and ObjectSourceSystemReferenceValue, is used to identify the object party of the relationship.
AccountPartyNumber	String	False		No	The public unique identification number for the object party of the relationship. One of ObjectPartyId, ObjectPartyNumber, and a combination of ObjectSourceSystem and ObjectSourceSystemReferenceValue, is used to identify the object party of the relationship.
AccountSourceSystem	String	False		No	The name of external source system for the object party in the relationship, which are defined by an administrator as part of system setup. One of ObjectPartyId, ObjectPartyNumber, and a combination of ObjectSourceSystem and ObjectSourceSystemReferenceValue, is used to identify the object party of the relationship. The value for this attribute should be predefined using the setup task Manage Trading Community Source Systems.
AccountSourceSystemReferenceValue	String	False		No	The identifier for the object party in the relationship from external source system. One of ObjectPartyId, ObjectPartyNumber, and a combination of ObjectSourceSystem and ObjectSourceSystemReferenceValue, is used to identify the object party of the relationship.
AccountUniqueName	String	True		No	The unique name of the account.
Comments	String	False		No	The comments of the user.
ContactFirstName	String	True		No	The first name of the contact record.
ContactLastName	String	True		No	The last name of the contact record.
ContactLastUpdateDate	Datetime	True		No	The date when the contact record was last updated.
ContactName	String	True		No	The name of the contact.
ContactNumber	String	False		No	The user-defined identification number for this contact.
ContactPartyId	Long	False		No	The primary key identifier of the subject in this relationship. Either one of SubjectPartyId, SubjectPartyNumber, and a combination of SubjectSourceSystem and SubjectSourceSystemReferenceValue, is used to identify the subject party of the relationship.
ContactPartyNumber	String	False		No	The public key identifier for the subject party of the relationship. One of SubjectPartyId, SubjectPartyNumber, and a combination of SubjectSourceSystem and SubjectSourceSystemReferenceValue, is used to identify the subject party of the relationship.
ContactSourceSystem	String	False		No	The name of external source system for the subject party in the relationship, which are defined by an administrator as part of system setup. One of SubjectPartyId, SubjectPartyNumber, and a combination of SubjectSourceSystem and SubjectSourceSystemReferenceValue, is used to identify the subject party of the relationship. The value for this attribute should be predefined using the setup task Manage Trading Community Source Systems.
ContactSourceSystemReferenceValue	String	False		No	The identifier for the subject party in the relationship from external source system. One of SubjectPartyId, SubjectPartyNumber, and a combination of SubjectSourceSystem and SubjectSourceSystemReferenceValue, is used to identify the subject party of the relationship.
CreatedBy	String	True		No	The user who created the row.
CreatedByModule	String	False		No	The application module that created the record. It's defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. You can review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
CreationDate	Datetime	True		No	The date and time when the row was created.
DecisionMakerFlag	Bool	False		No	Indicates whether this contact is a decision maker. The values are Y for a decision maker, N for someone who's not the decision maker.
Department	String	False		No	The free form text used to name the department for the contact.
DepartmentCode	String	False		No	The value of the department code for the contact.
DoCallFlag	Bool	True		No	Indicates whether the user can call the contact of an account. The accepted values are True and False or Y and N. Default is False or N.
DoEmailFlag	Bool	True		No	Indicates whether the user can email the contact of an account. The accepted values are True and False or Y and N. Default is False or N.
DoNotCallFlag	Bool	True		No	Indicates whether you can call the account contact. The accepted values are True and False or Y and N. Default is False or N.
DoNotEmailFlag	Bool	True		No	Indicates whether you can email the account contact. The accepted values are True and False or Y and N. Default is False or N.
EmailAddress	String	True		No	The e-mail address of the contact person for the account.
EmailVerificationDate	Date	True		No	The date of the verification for the email.
EmailVerificationStatus	String	True		No	The status of the verification for email. Accepted values are defined in the standard lookup type ORA_HZ_VALIDATION_STATUS as ORA_VALID, ORA_INVALID and ORA_PARTIALLY_VALID. Default value is blank which indicates that values aren't verified.
FormattedAddress	String	True		No	The formatted address of the contact.
FormattedPhoneNumber	String	True		No	The primary formatted phone number for the contact person.
InfluenceLevelCode	String	False		No	The contact's level of influence in the buying process.
JobTitle	String	False		No	The free form text for job title for the contact associated to an account.
JobTitleCode	String	False		No	The value of the code for the job title of the contact person.
LastUpdateDate	Datetime	True		No	The date and time when the record was last updated.
LastUpdateLogin	String	True		No	The login of the user who last updated the row.
LastUpdatedBy	String	True		No	The user who last updated the record.
PersonBuyingRole	String	True		No	Describes a contact's role in a buying relationship. Sample values are key decision maker, supporting decision maker.
PersonJobTitle	String	True		No	The title of the contact's job with deploying organization.
PersonSalesAffinityCode	String	True		No	The contact's affinity for the deploying organization.
PhoneVerificationDate	Date	True		No	The date of the verification for phone.
PhoneVerificationStatus	String	True		No	The status of the verification for phone. Accepted values are defined in the standard lookup type ORA_HZ_VALIDATION_STATUS as ORA_VALID and ORA_INVALID. Default value is blank which indicates that values aren't verified.
PreferredContactFlag	Bool	False		No	Indicates whether this contact person is primary contact for the customer. Accepted values are Y and N. Default value is N.
PreferredContactMethod	String	True		No	The person's or organization's preferred contact method.
PrimaryCustomerFlag	Bool	False		No	Indicates whether this customer is primary customer for the contact. Accepted values are Y and N. Default value is N.
ReferenceUseFlag	Bool	False		No	Indicates if this contact can be used as a reference. The values are Y for a contact who will act as a reference, N for a contact who can't act as a reference.
RelationshipId	Long	True		No	The unique identifier of the relationship associated with account contact record.
RelationshipRecId	Long	False		No	Finds an account contact with the relationship record identifier.
RelationshipSourceSystem	String	False		No	The name of external source system for the relationship, which is defined by an administrator as part of system setup. One of ObjectPartyId, ObjectPartyNumber, and a combination of ObjectSourceSystem and ObjectSourceSystemReferenceValue, is used to identify the object party of the relationship. The value for this attribute should be predefined using the setup task Manage Trading Community Source Systems.
RelationshipSourceSystemReferenceValue	String	False		No	The identifier for the relationship with the external source system.
SalesAffinityCode	String	False		No	The contact's affinity for the deploying organization.
SalesAffinityComments	String	False		No	The comments describing the contact's affinity for the deploying organization.
SalesBuyingRoleCode	String	False		No	The contact's role in the buying process.
Status	String	False		No	Indicates whether this is an active or inactive relationship. The values are A for active, I for inactive. This is an internal column and you're not expected to pass in a value. A list of valid values is defined in the lookup HZ_STATUS. You can review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task. Default value is A.
AccountLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
Finder	String	False		Yes	Input specifying the Finder type.
FocusPartyId	String	False		Yes	The unique identifier of the child account to be returned at the top by the Direct Accounts finder.
ParentPartyId	String	False		Yes	The unique identifier of the account used to search the direct child accounts.
BindUserPartyId	String	False		Yes	The unique identifier of the party. Used in MyAccounts finder.
OrganizationProfileId	String	False		Yes	The unique identifier of the organization.
PartyId	String	False		Yes	The unique identifier of the party associated to the given account.
SourceSystem	String	False		Yes	Name of external source system.
SourceSystemReferenceValue	String	False		Yes	Identifier for this record from external source system.

Return to Top

AccountPrimaryAddresses

Name	Type	ReadOnly	References	FilterOnly	Description
AddressNumber [KEY]	String	False		No	This is the primary key of the primary addresses table.
PartyNumber [KEY]	String	False	Accounts.PartyNumber	No
AddressElementAttribute1	String	False		No	An additional address element to support flexible address format.
AddressElementAttribute2	String	False		No	An additional address element to support flexible address format.
AddressElementAttribute3	String	False		No	An additional address element to support flexible address format.
AddressElementAttribute4	String	False		No	An additional address element to support flexible address format.
AddressElementAttribute5	String	False		No	An additional address element to support flexible address format.
AddressId	Long	False		No	The unique identifier of the primary address.
AddressLine1	String	False		No	The first line of the primary address.
AddressLine2	String	False		No	The second line of the primary address.
AddressLine3	String	False		No	The third line of the primary address.
AddressLine4	String	False		No	The fourth line of the primary address.
AddressLinesPhonetic	String	False		No	The phonetic or Kana representation of the Kanji address lines. This is used for addresses in Japan.
Building	String	False		No	The building name or number in the primary address.
City	String	False		No	The building name or number in the primary address.
Comments	String	False		No	The user-provided comments for the primary address.
CorpCurrencyCode	String	False		No	The corporate currency code used by the CRM Extensibility framework.
Country	String	False		No	The country code of the primary address. Review the list of country codes using the Manage Geographies task.
County	String	False		No	The county of the primary address.
CreatedBy	String	False		No	The user who created the primary address record.
CreationDate	Datetime	False		No	The date when the record was created.
CurcyConvRateType	String	False		No	The currency conversion rate type. This attribute is used by CRM Extensibility framework. A list of valid values are defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
CurrencyCode	String	False		No	The currency code. This attribute is used by CRM Extensibility framework. A list of valid values are defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
DateValidated	Date	False		No	The date when the primary address was last validated.
DeleteFlag	Boolean	False		No	Indicates whether the primary address is to be deleted. If the value is Y, then the primary address has to be deleted. The default value is N.
Description	String	False		No	The description of the location.
FloorNumber	String	False		No	The floor number of the primary address.
FormattedAddress	String	False		No	The formatted version of the primary address.
FormattedMultiLineAddress	String	False		No	The formatted multiline version of the primary address.
HouseType	String	False		No	Indicates the building type for the building in the address. A list of valid values are defined in the lookup HZ_HOUSE_TYPE. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
LastUpdateDate	Datetime	False		No	The date when the record was last updated.
LastUpdatedBy	String	False		No	The user who last updated the record.
LastUpdateLogin	String	False		No	The login of the user who last updated the record.
Latitude	Double	False		No	The latitude information for the address. The latitude information for the location is used for spatial proximity and containment purposes.
LocationDirections	String	False		No	The directions to the address location.
LocationId	Long	False		No	The unique identifier for the location.
Longitude	Double	False		No	The longitude information for the address. The longitude information for the location is used for spatial proximity and containment purposes.
Mailstop	String	False		No	The user-defined code that indicates a mail drop point within the organization.
PartyId	Long	False		No	The unique identifier of the account associated with the address.
PostalCode	String	False		No	The postal code of the address.
PostalPlus4Code	String	False		No	The four-digit extension to the United States Postal ZIP code for the address.
Province	String	False		No	The province of the address.
SourceSystem	String	False		No	The name of external source system where the address is imported from. The values configured in setup task Trading Community Source System.
SourceSystemReferenceValue	String	False		No	The unique identifier for the address from the external source system specified in the attribute PartySourceSystem.
State	String	False		No	The state of the address.
ValidatedFlag	Boolean	False		No	Indicates whether the location is validated. The value is internally set by system during address cleansing. If the value is Y, then the address is validated. The default value is N.
ValidationStatusCode	String	False		No	A standardized status code describing the results of the validation. The value is internally set by system during address cleansing.
AccountLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
Finder	String	False		Yes	Input specifying the Finder type.
FocusPartyId	String	False		Yes	The unique identifier of the child account to be returned at the top by the Direct Accounts finder.
ParentPartyId	String	False		Yes	The unique identifier of the account used to search the direct child accounts.
BindUserPartyId	String	False		Yes	The unique identifier of the party. Used in MyAccounts finder.
OrganizationProfileId	String	False		Yes	The unique identifier of the organization.

Return to Top

AccountRelationships

Name	Type	ReadOnly	References	FilterOnly	Description
RelationshipRecId [KEY]	Long	False		No	This is the primary key of the relationships table.
PartyNumber [KEY]	String	False	Accounts.PartyNumber	No
Comments	String	False		No	The user-provided comments for the relationship.
CreatedBy	String	False		No	The user who created the record.
CreatedByModule	String	False		No	The module that created the account record.
CreationDate	Datetime	False		No	The date when the record was created.
EndDate	Date	False		No	The date when the relationship ends.
LastUpdateDate	Datetime	False		No	The date when the record was last updated.
LastUpdatedBy	String	False		No	The user who last updated the record.
LastUpdateLogin	String	False		No	The login of the user who last updated the record.
ObjectPartyId	Long	False		No	The unique identifier of the object party in this relationship.
ObjectPartyNumber	String	False		No	The alternate key identifier for the object party of the relationship.
ObjectSourceSystem	String	False		No	The name of the external source system for the object party in the relationship.
ObjectSourceSystemReferenceValue	String	False		No	The identifier for the object party in the relationship from the external source system.
RelationshipCode	String	False		No	The code of the relationship that specifies if this is a forward or a backward relationship code. A list of valid relationship codes is defined in the lookup PARTY_RELATIONS_TYPE. Review and update the codes using the Setup and Maintenance task, Manage Relationship Lookups.
RelationshipSourceSystem	String	False		No	The name of external source system where the relationship is imported from. The values configured in setup task Trading Community Source System.
RelationshipSourceSystemReferenceValue	String	False		No	The unique identifier for the relationship from the external source system specified in the attribute RelationshipSourceSystem.
RelationshipType	String	False		No	The relationship type such as CUSTOMER_SUPPLIER. A list of valid relationship types is defined in the lookup HZ_RELATIONSHIP_TYPE. Review and update the codes using the Setup and Maintenance task, Manage Relationship Lookups.
StartDate	Date	False		No	The date when the relationship was created.
Status	String	False		No	Indicates if the relationship is active or inactive, such as A for active and I for inactive. A list of valid values is defined in the lookup HZ_STATUS. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
SubjectPartyId	Long	False		No	The unique identifier of the subject party in this relationship.
SubjectPartyNumber	String	False		No	The alternate key identifier for the subject party of the relationship.
SubjectSourceSystem	String	False		No	The name of the external source system for the subject party in the relationship.
SubjectSourceSystemReferenceValue	String	False		No	The identifier for the subject party in the relationship from the external source system.
AccountLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
PartyId	Long	False		No	The unique identifier of the party.
Finder	String	False		Yes	Input specifying the Finder type.
FocusPartyId	String	False		Yes	The unique identifier of the child account to be returned at the top by the Direct Accounts finder.
ParentPartyId	String	False		Yes	The unique identifier of the account used to search the direct child accounts.
BindUserPartyId	String	False		Yes	The unique identifier of the party. Used in MyAccounts finder.
OrganizationProfileId	String	False		Yes	The unique identifier of the organization.

Return to Top

AccountResources

Name	Type	ReadOnly	References	FilterOnly	Description
TeamMemberId [KEY]	Long	False		No	The surrogate primary key for the member of the sales account resource team.
PartyNumber [KEY]	String	False	Accounts.PartyNumber	No
AccessLevelCode	String	False		No	The access level determines the type of access granted to the resource as well as managers of the organizations. The possible values are contained in the ZCA_ACCESS_LEVEL lookup.
AssignmentTypeCode	String	False		No	The code indicating how the resource is assigned to the sales account team. The possible values are contained in the ZCA_ASSIGNMENT_TYPE lookup.
CreatedBy	String	False		No	The user who created the record.
CreationDate	Datetime	False		No	The date and time the record was created.
EndDateActive	Date	False		No	Indicates the date on which the association of resource is ended to the sales account.
LastUpdatedBy	String	False		No	The date on which the record is last updated.
LastUpdateLogin	String	False		No	The user who last updated the record.
LockAssignmentFlag	Boolean	False		No	The user login for the user who last updated the record.
MemberFunctionCode	String	False		No	The flag indicates automatic territory assignment cannot remove the sales account team resource when this flag is Y'. When a sales account team member is added manually, this flag is defaulted toY'. Otherwise,
ResourceEmailAddress	String	False		No	The lookup code indicating a sales account resource's role on the resource team such as Integrator, Executive Sponsor and Technical Account Manager. The code lookup is stored in FND_LOOKUPS.
ResourceId	Long	False		No	Unique identifier for the resource
ResourceName	String	False		No	The name of the sales team member.
ResourceOrgName	String	False		No	The name of the organization that the sales team member belongs to.
ResourcePartyNumber	String	False		No	Unique identifier for the resource
ResourcePhoneNumber	String	False		No	The primary phone number of the sales team member.
ResourceRoleName	String	False		No	The roles assigned to the sales team member.
SalesProfileId	Long	False		No	The identifier for the sales account.
StartDateActive	Date	False		No	Indicates the date on which the association of resource is created to the sales account.
UserLastUpdateDate	Datetime	False		No	The date and time of the last update from mobile.
AccountLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
PartyId	Long	False		No	The unique identifier of the party.
Finder	String	False		Yes	Input specifying the Finder type.
FocusPartyId	String	False		Yes	The unique identifier of the child account to be returned at the top by the Direct Accounts finder.
ParentPartyId	String	False		Yes	The unique identifier of the account used to search the direct child accounts.
BindUserPartyId	String	False		Yes	The unique identifier of the party. Used in MyAccounts finder.
SourceSystem	String	False		Yes	Name of external source system.
SourceSystemReferenceValue	String	False		Yes	Identifier for this record from external source system.
OrganizationProfileId	String	False		Yes	The unique identifier of the organization.

Return to Top

Accounts

Name	Type	ReadOnly	FilterOnly	Description
PartyNumber [KEY]	String	False	No	The unique alternate identifier for the account party. You can update the value if the profile option HZ_GENERATE_PARTY_NUMBER is set to True. The default value is a concatenation of the value specified in the profile option ZCA_PUID_PREFIX and a unique system generated sequence number.
AnalysisFiscalYear	String	False	No	The fiscal year used as the source for financial information.
AssignmentExceptionFlag	Boolean	False	No	Indicates whether the sales account had the required dimensions to allow assignment manager to assign territories to the sales account. If the value is True, then the sales account has the dimensions. The default value is False.
BusinessReport	String	False	No	The Dun & Bradstreet business information report.
BusinessScope	String	False	No	The class of business to which the account belongs, such as local, national, or international.
CEOName	String	False	No	The name of the organization's chief executive officer.
CEOTitle	String	False	No	The formal title of the chief executive officer.
CertificationLevel	String	False	No	The certification level the organization. A list of valid certification level codes is defined using the lookup HZ_PARTY_CERT_LEVEL. Review the Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
CertificationReasonCode	String	False	No	The reason for the contact's current certification level assignment. A list of valid certification reason codes are defined using the lookup HZ_PARTY_CERT_REASON. Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
Comments	String	False	No	The corporate charter of the organization.
CongressionalDistrictCode	String	False	No	The U.S. Congressional district code for the account.
ControlYear	Long	False	No	The year when current ownership gained control of the organization.
CorpCurrencyCode	String	False	No	The corporate currency code associated with the account. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
CorporationClass	String	False	No	The taxation classification for corporation entities such as Chapter S in the US.
CreatedBy	String	False	No	The user who created the account record.
CreatedByModule	String	False	No	The module that created the account record.
CreationDate	Datetime	False	No	The date when the record was created.
CurrencyCode	String	False	No	The currency code. This attribute is used by CRM Extensibility framework. A list of valid values are defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
CurrentFiscalYearPotentialRevenueAmount	Decimal	False	No	The estimated revenues that can be earned by the organization during its current fiscal year.
DeleteFlag	Boolean	False	No	Indicates if the account can be deleted.
DisadvantageIndicator	String	False	No	Indicates whether the organization is considered disadvantaged by the US government under Title 8A. If the value is Yes, the organization is considered disadvantaged under Title 8A. The default value is No.
DomesticUltimateDUNSNumber	String	False	No	The DUNS Number for the Domestic Ultimate. A Domestic Ultimate is the highest member of the same country in the organization's hierarchy. An organization can be its own Domestic Ultimate.
DoNotConfuseWith	String	False	No	Indicates that there is an organization that is similarly named.
DUNSCreditRating	String	False	No	The Dun & Bradstreet credit rating.
DUNSNumber	String	False	No	The DUNS Number in freeform text format. The value not restricted to nine digit number.
EmailAddress	String	False	No	The e-mail address of the contact point for the organization.
EmailFormat	String	False	No	The preferred format for e-mail addressed to this organization, such as HTML or ASCII.
EmployeesAtPrimaryAddress	String	False	No	The qualifier to calculate the estimated number of employees at the primary address. A list of valid qualifier codes are defined using the lookup EMP_AT_PRIMARY_ADR_EST_IND. Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
EmployeesAtPrimaryAddressEstimation	String	False	No	The estimated minimum number of employees at the primary address. A list of accepted values are defined in the lookup type EMP_AT_PRIMARY_ADR_MIN_IND. Review and update the values using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
EmployeesAtPrimaryAddressMinimum	String	False	No	The qualifier to qualify calculation of employees at the primary address as minimum.
EmployeesAtPrimaryAddressText	String	False	No	The number of employees at the referenced address in text format.
EmployeesTotal	Long	False	No	The total number of employees in the organization.
ExistingCustomerFlag	Boolean	False	No	Indicates if there is an existing selling or billing relationship with the sales account. If the value is true, then there is an existing relationship with the sales account. The default value is False.
ExistingCustomerFlagLastUpdateDate	Date	False	No	The date when the existing customer flag was last updated.
ExportIndicator	String	False	No	Indicates whether the organization is an exporter. If the value is Y, then the organization is an exporter. The default value is N.
FavoriteAccountFlag	Boolean	False	No	Indicates if the account is a favorite.
FaxAreaCode	String	False	No	The area code for the fax number.
FaxCountryCode	String	False	No	The international country code for a fax number, such as 33 for France.
FaxExtension	String	False	No	The extension to the fax number of the organization.
FaxNumber	String	False	No	The fax number of the organization in the local format. The number should not include area code, country code, or extension.
FiscalYearendMonth	String	False	No	The last month of a fiscal year for the organization. The list of accepted values is defined in the lookup type MONTH.
FormattedFaxNumber	String	False	No	The formatted phone number of the organization.
FormattedPhoneNumber	String	False	No	The formatted phone number of the organization.
GeneralServicesAdministrationFlag	Boolean	False	No	Indicates whether organization is a US federal agency supported by the General Services Administration (GSA). If the value is Y, then the organization is supported by GSA. The default value is N.
GlobalUltimateDUNSNumber	String	False	No	The DUNS Number for the Global Ultimate. A Global Ultimate is the highest member in the organization's hierarchy. An organization can be its own Global Ultimate.
GrowthStrategyDescription	String	False	No	The user-defined description of growth strategy.
HomeCountry	String	False	No	The home country of the organization.
HQBranchIndicator	String	False	No	The status of this site, such as HQ, a branch, or a single location. A list of accepted values are defined in the lookup type HQ_BRANCH_IND.
ImportIndicator	String	False	No	Indicates whether the organization is an importer. If the value is Y, then the organization is an importer. The default value is N.
IndustryCode	String	False	No	The Industry classification code. The classification codes are defined for every classification category as specified in IndustryCodeType attribute. Review and update the codes using the Setup and Maintenance work area, Manage Classification Categories task.
IndustryCodeType	String	False	No	The industry classification category code type. It is defaulted to the value of profile option MOT_INDUSTRY_CLASS_CATEGORY. Review and update the codes using the Setup and Maintenance work area, Manage Classification Categories task.
LaborSurplusIndicator	String	False	No	Indicates whether the organization operates in an area with a labor surplus. If the value is Y, then the organization operates in an area with a labor surplus. The default value is N.
LastAssignmentDateTime	Datetime	False	No	The date when the Sales Account Territory Assignment was last run by Assignment Manager.
LastEnrichmentDate	Date	False	No	The date when the record was last enriched.
LastUpdateDate	Datetime	False	No	The date when the record was last updated.
LastUpdatedBy	String	False	No	The user who last updated the record.
LastUpdateLogin	String	False	No	The login of the user who last updated the record.
LegalStatus	String	False	No	The legal structure of the organization such as partnership, corporation, and so on.
LineOfBusiness	String	False	No	The type of business activities performed at this site.
LocalActivityCode	String	False	No	The local activity classification code.
LocalActivityCodeType	String	False	No	The local activity classification code type identifier.
LocalBusinessIdentifier	String	False	No	The primary identifier assigned to a businesses by a government agency such as Chamber of Commerce, or other authority. It is often used by countries other than USA.
LocalBusinessIdentifierType	String	False	No	The lookup that represents most common business identifier in a country such as Chamber of Commerce Number in Italy, Government Registration Number in Taiwan. A list of accepted values are defined in the lookup type LOCAL_BUS_IDEN_TYPE.
MinorityOwnedIndicator	String	False	No	Indicates whether the organization is primarily owned by ethnic or racial minorities. If the value is Y, then the organization is owned by ethnic or racial minorities. company is primarily owned by ethnic or racial minorities. The default value is N.
MinorityOwnedType	String	False	No	The type of minority-owned firm.
MissionStatement	String	False	No	The corporate charter of organization in user-defined text format.
NamedFlag	Boolean	False	No	Indicates if the sales account is a named sales account. If the value is True, then the account is a named account. The default value is False.
NextFiscalYearPotentialRevenueAmount	Decimal	False	No	The estimated revenue of the organization to be earned during its next fiscal year.
OrganizationName	String	False	No	The name of the account.
OrganizationSize	String	False	No	The size of the organization based on its revenue, number of employees, and so on.
OrganizationType	String	False	No	The type of the organization.
OutOfBusinessIndicator	String	False	No	Indicates whether the organization is out of business. If the value is Y, then the organization is out of business. The default value is N.
OwnerEmailAddress	String	False	No	The e-mail address of the employee resource that owns and manages the sales account. The owner is a valid employee resource defined within Sales Cloud.
OwnerName	String	False	No	The name of the employee resource that owns and manages the sales account.
OwnerPartyId	Long	False	No	The unique identifier of a valid employee resource who owns and manages the sales account.
OwnerPartyNumber	String	False	No	The party number of a valid employee resource who owns and manages the sales account.
ParentAccountName	String	False	No	The name of the parent account in the hierarchy.
ParentAccountPartyId	Long	False	No	The party Id of the parent account within the hierarchy. To assign a parent account to a sales account, you must provide the parent account's party ID, party number, or source system reference.
ParentAccountPartyNumber	String	False	No	The party number of the parent account within the hierarchy.
ParentAccountSourceSystem	String	False	No	The source system of the parent account within the hierarchy.
ParentAccountSourceSystemReferenceValue	String	False	No	The source system reference of the parent account within the hierarchy.
ParentDUNSNumber	String	False	No	The DUNS Number of the organization or the parent entity that owns a majority stake of the organization's capital stock. The parent entity can be a subsidiary of another corporation. If the parent also has branches, then it is regarded as headquarters as well as a parent company.A headquarters is a business establishment that has branches or divisions reporting to it, and is financially responsible for those branches or divisions. If the headquarters has more than 50% of capital stock owned by another corporation, it also will be a subsidiary. If it owns more than 50% of capital stock of another corporation, then it is also a parent.
ParentOrSubsidiaryIndicator	String	False	No	Title:
PartyId	Long	False	No	Title:
PartyStatus	String	False	No	Title:
PartyUniqueName	String	False	No	Title:
PhoneAreaCode	String	False	No	Title:
PhoneCountryCode	String	False	No	Title:
PhoneExtension	String	False	No	Title:
PhoneNumber	String	False	No	Title:
PreferredContactMethod	String	False	No	Title:
PreferredFunctionalCurrency	String	False	No	Title:
PrimaryContactEmail	String	False	No	Title:
PrimaryContactName	String	False	No	Title:
PrimaryContactPartyId	Long	False	No	Title:
PrimaryContactPartyNumber	String	False	No	Title:
PrimaryContactPhone	String	False	No	Title:
PrimaryContactSourceSystem	String	False	No	Title:
PrimaryContactSourceSystemReferenceValue	String	False	No	Title:
PrincipalName	String	False	No	Title:
PrincipalTitle	String	False	No	Title:
PublicPrivateOwnershipFlag	Boolean	False	No	Title:
RecordSet	String	False	No	Title:
RegistrationType	String	False	No	Title:
RentOrOwnIndicator	String	False	No	Title:
SalesProfileStatus	String	False	No	Title:
SmallBusinessIndicator	String	False	No	Indicates whether the organization is considered as a small business. If the value is Y, then the organization is considered as a small business. The default value is N.
SourceSystem	String	False	No	The name of external source system where the account party is imported from. The values configured in setup task Trading Community Source System.
SourceSystemReferenceValue	String	False	No	The unique identifier for the account party from the external source system specified in the attribute SourceSystem.
StockSymbol	String	False	No	The corporate stock symbol of the organization as listed in stock exchanges.
TaxpayerIdentificationNumber	String	False	No	The taxpayer identification number that is often a unique identifier of the organization, such as income taxpayer Id in USA and fiscal code or NIF in Europe.
TotalEmployeesEstimatedIndicator	String	False	No	Indicates if the employee total is estimated. The accepted values are defined in the lookup type TOTAL_EMP_EST_IND.
TotalEmployeesIndicator	String	False	No	Indicates if subsidiaries are included in the calculation of total employees. The accepted values are defined in the lookup type TOTAL_EMPLOYEES_INDICATOR.
TotalEmployeesMinimumIndicator	String	False	No	Indicates if the number is a minimum, maximum, or average number of total employees. The accepted values are defined in the lookup type TOTAL_EMP_MIN_IND.
TotalEmployeesText	String	False	No	The total number of employees in text format.
Type	String	False	No	The account type that defines if the account is a sales account or a prospect or any other party type. The accepted values are defined in the lookup type ZCA_ACCOUNT_TYPE. It is defaulted to ZCA_CUSTOMER if no value is provided.
UniqueNameSuffix	String	False	No	The suffix used to generate the attribute PartyUniqueName. The suffix is concatenated to the OrganizationName attribute to generate the PartyUniqueName. The primary address is defaulted as the suffix.
UpdateFlag	Boolean	False	No	Indicates if the record can be updated.
URL	String	False	No
WomanOwnedIndicator	String	False	No	Indicates whether the organization is primarily owned by women. If the value is Y, then the organization is primarily owned by women. The default value is N.
YearEstablished	Int	False	No	The year that the organization started it business operations.
YearIncorporated	Int	False	No	The year that the business was formally incorporated.
OrganizationProfileId	Long	False	No	The unique identifier of the organization.
Finder	String	False	Yes	Input specifying the Finder type.
FocusPartyId	String	False	Yes	The unique identifier of the child account to be returned at the top by the Direct Accounts finder.
ParentPartyId	String	False	Yes	The unique identifier of the account used to search the direct child accounts.
BindUserPartyId	String	False	Yes	The unique identifier of the party. Used in MyAccounts finder.

Return to Top

Activities

Name	Type	ReadOnly	FilterOnly	Description
ActivityNumber [KEY]	String	False	No	System generated or can come from external system (user key).
ActivityId	Long	False	No	System generated non-nullable primary key of the table.
StartDtRFAttr	Datetime	False	No	null
AccountAddress	String	False	No	null
AccountId	Long	False	No	Party Id of the activity account (Customer - org/person, or Partner etc.).
AccountIdAttr	Long	False	No	null
AccountName	String	False	No	Name of account associated to activity.
AccountNameOsn	String	False	No	null
AccountPhoneNumber	String	False	No	null
AccountStatus	String	False	No	null
AccountType	String	False	No	null
ActivityCreatedBy	String	False	No	Original Activity Created By
ActivityCreationDate	Datetime	False	No	Original Activity Creation Date
ActivityDescription	String	False	No	A text field for capturing some descriptive information about the activity.
ActivityDirection	String	False	No	null
ActivityEndDate	Datetime	False	No	The end date and time of an appointment, or the completion time of a task.
ActivityFilter	String	False	No	null
ActivityFunctionCode	String	False	No	Task vs Appointment. System use only.
ActivityFunctionCodeTrans	String	False	No	null
ActivityLastUpdateLogin	String	False	No	Original Activity Last Update Login
ActivityMtgMinutes	String	False	No	Activity meeting minutes
ActivityOutcome	String	False	No	null
ActivityPartialDescription	String	False	No	null
ActivityPriority	String	False	No	null
ActivityStartDate	Datetime	False	No	The start date and time of an appointment or a task. Defaulted to null for an appointment and defaulted to creation datetime for a task.
ActivityStatus	String	False	No	null
ActivityTimezone	String	False	No	Represents the time zone that the activity needs to be created in, other than the default logged in user's timezone preference.
ActivityType	String	False	No	null
ActivityTypeCode	String	False	No	The type or category of the activity.
ActivityUpdateDate	Datetime	False	No	Original Activity Update Date
ActivityUpdatedBy	String	False	No	Original Activity Updated By
ActivityUserLastUpdateDate	Datetime	False	No	Original Activity User Last Update Date
AllDayFlag	Bool	False	No	Designates that an appointment is the entire day.
ApptEndTime	Datetime	False	No	null
ApptStartTime	Datetime	False	No	null
AssessmentId	Long	False	No	Identifier of the Assessment to which the activity or the activity template is associated to.
AssetId	Long	False	No	Id of the Asset associated with the activity.
AssetName	String	False	No	Name of the Asset associated with the activity
AssetNumber	String	False	No	Asset Number.
AssetSerialNumber	String	False	No	Asset Serial Number.
AttachmentEntityName	String	False	No	null
AutoLogSource	String	False	No	For activities auto-generated through other systems, store the source system where it came from. We will use this information later in sync back logic to avoid double appearances of the same activity.
BpId	Long	False	No	Related Business plan.
BuOrgId	Long	False	No	null
CalendarAccess	Bool	False	No	null
CalendarRecurType	String	False	No	null
CalendarSubject	String	False	No	null
CalendarSubjectDay	String	False	No	null
CalendarTimeType	String	False	No	null
CallReportCount	Long	False	No	null
CallReportUpcomingYN	String	False	No	Flag to indicate Y,N,M for upcoming appointments
CallReportYN	String	False	No	Flag to Check if this activity has a Call Report
CampaignId	Long	False	No	Related Campaign.
CampaignName	String	False	No	Name of campaign associated to the activity.
CheckedInBy	String	False	No	Specifies the name of the person who checks-in to a location.
CheckedOutBy	String	False	No	Specifies the name of the person who checks-out to a location.
CheckinDate	Datetime	False	No	Stores the date and time when a user checks in to an Appointment.
CheckinLatitude	Double	False	No	Stores the latitude of a location where a user checks in to an Appointment.
CheckinLongitude	Double	False	No	Stores the longitude of a location where a user checks in to an Appointment.
CheckoutDate	Datetime	False	No	Stores the date and time when a user checks out of an Appointment.
CheckoutLatitude	Double	False	No	Stores the latitude of a location where a user checks out of an Appointment.
CheckoutLongitude	Double	False	No	Stores the longitude of a location where a user checks out of an Appointment.
ClaimId	Long	False	No	Related Claim.
ClaimName	String	False	No	Claim Name associated to the activity.
ConflictId	Long	False	No	null
ContactIDAttr	Long	False	No	null
CorpCurrencyCode	String	False	No	Holds Corporate Currency Code from profile
CreatedBy	String	False	No	System attribute to capture the user Id of the activity creator. This is defaulted by the system.
CreationDate	Datetime	False	No	System attribute to capture the Date and time the activity was created. This is defaulted by the system.
CurcyConvRateType	String	False	No	Holds currency code of a record
CurrencyCode	String	False	No	Holds Currency Conversion Rate Type from profile
CurrentDateForCallReport	Datetime	False	No	null
CurrentDateForCallReportAttr	Datetime	False	No	null
CurrentSystemDtTransient	Date	False	No	null
CustomerAccountId	Long	False	No	Id of Customer Account that the activity relates to.
DealId	Long	False	No	Related Deal.
DealNumber	String	False	No	Deal Number associated to the activity.
DelegatorId	Long	False	No	Activity resource that delegated activity ownership to another resource.
DelegatorName	String	False	No	Name of activity resource that delegated activity ownership to another resource.
DeleteFlag	Bool	False	No	This flag controls if the user has access to delete the record
DerivedAccountId	Long	False	No	null
DirectionCode	String	False	No	Inbound/Outbound. Optional. Default null.
DismissFlag	Bool	False	No	This Flag indicates if this activity is Dismissed
DoNotCallFlag	Bool	False	No	Flag to indicate if primary Contact can be called.
DueDate	Date	False	No	The date the task activity is due to be completed.
Duration	Double	False	No	Duration of an appt or task.
DynamicClaimLOVSwitcher	String	False	No	null
EmailSentDate	Datetime	False	No	This field is used to capture the Activity Email Notification shared date for Outlook integration
EndDateForCallReport	Datetime	False	No	null
EndDateForCallReportAttr	Datetime	False	No	null
EndDtRFAttr	Datetime	False	No	null
ExternalContactEmail	String	False	No	Indicates the Email address of an external contact.
ExternalContactName	String	False	No	Indicates the name of an external contact.
ExternallyOwnedFlag	Bool	False	No	Indicates that the activity is not created by an internal resource.
FundRequestId	Long	False	No	Related Fund request.
FundRequestName	String	False	No	Fund Request Name associated to the activity.
InstNumDerivedFrom	String	False	No	null
IsClientService	String	False	No	null
LastUpdateDate	Datetime	False	No	System attribute to capture the Date and Time the activity was last updated. This is defaulted by the system.
LastUpdateLogin	String	False	No	System attribute to capture the Id of the user who last updated the activity. This is defaulted by the system.
LastUpdatedBy	String	False	No	System attribute to capture the Id of the user who last updated the activity. This is defaulted by the system.
LeadId	Long	False	No	Related Lead.
LeadIdAttr	Long	False	No	null
LeadName	String	False	No	Lead Name
LeadNameOsn	String	False	No	null
Location	String	False	No	Appointment location.
LocationId	Long	False	No	Location or Address ID of the activity account or primary contact.
LoginUserRFAttr	Long	False	No	null
MdfRequestId	Long	False	No	null
MobileActivityCode	String	False	No	Unique identifier of external mobile device.
NotesLinkSourceCodeTransient	String	False	No	null
ObjectiveId	Long	False	No	Related Objective.
OpportunityId	Long	False	No	Related Opportunity.
OpportunityIdAttr	Long	False	No	null
OpportunityName	String	False	No	Name of opportunity associated to the activity.
OpportunityNameOsn	String	False	No	null
OrigEntityCode	String	False	No	null
OrigEntityNumber	String	False	No	null
OsnActivityId	Long	False	No	null
OtherPartyPhoneNumber	String	False	No	For inbound phone calls, the ANI or number being called from. For outbound calls, the phone number being called.
OutcomeCode	String	False	No	The outcome of the activity.
OutlookFlag	Bool	False	No	If created from Outlook and synced,
OutlookIdentifier	String	False	No	Unique identifier from Outlook Activity.
OwnerAddress	String	False	No	Activity Owner's Address.
OwnerEmailAddress	String	False	No	Activity Owner's Email Address.
OwnerId	Long	False	No	Primary resource on the activity. Supports resources only.
OwnerName	String	False	No	Name of primary resource of activity.
OwnerNameOsn	String	False	No	null
OwnerPhoneNumber	String	False	No	Activity Owner's Phone Number.
ParentActivityId	Long	False	No	Related activity Id, only applicable if the record is a follow up activity.
ParentActivityIdAttr	String	False	No	null
PartialMtgMinutes	String	False	No	null
PartnerEnrollmentId	Long	False	No	Related Partner Enrollment
PartnerEnrollmentNumber	String	False	No	null
PartnerPartyId	Long	False	No	Party identifier of the partner organization.
PartnerPartyName	String	False	No	Party name of the partner organization.
PartnerProgramId	Long	False	No	Related Partner Program.
PartnerProgramName	String	False	No	Name of partner program associated to the activity.
PartnerUsageFlag	Bool	False	No	Flag to indicate that the Activity has been created for an Organization Account with usage as Partner.
PercentageComplete	Double	False	No	Numeric Value 0-100 to reflect the percent complete status of the activity. Free form numeric. % value at end.
PrimaryContactEmailAddress	String	False	No	Holds Email Id of the primary contact
PrimaryContactId	Long	False	No	Primary contact of the activity.
PrimaryContactName	String	False	No	Name of primary contact.
PrimaryContactNameOsn	String	False	No	null
PrimaryFormattedAddress	String	False	No	Holds Address of the primary contact
PrimaryFormattedPhoneNumber	String	False	No	Holds Phone Number of the primary contact
PriorityCode	String	False	No	The priority of the activity. Default to 2. Possible values: 1, 2, 3.
PrivateFlag	Bool	False	No	This Flag indicates if this activity is private
RecordSet	String	False	No	null
RecurDay	Long	False	No	Repeat on specified day of month (for monthly appointments).
RecurEndDate	Datetime	False	No	Ends on a specified date.
RecurEveryOptionFlag	Bool	False	No	It is set to indicate if the recurrence occurs for every day, month, year, etc. For example, a daily recurring appointment can occur every day of the week or weekdays only. If it is everyday of the week, it is set to Y if it is weekdays only, it is set to N.
RecurExceptionFlag	Bool	False	No	Indicates if Appointment instance has been updated outside of recurring appointment series.
RecurFrequency	Double	False	No	Frequency that the recurring appointment series repeats.
RecurFriFlag	Bool	False	No	Repeat on Friday.
RecurMonFlag	Bool	False	No	Repeat on Monday.
RecurMonth	String	False	No	Repeat on specified month (for yearly appointments).
RecurNumberOfInstances	Long	False	No	Designates specific number of occurrences for the series to end after.
RecurOrigInstDate	Datetime	False	No	Original date of a recurring appointment instance.
RecurPattern	String	False	No	Designates which week for appointment to recur (for monthly and yearly appointments). Possible values: First, Second, Third, Fourth, Last.
RecurRecType	String	False	No	For Internal Use Only. Either
RecurSatFlag	Bool	False	No	Repeat on Saturday.
RecurSeriesId	Long	False	No	Series Id that links instances of a series together.
RecurSunFlag	Bool	False	No	Repeat on Sunday.
RecurThuFlag	Bool	False	No	Repeat on Thursday.
RecurTueFlag	Bool	False	No	Repeat on Tuesday.
RecurTypeCode	String	False	No	Designates how often an appointment is repeated. Possible values: Daily, Weekly, Monthly, Yearly.
RecurUpdatedAttributes	String	False	No	null
RecurWedFlag	Bool	False	No	Repeat on Wednesday.
RecurWeekday	String	False	No	It works in conjunction with RecurPattern attribute. Possbile values: Monday to Sunday, Weekday, Weekend, Day
ReferenceCustomerActTypeCode	String	False	No	Activity Type for a reference customer activity. To be used as an extension only
ReferenceCustomerId	Long	False	No	Id of the reference customer (party) associated with the activity.
ReminderPeriod	String	False	No	Reminder Period
ResponseCode	String	False	No	Response Code
SalesObjectiveName	String	False	No	Sales Objective Name associated to the activity.
SearchDate	Datetime	False	No	null
SelectedFlag	Bool	False	No	null
ShowStatus	String	False	No	null
ShowTimeAs	String	False	No	Show Time
SortDate	Datetime	False	No	This is an internal column which is used to sort the activity based on the due date for task and start date for activity.
SourceObjectCode	String	False	No	Code of the Object to which Activity will get related to
SourceObjectId	Long	False	No	Identifier of the Object to which Activity will get related to
SrId	Long	False	No	Service Request Id
SrNumber	String	False	No	Service Request Number
StartDateForCallReport	Datetime	False	No	null
StartDateForCallReportAttr	Datetime	False	No	null
StatusCode	String	False	No	Status of the activity. Defaulted to NOT_STARTED.
Subject	String	False	No	Subject/Name/Title of the activity.
SubmittedBy	Long	False	No	Call Report submitter.
SubmittedByName	String	False	No	Call Report submitter
SubmittedDate	Datetime	False	No	Call Report submission date
SwitchCallId	String	False	No	Unique Ientifier of the call on the external phone system.
TemplateDuration	Double	False	No	The duration (in days) of the template activity. This attribute is used with the start date when generating an activity from a template in order to calculate the due date.
TemplateFlag	String	False	No	null
TemplateId	Long	False	No	null
TemplateLeadTime	String	False	No	The lead time (in days) of the template activity. This attribute is used with the date input parameter when generating an activity from a template in order to calculate the activity start date. Activity start date = date provided as input parameter + lead time.
UpdateFlag	Bool	False	No	This flag controls if the user has access to update the record
UpgSourceObjectId	String	False	No	null
UpgSourceObjectType	String	False	No	null
Finder	String	False	Yes	Input specifying the Finder type.
DateRange	String	False	Yes	The date range within which you want search for appointments.
Bind_CurrentDate	String	False	Yes	Finds the date used to locate completed activities.
Bind_RecurSeriesType_BV	String	False	Yes	The recurring type code of an appointment.
Bind_TaskActFuncCd_BV	String	False	Yes	The activities with a function code of task.
Bind_TaskStatus_BV	String	False	Yes	The status of the tasks.
Bind_UserResourceId	String	False	Yes	Finds the resource ID of the user.
Bind_Subject	String	False	Yes	Open activities owned by a specified user.
Bind_LoggedInUserId_BV	String	False	Yes	The ID of the user who is logged into the application.
Bind_TaskStatus_Cancel_BV	String	False	Yes	The tasks with a cancelled status.
Bind_TaskPriority_BV	String	False	Yes	The priority of the task.
Bind_CurrentUPTZDate	String	False	Yes	The date used to locate the Tasks whose due date is before the current date.

Return to Top

ActivityAssignees

Name	Type	ReadOnly	FilterOnly	Description
ActivityAssigneeId [KEY]	Long	False	No	Activity Assignee Id.This is the surrogate primary key added for BI and Outlook.
ActivityFunctionCode	String	False	No	null
ActivityId [KEY]	Long	False	No	System generated non-nullable primary key of the Parent Activity.
ActivityNumber [KEY]	String	False	No
AssigneeId [KEY]	Long	False	No	ID of assignee associated with the activity.
AssigneeName	String	False	No	Assignee Name
AssigneePartyNumber	String	False	No	Holds Party Number of the contact
AtkMessageId	Long	False	No	null
AttendeeFlag	Bool	False	No	Flag to Check If the Contact Attended the Activity
ConflictId	Long	False	No	null
CorpCurrencyCode	String	False	No	Holds Corporate Currency Code from profile
CreatedBy	String	False	No	System attribute to capture the user Id of the activity assignee creator. This is defaulted by the system.
CreationDate	Datetime	False	No	System attribute to capture the date and time the activity assignee was created. This is defaulted by the system.
CurcyConvRateType	String	False	No	Holds Currency Conversion Rate Type from profile
CurrencyCode	String	False	No	Holds currency code of a record
DismissFlag	Bool	False	No	This Flag indicates if this activity is Dismissed
JobName	String	False	No	Job Name
LastUpdateDate	Datetime	False	No	System attribute to capture the date and time the activity assignee was last updated. This is defaulted by the system.
LastUpdateLogin	String	False	No	System attribute to capture the Id of the user who last updated the activity assignee. This is defaulted by the system.
LastUpdatedBy	String	False	No	System attribute to capture the Id of the user who last updated the activity assignee. This is defaulted by the system.
Phone	String	False	No	Holds Phone Number of the contact
PrimaryAssigneeFlag	String	False	No	null
PrimaryEmail	String	False	No	Holds Email Id of the contact
PrimaryFormattedAddress	String	False	No	Holds Primary Address of the resource
RecurSeriesId	Long	False	No	null
ReminderDatetime	Datetime	False	No	The date/time to send the appointment reminder.
ReminderPeriod	Int	False	No	Designates how soon before the appointment to send a reminder.
ResourceName	String	False	No	null
ResponseCode	String	False	No	Flag to indicate whether a reminder if needed.
SenderJobId	Long	False	No	null
ShowTimeAsCode	String	False	No	Designates how to show your appointment time on the calendar (free, busy, tentative).
SortDate	Datetime	False	No	null
StatusCode	String	False	No	null
UpgSourceObjectId	Long	False	No	null
UpgSourceObjectType	String	False	No	null
UserGuid	String	False	No	null
UserGuid1	String	False	No	null
UserLastUpdateDate	Datetime	False	No	Attribute to capture when the record was last updated by a user in disconnect mode.
UserName	String	False	No	null
ActivityLastUpdateDate	Datetime	False	No	The date and time when the opportunity was last updated.
Finder	String	False	Yes	Input specifying the Finder type.
ContactIDAttr	String	False	Yes	The contact ID related to the activities.
AccountIdAttr	String	False	Yes	Finds the account ID related to the call reports.
LeadIdAttr	String	False	Yes	Finds the lead ID related to the call reports.
OpportunityIdAttr	String	False	Yes	Finds the opportunity ID related to the call reports.
ParentActivityIdAttr	String	False	Yes	The parent activity ID related to the call reports.
EndDtRFAttr	String	False	Yes	The appointment end date.
StartDtRFAttr	String	False	Yes	The appointment start date.
DateRange	String	False	Yes	The date range within which you want search for appointments.
Bind_CurrentDate	String	False	Yes	Finds the date used to locate completed activities.
Bind_RecurSeriesType_BV	String	False	Yes	The recurring type code of an appointment.
Bind_TaskActFuncCd_BV	String	False	Yes	The activities with a function code of task.
Bind_TaskStatus_BV	String	False	Yes	The status of the tasks.
Bind_UserResourceId	String	False	Yes	Finds the resource ID of the user.
Bind_Subject	String	False	Yes	Open activities owned by a specified user.
Bind_LoggedInUserId_BV	String	False	Yes	The ID of the user who is logged into the application.
Bind_TaskStatus_Cancel_BV	String	False	Yes	The tasks with a cancelled status.
Bind_TaskPriority_BV	String	False	Yes	The priority of the task.
Bind_CurrentUPTZDate	String	False	Yes	The date used to locate the Tasks whose due date is before the current date.

Return to Top

ActivityAttachments

Name	Type	ReadOnly	References	FilterOnly	Description
AttachedDocumentId [KEY]	Long	False		No	The unique identifier of the attached document.
ActivityNumber [KEY]	String	False	Activities.ActivityNumber	No	ActivityNumber
AsyncTrackerId	String	False		No	Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files.
CategoryName	String	False		No	The category of the attachment.
ContentRepositoryFileShared	Bool	False		No	Indicates whether the attachment is shared
CreatedBy	String	True		No	The user who created the record.
CreatedByUserName	String	True		No	The user name who created the record.
CreationDate	Datetime	True		No	The date when the record was created.
DatatypeCode	String	False		No	A value that indicates the data type.
Description	String	False		No	The description of the attachment.
DmDocumentId	String	False		No	The document ID from which the attachment is created.
DmFolderPath	String	False		No	The folder path from which the attachment is created.
DmVersionNumber	String	False		No	The document version number from which the attachment is created.
DownloadInfo	String	False		No	JSON object represented as a string containing information used to programmatically retrieve a file attachment.
ErrorStatusCode	String	False		No	The error code, if any, for the attachment.
ErrorStatusMessage	String	False		No	The error message, if any, for the attachment.
ExpirationDate	Datetime	False		No	The expiration date of the contents in the attachment.
FileContents	String	False		No	The contents of the attachment.
FileName	String	False		No	The file name of the attachment.
FileUrl	String	False		No	The URI of the file.
FileWebImage	String	True		No	The base64 encoded image of the file displayed in .png format if the source is a convertible image.
LastUpdateDate	Datetime	True		No	The date when the record was last updated.
LastUpdatedBy	String	True		No	The user who last updated the record.
LastUpdatedByUserName	String	True		No	The user name who last updated the record.
PostProcessingAction	String	False		No	The name of the action that can be performed after an attachment is uploaded.
Title	String	False		No	The title of the attachment.
UploadedFileContentType	String	False		No	The content type of the attachment.
UploadedFileLength	Long	False		No	The size of the attachment file.
UploadedFileName	String	False		No	The name to assign to a new attachment file.
UploadedText	String	False		No	The text content for a new text attachment.
Uri	String	False		No	The URI of a Topology Manager type attachment.
Url	String	False		No	The URL of a web page type attachment.
UserName	String	True		No	The login credentials of the user who created the attachment.
Finder	String	False		Yes	Input specifying the Finder type.
ContactIDAttr	String	False		Yes	The contact ID related to the activities.
ActivityId	String	False		Yes	Activity Id.
AccountIdAttr	String	False		Yes	Finds the account ID related to the call reports.
LeadIdAttr	String	False		Yes	Finds the lead ID related to the call reports.
OpportunityIdAttr	String	False		Yes	Finds the opportunity ID related to the call reports.
ParentActivityIdAttr	String	False		Yes	The parent activity ID related to the call reports.
EndDtRFAttr	String	False		Yes	The appointment end date.
StartDtRFAttr	String	False		Yes	The appointment start date.
DateRange	String	False		Yes	The date range within which you want search for appointments.
Bind_CurrentDate	String	False		Yes	Finds the date used to locate completed activities.
Bind_RecurSeriesType_BV	String	False		Yes	The recurring type code of an appointment.
Bind_TaskActFuncCd_BV	String	False		Yes	The activities with a function code of task.
Bind_TaskStatus_BV	String	False		Yes	The status of the tasks.
Bind_UserResourceId	String	False		Yes	Finds the resource ID of the user.
Bind_Subject	String	False		Yes	Open activities owned by a specified user.
Bind_LoggedInUserId_BV	String	False		Yes	The ID of the user who is logged into the application.
Bind_TaskStatus_Cancel_BV	String	False		Yes	The tasks with a cancelled status.
Bind_TaskPriority_BV	String	False		Yes	The priority of the task.
Bind_CurrentUPTZDate	String	False		Yes	The date used to locate the Tasks whose due date is before the current date.

Return to Top

ActivityContacts

Name	Type	ReadOnly	FilterOnly	Description
AccountId	Long	False	No	null
ActivityContactId [KEY]	Long	False	No	This is the surrogate primary key added for BI and Outlook.
ActivityId [KEY]	Long	False	No	System generated non-nullable primary key of the Parent Activity.
ActivityNumber [KEY]	String	False	No
Affinity	String	False	No	Contact Affinity
AttendeeFlag	Bool	False	No	Flag to Check If the Contact Attended the Activity
BuyingRole	String	False	No	Contact Buying Role
ConflictId	Long	False	No	null
ContactAccount	String	False	No	Holds the Account Name that the Contact is associated to
ContactAccountId	Long	False	No	Holds the Id of the Account that the Contact is associated to
ContactAccountType	String	False	No	null
ContactCustomer	String	False	No	null
ContactEmail	String	False	No	Holds Email Id of the contact
ContactId [KEY]	Long	False	No	Id of contact associated with the activity.
ContactJobTitle	String	False	No	Holds the Job Title of the Contact
ContactLovSwitcher	String	False	No	null
ContactName	String	False	No	Contact Name
ContactPartyNumber	String	False	No	Holds Party Number of the contact
ContactPhone	String	False	No	Holds Phone Number of the contact
CorpCurrencyCode	String	False	No	Holds Corporate Currency Code from profile
CreatedBy	String	False	No	System attribute to capture the user Id of the activity contact creator. This is defaulted by the system.
CreationDate	Datetime	False	No	System attribute to capture the date and time the activity contact was created. This is defaulted by the system.
CurcyConvRateType	String	False	No	Holds Currency Conversion Rate Type from profile
CurrencyCode	String	False	No	Holds currency code of a record
DoNotCallFlag	Bool	False	No	Flag to check if this contact can be contacted through Call
DoNotContactFlag	Bool	False	No	Flag to check if this contact can be contacted
DoNotEmailFlag	Bool	False	No	Flag to check if this contact can be contacted through Email
EmailContactPreferenceFlag	String	False	No	null
ExternalContactEmail	String	False	No	Indicates the Email address of an external contact.
ExternalContactFlag	Bool	False	No	Indicates that the contact does not exist in Oracle Sales.
ExternalContactName	String	False	No	Indicates the name of an external contact.
LastUpdateDate	Datetime	False	No	System attribute to capture the date and time the activity contact was last updated. This is defaulted by the system.
LastUpdateLogin	String	False	No	System attribute to capture the Id of the user who last updated the activity contact. This is defaulted by the system.
LastUpdatedBy	String	False	No	System attribute to capture the ID of the user who last updated the activity contact. This is defaulted by the system.
Name	String	False	No	null
PhoneContactPreferenceFlag	String	False	No	null
PrimaryContactFlag	Bool	False	No	This used of enable/disable PrimaryContactFlag for a contact.
PrimaryFormattedAddress	String	False	No	Holds Primary Address of the contact
RecurSeriesId	Long	False	No	null
RelationshipId	Long	False	No	Id of the relationship of the contact.
UpgSourceObjectId	Long	False	No	null
UpgSourceObjectType	String	False	No	null
UserLastUpdateDate	Datetime	False	No	Attribute to capture when the record was last updated by a user in disconnect mode.
ActivityLastUpdateDate	Datetime	False	No	The date and time when the opportunity was last updated.
Finder	String	False	Yes	Input specifying the Finder type.
ContactIDAttr	String	False	Yes	The contact ID related to the activities.
AccountIdAttr	String	False	Yes	Finds the account ID related to the call reports.
LeadIdAttr	String	False	Yes	Finds the lead ID related to the call reports.
OpportunityIdAttr	String	False	Yes	Finds the opportunity ID related to the call reports.
ParentActivityIdAttr	String	False	Yes	The parent activity ID related to the call reports.
EndDtRFAttr	String	False	Yes	The appointment end date.
StartDtRFAttr	String	False	Yes	The appointment start date.
DateRange	String	False	Yes	The date range within which you want search for appointments.
Bind_CurrentDate	String	False	Yes	Finds the date used to locate completed activities.
Bind_RecurSeriesType_BV	String	False	Yes	The recurring type code of an appointment.
Bind_TaskActFuncCd_BV	String	False	Yes	The activities with a function code of task.
Bind_TaskStatus_BV	String	False	Yes	The status of the tasks.
Bind_UserResourceId	String	False	Yes	Finds the resource ID of the user.
Bind_Subject	String	False	Yes	Open activities owned by a specified user.
Bind_LoggedInUserId_BV	String	False	Yes	The ID of the user who is logged into the application.
Bind_TaskStatus_Cancel_BV	String	False	Yes	The tasks with a cancelled status.
Bind_TaskPriority_BV	String	False	Yes	The priority of the task.
Bind_CurrentUPTZDate	String	False	Yes	The date used to locate the Tasks whose due date is before the current date.

Return to Top

ActivityFunctionLookups

Name	Type	ReadOnly	FilterOnly	Description
LookupCode [KEY]	String	False	No
EnabledFlag	Bool	False	No
LookupType	String	False	No
Meaning	String	False	No
SetId	Long	False	No
Tag	String	False	No
ViewApplicationId	Long	False	No
Finder	String	False	Yes	Input specifying the Finder type.

Return to Top

ActivityNotes

Name	Type	ReadOnly	References	FilterOnly	Description
NoteId [KEY]	Long	False		No	Unique Note Identifier. This is the primary key of the notes table.
ActivityNumber [KEY]	String	False	Activities.ActivityNumber	No
ContactRelationshipId	Long	False		No	The relationship ID populated when the note is associated with a contact.
CorpCurrencyCode	String	False		No	Holds Corporate Currency Code from profile
CreatedBy	String	False		No	Who column: indicates the user who created the row.
CreationDate	Datetime	False		No	Who column: indicates the date and time of the creation of the row.
CreatorPartyId	Long	False		No	This is Party Id for the Note Creator
CurcyConvRateType	String	False		No	Holds Currency Conversion Rate Type from profile
CurrencyCode	String	False		No	Holds currency code of a record
DeleteFlag	Bool	False		No	This flag controls if the user has access to delete the record
EmailAddress	String	False		No	Email Address of the user who created the Note
FormattedAddress	String	False		No	Address of the user who created the Note
FormattedPhoneNumber	String	False		No	Phone Number of the user who created the Note
LastUpdateDate	Datetime	False		No	Who column: indicates the date and time of the last update of the row.
LastUpdateLogin	String	False		No	System attribute to capture the Id of the user who last updated the Note. This is defaulted by the system.
LastUpdatedBy	String	False		No	System attribute to capture the Id of the user who last updated the Note. This is defaulted by the system.
NoteTxt	String	False		No	This is the column which will store the actual note text.
NoteTypeCode	String	False		No	This is the note type code for categorization of note.
ParentNoteId	Long	False		No	null
PartyId	Long	False		No	Party identifier
PartyName	String	False		No	Name of this party
SourceObjectCode	String	False		No	This is the source_object_code for the source object as defined in OBJECTS Metadata.
SourceObjectId	String	False		No	This is the source_object_Uid for the source object (such as Activities, Opportunities etc) as defined in OBJECTS Metadata.
UpdateFlag	Bool	False		No	This flag controls if the user has access to update the record
VisibilityCode	String	False		No	This is the attribute to specify the visibility level of the note.
ActivityLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
Finder	String	False		Yes	Input specifying the Finder type.
ActivityId	String	False		Yes	The unique identifier of the activity.
ContactIDAttr	String	False		Yes	The contact ID related to the activities.
AccountIdAttr	String	False		Yes	Finds the account ID related to the call reports.
LeadIdAttr	String	False		Yes	Finds the lead ID related to the call reports.
OpportunityIdAttr	String	False		Yes	Finds the opportunity ID related to the call reports.
ParentActivityIdAttr	String	False		Yes	The parent activity ID related to the call reports.
EndDtRFAttr	String	False		Yes	The appointment end date.
StartDtRFAttr	String	False		Yes	The appointment start date.
DateRange	String	False		Yes	The date range within which you want search for appointments.
Bind_CurrentDate	String	False		Yes	Finds the date used to locate completed activities.
Bind_RecurSeriesType_BV	String	False		Yes	The recurring type code of an appointment.
Bind_TaskActFuncCd_BV	String	False		Yes	The activities with a function code of task.
Bind_TaskStatus_BV	String	False		Yes	The status of the tasks.
Bind_UserResourceId	String	False		Yes	Finds the resource ID of the user.
Bind_Subject	String	False		Yes	Open activities owned by a specified user.
Bind_LoggedInUserId_BV	String	False		Yes	The ID of the user who is logged into the application.
Bind_TaskStatus_Cancel_BV	String	False		Yes	The tasks with a cancelled status.
Bind_TaskPriority_BV	String	False		Yes	The priority of the task.
Bind_CurrentUPTZDate	String	False		Yes	The date used to locate the Tasks whose due date is before the current date.

Return to Top

ActivityObjectives

Name	Type	ReadOnly	References	FilterOnly	Description
ObjectiveId [KEY]	Long	False		No	Objective Id
ActivityNumber [KEY]	String	False	Activities.ActivityNumber	No
ActivityId	Long	False	Activities.ActivityId	No	System generated non-nullable primary key of the Parent Activity.
AttributeCategory	String	False		No	null
CompletedFlag	Bool	False		No	Completed Flag
ConflictId	Long	False		No	Conflict id
CorpCurrencyCode	String	False		No	Holds Corporate Currency Code from profile
CreatedBy	String	False		No	System attribute to capture the user Id of the activity assignee creator. This is defaulted by the system.
CreationDate	Datetime	False		No	System attribute to capture the date and time the activity assignee was created. This is defaulted by the system.
CurcyConvRateType	String	False		No	Holds Currency Conversion Rate Type from profile
CurrencyCode	String	False		No	Holds currency code of a record
LastUpdateDate	Datetime	False		No	System attribute to capture the date and time the activity assignee was last updated. This is defaulted by the system.
LastUpdateLogin	String	False		No	System attribute to capture the Id of the user who last updated the activity assignee. This is defaulted by the system.
LastUpdatedBy	String	False		No	System attribute to capture the Id of the user who last updated the activity assignee. This is defaulted by the system.
ObjectiveCode	String	False		No	Objective Code
ObjectiveFreefmtText	String	False		No	Objective Free Format Text
RecurSeriesId	Long	False		No	null
ActivityLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
Finder	String	False		Yes	Input specifying the Finder type.
ContactIDAttr	String	False		Yes	The contact ID related to the activities.
AccountIdAttr	String	False		Yes	Finds the account ID related to the call reports.
LeadIdAttr	String	False		Yes	Finds the lead ID related to the call reports.
OpportunityIdAttr	String	False		Yes	Finds the opportunity ID related to the call reports.
ParentActivityIdAttr	String	False		Yes	The parent activity ID related to the call reports.
EndDtRFAttr	String	False		Yes	The appointment end date.
StartDtRFAttr	String	False		Yes	The appointment start date.
DateRange	String	False		Yes	The date range within which you want search for appointments.
Bind_CurrentDate	String	False		Yes	Finds the date used to locate completed activities.
Bind_RecurSeriesType_BV	String	False		Yes	The recurring type code of an appointment.
Bind_TaskActFuncCd_BV	String	False		Yes	The activities with a function code of task.
Bind_TaskStatus_BV	String	False		Yes	The status of the tasks.
Bind_UserResourceId	String	False		Yes	Finds the resource ID of the user.
Bind_Subject	String	False		Yes	Open activities owned by a specified user.
Bind_LoggedInUserId_BV	String	False		Yes	The ID of the user who is logged into the application.
Bind_TaskStatus_Cancel_BV	String	False		Yes	The tasks with a cancelled status.
Bind_TaskPriority_BV	String	False		Yes	The priority of the task.
Bind_CurrentUPTZDate	String	False		Yes	The date used to locate the Tasks whose due date is before the current date.

Return to Top

Assets

Name	Type	ReadOnly	FilterOnly	Description
AssetId [KEY]	Long	False	No	The unique identifier of the Asset.
AssetAmount	Decimal	False	No	The cost amount of the asset in the transaction currency.
AssetDescription	String	False	No	The description field of the asset.
AssetGroup	String	False	No	The name of the asset group.
AssetName	String	False	No	The name that describes the asset.
AssetNumber	String	False	No	The number that identifies the asset.
AssetOrigSystem	String	False	No	A source system code that identifies the original source system of the asset
AssetOrigSystemReference	String	False	No	A source system reference that identifies the unique ID of the asset in user's legacy or external system.
AssetTag	String	False	No	The tag number associated with the asset.
AttributeCategory	String	False	No	Standard column used in Fusion tables.
BatchId	Long	False	No	The batch ID for importing process.
CompetitiveAsset	String	False	No	Indicates if the asset belongs to a competitor.
CorpCurrencyCode	String	False	No	Corporate currency code
CreatedBy	String	False	No	The user who created the record or imported the record.
CreationDate	Datetime	False	No	The time stamp when the record was created.
CrmConvRate	String	False	No	CRM Currency convert rate
CurcyConvRateType	String	False	No	Currency convert rate type
CustomerId	Long	False	No	The unique ID for the existing customer party record in the Oracle Fusion destination table.
CustomerPartyNumber	String	False	No
DeleteFlag	Bool	False	No	Delete Flag for soft deletes, Y for Yes and NULL or N for No
Description	String	False	No	Asset item description
EndDate	Date	False	No	The date when the asset ends.
EnteredCurrencyCode	String	False	No	The code that represents the currency for the asset amounts.
IBAssetId	Long	False	No	Unique ID of the associated Install Base asset record.
IBAssetSyncedVersionNumber	Int	False	No	Last synced Version Number of the Install Base Asset
InstallDate	Date	False	No	The date the asset was installed.
InterfaceRowId	Long	False	No	The interface table row's unique ID.
InventoryItemId	Long	False	No	The unique ID for the existing sales catalog product (item) record in the Oracle Fusion destination table.
InventoryOrgId	Long	False	No	Item Organization Id as created by Fusion CRM
ItemNumber	String	False	No	Item Number
LastUpdateDate	Datetime	False	No	The time stamp when the record was last updated.
LastUpdateLogin	String	False	No	The ID of the user who last updated the record in the interface table or submitted the import process.
LastUpdatedBy	String	False	No	The session sign in of the user that last updated the row.
Manufacturer	String	False	No	The name of the manufacturer.
Model	String	False	No	The name of the model.
OrganizationId	Long	False	No	Organization ID
PartyType	String	False	No
PartyUniqueName	String	False	No
PrContactPartyId	Long	False	No	The party identifier of the asset's primary contact.
PrContactPartyNumber	String	False	No
ProdGroupId	Long	False	No	Product Group ID in sales catalog
ProdGroupName	String	False	No	Product Group Name
ProdGroupReferenceNumber	String	False	No
Product	String	False	No	The name of the product.
ProductType	String	False	No
PurchaseDate	Date	False	No	The date the asset was purchased.
Quantity	Decimal	False	No	The quantity purchased.
ResourceOwnerId	Long	False	No	The identifier of the asset's resource owner.
ResourceOwnerPartyNumber	String	False	No
SearchFilter	String	False	No
SerialNumber	String	False	No	The asset's serial number.
StartDate	Date	False	No	The date when the asset starts.
StatusCode	String	False	No	The lookup code that represents the asset status, such as active or expired.
UOMCode	String	False	No	Unit of Measure
Version	String	False	No	The version of the asset product.
Year	String	False	No	The year of manufacture or the nominal model year of the asset product.
Finder	String	False	Yes	Input specifying the Finder type.
PartyId	String	False	Yes	The unique identifier of the party used to find the account by hierarchy.
PartyIdAttribute	String	False	Yes	The unique identifier attribute name of the party used to find the account by hierarchy.
AttributeName	String	False	Yes	The rollup attribute name to find a rollups.
RollupId	String	False	Yes	The unique identifier of a rollup used to find the rollup.
SourceObject	String	False	Yes	The source object code used to find the rollup.
SourceObjectId	String	False	Yes	The source object identifier of the party associated with the rollup.

Return to Top

CatalogProductGroups

Name	Type	ReadOnly	FilterOnly	Description
ProductGroupDenormId [KEY]	Long	False	No	Product Group denorm identifier.
AllowDuplicateContentFlag	String	False	No
AttachmentEntityName	String	False	No
Depth	Long	False	No	Difference in level from the first product group to the last Product Group in the path.
FilterByTM	String	False	No
FirstProdGrpId	Long	False	No
InternalName	String	False	No	Internal name of the Product Group.
LastUpdateDate	Datetime	False	No
ModelConfigAttributes	String	False	No
ModelName	String	False	No
ParentProductGroupId	Long	False	No	Product Group identifier for the penultimate node in the path.
PathId	Long	False	No	Persistent identifier for the path.
ProdGrpDetailsId	Long	False	No
ProductGroupDescription	String	False	No	Translated Product Group description used for runtime display.
ProductGroupId	Long	False	No	Product Group identifier.
ProductGroupName	String	False	No	Translated name of the Product Group used for runtime display.
ProductGroupReferenceNumber	String	False	No
ReferenceNumber	String	False	No	Identifier used for integration with external systems.
RevenueCategoryCode	String	False	No
RevenueRoleCode	String	False	No
UsageCode	String	False	No
UsageModeCode	String	False	No
UsageRootFlag	String	False	No
Finder	String	False	Yes	Input specifying the Finder type.
Bind_InventoryItemId	String	False	Yes	Bind InventoryItemId.
Bind_ProductGroupId	String	False	Yes	Bind ProductGroupId.
Bind_UsageCode	String	False	Yes	Bind UsageCode.
Bind_UsageModeCode	String	False	Yes	Bind UsageModeCode.

Return to Top

CompetitorAccounts

Name	Type	ReadOnly	FilterOnly	Description
PartyId [KEY]	Long	False	No	PartyId
AnnualRevenueAmount	Double	False	No	AnnualRevenueAmount
CeoName	String	False	No	CeoName
Country	String	False	No	Country
CreatedBy	String	True	No	CreatedBy
CreatedByModule	String	False	No	CreatedByModule
CreationDate	Datetime	True	No	CreationDate
CurrencyCode	String	False	No	CurrencyCode
DUNSNumber	String	False	No	DUNSNumber
DbRating	String	False	No	DbRating
DeletetFlag	Bool	True	No	DeletetFlag
FiscalYearendMonth	String	False	No	FiscalYearendMonth
IncorpYear	Int	False	No	IncorpYear
LastUpdateDate	Datetime	True	No	LastUpdateDate
LastUpdateLogin	String	True	No	LastUpdateLogin
LastUpdatedBy	String	True	No	LastUpdatedBy
LineOfBusiness	String	False	No	LineOfBusiness
MinorityOwnedInd	String	False	No	MinorityOwnedInd
OrganizationName	String	False	No	OrganizationName
OrganizationSize	String	False	No	OrganizationSize
PartyName	String	False	No	PartyName
PartyNumber	String	False	No	PartyNumber
PartyType	String	False	No	PartyType
PublicPrivateOwnershipFlag	Bool	False	No	PublicPrivateOwnershipFlag
SICCode	String	False	No	SICCode
SmallBusInd	String	False	No	SmallBusInd
StatusCode	String	False	No	StatusCode
StockSymbol	String	False	No	StockSymbol
ThreatLevelCode	String	False	No	ThreatLevelCode
TradingPartnerIdentifier	String	False	No	TradingPartnerIdentifier
URL	String	False	No	URL
UniqueNameSuffix	String	False	No	UniqueNameSuffix
UpdateFlag	Bool	True	No	UpdateFlag
YearEstablished	Int	False	No	YearEstablished
Finder	String	False	Yes	Input specifying the Finder type.

Return to Top

ContactAddresses

Name	Type	ReadOnly	References	FilterOnly	Description
AddressNumber [KEY]	String	False		No	The unique alternate identifier for the address. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address record during update. If not specified, then it is automatically generated. A list of accepted values is defined in the profile option ZCA_PUID_PREFIX concatenated with an internally generated unique sequence number.
PartyNumber [KEY]	String	False	Contacts.PartyNumber	No	The alternate unique identifier of the contact to which the address is associated. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the contact record with which the address is associated. The default value for PartyNumber is the value specified in the profile option ZCA_PUID_PREFIX concatenated with a unique generated sequence number. You can update the PartyNymber depending on the profile option HZ_GENERATE_PARTY_NUMBER. A list of accepted values is defined in the profile option HZ_GENERATE_PARTY_NUMBER. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Profile Options task.
AddrElementAttribute1	String	False		No	The additional address element to support flexible address format.
AddrElementAttribute2	String	False		No	The additional address element to support flexible address format.
AddrElementAttribute3	String	False		No	The additional address element to support flexible address format.
AddrElementAttribute4	String	False		No	The additional address element to support flexible address format.
AddrElementAttribute5	String	False		No	The additional address element to support flexible address format.
Address1	String	False		No	The first line for address.
Address2	String	False		No	The second line for address.
Address3	String	False		No	The third line for address.
Address4	String	False		No	The fourth line for address.
AddressId	Long	False		No	The unique identifier for the address that is generated internally during create. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address record during update.
AddressLinesPhonetic	String	False		No	The phonetic or kana representation of the Kanji address lines (used in Japan).
City	String	False		No	The city element of Address.
ClliCode	String	False		No	The Common Language Location Identifier (CLLI) code.
Comments	String	False		No	User comments for the address.
CorpCurrencyCode	String	False		No	The corporate currency code associated with the addresses. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
Country	String	False		No	The country code of the address. This attribute is defined in the TERRITORY_CODE column in the FND_TERRITORY table.
County	String	False		No	The county element of Address.
CreatedBy	String	False		No	The user who created the address record.
CreatedByModule	String	False		No	The application module that created this organization record. The default value for CreatedByModule is HZ_WS for all Web service based creation.
CreationDate	Datetime	False		No	The date and time when the address record was created.
CurcyConvRateType	String	False		No	The currency conversion rate type associated with the address. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
CurrencyCode	String	False		No	The currency code associated with the address. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
DateValidated	Date	False		No	The date when the address was last validated.
Description	String	False		No	An extensive description of the location of the address.
DoNotMailFlag	Boolean	False		No	Indicates if this address should be used for mailing. If the value is True, then the address should not be used for mailing. The default value is False.
EffectiveDate	Date	False		No	The date when the address becomes effective.
EndDateActive	Date	False		No	Date on which this address is no longer active.
FloorNumber	String	False		No	The specific floor number at a given address or in a particular building when building number is provided.
FormattedAddress	String	False		No	The formatted address information.
FormattedMultilineAddress	String	False		No	The formatted multiple line address information.
HouseType	String	False		No	The type of building. A list of accepted values for this attribute is defined in the lookup HZ_HOUSE_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
LastUpdateDate	Datetime	False		No	The date when the address data was last updated.
LastUpdatedBy	String	False		No	The user who last updated the address record.
LastUpdateLogin	String	False		No	The session login associated to the user who last updated the address record.
Latitude	Double	False		No	Used to store latitude information for the location for spatial proximity and containment purposes.
LocationDirections	String	False		No	The directions to the location.
LocationId	Long	False		No	The unique identifier for this location.
Longitude	Double	False		No	Used to store longitude information for the location for spatial proximity and containment purposes.
Mailstop	String	False		No	A user-defined code to indicate a mail drop point within their organization.
ObjectVersionNumber	Long	False		No	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.
PartyId	Long	False		No	The unique Identifier of the contact to which the address is associated. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to uniquely identify the contact record with which the address is associated.
PartySourceSystem	String	False		No	The name of external source system of the contact with which the address is associated. Part of Alternate Key for the contact record (along with PartyourceSystemReferenceValue). One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the contact record with which the address is associated. A list of accepted values should be pre-defined in the lookup type HZ_ORIG_SYSTEMS_VL. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Source Systems task.
PartySourceSystemReferenceValue	String	False		No	The identifier from external source system for the contact with which the address is associated. Part of Alternate Key (along with PartySourceSystem). One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the contact record with which the address is associated.
PostalCode	String	False		No	The postal code as defined by the formal countrywide postal system.
PostalPlus4Code	String	False		No	The four digit extension to the United States Postal ZIP code.
PrimaryFlag	Boolean	False		No	Indicates if this is the primary address of the contact irrespective of the context. If the value is True, then the address is the primary address of the contact. The default value is False.
Province	String	False		No	The province element of Address.
SourceSystem	String	False		No	The name of external source system for the address denoted by a code, which is defined by an administrator as part of system setup. The value of SourceSystem should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Source Systems. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
SourceSystemReferenceValue	String	False		No	The identifier for the address from the external source. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
StartDateActive	Date	False		No	Date on which this address becomes active.
State	String	False		No	The state element of Address.
Status	String	False		No	The status of the address. A list of accepted values is defined in the lookup HZ_STATUS. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
ValidatedFlag	Boolean	False		No	Indicates if the location was validated. If the value is True, then the location is validated. The default value is False. The value is internally set by system during address cleansing.
ValidationStartDate	Date	False		No	The date when the address validation started. The value is internally set by system during address cleansing.
ValidationStatusCode	String	False		No	The standardized status code describing the results of the address validation. The value is internally set by system during address cleansing.
ContactLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
Finder	String	False		Yes	Input specifying the Finder type.
BindUserPartyId	String	False		Yes	The unique identifier of the contact.
PersonProfileId	String	False		Yes	The unique identifier of the contact.

Return to Top

ContactAddressPurposes

Name	Type	ReadOnly	References	FilterOnly	Description
AddressPurposeId [KEY]	Long	False		No	This is the primary key of the contact address purposes table.
PartyNumber [KEY]	String	False	Contacts.PartyNumber	No
AddressNumber [KEY]	String	False	ContactAddresses.AddressNumber	No
DeleteFlag	Boolean	False		No	Indicates if the address purpose for an address was deleted. If the value is True, then the address purpose is deleted. The default value is False.
Purpose	String	False		No	The use or purpose of the address.
ContactLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
SourceSystem	String	False		No	The name of external source system for the address purpose denoted by a code, which is defined by an administrator as part of system setup.
SourceSystemReferenceValue	String	False		No	The unique identifier for the address purpose from the external source.
Finder	String	False		Yes	Input specifying the Finder type.
BindUserPartyId	String	False		Yes	The unique identifier of the contact.
PersonProfileId	String	False		Yes	The unique identifier of the contact.
PartyId	String	False		Yes	The unique identifier of the contact.

Return to Top

ContactAttachments

Name	Type	ReadOnly	References	FilterOnly	Description
AttachedDocumentId [KEY]	Long	False		No	The unique identifier of the attached document.
PartyNumber [KEY]	String	True	Contacts.PartyNumber	No	PartyNumber
AsyncTrackerId	String	False		No	Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files.
CategoryName	String	False		No	The category of the attachment.
ContentRepositoryFileShared	Bool	False		No	Indicates whether the attachment is shared
CreatedBy	String	True		No	The user who created the record.
CreatedByUserName	String	True		No	The user name who created the record.
CreationDate	Datetime	True		No	The date when the record was created.
DatatypeCode	String	False		No	A value that indicates the data type.
Description	String	False		No	The description of the attachment.
DmDocumentId	String	False		No	The document ID from which the attachment is created.
DmFolderPath	String	False		No	The folder path from which the attachment is created.
DmVersionNumber	String	False		No	The document version number from which the attachment is created.
DownloadInfo	String	False		No	JSON object represented as a string containing information used to programmatically retrieve a file attachment.
ErrorStatusCode	String	False		No	The error code, if any, for the attachment.
ErrorStatusMessage	String	False		No	The error message, if any, for the attachment.
ExpirationDate	Datetime	False		No	The expiration date of the contents in the attachment.
FileContents	String	False		No	The contents of the attachment.
FileName	String	False		No	The file name of the attachment.
FileUrl	String	False		No	The URI of the file.
FileWebImage	String	True		No	The base64 encoded image of the file displayed in .png format if the source is a convertible image.
LastUpdateDate	Datetime	True		No	The date when the record was last updated.
LastUpdatedBy	String	True		No	The user who last updated the record.
LastUpdatedByUserName	String	True		No	The user name who last updated the record.
PostProcessingAction	String	False		No	The name of the action that can be performed after an attachment is uploaded.
Title	String	False		No	The title of the attachment.
UploadedFileContentType	String	False		No	The content type of the attachment.
UploadedFileLength	Long	False		No	The size of the attachment file.
UploadedFileName	String	False		No	The name to assign to a new attachment file.
UploadedText	String	False		No	The text content for a new text attachment.
Uri	String	False		No	The URI of a Topology Manager type attachment.
Url	String	False		No	The URL of a web page type attachment.
UserName	String	True		No	The login credentials of the user who created the attachment.
Finder	String	False		Yes	Input specifying the Finder type.
BindUserPartyId	String	False		Yes	The unique identifier of the contact.
PartyId	String	False		Yes	The unique identifier of the contact.
PersonProfileId	String	False		Yes	The unique identifier of the contact.
SourceSystem	String	False		Yes	The name of external source system where the contact party is imported from.
SourceSystemReferenceValue	String	False		Yes	The unique identifier for the contact party from the external source system.

Return to Top

ContactContactPoints

Name	Type	ReadOnly	References	FilterOnly	Description
ContactPointId [KEY]	Long	True	Contacts.PartyNumber	No	The unique identifier of the contact point.
PartyNumber [KEY]	String	False		No	The unique alternate identifier for the account party.
ConflictId	Long	False		No	The unique identifier of the conflict for the contact point record. This number is used by mobile or portable applications that consume the web service.
ContactPointType	String	False		No	The type of Contact Point record. The accepted values are defined in the lookup type COMMUNICATION_TYPE. Sample values include PHONE, EMAIL, and WEB.
CreatedBy	String	True		No	The user who created the contact point record.
CreatedByModule	String	False		No	The application module that created this contact point record. Defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. You can review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups.
CreationDate	Datetime	True		No	The date when the record was created.
DoContactPreferenceFlag	Bool	False		No	Indicates whether to use a particular contact method. Defaulted to false.
DoNotContactPreferenceFlag	Bool	False		No	Indicates whether the record can be contacted.
DoNotContactReason	String	False		No	The reason code for the contact preference.
EmailAddress	String	False		No	The email address of the contact point record of type email.
EmailPurpose	String	False		No	The purpose of using the EMAIL contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE. The values can be ASSISTANT, PERSONAL, HOME_BUSINESS, BUSINESS, and so on.
FormattedPhoneNumber	String	True		No	The formatted phone number of the contact point.
LastUpdateDate	Datetime	True		No	The date when the record was last updated.
LastUpdateLogin	String	True		No	The login of the user who last updated the record.
LastUpdatedBy	String	True		No	The user who last updated the contact point record.
ObjectVersionNumber	Int	False		No	The number used to implement optimistic locking for contact point record. This number is incremented every time 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.
PartyId	Long	False		No	The unique identifier of the associated party record for contact point.
PartySourceSystem	String	False		No	The name of external source system of the account, contact or household with which the contact point is associated. Part of alternate key for the account, contact or household record along with PartyourceSystemReferenceValue. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems.
PartySourceSystemReferenceValue	String	False		No	The unique identifier from external source system for the account, contact or household with which the address is associated. Part of alternate key along with PartySourceSystem. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated.
PhoneAreaCode	String	False		No	The area code for the phone number.
PhoneCountryCode	String	False		No	The country code of the phone number.
PhoneExtension	String	False		No	The extension number of the phone line number like office desk extension.
PhoneNumber	String	False		No	The phone number of the contact point.
PhonePurpose	String	False		No	Defines the purpose of using the PHONE contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE.Sample values: ASSISTANT,PERSONAL,HOME_BUSINESS,BUSINESS etc.
PhoneType	String	False		No	The type of phone contact point. The accepted values are defined in the lookup type ORA_HZ_PHONE_TYPE. The values can be WORK, HOME, FAX, and so on.
PreferenceRequestedBy	String	False		No	Indicates if the permission or restriction was created internally or requested by the party. The list of accepted values are defined in the REQUESTED_BY lookup.
PrimaryFlag	Bool	False		No	Indicates whether this is the primary contact point of the associated object. If the value is True, then this is the primary contact point. The default value is False. If this attribute isn't explicitly mentioned in the payload, then the value of this attribute is set to null.
RawPhoneNumber	String	False		No	The raw phone number on the contact point record of type phone.
SocialNetworkId	String	False		No	The unique identifier of the social network.
SocialNetworkName	String	False		No	The name of the social network.
SocialNetworkPurpose	String	False		No	Defines the purpose of using the IM contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE.Sample values: ASSISTANT,PERSONAL,HOME_BUSINESS,BUSINESS etc.
SourceSystem	String	False		No	The name of external source system, which is defined by an administrator as part of system setup. It's part of alternate key along with SourceSystemReference, and is mandatory if PK or partyNumberBusinessKey isn't passed in update.
SourceSystemReferenceValue	String	False		No	The unique identifier for the contacts party from the external source system specified in the attribute SourceSystem. It's part of alternate key along with SourceSystemReference, and is mandatory if PK or partyNumberBusinessKey isn't passed in update.
Status	String	False		No	Indicates the status of the contact point. The status codes are defined in the lookup HZ_STATUS. The default value is A.
URL	String	False		No	The URL of the contact point.
VerificationDate	Date	False		No	The date of verification of the phone or email contact point.
VerificationStatus	String	False		No	The status of the verification for phone or email contact points. Accepted values are defined in the standard lookup type ORA_HZ_VALIDATION_STATUS as ORA_VALID, ORA_INVALID and ORA_PARTIALLY_VALID. The value ORA_PARTIALLY_VALID is applicable only for email. Default value is blank which indicates that values aren't verified.
WebPurpose	String	False		No	Defines the purpose of using the WEB contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE_WEB.Sample values: HOMEPAGE,SALESURL,MARKETINGURL,SUPPORTURL,RSS_FEED etc.
Finder	String	False		Yes	Input specifying the Finder type.
BindUserPartyId	String	False		Yes	The unique identifier of the contact.
PersonProfileId	String	False		Yes	The unique identifier of the contact.

Return to Top

ContactNotes

Name	Type	ReadOnly	References	FilterOnly	Description
NoteId [KEY]	Long	False		No	This is the primary key of the notes table.
PartyNumber [KEY]	String	False	Contacts.PartyNumber	No
ContactRelationshipId	Long	False		No	The identifier of the relationship populated when the note is associated with a contact.
CorpCurrencyCode	String	False		No	The corporate currency code of the note associated with the contact. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
CreatedBy	String	False		No	The user who created the note record.
CreationDate	Datetime	False		No	The date and time when the note record was created.
CreatorPartyId	Long	False		No	The unique party identifier for the note creator.
CurcyConvRateType	String	False		No	The currency conversion rate type associated with the note. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
CurrencyCode	String	False		No	The currency code associated with the note. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
LastUpdateDate	Datetime	False		No	The date when the note data was last updated.
NoteTxt	String	False		No	The actual note text.
NoteTypeCode	String	False		No	This code for categorization of the note type.
PartyId	Long	False		No	The unique Identifier of the contact to which the note is associated. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to uniquely identify the contact record with which the address is associated.
PartyName	String	False		No	The name of a contact party.
SourceObjectCode	String	False		No	The code of the source object such as Activities, Opportunities, as defined in OBJECTS Metadata.
SourceObjectId	String	False		No	The primary key identifier of the source object such as Activities, Opportunities, as defined in OBJECTS Metadata.
VisibilityCode	String	False		No	The visibility level of the note.
ContactLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
Finder	String	False		Yes	Input specifying the Finder type.
BindUserPartyId	String	False		Yes	The unique identifier of the contact.
PersonProfileId	String	False		Yes	The unique identifier of the contact.
SourceSystem	String	False		Yes	The name of external source system where the contact party is imported from.
SourceSystemReferenceValue	String	False		Yes	The unique identifier for the contact party from the external source system.

Return to Top

ContactPrimaryAddresses

Name	Type	ReadOnly	References	FilterOnly	Description
AddressNumber [KEY]	String	False		No	This is the primary key of the contact primary addresses table.
PartyNumber [KEY]	String	False	Contacts.PartyNumber	No
AddressElementAttribute1	String	False		No	The additional address element to support flexible address format.
AddressElementAttribute2	String	False		No	The additional address element to support flexible address format.
AddressElementAttribute3	String	False		No	The additional address element to support flexible address format.
AddressElementAttribute4	String	False		No	The additional address element to support flexible address format.
AddressElementAttribute5	String	False		No	The additional address element to support flexible address format.
AddressId	Long	False		No	The unique identifier for the address that is generated internally during create. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address record during update.
AddressLine1	String	False		No	The first line for address.
AddressLine2	String	False		No	The second line for address.
AddressLine3	String	False		No	The third line for address.
AddressLine4	String	False		No	The fourth line for address.
AddressLinesPhonetic	String	False		No	The phonetic or kana representation of the Kanji address lines (used in Japan).
Building	String	False		No	The specific building name or number at a given address.
City	String	False		No	The city element of Address.
Comments	String	False		No	User comments for the address.
CorpCurrencyCode	String	False		No	The corporate currency code associated with the addresses. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
Country	String	False		No	The country code of the address. This attribute is defined in the TERRITORY_CODE column in the FND_TERRITORY table.
County	String	False		No	The county element of Address.
CreatedBy	String	False		No	The user who created the address record.
CreationDate	Datetime	False		No	The date and time when the address record was created.
CurcyConvRateType	String	False		No	The currency conversion rate type associated with the address. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
CurrencyCode	String	False		No	The currency code associated with the address. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
DateValidated	Date	False		No	The date when the address was last validated.
DeleteFlag	Boolean	False		No	Indicates if the primary address was deleted. If the value is True, then the primary address is deleted. The default value is False.
Description	String	False		No	An extensive description of the location of the address.
FloorNumber	String	False		No	The specific floor number at a given address or in a particular building when building number is provided.
FormattedAddress	String	False		No	The formatted address information.
FormattedMultiLineAddress	String	False		No	The formatted multiple line address information.
HouseType	String	False		No	The type of building. A list of accepted values is defined in the lookup HZ_HOUSE_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
LastUpdateDate	Datetime	False		No	The date when the address data was last updated.
LastUpdatedBy	String	False		No	The user who last updated the address record.
LastUpdateLogin	String	False		No	The session login associated to the user who last updated the address record.
Latitude	Double	False		No	Used to store latitude information for the location for spatial proximity and containment purposes.
LocationDirections	String	False		No	The directions to the location.
LocationId	Long	False		No	The unique identifier for this location.
Longitude	Double	False		No	Used to store longitude information for the location for spatial proximity and containment purposes.
Mailstop	String	False		No	A user-defined code to indicate a mail drop point within their organization.
PartyId	Long	False		No	The unique Identifier of the contact to which the primary address is associated. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to uniquely identify the contact record with which the address is associated.
PostalCode	String	False		No	The postal code as defined by the formal countrywide postal system.
PostalPlus4Code	String	False		No	The four digit extension to the United States Postal ZIP code.
Province	String	False		No	The province element of Address.
SourceSystem	String	False		No	The name of external source system for the address denoted by a code, which is defined by an administrator as part of system setup. The value of SourceSystem should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Source Systems. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
SourceSystemReferenceValue	String	False		No	The identifier for the address from the external source. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
State	String	False		No	The state element of Address.
ValidatedFlag	Boolean	False		No	Indicates if the location was validated. If the value is True, then the location is validated. The default value is False. The value is internally set by system during address cleansing.
ValidationStatusCode	String	False		No	The date when the address validation started. The value is internally set by system during address cleansing.
ContactLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
Finder	String	False		Yes	Input specifying the Finder type.
BindUserPartyId	String	False		Yes	The unique identifier of the contact.
PersonProfileId	String	False		Yes	The unique identifier of the contact.

Return to Top

ContactRelationships

Name	Type	ReadOnly	References	FilterOnly	Description
RelationshipRecId [KEY]	Long	False		No	This is the primary key of the relationships table.
PartyNumber [KEY]	String	False	Contacts.PartyNumber	No
Comments	String	False		No	User comments for the relationship.
CreatedBy	String	False		No	The user who created the relationship record.
CreatedByModule	String	False		No	The application module that created this organization record. The default value for CreatedByModule is HZ_WS for all Web service based creation. A list of accepted values is defined in the lookup type HZ_CREATED_BY_MODULES. Review and update the value for this attribute using the Setup and Maintenance task work area, Manage Trading Community Common Lookups task.
CreationDate	Datetime	False		No	The date and time when the relationship record was created.
EndDate	Date	False		No	The date when the relationship ends.
LastUpdateDate	Datetime	False		No	The date and time when the relationship data was last updated.
LastUpdatedBy	String	False		No	The user who last updated the relationship record.
LastUpdateLogin	String	False		No	The session login associated to the user who last updated the relationship record.
ObjectPartyId	Long	False		No	The primary key identifier of the contact, in this relationship. One of ObjectPartyId, ObjectPartyNumber and ObjectSourceSystem along with ObjectSourceSystemReferenceValue combination is used to identify the contact party of the relationship.
ObjectPartyNumber	String	False		No	The unique alternate identifier for the relationship of the contact party. One of ObjectPartyId, ObjectPartyNumber and ObjectSourceSystem along with ObjectSourceSystemReferenceValue combination is used to identify the object party of the relationship.
ObjectSourceSystem	String	False		No	The name of external source system for the contact party in the relationship, which are defined by an admin as part of system setup. One of ObjectPartyId, ObjectPartyNumber and ObjectSourceSystem along with ObjectSourceSystemReferenceValue combination is used to identify the object party of the relationship. A list of accepted values should be pre-defined in the lookup type HZ_ORIG_SYSTEMS_VL. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Source Systems task.
ObjectSourceSystemReferenceValue	String	False		No	The identifier from external source system for the relationship of the contact party. One of ObjectPartyId, ObjectPartyNumber and ObjectSourceSystem along with ObjectSourceSystemReferenceValue combination is used to identify the contact party of the relationship.
RelationshipCode	String	False		No	The code for a forward or a backward relationship. A list of accepted relationship values is defined in the lookup PARTY_RELATIONS_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Relationship Lookups.
RelationshipSourceSystem	String	False		No	The name of external source system for the relationship, which are defined by an Admin as part of system setup.
RelationshipSourceSystemReferenceValue	String	False		No	The identifier from external source system for the relationship.
RelationshipType	String	False		No	The type of relationship of a contact party, such as CUSTOMER_SUPPLIER. A list of accepted relationship type values is defined in the lookup HZ_RELATIONSHIP_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Relationship Lookups task.
StartDate	Date	False		No	Date on which this relationship becomes active.
Status	String	False		No	The status of the relationship. Indicates if this is an active or inactive relationship. The values A indicate an active relationship and I an inactive relationship. This is an internal column and user is not expected to pass in a value. A list of accepted values is defined in the lookup HZ_STATUS. Review and update the values for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
SubjectPartyId	Long	False		No	The primary key identifier of the subject in this relationship. One of SubjectPartyId, SubjectPartyNumber and SubjectSourceSystem along with SubjectSourceSystemReferenceValue combination is used to identify the subject party of the relationship.
SubjectPartyNumber	String	False		No	The alternate unique identifier for the subject party of the relationship. One of SubjectPartyId, SubjectPartyNumber and SubjectSourceSystem along with SubjectSourceSystemReferenceValue combination is used to identify the subject party of the relationship.
SubjectSourceSystem	String	False		No	The name of external source system for the subject party in the relationship, which are defined by an Admin as part of system setup. One of SubjectPartyId, SubjectPartyNumber and SubjectSourceSystem along with SubjectSourceSystemReferenceValue combination is used to identify the subject party of the relationship. A list of accepted values should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Source Systems task.
SubjectSourceSystemReferenceValue	String	False		No	The identifier from external source system for the subject party in the relationship. One of SubjectPartyId, SubjectPartyNumber and SubjectSourceSystem along with SubjectSourceSystemReferenceValue combination is used to identify the subject party of the relationship.
ContactLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
PartyId	Long	False		No	The unique identifier of the party.
Finder	String	False		Yes	Input specifying the Finder type.
BindUserPartyId	String	False		Yes	The unique identifier of the contact.
PersonProfileId	String	False		Yes	The unique identifier of the contact.
SourceSystem	String	False		Yes	The name of external source system where the contact party is imported from.
SourceSystemReferenceValue	String	False		Yes	The unique identifier for the contact party from the external source system.

Return to Top

Contacts

Name	Type	ReadOnly	FilterOnly	Description
PartyNumber [KEY]	String	False	No	The unique alternate identifier for the contact party. The default value for PartyNumber is the value specified in the profile option HZ_GENERATE_PARTY_NUMBER. You can update the PartyNumber depending on the profile option HZ_GENERATE_PARTY_NUMBER. A list of accepted values is defined in the profile option HZ_GENERATE_PARTY_NUMBER. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Profile Options task.
AcademicTitle	String	False	No	The part of the person's title that denotes the academic qualification, such as Dr. Jane Smith.
AccountName	String	False	No	The name of the sales account that this contact belongs to.
AccountPartyId	Long	False	No	The unique identifier of sales account that this contact belongs to. To specify the account for a contact, you can provide an Account's party ID, PartyNumber, SourceSystem, or SourceSystemReference.
AccountPartyNumber	String	False	No	The party number of the sales account that this contact belongs to. To specify the account for a contact, you can provide an Account's party ID, PartyNumber, SourceSystem, or SourceSystemReference.
AccountSourceSystem	String	False	No	The Source System code of the sales account that this contact belongs to. To specify the account for a contact, you can provide an Account's party ID, PartyNumber, SourceSystem, or SourceSystemReference.
AccountSourceSystemReferenceValue	String	False	No	The Source System Reference value of the sales account that this contact belongs to. To specify the account for a contact, you can provide an Account's party ID, PartyNumber, SourceSystem, or SourceSystemReference.
AddressElementAttribute1	String	False	No	Additional address element to support flexible address format
AddressElementAttribute2	String	False	No	Additional address element to support flexible address format
AddressElementAttribute3	String	False	No	Additional address element to support flexible address format
AddressElementAttribute4	String	False	No	Additional address element to support flexible address format
AddressElementAttribute5	String	False	No	Additional address element to support flexible address format
AddressLine1	String	False	No	First line of address.
AddressLine2	String	False	No	Second line of address.
AddressLine3	String	False	No	Third line of address.
AddressLine4	String	False	No	Fourth line of address.
AddressLinesPhonetic	String	False	No	The phonetic or Kana representation of the Kanji address lines (used in Japan).
AddressNumber	String	False	No	Alternate unique identifier for the address. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address record during update. If not specified, then it is automatically generated. Prefix defined as in profile option ZCA_PUID_PREFIX concatenated with an internally generated unique sequence number.
AddressType	String	False	No	Additional information as type of address like BillTo, ShipTo.
AssignmentExceptionFlag	Bool	False	No	Indicates whether the sales account has the required dimensions to allow assignment manager to assign territories to the sales account. If the value is True, then the sales account has the required dimensions. The default is false.
Building	String	False	No	Specific building name or number at a given address.
CertificationLevel	String	False	No	The certification level of a contact. A list of accepted values are defined in the lookup HZ_PARTY_CERT_LEVEL. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
CertificationReasonCode	String	False	No	The reason for the contact's current certification level assignment. A list of accepted values are defined using the lookup HZ_PARTY_CERT_REASON. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
City	String	False	No	The city element of address.
ClassificationCategory	String	False	No	A valid classification category code for the contact. This is defined by an admin and is marked as primary.
ClassificationCode	String	False	No	A valid classification code corresponding to the classification category, which is marked as primary.
Comments	String	False	No	The textual comments about a contact.
ContactIsPrimaryForAccount	String	False	No	The preferred contact for the account.
ContactName	String	False	No	The derived name of the contact.
ContactRole	String	False	No	Specifies the role of the contact
ContactUniqueName	String	False	No	The unique contact name displayed on contact related screens. The default value for ContactUniqueName is the concatenation of attributes ContactName and UniqueNameSuffix. If the attribute UniqueNameSuffix is nil, then the ContactName is concatenated with a system generated number.
Country	String	False	No	Country code of the address.
County	String	False	No	County element of address.
CreatedBy	String	False	No	The user who created the contact record.
CreatedByModule	String	False	No	The application module that created this contact record. The default value for CreatedByModule is HZ_WS for all Web service based creation. A list of accepted values is defined in the lookup type HZ_CREATED_BY_MODULES. Review and update the value for this attribute using the Setup and Maintenance task work area, Manage Trading Community Common Lookups task.
CreationDate	Datetime	False	No	The date and time when the contact record was created.
CurrencyCode	String	False	No	The currency code. This attribute is used by CRM Extensibility framework. A list of valid values are defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
DataCloudStatus	String	False	No	The enrichment status of the contact record from Data 360. A list of accepted values are defined in the lookup DATA_CLOUD_STATUS. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
DateOfBirth	Date	False	No	The date when the person was born.
DateOfDeath	Date	False	No	Date the person died.
DeceasedFlag	Bool	False	No	Indicates whether the person is deceased or not. If the value is True, then the person is deceased. The default is False.
DeclaredEthnicity	String	False	No	The declared ethnicity of the person.
DeleteFlag	Bool	False	No	This flag controls if the user has access to delete the record
Department	String	False	No	The free form text used to name the department for the contact.
DepartmentCode	String	False	No	The department code for the contact. A list of accepted values is defined in the lookup DEPARTMENT_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task.
DoNotCallFlag	Bool	False	No	Indicates if the user can call the person or not. If the value is True, then the user must not call the person. The default is False. A list of accepted values is defined using the lookup YES_NO. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Common Lookups task.
DoNotContactFlag	Bool	False	No	Indicates if the user can contact the person or not by phone, e-mail, or mail. If the value is True, then the user must not contact the person. The default is False. A list of accepted values is defined using the lookup YES_NO. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Common Lookups task.
DoNotEmailFlag	Bool	False	No	Indicates if the user can e-mail the person or not. If the value is True, then the user must not contact the person by e-mail. The default is False. A list of accepted values is defined using the lookup YES_NO. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Common Lookups task.
DoNotMailFlag	Bool	False	No	Indicates if the user can send mail to the person or not. If the value is True, then the user must not contact the person by mail. The default is False. A list of accepted values is defined using the lookup YES_NO. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Common Lookups task.
EmailAddress	String	False	No	The e-mail address of the contact point.
EmailContactPointType	String	False	No
EmailFormat	String	False	No	The preferred format for e-mail addressed to this address such as HTML or ASCII. A list of accepted values is defined using the lookup EMAIL_FORMAT. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
ExistingCustomerFlag	Bool	False	No	Indicates whether there is an existing selling or billing relationship with the sales account. If the value is true, then there is an existing relationship with the sales account. The default value is False. Such relationships are defined by the existence of a Sell_To or Bill_To address.
ExistingCustomerFlagLastUpdateDate	Date	False	No	The date when the ExistingCustomerFlag was last modified. It is internally populated by the application.
FavoriteContactFlag	Bool	False	No	Indicates whether the person is a key contact. If the value is true, then person is a key contact. The default value is False.
FaxAreaCode	String	False	No	The area code.
FaxContactPointType	String	False	No
FaxCountryCode	String	False	No	The international country code for a telephone number, such as 33 for France.
FaxExtension	String	False	No	The additional number addressed after initial connection to an internal telephone system.
FaxNumber	String	False	No	A telephone number formatted in the local format without the area code, country code, or extension.
FirstName	String	False	No	First name of the person.
FloorNumber	String	False	No	Specific floor number at a given address or in a particular building when building number is provided
FormattedFaxNumber	String	False	No	The formatted fax number information.
FormattedHomePhoneNumber	String	False	No	Formatted mobile phone number information.
FormattedMobileNumber	String	False	No	The formatted mobile phone number information.
FormattedWorkPhoneNumber	String	False	No	The formatted work phone number information.
Gender	String	False	No	The gender of the person, such as male, female, and unknown. A list of accepted values are defined in the lookup HZ_GENDER. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
HeadOfHouseholdFlag	Bool	False	No	Indicates if the person is the head of the household. If the value is True, then the person is the head of the household. The default value is False.
HomePhoneAreaCode	String	False	No	The area code within a country code.
HomePhoneContactPointType	String	False	No
HomePhoneCountryCode	String	False	No	The international country code for a telephone number, such as 33 for France.
HomePhoneNumber	String	False	No	The home phone number formatted in the local format without the area code, country code, or extension.
HouseholdIncomeAmount	Decimal	False	No	The income of the household that this person is a part of.
HouseholdSize	Double	False	No	The size of the household this person is a part of.
Initials	String	False	No	The initials in the contact's name.
JobTitle	String	False	No	The free form text for job title.
JobTitleCode	String	False	No	Code given to the job title.
LastAssignmentDate	Date	False	No	The date when the Sales Account Territory Assignment was last run by Assignment Manager.
LastContactDate	Datetime	False	No	The date when the contact was last contacted.
LastEnrichmentDate	Date	False	No	The date when the contact record was last enriched with data from external sources by using Data-as-a-Service.
LastName	String	False	No	The last name of the person.
LastNamePrefix	String	False	No	The prefix for the last name of a person, such as fon, van. For example, if a person's name is Hans Van, the last name of the person is captured using this attribute.
LastUpdateDate	Datetime	False	No	The date and time when the contact was last updated.
LastUpdateLogin	String	False	No	Indicates the session login associated to the user who last updated the record.
LastUpdatedBy	String	False	No	The user who last updated the contact record.
Mailstop	String	False	No	A user-defined code to indicate a mail drop point within their organization
MaritalStatus	String	False	No	The marital status of the person. A list of accepted values is defined in the lookup MARITAL_STATUS. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
MaritalStatusEffectiveDate	Date	False	No	The date when the person's marital status was changed.
MiddleName	String	False	No	The middle name of the person.
MobileAreaCode	String	False	No	The area code for the contact's mobile phone.
MobileContactPointType	String	False	No
MobileCountryCode	String	False	No	The international country code for a contact's mobile phone number, such as 33 for France.
MobileExtension	String	False	No	The additional number addressed after initial connection to an internal telephone system.
MobileNumber	String	False	No	The mobile phone number formatted in the local format. The number should not include area code, country code, or extension.
NameSuffix	String	False	No	The place in a family structure. For example, in
NamedFlag	Bool	False	No	Indicates whether a sales account is a named sales account. If the value is true, then the sales account is a named sales account. The default value is False.
OverallPrimaryFormattedPhoneNumber	String	False	No
OwnerEmailAddress	String	False	No	The e-mail address of a valid employee resource who owns and manages the sales account. To assign an owner to the sales account, user can provide one of the following attributes pertaining to the owner: PartyID, PartyNumber or E-mail Address. This is provided if user wants to change the owner of the contact or create contact with a different owner than the login user. If provided, then OwnerPartyID, OwnerPartyNumber, and OwnerEmailAddress are honored in this order to determine the owner for the contact.
OwnerName	String	False	No	The name of the sales account owner.
OwnerPartyId	Long	False	No	The unique identifier of a valid employee resource who owns and manages the sales account. The owner is a valid employee resource defined within Sales Cloud. To assign an owner to the sales account, user can provide one of the following attributes pertaining to the owner: PartyID, PartyNumber, or E-mail Address. This is provided if user wants to change the owner of the contact or create contact with a different owner than the login user. If provided, then OwnerPartyID, OwnerPartyNumber, and OwnerEmailAddress are honored in this order to determine the owner for the contact. During create, if none of the OwnerPartyID, OwnerPartyNumber, or OwnerEmailAddress is provided, then the contact is assigned by default to the login user. The login user's partyID is used to populate OwnerPartyID.
OwnerPartyNumber	String	False	No	The party number of a valid employee resource who owns and manages the sales account. To assign an owner to the sales account, user can provide one of the following attributes pertaining to the owner: PartyID, PartyNumber, or E-mail Address. This is provided if user wants to change the owner of the contact or create contact with a different owner than the login user. If provided, then OwnerPartyID, OwnerPartyNumber, and OwnerEmailAddress are honored in this order to determine the owner for the contact.
PartyId	Long	False	No	The unique internal identifier of a contact party. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to uniquely identify the contact party.
PartyNumberKey	String	False	No
PartyStatus	String	False	No	The status of the contact. A list of valid values are defined in the lookup HZ_STATUS. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
PartyType	String	False	No
PersonProfileId	Long	False	No
PersonalIncomeAmount	Decimal	False	No	The estimated gross annual income of the person.
PlaceOfBirth	String	False	No	The place where the person was born, such as city or country.
PostalCode	String	False	No	Postal code as defined by the formal countrywide postal system
PostalPlus4Code	String	False	No	Four digit extension to the United States Postal ZIP code.
PreferredContactMethod	String	False	No	The preferred method to contact the person. A list of accepted values is defined in the lookup HZ_PREFERRED_CONTACT_METHOD. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Contact Point Lookups task.
PreferredFunctionalCurrency	String	False	No	The default currency code for this contact. A list of accepted values is defined using the Setup and Maintenance work area, Manage Currencies task.
PreviousLastName	String	False	No	The previous last name or surname of the person.
PrimaryAddressId	Long	False	No
Province	String	False	No	Province element of address.
RawFaxNumber	String	False	No	The unformatted fax number information.
RawHomePhoneNumber	String	False	No	Unformatted home phone number information.
RawMobileNumber	String	False	No	The unformatted mobile phone number information.
RawWorkPhoneNumber	String	False	No	The unformatted work phone number information.
RecordSet	String	False	No	The search results displayed under the selected record set.
RegistrationStatus	String	False	No	Specifies the registration status of the contact
RentOrOwnIndicator	String	False	No	Indicates if this contact owns or rents his or her residence. A list of valid values for rent, own, and lease is defined in the lookup OWN_RENT_IND. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
SalesAffinityCode	String	False	No	The affinity of a contact to the deploying organization. A list of accepted values are defined in the lookup HZ_SLS_CNTCT_AFFINITY_CODE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task.
SalesBuyingRoleCode	String	False	No	The roles played by a contact in the buying process, for example, decision maker or supporting role. A list of accepted values is defined in the lookup HZ_SLS_CNTCT_BUY_ROLE_CODE. Review and update the values for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task.
SalesProfileNumber	String	False	No
SalesProfileStatus	String	False	No	A valid user defined status of the sales account.
Salutation	String	False	No	The phrase used to address a contact party in any correspondence.
SalutoryIntroduction	String	False	No	The title or a salutary introduction for a contact, such as Mr., Herr, and so on. A list of accepted values is defined in the lookup CONTACT_TITLE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
SecondLastName	String	False	No	The second last name for a person. A list of accepted values is defined in the lookup HZ_PERSON_PROFILES. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
SellToPartySiteId	Long	False	No
SourceObjectType	String	False	No
SourceSystem	String	False	No	The name of external source system where the contact party is imported from. The values are configured in Setup and Maintenance work area, Manage Trading Community Source Systems task.
SourceSystemReferenceValue	String	False	No	The alternate unique identifier for the contact party from the external source system specified in the attribute SourceSystem.
State	String	False	No	State element of address.
TaxpayerIdentificationNumber	String	False	No	The taxpayer identification number, which is often a unique identifier of the contact. The typical values are taxpayer Id in USA or fiscal code or NIF in Europe.
Title	String	False	No	A professional or family title, such as Don or The Right Honorable.
Type	String	False	No	The contact party type that defines whether the contact is a sales account, a prospect, a contact or any other user-defined party type. The default value is ZCA_CUSTOMER. A list of accepted values is defined in the lookup ZCA_CONTACT_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
UniqueNameSuffix	String	False	No	The system generated or manually overridden suffix. The suffix is used to generate the PartyUniqueName attribute and is concatenated to the ContactName attribute to generate the PartyUniqueName. The primary address is defaulted as the suffix.
UpdateFlag	Bool	False	No	This flag controls if the user has access to update the record
WorkPhoneAreaCode	String	False	No	The area code for the contact's work phone.
WorkPhoneContactPointType	String	False	No
WorkPhoneCountryCode	String	False	No	The international country code for a contact's work phone number, such as 33 for France.
WorkPhoneExtension	String	False	No	The additional number addressed after initial connection to an internal telephone system.
WorkPhoneNumber	String	False	No	The work phone number formatted in the local format without the area code, country code, or extension.
Finder	String	False	Yes	Input specifying the Finder type.
BindUserPartyId	String	False	Yes	The unique identifier of the contact.

Return to Top

ContactSalesAccountResources

Name	Type	ReadOnly	References	FilterOnly	Description
TeamMemberId [KEY]	Long	False		No	This is the primary key of the sales account resources table.
PartyNumber [KEY]	String	False	Contacts.PartyNumber	No
AccessLevelCode	String	False		No	The type of access granted to the resource as well as managers of the organizations. A list of accepted values is defined in the lookup ZCA_ACCESS_LEVEL. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
AssignmentTypeCode	String	False		No	The code indicating how the resource is assigned to the sales account team. A list of accepted values is defined in the lookup ZCA_ASSIGNMENT_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
CreatedBy	String	False		No	The user who created the sales team member record.
CreationDate	Datetime	False		No	The date and time when the sale team member record was created.
EndDateActive	Date	False		No	Date on which this sales team member is no longer active.
LastUpdateDate	Datetime	False		No	The date when the sales team member record was last updated.
LastUpdatedBy	String	False		No	The user who last updated the sales team member record.
LastUpdateLogin	String	False		No	The session login associated to the user who last updated the sales team member record.
LockAssignmentFlag	Boolean	False		No	Indicates if the automatic territory assignment can be set. If the value is True, then the automatic territory assignment cannot remove the sales account team resource. The default value is False. When a sales account team member is added manually, this flag is defaulted to `Y'.
MemberFunctionCode	String	False		No	The code indicating the role of a sales team member in the resource team such as Integrator, Executive Sponsor, and Technical Account Manager. A list of accepted values is defined in the lookup FND_LOOKUPS. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
ResourceEmailAddress	String	False		No	The e-mail address of the resource.
ResourceId	Long	False		No	The unique party ID for the existing resource record in Oracle Sales.
ResourceName	String	False		No	The name of the sales team member.
ResourceOrgName	String	False		No	The name of the organization that the sales team member belongs to.
ResourcePartyNumber	String	False		No	The unique public identifier of the resource record.
ResourcePhoneNumber	String	False		No	The primary phone number of the sales team member.
ResourceRoleName	String	False		No	The roles assigned to the sales team member.
SalesProfileId	Long	False		No	The unique identifier of the sales profile of the resource.
StartDateActive	Date	False		No	Date on which this sales team member becomes active.
UserLastUpdateDate	Datetime	False		No	The date and time when the sales team member was last updated from mobile.
ContactLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
PartyId	Long	False		No	The unique identifier of the party.
Finder	String	False		Yes	Input specifying the Finder type.
BindUserPartyId	String	False		Yes	The unique identifier of the contact.
PersonProfileId	String	False		Yes	The unique identifier of the contact.
SourceSystem	String	False		Yes	The name of external source system where the contact party is imported from.
SourceSystemReferenceValue	String	False		Yes	The unique identifier for the contact party from the external source system.

Return to Top

ContactsPictureAttachments

Name	Type	ReadOnly	References	FilterOnly	Description
AttachedDocumentId [KEY]	Long	False		No	The Id of Attachment.
PartyNumber [KEY]	String	False	Contacts.PartyNumber	No	The unique identifier for the resource party.
ContentRepositoryFileShared	Boolean	False		No	Indicates if the attachment is shared.
CreatedBy	String	False		No	The user who uploaded the picture attachment.
CreationDate	Datetime	False		No	The date when the picture attachment was uploaded.
DatatypeCode	String	False		No	The data type for the picture attachment.
Description	String	False		No	The description of the picture attachment.
DmFolderPath	String	False		No	The folder path where the picture attachment exists.
ErrorStatusCode	String	False		No	The error code, if any, for the attachment.
ErrorStatusMessage	String	False		No	The error message, if any, for the attachment.
ExpirationDate	Datetime	False		No	The expiration date of the contents in the attachment.
FileContents	String	False		No	The contents of the attachment.
FileName	String	False		No	The name of the attachment file.
FileUrl	String	False		No	The URL of the attachment file.
LastUpdateDate	Datetime	False		No	The date when the record was last updated.
LastUpdatedBy	String	False		No	The user who last updated the record.
Title	String	False		No	The title of the attachment.
UploadedFileContentType	String	False		No	The content type of the attachment.
UploadedFileLength	Long	False		No	The length of the attachment file.
UploadedFileName	String	False		No	The name of the attachment file.
UploadedText	String	False		No	The text uploaded in the attachment.
Uri	String	False		No	The URI of the attachment.
Url	String	False		No	The URL of the attachment.
UserName	String	False		No	The login associated with the attachment.
Finder	String	False		Yes	Input specifying the Finder type.
BindUserPartyId	String	False		Yes	The unique identifier of the contact.
PartyId	String	False		Yes	The unique identifier of the contact.
PersonProfileId	String	False		Yes	The unique identifier of the contact.
SourceSystem	String	False		Yes	The name of external source system where the contact party is imported from.
SourceSystemReferenceValue	String	False		Yes	The unique identifier for the contact party from the external source system.

Return to Top

EmployeeResourceAttachments

Name	Type	ReadOnly	FilterOnly	Description
AttachedDocumentId [KEY]	Long	False	No	This is the hash key of the attributes which make up the composite key--- AttachedDocumentId and DocumentId1 ---for the Attachments resource and used to uniquely identify an instance of Attachments. The client should not generate the hash key value. Instead, the client should query on the Attachments collection resource with a filter on the primary key values in order to navigate to a specific instance of Attachments.
PartyNumber [KEY]	String	False	No	The unique identifier for the resource party.
ContentRepositoryFileShared	Boolean	False	No	Indicates if the attachment is shared.
CreatedBy	String	False	No	The user who uploaded the picture attachment.
CreationDate	Datetime	False	No	The date when the picture attachment was uploaded.
DatatypeCode	String	False	No	The data type for the picture attachment.
Description	String	False	No	The description of the picture attachment.
DmFolderPath	String	False	No	The folder path where the picture attachment exists.
ErrorStatusCode	String	False	No	The error code, if any, for the attachment.
ErrorStatusMessage	String	False	No	The error message, if any, for the attachment.
ExpirationDate	Datetime	False	No	The expiration date of the contents in the attachment.
FileContents	String	False	No	The contents of the attachment.
FileName	String	False	No	The name of the attachment file.
FileUrl	String	False	No	The URL of the attachment file.
LastUpdateDate	Datetime	False	No	The date when the record was last updated.
LastUpdatedBy	String	False	No	The user who last updated the record.
Title	String	False	No	The title of the attachment.
UploadedFileContentType	String	False	No	The content type of the attachment.
UploadedFileLength	Long	False	No	The length of the attachment file.
UploadedFileName	String	False	No	The name of the attachment file.
UploadedText	String	False	No	The text uploaded in the attachment.
Uri	String	False	No	The URI of the attachment.
Url	String	False	No	The URL of the attachment.
UserName	String	False	No	The login associated with the attachment.
Finder	String	False	Yes	Input specifying the Finder type.
EmailAddress	String	False	Yes	The e-mail address of the resource.
BindSysdate	String	False	Yes	The identifier for the resource based on the manager reports flag.
PartyId	String	False	Yes	The unique identifier for the resource party.
ResourceProfileId	String	False	Yes	The unique primary key identifier for the resource profile.

Return to Top

EmployeeResources

Name	Type	ReadOnly	FilterOnly	Description
PartyNumber [KEY]	String	False	No	Unique identification number for this party
EmailAddress	String	False	No	E-mail address
EndDateActive	Date	False	No	Indicates the date at which the resource becomes inactive
FormattedAddress	String	False	No	Primary Formatted address for the resource
FormattedPhoneNumber	String	False	No	Primary Formatted phone number for the resource
PartyId	Long	False	No	Identifier for the party. Foreign key to the HZ_PARTIES PARTY_ID.
PartyName	String	False	No	Name of the Party
PersonFirstName	String	False	No	Peron First Name
PersonLastName	String	False	No	Peron LastName
PersonLastNamePrefix	String	False	No	Resource Peron Last name
PersonMiddleName	String	False	No	Peron Middle Name.
PersonNameSuffix	String	False	No	Peron Name suffix
PersonPreNameAdjunct	String	False	No	Person Preferred Name adjacency
PersonPreviousLastName	String	False	No	perin Previous flag mage
PersonSecondLastName	String	False	No	peron secind last name
ResourceProfileId	Long	False	No	Unique identifier for the Resource Profile. Primary Key.
ResourceType	String	False	No	Type of Resource ex employee
StartDateActive	Date	False	No	Indicates the date at which the resource becomes active
Url	String	False	No	Primary URL for the resource
Usage	String	False	No	Read only party usage for resource party
Finder	String	False	Yes	Input specifying the Finder type.
BindSysdate	String	False	Yes	The identifier for the resource based on the manager reports flag.

Return to Top

Leads

Name	Type	ReadOnly	FilterOnly	Description
LeadId [KEY]	Long	False	No	Partner Type. Indicates the type of partner stamped on the lead.
AcceptedDate	Date	False	No	The date on which lead was accepted by a resource assigned to it.
AcceptedDateTime	Datetime	False	No	Date and time when the sales lead is accepted by a resource assigned to it.
AccountPartyNumber	String	False	No
AddrElementAttribute1	String	False	No	Additional address element to support flexible address format.
AddrElementAttribute2	String	False	No	Additional address element to support flexible address format.
AddrElementAttribute3	String	False	No	Additional address element to support flexible address format.
AddrElementAttribute4	String	False	No	Additional address element to support flexible address format.
AddrElementAttribute5	String	False	No	Additional address element to support flexible address format.
AddressLinesPhonetic	String	False	No	Phonetic or Kana representation of the Kanji address lines (used in Japan).
ApprovalDate	Date	False	No	The date on which a partner registered lead is approved by internal channel manager.
ApprovalDateTime	Datetime	False	No	Date and time when the sales lead is approved. This is only applicable to deal registrations.
AssetId	Long	False	No	Unique identifier for the Asset associated with the Sales Lead.
AssetNumber	String	False	No	Unique Number for the Asset associated with the Sales Lead.
AssetSerialNumber	String	False	No	Serial Number for the Asset associated with the Sales Lead.
AssignmentStatusCode	String	False	No	Includes the current assignment related status for the lead, for example whether the lead is assigned or unassigned.
BudgetAmount	Decimal	False	No	Budget amount associated with this sales lead.
BudgetCurrencyCode	String	False	No	Currency code associated with the Budget Amount associated with this sales lead.
BudgetStatus	String	False	No	Budget status associated with the Budget Amount associated with this sales lead.
Building	String	False	No	Specific building name or number at a given address.
BusinessUnitId	Long	False	No	Business Unit Identifier associated with the business unit of the sales lead creator.
CampaignName	String	False	No	Name of the campaign associated with the sales lead.
ChannelType	String	False	No	Indicates the channel through which this lead contacted the company.
ClassCode1	String	False	No	The auxilliary dimension for the Account.
ClassCode2	String	False	No	The auxilliary dimension for the Account.
ClassCode3	String	False	No	The auxilliary dimension for the Account.
ClassCode4	String	False	No	The auxilliary dimension for the Account.
ContactFormattedAddress	String	False	No
ContactPartyNumber	String	False	No
ContactTimezoneCd	String	False	No	Preferred time zone of the contact pursued on the lead.
ConvertedDateTime	Datetime	False	No	Date and time when the sales lead is converted to an opportunity.
CreatedBy	String	False	No	Indicates the user who created this record.
CreationDate	Datetime	False	No	Indicates the date and time when this record is created.
CurrencyCode	String	False	No	Currency code for the lead.
CustomerId	Long	False	No	Customer Id. It is a reference to the customer record in the TCA schema.
CustomerNeed	String	False	No	Indicates what need the lead product serves for the lead customer.
CustomerPartyName	String	False	No	Name of the customer.
DealAmount	Decimal	False	No	The total amount attributed to a lead.
DecisionMakerIdentifiedFlag	Bool	False	No	Indicates if the decision maker at customer site has been identified.
DeleteFlag	Bool	False	No	This flag controls if the user has access to delete the record
Description	String	False	No	Description associated with this sales lead.
Distance	Double	False	No	Distance from the input location.
EstimatedCloseDate	Date	False	No	Estimated close date for a deal once registered
ExpirationDate	Date	False	No	Expiration date associated with this sales lead.
FloorNumber	String	False	No	Specific floor number at a given address or in a particular building when building number is provided.
FormattedPhoneNumber1	String	False	No
InventoryItemDescription	String	False	No	The description of the product added to a lead.
JobTitle	String	False	No	Job title of the primary contact on the sales lead.
LastAssignmentDate	Datetime	False	No	The date on which the lead was last reassigned.
LastUpdateDate	Datetime	False	No	Who column: indicates the date and time of the last update of the row.
LastUpdateLogin	String	False	No	Who column: indicates the login of the user who last updated the row.
LastUpdatedBy	String	False	No	Who column: indicates the user who last updated the row.
Latitude	Double	False	No	Latitude information for the location.
LeadAcceptedFlag	Bool	False	No	Indicates if the lead has been accepted.
LeadAging	Long	False	No	The number of days elapsed since the lead was created.
LeadCreatedBy	String	False	No	Functional WHO: Indicates the user who created this record.
LeadCreationDate	Datetime	False	No	Functional WHO: Indicates the date and time when this record is created.
LeadLastUpdateDate	Datetime	False	No	Functional WHO: Indicates the date and time of the last update of the row.
LeadLastUpdatedBy	String	False	No	Functional WHO: Indicates the user who last updated the row.
LeadNumber	String	False	No	User friendly unique identifier for a lead.
Longitude	Double	False	No	Longitude information for the location.
Name	String	False	No	Lead Name used for identifying the lead.
OrganizationSize	String	False	No	Organization Size
OrganizationType	String	False	No	Organization Type
OwnerId	Long	False	No	Party identifier associated with the owner of this sales lead.
OwnerPartyName	String	False	No	Name associated with the owner of this sales lead.
OwnerPartyNumber	String	False	No
PartnerCompanyNumber	String	False	No
PartnerId	Long	False	No	Unique identifier for the primary partner associated with the lead.
PartnerPartyName	String	False	No	Name associated with the primary partner of this sales lead. This is a deal specific attribute.
PartnerProgramId	Long	False	No	A reference to the partner program in which the primary partner associated with this sales lead is enrolled. This is a deal specific attribute.
PartnerProgramNumber	String	False	No
PartnerType	String	False	No	Indicates the type of the primary partner associated with this sales lead. This is a deal specific attribute.
PostalPlus4Code	String	False	No	Four digit extension to the United States Postal ZIP code.
PrimaryContactAddress1	String	False	No	The first line of address associated with the primary contact of the lead.
PrimaryContactAddress2	String	False	No	The second line of address associated with the primary contact of the lead.
PrimaryContactAddress3	String	False	No	The third line of address associated with the primary contact of the lead.
PrimaryContactAddress4	String	False	No	The fourth line of address associated with the primary contact of the lead.
PrimaryContactCity	String	False	No	The city where the primary contact of the lead is located.
PrimaryContactCountry	String	False	No	The country where the primary contact of the lead is located.
PrimaryContactCountryName	String	False	No	Full name associated with primary contact country code
PrimaryContactCounty	String	False	No	The county where the primary contact of the lead is located.
PrimaryContactEmailAddress	String	False	No	Email address for the primary sales lead contact on the lead
PrimaryContactId	Long	False	No	Identifer of the sales lead contact marked as a primary lead contact.
PrimaryContactPartyName	String	False	No	Name associated with the primary lead contact.
PrimaryContactPersonFirstName	String	False	No	First name of the primary contact for a lead.
PrimaryContactPersonLastName	String	False	No	Last name of the primary contact for a lead.
PrimaryContactPersonMiddleName	String	False	No	Middle name of the primary contact for a lead.
PrimaryContactPostalCode	String	False	No	The zip code where the primary contact of the lead is located.
PrimaryContactProvince	String	False	No	The province where the primary contact of the lead is located.
PrimaryContactRelationshipId	Long	False	No	Unique identifier of the relationship primary contact has with its parent organization.
PrimaryContactState	String	False	No	The state where the primary contact of the lead is located.
PrimaryInventoryItemId	Long	False	No	Unique identifier of the primary product associated with a lead.
PrimaryInventoryItemNumber	String	False	No
PrimaryInventoryOrgId	Long	False	No	Unique identifier of the organization to which the primary product associated with a lead belongs.
PrimaryPhoneAreaCode	String	False	No	Primary phone area code for the sales lead contact.
PrimaryPhoneCountryCode	String	False	No	Primary phone country code for the sales lead contact.
PrimaryPhoneNumber	String	False	No	Primary phone number for the sales lead contact.
PrimaryProductGroupId	Long	False	No	Unique identifier of the primary product group associated with a lead.
PrimaryProductGroupReferenceNumber	String	False	No
ProductGroupDescription	String	False	No	Description of the product or product group associated with a lead.
ProductGroupName	String	False	No	Name of the product group associated with a lead.
ProgramName	String	False	No	Name of the partner program in which the primary partner associated with this sales lead is enrolled. This is a deal specific attribute.
Project	String	False	No	customer project identified for this sales lead.
QualificationScore	Long	False	No	Qualification score for a lead.
QualifiedDate	Date	False	No	Indicates the date when this sales lead was qualified.
QualifiedDateTime	Datetime	False	No	Date and time when the sales lead is qualified.
Rank	String	False	No	Rank associated with this sales lead.
ReassignComment	String	False	No	Comment provided by a user while requesting the lead reassignment.
ReassignReasonCode	String	False	No	Pre-defined code used to indicate the reason for lead reassignment.
RecordSet	String	False	No
RegistrationNumber	String	False	No	Registration number of the sales lead. This unique identifier is generated when the sales lead is approved. This is a deal specific attribute.
RegistrationStatus	String	False	No	Approval Status of the sales lead. This is a deal specific attribute.
RegistrationType	String	False	No	Indicates the registration type of the sales lead. This is a deal specific attribute.
RejectByUserId	Long	False	No	Identifier of the sales representative who rejected this sales lead.
RejectComment	String	False	No	Comments provided by the sales representative who rejected this sales lead.
RejectReasonCode	String	False	No	Pre-defined code used to indicate the reason for rejecting a lead.
RejectedDateTime	Datetime	False	No	Date and time when the sales lead is rejected.
RetireComment	String	False	No	Comments recorded when the sales lead is moved to a retired status.
RetireReasonCode	String	False	No	Pre-defined code used to indicate the reason for retiring a lead.
RetiredDateTime	Datetime	False	No	Date and time when the sales lead is moved to a retired status.
SalesChannel	String	False	No	Indicates the sales channel responsible for following up on this sales lead.
Score	Long	False	No	The score associated with this sales lead. This score is computed based on the scoring rules.
SourceCode	String	False	No	Marketing source code associated with this sales lead.
StatusCode	String	False	No	Pre-defined code used to indicate the status of a lead.
Timeframe	String	False	No	Timeframe associated with this sales lead.
ToReassignFlag	Bool	False	No	Identifies leads that are marked for reassignment.
UpdateFlag	Bool	False	No	This flag controls if the user has access to update the record
WorkPhoneAreaCode	String	False	No	Work phone area code for the sales lead contact.
WorkPhoneCountryCode	String	False	No	Work phone country code for the sales lead contact.
WorkPhoneNumber	String	False	No	Work phone number for the sales lead contact.
Finder	String	False	Yes	Input specifying the Finder type.
ContactId	String	False	Yes	The unique identifier of the Contact.
SysEffectiveDate	String	False	Yes	SysEffectiveDate.
ResourcePartyIdRest	String	False	Yes	The unique identifier of the Resource.
RestCreationDateLower	String	False	Yes	Finds the leads that are created before the date specified.
RestCreationDateUpper	String	False	Yes	Finds the leads with the specified creation date.
RestRecordSet	String	False	Yes	Finds the leads with the specified record set value.
RestStatusCode	String	False	Yes	Finds the leads with the specified status code.

Return to Top

LightboxDocuments

Name	Type	ReadOnly	FilterOnly	Description
LightboxDocumentId [KEY]	String	False	No
CreatedBy	String	False	No
CreationDate	Datetime	False	No
CurrencyCode	String	False	No
CurrentRevision	String	False	No
DeleteFlag	Bool	False	No
DocumentContents	String	False	No
DocumentDownloadURL	String	False	No
DocumentDownloadedCount	Long	False	No
DocumentOwnerFlag	Bool	False	No
DocumentPageCount	Int	False	No
DocumentSharedToEntityCount	Long	False	No
DocumentSharedToUserCount	Long	False	No
DocumentThumbnailURL	String	False	No
DocumentTitle	String	False	No
DocumentType	String	False	No
DocumentTypeCode	String	False	No
DocumentUnsharedFromUserCount	Long	False	No
DocumentViewedInLightboxCount	Long	False	No
DocumentViewedOutsideLightboxCount	Long	False	No
FileName	String	False	No
FileSize	Long	False	No
IsDocumentReadyFlag	Bool	False	No
IsDocumentUploadInProgressFlag	Bool	False	No
IsSharedWithCurrentUserFlag	Bool	False	No
KeyPageSequenceNumber	Long	False	No
LastUpdateDate	Datetime	False	No
LastUpdateLogin	String	False	No
LastUpdatedBy	String	False	No
OriginalOwnerEmailAddress	String	False	No
OriginalOwnerName	String	False	No
OriginalOwnerPartyId	Long	False	No
PublicDocumentDate	String	False	No
PublicDocumentFlag	Bool	False	No
SharedDate	Datetime	False	No
Thumbnail	String	False	No
UpdateFlag	Bool	False	No
UploadDate	Datetime	False	No
Finder	String	False	Yes	Input specifying the Finder type.

Return to Top

Opportunities

Name	Type	ReadOnly	FilterOnly	Description
OptyNumber [KEY]	String	False	No	The unique alternate identifier for the opportunity.
AverageDaysAtStage	Int	False	No	The average duration, in number of days, the opportunity remains in the current sales stage.
BudgetAvailableDate	Date	False	No	The date when the budget will be available.
BudgetedFlag	Boolean	False	No	Indicates if the opportunity sales account has the budget approved for the potential purchase. If the value is true, then the sales account has the budget approved for the purchase. The default value is False.
ChampionFlag	Boolean	False	No	Indicates if the opportunity has an internal sponsor. If the value is true, then the opportunity has an internal sponsor. The default value is False.
CreatedBy	String	False	No	The user who created the opportunity record.
CreationDate	Datetime	False	No	The date and time when the record was created.
CurrencyCode	String	False	No	The currency used by the opportunity.
CustomerAccountId	Long	False	No	The customer account associated with the opportunity.
DealHorizonCode	String	False	No	The estimated time, in days, required to close the deal. A list of valid values is defined in the lookup MOO_SETID_DEAL_HORIZION. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
DecisionLevelCode	String	False	No	The job level of the person who takes the final decision for the opportunity. A list of valid values is defined in the lookup MOO_SETID_DECISION_LEVEL. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
DeleteFlag	Boolean	False	No	Indicates whether the opportunity can be deleted.
Description	String	False	No	The description of the opportunity including the sales objective. The description is added by the Sales Representative.
DescriptionText	String	False	No	The description of the sales objective of the opportunity.
DownsideAmount	Decimal	False	No	The minimum amount of revenue for the opportunity.
EffectiveDate	Date	False	No	The date when the opportunity may to close.
EmailAddress	String	False	No	The e-mail address of the employee resource that owns the opportunity.
ExpectAmount	Decimal	False	No	The expected revenue from the opportunity.
KeyContactId	Long	False	No	The unique identifier of the primary contact of the opportunity.
LastUpdateDate	Datetime	False	No	The date when the record was last updated.
LastUpdatedBy	String	False	No	The user who last updated the opportunity record.
LastUpdateLogin	String	False	No	The session login associated to the user who last updated the record.
LineOfBusinessCode	String	False	No	The line of business that owns the opportunity.
MaximumDaysInStage	Int	False	No	The maximum duration, in number of days, that an opportunity can be in sales stage before it is considered stalled.
Name	String	False	No	The name of the opportunity.
OptyId	Long	False	No	The unique identifier of the opportunity.
OwnerResourcePartyId	Long	False	No	The unique identifier of a valid employee resource who owns and manages the opportunity.
PartyName1	String	False	No	The name of the opportunity owner.
PartyUniqueName1	String	False	No	The unique name of the primary competitor for the opportunity.
PhaseCd	String	False	No	The current phase of the opportunity sales stage.
PrimaryCompetitorId	Long	False	No	The unique identifier of the primary competitor for this opportunity.
PrimaryContactEmailAddress	String	False	No	The e-mail address of the primary contact for the opportunity.
PrimaryContactFormattedPhoneNumber	String	False	No	The formatted phone number of the primary contact for the opportunity.
PrimaryContactPartyName	String	False	No	The name of the opportunity's primary contact.
PrimaryOrganizationId	Long	False	No	The unique identifier of the business unit to which this opportunity belongs.
PrimaryPartnerId	Long	False	No	The unique identifier of the primary partner associated with the opportunity.
PrimaryPartnerOrgPartyName	String	False	No	The name of the primary partner associated with the opportunity.
PrimaryRevenueId	Long	False	No	The unique identifier of the summary revenue line for the opportunity. The summary revenue line stores the total revenue amount of the opportunity.
PrSrcNumber	String	False	No	The unique identifier number of the primary marketing source or campaign that generated this opportunity.
QuotaFactor	Decimal	False	No	The quota factor of the opportunity sales stage.
RcmndWinProb	Decimal	False	No	The recommended probability of winning the opportunity in the sales stage.
ReasonWonLostCode	String	False	No	The reason for winning or losing the opportunity. A list of valid values is defined in the lookup MOO_SETID_WIN_LOSS_REASON. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
Registered	String	False	No	Indicates whether the opportunity was registered. The valid values are Expired, Yes, and No.
RegistrationStatus	String	False	No	The registration status of the opportunity or deal created by a partner.
RegistrationType	String	False	No	The registration type used by the partner to create the opportunity or deal.
Revenue	Double	False	No	The estimated revenue amount from the opportunity.
RiskLevelCode	String	False	No	The risk level code of the opportunity. A list of valid values is defined in the lookup MOO_SETID_RISK_LEVE. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
SalesAccountUniqueName	String	False	No	The unique name of the sales account that owns the opportunity.
SalesChannelCd	String	False	No	The sales channel for the opportunity.
SalesMethod	String	False	No	The sales method associated with the opportunity.
SalesMethodId	Long	False	No	The sales method identifier for this opportunity, and indicates the sales process used.
SalesStage	String	False	No	The current sales stage of the opportunity.
SalesStageId	Long	False	No	The unique identifier for the sales stage of the opportunity.
StageStatusCd	String	False	No	The default status for the opportunity's sales stage.
StatusCode	String	False	No	The status of the opportunity. A list of valid values is defined in the lookup MOO_OPTY_STATUS. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
StgOrder	Decimal	False	No	The order of the opportunity's sales stage in the sales method.
StrategicLevelCode	String	False	No	The strategic value that the opportunity has for the sales account. A list of valid values is defined in the lookup MOO_SETID_STRATEGIC_VALUE. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
TargetPartyId	Long	False	No	The unique identifier of the sales account that owns the opportunity.
TargetPartyName	String	False	No	The name of the sales account that owns the opportunity.
UpdateFlag	Boolean	False	No	Indicates whether the opportunity can be updated.
UpsideAmount	Decimal	False	No	The maximum amount of revenue for the opportunity.
WinProb	Long	False	No	The estimated probability of winning the opportunity.
ClosePeriod	String	False	No	The names of the filter on which opportunities can be filtered based on effective date range.
LookupCategory	String	False	No	The status category of the opportunity status
RecordSet	String	False	Yes	Input specifying the resource type.
Finder	String	False	Yes	Input specifying the Finder type.
PartyId	String	False	Yes	Input specifying the Party Id.
PartyIdAttribute	String	False	Yes	Input specifying the Party Id Attribute.
AttributeName	String	False	Yes	Input specifying the Attribute Name.
RollUpId	String	False	Yes	Input specifying the RollUp Id.
SourceObject	String	False	Yes	Input specifying the Source Object.
SourceObjectId	String	False	Yes	Input specifying the Source Object Id.
ContactPartyId	String	False	Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False	Yes	Input specifying the Effective BeginDate.
EffectiveEndDate	String	False	Yes	Input specifying the Effective EndDate.
LeadNumber	String	False	Yes	Input specifying the Lead Number.
OpportunityContactName	String	False	Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False	Yes	Input specifying the Opty StatusCode.
Partner	String	False	Yes	Input specifying the Partner.
PartnerPartyId	String	False	Yes	Input specifying the Partner Party Id.
Product	String	False	Yes	Input specifying the Product.
ProductGroup	String	False	Yes	Input specifying the Product Group.
ReferenceName	String	False	Yes	Input specifying the Reference Name.
ResourcePartyId	String	False	Yes	Input specifying the Resource Party Id.
TeamMember	String	False	Yes	Input specifying the Team Member.

Return to Top

OpportunityAssessments

Name	Type	ReadOnly	References	FilterOnly	Description
AssessmentId [KEY]	Long	False		No	AssessmentId
OptyNumber [KEY]	String	False	Opportunities.OptyNumber	No	OptyNumber
AssessTemplateId	Long	False		No	AssessTemplateId
AssessedLanguage	String	False		No	AssessedLanguage
AssessedObjTypeCode	String	False		No	AssessedObjTypeCode
AssessedObjectId	Long	False		No	AssessedObjectId
AssessmentScore	Int	False		No	AssessmentScore
BusinessUnit	Long	False		No	BusinessUnit
ConflictId	Long	False		No	ConflictId
CreatedBy	String	True		No	CreatedBy
LastUpdateDate	Datetime	True		No	LastUpdateDate
LastUpdatedBy	String	True		No	LastUpdatedBy
Name	String	False		No	Name
RatingFeedback	String	True		No	RatingFeedback
RatingTerm	String	True		No	RatingTerm
StatusCode	String	False		No	StatusCode
StatusFuse	String	True		No	StatusFuse
TemplateName	String	False		No	TemplateName
TemplateType	String	False		No	TemplateType
TotalAnswered	Double	False		No	TotalAnswered
TotalQuestions	Double	False		No	TotalQuestions
OpportunityLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
RecordSet	String	False		Yes	Input specifying the resource type.
Finder	String	False		Yes	Input specifying the Finder type.
PartyId	String	False		Yes	Input specifying the Party Id.
PartyIdAttribute	String	False		Yes	Input specifying the Party Id Attribute.
AttributeName	String	False		Yes	Input specifying the Attribute Name.
RollUpId	String	False		Yes	Input specifying the RollUp Id.
SourceObject	String	False		Yes	Input specifying the Source Object.
SourceObjectId	String	False		Yes	Input specifying the Source Object Id.
ClosePeriod	String	False		Yes	Input specifying the Close Period.
ContactPartyId	String	False		Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False		Yes	Input specifying the Effective BeginDate.
EffectiveEndDate	String	False		Yes	Input specifying the Effective EndDate.
LeadNumber	String	False		Yes	Input specifying the Lead Number.
LookupCategory	String	False		Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False		Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False		Yes	Input specifying the Opty StatusCode.
Partner	String	False		Yes	Input specifying the Partner.
PartnerPartyId	String	False		Yes	Input specifying the Partner Party Id.
Product	String	False		Yes	Input specifying the Product.
ProductGroup	String	False		Yes	Input specifying the Product Group.
ReferenceName	String	False		Yes	Input specifying the Reference Name.
ResourcePartyId	String	False		Yes	Input specifying the Resource Party Id.
TeamMember	String	False		Yes	Input specifying the Team Member.
OptyId	String	False		Yes	Input specifying the Opty Id.

Return to Top

OpportunityAttachments

Name	Type	ReadOnly	References	FilterOnly	Description
AttachedDocumentId [KEY]	Long	False		No	The unique identifier of the attached document.
OptyNumber [KEY]	String	False	Opportunities.OptyNumber	No	OptyNumber
AsyncTrackerId	String	False		No	Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files.
CategoryName	String	False		No	The category of the attachment.
ContentRepositoryFileShared	Bool	False		No	Indicates whether the attachment is shared
CreatedBy	String	False		No	The user who created the record.
CreatedByUserName	String	False		No	The user name who created the record.
CreationDate	Datetime	False		No	The date when the record was created.
DatatypeCode	String	False		No	A value that indicates the data type.
Description	String	False		No	The description of the attachment.
DmDocumentId	String	False		No	The document ID from which the attachment is created.
DmFolderPath	String	False		No	The folder path from which the attachment is created.
DmVersionNumber	String	False		No	The document version number from which the attachment is created.
DownloadInfo	String	False		No	JSON object represented as a string containing information used to programmatically retrieve a file attachment.
ErrorStatusCode	String	False		No	The error code, if any, for the attachment.
ErrorStatusMessage	String	False		No	The error message, if any, for the attachment.
ExpirationDate	Datetime	False		No	The expiration date of the contents in the attachment.
FileContents	String	False		No	The contents of the attachment.
FileName	String	False		No	The file name of the attachment.
FileUrl	String	False		No	The URI of the file.
FileWebImage	String	False		No	The base64 encoded image of the file displayed in .png format if the source is a convertible image.
LastUpdateDate	Datetime	False		No	The date when the record was last updated.
LastUpdatedBy	String	False		No	The user who last updated the record.
LastUpdatedByUserName	String	False		No	The user name who last updated the record.
PostProcessingAction	String	False		No	The name of the action that can be performed after an attachment is uploaded.
Title	String	False		No	The title of the attachment.
UploadedFileContentType	String	False		No	The content type of the attachment.
UploadedFileLength	Long	False		No	The size of the attachment file.
UploadedFileName	String	False		No	The name to assign to a new attachment file.
UploadedText	String	False		No	The text content for a new text attachment.
Uri	String	False		No	The URI of a Topology Manager type attachment.
Url	String	False		No	The URL of a web page type attachment.
UserName	String	False		No	The login credentials of the user who created the attachment.
OpportunityLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
RecordSet	String	False		Yes	Input specifying the resource type.
Finder	String	False		Yes	Input specifying the Finder type.
PartyIdAttribute	String	False		Yes	Input specifying the Party Id Attribute.
AttributeName	String	False		Yes	Input specifying the Attribute Name.
RollUpId	String	False		Yes	Input specifying the RollUp Id.
SourceObject	String	False		Yes	Input specifying the Source Object.
SourceObjectId	String	False		Yes	Input specifying the Source Object Id.
ClosePeriod	String	False		Yes	Input specifying the Close Period.
ContactPartyId	String	False		Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False		Yes	Input specifying the Effective BeginDate.
LeadNumber	String	False		Yes	Input specifying the Lead Number.
LookupCategory	String	False		Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False		Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False		Yes	Input specifying the Opty StatusCode.
Partner	String	False		Yes	Input specifying the Partner.
PartnerPartyId	String	False		Yes	Input specifying the Partner Party Id.
Product	String	False		Yes	Input specifying the Product.
ProductGroup	String	False		Yes	Input specifying the Product Group.
ReferenceName	String	False		Yes	Input specifying the Reference Name.
ResourcePartyId	String	False		Yes	Input specifying the Resource Party Id.
TeamMember	String	False		Yes	Input specifying the Team Member.
OptyId	String	False		Yes	Input specifying the Opty Id.

Return to Top

OpportunityCampaigns

Name	Type	ReadOnly	References	FilterOnly	Description
OptyCampaignId [KEY]	Long	False		No	OptyCampaignId
OptyNumber [KEY]	String	False	Opportunities.OptyNumber	No	OptyNumber
CampaignEndDate	Datetime	True		No	CampaignEndDate
CampaignId	Long	False		No	CampaignId
CampaignName	String	True		No	CampaignName
CampaignNumber	String	False		No	CampaignNumber
CampaignStartDate	Datetime	True		No	CampaignStartDate
CampaignStatus	String	True		No	CampaignStatus
CampaignType	String	True		No	CampaignType
CreatedBy	String	True		No	CreatedBy
CreationDate	Datetime	True		No	CreationDate
LastUpdateDate	Datetime	True		No	LastUpdateDate
LastUpdatedBy	String	True		No	LastUpdatedBy
OptyCampaignNumber	String	False		No	OptyCampaignNumber
OptyId	Long	False		No	OptyId
PrimaryFlag	Bool	False		No	PrimaryFlag
RevenuePercentage	Double	False		No	RevenuePercentage
OpportunityLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
RecordSet	String	False		Yes	Input specifying the resource type.
Finder	String	False		Yes	Input specifying the Finder type.
PartyIdAttribute	String	False		Yes	Input specifying the Party Id Attribute.
AttributeName	String	False		Yes	Input specifying the Attribute Name.
RollUpId	String	False		Yes	Input specifying the RollUp Id.
SourceObject	String	False		Yes	Input specifying the Source Object.
SourceObjectId	String	False		Yes	Input specifying the Source Object Id.
ClosePeriod	String	False		Yes	Input specifying the Close Period.
ContactPartyId	String	False		Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False		Yes	Input specifying the Effective BeginDate.
LeadNumber	String	False		Yes	Input specifying the Lead Number.
LookupCategory	String	False		Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False		Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False		Yes	Input specifying the Opty StatusCode.
Partner	String	False		Yes	Input specifying the Partner.
PartnerPartyId	String	False		Yes	Input specifying the Partner Party Id.
Product	String	False		Yes	Input specifying the Product.
ProductGroup	String	False		Yes	Input specifying the Product Group.
ReferenceName	String	False		Yes	Input specifying the Reference Name.
ResourcePartyId	String	False		Yes	Input specifying the Resource Party Id.
TeamMember	String	False		Yes	Input specifying the Team Member.

Return to Top

OpportunityCompetitors

Name	Type	ReadOnly	References	FilterOnly	Description
OptyCompetitorId [KEY]	Long	False		No	This is the primary key of the opportunity competitors table.
OptyNumber [KEY]	String	False	Opportunities.OptyNumber	No
CmptPartyId	Long	False		No	The unique identifier for the competitor party.
Comments	String	False		No	The user-provided comments about the opportunity's competitor.
CreatedBy	String	False		No	The user who created the record.
CreationDate	Datetime	False		No	The date and time when the contact record was created.
LastUpdateDate	Datetime	False		No	The date when the record was last updated.
LastUpdatedBy	String	False		No	The user who last updated the record.
LastUpdateLogin	String	False		No	The session login associated to the user who last updated the record.
Name	String	False		No	The name of the opportunity.
OptyId	Long	False		No	The unique identifier for the opportunity.
PartyName	String	False		No	The name of the party.
PrimaryFlg	String	False		No	Indicates if the competitor is the primary competitor for the opportunity. If True, then the competitor is the primary competitor. The default value is False.
ThreatLevelCode	String	False		No	The level of threat or risk from the competitor. The list of valid values are Low, Medium and High. A list of accepted values are defined in the lookup Competitor Threat Level. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
OpportunityLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
RecordSet	String	False		Yes	Input specifying the resource type.
Finder	String	False		Yes	Input specifying the Finder type.
PartyId	String	False		Yes	Input specifying the Party Id.
PartyIdAttribute	String	False		Yes	Input specifying the Party Id Attribute.
AttributeName	String	False		Yes	Input specifying the Attribute Name.
RollUpId	String	False		Yes	Input specifying the RollUp Id.
SourceObject	String	False		Yes	Input specifying the Source Object.
SourceObjectId	String	False		Yes	Input specifying the Source Object Id.
ClosePeriod	String	False		Yes	Input specifying the Close Period.
ContactPartyId	String	False		Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False		Yes	Input specifying the Effective BeginDate.
EffectiveEndDate	String	False		Yes	Input specifying the Effective EndDate.
LeadNumber	String	False		Yes	Input specifying the Lead Number.
LookupCategory	String	False		Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False		Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False		Yes	Input specifying the Opty StatusCode.
Partner	String	False		Yes	Input specifying the Partner.
PartnerPartyId	String	False		Yes	Input specifying the Partner Party Id.
Product	String	False		Yes	Input specifying the Product.
ProductGroup	String	False		Yes	Input specifying the Product Group.
ReferenceName	String	False		Yes	Input specifying the Reference Name.
ResourcePartyId	String	False		Yes	Input specifying the Resource Party Id.
TeamMember	String	False		Yes	Input specifying the Team Member.

Return to Top

OpportunityContacts

Name	Type	ReadOnly	References	FilterOnly	Description
OptyConId [KEY]	Long	False		No	This is the primary key of the opportunity contacts table.
OptyNumber [KEY]	String	False	Opportunities.OptyNumber	No
AffinityLvlCd	String	False		No	The affinity of the opportunity contact to the deploying organization. A list of accepted values are defined in the lookup HZ_SLS_CNTCT_AFFINITY_CODE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task.
Comments	String	False		No	The textual comments about the contact on the current opportunity.
ContactedFlg	String	False		No	Indicates if the contact for this opportunity has been contacted. If the value is True, then the contact was contacted. The default value is False.
ContactPointId	Long	False		No	The unique identifier of the contact's contact point.
CreatedBy	String	False		No	The user who created the opportunity contact record.
CreationDate	Datetime	False		No	The date and time when the contact record was created.
DoNotContactFlag	Boolean	False		No	Indicates if the user can contact the person or not by phone, e-mail, or mail. If the value is True, then the user must not contact the person. The default is False.
EmailAddress	String	False		No	The e-mail address of the contact.
FormattedAddress	String	False		No	The formatted address of the contact.
FormattedPhoneNumber	String	False		No	The formatted phone number of the contact.
InfluenceLvlCd	String	False		No	The influence of the opportunity contact has on the deploying organization. A list of accepted values are defined in the lookup HZ_SLS_CNTCT_INFLUENCE_LVL_CD. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task.
JobTitle	String	False		No	The free form text for job title of the opportunity contact.
LastUpdateDate	Datetime	False		No	The date when the record was last updated.
LastUpdatedBy	String	False		No	The user who last updated the record.
LastUpdateLogin	String	False		No	The session login associated to the user who last updated the record.
OptyId	Long	False		No	The unique identifier of the opportunity.
OrganizationPartyId	Long	False		No	The unique identifier of the contact's organization.
OrganizationPartyName	String	False		No	The name of the contact's organization.
OrgContactId	Long	False		No	The unique identifier of the organization contact for the opportunity.
PartyName	String	False		No	The name of the contact for the opportunity.
PartyUniqueName	String	False		No	The unique contact name displayed on party related screens. The default value for Contacts is the concatenation of attributes ContactName and UniqueNameSuffix. The default value for Organizations is the concatenation of the unique name alias and UniqueNameSuffix.
PERPartyId	Long	False		No	The unique identifier of a valid employee resource who owns and manages the opportunity.
PreferredContactMethod	String	False		No	The preferred method to contact the person. A list of accepted values is defined in the lookup HZ_PREFERRED_CONTACT_METHOD. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Contact Point Lookups task.
PrimaryFlg	String	False		No	Indicates if the contact is the primary contact for the opportunity. If the value is True, then the contact is the primary contact fo the opportunity. The default value is False.
RelationshipCode	String	False		No	The code for a forward or a backward relationship. A list of accepted relationship values is defined in the lookup PARTY_RELATIONS_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Relationship Lookups.
RelationshipId	Long	False		No	The identifier of the relationship for the opportunity contact.
RoleCd	String	False		No	The roles played by a contact in the opportunity. A list of accepted values is defined in the lookup HZ_SLS_CNTCT_BUY_ROLE_CODE. Review and update the values for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task.
SalesAffinityCode	String	False		No	The affinity of a contact to the deploying organization. A list of accepted values are defined in the lookup HZ_SLS_CNTCT_AFFINITY_CODE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task.
SalesBuyingRoleCode	String	False		No	The roles played by a contact in the buying process, for example, decision maker or supporting role. A list of accepted values is defined in the lookup HZ_SLS_CNTCT_BUY_ROLE_CODE. Review and update the values for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task.
SalesInfluenceLevelCode	String	False		No	The contact's level of influence in the buying process for the current opportunity.
OpportunityLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
RecordSet	String	False		Yes	Input specifying the resource type.
Finder	String	False		Yes	Input specifying the Finder type.
PartyId	String	False		Yes	Input specifying the Party Id.
PartyIdAttribute	String	False		Yes	Input specifying the Party Id Attribute.
AttributeName	String	False		Yes	Input specifying the Attribute Name.
RollUpId	String	False		Yes	Input specifying the RollUp Id.
SourceObject	String	False		Yes	Input specifying the Source Object.
SourceObjectId	String	False		Yes	Input specifying the Source Object Id.
ClosePeriod	String	False		Yes	Input specifying the Close Period.
ContactPartyId	String	False		Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False		Yes	Input specifying the Effective BeginDate.
EffectiveEndDate	String	False		Yes	Input specifying the Effective EndDate.
LeadNumber	String	False		Yes	Input specifying the Lead Number.
LookupCategory	String	False		Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False		Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False		Yes	Input specifying the Opty StatusCode.
Partner	String	False		Yes	Input specifying the Partner.
PartnerPartyId	String	False		Yes	Input specifying the Partner Party Id.
Product	String	False		Yes	Input specifying the Product.
ProductGroup	String	False		Yes	Input specifying the Product Group.
ReferenceName	String	False		Yes	Input specifying the Reference Name.
ResourcePartyId	String	False		Yes	Input specifying the Resource Party Id.
TeamMember	String	False		Yes	Input specifying the Team Member.
Name	String	False		Yes	Input specifying the Name.

Return to Top

OpportunityDeals

Name	Type	ReadOnly	References	FilterOnly	Description
OptyDealId [KEY]	Long	False		No	This is the primary key of the opportunity deals table.
OptyNumber [KEY]	String	False	Opportunities.OptyNumber	No
CreatedBy	String	False		No	The user who created the opportunity deal record.
CreationDate	Datetime	False		No	The date and time when the opportunity deal record was created.
DealId	Long	False		No	The unique identifier of the deal.
LastUpdateDate	Datetime	False		No	The date and time when the opportunity deal record was last updated.
LastUpdatedBy	String	False		No	The user who last updated the opportunity deal record.
LastUpdateLogin	String	False		No	The session login associated to the user who last updated the opportunity deal record.
OptyId	Long	False		No	The unique identifier of the opportunity.
PartyName	String	False		No	The name of the partner.
OpportunityLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
RecordSet	String	False		Yes	Input specifying the resource type.
Finder	String	False		Yes	Input specifying the Finder type.
PartyId	String	False		Yes	Input specifying the Party Id.
PartyIdAttribute	String	False		Yes	Input specifying the Party Id Attribute.
AttributeName	String	False		Yes	Input specifying the Attribute Name.
RollUpId	String	False		Yes	Input specifying the RollUp Id.
SourceObject	String	False		Yes	Input specifying the Source Object.
SourceObjectId	String	False		Yes	Input specifying the Source Object Id.
ClosePeriod	String	False		Yes	Input specifying the Close Period.
ContactPartyId	String	False		Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False		Yes	Input specifying the Effective BeginDate.
EffectiveEndDate	String	False		Yes	Input specifying the Effective EndDate.
LeadNumber	String	False		Yes	Input specifying the Lead Number.
LookupCategory	String	False		Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False		Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False		Yes	Input specifying the Opty StatusCode.
Partner	String	False		Yes	Input specifying the Partner.
PartnerPartyId	String	False		Yes	Input specifying the Partner Party Id.
Product	String	False		Yes	Input specifying the Product.
ProductGroup	String	False		Yes	Input specifying the Product Group.
ReferenceName	String	False		Yes	Input specifying the Reference Name.
ResourcePartyId	String	False		Yes	Input specifying the Resource Party Id.
TeamMember	String	False		Yes	Input specifying the Team Member.
Name	String	False		Yes	Input specifying the Name.

Return to Top

OpportunityLeads

Name	Type	ReadOnly	References	FilterOnly	Description
OptyLeadId [KEY]	Long	False		No	This is the primary key of the opportunity leads table.
OptyNumber [KEY]	String	False	Opportunities.OptyNumber	No
CreatedBy	String	False		No	The user who created the record.
CreationDate	Datetime	False		No	The date and time when the record was created.
DealEstimatedCloseDate	Date	False		No	The date when the deal registration for the opportunity is estimated to be closed.
DealExpirationDate	Date	False		No	The date when the lead registration will expire.
DealPartProgramId	Long	False		No	The unique identifier of the partner program associated with the lead registration.
DealType	String	False		No	The deal or lead registration type for the opportunity.
LastUpdateDate	Datetime	False		No	The date when the record was last updated.
LastUpdatedBy	String	False		No	The user who last updated the record.
LastUpdateLogin	String	False		No	The session login associated to the user who last updated the record.
LeadNumber	String	False		No	The unique identification number for the lead.
OptyId	Long	False		No	The unique identifier of the opportunity.
PartnerTypeCd	String	False		No	The type of the partner for the lead registration.
PrDealPartOrgPartyId	Long	False		No	The unique identifier for the partner on the lead registration.
PrDealPartResourcePartyId	Long	False		No	The unique identifier for the primary partner resource on the lead registration.
RegistrationNumber	String	False		No	The unique registration number of the lead for the opportunity.
UserLastUpdateDate	Datetime	False		No	The date and time when the opportunity lead was last updated from mobile.
OpportunityLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
LeadNumber	String	False		No	The alternate key identifier of the lead.
RecordSet	String	False		Yes	Input specifying the resource type.
Finder	String	False		Yes	Input specifying the Finder type.
PartyId	String	False		Yes	Input specifying the Party Id.
PartyIdAttribute	String	False		Yes	Input specifying the Party Id Attribute.
AttributeName	String	False		Yes	Input specifying the Attribute Name.
RollUpId	String	False		Yes	Input specifying the RollUp Id.
SourceObject	String	False		Yes	Input specifying the Source Object.
SourceObjectId	String	False		Yes	Input specifying the Source Object Id.
ClosePeriod	String	False		Yes	Input specifying the Close Period.
ContactPartyId	String	False		Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False		Yes	Input specifying the Effective BeginDate.
EffectiveEndDate	String	False		Yes	Input specifying the Effective EndDate.
LookupCategory	String	False		Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False		Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False		Yes	Input specifying the Opty StatusCode.
Partner	String	False		Yes	Input specifying the Partner.
PartnerPartyId	String	False		Yes	Input specifying the Partner Party Id.
Product	String	False		Yes	Input specifying the Product.
ProductGroup	String	False		Yes	Input specifying the Product Group.
ReferenceName	String	False		Yes	Input specifying the Reference Name.
ResourcePartyId	String	False		Yes	Input specifying the Resource Party Id.
TeamMember	String	False		Yes	Input specifying the Team Member.
Name	String	False		Yes	Input specifying the Name.

Return to Top

OpportunityNotes

Name	Type	ReadOnly	References	FilterOnly	Description
NoteId [KEY]	Long	False		No	This is the primary key of the notes table.
OptyNumber [KEY]	String	False	Opportunities.OptyNumber	No
ContactRelationshipId	Long	False		No	The identifier of the relationship populated when the note is associated with a contact.
CorpCurrencyCode	String	False		No	The corporate currency code of the note associated with the contact. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
CreatedBy	String	False		No	The user who created the note record.
CreationDate	Datetime	False		No	The date and time when the note record was created.
CreatorPartyId	Long	False		No	The unique party identifier for the note creator.
CurcyConvRateType	String	False		No	The currency conversion rate type associated with the note. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
CurrencyCode	String	False		No	The currency code associated with the note. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
LastUpdateDate	Datetime	False		No	The date when the note data was last updated.
NoteTxt	String	False		No	The actual note text.
NoteTypeCode	String	False		No	This code for categorization of the note type.
PartyId	Long	False		No	The unique Identifier of the party to which the note is associated.
PartyName	String	False		No	The name of party associated with the opportunity.
SourceObjectCode	String	False		No	The code of the source object Opportunities, as defined in OBJECTS Metadata.
SourceObjectId	String	False		No	The primary key identifier of the source object Opportunities, as defined in OBJECTS Metadata.
VisibilityCode	String	False		No	The visibility level of the note.
OpportunityLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
PartyId	Long	False		No	The unique Identifier of the party to which the note is associated.
SourceObjectId	String	False		No	The unique identifier of the source object as defined in OBJECTS Metadata, such as activities, opportunities, and so on.
RecordSet	String	False		Yes	Input specifying the resource type.
Finder	String	False		Yes	Input specifying the Finder type.
PartyIdAttribute	String	False		Yes	Input specifying the Party Id Attribute.
AttributeName	String	False		Yes	Input specifying the Attribute Name.
RollUpId	String	False		Yes	Input specifying the RollUp Id.
SourceObject	String	False		Yes	Input specifying the Source Object.
ClosePeriod	String	False		Yes	Input specifying the Close Period.
ContactPartyId	String	False		Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False		Yes	Input specifying the Effective BeginDate.
EffectiveEndDate	String	False		Yes	Input specifying the Effective EndDate.
LeadNumber	String	False		Yes	Input specifying the Lead Number.
LookupCategory	String	False		Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False		Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False		Yes	Input specifying the Opty StatusCode.
Partner	String	False		Yes	Input specifying the Partner.
PartnerPartyId	String	False		Yes	Input specifying the Partner Party Id.
Product	String	False		Yes	Input specifying the Product.
ProductGroup	String	False		Yes	Input specifying the Product Group.
ReferenceName	String	False		Yes	Input specifying the Reference Name.
ResourcePartyId	String	False		Yes	Input specifying the Resource Party Id.
TeamMember	String	False		Yes	Input specifying the Team Member.
Name	String	False		Yes	Input specifying the Name.
OptyId	String	False		Yes	Input specifying the Opty Id.

Return to Top

OpportunityPartners

Name	Type	ReadOnly	References	FilterOnly	Description
RevnPartOrgPartyId [KEY]	Long	False		No	This is the primary key of the opportunity partners table.
OptyNumber [KEY]	String	False	Opportunities.OptyNumber	No
CreatedBy	String	False		No	The user who created the record.
CreationDate	Datetime	False		No	The date and time when the contact record was created.
DealEstCloseDate	Datetime	False		No	The date when the deal registration is estimated to close.
DealExpirationDate	Datetime	False		No	The date when the deal registration will expire.
DealType	String	False		No	The type of deal registration.
LastUpdateDate	Datetime	False		No	The date when the record was last updated.
LastUpdatedBy	String	False		No	The user who last updated the record.
LastUpdateLogin	String	False		No	The session login associated to the user who last updated the record.
OptyId	Long	False		No	The unique identifier of the opportunity.
PartOrgEmailAddress	String	False		No	The email address of the primary partner organization for this revenue.
PartOrgFormattedPhoneNumber	String	False		No	The phone number of the primary partner organization for this revenue.
PartOrgPartyId	Long	False		No	The unique identifier of the partner organization associated with the revenue.
PartProgramId	Long	False		No	The unique identifier of the partner program associated with the revenue.
PartTypeCd	String	False		No	The type of the party associated with the summary or primary revenue of the opportunity.
PartyId	Long	False		No	The unique identifier of the partner party is associated with the opportunity.
PartyName	String	False		No	The name of the partner associated with the opportunity.
PartyName1	String	False		No	The name of the primary partner resource associated with the opportunity.
PreferredContactEmail	String	False		No	The e-mail address of the partner's primary contact.
PreferredContactName	String	False		No	The name of the partner's primary contact.
PreferredContactPhone	String	False		No	The phone number of the partner's primary contact.
PrPartResourcePartyId	Long	False		No	The unique identifier of the primary partner resource.
RegistrationNumber	String	False		No	The registration number of the deal registration.
RegistrationStatus	String	False		No	The registration status of the partner who create the opportunity or deal.
RevnId	Long	False		No	The unique identifier of the summary or primary revenue for the opportunity.
RevnPartnerNumber	String	False		No	The unique number of the associated between the opportunity partner and a revenue line.
OpportunityLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
RecordSet	String	False		Yes	Input specifying the resource type.
Finder	String	False		Yes	Input specifying the Finder type.
PartyIdAttribute	String	False		Yes	Input specifying the Party Id Attribute.
AttributeName	String	False		Yes	Input specifying the Attribute Name.
RollUpId	String	False		Yes	Input specifying the RollUp Id.
SourceObject	String	False		Yes	Input specifying the Source Object.
SourceObjectId	String	False		Yes	Input specifying the Source Object Id.
ClosePeriod	String	False		Yes	Input specifying the Close Period.
ContactPartyId	String	False		Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False		Yes	Input specifying the Effective BeginDate.
EffectiveEndDate	String	False		Yes	Input specifying the Effective EndDate.
LeadNumber	String	False		Yes	Input specifying the Lead Number.
LookupCategory	String	False		Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False		Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False		Yes	Input specifying the Opty StatusCode.
Partner	String	False		Yes	Input specifying the Partner.
PartnerPartyId	String	False		Yes	Input specifying the Partner Party Id.
Product	String	False		Yes	Input specifying the Product.
ProductGroup	String	False		Yes	Input specifying the Product Group.
ReferenceName	String	False		Yes	Input specifying the Reference Name.
ResourcePartyId	String	False		Yes	Input specifying the Resource Party Id.
TeamMember	String	False		Yes	Input specifying the Team Member.
Name	String	False		Yes	Input specifying the Name.

Return to Top

OpportunityRevenueItems

Name	Type	ReadOnly	References	FilterOnly	Description
RevnId [KEY]	Long	False		No	This is the primary key of the revenue items table.
OptyNumber [KEY]	String	False	Opportunities.OptyNumber	No
ActualCloseDate	Date	False		No	The date when the revenue line was closed.
BUOrgId	Long	False		No	The unique identifier of the Business Unit that owns the opportunity.
CloseReasonCode	String	False		No	The reason for winning or losing the revenue.
Comments	String	False		No	The user-provided comments for the revenue line.
CommitFlag	Boolean	False		No	Indicates if the revenue line should be used for forecasting. If the value is true, then the revenue line should be used for forecasting. The default value is False.
ConversionRate	Double	False		No	The currency conversion rate for converting the revenue amount to opportunity summary currency. The rate is used if the revenue line is different from that of the opportunity.
ConversionRateType	String	False		No	The currency conversion rate type for converting the revenue amount to opportunity summary currency. The rate type is used if the revenue line is different from that of the opportunity. For example, the rate type can be spot, user-defined, or corporate.
CostAmount	Decimal	False		No	The cost amount for the opportunity.
CreatedBy	String	False		No	The user who created the child revenue record.
CreationDate	Datetime	False		No	The date when the record was created.
CreditRcptPartOrgPartyId	Long	False		No	Credit Recipient Partner Organization Party.
CrmConversionRate	Double	False		No	The currency conversion rate for converting the revenue amount to CRM common currency for the Revenue Forecast Metrics. The rate is used if the revenue line is different from that of the opportunity.
CrmConversionRateType	String	False		No	The currency conversion rate type for converting the revenue amount to CRM common currency for Revenue Forecast Metrics. The rate type is used if the revenue line is different from that of the opportunity. For example, the rate type can be spot, user-defined, or corporate.
CrmCurcyCode	String	False		No	The common CRM currency code.
CustomerAccountId	Long	False		No	The unique identifier of the customer account that owns the opportunity.
Description	String	False		No	The user-provided description of the product associated with the revenue.
Discount	Decimal	False		No	The discount percent.
DownsideAmount	Decimal	False		No	The minimum amount of revenue for the opportunity.
EffectiveDate	Date	False		No	The date when the child revenue closes. The default value is the opportunity's close date.
ExpectAmount	Decimal	False		No	The maximum amount of revenue for the opportunity.
ExpectDlvryDate	Date	False		No	The expected delivery date for the product in the opportunity. This used only for opportunities that include products.
ForecastOverrideCode	String	False		No	The code that indicates if the revenue forecast should be overridden. The valid values are ALWAYS, NEVER, and CRITERIA.
InventoryItemId	Long	False		No	The unique identifier of the product in the inventory.
InventoryOrgId	Long	False		No	The unique identifier of the organization in the inventory.
ItemNumber	String	False		No	The unique number of the product that is associated with the revenue.
ItemNumberInternal	String	False		No	The unique internal number of the product that is associated with the revenue.
LastUpdateDate	Datetime	False		No	The date when the record was last updated.
LastUpdatedBy	String	False		No	The user who last updated the record.
LastUpdateLogin	String	False		No	The login of the user who last updated the record.
MarginAmount	Decimal	False		No	The margin amount for the opportunity.
Name1	String	False		No	The name of the territory.
NqSplitAllocTypeCode	String	False		No	The code indicating the non-quota allocation split type. The valid values are Adhoc amount and Proportional to Revenue.
OptyId	Long	False		No	The unique identified of the opportunity.
OptyLeadId	Long	False		No	Identifier for lead associated with opportunity.
OrganizationId	Long	False		No	The unique identifier of the organization to which the product belongs.
OwnerDealExpirationDate	Date	False		No	The date when the owner deal expires.
OwnerDealProtectedDate	Date	False		No	The date when the owner deal starts.
OwnerLockAsgnFlag	Boolean	False		No	Indicates if the revenue owner assignment should be locked. If the value is Y, then the owner assignment for the child revenue should be locked.
ParentRevnId	Long	False		No	The Parent revenue line id. Used for Lineset functionality.
PartEngagementTypeCd	String	False		No	Partner Engagement Type.
PartOrgPartyId	Long	False		No	The unique identifier of the primary revenue partner party.
PartOrgPartyName	String	False		No	The name of the primary partner associated with the child revenue.
PrCmptPartyId	Long	False		No	The unique identifier of the primary competitor of this child revenue.
PrimaryFlag	Boolean	False		No	Indicates if the revenue is the primary revenue. If the value is true, then the revenue is the primary revenue among all the child revenues. The default value is False.
ProdGroupId	Long	False		No	The unique identifier of the product group.
ProdGroupName	String	False		No	The name of the product group associated with the revenue.
ProductType	String	False		No	The type of product on the revenue line, such as item or product group.
PrPartOrgPartyId	Long	False		No	Primary Revenue Partner Organization Party.
PrTerritoryVersionId	Long	False		No	The unique identifier of the primary territory for this revenue item.
Quantity	Double	False		No	The quantity of product for this opportunity.
RecurDownsideAmount	Decimal	False		No	The minimum revenue amount from the recurrence.
RecurEndDate	Date	False		No	The date when the child revenue recurrence ends.
RecurFrequencyCode	String	False		No	The code that indicates the frequency of recurrence for the child revenue.
RecurNumberPeriods	Long	False		No	The number of time the child revenue should recur.
RecurParentRevnId	Long	False		No	The unique identifier for the parent revenue of the recurring revenue lines.
RecurPeriodOrEndDateCode	String	False		No	Indicates if a date or the number of recurrences are specified to end the recurrences.
RecurQuantity	Double	False		No	The quantity of the child revenue recurrence.
RecurRevnAmount	Decimal	False		No	The amount of revenue from the child revenue recurrence.
RecurStartDate	Date	False		No	The date when the recurrence starts.
RecurTypeCode	String	False		No	Indicates if the line is a standard revenue line or recurring revenue line.
RecurUnitPrice	Decimal	False		No	The price of each child revenue recurrence.
RecurUpsideAmount	Decimal	False		No	The maximum revenue amount from the recurrence.
ResourcePartyId	Long	False		No	The unique identifier of the revenue owner.
RevnAmount	Decimal	False		No	The amount of revenue that is earned from this opportunity.
RevnAmountCurcyCode	String	False		No	The currency code used to calculate the revenue for this opportunity.
RevnCategoryCode	String	False		No	The revenue category used in Revenue Line Set functionality.
RevnLineTypeCode	String	False		No	This denotes the type of revenue line like Opportunity Summary Revenue, Standard Revenue and so on.
RevnNumber	String	False		No	The user-editable unique identifier for the child revenue. The default value is the revenue identifier.
RevnSequenceNumber	Long	False		No	The Revenue Sequence Number
SalesAccountId	Long	False		No	Identifier of the opportunity sales account.
SalesChannelCd	String	False		No	Sales Channel Code.
SalesCreditTypeCode	String	False		No	The type of the sales credit, such as quota or non-quota.
SplitParentRevnId	Long	False		No	The unique identifier of the split parent revenue.
SplitPercent	Double	False		No	The percentage of split revenue.
SplitTypeCode	String	False		No	The code that indicates if the split is revenue or non-revenue.
StatusCode	String	False		No	The unique code of the status for the child revenue.
TargetPartyId	Long	False		No	The unique identifier of the sales account that owns the opportunity.
TypeCode	String	False		No	The revenue type for the revenue earned from this opportunity.
UnitPrice	Decimal	False		No	The estimated unit price for the product.
UOMCode	String	False		No	The unit of measure code for the product.
UpsideAmount	Decimal	False		No	The maximum amount of revenue for the opportunity.
WinProb	Long	False		No	The estimated probability of winning the opportunity.
OpportunityLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
EffectiveEndDate	Datetime	False		No	The end date for the territory owner.
ResourcePartyId	String	False		No	The unique identifier of the revenue owner.
RecordSet	String	False		Yes	Input specifying the resource type.
Finder	String	False		Yes	Input specifying the Finder type.
PartyId	String	False		Yes	Input specifying the Party Id.
PartyIdAttribute	String	False		Yes	Input specifying the Party Id Attribute.
AttributeName	String	False		Yes	Input specifying the Attribute Name.
RollUpId	String	False		Yes	Input specifying the RollUp Id.
SourceObject	String	False		Yes	Input specifying the Source Object.
SourceObjectId	String	False		Yes	Input specifying the Source Object Id.
ClosePeriod	String	False		Yes	Input specifying the Close Period.
ContactPartyId	String	False		Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False		Yes	Input specifying the Effective BeginDate.
LeadNumber	String	False		Yes	Input specifying the Lead Number.
LookupCategory	String	False		Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False		Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False		Yes	Input specifying the Opty StatusCode.
Partner	String	False		Yes	Input specifying the Partner.
PartnerPartyId	String	False		Yes	Input specifying the Partner Party Id.
Product	String	False		Yes	Input specifying the Product.
ProductGroup	String	False		Yes	Input specifying the Product Group.
ReferenceName	String	False		Yes	Input specifying the Reference Name.
TeamMember	String	False		Yes	Input specifying the Team Member.
Name	String	False		Yes	Input specifying the Name.

Return to Top

OpportunityRevenueItemsChildSplitRevenue

Name	Type	ReadOnly	References	FilterOnly	Description
RevnId [KEY]	String	False		No	RevnId
ChildRevenueRevnId [KEY]	String	False	OpportunityRevenueItems.RevnId	No	RevnId of ChildRevenue
OptyNumber [KEY]	String	False	Opportunities.OptyNumber	No	OptyNumber
CreatedBy	String	False		No	Who column: indicates the user who created the row.
CreationDate	Datetime	False		No	Who column: indicates the date and time of the creation of the row.
ExtnPartyName	String	False		No	ExtnPartyName
ExtnPartyNameLOVSwitcher	String	False		No	ExtnPartyNameLOVSwitcher
ForecastTerritoryName	String	False		No	ForecastTerritoryName
LastUpdateDate	Datetime	False		No	Who column: indicates the date and time of the last update of the row.
LastUpdateLogin	String	False		No	Who column: indicates the session login associated to the user who last updated the row.
LastUpdatedBy	String	False		No	Who column: indicates the user who last updated the row.
Name	String	False		No	Name of the resource organization of the credit recipient.
OwnerLockAsgnFlag	Bool	False		No	Indicates if the credit recipients of the revenue line should be locked from re-assignment by the system.
OwnerPartyNumber	String	False		No	OwnerPartyNumber
PrTerritoryUpdatedByPartyName	String	False		No	Name of the user who last updated the forecast territory.
PrTerritoryVersionId	Long	False		No	Forecast territory version identifier.
PrTerritoryVersionIdForManual	String	False		No	Indicates the version ID of a territory that is to be manually assigned to the revenue record.
ResourcePartyId	Long	False		No	Resource identifier of the credit recipient.
RevnAmount	Decimal	False		No	Revenue amount.
RevnAmountCurcyCode	String	False		No	The currency the amount on this revenue line is based on.
RevnNumber	String	False		No	Unique number for the revenue line. Initially defaulted from the revenue identifier.
SalesCreditTypeCode	String	False		No	Indicates the type of sales credit - revenue or nonrevenue.
SplitPercent	Double	False		No	Split percent.
TerrOwnerPartyName	String	False		No	TerrOwnerPartyName
OpportunityLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
RecordSet	String	False		Yes	Input specifying the resource type.
Finder	String	False		Yes	Input specifying the Finder type.
PartyId	String	False		Yes	Input specifying the Party Id.
PartyIdAttribute	String	False		Yes	Input specifying the Party Id Attribute.
AttributeName	String	False		Yes	Input specifying the Attribute Name.
RollUpId	String	False		Yes	Input specifying the RollUp Id.
SourceObject	String	False		Yes	Input specifying the Source Object.
SourceObjectId	String	False		Yes	Input specifying the Source Object Id.
ClosePeriod	String	False		Yes	Input specifying the Close Period.
ContactPartyId	String	False		Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False		Yes	Input specifying the Effective BeginDate.
EffectiveEndDate	String	False		Yes	Input specifying the Effective EndDate.
LeadNumber	String	False		Yes	Input specifying the Lead Number.
LookupCategory	String	False		Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False		Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False		Yes	Input specifying the Opty StatusCode.
Partner	String	False		Yes	Input specifying the Partner.
PartnerPartyId	String	False		Yes	Input specifying the Partner Party Id.
Product	String	False		Yes	Input specifying the Product.
ProductGroup	String	False		Yes	Input specifying the Product Group.
ReferenceName	String	False		Yes	Input specifying the Reference Name.
TeamMember	String	False		Yes	Input specifying the Team Member.
OptyId	String	False		Yes	Input specifying the Opty Id.

Return to Top

OpportunityRevenueItemsRecurringRevenues

Name	Type	ReadOnly	References	FilterOnly	Description
RevnId [KEY]	String	True		No	RevnId
ChildRevenueRevnId [KEY]	String	False	OpportunityRevenueItems.RevnId	No	RevnId of ChildRevenue.
OptyNumber [KEY]	String	False	Opportunities.OptyNumber	No	OptyNumber
CreatedBy	String	True		No	Who column: indicates the user who created the row.
CreationDate	Datetime	True		No	Who column: indicates the date and time of the creation of the row.
EffectiveDate	Date	False		No	Estimated close date for this revenue - defaulted from opportunity's close date
LastUpdateDate	Datetime	True		No	Who column: indicates the date and time of the last update of the row.
LastUpdateLogin	String	True		No	Who column: indicates the session login associated to the user who last updated the row.
LastUpdatedBy	String	True		No	Who column: indicates the user who last updated the row.
NonRecurringRevenue	Decimal	False		No	Non-Recurring Revenue Amount (Net)
Quantity	Double	False		No	Product quantity.
RecurParentRevnId	Long	False		No	Indicates the parent revenue id for the recurrence
RecurRevenue	Decimal	False		No	The recurring revenue amount on the revenue line
RevnAmount	Decimal	False		No	Revenue amount.
RevnAmtCurcyCode	String	True		No	RevnAmtCurcyCode
RevnNumber	String	False		No	User editable revenue number. Defaulted from REVN_ID. Needs to be unique, cannot be NULL.
UsageRevenue	Decimal	False		No	The usage revenue amount on the revenue line
OpportunityLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
RecordSet	String	False		Yes	Input specifying the resource type.
Finder	String	False		Yes	Input specifying the Finder type.
PartyId	String	False		Yes	Input specifying the Party Id.
PartyIdAttribute	String	False		Yes	Input specifying the Party Id Attribute.
AttributeName	String	False		Yes	Input specifying the Attribute Name.
RollUpId	String	False		Yes	Input specifying the RollUp Id.
SourceObject	String	False		Yes	Input specifying the Source Object.
SourceObjectId	String	False		Yes	Input specifying the Source Object Id.
ClosePeriod	String	False		Yes	Input specifying the Close Period.
ContactPartyId	String	False		Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False		Yes	Input specifying the Effective BeginDate.
EffectiveEndDate	String	False		Yes	Input specifying the Effective EndDate.
LeadNumber	String	False		Yes	Input specifying the Lead Number.
LookupCategory	String	False		Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False		Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False		Yes	Input specifying the Opty StatusCode.
Partner	String	False		Yes	Input specifying the Partner.
PartnerPartyId	String	False		Yes	Input specifying the Partner Party Id.
Product	String	False		Yes	Input specifying the Product.
ProductGroup	String	False		Yes	Input specifying the Product Group.
ReferenceName	String	False		Yes	Input specifying the Reference Name.
TeamMember	String	False		Yes	Input specifying the Team Member.
OptyId	String	False		Yes	Input specifying the Opty Id.
ResourcePartyId	String	False		Yes	Input specifying the ResourcePartyId.

Return to Top

OpportunityRevenueProductGroups

Name	Type	ReadOnly	FilterOnly	Description
ProdGroupId [KEY]	Integer	False	No	This is the primary key of the revenue territories table.
RevnId [KEY]	Long	False	No
OptyNumber [KEY]	String	False	No
Description	String	False	No	The user-provided description of the product group.
DisplayName	String	False	No	The name of the product group.
LastUpdateDate	String	False	No	The date the product group was last updated.
OpportunityLastUpdateDate	Datetime	False	No	The date and time when the opportunity was last updated.
RecordSet	String	False	Yes	Input specifying the resource type.
Finder	String	False	Yes	Input specifying the Finder type.
PartyId	String	False	Yes	Input specifying the Party Id.
PartyIdAttribute	String	False	Yes	Input specifying the Party Id Attribute.
AttributeName	String	False	Yes	Input specifying the Attribute Name.
RollUpId	String	False	Yes	Input specifying the RollUp Id.
SourceObject	String	False	Yes	Input specifying the Source Object.
SourceObjectId	String	False	Yes	Input specifying the Source Object Id.
ClosePeriod	String	False	Yes	Input specifying the Close Period.
ContactPartyId	String	False	Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False	Yes	Input specifying the Effective BeginDate.
EffectiveEndDate	String	False	Yes	Input specifying the Effective EndDate.
LeadNumber	String	False	Yes	Input specifying the Lead Number.
LookupCategory	String	False	Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False	Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False	Yes	Input specifying the Opty StatusCode.
Partner	String	False	Yes	Input specifying the Partner.
PartnerPartyId	String	False	Yes	Input specifying the Partner Party Id.
Product	String	False	Yes	Input specifying the Product.
ProductGroup	String	False	Yes	Input specifying the Product Group.
ReferenceName	String	False	Yes	Input specifying the Reference Name.
ResourcePartyId	String	False	Yes	Input specifying the Resource Party Id.
TeamMember	String	False	Yes	Input specifying the Team Member.
Name	String	False	Yes	Input specifying the Name.
OptyId	String	False	Yes	Input specifying the Opty Id.

Return to Top

OpportunityRevenueProducts

Name	Type	ReadOnly	FilterOnly	Description
ProductNum [KEY]	String	False	No	The number of the product.
RevnId [KEY]	String	False	No
OptyNumber [KEY]	String	False	No
ActiveFlag	Boolean	False	No	Indicates if the product is Active.
Description	String	False	No	The description of the product associated with the opportunity.
EndDate	Datetime	False	No	The effective end date of the product.
InventoryItemId	Long	False	No	The unique identifier of the product inventory item associated with the opportunity.
InvOrgId	Long	False	No	The unique identifier of the inventory organization.
LastUpdateDate	Datetime	False	No	The date the product was last updated.
LongDescription	String	False	No	Text to describe the product.
ProdGroupId	Long	False	No	The unique identifier of the Product Group.
ProductType	String	False	No	The type of the product.
StartDate	Datetime	False	No	The effective start date of the product.
Text	String	False	No	The text or keywords associated with the product.
OpportunityLastUpdateDate	Datetime	False	No	The date and time when the opportunity was last updated.
RecordSet	String	False	Yes	Input specifying the resource type.
Finder	String	False	Yes	Input specifying the Finder type.
PartyId	String	False	Yes	Input specifying the Party Id.
PartyIdAttribute	String	False	Yes	Input specifying the Party Id Attribute.
AttributeName	String	False	Yes	Input specifying the Attribute Name.
RollUpId	String	False	Yes	Input specifying the RollUp Id.
SourceObject	String	False	Yes	Input specifying the Source Object.
SourceObjectId	String	False	Yes	Input specifying the Source Object Id.
ClosePeriod	String	False	Yes	Input specifying the Close Period.
ContactPartyId	String	False	Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False	Yes	Input specifying the Effective BeginDate.
EffectiveEndDate	String	False	Yes	Input specifying the Effective EndDate.
LeadNumber	String	False	Yes	Input specifying the Lead Number.
LookupCategory	String	False	Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False	Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False	Yes	Input specifying the Opty StatusCode.
Partner	String	False	Yes	Input specifying the Partner.
PartnerPartyId	String	False	Yes	Input specifying the Partner Party Id.
Product	String	False	Yes	Input specifying the Product.
ProductGroup	String	False	Yes	Input specifying the Product Group.
ReferenceName	String	False	Yes	Input specifying the Reference Name.
ResourcePartyId	String	False	Yes	Input specifying the Resource Party Id.
TeamMember	String	False	Yes	Input specifying the Team Member.
Name	String	False	Yes	Input specifying the Name.
OptyId	String	False	Yes	Input specifying the Opty Id.

Return to Top

OpportunityRevenueTerritories

Name	Type	ReadOnly	FilterOnly	Description
RevnTerrId [KEY]	Long	False	No	This is the primary key of the revenue territories table.
RevnId [KEY]	Long	False	No
OptyNumber [KEY]	String	False	No
AssignmentType	String	False	No	The type of assignment used to assign the territory to the opportunity.
CreatedBy	String	False	No	The user who created the revenue territory record.
CreationDate	Datetime	False	No	The date when the record was created.
EffectiveEndDate	Date	False	No	The date when the resource organization assignment to the territory ends.
EffectiveStartDate	Date	False	No	The date when the resource organization for the territory was assigned to the revenue line.
ForecastParticipationCode	String	False	No	The code to identify the forecast type that the territory participates in. For example, Revenue, Nonrevenue, Revenue and Nonrevenue, or Nonforecasting.
LastUpdateDate	Datetime	False	No	The date when the record was last updated.
LastUpdatedBy	String	False	No	The user who last updated the record.
LastUpdateLogin	String	False	No	The login of the user who last updated the record.
Name	String	False	No	The name of the territory that the opportunity belongs to.
Name1	String	False	No	The name of the organization that the territory resource belongs to.
PartyId	Long	False	No	The unique identifier of the resource who owns the territory.
PartyName	String	False	No	The name of the territory owner for the opportunity.
RoleId	Long	False	No	The unique identifier of the resource's role.
RoleName	String	False	No	The name of the resource's role.
TerritoryId	Long	False	No	Territory identifier.
TerritoryVersionId	Long	False	No	Territory version identifier.
TypeCode	String	False	No	The type of territory assigned to the opportunity.
OpportunityLastUpdateDate	Datetime	False	No	The date and time when the opportunity was last updated.
PartyId	Long	False	No	The unique identifier of the resource who owns the territory.
EffectiveEndDate	Datetime	False	No	The date when the resource organization assignment to the territory ends.
RecordSet	String	False	Yes	Input specifying the resource type.
Finder	String	False	Yes	Input specifying the Finder type.
PartyIdAttribute	String	False	Yes	Input specifying the Party Id Attribute.
AttributeName	String	False	Yes	Input specifying the Attribute Name.
RollUpId	String	False	Yes	Input specifying the RollUp Id.
SourceObject	String	False	Yes	Input specifying the Source Object.
SourceObjectId	String	False	Yes	Input specifying the Source Object Id.
ClosePeriod	String	False	Yes	Input specifying the Close Period.
ContactPartyId	String	False	Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False	Yes	Input specifying the Effective BeginDate.
LeadNumber	String	False	Yes	Input specifying the Lead Number.
LookupCategory	String	False	Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False	Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False	Yes	Input specifying the Opty StatusCode.
Partner	String	False	Yes	Input specifying the Partner.
PartnerPartyId	String	False	Yes	Input specifying the Partner Party Id.
Product	String	False	Yes	Input specifying the Product.
ProductGroup	String	False	Yes	Input specifying the Product Group.
ReferenceName	String	False	Yes	Input specifying the Reference Name.
ResourcePartyId	String	False	Yes	Input specifying the Resource Party Id.
TeamMember	String	False	Yes	Input specifying the Team Member.
OptyId	String	False	Yes	Input specifying the Opty Id.

Return to Top

OpportunitySources

Name	Type	ReadOnly	FilterOnly	Description
OptySrcId [KEY]	Long	False	No	This is the primary key of the opportunity sources table.
OptyNumber	String	False	No
CreatedBy	String	False	No	The user who created the record.
CreationDate	Datetime	False	No	The date and time when the record was created.
LastUpdateDate	Datetime	False	No	The date when the record was last updated.
LastUpdatedBy	String	False	No	The user who last updated the record.
LastUpdateLogin	String	False	No	The session login associated to the user who last updated the record.
OptyId	Long	False	No	The unique Identifier of the opportunity.
SrcNumber	String	False	No	A unique number indicating the source of the marketing event for the opportunity, such as campaign, new product line, a marketing seminar, and so on.
UserLastUpdateDate	Datetime	False	No	The date and time when the opportunity was last updated from mobile.
OpportunityLastUpdateDate	Datetime	False	No	The date and time when the opportunity was last updated.
RecordSet	String	False	Yes	Input specifying the resource type.
Finder	String	False	Yes	Input specifying the Finder type.
PartyId	String	False	Yes	Input specifying the Party Id.
PartyIdAttribute	String	False	Yes	Input specifying the Party Id Attribute.
AttributeName	String	False	Yes	Input specifying the Attribute Name.
RollUpId	String	False	Yes	Input specifying the RollUp Id.
SourceObject	String	False	Yes	Input specifying the Source Object.
SourceObjectId	String	False	Yes	Input specifying the Source Object Id.
ClosePeriod	String	False	Yes	Input specifying the Close Period.
ContactPartyId	String	False	Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False	Yes	Input specifying the Effective BeginDate.
EffectiveEndDate	String	False	Yes	Input specifying the Effective EndDate.
LeadNumber	String	False	Yes	Input specifying the Lead Number.
LookupCategory	String	False	Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False	Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False	Yes	Input specifying the Opty StatusCode.
Partner	String	False	Yes	Input specifying the Partner.
PartnerPartyId	String	False	Yes	Input specifying the Partner Party Id.
Product	String	False	Yes	Input specifying the Product.
ProductGroup	String	False	Yes	Input specifying the Product Group.
ReferenceName	String	False	Yes	Input specifying the Reference Name.
ResourcePartyId	String	False	Yes	Input specifying the Resource Party Id.
TeamMember	String	False	Yes	Input specifying the Team Member.
Name	String	False	Yes	Input specifying the Name.

Return to Top

OpportunityTeamMembers

Name	Type	ReadOnly	References	FilterOnly	Description
OptyResourceId [KEY]	Long	False		No	This is the primary key of the opportunity team members table.
OptyNumber [KEY]	String	False	Opportunities.OptyNumber	No
AccessLevelCode	String	False		No	The type of access granted to the resource as well as managers of the organizations. A list of accepted values are defined in the lookup ZCA_ACCESS_LEVEL. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
AsgnTerritoryVersionId	Long	False		No	The unique identifier of the territory version for the resource that got assigned to the opportunity through territory-based assignment.
AssignmentType	String	False		No	The code indicating how the resource is assigned to the sales account team. A list of accepted values are defined in the lookup ZCA_ASSIGNMENT_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
CreatedBy	String	False		No	The user who created the opportunity resource record.
CreationDate	Datetime	False		No	The date and time when the resource record was created.
DealExpirationDate	Date	False		No	The date on which the deal protection period of an opportunity team member ends. The date is updated for territory members when they are unassigned from a opportunity because of a territory realingment.
DealProtected	String	False		No	Indicates if the resource is under deal protection. If the value is True, then the resource is under deal protection. The default value is False.
DealProtectedDate	Date	False		No	The date on which the deal protection period of an opportunity team member starts. The date is updated for territory members when they are unassigned from a opportunity because of a territory realingment.
EmailAddress	String	False		No	The e-mail address of the opportunity team member.
FormattedPhoneNumber	String	False		No	The formatted phone number of the opportunity team member.
LastUpdateDate	Datetime	False		No	The date when the record was last updated.
LastUpdatedBy	String	False		No	The user who last updated the record.
LastUpdateLogin	String	False		No	The session login associated to the user who last updated the record.
LockAssignmentFlag	Boolean	False		No	Indicates if the automatic territory assignment can be set. If the value is True, then the automatic territory assignment cannot remove the sales account team resource. When a sales account team member is added manually, this flag is defaulted to `Y'.
MemberFunctionCode	String	False		No	The code indicating the role of a sales team member in the resource team such as Integrator, Executive Sponsor, and Technical Account Manager. A list of accepted values is defined in the lookup FND_LOOKUPS. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
MgrResourceId	Long	False		No	The unique identifier of the resource team member's manager.
OptyId	Long	False		No	The unique Identifier of the opportunity.
OptyResourceNumber	String	False		No	The label that represents the association between the opportunity and resource.
OwnerFlag	Boolean	False		No	Indicates if the opportunity team member is the owner of the opportunity. If the value is True, then the opportunity team member is also the owner fo the opportunity. The default value is False.
PartnerOrgId	Long	False		No	The unique identifier of the partner organization.
PartnerPartyName	String	False		No	The name of the partner associated with the partner resource.
PartyName	String	False		No	The name of the opportunity team member.
PersonFirstName	String	False		No	The first name of the opportunity team member.
PersonLastName	String	False		No	The last name of the opportunity team member.
ResourceId	Long	False		No	The unique party identifier for the existing resource record in Oracle Sales.
RoleName	String	False		No	The role of the opportunity team member in the resource organization.
TerritoryName	String	False		No	The name of the opportunity team member's territory.
OpportunityLastUpdateDate	Datetime	False		No	The date and time when the opportunity was last updated.
RecordSet	String	False		Yes	Input specifying the resource type.
Finder	String	False		Yes	Input specifying the Finder type.
PartyId	String	False		Yes	Input specifying the Party Id.
PartyIdAttribute	String	False		Yes	Input specifying the Party Id Attribute.
AttributeName	String	False		Yes	Input specifying the Attribute Name.
RollUpId	String	False		Yes	Input specifying the RollUp Id.
SourceObject	String	False		Yes	Input specifying the Source Object.
SourceObjectId	String	False		Yes	Input specifying the Source Object Id.
ClosePeriod	String	False		Yes	Input specifying the Close Period.
ContactPartyId	String	False		Yes	Input specifying the Contact Party Id.
EffectiveBeginDate	String	False		Yes	Input specifying the Effective BeginDate.
EffectiveEndDate	String	False		Yes	Input specifying the Effective EndDate.
LeadNumber	String	False		Yes	Input specifying the Lead Number.
LookupCategory	String	False		Yes	Input specifying the Lookup Category.
OpportunityContactName	String	False		Yes	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	False		Yes	Input specifying the Opty StatusCode.
Partner	String	False		Yes	Input specifying the Partner.
PartnerPartyId	String	False		Yes	Input specifying the Partner Party Id.
Product	String	False		Yes	Input specifying the Product.
ProductGroup	String	False		Yes	Input specifying the Product Group.
ReferenceName	String	False		Yes	Input specifying the Reference Name.
ResourcePartyId	String	False		Yes	Input specifying the Resource Party Id.
TeamMember	String	False		Yes	Input specifying the Team Member.
Name	String	False		Yes	Input specifying the Name.

Return to Top

PartnerContacts

Name	Type	ReadOnly	FilterOnly	Description
PartyId [KEY]	Long	False	No
AcademicTitle	String	False	No
AddrElementAttribute1	String	False	No
AddrElementAttribute2	String	False	No
AddrElementAttribute3	String	False	No
AddrElementAttribute4	String	False	No
AddrElementAttribute5	String	False	No
AddressLineFour	String	False	No
AddressLineOne	String	False	No
AddressLineThree	String	False	No
AddressLineTwo	String	False	No
Building	String	False	No
CertificationLevel	String	False	No
CertificationReasonCode	String	False	No
City	String	False	No
Comments	String	False	No
ContactName	String	False	No
Country	String	False	No
County	String	False	No
CreateUserAccountFlag	Bool	False	No
CreatedBy	String	False	No
CreationDate	Datetime	False	No
DateOfBirth	Date	False	No
DateOfDeath	Date	False	No
DeceasedFlag	Bool	False	No
DeclaredEthnicity	String	False	No
Department	String	False	No
DepartmentCode	String	False	No
DoNotCallFlag	Bool	False	No
DoNotContactFlag	Bool	False	No
DoNotEmailFlag	Bool	False	No
DoNotMailFlag	Bool	False	No
EmailAddress	String	False	No
FavoriteContactFlag	Bool	False	No
FirstName	String	False	No
FloorNumber	String	False	No
FormattedAddress	String	False	No
FormattedMobileNumber	String	False	No
FormattedWorkPhoneNumber	String	False	No
Gender	String	False	No
Initials	String	False	No
JobTitle	String	False	No
JobTitleCode	String	False	No
LastName	String	False	No
LastNamePrefix	String	False	No
LastUpdateDate	Datetime	False	No
LastUpdateLogin	String	False	No
LastUpdatedBy	String	False	No
Latitude	Double	False	No
Longitude	Double	False	No
Mailstop	String	False	No
ManagerName	String	False	No
ManagerPartyId	Long	False	No
ManagerPartyNumber	String	False	No
MaritalStatus	String	False	No
MaritalStatusEffectiveDate	Date	False	No
MiddleName	String	False	No
MobileAreaCode	String	False	No
MobileCountryCode	String	False	No
MobileExtension	String	False	No
MobileNumber	String	False	No
NameSuffix	String	False	No
NamedFlag	Bool	False	No
PartnerCompanyNumber	String	False	No
PartnerName	String	False	No
PartnerPartyId	Long	False	No
PartyNumber	String	False	No
PersonPreNameAdjunct	String	False	No
PlaceOfBirth	String	False	No
PostalCode	String	False	No
PostalPlus4Code	String	False	No
PreferredContactMethod	String	False	No
PreferredFunctionalCurrency	String	False	No
PreviousLastName	String	False	No
PrimaryAddressId	Long	False	No
PrimaryContactPartyId	Long	False	No
PrimaryFlag	Bool	False	No
Province	String	False	No
RentOrOwnIndicator	String	False	No
RoleCode	String	False	No
RoleId	Long	False	No
RoleName	String	False	No
SalesAffinityCode	String	False	No
SalesBuyingRoleCode	String	False	No
Salutation	String	False	No
SecondLastName	String	False	No
SourceSystem	String	False	No
SourceSystemReferenceValue	String	False	No
State	String	False	No
Title	String	False	No
Type	String	False	No
Username	String	False	No
WorkPhoneAreaCode	String	False	No
WorkPhoneCountryCode	String	False	No
WorkPhoneExtension	String	False	No
WorkPhoneNumber	String	False	No
isSelfRegistration	String	False	No
Finder	String	False	Yes	Input specifying the Finder type.
BindSourceSystem	String	False	Yes	The name of the external source system of the partner contact.
BindSourceSystemReferenceValue	String	False	Yes	The identifier of the partner contact record from the external source system.

Return to Top

PartnerProgramBenefits

Name	Type	ReadOnly	FilterOnly	Description
ProgramBenefitId [KEY]	Long	False	No
CategoryCode	String	False	No
CreatedBy	String	False	No
CreationDate	Datetime	False	No
DataType	String	False	No
DeleteFlag	Bool	False	No
Description	String	False	No
LastUpdateDate	Datetime	False	No
LastUpdateLogin	String	False	No
LastUpdatedBy	String	False	No
LastUpdatedByName	String	False	No
Name	String	False	No
UpdateFlag	Bool	False	No
Finder	String	False	Yes	Input specifying the Finder type.

Return to Top

PartnerPrograms

Name	Type	ReadOnly	FilterOnly	Description
PartnerProgramId [KEY]	Long	False	No	Primary Key: Partner Program Id
CountryNames	String	False	No
CreatedBy	String	False	No	Who column: indicates the user who created the row.
CreationDate	Datetime	False	No	Who column: indicates the date and time of the creation of the row.
DeleteFlag	Bool	False	No	An Attribute to identify if a record is deleteable.
EndDateActive	Date	False	No	Effective End Date of a program.
LastUpdateDate	Datetime	False	No	Who column: indicates the date and time of the last update of the row.
LastUpdateLogin	String	False	No
LastUpdatedBy	String	False	No	Who column: indicates the user who last updated the row.
OwnerPartyNumber	String	False	No	Public Unique Identifier of Owner Party on the Partner Programs.
ProgramDescription	String	False	No	Text describing the program.
ProgramManagerId	Long	False	No	Unique identifier of the manager for the partner program. This is to identify who is managing this partner program.
ProgramManagerName	String	False	No	Program Manager Name
ProgramName	String	False	No	Name of the partner program.
ProgramNumber	String	False	No	A unique number generated for each program.
ProgramType	String	False	No	Type of various partner program. Possible values are reseller, go to market.
StartDateActive	Date	False	No	Effective Start Date of a program.
StatusCode	String	False	No
UpdateFlag	Bool	False	No	Attribute to identify if a record is updateable.
Finder	String	False	Yes	Input specifying the Finder type.

Return to Top

Partners

Name	Type	ReadOnly	FilterOnly	Description
OrganizationProfileId [KEY]	Long	False	No
AccountDirectorId	Long	False	No
AddrElementAttribute1	String	False	No
AddrElementAttribute2	String	False	No
AddrElementAttribute3	String	False	No
AddrElementAttribute4	String	False	No
AddrElementAttribute5	String	False	No
AddressLineFour	String	False	No
AddressLineOne	String	False	No
AddressLineThree	String	False	No
AddressLineTwo	String	False	No
AnnualRevenue	Double	False	No
Building	String	False	No
BusinessScope	String	False	No
CeoName	String	False	No
City	String	False	No
CompanyNumber	String	False	No
ComplianceReviewedDate	Date	False	No
ComplianceStatus	String	False	No
ControlYr	Double	False	No
CorpCurrencyCode	String	False	No
Country	String	False	No
County	String	False	No
CreatedBy	String	False	No
CreationDate	Datetime	False	No
CurrencyCode	String	False	No
DUNSNumberC	String	False	No
DbRating	String	False	No
EligibleForPublicProfile	String	False	No
EmailAddress	String	False	No
EmailFormat	String	False	No
EmployeesTotal	Long	False	No
FaxNumber	String	False	No
FloorNumber	String	False	No
FormattedAddress	String	False	No
HomeCountry	String	False	No
IndstClassCategory	String	False	No
IndstClassCode	String	False	No
IndustryName	String	False	No
IsSelfRegisteredPartner	String	False	No
JgzzFiscalCode	String	False	No
LastUpdateDate	Datetime	False	No
LastUpdateLogin	String	False	No
LastUpdatedBy	String	False	No
Latitude	Double	False	No
LineOfBusiness	String	False	No
Longitude	Double	False	No
Mailstop	String	False	No
OpportunitiesWonPriorYear	Long	False	No
OpportunitiesWonYTD	Long	False	No
OrganizationName	String	False	No
OrganizationSize	String	False	No
OwnerName	String	False	No
OwnerPartyNumber	String	False	No
ParentPartnerId	String	False	No
ParentPartnerName	String	False	No
ParentPartnerOrigSystem	String	False	No
ParentPartnerOrigSystemReference	String	False	No
ParentPartnerPartyId	Long	False	No
ParentPartnerPartyNumber	String	False	No
PartnerLevel	String	False	No
PartnerSummary	String	False	No
PartyId	Long	False	No
PartyNumber	String	False	No
PhoneAreaCode	String	False	No
PhoneCountryCode	String	False	No
PhoneExtension	String	False	No
PhoneLineType	String	False	No
PhoneNumber	String	False	No
PostalCode	String	False	No
PostalPlus4Code	String	False	No
PreferredContactPersonId	Long	False	No
PrincipalName	String	False	No
Province	String	False	No
PublicStatus	String	False	No
RunDataSyncFlag	Bool	False	No
SSROwnerTableName	String	False	No
SolutionOverview	String	False	No
SourceSystem	String	False	No
SourceSystemReferenceValue	String	False	No
SourceType	String	False	No
State	String	False	No
Status	String	False	No
StockSymbol	String	False	No
Synergy	String	False	No
TierId	Long	False	No
TierName	String	False	No
URL	String	False	No
UpdateFlag	Bool	False	No
WebType	String	False	No
YearEstablished	Int	False	No
Finder	String	False	Yes	Input specifying the Finder type.
RecordSet	String	False	Yes	The value of the record set.
BindSourceSystem	String	False	Yes	The name of the external source system of the partner contact.
BindSourceSystemReferenceValue	String	False	Yes	The identifier of the partner contact record from the external source system.

Return to Top

ProgramEnrollments

Name	Type	ReadOnly	FilterOnly	Description
ProgramEnrollmentId [KEY]	Decimal	False	No	Unique identifier of a partner program enrollment.
ActiveEnrollment	String	False	No	Staus of enrollment. Possible values are active or inactive.
ApprovalDate	Date	False	No	Date on which enrollment is approved.
CreatedBy	String	False	No	Who column: indicates the user who created the row.
CreationDate	Datetime	False	No	Who column: indicates the date and time of the creation of the row.
EnrollmentNumber	String	False	No	A unique number generated for each program enrollment.
EnrollmentStatus	String	False	No	Status of the enrollment. Possible values are draft, pending, approved, rejected, terminated, renewed.
ExpirationDate	Date	False	No	Date on which enrollment is expiring.
LastUpdateDate	Datetime	False	No	Who column: indicates the date and time of the last update of the row.
LastUpdateLogin	String	False	No
LastUpdatedBy	String	False	No	Who column: indicates the user who last updated the row.
PartnerCompanyNumber	String	False	No	Public Unique Identifier of Partner company associated to the Program Enrollments.
PartnerName	String	False	No
PartnerPartyId	Decimal	False	No	Unique identifier of a partner.
PartnerPartyName	String	False	No	Partner Name
PartnerProgramId	Decimal	False	No	Unique identifier of a partner program.
PartnerTierId	Long	False	No
ProgramAccessable	Bool	False	No
ProgramDescription	String	False	No	Text describing the program.
ProgramName	String	False	No	Name of the partner program.
ProgramNumber	String	False	No	A unique number generated for each program.
RemainingDays	String	False	No	Number of days left for expiry of the enrollment.
RenewAllowed	Bool	False	No
RenewedEnrollment	String	False	No	Staus of enrollment which is of type renewal. Possible values are new or renewal.
RenewedFromEnrollmentNumber	String	False	No
RenewedFromId	Decimal	False	No	Unique identifier of the enrollment from which the renewal enrollment is copied.
StartDate	Date	False	No	Effective Start Date of a program enrollment.
SubmissionDate	Date	False	No
SubmitAllowed	Bool	False	No
TerminateAllowed	Bool	False	No
TerminationDate	Date	False	No	Date on which enrollment is terminated.
WithdrawAllowed	Bool	False	No
Finder	String	False	Yes	Input specifying the Finder type.

Return to Top

Proposals

Name	Type	ReadOnly	FilterOnly	Description
TerrProposalId [KEY]	Long	False	No	Identifier of the proposal.
ActFailureReasonCode	String	False	No	Failure Code for Proposal Activation
ActivationDateTime	Datetime	False	No
CreatedBy	String	False	No
CreationDate	Datetime	False	No
DeleteFlag	Bool	False	No	Access Level Indicator For Delete
Description	String	False	No	Brief Description of the proposal and intended changes
LastUpdateDate	Datetime	False	No
LastUpdateLogin	String	False	No
LastUpdatedBy	String	False	No
Name	String	False	No	Name of the proposal
Owner	String	False	No	Display name for the initiator of the proposal.
OwnerId	Long	False	No	Resource who initiated the proposal, Typically the owner of the territory.
OwnerNumber	String	False	No
PartitionCode	String	False	No	This identifies whether or not the proposal is a error correction proposal for territories that were made invalid by dimension/member changes by recording whether the proposal is in the 'Stage' or a 'Production' partition
ProposalNumber	String	False	No	Unique identification number for this proposal
StatusCode	String	False	No	Indicates the status of the proposal
UpdateFlag	Bool	False	No	Access Level Indicator For Update
Finder	String	False	Yes	Input specifying the Finder type.

Return to Top

Resources

Name	Type	ReadOnly	FilterOnly	Description
ResourceProfileId [KEY]	Long	False	No	Unique identifier for the Resource Profile.
CreatedBy	String	False	No	Who column: indicates the user who created the row.
CreationDate	Datetime	False	No	Who column: indicates the date and time of the creation of the row.
DeleteFlag	Bool	False	No	Indicates if the user can delete the resource.
EmailAddress	String	False	No	E-mail address
EndDateActive	Date	False	No	Indicates the date at which the resource becomes inactive
FormattedAddress	String	False	No	Primary Formatted address for the resource
FormattedPhoneNumber	String	False	No	Primary Formatted phone number for the resource
JobMeaning	String	False	No	Job for this resource if it is employee
LastUpdateDate	Datetime	False	No	Who column: indicates the date and time of the last update of the row.
LastUpdateLogin	String	False	No	Who column: indicates the session login associated to the user who last updated the row.
LastUpdatedBy	String	False	No	Who column: indicates the user who last updated the row.
Manager	String	False	No	Name of the manager for this resource
ManagerPartyId	Long	False	No
PartyId	Long	False	No	Identifier for the party. Foreign key to the HZ_PARTIES PARTY_ID.
PartyName	String	False	No	Name of the Party
PartyNumber [KEY]	String	False	No	Unique identification number for this party
PersonFirstName	String	False	No	Peron First Name
PersonLastName	String	False	No	Peron LastName
PersonLastNamePrefix	String	False	No	Resource Peron Last name
PersonMiddleName	String	False	No	Peron Middle Name.
PersonNameSuffix	String	False	No	Peron Name suffix
PersonPreNameAdjunct	String	False	No	Person Preferred Name adjacency
PersonPreviousLastName	String	False	No	perin Previous flag mage
PersonSecondLastName	String	False	No	peron secind last name
PrimaryOrganization	String	False	No	Primary organizations for this resource
RecordSet	String	False	No
ResourceType	String	False	No	Type of Resource ex employee
StartDateActive	Date	False	No	Indicates the date at which the resource becomes active
UpdateFlag	Bool	False	No	Indicates if the user can update the resource.
Url	String	False	No	Primary URL for the resource
Usage	String	False	No	Read only party usage for resource party
Finder	String	False	Yes	Input specifying the Finder type.
BindSysdate	String	False	Yes	The identifier for the resource based on the manager reports flag.

Return to Top

ResourceUsers

Name	Type	ReadOnly	FilterOnly	Description
ResourceProfileId [KEY]	Long	True	No	The profile identifier of the resource.
AddressLine1	String	False	No	The first line of the address of resource.
AddressLine2	String	False	No	The second line of the address of resource.
BusinessUnit	String	False	No	Name of the business unit of worker record of resource.
City	String	False	No	The name of the city for address of resource.
Country	String	False	No	The name of the country for address of resource.
County	String	False	No	Name of the county of the address of resource.
CreateUserAccountFlag	Bool	False	No	Indicates if a user account can be created for the resource.
CreatedBy	String	True	No	CreatedBy
CreationDate	Datetime	True	No	CreationDate
DeleteFlag	Bool	True	No	DeleteFlag
FaxCountryCode	String	False	No	The country code of the fax.
FirstName	String	False	No	The first name of the resource.
FormattedAddress	String	True	No	Primary Formatted address for the resource.
HRManagerEmailAddress	String	False	No	Email address of the human resource manager of worker record for resource.
HireDate	Date	False	No	Start date of the worker record for resource.
IndividualRoleCode	String	False	No	IndividualRoleCode
IndividualRoleEndDate	Date	False	No	IndividualRoleEndDate
IndividualRoleStartDate	Date	False	No	IndividualRoleStartDate
JobCode	String	False	No	Job code assigned to the resource.
JobTitle	String	True	No	Title of the job assigned to resource.
LastName	String	False	No	The last name of the resource.
LastUpdateDate	Datetime	True	No	The date when the record was last updated.
LastUpdatedBy	String	True	No	LastUpdatedBy
LegalEntity	String	False	No	Name of legal entity of the worker record for resource.
MiddleName	String	False	No	The lmiddle name of the resource.
MobilePhoneCountryCode	String	False	No	The country code associated with the mobile phone.
PartyName	String	True	No	A person's name
PersonNumber	String	True	No	Person number identifier of the worker record for resource.
PersonType	String	False	No	Person type of the worker record for resource.
PostalCode	String	False	No	The postal code for the address of resource.
Province	String	False	No	Name of the province for address of resource.
RawFaxNumber	String	False	No	The fax number of the resource in raw format.
RawMobilePhoneNumber	String	False	No	The mobile phone number of the resource.
RawWorkPhoneNumber	String	False	No	The resource's work phone number in raw format.
ResourceEmail	String	False	No	The email address of the resource.
ResourceEndDate	Date	False	No	The date up to which the resource role is active.
ResourceManagerFirstName	String	False	No	The first name of the reporting manager of resource.
ResourceManagerLastName	String	False	No	The last name of the reporting manager of resource.
ResourceManagerName	String	False	No	The name of the manager for the resource.
ResourceManagerPartyId	Long	True	No	The unique internal identifier for the reporting manager of resource.
ResourceManagerPartyNumber	String	True	No	The unique public identifier of the reporting manager of resource.
ResourceOrgManagerEmail	String	False	No	The email address of the reporting manager of resource.
ResourceOrgMemRoleEndDate	Date	False	No	Indicates the date when the resource organization membership of the resource ends
ResourceOrgMemRoleStartDate	Date	False	No	ResourceOrgMemRoleStartDate
ResourceOrgRoleCode	String	False	No	The code that indicates the role of the resource in association with organization membership.
ResourceOrgRoleName	String	True	No	The role that defines the function of the resource in an organization or hierarchy.
ResourceOrganizationName	String	False	No	The name of the resource organization associated to the resource.
ResourceOrganizationUsage	String	True	No	The usage type of the resource organization.
ResourceParentOrganizationName	String	False	No	The name of the parent organization of resource.
ResourcePartyId	Long	False	No	The unique party identifier of the person record for resource.
ResourcePartyNumber	String	False	No	The party number of the person record for resource.
ResourceStartDate	Date	False	No	Date on which the resource becomes active.
ResourceType	String	False	No	Describes the resource type.
State	String	False	No	The state in the resource's address.
TimezoneCode	String	False	No	The code of time zone for the resource.
Title	String	False	No	The title for the name of resource.
TopResourceFlag	Bool	False	No	TopResourceFlag
UpdateFlag	Bool	True	No	Indicates if the user can update the resource.
UserStatus	String	False	No	Indicates the the status of the user account for the resource. The supported values are A for active and S for suspended. The status is set to A for new accounts.
Username	String	False	No	User login account name of resource user.
WorkPhoneCountryCode	String	False	No	The country code associated with the work phone.
Finder	String	False	Yes	Input specifying the Finder type.
BindPartyId	String	False	Yes	The unique primary key identifier of the party associated with the resource.

Return to Top

ResourceUsersResourceRoleAssignments

Name	Type	ReadOnly	References	FilterOnly	Description
RoleRelateId [KEY]	Long	False		No	Role Relation identifier (PK)
ResourceProfileId [KEY]	String	False	ResourceUsers.ResourceProfileId	No	ResourceProfileId
EndDateActive	Date	False		No	Date this role-resource becomes inactive
PartyName	String	False		No	PartyName
RoleCode	String	False		No	RoleCode
RoleId	Long	False		No	Role identifier (foreign key to JTF_RS_ROLES)
RoleResourceId	Long	False		No	Resource identifier (foreign key to HZ_PARTIES) or (foreign key to JTF_RS_GROUPS_MEMBERS or (foreign key to JTF_RS_TEAM_MEMBERS)
StartDateActive	Date	False		No	Date this role-resource becomes active
Finder	String	False		Yes	Input specifying the Finder type.
BindPartyId	String	False		Yes	The unique primary key identifier of the party associated with the resource.
ResourcePartyNumber	String	False		Yes	Input specifying the ResourcePartyNumber type.

Return to Top

SalesLeadAttachments

Name	Type	ReadOnly	References	FilterOnly	Description
AttachedDocumentId [KEY]	Long	False		No	The unique identifier of the attached document.
LeadId [KEY]	String	False	SalesLeads.LeadId	No	LeadId
AsyncTrackerId	String	False		No	Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files.
CategoryName	String	False		No	The category of the attachment.
ContentRepositoryFileShared	Bool	False		No	Indicates whether the attachment is shared
CreatedBy	String	False		No	The user who created the record.
CreatedByUserName	String	False		No	The user name who created the record.
CreationDate	Datetime	False		No	The date when the record was created.
DatatypeCode	String	False		No	A value that indicates the data type.
Description	String	False		No	The description of the attachment.
DmDocumentId	String	False		No	The document ID from which the attachment is created.
DmFolderPath	String	False		No	The folder path from which the attachment is created.
DmVersionNumber	String	False		No	The document version number from which the attachment is created.
DownloadInfo	String	False		No	JSON object represented as a string containing information used to programmatically retrieve a file attachment.
ErrorStatusCode	String	False		No	The error code, if any, for the attachment.
ErrorStatusMessage	String	False		No	The error message, if any, for the attachment.
ExpirationDate	Datetime	False		No	The expiration date of the contents in the attachment.
FileContents	String	False		No	The contents of the attachment.
FileName	String	False		No	The file name of the attachment.
FileUrl	String	False		No	The URI of the file.
FileWebImage	String	False		No	The base64 encoded image of the file displayed in .png format if the source is a convertible image.
LastUpdateDate	Datetime	False		No	The date when the record was last updated.
LastUpdatedBy	String	False		No	The user who last updated the record.
LastUpdatedByUserName	String	False		No	The user name who last updated the record.
PostProcessingAction	String	False		No	The name of the action that can be performed after an attachment is uploaded.
Title	String	False		No	The title of the attachment.
UploadedFileContentType	String	False		No	The content type of the attachment.
UploadedFileLength	Long	False		No	The size of the attachment file.
UploadedFileName	String	False		No	The name to assign to a new attachment file.
UploadedText	String	False		No	The text content for a new text attachment.
Uri	String	False		No	The URI of a Topology Manager type attachment.
Url	String	False		No	The URL of a web page type attachment.
UserName	String	False		No	The login credentials of the user who created the attachment.
Finder	String	False		Yes	Input specifying the Finder type.
ContactId	String	False		Yes	The unique identifier of the Contact.
SysEffectiveDate	String	False		Yes	SysEffectiveDate.
ResourcePartyIdRest	String	False		Yes	The unique identifier of the Resource.
RestCreationDateLower	String	False		Yes	Finds the leads that are created before the date specified.
RestCreationDateUpper	String	False		Yes	Finds the leads with the specified creation date.
RestRecordSet	String	False		Yes	Finds the leads with the specified record set value.
RestStatusCode	String	False		Yes	Finds the leads with the specified status code.
Name	String	False		Yes	Finds the leads with the specified name.
LeadNumber	String	False		Yes	Finds the leads with the specified lead number.

Return to Top

SalesLeadContacts

Name	Type	ReadOnly	References	FilterOnly	Description
LeadMemberId [KEY]	Long	False		No	Primary Key for Lead Contact
LeadId [KEY]	String	False	SalesLeads.LeadId	No	LeadId
AccountName	String	True		No	AccountName
City	String	True		No	City associated with the identifying address associated with this lead contact.
ConflictId	Long	False		No	ConflictId
ContactDoNotCallFlag	Bool	True		No	Do not call flag set at person level for the sales lead contact.
ContactDoNotContactFlag	Bool	True		No	Do not contact flag set at person level for the sales lead contact.
ContactDoNotMailFlag	Bool	True		No	Do not mail flag set at person level for the sales lead contact.
ContactJobTitle	String	False		No	ContactJobTitle
CreatedBy	String	True		No	Indicates the user who created this record.
CreationDate	Datetime	True		No	Indicates the date and time when this record is created.
EmailAddress	String	False		No	Email address associated with the sales lead contact.
EmailPreference	String	True		No	Indicates if the lead contact has an email preference of do not email, ok to email, or no value.
FormattedPhoneNumber	String	False		No	Stores formatted phone number of the lead contact.
JobTitle	String	True		No	Job title of the sales lead contact.
LastUpdateDate	Datetime	True		No	System field that indicates the date and time of the last update of the row.
LastUpdateLogin	String	True		No	Who column: indicates the session login associated to the user who last updated the row.
LastUpdatedBy	String	True		No	System field that indicates the user who last updated the row.
LeadNumber	String	False		No	LeadNumber
OrgContactId	Long	True		No	Organization Contact Identifier of the sales lead contact
PartyId	Long	False		No	Party identifier of the lead contact.
PartyName	String	True		No	Party name of the lead contact.
PartyNumber	String	False		No	Party Number of the sales lead contact
PartyType	String	True		No	Indicates the type of the party recorded as lead contact. Possible values are person, organization or group.
PartyUsageCode	String	False		No	Party usage recorded for this lead contact in the customer master.
PersonFirstName	String	True		No	First name of the lead contact.
PersonLastName	String	True		No	Last name or surname of this lead contact.
PersonTitle	String	True		No	Title asscoaited with the lead contact. This is not the same as the job title.
PhonePreference	String	True		No	Indicates whether the lead contact has a phone preference of do not call, ok to call, or no value.
PostalCode	String	True		No	Postal code part of the identifying address associated with this lead contact.
PrimaryCustomerId	Long	True		No	PrimaryCustomerId
PrimaryFlag	Bool	False		No	Indicates whether this lead contact is primary. Primary lead contact is also the lead owner.
RelationshipId	Long	False		No	Relationship identifier for this lead contact. This represents the relation of this lead contact with lead customer.
Role	String	False		No	Role of lead contact in the context of this lead.
State	String	True		No	State part of the identifying address associated with this lead contact.
Finder	String	False		Yes	Input specifying the Finder type.
ContactId	String	False		Yes	The unique identifier of the Contact.
SysEffectiveDate	String	False		Yes	SysEffectiveDate.
ResourcePartyIdRest	String	False		Yes	The unique identifier of the Resource.
RestCreationDateLower	String	False		Yes	Finds the leads that are created before the date specified.
RestCreationDateUpper	String	False		Yes	Finds the leads with the specified creation date.
RestRecordSet	String	False		Yes	Finds the leads with the specified record set value.
RestStatusCode	String	False		Yes	Finds the leads with the specified status code.
Name	String	False		Yes	Finds the leads with the specified name.

Return to Top

SalesLeadResources

Name	Type	ReadOnly	References	FilterOnly	Description
LeadResourceId [KEY]	Long	False		No	Identifier of the sales lead resource.
LeadId [KEY]	String	False	SalesLeads.LeadId	No	LeadId
AccessLevelCode	String	False		No	Access level for the sale team member on the lead.
ConflictId	Long	False		No	ConflictId
CreatedBy	String	True		No	Indicates the user who created this record.
CreationDate	Datetime	True		No	Indicates the date and time when this record is created.
EmailAddress	String	True		No	Email address associated with the sales lead team resource.
FormattedPhoneNumber	String	True		No	Stores formatted phone number of the lead sales team resource.
FunctionalRole	String	False		No	Indicates the role played by this Sale team resource for the handling of this sales lead.
LastUpdateDate	Datetime	True		No	System field that indicates the date and time of the last update of the row.
LastUpdateLogin	String	True		No	LastUpdateLogin
LastUpdatedBy	String	True		No	System field that indicates the user who last updated the row.
LeadNumber	String	False		No	LeadNumber
ManagerName	String	True		No	Manager name of the resource
Name	String	True		No	Name of this lead resource.
PartyName	String	True		No	Party name of the lead resource.
PartyNumber	String	False		No	Party contact number.
PrimaryFlag	Bool	False		No	Indicates whether the record represents the primay resource on the lead. Primary resource on the lead is the same as the lead owner.
PrimaryPhonePurpose	String	True		No	Indicates Contact point type that is used for updating underlying contact point TCA data.
ResourceId	Long	False		No	Resource identifier associated with this lead resource.
ResourceOrgId	Long	True		No	Resource organization identifier associated with this lead resource.
RoleName	String	True		No	Name of the role of the lead resource in the context of this sales lead.
Finder	String	False		Yes	Input specifying the Finder type.
ContactId	String	False		Yes	The unique identifier of the Contact.
SysEffectiveDate	String	False		Yes	SysEffectiveDate.
ResourcePartyIdRest	String	False		Yes	The unique identifier of the Resource.
RestCreationDateLower	String	False		Yes	Finds the leads that are created before the date specified.
RestCreationDateUpper	String	False		Yes	Finds the leads with the specified creation date.
RestRecordSet	String	False		Yes	Finds the leads with the specified record set value.
RestStatusCode	String	False		Yes	Finds the leads with the specified status code.

Return to Top

SalesLeads

Name	Type	ReadOnly	FilterOnly	Description
LeadId [KEY]	Long	False	No	Partner Type. Indicates the type of partner stamped on the lead.
AILeadScore	Double	True	No	AILeadScore
AcceptedDate	Date	True	No	The date on which lead was accepted by a resource assigned to it.
AcceptedDateTime	Datetime	True	No	Date and time when the sales lead is accepted by a resource assigned to it.
AccountPartyNumber	String	False	No	AccountPartyNumber
AddrElementAttribute1	String	False	No	Additional address element to support flexible address format.
AddrElementAttribute2	String	False	No	Additional address element to support flexible address format.
AddrElementAttribute3	String	False	No	Additional address element to support flexible address format.
AddrElementAttribute4	String	False	No	Additional address element to support flexible address format.
AddrElementAttribute5	String	False	No	Additional address element to support flexible address format.
AddressLinesPhonetic	String	False	No	Phonetic or Kana representation of the Kanji address lines (used in Japan).
ApprovalDate	Date	False	No	The date on which a partner registered lead is approved by internal channel manager.
ApprovalDateTime	Datetime	False	No	Date and time when the sales lead is approved. This is only applicable to deal registrations.
AssetId	Long	False	No	Unique identifier for the Asset associated with the Sales Lead.
AssetNumber	String	False	No	Unique Number for the Asset associated with the Sales Lead.
AssetSerialNumber	String	True	No	Serial Number for the Asset associated with the Sales Lead.
AssignmentStatusCode	String	False	No	Includes the current assignment related status for the lead, for example whether the lead is assigned or unassigned.
BudgetAmount	Decimal	False	No	Budget amount associated with this sales lead.
BudgetCurrencyCode	String	False	No	Currency code associated with the Budget Amount associated with this sales lead.
BudgetStatus	String	False	No	Budget status associated with the Budget Amount associated with this sales lead.
Building	String	False	No	Specific building name or number at a given address.
BusinessUnitId	Long	False	No	Business Unit Identifier associated with the business unit of the sales lead creator.
CampaignName	String	True	No	Name of the campaign associated with the sales lead.
ChannelType	String	False	No	Indicates the channel through which this lead contacted the company.
ClassCode1	String	False	No	The auxilliary dimension for the Account.
ClassCode2	String	False	No	The auxilliary dimension for the Account.
ClassCode3	String	False	No	The auxilliary dimension for the Account.
ClassCode4	String	False	No	The auxilliary dimension for the Account.
ConflictId	Long	False	No	ConflictId
ContactDoNotPreference	Bool	False	No	ContactDoNotPreference
ContactFormattedAddress	String	True	No	ContactFormattedAddress
ContactPartyNumber	String	False	No	ContactPartyNumber
ContactTimezoneCd	String	False	No	Preferred time zone of the contact pursued on the lead.
ConvertedDateTime	Datetime	False	No	Date and time when the sales lead is converted to an opportunity.
CreatedBy	String	True	No	Indicates the user who created this record.
CreationDate	Datetime	True	No	Indicates the date and time when this record is created.
CurrencyCode	String	False	No	Currency code for the lead.
CustPartyType	String	False	No	CustPartyType
CustomerId	Long	False	No	Customer Id. It is a reference to the customer record in the TCA schema.
CustomerNeed	String	False	No	Indicates what need the lead product serves for the lead customer.
CustomerPartyName	String	False	No	Name of the customer.
DealAmount	Decimal	False	No	The total amount attributed to a lead.
DecisionMakerIdentifiedFlag	Bool	False	No	Indicates if the decision maker at customer site has been identified.
DeleteFlag	Bool	True	No	This flag controls if the user has access to delete the record
Description	String	False	No	Description associated with this sales lead.
Distance	Double	True	No	Distance from the input location.
EligibleForConversionFlag	Bool	False	No	EligibleForConversionFlag
EnableCreateAccount	String	False	No	EnableCreateAccount
EnableCreateContact	String	False	No	EnableCreateContact
EstimatedCloseDate	Date	False	No	Estimated close date for a deal once registered
ExpirationDate	Date	False	No	Expiration date associated with this sales lead.
FloorNumber	String	False	No	Specific floor number at a given address or in a particular building when building number is provided.
FollowupTimestamp	Date	False	No	Indicates when the sales lead needs to be followed up.
FormattedPhoneNumber1	String	True	No	FormattedPhoneNumber1
IBAssetId	Long	False	No	Unique identifier for the IB Asset associated with the Sales Lead.
IBAssetNumber	String	True	No	Unique number for the IB Asset associated with the Sales Lead.
IBAssetSerialNumber	String	True	No	Unique serial number for the IB Asset associated with the Sales Lead.
InventoryItemDescription	String	False	No	The description of the product added to a lead.
JobTitle	String	False	No	Job title of the primary contact on the sales lead.
LastAssignmentDate	Datetime	False	No	The date on which the lead was last reassigned.
LastUpdateDate	Datetime	True	No	Who column: indicates the date and time of the last update of the row.
LastUpdateLogin	String	True	No	Who column: indicates the login of the user who last updated the row.
LastUpdatedBy	String	True	No	Who column: indicates the user who last updated the row.
Latitude	Double	False	No	Latitude information for the location.
LeadAcceptedFlag	Bool	False	No	Indicates if the lead has been accepted.
LeadAging	Double	True	No	The number of days elapsed since the lead was created.
LeadCreatedBy	String	False	No	Functional WHO: Indicates the user who created this record.
LeadCreationDate	Datetime	False	No	Functional WHO: Indicates the date and time when this record is created.
LeadLastUpdateDate	Datetime	False	No	Functional WHO: Indicates the date and time of the last update of the row.
LeadLastUpdatedBy	String	False	No	Functional WHO: Indicates the user who last updated the row.
LeadNumber	String	False	No	User friendly unique identifier for a lead.
LeadOrigin	String	False	No	Origin of the Lead
Longitude	Double	False	No	Longitude information for the location.
Name	String	False	No	Lead Name used for identifying the lead.
OpportunityName	String	False	No	OpportunityName
OpportunityOwnerNumber	String	False	No	OpportunityOwnerNumber
OrganizationSize	String	False	No	Organization Size
OrganizationType	String	False	No	Organization Type
OwnerId	Long	False	No	Party identifier associated with the owner of this sales lead.
OwnerPartyName	String	False	No	Name associated with the owner of this sales lead.
OwnerPartyNumber	String	False	No	OwnerPartyNumber
PartnerCompanyNumber	String	False	No	PartnerCompanyNumber
PartnerId	Long	False	No	Unique identifier for the primary partner associated with the lead.
PartnerPartyName	String	False	No	Name associated with the primary partner of this sales lead. This is a deal specific attribute.
PartnerProgramId	Long	False	No	A reference to the partner program in which the primary partner associated with this sales lead is enrolled. This is a deal specific attribute.
PartnerProgramNumber	String	False	No	PartnerProgramNumber
PartnerType	String	False	No	Indicates the type of the primary partner associated with this sales lead. This is a deal specific attribute.
PostalPlus4Code	String	False	No	Four digit extension to the United States Postal ZIP code.
PrimaryCampaignId	Long	False	No	PrimaryCampaignId
PrimaryCampaignName	String	False	No	PrimaryCampaignName
PrimaryCampaignNumber	String	False	No	PrimaryCampaignNumber
PrimaryCompetitorName	String	False	No	PrimaryCompetitorName
PrimaryCompetitorPartyId	Long	False	No	PrimaryCompetitorPartyId
PrimaryCompetitorPartyNumber	String	False	No	PrimaryCompetitorPartyNumber
PrimaryContactAddress1	String	False	No	The first line of address associated with the primary contact of the lead.
PrimaryContactAddress2	String	False	No	The second line of address associated with the primary contact of the lead.
PrimaryContactAddress3	String	False	No	The third line of address associated with the primary contact of the lead.
PrimaryContactAddress4	String	False	No	The fourth line of address associated with the primary contact of the lead.
PrimaryContactCity	String	False	No	The city where the primary contact of the lead is located.
PrimaryContactCountry	String	False	No	The country where the primary contact of the lead is located.
PrimaryContactCountryName	String	True	No	Full name associated with primary contact country code
PrimaryContactCounty	String	False	No	The county where the primary contact of the lead is located.
PrimaryContactEmailAddress	String	False	No	Email address for the primary sales lead contact on the lead
PrimaryContactEmailPreference	String	False	No	PrimaryContactEmailPreference
PrimaryContactEmailVerificationDate	Datetime	False	No	PrimaryContactEmailVerificationDate
PrimaryContactEmailVerificationStatus	String	False	No	PrimaryContactEmailVerificationStatus
PrimaryContactId	Long	False	No	Identifer of the sales lead contact marked as a primary lead contact.
PrimaryContactMailPreference	String	False	No	PrimaryContactMailPreference
PrimaryContactPartyName	String	False	No	Name associated with the primary lead contact.
PrimaryContactPersonFirstName	String	False	No	First name of the primary contact for a lead.
PrimaryContactPersonLastName	String	False	No	Last name of the primary contact for a lead.
PrimaryContactPersonMiddleName	String	False	No	Middle name of the primary contact for a lead.
PrimaryContactPhonePreference	String	False	No	PrimaryContactPhonePreference
PrimaryContactPostalCode	String	False	No	The zip code where the primary contact of the lead is located.
PrimaryContactProvince	String	False	No	The province where the primary contact of the lead is located.
PrimaryContactRelationshipId	Long	False	No	Unique identifier of the relationship primary contact has with its parent organization.
PrimaryContactState	String	False	No	The state where the primary contact of the lead is located.
PrimaryInventoryItemId	Long	False	No	Unique identifier of the primary product associated with a lead.
PrimaryInventoryItemNumber	String	False	No	PrimaryInventoryItemNumber
PrimaryInventoryOrgId	Long	False	No	Unique identifier of the organization to which the primary product associated with a lead belongs.
PrimaryPhoneAreaCode	String	False	No	Primary phone area code for the sales lead contact.
PrimaryPhoneCountryCode	String	False	No	Primary phone country code for the sales lead contact.
PrimaryPhoneNumber	String	False	No	Primary phone number for the sales lead contact.
PrimaryPhoneVerificationDate	Datetime	False	No	PrimaryPhoneVerificationDate
PrimaryPhoneVerificationStatus	String	False	No	PrimaryPhoneVerificationStatus
PrimaryProductGroupId	Long	False	No	Unique identifier of the primary product group associated with a lead.
PrimaryProductGroupReferenceNumber	String	False	No	PrimaryProductGroupReferenceNumber
ProductGroupDescription	String	True	No	Description of the product or product group associated with a lead.
ProductGroupName	String	False	No	Name of the product group associated with a lead.
ProductType	String	False	No	ProductType
ProgramName	String	False	No	Name of the partner program in which the primary partner associated with this sales lead is enrolled. This is a deal specific attribute.
Project	String	False	No	customer project identified for this sales lead.
QualificationScore	Int	True	No	Qualification score for a lead.
QualifiedDate	Date	False	No	Indicates the date when this sales lead was qualified.
QualifiedDateTime	Datetime	False	No	Date and time when the sales lead is qualified.
Rank	String	False	No	Rank associated with this sales lead.
RawPrimaryPhoneNumber	String	False	No	RawPrimaryPhoneNumber
ReassignComment	String	False	No	Comment provided by a user while requesting the lead reassignment.
ReassignReasonCode	String	False	No	Pre-defined code used to indicate the reason for lead reassignment.
RecordSet	String	True	No	RecordSet
RegistrationNumber	String	False	No	Registration number of the sales lead. This unique identifier is generated when the sales lead is approved. This is a deal specific attribute.
RegistrationStatus	String	False	No	Approval Status of the sales lead. This is a deal specific attribute.
RegistrationType	String	False	No	Indicates the registration type of the sales lead. This is a deal specific attribute.
RejectByUserId	Long	False	No	Identifier of the sales representative who rejected this sales lead.
RejectComment	String	False	No	Comments provided by the sales representative who rejected this sales lead.
RejectReasonCode	String	False	No	Pre-defined code used to indicate the reason for rejecting a lead.
RejectedDateTime	Datetime	False	No	Date and time when the sales lead is rejected.
RetireComment	String	False	No	Comments recorded when the sales lead is moved to a retired status.
RetireReasonCode	String	False	No	Pre-defined code used to indicate the reason for retiring a lead.
RetiredDateTime	Datetime	False	No	Date and time when the sales lead is moved to a retired status.
SalesChannel	String	False	No	Indicates the sales channel responsible for following up on this sales lead.
SalesTargetLeadEloquaSyncDate	Datetime	False	No	SalesTargetLeadEloquaSyncDate
SalesTargetLeadOptOutComment	String	False	No	SalesTargetLeadOptOutComment
SalesTargetLeadOptOutDate	Datetime	False	No	SalesTargetLeadOptOutDate
SalesTargetLeadOptOutReasonCode	String	False	No	SalesTargetLeadOptOutReasonCode
SalesTargetLeadStage	String	False	No	SalesTargetLeadStage
SalesTargetLeadValidationDueDate	Datetime	False	No	SalesTargetLeadValidationDueDate
Score	Int	False	No	The score associated with this sales lead. This score is computed based on the scoring rules.
SourceCode	String	False	No	Marketing source code associated with this sales lead.
StatusCode	String	False	No	Pre-defined code used to indicate the status of a lead.
Timeframe	String	False	No	Timeframe associated with this sales lead.
ToReassignFlag	Bool	False	No	Identifies leads that are marked for reassignment.
UpdateFlag	Bool	True	No	This flag controls if the user has access to update the record
WorkPhoneAreaCode	String	False	No	Work phone area code for the sales lead contact.
WorkPhoneCountryCode	String	False	No	Work phone country code for the sales lead contact.
WorkPhoneNumber	String	False	No	Work phone number for the sales lead contact.
Finder	String	False	Yes	Input specifying the Finder type.
ContactId	String	False	Yes	The unique identifier of the Contact.
SysEffectiveDate	String	False	Yes	SysEffectiveDate.
ResourcePartyIdRest	String	False	Yes	The unique identifier of the Resource.
RestCreationDateLower	String	False	Yes	Finds the leads that are created before the date specified.
RestCreationDateUpper	String	False	Yes	Finds the leads with the specified creation date.
RestRecordSet	String	False	Yes	Finds the leads with the specified record set value.
RestStatusCode	String	False	Yes	Finds the leads with the specified status code.

Return to Top

SalesLeadsLeadCampaigns

Name	Type	ReadOnly	References	FilterOnly	Description
LeadCampaignId [KEY]	Long	True		No	LeadCampaignId
LeadId [KEY]	String	True	SalesLeads.LeadId	No	LeadId
CampaignEndDate	Datetime	True		No	CampaignEndDate
CampaignId	Long	False		No	CampaignId
CampaignName	String	True		No	CampaignName
CampaignNumber	String	False		No	CampaignNumber
CampaignStartDate	Datetime	True		No	CampaignStartDate
CampaignStatus	String	True		No	CampaignStatus
CampaignType	String	True		No	CampaignType
CreatedBy	String	True		No	CreatedBy
CreationDate	Datetime	True		No	CreationDate
LastUpdateDate	Datetime	True		No	LastUpdateDate
LastUpdatedBy	String	True		No	LastUpdatedBy
LeadCampaignNumber	String	False		No	LeadCampaignNumber
LeadNumber	String	False		No	LeadNumber
PrimaryFlag	Bool	False		No	PrimaryFlag
Finder	String	False		Yes	Input specifying the Finder type.
ContactId	String	False		Yes	The unique identifier of the Contact.
SysEffectiveDate	String	False		Yes	SysEffectiveDate.
ResourcePartyIdRest	String	False		Yes	The unique identifier of the Resource.
RestCreationDateLower	String	False		Yes	Finds the leads that are created before the date specified.
RestCreationDateUpper	String	False		Yes	Finds the leads with the specified creation date.
RestRecordSet	String	False		Yes	Finds the leads with the specified record set value.
RestStatusCode	String	False		Yes	Finds the leads with the specified status code.
Name	String	False		Yes	Input specifying the name.

Return to Top

SalesLeadsLeadCompetitors

Name	Type	ReadOnly	References	FilterOnly	Description
LeadCompetitorId [KEY]	Long	False		No	LeadCompetitorId
LeadId [KEY]	String	False	SalesLeads.LeadId	No	LeadId
Comments	String	False		No	Comments
CompetitorPartyId	Long	False		No	CompetitorPartyId
CompetitorPartyName	String	True		No	CompetitorPartyName
CompetitorPartyNumber	String	False		No	CompetitorPartyNumber
CreatedBy	String	True		No	CreatedBy
CreationDate	Datetime	True		No	CreationDate
LastUpdateDate	Datetime	True		No	LastUpdateDate
LastUpdateLogin	String	True		No	LastUpdateLogin
LastUpdatedBy	String	True		No	LastUpdatedBy
LeadCompetitorNumber	String	False		No	LeadCompetitorNumber
LeadNumber	String	False		No	LeadNumber
PrimaryFlag	Bool	False		No	PrimaryFlag
ThreatLevelCode	String	False		No	ThreatLevelCode
Finder	String	False		Yes	Input specifying the Finder type.
ContactId	String	False		Yes	The unique identifier of the Contact.
SysEffectiveDate	String	False		Yes	SysEffectiveDate.
ResourcePartyIdRest	String	False		Yes	The unique identifier of the Resource.
RestCreationDateLower	String	False		Yes	Finds the leads that are created before the date specified.
RestCreationDateUpper	String	False		Yes	Finds the leads with the specified creation date.
RestRecordSet	String	False		Yes	Finds the leads with the specified record set value.
RestStatusCode	String	False		Yes	Finds the leads with the specified status code.
Name	String	False		Yes	Finds the leads with the specified name.

Return to Top

SalesLeadsLeadOpportunity

Name	Type	ReadOnly	References	FilterOnly	Description
LeadNumber [KEY]	String	False		No	LeadNumber
LeadId [KEY]	String	False	SalesLeads.LeadId	No	LeadId
Account	String	False		No	Account
Currency	String	False		No	Currency
ExpectedAmount	Long	False		No	ExpectedAmount
LeadName	String	False		No	LeadName
OptyCloseDate	Datetime	False		No	OptyCloseDate
OptyId	Long	False		No	OptyId
OptyName	String	False		No	OptyName
OptyNumber	String	False		No	OptyNumber
OptyStatus	String	False		No	OptyStatus
RevenueAmount	Long	False		No	RevenueAmount
SalesStageId	Long	False		No	SalesStageId
SalesStageName	String	False		No	SalesStageName
WinProbability	Long	False		No	WinProbability
Finder	String	False		Yes	Input specifying the Finder type.
ContactId	String	False		Yes	The unique identifier of the Contact.
SysEffectiveDate	String	False		Yes	SysEffectiveDate.
ResourcePartyIdRest	String	False		Yes	The unique identifier of the Resource.
RestCreationDateLower	String	False		Yes	Finds the leads that are created before the date specified.
RestCreationDateUpper	String	False		Yes	Finds the leads with the specified creation date.
RestRecordSet	String	False		Yes	Finds the leads with the specified record set value.
RestStatusCode	String	False		Yes	Finds the leads with the specified status code.
Name	String	False		Yes	Finds the leads with the specified name.

Return to Top

SalesLeadsLeadQualifications

Name	Type	ReadOnly	References	FilterOnly	Description
AssessmentId [KEY]	Long	False		No	AssessmentId
LeadId [KEY]	String	False	SalesLeads.LeadId	No	LeadId
AssessTemplateId	Long	False		No	AssessTemplateId
AssessedLanguage	String	False		No	AssessedLanguage
AssessedObjTypeCode	String	False		No	AssessedObjTypeCode
AssessedObjectId	Long	False		No	AssessedObjectId
AssessmentScore	Int	False		No	AssessmentScore
BusinessUnit	Long	False		No	BusinessUnit
ConflictId	Long	False		No	ConflictId
CreatedBy	String	True		No	CreatedBy
LastUpdateDate	Datetime	True		No	LastUpdateDate
LastUpdatedBy	String	True		No	LastUpdatedBy
Name	String	False		No	Name
RatingFeedback	String	True		No	RatingFeedback
RatingTerm	String	True		No	RatingTerm
StatusCode	String	False		No	StatusCode
StatusFuse	String	True		No	StatusFuse
TemplateName	String	False		No	TemplateName
TemplateType	String	False		No	TemplateType
TotalAnswered	Double	False		No	TotalAnswered
TotalQuestions	Double	False		No	TotalQuestions
Finder	String	False		Yes	Input specifying the Finder type.
ContactId	String	False		Yes	The unique identifier of the Contact.
SysEffectiveDate	String	False		Yes	SysEffectiveDate.
ResourcePartyIdRest	String	False		Yes	The unique identifier of the Resource.
RestCreationDateLower	String	False		Yes	Finds the leads that are created before the date specified.
RestCreationDateUpper	String	False		Yes	Finds the leads with the specified creation date.
RestRecordSet	String	False		Yes	Finds the leads with the specified record set value.
RestStatusCode	String	False		Yes	Finds the leads with the specified status code.
LeadNumber	String	False		Yes	Finds the leads with the lead number.

Return to Top

SalesLeadsLeadTeam

Name	Type	ReadOnly	References	FilterOnly	Description
LeadTeamId [KEY]	Long	False		No	LeadTeamId
LeadId [KEY]	String	False	SalesLeads.LeadId	No	LeadId
AccessLevelCode	String	False		No	AccessLevelCode
AddedOnDateTime	Datetime	False		No	AddedOnDateTime
City	String	False		No	City
ConflictId	Long	False		No	ConflictId
Country	String	False		No	Country
CreatedBy	String	False		No	CreatedBy
CreationDate	Datetime	False		No	CreationDate
EmailAddress	String	False		No	EmailAddress
FormattedPhoneNumber	String	False		No	FormattedPhoneNumber
FunctionCode	String	False		No	FunctionCode
FunctionalRole	String	False		No	FunctionalRole
LastUpdateDate	Datetime	False		No	LastUpdateDate
LastUpdateLogin	String	False		No	LastUpdateLogin
LastUpdatedBy	String	False		No	LastUpdatedBy
LeadNumber	String	False		No	LeadNumber
LeadResourceId	Long	False		No	LeadResourceId
OwnerFlag	Bool	False		No	OwnerFlag
PartyId	Long	False		No	PartyId
PartyName	String	False		No	PartyName
PartyNumber	String	False		No	PartyNumber
PrimaryFlag	Bool	False		No	PrimaryFlag
PrimaryPhoneNumber	String	False		No	PrimaryPhoneNumber
PrimaryPhonePurpose	String	False		No	PrimaryPhonePurpose
ResourceId	Long	False		No	ResourceId
ResourceRoleName	String	False		No	ResourceRoleName
State	String	False		No	State
TerritoryFunctionCode	String	False		No	TerritoryFunctionCode
TerritoryName	String	False		No	TerritoryName
TerritoryNumber	String	False		No	TerritoryNumber
TerritoryOwnerFlag	Bool	False		No	TerritoryOwnerFlag
TerritoryVersionId	Double	False		No	TerritoryVersionId
TypeCode	String	False		No	TypeCode
Finder	String	False		Yes	Input specifying the Finder type.
ContactId	String	False		Yes	The unique identifier of the Contact.
SysEffectiveDate	String	False		Yes	SysEffectiveDate.
ResourcePartyIdRest	String	False		Yes	The unique identifier of the Resource.
RestCreationDateLower	String	False		Yes	Finds the leads that are created before the date specified.
RestCreationDateUpper	String	False		Yes	Finds the leads with the specified creation date.
RestRecordSet	String	False		Yes	Finds the leads with the specified record set value.
RestStatusCode	String	False		Yes	Finds the leads with the specified status code.
Name	String	False		Yes	Finds the leads with the specified name.

Return to Top

SalesLeadsNotes

Name	Type	ReadOnly	References	FilterOnly	Description
NoteId [KEY]	Long	True		No	The unique identifier of the note. This is the primary key of the notes table.
LeadId [KEY]	String	False	SalesLeads.LeadId	No	LeadId
ContactRelationshipId	Long	False		No	The relationship ID populated when the note is associated with a contact.
CorpCurrencyCode	String	False		No	The corporate currency code for extensibility.
CreatedBy	String	True		No	The user who created the record.
CreationDate	Datetime	True		No	The date when the record was created.
CreatorPartyId	Long	False		No	The unique identifier of the party.
CurcyConvRateType	String	False		No	The currency conversion rate type for extensibility.
CurrencyCode	String	False		No	The currency code for extensibility.
DeleteFlag	Bool	True		No	Indicates whether the user has access to delete the note.
EmailAddress	String	True		No	The email address of the user who created the note.
FormattedAddress	String	True		No	The address of the user who created the note.
FormattedPhoneNumber	String	True		No	The phone number of the user who created the note.
LastUpdateDate	Datetime	True		No	The date when the record was last updated.
LastUpdateLogin	String	True		No	The login of the user who last updated the record.
LastUpdatedBy	String	True		No	The unique identifier of the note. This is the primary key of the notes table.
NoteNumber	String	False		No	The alternate unique identifier of the note. A user key that's system generated or from an external system.
NoteTitle	String	False		No	The title of the note entered by the user.
NoteTxt	String	False		No	The column which stores the actual note text.
NoteTypeCode	String	False		No	The note type code for categorization of note.
ParentNoteId	Long	False		No	The unique identifier of the note. This is the primary key of the notes table.
PartyId	Long	True		No	The unique identifier of the party.
PartyName	String	True		No	The name of the party.
SourceObjectCode	String	False		No	This is the source object code for the source object as defined in OBJECTS Metadata.
SourceObjectId	String	False		No	The unique identifier of the parent source object associated to the note.
UpdateFlag	Bool	True		No	Indicates whether the user can update the note.
VisibilityCode	String	False		No	The attribute to specify the visibility level of the note. It indicates whether the note is internal, external, or private.
Finder	String	False		Yes	Input specifying the Finder type.
ContactId	String	False		Yes	The unique identifier of the Contact.
SysEffectiveDate	String	False		Yes	SysEffectiveDate.
ResourcePartyIdRest	String	False		Yes	The unique identifier of the Resource.
RestCreationDateLower	String	False		Yes	Finds the leads that are created before the date specified.
RestCreationDateUpper	String	False		Yes	Finds the leads with the specified creation date.
RestRecordSet	String	False		Yes	Finds the leads with the specified record set value.
RestStatusCode	String	False		Yes	Finds the leads with the specified status code.
Name	String	False		Yes	Finds the leads with the specified name.
LeadNumber	String	False		Yes	Finds the leads with the specified lead number.

Return to Top

SalesLeadsProductGroups

Name	Type	ReadOnly	References	FilterOnly	Description
ProdGroupId [KEY]	Long	False		No	ProdGroupId
LeadId [KEY]	String	False	SalesLeads.LeadId	No	LeadId
Description	String	False		No	Description
DisplayName	String	False		No	DisplayName
LastUpdateDate	String	False		No	LastUpdateDate
ModelConfigAttributes	String	False		No	ModelConfigAttributes
ModelName	String	False		No	ModelName
QuotableFlag	Bool	False		No	QuotableFlag
ReferenceNumber	String	False		No	ReferenceNumber
Finder	String	False		Yes	Input specifying the Finder type.
ContactId	String	False		Yes	The unique identifier of the Contact.
SysEffectiveDate	String	False		Yes	SysEffectiveDate.
ResourcePartyIdRest	String	False		Yes	The unique identifier of the Resource.
RestCreationDateLower	String	False		Yes	Finds the leads that are created before the date specified.
RestCreationDateUpper	String	False		Yes	Finds the leads with the specified creation date.
RestRecordSet	String	False		Yes	Finds the leads with the specified record set value.
RestStatusCode	String	False		Yes	Finds the leads with the specified status code.
Name	String	False		Yes	Finds the leads with the specified name.
LeadNumber	String	False		Yes	Finds the leads with the specified lead number.

Return to Top

SalesLeadsProducts

Name	Type	ReadOnly	References	FilterOnly	Description
InventoryItemId [KEY]	Long	False		No	InventoryItemId
InvOrgId [KEY]	Long	False		No	InvOrgId
LeadId [KEY]	String	False	SalesLeads.LeadId	No	LeadId
ActiveFlag	Bool	False		No	ActiveFlag
CSSEnabled	String	False		No	CSSEnabled
Description	String	False		No	Description
EndDate	Datetime	False		No	EndDate
LastUpdateDate	Datetime	False		No	LastUpdateDate
LongDescription	String	False		No	LongDescription
ProdGroupId	Long	False		No	ProdGroupId
ProductNum	String	False		No	ProductNum
ProductType	String	False		No	ProductType
ServiceRequestEnabledCode	String	False		No	ServiceRequestEnabledCode
StartDate	Datetime	False		No	StartDate
Text	String	False		No	Text
Finder	String	False		Yes	Input specifying the Finder type.
ContactId	String	False		Yes	The unique identifier of the Contact.
SysEffectiveDate	String	False		Yes	SysEffectiveDate.
ResourcePartyIdRest	String	False		Yes	The unique identifier of the Resource.
RestCreationDateLower	String	False		Yes	Finds the leads that are created before the date specified.
RestCreationDateUpper	String	False		Yes	Finds the leads with the specified creation date.
RestRecordSet	String	False		Yes	Finds the leads with the specified record set value.
RestStatusCode	String	False		Yes	Finds the leads with the specified status code.
Name	String	False		Yes	Finds the leads with the specified name.
LeadNumber	String	False		Yes	Finds the leads with the specified lead number.

Return to Top

SalesLeadTerritories

Name	Type	ReadOnly	References	FilterOnly	Description
LeadTerritoryId [KEY]	Long	False		No	LeadTerritoryId
LeadId [KEY]	String	False	SalesLeads.LeadId	No	LeadId
ConflictId	Long	False		No	ConflictId
CreatedBy	String	False		No	CreatedBy
CreationDate	Datetime	False		No	CreationDate
LastUpdateDate	Datetime	False		No	LastUpdateDate
LastUpdateLogin	String	False		No	LastUpdateLogin
LastUpdatedBy	String	False		No	LastUpdatedBy
Name	String	False		No	Name
OwnerPartyNumber	String	False		No	OwnerPartyNumber
PartnerPartyId	Long	False		No	PartnerPartyId
PartnerPartyName	String	False		No	PartnerPartyName
PartyId	Long	False		No	PartyId
PartyName	String	False		No	PartyName
TerritoryId	Long	False		No	TerritoryId
TerritoryNumber	String	False		No	TerritoryNumber
TerritoryVersionId	Long	False		No	TerritoryVersionId
TypeCode	String	False		No	TypeCode
Finder	String	False		Yes	Input specifying the Finder type.
ContactId	String	False		Yes	The unique identifier of the Contact.
SysEffectiveDate	String	False		Yes	SysEffectiveDate.
ResourcePartyIdRest	String	False		Yes	The unique identifier of the Resource.
RestCreationDateLower	String	False		Yes	Finds the leads that are created before the date specified.
RestCreationDateUpper	String	False		Yes	Finds the leads with the specified creation date.
RestRecordSet	String	False		Yes	Finds the leads with the specified record set value.
RestStatusCode	String	False		Yes	Finds the leads with the specified status code.
LeadNumber	String	False		Yes	Finds the leads with the specified lead number.

Return to Top

SalesOrders

Name	Type	ReadOnly	FilterOnly	Description
OrderHeaderId [KEY]	Long	False	No	Unique identifier for the quote or Order
ActiveVersionFlag	Bool	False	No	active version flag
CreatedBy	String	False	No
CreationDate	Datetime	False	No
CrmConversionRate	Double	False	No
CurrencyCode	String	False	No	Currency code
DeleteFlag	Bool	False	No	This flag controls if the user has access to delete the record
Description	String	False	No	Quote Description
ExpirationDate	Datetime	False	No	Expiration Date of the Quote or Order
ExternalQuoteNumber	String	False	No	Identifier from source system that created this Quote
ExternalReferenceNumber	String	False	No	Identifier for the External Quote/Order
ExternalSystemReferenceCode	String	False	No	External reference(Third party) type for the Quote or Order. Big machines will pass BMQUOTE
LastOptySyncDate	Datetime	False	No	Last Opportunity Sync date for the quote to identify the Active version of the quote for the opportunity.
LastUpdateDate	Datetime	False	No	last update date when record was updated
LastUpdateLogin	String	False	No
LastUpdatedBy	String	False	No
Name	String	False	No	Store the Quote/Order Name
OptyId	Long	False	No	Opportunity Id for the Quote is created
OptyNumber	String	False	No
OrderHeaderNumber	String	False	No
OrderTotal	Double	False	No	Total Amount
Owner	String	False	No	Quote Owner
PlacedOnDate	Datetime	False	No	Date on which Order was placed
ProposalExistFlag	Bool	False	No	Flag to identify the associated proposal for the Quote. Valid values are Y or N
ProposalUrl	String	False	No	URL to fetch quote proposal document
SalesAccountId	Long	False	No
SalesAccountUniqueName	String	False	No	Name of the customer account
SoldContactPartyId	Long	False	No	Customer Contact Party Identifier
SoldContactPartyNumber	String	False	No
SoldCustPartyNumber	String	False	No
SoldCustomerPartyId	Long	False	No	Customer Party Identifier
SoldPartySiteId	Long	False	No	Customer Address Identifier
Status	String	False	No	The exact quote status sent by BM
UpdateFlag	Bool	False	No	This flag controls if the user has access to update the record
VersionNumber	Long	False	No	Version Number of the Quote/Order
WinStatusCode	String	False	No	Lookup code for lookup type=ORA_ZCA_WIN_STATUS
Finder	String	False	Yes	Input specifying the Finder type.

Return to Top

ServiceDetails

Name	Type	ReadOnly	FilterOnly	Description
ServiceId [KEY]	Long	False	No
CreatedBy	String	False	No
CreationDate	Datetime	False	No
EstimatedStartTime	Datetime	False	No
LastAvailDate	Datetime	False	No
LastUpdateDate	Datetime	False	No
LastUpdateLogin	String	False	No
LastUpdatedBy	String	False	No
ProviderId	Long	False	No
ProviderName	String	False	No
ServiceName	String	False	No
ServiceStateCd	String	False	No
Finder	String	False	Yes	Input specifying the Finder type.

Return to Top

ServiceProviders

Name	Type	ReadOnly	FilterOnly	Description
ProviderId [KEY]	Long	False	No
CreatedBy	String	False	No
CreationDate	Datetime	False	No
ImposedEstimatedStartTime	Datetime	False	No
ImposedServiceStateCd	String	False	No
LastUpdateDate	Datetime	False	No
LastUpdateLogin	String	False	No
LastUpdatedBy	String	False	No
PassiveBeaconURL	String	False	No
ProviderAPPKey	String	False	No
ProviderName	String	False	No
Finder	String	False	Yes	Input specifying the Finder type.

Return to Top

Signatures

Name	Type	ReadOnly	FilterOnly	Description
SignatureId [KEY]	Long	True	No	The unique identifier of the signature.
ChannelId	Long	False	No	The unique identifier of the channel associated to a signature.
CreatedBy	String	True	No	The user who created the signature.
CreationDate	Datetime	True	No	The date when the signature record was created.
DefaultFlag	Bool	False	No	Indicates whether the signature is the default signature.
LastUpdateDate	Datetime	True	No	The date when the signature was last updated.
LastUpdateLogin	String	True	No	The login of the user who last updated the signature.
LastUpdatedBy	String	True	No	The user who last updated the signature.
SignatureContent	String	False	No	The content of the signature.
SignatureName	String	False	No	The name of the signature.
SignatureNumber	String	False	No	The alternate key identifier of the signature.
UserPartyId	Long	False	No	The unique party identifier of the user who associated to a signature.

Return to Top

Territories

Name	Type	ReadOnly	FilterOnly	Description
TerritoryVersionId [KEY]	Long	False	No	The unique identifier of the territory version.
CoverageModel	String	False	No	Indicates if the dimensions of the territory are based on account attributes or partner attributes.
DeleteFlag	Boolean	False	No	Indicates if the logged-in user can delete the territory.
Description	String	False	No	The description of the territory.
EffectiveEndDate	Date	False	No	The date and time when the territory version becomes active.
EffectiveStartDate	Date	False	No	The date and time when the territory version becomes active.
EligibleForQuotaFlag	Boolean	False	No	Indicates whether the territory is going to change during a territory realignment. If the value is True, then the territory is unlikely to change during a major realignment and therefore a quota can be entered against the proposed definition.
ForecastedByParentTerritoryFlag	Boolean	False	No	Indicates if the forecast for the territory is made by its parent territory.
ForecastParticipationCode	String	False	No	The code for the forecast participation. The accepted values are: REVENUE, NONREVENUE, REVENUE_AND_NONREVENUE, and NON_FORECASTING.
LatestVersionFlag	Boolean	False	No	Indicates the latest active version of the territory. If the value is True, then the territory version is the latest active version of the territory.
Name	String	False	No	The name of the territory.
OrganizationName	String	False	No	The name of the organization to which the owner belongs.
OwnerResourceId	Long	False	No	The unique identifier of the owner resource.
ParentTerritoryId	Long	False	No	The unique identifier of the parent territory.
PartnerId	Long	False	No	The unique identifier of the partner associated with the territory.
PartnerProgramId	Long	False	No	The unique identifier of the partner program to which the partner is enrolled.
ProgramName	String	False	No	The name of the partner program to which the partner is enrolled.
ReviseQuotaFlag	Boolean	False	No	Indicates whether a submitted quota needs to be revised.
RevisionDescription	String	False	No	The description of the reason for revising the quota.
RevisionReason	String	False	No	The user-defined reason for revising the quota.
SourceTerrId	Long	False	No	The identifier of the territory from which the dimensions are inherited.
SourceTerrLastUpdateDate	Datetime	False	No	The date and time when the source territory was last updated. This attribute is related to the inheritance of dimensions by recipient territories from source territories.
SourceTerrName	String	False	No	The name of the territory from which the selected dimensions are inherited.
SourceTerrVersionId	Long	False	No	The unique identifier of the source territory version.
StatusCode	String	False	No	The code for the territory status.
TerritoryId	Long	False	No	The unique identifier of the territory.
TerritoryLevel	Long	False	No	The level of the territory in the territory hierarchy.
TerritoryNumber	String	False	No	The unique alternate identification number for the territory.
TerrProposalId	Long	False	No	The unique identifier of the territory proposal.
TypeCode	String	False	No	The code for the territory type.
UpdateFlag	Boolean	False	No	Indicates if the logged-in user can update the territory.
UniqueTerritoryNumber	String	False	No	The unique territory number of the territory.
Finder	String	False	Yes	Input specifying the Finder type.

Return to Top

TerritoryForecasts

Name	Type	ReadOnly	FilterOnly	Description
ForecastParticipantId [KEY]	Long	False	No	The unique identifier of the territory forecast.
AdjustedBestCase	Double	False	No	The best case value of the forecast after adjustments.
AdjustedForecast	Double	False	No	The value of the territory forecast after adjustments.
AdjustedQuantity	Double	False	No	The value of the adjusted quantity.
AdjustedWorstCase	Double	False	No	The worst case value of the forecast after adjustments.
DueDate	Date	False	No	The due date for the forecast.
EndDate	Date	False	No	The end date for the forecast.
ForecastHeaderId	Long	False	No	The unique identifier of the forecast.
ForecastName	String	False	No	The name of the forecast.
ForecastParticipationCode	String	False	No	The participation code for the forecast. The accepted values are: Revenue and Non-Revenue, Revenue (for revenue forecasts), and Non-Revenue (for overlay forecasts).
ForecastType	String	False	No	The type of the forecast. The accepted values are: Revenue and Overlay.
Meaning	String	False	No	The status of the forecast. The accepted values are: Submitted, Unsubmitted, and Rejected.
OwnerResourceId	Long	False	No	The unique identifier of the party that owns the territory.
ParentTerritoryOwnerResourceId	Long	False	No	The resource identifier of the parent territory owner.
PseudoTerritoryFlag	Boolean	False	No	Indicates if the territory is a manager territory.
StartDate	Date	False	No	The start date for the forecast.
StatusCode	String	False	No	The status code of the forecast. The accepted values are: SUBMITTED, UNSUBMITTED, and REJECTED.
SubmittedBy	String	False	No	The name of the user who submitted the forecast.
SubmittedOn	Datetime	False	No	The submission date of the forecast.
TerritoryHierarchyFreezeDate	Date	False	No	The date on which the territory hierarchy is frozen. The forecast for a period is editable only after the territory hierarchy has been frozen for that forecasting period.
TerritoryId	Long	False	No	The unique identifier of the territory.
TerritoryLevel	Number	False	No	The level of the territory in the territory hierarchy.
TerritoryName	String	False	No	The name of the forecast territory.
TerritoryVersionId	Long	False	No	The unique identifier of the territory version.
UpdateFlag	Boolean	False	No	Indicates if the user has access to update the record.
Finder	String	False	Yes	Input specifying the Finder type.
TrStatus	String	False	Yes	The accepted values for TrStatus are ACTIVE, PAST, and FUTURE. The forecast records for the given user are filtered based on the specified territory forecast status value.

Return to Top

TerritoryResources

Name	Type	ReadOnly	References	FilterOnly	Description
TerrResourceId [KEY]	Long	False		No	Identifier of the resource.
TerritoryVersionId [KEY]	String	True	Territories.TerritoryVersionId	No	TerritoryVersionId
AdministratorFlag	Bool	False		No	Indicates that the resource is an administrator in the given territory.
CreatedBy	String	True		No	CreatedBy
CreationDate	Datetime	True		No	CreationDate
Email	String	True		No	Email
FunctionCode	String	False		No	Stores the function of the resource in the Territory.
LastUpdateDate	Datetime	True		No	LastUpdateDate
LastUpdateLogin	String	True		No	LastUpdateLogin
LastUpdatedBy	String	True		No	LastUpdatedBy
ManageForecastFlag	Bool	False		No	Indicates that a Territory Resource has been given the responsibility to manage the corresponding Territory Forecast on behalf of the owner of the Territory.
Manager	String	True		No	Name of the Manager.
OrganizationName	String	True		No	Name of the Organization.
OwnerFlag	Bool	True		No	OwnerFlag
ResourceId	Long	False		No	Identifier of the resource from resource manager ie. party model.
ResourceName	String	True		No	Name of the resource.
ResourceNumber	String	False		No	ResourceNumber
RoleName	String	True		No	Role associated to the resource.
UniqueTerritoryNumber	String	False		No	UniqueTerritoryNumber
Finder	String	False		Yes	Input specifying the Finder type.
TrStatus	String	False		Yes	The accepted values for TrStatus are ACTIVE, PAST, and FUTURE. The forecast records for the given user are filtered based on the specified territory forecast status value.

Return to Top