# Vendor Direct Fulfillment Orders

- BigQuery table name: `amazon_vendor_df_orders`
- Available in: Vendor Central
- Data scheme index: https://api.datadoe.com/api/v1/spec/data-scheme.md

Vendor Direct Fulfillment order line items (vendor ships to the customer). One row per line item with order header fields repeated. purchase_order_number is the DF purchase order; customer_order_number is the shopper order.

- Source type: `VENDOR_CENTRAL`
- Source ID: `42ec2de94b0a2f37d37649cef2ce1c458d348cac50c76c1e1dc7011deba88c9e`
- Requires a date period: yes
- Contains PII: no
- Premium table: no
- User-managed: no
- Default dataset: no
- Rows count towards billing: yes
- Hub: https://www.datadoe.com/hub/data-scheme?source=VENDOR_CENTRAL&table=42ec2de94b0a2f37d37649cef2ce1c458d348cac50c76c1e1dc7011deba88c9e

## Fetch periods

- `INITIAL` (30 days)
- `CONTINUOUS`

## Data availability

- `REAL_TIME` — Orders are available up to 1 hour after being placed. Refresh: 10am, 1pm, 4pm, 7pm.

## Search aliases

- direct fulfillment
- df orders

## Columns (38)

- `marketplace_id` (`TEXT`, required) — Amazon provided ID that represents a specific country where the Seller or Vendor operates.
- `marketplace_country_code` (`TEXT`, required) — ISO country code for the Amazon marketplace.
- `marketplace_country_name` (`TEXT`, required) — Human-readable country name for the marketplace (derived from marketplace_id).
- `seller_or_vendor_id` (`TEXT`, required) — DataDoe account identifier used by MCP/API calls (sellers_and_vendors_list, exports). Not unique in amazon_sellers_and_vendors_context when one account has multiple connection contexts — join that table on connection_context_id instead.
- `seller_or_vendor_name` (`TEXT`, required) — DataDoe connection context display name for the seller or vendor.
- `marketplace_seller_id` (`TEXT`, nullable) — Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID.
- `date` (`DATE`, nullable) — Calendar day of the Direct Fulfillment order date (orderDate).
- `purchase_order_number` (`TEXT`, required) — Amazon Direct Fulfillment purchase order number.
- `item_sequence_number` (`TEXT`, required) — Line number within the purchase order. Grain key with purchase_order_number.
- `customer_order_number` (`TEXT`, nullable) — Shopper's Amazon order id. Not purchase_order_number.
- `order_status` (`TEXT`, nullable) — Amazon orderStatus: NEW, SHIPPED, ACCEPTED, or CANCELLED.
- `ship_method` (`TEXT`, nullable) — Ship method name Amazon assigned for this order.
- `is_priority_shipment` (`LOGIC`, nullable) — Amazon flagged this order as a priority shipment.
- `is_scheduled_delivery_shipment` (`LOGIC`, nullable) — Amazon flagged this order as a scheduled-delivery shipment.
- `is_pslip_required` (`LOGIC`, nullable) — A packing slip must ship with the order.
- `is_gift` (`LOGIC`, nullable) — The order contains a gift.
- `has_customizable_items` (`LOGIC`, nullable) — The order contains customizable items.
- `required_ship_date` (`DATE`, nullable) — Latest time the vendor must ship the order.
- `promised_delivery_date` (`DATE`, nullable) — Delivery time Amazon promised the customer.
- `selling_party_id` (`TEXT`, nullable) — Vendor party id Amazon assigned on the order.
- `ship_from_party_id` (`TEXT`, nullable) — Warehouse party id the vendor ships from.
- `bill_to_party_id` (`TEXT`, nullable) — Amazon bill-to party id.
- `order_tax_total_amount` (`NUMBER`, nullable)
- `order_tax_total_currency` (`TEXT`, nullable)
- `asin` (`TEXT`, nullable)
- `vendor_code` (`TEXT`, nullable) — Vendor code assigned by Amazon, uploaded per ASIN or SKU.
- `vendor_product_identifier` (`TEXT`, nullable)
- `title` (`TEXT`, nullable)
- `ordered_quantity` (`NUMBER`, nullable) — Units the customer ordered on this Direct Fulfillment line. Not amazon_vendor_purchase_orders.ordered_quantity (often Cases).
- `ordered_quantity_unit_of_measure` (`TEXT`, nullable) — Unit of measure for ordered_quantity, usually Each.
- `net_price_amount` (`NUMBER`, nullable) — Price Amazon pays the vendor per unit. Not the customer price.
- `net_price_currency` (`TEXT`, nullable)
- `total_price_amount` (`NUMBER`, nullable) — Line amount Amazon pays the vendor (net price × ordered quantity).
- `total_price_currency` (`TEXT`, nullable)
- `item_tax_amount` (`NUMBER`, nullable)
- `item_tax_currency` (`TEXT`, nullable)
- `gift_wrap_id` (`TEXT`, nullable)
- `last_seen_at` (`DATE`, required) — Timestamp when DataDoe last received this row from the Vendor API.

---

Query live via DataDoe MCP `exports_source_get` (connected accounts only), or request rows with `exports_create`.