Transaction discount feed layout definition
The following table represents the feed layout definition.
Required fields are marked as (Required) in the field description column; fields not marked as required are optional.
Business name | Field name | Description | Field data type/length |
---|---|---|---|
System of Record Name |
| Name of the system that is the authoritative data source for a record. |
|
Discount Code |
| (Required) Identifies a coupon, a promotion or ticket or document that can be redeemed for a financial discount or rebate when purchasing a product. |
|
Transaction Datetime |
| (Deprecated) Date time when transaction occurred. This will be populated based on the transaction datetime from the associated transaction record and data in this layout is not used ( |
|
Source Location Id |
| Uniquely identifies a Location in the source system where transaction took place (location can be a store or website). References Location ID in Location feed layout. |
|
Purchase Order Id |
| Either web order ID of the customer's order generated by eCommerce system or a combination of transaction ID, store ID, and other data that makes a purchase unique within POS system. |
|
Source Transaction Id |
| (Required) This field is a natural primary key. Either eComm Transaction ID generated by eCommerce system (may be order ID, or order ID + invoice, or a combination of POS transaction ID + store ID and other data that makes a purchase unique within POS system.) |
|
Pos Transaction Id |
| Transaction number generated by POS system. |
|
Register Number |
| ID of the register used for placing an order. |
|
Line Item Number |
| (Must be populated in item/detail records) This field is a natural primary key for detail record. Line item number identifies transaction's line number which corresponds to the actual line on the receipt where the item appears that the Discount was applied to. When discount applied at the item level vs. Header, this field must be populated. |
|
Discount Sequence |
| (Required) This field is a natural primary key. Line sequence number within a single order/ item. There can be multiple discounts applied per each transaction item. |
|
Discount Type Code |
| The type of discount applied for the item purchased, examples: student discount, coupon, markdown, any type of promotion, etc. |
|
Discount Percentage Off |
| The value of promotion or coupon (10% off of entire purchase or 20% off of the single item, etc.). |
|
Global Discount Item Amount |
| The amount of the discount applied in global currency. |
|
Local Discount Item Amount |
| The amount of the discount applied in local currency. |
|
Discount Level Code |
| Indicates if the discount is at entire purchase vs. item level. |
|
Source Record Create Datetime |
| The datetime when the record was created at source system ( |
|
Source Record Update Datetime |
| The datetime of the latest update of the record at source system ( |
|