= {Category Description} + CASE WHEN {Activity Code} = 'D1 - Discontinued item - Can be custom made' AND {Quantity in stock} = 0 AND {Japan Inventory} = 0 THEN '
Notice: This product is discontinued, but will be available on a made to order custom basis once current inventory runs out.' WHEN {Activity Code} = 'D2 - Discontinued item - Substitute item Available' AND {Quantity in stock} = 0 AND {Japan Inventory} = 0 THEN '
Notice: This product is discontinued, but does have an alternate. Please see the alternate compatible product.' WHEN {Activity Code} = 'D3 - Discontinued item - No Longer Available' AND {Quantity in stock} = 0 AND {Japan Inventory} = 0 THEN '
Notice: This product is discontinued. Please contact KHK for alternative solutions by calling 516-248-3850 or by filling out the form below' ELSE '' END =
Notice: This product is discontinued, but will be available on a made to order custom basis once current inventory runs out.' WHEN {Activity Code} = 'D2 - Discontinued item - Substitute item Available' AND {Quantity in stock} = 0 AND {Japan Inventory} = 0 THEN '
Notice: This product is discontinued, but does have an alternate. Please see the alternate compatible product.' WHEN {Activity Code} = 'D3 - Discontinued item - No Longer Available' AND {Quantity in stock} = 0 AND {Japan Inventory} = 0 THEN '
Notice: This product is discontinued. Please contact KHK for alternative solutions by calling 516-248-3850 or by filling out the form below' ELSE '' END =
Unit of Measure
Dimensions
A |
N/A 54 mm2.126 in |
B |
N/A 34.7 mm1.366 in |
B1 |
N/A 19 mm0.748 in |
C |
N/A 17.8 mm0.701 in |
D |
N/A 41.76 mm1.644 in |
E |
N/A 25 mm0.984 in |
| F1 | N/A M14 x 1.5 |
G |
N/A 28 mm1.102 in |
H |
N/A 1.6 mm0.063 in |
L |
N/A 6 mm0.236 in |
P |
N/A 27 mm1.063 in |
Q |
N/A 8 mm0.315 in |
| R2 | N/A 3.0 mm0.118 in |
S |
N/A 14.5 mm0.571 in |
S1 |
N/A 16.4 mm0.646 in |
T |
N/A 23.5 mm0.925 in |
T1 |
N/A 10.5 mm0.413 in |
T2 |
N/A 18.5 mm0.728 in |
U |
N/A 89.5 mm3.524 in |
U1 |
N/A 133 mm5.236 in |
V |
N/A 25 mm0.984 in |
W |
N/A 62 mm2.441 in |
X |
N/A M8 x 1.25 |
Y |
N/A 13 mm0.512 in |
Z |
N/A 20 mm0.787 in |
Internal
Sell Price 1 Value |
N/A {0} USD |
Activity Code |
N/A {N/A} |
Sell Price 2 Value |
N/A {0} USD |
Sell Price 3 Range |
N/A {0} |
Sell Price 3 Value |
N/A {0} USD |
Sell Price 4 Range |
N/A {0} |
Sell Price 4 Value |
N/A {0} USD |
Sell Price 5 Range |
N/A {0} |
Sell Price 5 Value |
N/A {0} USD |
Sell Price 6 Range |
N/A {0} |
Sell Price 6 Value |
N/A {0} USD |
Sell Price 7 Range |
N/A {0} |
Sell Price 7 Value |
N/A {0} USD |
Sell Price 8 Range |
N/A {0} |
Sell Price 8 Value |
N/A {0} USD |
Sell Price 1 Range |
N/A {0} |
Sell Price 2 Range |
N/A {0} |
custitemkhk_jp_production_date |
N/A {N/A} |
custitemcustitem_khk_jp_production_qty |
N/A {0} |
Discounts
Pricing Structure |
N/A
= '
|
Inventory
Quantity in stock |
N/A {N/A} |
3 Day Delivery (Factory Direct) Inventory |
N/A {N/A} |
Backorder Availability* |
N/A = IIF(CAST({custitemcustitem_khk_jp_production_qty} AS NUMERIC)>0,'An additional '+ {custitemcustitem_khk_jp_production_qty} ,'Additional') + ' pieces available in ' + FORMAT(DATEDIFF(WEEK, GETDATE(), CONVERT(date, {custitemkhk_jp_production_date}, 112)),'N0') + ' week(s) ARO.' = |
Inventory Note |
N/A *Approximate inventory level subject to prior sale and availability. If you require more product then is available, please contact us at (516) 248-3850. |
- 1 Screws are metric fine thread. See dimension F above.
- 2 The R dimension value is the eccentricity of the adjusting nut, which is the adjustment amount of the adjusting nut in 360°
