Application Launcher

Attribute Name	Data Type	Description
ID	string	The unique identifier of the transaction record in CDP.
TenantID	int	The unique identifier of the client environment in CDP.
SourceSystemID	string	The unique identifier of the upstream source system in CDP.
MasterCustomerID	string	The unique identifier of the de-duplicated master customer in CDP. MasterCustomerIDs can change daily.
MasterCustomerID2	string	The unique identifier of the de-duplicated master customer in CDP. MasterCustomerIDs can change daily.
HouseholdID	string	The unique identifier of the household the transaction is associated with.
MasterCustomerTransactionSequence	int	The sequence of the transactions for each customer after sorting their transactions by Transaction Date in the ascending order. The following are the values: 1 denotes the first transaction of a customer. 2 denotes the second transaction of a customer. These values are calculated at the transaction header-level. If a customer places more than one transaction on the same day, each of those transactions has a different sequence number depending on the timestamp of the transaction and the unique identifier of the transaction.
MasterCustomerDaySinceFirstTransaction	int	The number of days between a given transaction and the customer’s first transaction. This field is calculated at the transaction level, and it does not indicate the customer tenure.
HouseholdTransactionSequence	int	The sequence of the transactions for each household after sorting their transactions by Transaction Date in the ascending order. The following are the values: 1 denotes the first transaction of a household. 2 denotes the second transaction of a household. These values are calculated at the transaction header-level. If a household places more than one transaction on the same day, each of those transactions has a different sequence number depending on the timestamp of the transaction and the unique identifier of the transaction.
HouseholdDaySinceFirstTransaction	int	The number of days between a given transaction and the household’s first transaction. This field is calculated at the transaction level, and it does not indicate the household tenure.
TransactionTimeStampFK	int	It is the YYYYMMDD format of the TransactionTimeStamp.
SourceTransactionItemNumber	string	The unique identifier of the transaction item in your data. If the item has multiple rows, the value for this attribute must be unique for each row. A conventional way to achieve this is to append the status of the item to its identifier.
TransactionID	string	The unique identifier of the transaction in your data.
SourceTransactionNumber	string	The unique identifier of the transaction in your data.
OrganizationID	string	The identifier of the organization where the transaction was placed.
SourceOrganizationNumber	string	The identifier of the organization where the transaction was placed.
SourceProductNumber	string	The unique identifier of the product that was purchased, shipped, or returned.
ProductID	string	The unique identifier of the product that was purchased, shipped, or returned.
Type	string	The type of transaction line. The default value is Purchase. If you have custom transaction line types, contact your CDP AM or CVM.
Subtype	string	The subtype of the transaction line. The possible values are: Demand, Canceled, Shipped, Returned.
ShipDate	timestamp	The date at which the specific transaction item was: Billed (SubType=Demand) Canceled (SubType=Canceled) Shipped (SubType=Shipped) Returned (SubType=Returned)
InvoiceDate	timestamp	The date of the transaction at the line-level.
Quantity	int	The quantity for the product that was purchased in this transaction item.
ListPrice	decimal	The Manufacturer’s Suggested Retail Price (MSRP) of the transaction line.
SaleRevenue	decimal	The sale revenue of the transaction line.
Discount	decimal	The discount applied to the transaction line.
CostBasis	decimal	The cost of goods sold on the transaction line.
Tax	decimal	The tax applied to the transaction line.
ShippingRevenue	decimal	The shipping revenue of the transaction line.
ShippingCost	decimal	The cost of shipping of the transaction line.
ShippingDiscount	decimal	The shipping discount of the transaction line.
OtherRevenue	decimal	Any other non-product, non-shipping, non-tax revenue generated by this item.
OtherCost	decimal	Any other non-product, non-shipping cost generated by this item.
Currency	string	The currency of the transaction line. For example, USD, CAD, EUR.
UserClient	string	NA
BundleNumber	string	NA
SourceSubscriptionNumber	string	NA
SubscriptionID	string	The unique identifier of the subscription.
Gift	boolean	This flag indicates if a product is a gift. This is not used in CDP’s calculations, and is simply provided as a standard pass-through attribute.
DateCreated	timestamp	The date at which the record was created in your system.
DateModified	timestamp	The date at which the record was modified in your system.
SourceCustomerNumber	string	The identifier of the customer billed for the transaction.
CustomerID	string	The identifier of the customer billed for the transaction.
SourceAccountNumber	string	The source account number.
AccountID	string	The unique identifier of the account.
TransactionDate	timestamp	The date of transaction at header-level.
SourceEmployeeNumber	string	The source employee number, which is a unique identifier of the employee on the tenant side.
EmployeeID	string	This is the unique identifier of the employee.
TransactionLastMarketingTouchID	string	This is the last of all online marketing touches responsible for transactions. This data typically comes from web analytics providers, such as Google Analytics, Adobe Analytics, or IBM Coremetrics. The data is represented with the following levels, Source, Medium, Campaign, Adgroup, and Keyword.
RowCreated	timestamp	The time when the transaction record was created.
RowModified	timestamp	The time when the transaction record was last modified.
Batch	string	When the transaction record was last modified in CDP. This is used for bucketing the ingestion of records into CDP.
DeviceType	string	The type of device used to trigger the transaction. This is applicable for web events. This is automatically populated when you use the CDP JS SDK on your website. However, you must populate the value when using the Tracker API. The supported values are: COMPUTER: Used for laptops and desktops. MOBILE: Used for mobile phones. TABLET: Used for tablets. GAME_CONSOLE: Used for game consoles. DMR: Used for digital media receivers. WEARABLE: Used for wearable devices. UNKNOWN: Used for the rest.
TransactionTimeStamp	timestamp	The date of transaction at header-level.
ShipDateFK	int	It is the YYYYMMDD format of the ShipDate.
InvoiceDateFK	int	It is the YYYYMMDD format of the InvoiceDate.
TransactionLastOfflineMarketingTouchID	string	This is the last of all offline marketing touches responsible for the transaction. This data is typically calculated from direct, postal mail send events.
TransactionLastOfflineMarketingTouchIDHousehold	string	This is the last of all offline marketing touches responsible for the transaction. This data is typically calculated from direct, postal mail send events.

Attribute Name	Data Type	Description
ID	string	The unique identifier of the transaction record in CDP.
TenantID	int	The unique identifier of the client environment in CDP.
SourceSystemID	string	The unique identifier of the upstream source system in CDP.
MasterCustomerID	string	The unique identifier of the de-duplicated master customer in CDP. MasterCustomerIDs can change daily.
MasterCustomerID2	string	The unique identifier of the de-duplicated master customer in CDP. MasterCustomerIDs can change daily.
HouseholdID	string	The unique identifier of the household the transaction is associated with.
MasterCustomerTransactionSequence	int	The sequence of the transactions for each customer after sorting their transactions by Transaction Date in the ascending order. The following are the values: 1 denotes the first transaction of a customer. 2 denotes the second transaction of a customer. These values are calculated at the transaction header-level. If a customer places more than one transaction on the same day, each of those transactions has a different sequence number depending on the timestamp of the transaction and the unique identifier of the transaction.
MasterCustomerDaySinceFirstTransaction	int	The number of days between a given transaction and the customer’s first transaction. This field is calculated at the transaction level, and it does not indicate the customer tenure.
HouseholdTransactionSequence	int	The sequence of the transactions for each household after sorting their transactions by Transaction Date in the ascending order. The following are the values: 1 denotes the first transaction of a household. 2 denotes the second transaction of a household. These values are calculated at the transaction header-level. If a household places more than one transaction on the same day, each of those transactions has a different sequence number depending on the timestamp of the transaction and the unique identifier of the transaction.
HouseholdDaySinceFirstTransaction	int	The number of days between a given transaction and the household’s first transaction. This field is calculated at the transaction level, and it does not indicate the household tenure.
TransactionTimeStampFK	int	It is the YYYYMMDD format of the TransactionTimeStamp.
SourceTransactionItemNumber	string	The unique identifier of the transaction item in your data. If the item has multiple rows, the value for this attribute must be unique for each row. A conventional way to achieve this is to append the status of the item to its identifier.
TransactionID	string	The unique identifier of the transaction in your data.
SourceTransactionNumber	string	The unique identifier of the transaction in your data.
OrganizationID	string	The identifier of the organization where the transaction was placed.
SourceOrganizationNumber	string	The identifier of the organization where the transaction was placed.
SourceProductNumber	string	The unique identifier of the product that was purchased, shipped, or returned.
ProductID	string	The unique identifier of the product that was purchased, shipped, or returned.
Type	string	The type of transaction line. The default value is Purchase. If you have custom transaction line types, contact your CDP AM or CVM.
Subtype	string	The subtype of the transaction line. The possible values are: Demand, Canceled, Shipped, Returned.
ShipDate	timestamp	The date at which the specific transaction item was: Billed (SubType=Demand) Canceled (SubType=Canceled) Shipped (SubType=Shipped) Returned (SubType=Returned)
InvoiceDate	timestamp	The date of the transaction at the line-level.
Quantity	int	The quantity for the product that was purchased in this transaction item.
ListPrice	decimal	The Manufacturer’s Suggested Retail Price (MSRP) of the transaction line.
SaleRevenue	decimal	The sale revenue of the transaction line.
Discount	decimal	The discount applied to the transaction line.
CostBasis	decimal	The cost of goods sold on the transaction line.
Tax	decimal	The tax applied to the transaction line.
ShippingRevenue	decimal	The shipping revenue of the transaction line.
ShippingCost	decimal	The cost of shipping of the transaction line.
ShippingDiscount	decimal	The shipping discount of the transaction line.
OtherRevenue	decimal	Any other non-product, non-shipping, non-tax revenue generated by this item.
OtherCost	decimal	Any other non-product, non-shipping cost generated by this item.
Currency	string	The currency of the transaction line. For example, USD, CAD, EUR.
UserClient	string	NA
BundleNumber	string	NA
SourceSubscriptionNumber	string	NA
SubscriptionID	string	The unique identifier of the subscription.
Gift	boolean	This flag indicates if a product is a gift. This is not used in CDP’s calculations, and is simply provided as a standard pass-through attribute.
DateCreated	timestamp	The date at which the record was created in your system.
DateModified	timestamp	The date at which the record was modified in your system.
SourceCustomerNumber	string	The identifier of the customer billed for the transaction.
CustomerID	string	The identifier of the customer billed for the transaction.
SourceAccountNumber	string	The source account number.
AccountID	string	The unique identifier of the account.
TransactionDate	timestamp	The date of transaction at header-level.
SourceEmployeeNumber	string	The source employee number, which is a unique identifier of the employee on the tenant side.
EmployeeID	string	This is the unique identifier of the employee.
TransactionLastMarketingTouchID	string	This is the last of all online marketing touches responsible for transactions. This data typically comes from web analytics providers, such as Google Analytics, Adobe Analytics, or IBM Coremetrics. The data is represented with the following levels, Source, Medium, Campaign, Adgroup, and Keyword.
RowCreated	timestamp	The time when the transaction record was created.
RowModified	timestamp	The time when the transaction record was last modified.
Batch	string	When the transaction record was last modified in CDP. This is used for bucketing the ingestion of records into CDP.
DeviceType	string	The type of device used to trigger the transaction. This is applicable for web events. This is automatically populated when you use the CDP JS SDK on your website. However, you must populate the value when using the Tracker API. The supported values are: COMPUTER: Used for laptops and desktops. MOBILE: Used for mobile phones. TABLET: Used for tablets. GAME_CONSOLE: Used for game consoles. DMR: Used for digital media receivers. WEARABLE: Used for wearable devices. UNKNOWN: Used for the rest.
TransactionTimeStamp	timestamp	The date of transaction at header-level.
ShipDateFK	int	It is the YYYYMMDD format of the ShipDate.
InvoiceDateFK	int	It is the YYYYMMDD format of the InvoiceDate.
TransactionLastOfflineMarketingTouchID	string	This is the last of all offline marketing touches responsible for the transaction. This data is typically calculated from direct, postal mail send events.
TransactionLastOfflineMarketingTouchIDHousehold	string	This is the last of all offline marketing touches responsible for the transaction. This data is typically calculated from direct, postal mail send events.

Attribute Name	Data Type	Description
ID	string	The unique identifier of the transaction record in CDP.
TenantID	int	The unique identifier of the client environment in CDP.
SourceSystemID	string	The unique identifier of the upstream source system in CDP.
MasterCustomerID	string	The unique identifier of the de-duplicated master customer in CDP. MasterCustomerIDs can change daily.
MasterCustomerID2	string	The unique identifier of the de-duplicated master customer in CDP. MasterCustomerIDs can change daily.
HouseholdID	string	The unique identifier of the household the transaction is associated with.
MasterCustomerTransactionSequence	int	The sequence of the transactions for each customer after sorting their transactions by Transaction Date in the ascending order. The following are the values: 1 denotes the first transaction of a customer. 2 denotes the second transaction of a customer. These values are calculated at the transaction header-level. If a customer places more than one transaction on the same day, each of those transactions has a different sequence number depending on the timestamp of the transaction and the unique identifier of the transaction.
MasterCustomerDaySinceFirstTransaction	int	The number of days between a given transaction and the customer’s first transaction. This field is calculated at the transaction level, and it does not indicate the customer tenure.
HouseholdTransactionSequence	int	The sequence of the transactions for each household after sorting their transactions by Transaction Date in the ascending order. The following are the values: 1 denotes the first transaction of a household. 2 denotes the second transaction of a household. These values are calculated at the transaction header-level. If a household places more than one transaction on the same day, each of those transactions has a different sequence number depending on the timestamp of the transaction and the unique identifier of the transaction.
HouseholdDaySinceFirstTransaction	int	The number of days between a given transaction and the household’s first transaction. This field is calculated at the transaction level, and it does not indicate the household tenure.
TransactionTimeStampFK	int	It is the YYYYMMDD format of the TransactionTimeStamp.
SourceTransactionItemNumber	string	The unique identifier of the transaction item in your data. If the item has multiple rows, the value for this attribute must be unique for each row. A conventional way to achieve this is to append the status of the item to its identifier.
TransactionID	string	The unique identifier of the transaction in your data.
SourceTransactionNumber	string	The unique identifier of the transaction in your data.
OrganizationID	string	The identifier of the organization where the transaction was placed.
SourceOrganizationNumber	string	The identifier of the organization where the transaction was placed.
SourceProductNumber	string	The unique identifier of the product that was purchased, shipped, or returned.
ProductID	string	The unique identifier of the product that was purchased, shipped, or returned.
Type	string	The type of transaction line. The default value is Purchase. If you have custom transaction line types, contact your CDP AM or CVM.
Subtype	string	The subtype of the transaction line. The possible values are: Demand, Canceled, Shipped, Returned.
ShipDate	timestamp	The date at which the specific transaction item was: Billed (SubType=Demand) Canceled (SubType=Canceled) Shipped (SubType=Shipped) Returned (SubType=Returned)
InvoiceDate	timestamp	The date of the transaction at the line-level.
Quantity	int	The quantity for the product that was purchased in this transaction item.
ListPrice	decimal	The Manufacturer’s Suggested Retail Price (MSRP) of the transaction line.
SaleRevenue	decimal	The sale revenue of the transaction line.
Discount	decimal	The discount applied to the transaction line.
CostBasis	decimal	The cost of goods sold on the transaction line.
Tax	decimal	The tax applied to the transaction line.
ShippingRevenue	decimal	The shipping revenue of the transaction line.
ShippingCost	decimal	The cost of shipping of the transaction line.
ShippingDiscount	decimal	The shipping discount of the transaction line.
OtherRevenue	decimal	Any other non-product, non-shipping, non-tax revenue generated by this item.
OtherCost	decimal	Any other non-product, non-shipping cost generated by this item.
Currency	string	The currency of the transaction line. For example, USD, CAD, EUR.
UserClient	string	NA
BundleNumber	string	NA
SourceSubscriptionNumber	string	NA
SubscriptionID	string	The unique identifier of the subscription.
Gift	boolean	This flag indicates if a product is a gift. This is not used in CDP’s calculations, and is simply provided as a standard pass-through attribute.
DateCreated	timestamp	The date at which the record was created in your system.
DateModified	timestamp	The date at which the record was modified in your system.
SourceCustomerNumber	string	The identifier of the customer billed for the transaction.
CustomerID	string	The identifier of the customer billed for the transaction.
SourceAccountNumber	string	The source account number.
AccountID	string	The unique identifier of the account.
TransactionDate	timestamp	The date of transaction at header-level.
SourceEmployeeNumber	string	The source employee number, which is a unique identifier of the employee on the tenant side.
EmployeeID	string	This is the unique identifier of the employee.
TransactionLastMarketingTouchID	string	This is the last of all online marketing touches responsible for transactions. This data typically comes from web analytics providers, such as Google Analytics, Adobe Analytics, or IBM Coremetrics. The data is represented with the following levels, Source, Medium, Campaign, Adgroup, and Keyword.
RowCreated	timestamp	The time when the transaction record was created.
RowModified	timestamp	The time when the transaction record was last modified.
Batch	string	When the transaction record was last modified in CDP. This is used for bucketing the ingestion of records into CDP.
DeviceType	string	The type of device used to trigger the transaction. This is applicable for web events. This is automatically populated when you use the CDP JS SDK on your website. However, you must populate the value when using the Tracker API. The supported values are: COMPUTER: Used for laptops and desktops. MOBILE: Used for mobile phones. TABLET: Used for tablets. GAME_CONSOLE: Used for game consoles. DMR: Used for digital media receivers. WEARABLE: Used for wearable devices. UNKNOWN: Used for the rest.
TransactionTimeStamp	timestamp	The date of transaction at header-level.
ShipDateFK	int	It is the YYYYMMDD format of the ShipDate.
InvoiceDateFK	int	It is the YYYYMMDD format of the InvoiceDate.
TransactionLastOfflineMarketingTouchID	string	This is the last of all offline marketing touches responsible for the transaction. This data is typically calculated from direct, postal mail send events.
TransactionLastOfflineMarketingTouchIDHousehold	string	This is the last of all offline marketing touches responsible for the transaction. This data is typically calculated from direct, postal mail send events.

Did not find what you were looking for?

Did not find what you were looking for?

transactionsummary

transactionsummary

transactionsummary

Did not find what you were looking for?

Did not find what you were looking for?