TDV Adapter for Oracle Sales

Build 22.0.8462

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

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462