AccountAddresses
The address resource is used to view, create, and update addresses of an account. An address represents the location information of an account.
Columns
| Name | Type | ReadOnly | References | Description |
| AddressNumber [KEY] | String | False |
This is the primary key of the addresses table. | |
| PartyNumber [KEY] | String | False |
Accounts.PartyNumber |
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 |
An additional address element to support flexible address format. | |
| AddrElementAttribute2 | String | False |
An additional address element to support flexible address format. | |
| AddrElementAttribute3 | String | False |
An additional address element to support flexible address format. | |
| AddrElementAttribute4 | String | False |
An additional address element to support flexible address format. | |
| AddrElementAttribute5 | String | False |
An additional address element to support flexible address format. | |
| Address1 | String | False |
The first line for address. | |
| Address2 | String | False |
The second line for address. | |
| Address3 | String | False |
The third line for address. | |
| Address4 | String | False |
The fourth line for address. | |
| AddressId | Long | False |
The unique identifier of the 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 address. | |
| City | String | False |
The city in the address. | |
| ClliCode | String | False |
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 |
The user-provided comments for the address. | |
| CorpCurrencyCode | String | False |
The corporate currency code used by the CRM Extensibility framework. | |
| Country | String | False |
The country code of the address. Review the list of country codes using the Manage Geographies task. | |
| CreatedBy | String | False |
The user who created the account record. | |
| CreatedByModule | String | False |
The module that created the account 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 address was last validated. | |
| Description | String | False |
The description of the location. | |
| DoNotMailFlag | Boolean | False |
Indicates whether the address should not be used for mailing. | |
| EffectiveDate | Date | False |
The date when the address becomes active. | |
| EndDateActive | Date | False |
The date after which the address becomes inactive. | |
| FloorNumber | String | False |
The floor number of the address. | |
| FormattedAddress | String | False |
The formatted version of the address. | |
| FormattedMultilineAddress | String | False |
The formatted multiline version of the 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. | |
| ObjectVersionNumber | Long | False |
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 |
The unique identifier of the account associated with the address. | |
| PartySourceSystem | String | False |
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 |
The unique identifier for the account, associated with the address, from the external source system specified in the attribute PartySourceSystem. | |
| 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. | |
| PrimaryFlag | Boolean | False |
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 |
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. | |
| StartDateActive | Date | False |
The date when the address becomes active. | |
| State | String | False |
The state of the address. | |
| Status | String | False |
The internal flag indicating status of the address. The status codes are defined by the lookup HZ_STATUS. | |
| 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. | |
| ValidationStartDate | Date | False |
The date when the validation becomes active. The value is internally set by system during address cleansing. | |
| 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. |