ODBC Driver for Oracle Sales

Build 21.0.7930

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 Datetime 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 Datetime False

The date when the address becomes active.

EndDateActive Datetime 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 Long 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 Long 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 Integer 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 Datetime 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 Datetime 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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930