Transaction feed structure
Field name | Importance | Data type | Referential integrity | Description |
---|---|---|---|---|
SourceTransactionNumber (key) | Required | String | TransactionItem:SourceTransactionNumber, Webtag:SourceTransactionNumber | The unique identifier of the transaction in your data. |
SourceOrganizationNumber | Required | String | Organization:SourceOrganizationNumber | The identifier of the organization where the transaction was placed. For example, San Francisco store or ecommerce website. |
Total | Optional | Float | The total revenue of this transaction. Customer Data Platform (CDP) uses the revenue at the TransactionItem level and does not leverage Transaction-level information to spread it across TransactionItems. | |
Currency | Optional | String | The currency for this transaction’s revenue, costs, discounts, and other monetary amounts. | |
Discount | Optional | Float | The total discount used by the customer for this transaction. Customer Data Platform uses the discount at the TransactionItem level and does not leverage Transaction-level information to spread it across TransactionItems. | |
Tax | Optional | Float | The total tax paid by the customer for this transaction. Customer Data Platform uses the tax at the TransactionItem level and does not leverage Transaction-level information to spread it across TransactionItems. | |
Type | Optional | String | The type of transaction, typically “Purchase”. | |
TransactionTimeStamp | Required | Datetime | The date the transaction was placed. | |
SourceCustomerNumber | Required | String | Customer:SourceCustomerNumber, TransactionItem:SourceCustomerNumber, Webtag:SourceCustomerNumber | The identifier of the customer billed for the transaction. |
DateCreated | Optional | Datetime | The date the record was created in the client’s system. | |
Custom attributes | Optional | Any (float, datetime, string, boolean) | The custom attributes that you want to use inside the CDP application. This customization is not self-service. You must engage with your CDP Customer Value Manager and it involves deployment effort. |
You can also find examples and use cases for this feed in Transaction Item feeds.