ColumnTypeNotes
archivedBINARY
createdAtDATETIME
deal_idWHOLE NUMBERForeign Key from HubSpotDeals table
discountdecimal(18,
hs_cost_of_goods_solddecimal(18,
hs_recurring_billing_periodTEXT
hs_skuTEXT
idWHOLE NUMBERunique identifier
nameTEXT
pricedecimal(18,
quantityWHOLE NUMBER
recurringbillingfrequencyTEXT
tugger_product_idWHOLE NUMBER
updatedAtDATETIME
LastTugDateWHOLE NUMBERThe date the information was last pulled from HubSpot to Tugger in the format YYYYMMDD
DeletedBINARYFlag to indicate if the row has been deleted from HubSpot