Please wait

Loading...

Acquia Help

Filter by product:

Acquia CDP common questions

Organization 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).

Did not find what you were looking for?

If this content did not answer your questions, try searching or contacting our support team for further assistance.