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.
Columns
| Name | Type | ReadOnly | References | Description |
| AddressNumber [KEY] | String | False |
This is the primary key of the primary addresses table. | |
| PartyNumber [KEY] | String | False |
Accounts.PartyNumber | |
| AddressElementAttribute1 | String | False |
An additional address element to support flexible address format. | |
| AddressElementAttribute2 | String | False |
An additional address element to support flexible address format. | |
| AddressElementAttribute3 | String | False |
An additional address element to support flexible address format. | |
| AddressElementAttribute4 | String | False |
An additional address element to support flexible address format. | |
| AddressElementAttribute5 | String | False |
An additional address element to support flexible address format. | |
| AddressId | Long | False |
The unique identifier of the primary address. | |
| AddressLine1 | String | False |
The first line of the primary address. | |
| AddressLine2 | String | False |
The second line of the primary address. | |
| AddressLine3 | String | False |
The third line of the primary address. | |
| AddressLine4 | String | False |
The fourth line of the primary address. | |
| AddressLinesPhonetic | String | False |
The phonetic or Kana representation of the Kanji address lines. This is used for addresses in Japan. | |
| Building | String | False |
The building name or number in the primary address. | |
| City | String | False |
The building name or number in the primary address. | |
| Comments | String | False |
The user-provided comments for the primary address. | |
| CorpCurrencyCode | String | False |
The corporate currency code used by the CRM Extensibility framework. | |
| Country | String | False |
The country code of the primary address. Review the list of country codes using the Manage Geographies task. | |
| County | String | False |
The county of the primary address. | |
| CreatedBy | String | False |
The user who created the primary address record. | |
| CreationDate | Datetime | False |
The date when the record was created. | |
| CurcyConvRateType | String | False |
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 |
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 |
The date when the primary address was last validated. | |
| DeleteFlag | Boolean | False |
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 |
The description of the location. | |
| FloorNumber | String | False |
The floor number of the primary address. | |
| FormattedAddress | String | False |
The formatted version of the primary address. | |
| FormattedMultiLineAddress | String | False |
The formatted multiline version of the primary address. | |
| HouseType | String | False |
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 |
The date when the record was last updated. | |
| LastUpdatedBy | String | False |
The user who last updated the record. | |
| LastUpdateLogin | String | False |
The login of the user who last updated the record. | |
| Latitude | Double | False |
The latitude information for the address. The latitude information for the location is used for spatial proximity and containment purposes. | |
| LocationDirections | String | False |
The directions to the address location. | |
| LocationId | Long | False |
The unique identifier for the location. | |
| Longitude | Double | False |
The longitude information for the address. The longitude information for the location is used for spatial proximity and containment purposes. | |
| Mailstop | String | False |
The user-defined code that indicates a mail drop point within the organization. | |
| PartyId | Long | False |
The unique identifier of the account associated with the address. | |
| PostalCode | String | False |
The postal code of the address. | |
| PostalPlus4Code | String | False |
The four-digit extension to the United States Postal ZIP code for the address. | |
| Province | String | False |
The province of the address. | |
| SourceSystem | String | False |
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 |
The unique identifier for the address from the external source system specified in the attribute PartySourceSystem. | |
| State | String | False |
The state of the address. | |
| ValidatedFlag | Boolean | False |
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 |
A standardized status code describing the results of the validation. The value is internally set by system during address cleansing. | |
| AccountLastUpdateDate | Datetime | False |
The date and time when the opportunity was last updated. |
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. |
| OrganizationProfileId | String |
The unique identifier of the organization. |