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.
Columns
| Name | Type | ReadOnly | References | Description |
| TeamMemberId [KEY] | Long | False |
The surrogate primary key for the member of the sales account resource team. | |
| PartyNumber [KEY] | String | False |
Accounts.PartyNumber | |
| AccessLevelCode | String | False |
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 |
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 |
The user who created the record. | |
| CreationDate | Datetime | False |
The date and time the record was created. | |
| EndDateActive | Date | False |
Indicates the date on which the association of resource is ended to the sales account. | |
| LastUpdatedBy | String | False |
The date on which the record is last updated. | |
| LastUpdateLogin | String | False |
The user who last updated the record. | |
| LockAssignmentFlag | Boolean | False |
The user login for the user who last updated the record. | |
| MemberFunctionCode | String | False |
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 |
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 |
Unique identifier for the resource | |
| 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 |
Unique identifier for the resource | |
| 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 identifier for the sales account. | |
| StartDateActive | Date | False |
Indicates the date on which the association of resource is created to the sales account. | |
| UserLastUpdateDate | Datetime | False |
The date and time of the last update from mobile. | |
| AccountLastUpdateDate | 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. |
| FocusPartyId | String |
The unique identifier of the child account to be returned at the top by the Direct Accounts finder. |
| ParentPartyId | String |
The unique identifier of the account used to search the direct child accounts. |
| BindUserPartyId | String |
The unique identifier of the party. Used in MyAccounts finder. |
| SourceSystem | String |
Name of external source system. |
| SourceSystemReferenceValue | String |
Identifier for this record from external source system. |
| OrganizationProfileId | String |
The unique identifier of the organization. |