Returns a list of purchase orders created during the specified time frame, along with essential order information such as order dates, shipping addresses, requested delivery dates, and order status.

View-Specific Information

Select

To retrieve all new direct fulfillment orders from the last 7 days:

SELECT 
  PurchaseOrderNumber,
  OrderDate,
  OrderStatus,
  CustomerOrderNum,
  ShipToName,
  ShipToCity,
  ShipToStateOrRegion,
  ShipToPostalCode,
  RequiredDate,
  PromisedDate,
  ShipMethod,
  IsPriority
FROM VendorCentral.DirectFulfillmentOrders
WHERE OrderDate >= DATEADD(day, -7, GETDATE())
  AND OrderStatus = 'NEW'
ORDER BY OrderDate DESC;

Use this query for a quick overview of pending orders that need fulfillment.

To filter orders by warehouse to view fulfillment workload for a specific location:

SELECT 
  PurchaseOrderNumber,
  OrderDate,
  ShipFromId,
  ShippingPartyName,
  ShippingPartyCity,
  OrderStatus
FROM VendorCentral.DirectFulfillmentOrders
WHERE ShipFromId = 'WAREHOUSE-001'
  AND OrderDate >= DATEADD(day, -30, GETDATE());

To retrieve priority shipments with approaching deadlines to support time-sensitive fulfillment:

SELECT 
  PurchaseOrderNumber,
  OrderDate,
  RequiredDate,
  ShipToName,
  ShipToCity,
  ShipToStateOrRegion,
  CustomerMessage
FROM VendorCentral.DirectFulfillmentOrders
WHERE IsPriority = 1
  AND OrderStatus = 'NEW'
  AND RequiredDate <= DATEADD(day, 2, GETDATE())
ORDER BY RequiredDate ASC;

To generate a daily warehouse summary showing order volume, item count, total units, and total value to support capacity planning and workload balancing across facilities:

SELECT 
  ShipFromId,
  ShippingPartyName,
  COUNT(DISTINCT PurchaseOrderNumber) AS TotalOrders,
  COUNT(ItemSequenceNumber) AS TotalItems,
  SUM(CAST(OrderedAmount AS INT)) AS TotalUnits,
  SUM(CAST(TotalPrice AS DECIMAL(18,2))) AS TotalValue
FROM VendorCentral.DirectFulfillmentOrders 
INNER JOIN VendorCentral.DirectFulfillmentOrderItems 
  ON PurchaseOrderNumber = PurchaseOrderNumber
WHERE OrderDate >= CAST(GETDATE() AS DATE)
  AND OrderStatus = 'NEW'
GROUP BY ShipFromId, ShippingPartyName
ORDER BY TotalOrders DESC;

To identify orders with approaching required ship dates:

SELECT 
  PurchaseOrderNumber,
  OrderDate,
  RequiredDate,
  DATEDIFF(hour, GETDATE(), RequiredDate) AS HoursUntilRequired,
  ShipFromId,
  IsPriority,
  COUNT(ItemSequenceNumber) AS ItemCount,
  ShipToCity,
  ShipToStateOrRegion
FROM VendorCentral.DirectFulfillmentOrders 
INNER JOIN VendorCentral.DirectFulfillmentOrderItems 
  ON PurchaseOrderNumber = PurchaseOrderNumber
WHERE OrderStatus = 'NEW'
  AND RequiredDate BETWEEN GETDATE() AND DATEADD(day, 1, GETDATE())
GROUP BY 
  PurchaseOrderNumber,
  OrderDate,
  RequiredDate,
  ShipFromId,
  IsPriority,
  ShipToCity,
  ShipToStateOrRegion
ORDER BY RequiredDate ASC;

The HoursUntilRequired column shows the time remaining before the deadline.

Use this report to prioritize fulfillment activities and prevent late shipments.

Columns