Marketplace Dasher Pick Reports
Payout Summary
Report Type - NV_PAYMENTS
Description
This report outputs a order-level details for all payouts that have been completed within the requested report time frame
Example Report
| Column Name | Data Type | Definition | Example |
|---|---|---|---|
| transaction_date_utc | string | Date in UTC timezone when charge has been sent in MM/DD/YYYY format | 02/28/2021 |
| transaction_date_local | string | Date in Mx store timezone when charge has been sent in MM/DD/YYYY format | 02/29/2021 |
| transaction_timestamp_utc | timestamp | Timepoint in UTC timezone when charge has been sent in YYYY-MM-DD HH24:MI:SS | 02/28/2021 |
| transaction_timestamp_local | timestamp | Timepoint in Mx store timezone when charge has been sent in YYYY-MM-DD HH24:MI:SS | 02/28/2021 |
| timezone | string | Mx Store timezone | US/Pacific |
| merchant_store_id | integer | The merchant's store identifier | 301 |
| store_name | string | Store name | The Market |
| business_name | string | Business name | Market USA |
| delivery_uuid | string | UUID of Doordash delivery | UUID-string |
| client_order_id | integer | client_id of order in POS database | 5486816 |
| external_id | string | (when relevant) Merchant (external) POS ID external_id of order in POS database | UUID-string |
| shopping_protocol | string | Shopping protocol as per MDS store table | shopperdasher merchant |
| dashpass | integer | Is this order with dash pass or not | 1|0 |
| is_consumer_pickup | integer | Is this order pickup or not (is_consumer_pickup) | 1|0 |
| order_received_time_local | timestamp | Timepoint with timezone of actual order place in Mx store timezone in YYYY-MM-DD HH24:MI:SS | 03/11/2021 |
| order_status | string | Order Status | delivered |
| transaction_type | ENUM | Type of transaction | DELIVERY|ADJUSTMENT |
| currency | string | Cart currency as per ISO 4217 | USD |
| order_subtotal_dollar | 0.00F | Subtotal in cart | 20.29 |
| order_tax_amount_dollar | 0.00F | Total tax paid by consumer | 3.19 |
| commission_rate | 0.00F | Commission rate | 0.05 |
| order_commission_dollar | 0.00F | DoorDash commission | 2.23 |
| commission_tax_dollar | 0.00F | commission tax | 0.01 |
| order_marketing_fee_dollar | 0.00F | Marketing commission | 0 |
| dashpass_marketing_fee_dollar | 0.00F | DashPass flat fee | 2 |
| tax_remitted_by_dd_dollar | 0.00F | States where DoorDash is the merchant of record, DoorDash remits tax directly to the government (does not pass it to the Mx) | 0.19 |
| order_merchant_tip_amount_dollar | 0.00F | Merchant tip amount for pickup orders (merchant_tip_amount) | 3.71 |
| store_charge_dollar | 0.00F | Amount charged to the merchant | -2.19 |
| store_refund_dollar | 0.00F | Amount refunded to the merchant | 1.1 |
| payout_amount_dollar | 0.00F | Amount paid out during the transfer | 25.19 |
| transaction_notes | string | Description regarding error charges and adjustments | Issue: 1 Advil Ibuprofen Coated Tablets 100 mg (24 ct) missing |
| payout_transfer_id | integer | Doordash Internal Id of bank transfer | 128950624 |
| payout_timestamp | timestamp | Timepoint with timezone when charge has been sent in ISO 8601 format with timezone | 03/11/2021 |
Transaction Details
Report Type - NV_TRANSACTIONS
Description
This report outputs transaction details which can be used for financial reconciliation of RedCard transactions.
Example Report
| Column Name | Data Type | Definition | Example | Since Report Version |
|---|---|---|---|---|
| transaction_date_utc | date | Date in UTC timezone when charge has been sent in MM/DD/YYYY format | 02/28/2021 | 1 |
| transaction_date_local | date | Date in Mx store timezone when charge has been sent in MM/DD/YYYY format | 02/29/2021 | 1 |
| transaction_timestamp_utc | timestamp | Timepoint in UTC timezone when charge has been sent in YYYY-MM-DD HH24:MI:SS | 2021-02-28 17:41:12 | 1 |
| transaction_timestamp_local | timestamp | Timepoint in store timezone when charge has been sent in YYYY-MM-DD HH24:MI:SS | 2021-02-28 12:41:12 | 1 |
| timezone | string | The timezone of the store | US/Pacific | 1 |
| amount_captured | 0.00F | Amount of in-store transactions in currency. This value does not include any markup. | 5.19 | 1 |
| currency | string | Currency as per ISO 4217 | USD | 1 |
| merchant_store_id | string | The merchant's store identifier | 301 | 1 |
| store_name | string | Store name | The Market | 1 |
| business_id | The ID of the business associated with the transaction. | 11003456 | 1 | |
| business_name | string | Business name | Markets USA | 1 |
| delivery_uuid | string | UUID of Doordash delivery | UUID-string | 1 |
| external_id | string | Merchant's external order identifier. This is only relevant if orders are integrated to Merchant's POS system. If a Mx is on Dasher Shop and Deliver, it will be null. This field may be null when the report is generated. | UUID-string | 1 |
| shopping_protocol | string | Shopping protocol protocol configured in DoorDash store setup. Identifies if the merchant is fulfilling orders or Dashers are picking. | shopper|dasher merchant | 1 |
| is_consumer_pickup | boolean | Is this order pickup or not (is_consumer_pickup) | TRUE|FALSE | 1 |
| approval_code | string | 5 or 6 digit numbers unique ID assigned to a given authorization. It is printed on the receipt at the point of sale. | 93795 | 1 |
| allowance_id | string | ID of allowance in allowance table of payment database. This value comes from Marqeta Payment Processor. | UUID-string | 1 |
| network_reference_id | string | Network-assigned unique identifier of the transaction. This value comes from Marqeta Payment Processor. | 1 | |
| acting_card_first_six | integer | DoorDash’s BIN, always the same (539186) but not exclusive to this number | 539186 | 1 |
| acting_card_last_four | integer | Last four digits of red card PAN from marqeta settlements | 9887 | 1 |
| marqeta_merchant_name | string | Merchant Name passed through payment network (from the merchant to their (acquiring) payment processor to DoorDash’s payment processor (marqeta) | MARKET #1234 | 1 |
| marqeta_store_id | string | Mechant StoreID extracted from Marqeta data | 1234 | 1 |
| is_settled | boolean | Whether marqeta transaction is settled or not | TRUE | 1 |
| order_marketing_fee_dollar | 1 | |||
| crc_barcode | CRC barcode | 1 | ||
| dashpass | boolean | Whether or not a subscription discount was applied to the transaction. | TRUE | 1 |
| store_refund_dollar | 0.00F | refund amount in dollar | 5.12 | 1 |
| store_charge_dollar | 0.00F | charge amount in dollar | 6.12 | 1 |
| client_order_id | string | UUID-string | 1 | |
| store_street_address | string | store street address | 123 South Avenue | 1 |
| is_scheduled_order | boolean | is order schedule for delivery | TRUE|FALSE | 1 |
| order_received_time_local | timestamp | Timepoint with timezone of actual order place in Merchant's store timezone in YYYY-MM-DD HH24:MI:SS | 2021-02-28 17:41:12 | 1 |
| order_scheduled_time_local | timestamp | timestamp when order was scheduled | 2021-01-22 17:44:47 | 1 |
| store_confirmed_time_local | timestamp | timestamp when store confirmed the order | 2021-01-22 17:44:47 | 1 |
| dasher_arrived_at_store_time_local | timestamp | timestamp when dasher arrived at the store to pick up the order | 2021-04-20 17:08:05 | 1 |
| pickup_time_local | timestamp | time at dasher started picking up the order | 2021-04-20 17:08:05 | 1 |
| payment_protocol | timestamp | protocol for payments like red card etc | 1 | |
| bag_fee | 0.00F | bag fee total in the order | 0.12 | 1 |
| bag_fee_tax_amount | 0.00F | bag feel total tax for the order | 0.01 | 1 |
| is_doubledash | boolean | if uuid is doubledash then true else false | TRUE | 1 |
| bottle_deposit_fee | integer | bottle deposit fee | 12 | 1 |
| receipt_barcode | string | barcode of receipt | xdda | 1 |
| submit_platform | string | Platform customer used (iOS, desktop, Android, mobile web) | android | 1 |
| hashed_consumer_id | string | hashed consumer ID | sdfasfa1341-asfax | 2 |
| total_snap_ebt_amount | 0.00F | Amount paid for the item using SNAP EBT card | 0 | 3 |
| total_return_snap_ebt_amount | 0.00F | Snap abt amount refunded when an order is returned | 0 | 3 |
| order_cart_id | integer | Cart ID from checkout. This is sent to Fiserv, and is needed by Mx to reconcile | 12345678899383738 | 3 |
| cup_fee_amount | 0.00F | Cup fee amount | 0 | 3 |
| cup_fee_tax_amount | 0.00F | Cup fee tax amount | 0 | 3 |
| bottle_deposit_fee_tax_amount | 0.00F | bottle deposit fee tax amount | 0 | 3 |
| state_province_tax_amount | 0.00F | State province tax amount | 0 | 3 |
Order Item
Report Type - NV_ORDER_ITEMS
Description
This report outputs item level details of orders, including picked, not found, and substituted items.
Example Report
| Column Name | Data Type | Definition | Example | Since Report Version |
|---|---|---|---|---|
| delivery_uuid | string | The universally unique identifier for a delivery. | 8be22d51-b630-4053-872f-9455fd8beba7 | 1 |
| delivery_created_at | timestamp | The date and time when the delivery was created. | 01/23/2023 | 1 |
| store_id | integer | The unique identifier for a store. | 984803 | 1 |
| store_name | string | Store name | The Market | 1 |
| merchant_store_id | string | The Merchant's store identifier | 10/27/1900 | 1 |
| business_id | integer | The unique identifier for a business. | 412816 | 1 |
| business_name | string | Business name | Markets USA | 1 |
| shopping_protocol | string | The protocol used for shopping (e.g. curbside pickup, delivery, etc.). | DASHER_PICK|MERCHANT_PICK | 1 |
| dasher_id | integer | The unique identifier for a Dasher (i.e. the person delivering the order). | 1307479 | 1 |
| item_id | integer | The unique identifier for an item. | 6778833695 | 1 |
| item_merchant_supplied_id | string | Id of the item supplied by merchant | 302898-0-1 | 1 |
| item_name | string | The name of the item. | Advil Ibuprofen Coated Tablets 200 mg (24 ct) | 1 |
| substitution_preference | string | The substitution preference for the item (e.g. allow substitutions, prefer exact item, do not substitute, etc.). | substitute | 1 |
| was_requested | integer | A boolean value indicating whether the item was requested (i.e. included in the original order). | 1|0 | 1 |
| was_found | integer | A boolean value indicating whether the item was found in the store. | 1|1 | 1 |
| was_missing | integer | A boolean value indicating whether the item was missing from the store. | 1|2 | 1 |
| was_subbed | integer | A boolean value indicating whether the item was substituted with another item. | 1|3 | 1 |
| was_refunded | integer | A boolean value indicating whether the item was refunded. | 1|4 | 1 |
| sub | integer | Flag indicating if item is substitute | 1|5 | 1 |
| requested_item_id | integer | The unique identifier for the requested item. | 7236397626 | 1 |
| requested_item_merchant_supplied_id | string | Originally requested merchants supplied item id in case of substitution | 19200780339 | 1 |
| requested_item_name | string | Originally requested item name in case of substitution | Advil Ibuprofen Coated Tablets 100 mg (24 ct) | 1 |
| picked_at | timestamp | Time when the time was picked by Cx | 01/23/2023 | 1 |
| not_found_at | timestamp | Time when the time was marked as not found by Cx | 01/23/2023 | 1 |
| shop_start_time | timestamp | Time when Dx started shopping for the delivery | 01/23/2023 | 1 |
| shop_end_time | timestamp | Time when Dx completed shopping for the delivery | 01/23/2023 | 1 |
| is_alcohol | boolean | Indicates whether the item is an alcohol product. | TRUE | 1 |
| quantity | integer | total quantity of items being delivered | 12 | 1 |
| weighted_quantity | 0.00F | the total weight of the items being delivered, with each item being weighed individually | 12/31/1899 | 1 |
| quantity_requested | integer | the quantity of items requested by the customer | 11 | 1 |
| upc_id | string | Unique ID | 07/08/3415 | 1 |
| measurement_unit | string | Weighed quantity of the item | each | 1 |
| is_weighted_item | integer | Whether the item is weighed | TRUE | 1 |
| item_price | integer | Unit price of the item in USD currency | 549 | 1 |
| item_price_dollar | 0.00F | Unit price of the item in US dollar | 01/03/1900 | 1 |
| total_item_price_dollar | 0.00F | Total price of the item in US dollar | 01/03/1900 | 1 |
| item_tax_amount_dollar | 0.00F | Total tax paid for the item in USD dollar | 12/31/1899 | 1 |
| is_delivered | boolean | Indicates whether the item was delivered or was removed from the cart due to Dasher inability to find the item or the item being out of stock. | TRUE | 1 |
| delivery_zip_code | string | zip code for delivery address | 02/09/2022 | 1 |
| substituted_for_item_merchant_supplied_id | string | item_merchant_supplied_id substituted | 12/16/48887 | 1 |
| delivery_created_date_utc | date | Date when delivery is created (UTC) | 01/23/2023 | 1 |
| delivery_created_timestamp_utc | timestamp | timestamp when delivery is created (UTC) | 01/23/2023 | 1 |
| store_transaction_date_utc | date | date when transaction is done at store (UTC) | 01/23/2023 | 1 |
| store_transaction_timestamp_utc | timestamp | timestamp when transaction is done at store (UTC) | 01/23/2023 | 1 |
| item_price_no_markup_dollar | 0.00F | item price without markup | 01/03/1900 | 1 |
| aisle_name_l1 | string | Aisle category 1 | Snacks | 1 |
| aisle_name_l2 | string | Aisle category 2 | Chips | 1 |
| brand | string | brand of item | Advil | 1 |
| total_item_price | integer | Total price of the item in USD currency | 2780 | 1 |
| tax_rate | integer | Tax rate of the item | 7 | 1 |
| tax_amount | integer | Total tax paid for the item in USD currency | 202 | 1 |
| category | string | Category of the item | Medicine | 1 |
| delivery_fraud_rule_ind | integer | Flag indicating when grand rule was fired for delivery | 0 | 1 |
| delivery_cr_category | string | Category of the item in case of when fraud rule is fired | no_cr_issued | 1 |
| sub_rating | integer | Date and time when rating was provided by Cx for substitution | 1 | 1 |
| sub_rating_timestamp | timestamp | Rating provided by Cx for substitution | 03/25/2023 | 1 |
| tags_selected | variant | Tags selected when the rating of the substitution is provided | [ "SUBS_RATING_TAG_OTHER" ] | 1 |
| comment | variant | Additional comment when the rating of the substitution is provided | standard substitution comment | 1 |
| item_uuid | string | UUID of the item | 9526bda5-d722-4904-b5b3-af072d771c40 | 1 |
| item_pick_start_time | timestamp | Item pick start time | 01/04/2022 | 1 |
| item_pick_end_time | timestamp | Item pick end time | 01/04/2022 | 1 |
| item_pick_duration_seconds | integer | Time in seconds taken by Dx for picking the item | 356 | 1 |
| cancelled_at | timestamp | Canceled date time of the canceled delivery (UTC) | 09/05/2021 | 1 |
| is_missing_incorrect | boolean | Flag indicating whether delivery is marked M&I by either Cx or support | FALSE | 1 |
| is_from_store_to_us | boolean | Flag indicating whether the delivery is drive | FALSE | 1 |
| is_cancelled | boolean | Flag indicating whether the delivery is canceled | FALSE | 1 |
| is_snap_eligible | boolean | Flag indicating whether the item is eligible to pay with SNAP EBT Card | FALSE | 1 |
| snap_ebt_amount | integer | Amount paid for the item using SNAP EBT card | 0 | 1 |
| credit_card_amount | integer | Amount paid for the item using credit card | 499 | 1 |
| etl_load_at | timestamp | ETL insert time | 04/17/2023 | 1 |
| item_price_local | integer | Unit price of the item in local currency dollar | 499 | 1 |
| total_item_price_local | integer | Total price of the item in local currency dollar | 499 | 1 |
| is_doubledash | boolean | if uuid is doubledash then true else false | TRUE | 1 |
| item_price_no_markup_total_dollar | 0.00F | price of item markup total in dollar | 4.99 | 1 |
| item_was_returned | boolean | Whether item was returned or not | TRUE | 2 |
| return_delivery_uuid | string | UUID of Doordash return delivery | 8be22d51-b630-4053-872f-9455fd8beba7 | 2 |
| return_timestamp_utc | timestamp | When was delivery return in utc timestamp | 2021-04-20 17:08:05 | 2 |
| return_timestamp_local | timestamp | When was delivery return in local timestamp | 2021-04-20 17:08:05 | 2 |
| delivery_was_returned | boolean | Whether all the items in the delivery were returned | FALSE | 2 |
| snap_return_amount | 0.00F | Snap abt amount refunded when an item is returned | 0 | 3 |
| unadj_item_tax_rate | 0.00F | This is the aggregate sales tax rate used to calculate that would have been used on this item. This value will not be affected by EBT SNAP amount applied. Actual sales tax paid by dollar amount will be populated in Sales Tax. | 1.6 | 3 |
| unadj_item_tax_amount_dollar | 0.00F | What the tax amount would have been if the item was paid for with non-EBT; Online Revenue multiplied by Original Sales Tax rate (includes mark-up). | 0.09 | 3 |
| order_cart_id | integer | Cart ID from checkout. This is sent to Fiserv, and is needed by Mx to reconcile | 12345678899383738 | 3 |
| item_price_local_dollar | 0.00F | Unit price of the item local in dollar | 10.01 | 4 |
| total_item_price_local_dollar | 0.00F | Total price of the item local in dollar | 20.02 | 4 |
| tax_amount_local | 0.00F | Total tax paid for the item local currency | 5.01 | 4 |
| item_tax_amount_local_dollar | 0.00F | Total tax paid for the item local currency in dollar | 10.02 | 4 |