WOMEN'S OVIK TRAVEL SHORT SLEEVE SHIRT

No 87040

Description
Specs
Reviews
Live Chat

Button up the adventure

Travel in style in this short-sleeved shirt made from a cool hemp blend. Comfort fit that lets air circulate and the fabric’s uneven structure lifts it away from the skin for extra ventilation and a cool feel. In addition, the hemp has a natural resistance against microorganisms – a plus in tropical climates. A cool, airy travel favorite that will help you keep cool even on really hot days.

Material: 55% hemp, 45% polyester
Buttoned-down
Cool, easy-care fabric in hemp and recycled polyester
Warm-weather travel wear
The fabric’s uneven structure gives extra air circulation
Chest pocket with embroidered Fjällräven logo
Imported

No Reviews Yet!

Spill the Beans

Headline Name Email Overall Rating

Review

We want to make sure you know: All reviews become the property of Mast General Store. Your review requires staff approval before posting. See our Terms of Use for details.

Description

Travel in style in this short-sleeved shirt made from a cool hemp blend. Comfort fit that lets air circulate and the fabric’s uneven structure lifts it away from the skin for extra ventilation and a cool feel. In addition, the hemp has a natural resistance against microorganisms – a plus in tropical climates. A cool, airy travel favorite that will help you keep cool even on really hot days.
Specs
- Material: 55% hemp, 45% polyester
- Buttoned-down
- Cool, easy-care fabric in hemp and recycled polyester
- Warm-weather travel wear
- The fabric’s uneven structure gives extra air circulation
- Chest pocket with embroidered Fjällräven logo
- Imported
Reviews

No Reviews Yet!
Live Chat

$75.00

Choose Color

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	RASPBERRY_RED	124279	[empty string]	[empty string]	0	2	0	0	RASPBERRY_RED	32	Y	[empty string]	989948	[empty string]	210799
2	DARK_NAVY	124280	[empty string]	[empty string]	0	2	0	0	DARK_NAVY	31	Y	[empty string]	989949	[empty string]	210799

SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,14,6,5,9,8,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >= 2 ) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,14,6,5,9,8,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	210799

struct
INTERNALLISTPRICE	75
INTERNALMARKDOWN	false
INTERNALPRICE	75
REG	75
SALE	75
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	RASPBERRY_RED	124279	[empty string]	[empty string]	0	2	0	0	RASPBERRY_RED	32	Y	[empty string]	989948	[empty string]	210799
2	DARK_NAVY	124280	[empty string]	[empty string]	0	2	0	0	DARK_NAVY	31	Y	[empty string]	989949	[empty string]	210799