Information for: DEVELOPERS   PARTNERS   SUPPORT

Transaction Feed

Feed structure

Field Name Required ? 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 (e.g. San Francisco store, or ecommerce website).
Total Optional Float   The total revenue of this transaction. Note that Customer Data Platform (CDP) actually uses the revenue at the TransactionItem level instead, and does not leverage Transaction-level information to spread it across TransactionItems.
Currency Optional String   The currency for this Transaction’s revenue/costs/discounts/other monetary amounts.
Discount Optional Float   Total discount used by the customer for this transaction. Note that CDP actually uses the discount at the TransactionItem level instead, and does not leverage Transaction-level information to spread it across TransactionItems.
Tax Optional Float   Total tax paid by he customer for this transaction. Note that CDP actually uses the tax at the TransactionItem level instead, 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 at which 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   Date at which the record was created in the client’s system.
Custom attributes Optional Any (float, datetime, string, boolean)   Custom attributes that you want to use inside the CDP application. Note that this customization is not self-service, requires you to engage with your CDP CSM, and involves some deployment effort.

You can also find examples & use cases for this feed in this article : Standard Transaction & Transaction Item Feeds