Acquia CDP

Organization feed

Feed structure

Field name

Importance

Data type

Referential integrity

Description

SourceOrganizationNumber (key)

Required

String

Transaction:SourceOrganizationNumber, TransactionItem:SourceOrganizationNumber

The unique identifier of the organization in your data.

Name

Required

String

The name of the organization.

Status

Required

String

The status of the organization. The possible values are open and closed.

Type

Required

String

The type of organization. The default value is Other. The following are the values:

  • Digital

  • Physical

  • Warehouse

  • Other

SubType

Recommended

String

The subtype of your organization. For example, outlet stores or warehouse stores.

ParentSourceOrganizationNumber

Required (if available)

String

Organization: SourceOrganizationNumber

Identifier of the parent organization in your data. If populated, it references another row in the feed. If the organization has no parent, keep it empty.

Country

Required

String

The standard ISO Alpha-2 code for the country where the organization is located. For example, the code for the United States is US, Canada is CA, and France is FR. Two-character ISO Alpha-2 codes are required for distance-to-store and closest-store calculations. For more information, see list of supported countries.

State

Required

String

The state where the organization is located. This is required for distance-to-store calculations.

City

Required

String

The city where the organization is located. This is required for distance-to-store calculations.

Address1

Required

String

The address where the organization is located. This is required for distance-to-store calculations.

Address2

Required

String

The address where the organization is located. This is required for distance-to-store calculations.

Zip

Required

String

The zip or postal code of the organization’s location. This must contain the Zipcode and not the +4 code. This is required for distance-to-store calculations.

ExcludeAsClosestStore

Optional

Integer

This lists the stores that are excluded from distance-to-store ``calculations. The default value is ``0. The following are the values:

  • 0: Do not exclude the store

  • 1: Exclude the store

DateCreated

Optional

String

Date at which the record was created in the customer’s system.

Custom attributes

Optional

Any (float, datetime, string, boolean)

Custom attributes that you want to use inside the CDP application. To get this customization, contact your CDP customer value manager (CVM).