Transaction discount feed layout sample

System of Record Name

sor_name

Name of the system that is the authoritative data source for a record. 

char(100)

ERP

Discount Code

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.

char(100)

HAPPY2025

Transaction Datetime

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 (YYYY-MM-DD HH:mm:ss). 

datetime

2025-01-10 09:10:00

Source Location Id 

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.

char(100)

17

Purchase Order Id

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.

char(200)

Source Transaction Id

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.)

char(200)

S12345

Pos Transaction Id

pos_transaction_id

Transaction number generated by POS system.

char(200)

P12345

Register Number

register_num

ID of the register used for placing an order.

bigint

Line Item Number

line_item_num

(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.

integer

1

Discount Sequence

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. 

integer

1

Discount Type Code

discount_type_code

The type of discount applied for the item purchased, examples: student discount, coupon, markdown, any type of promotion, etc. 

char(100)

Discount Percentage Off

discount_pct

The value of promotion or coupon (10% off of entire purchase or 20% off of the single item, etc.).

char(100)

Global Discount Item Amount

global_discount_item_amount

The amount of the discount applied in global currency.

numeric(20,6)

0.1

Local Discount Item Amount

local_discount_item_amount

The amount of the discount applied in local currency.

numeric(20,6)

0.1

Discount Level Code

discount_level_code

Indicates if the discount is at entire purchase vs. item level. 

char(100)

Source Record Create Datetime

source_rec_create_datetime

The datetime when the record was created at source system (YYYY-MM-DD HH:mm:ss).

datetime

Source Record Update Datetime

source_rec_update_datetime

The datetime of the latest update of the record at source system (YYYY-MM-DD HH:mm:ss).

datetime