Back
/*
Table: PurchaseOrderSummary
Columns:
vendorID INT
sku VARCHAR
totalReceived INT
casesReceived INT
oldest DATETIME
newest DATETIME
Depends on:
PurchaseOrder, PurchaseOrderItems
Use:
Stores total quantities ordered for recent
orders where "recent" covers the same
timeframe as transarchive. Calculating this
on the fly can be prohibitively slow.
totalReceived is in individual units for comparison
against sales records. casesReceived is in cases.
numOrders indicates how many times the item has
been ordered. Credits are counted separately as
numCredits. oldest and newest are bounds on when
the item has been ordered.
*/Back