SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` WHERE (`category_name` LIKE "Time Clock Cards") AND `pinfo`.`status` IN ('active','discontinued') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN MATCH(`desc_short`) AGAINST ('TimeClockCard' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+TimeClockCard' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"TimeClockCard"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"TimeClockCard"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"TimeClockCard"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"TimeClockCard"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+TimeClockCard' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='TimeClockCard',`category_4` ='TimeClockCard') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'TimeClockCard,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('TimeClockCard', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Time Clock Cards

Refine Search

  GO
Brand

TOPS(17)

Lathem Time(5)

Acroprint(4)

Rediform(3)

uPunch(2)

Size

3 1/2 x 9(8)

3 1/2 x 10 1/2(4)

4 x 9(4)

3 3/8 x 8 1/4(2)

4 1/4 x 7(2)

7 1/2" x 3 1/2"(2)

3 1/2 x 7(2)

3 1/2 x 7 1/4(2)

6 x 4(1)

4 1/4 x 6 3/4(1)

4 1/4 x 8(1)

4 x 10(1)

3 1/2 x 8 1/2(1)

Manufacturer Part Number

1259(1)

12593(1)

1258(1)

1257(1)

1255(1)

1256(1)

1260(1)

1261(1)

3016(1)

3017(1)

1291(1)

1277(1)

1275(1)

1276(1)

1253(1)

1252(1)

E100(1)

E7-100(1)

16100(1)

09-9111-000(1)

09-7000-000(1)

09-9110-000(1)

E8100(1)

M2100(1)

4K409(1)

12443(1)

4K406(1)

4K402(1)

HNTCG1100(1)

HNTCL2100(1)

09-6103-080(1)

Country of Origin

US(27)

MX(3)

CN(1)

Time Period

Weekly(18)

Semi-Monthly(3)

Bi-Weekly; Weekly(3)

Bi-Weekly; Monthly; Semi-Monthly; Weekly(2)

Bi-Weekly; Semi-Monthly; Weekly(2)

Bi-Weekly(1)

Daily(1)

Job Card(1)

Card Quantity

100(15)

500(13)

250(2)

200(1)

OEM Card Number

Acroprint M33; IBM 10-800292; Lathem 33; Simplex 10-800292(2)

Acroprint ATR206; Amano 6500; Cincinnati C3000; Lathem M154(1)

Cincinnati K14-15(1)

Lathem CH-107-2(1)

Acroprint L34B; Cincinnati CH-131; Lathem CH-131; Simplex 10-100382(1)

Pyramid 331-10(1)

Simplex 10-100372(1)

Cincinnati L-61; Lathem L61; Simplex 1950-9502(1)

Acroprint ESP180, 125R, 150R, 175; Simplex 10-800762, 1950-9308(1)

Pyramid 35100-10(1)

uPunch HNTCL(1)

Acroprint 1900L; Lathem 1900L(1)

Acroprint 3200; Lathem 3200(1)

Acroprint ESP180, 125R, 150R, 175; Cincinnati K14-36971D; Lathem 30; Simplex 10-800292; Stromberg 1912R(1)

Cincinnati K14-36981D; Simplex 10-100312(1)

uPunch HNTCG(1)

Clock/Recorder Compatibility

Lathem Model 800P(1)

All Side Print Time Clocks(1)

uPunch HN1000, HN3000, and HN3600 Bundle(1)

uPunch HN2000, HN4000 and HN4600 Bundle(1)

Lathem Time Model 7000E(1)

Lathem Time Models 900E, 1000E, 1500E, 5000E(1)

Acroprint ATR240, ATR360(1)

Acroprint Model ATR120(1)

Acroprint Model ES1000(1)

Lathem Model 1600E(1)

Acroprint Model ATT310(1)

Printing Sides

One Side(17)

Two Sides(14)

Column Headers

In/Out(2)

Deductions; Earnings; Hours; Rate; Overtime(1)

Amount; Day; Deductions; Earnings; Hours; Job Desc.; Rate(1)

Description; Hours; Job No.; Rate(1)

Daily Hours; Minutes Worked AM/PM; Overtime(1)

In, Out, In, Out(1)

Date; Deductions; In/Out; Name; Signature(1)

In/Out, In, Out/In, Out(1)

In Out(1)

In/Out; Regular; Overtime Totals(1)

Price Range

$0-$9.99(7)

$10-$19.99(19)

$30-$39.99(4)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Office Solutions & Innovations, Inc., All Rights Reserved