JET CITY TRAVEL WALLET

No 9242_396

Be the first to review!

$30.00

Choose Color

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	BLACK	79622	[empty string]	[empty string]	0	7	0	0	JET_BLACK	34	[empty string]	887659	[empty string]	186990

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 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,5,8,6,9,14,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 not in ('N','NO') or (a.sell_web is null)) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,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	186990

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

Qty

Check Store Availability

Add to Basket

Please login or create an account to save this product to your wish list.

Description
Specs
Reviews
Live Chat

Travel ready & secure

Whether your adventure leads to the beach, city, or travels abroad, keep your essential close at hand and light with the Jet City Travel Wallet from KAVU. This bi-fold wallet features a zippered mesh pocket for coins, a pen pocket, and slots for cards, cash, and a passport. Slip it into a purse or pack, or sling the shoulder strap across your body for a minimalist carrying option.

Fixed rope cross body shoulder strap that can detach
Patterned webbing hand strap
Rope loop zip pulls
One main compartment with zip closure
Internal zip mesh pocket, pen pocket, and multiple internal passport, cash, cash and card slots
Fabric: 11-ounce 600D polyester
Strap length: 50 inches
Dimensions: 9 x 6 x 1 inches

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

Whether your adventure leads to the beach, city, or travels abroad, keep your essential close at hand and light with the Jet City Travel Wallet from KAVU. This bi-fold wallet features a zippered mesh pocket for coins, a pen pocket, and slots for cards, cash, and a passport. Slip it into a purse or pack, or sling the shoulder strap across your body for a minimalist carrying option.
Specs
- Fixed rope cross body shoulder strap that can detach
- Patterned webbing hand strap
- Rope loop zip pulls
- One main compartment with zip closure
- Internal zip mesh pocket, pen pocket, and multiple internal passport, cash, cash and card slots
- Fabric: 11-ounce 600D polyester
- Strap length: 50 inches
- Dimensions: 9 x 6 x 1 inches
Reviews

No Reviews Yet!
Live Chat

JET CITY TRAVEL WALLET

$30.00

Choose Color

Qty

Description

Specs

Reviews

Live Chat

Spill the Beans

You may also like