BookmarkBookmark this page!
Jan 26, 2026

BI CVW Fulfillment Analysis – Documentation

                         

Purpose:

The BI_CVW_FulfillmentAnalysis view provides detailed insight into item fulfillment activities, including operator actions, quantities processed, and related financial and logistical metrics. It is primarily used for operational analysis, warehouse performance monitoring, and fulfillment efficiency reporting.

                                          

Key Features:

  • Tracks all item fulfillment actions recorded in the system.

  • Associate each action with the responsible operator and department.

  • Calculates revenue, quantities, weights, and cubic volumes for fulfilled items.

  • Integrates revenue metrics from related transaction items.

                                         

Primary Columns & Metrics:

Column

Description

OperatorName

Name of the operator performing the action. 

Action

Description of the action performed.  Prep In, Prep Out, Will call.

Contract

Contract number associated with the item fulfillment.

DepartmentName

Department responsible for the item. 

DivisionName

Division associated with the item category.

ItemNumber

Unique identifier for the item (Item Num).

ItemName

Name/description of the item.

Timestamp

Original timestamp of the fulfillment action.

ActionDate

Date portion of the fulfillment timestamp (for reporting by day).

Qty

Quantity processed in the action (always positive, regardless of movement direction).

Weight

Calculated weight of the fulfilled items (Item Weight × Quantity).

CubicSize

Calculated cubic volume of the fulfilled items (Item CubicSize × Quantity).

ItemPrice

Price of the item line from the transaction, used for revenue calculation.

Revenue

Revenue contribution from this item action (same as ItemPrice).

 

Business Use Cases:

  • Monitoring daily and historical fulfillment activity by operator, department, or division.

  • Measuring operational efficiency by comparing quantities processed versus expected.

  • Calculating warehouse space utilization using weight and cubic volume metrics.

  • Analyzing revenue contributions from fulfilled items.

  • Supporting performance dashboards and operational KPIs for fulfillment teams.

                                                            

Notes:

  • Only includes items marked as fulfillable (Nonfulfillable = 0).

  • Joins multiple reference tables to retrieve operator, department, division, and item metadata.

  • Aggregates transaction-level revenue to align each fulfillment action with its financial value.

                                      

POR Tables

  • TransactionItemsSerialization 

  • TransactionItemsSerializationAction 

  • OperatorId 

  • ItemFile 

  • ItemCategory 

  • ItemDepartment 

  • ItemDivision 

  • TransactionItems 

 

Related Articles