Skip to main content
Below is a description of two different exports. One is the export of the receipt header and the other export contains the line-items of each receipt. The receiptId is the main key-reference here in order to connect the two tables.

Receipt

FieldDescriptionData typeExample value
receiptIdReceipt ID (Generated by Engage)GUIDBA270CBB-EAEA-4237-AA4A-A53100909FA2
contactIdUnique contact IDGUID5307c938-55fc-4fd8-9512-aab500977e67
storeIdInternal unique store ID where the purchase was made. (Generated by Engage)GUIDHJ270CBB-EAEA-4237-AA4A-743100909FA2
storeExternalIdThe store ID generated by the clientstring1001
receiptNumberThe invoice numberstring3247265354287
totalGrossPriceThe total purchase amountdecimal500.00
totalQuantityThe total quantity of all itemsint4
totalReturnedThe number of returned items in one receiptint2
totalLocalPriceThe total purchase amount in local currencydecimal50.00
exchangeRateThe currency exchange ratedecimal10.00
localCurrencyThe currency codestringEUR
numberOfItemsThe number of items in the receiptint4
numberOfPurchasesThe number of items of type PURCHASEint2
numberOfReturnsThe number of items of type RETURNint2
changeTypeWhether the row was created, updated or deleted.stringCREATE/UPDATE/DELETE

ReceiptItem

FieldDescriptionData typeExample value
receiptItemIdItem ID (Generated by Engage)GUIDJU270CBB-K9EA-4237-A6TA-B90300909FA2
receiptIdReceipt ID (Generated by Engage)GUIDBA270CBB-EAEA-4237-AA4A-A53100909FA2
contactIdUnique contact IDGUID5307c938-55fc-4fd8-9512-aab500977e67
storeIdUnique store ID (Generated by Engage)GUIDHJ270CBB-EAEA-4237-AA4A-743100909FA2
transactionDateTimeWhen the purchase was madedatetime2020-06-30T10:34:00+01:00
typePURCHASE or RETURNstringPURCHASE
skuStore keeping unitstring12314-5
articleNumberThe article numberstring12314
quantityQuantityint2
grossPaidPriceSummed price of all unitsdecimal100.00
grossPaidPricePerUnitPrice per unitdecimal50.00
localPricePrice in local currencydecimal10.00
localCurrencyCurrency codestringEUR
discountsTotal amount of discount on line itemdecimal10.00
discountPercentDiscount percentagedecimal10.00
marginPercentThe margin percentage of sold item.decimal50.00
taxPercentVAT percentage for itemdecimal25.00
articleNameName of the articlestringVoyado cap
articleGroupHighest level of categorizingstringHats
articleSpare1-10Up to 10 extra fieldsstringSize medium
articleDateSpare1-5Up to 5 extra datetime fieldsdatetime2020-01-02T03:04:05+01:00
awardsBonusIf item is valid for bonusbooleantrue
changeTypeWhether the row was created, updated or deletedstringCREATE/UPDATE/DELETE