| 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
| |
| 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
| |
| 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). |
If this content did not answer your questions, try searching or contacting our support team for further assistance.
If this content did not answer your questions, try searching or contacting our support team for further assistance.