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.
Columns
| Name | Type | ReadOnly | References | Description |
| TeamMemberId [KEY] | Long | False |
This is the primary key of the sales account resources table. | |
| PartyNumber [KEY] | String | False |
Contacts.PartyNumber | |
| AccessLevelCode | String | False |
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 |
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 |
The user who created the sales team member record. | |
| CreationDate | Datetime | False |
The date and time when the sale team member record was created. | |
| EndDateActive | Date | False |
Date on which this sales team member is no longer active. | |
| LastUpdateDate | Datetime | False |
The date when the sales team member record was last updated. | |
| LastUpdatedBy | String | False |
The user who last updated the sales team member record. | |
| LastUpdateLogin | String | False |
The session login associated to the user who last updated the sales team member record. | |
| LockAssignmentFlag | Boolean | False |
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 |
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 |
The e-mail address of the resource. | |
| ResourceId | Long | False |
The unique party ID for the existing resource record in Oracle Sales. | |
| ResourceName | String | False |
The name of the sales team member. | |
| ResourceOrgName | String | False |
The name of the organization that the sales team member belongs to. | |
| ResourcePartyNumber | String | False |
The unique public identifier of the resource record. | |
| ResourcePhoneNumber | String | False |
The primary phone number of the sales team member. | |
| ResourceRoleName | String | False |
The roles assigned to the sales team member. | |
| SalesProfileId | Long | False |
The unique identifier of the sales profile of the resource. | |
| StartDateActive | Date | False |
Date on which this sales team member becomes active. | |
| UserLastUpdateDate | Datetime | False |
The date and time when the sales team member was last updated from mobile. | |
| ContactLastUpdateDate | Datetime | False |
The date and time when the opportunity was last updated. | |
| PartyId | Long | False |
The unique identifier of the party. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String |
Input specifying the Finder type. |
| BindUserPartyId | String |
The unique identifier of the contact. |
| PersonProfileId | String |
The unique identifier of the contact. |
| SourceSystem | String |
The name of external source system where the contact party is imported from. |
| SourceSystemReferenceValue | String |
The unique identifier for the contact party from the external source system. |