A list of cycle counts

View Name: vw_KPICycle
Filter: Cycle Count status not X (cancelled)
Features: Company, Warehouse
Transactional: Yes, by CycDate

Field	Type	Description
CycID	int	Cycle Count ID
CompCode	varchar	Company Code
Whse	varchar	Warehouse Code
CycDate	datetime	Cycle Count Date
CycType	varchar	Cycle Count Type (FULL=Full Warehouse, ITEM=Specific Items, LOC=Specific Locations, SPOT=Spot)
CycleLines	int	Lines Counted
MatchLines	int	Lines Matched (no adjustment)
UnMatchLines	int	Lines UnMatched (adjustment needed)
NetAdjustment	decimal	Net adjustment value for unmatched lines