Banner1 Banner1
 
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_36` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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` 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 WHERE (`category_id` IN ('384')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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 `pinfo`.`sku` LIKE '%TimeClockCards' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('TimeClockCards' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+TimeClockCards' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"TimeClockCards"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"TimeClockCards"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"TimeClockCards"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"TimeClockCards"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+TimeClockCards' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='TimeClockCards',`category_4` ='TimeClockCards') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'TimeClockCards,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('TimeClockCards', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Time Clock Cards

Refine Search

  GO
 
Brand

TOPS(13)

Lathem Time(5)

Acroprint(3)

Rediform(1)

 
Size

3.5 x 9(7)

4 x 9(3)

3.5 x 10.5(2)

3.38 x 8.25(2)

4 x 10(1)

3.5 x 7(1)

7.5 x 3.35 x 0.81(1)

9"(1)

3.5 x 7.25(1)

4.25 x 7(1)

3.5 x 8.5(1)

4.25 x 6.75(1)

 
Manufacturer Part Number

09-6103-080(1)

1256(1)

1291(1)

1276(1)

1275(1)

1261(1)

1260(1)

1259(1)

1258(1)

1257(1)

1253(1)

09-9111-000(1)

1252(1)

12443(1)

4K406(1)

M2100(1)

E8100(1)

E7-100(1)

E17100(1)

16100(1)

09-9115-000(1)

3016(1)

 
Country of Origin

MX(13)

US(7)

CN(2)

 
Time Period

Weekly(13)

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

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

Bi-Weekly; Weekly(1)

Daily(1)

Job Card(1)

Bi-Weekly(1)

Semi-Monthly(1)

 
Card Quantity

500(11)

100(9)

200(1)

50(1)

 
OEM Card Number

Acroprint ATR481(1)

Lathem Time E17-100(1)

Pyramid 35100-10(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)

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

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

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

Cincinnati K14-15(1)

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

Lathem CH-107-2(1)

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

Pyramid 331-10(1)

 
Clock/Recorder Compatibility

Acroprint ATT310(1)

Acroprint ESP125R, 150R, 175, 180; Cincinnati K14-36971D; Lathem 30; Simplex 10-800292, 1950-9305; Stromberg 1912R(1)

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

Lathem CH-107-2(1)

Acroprint ATR206; Cincinnati C3000; Lathem M154(1)

Cincinnati K14-15(1)

Acroprint M33; IBM 10-800292; Lathem 33; Simplex 10-100382, 10-800292, 1950-9305, 1950-9361(1)

Cincinnati L-61; Lathem L-61; Simplex 15-800622(1)

Acroprint ESP125R, 150R, 175, 180; Simplex 10-800762, 1950-9308(1)

Acroprint 3200; Lathem 3200(1)

Acroprint ES1000(1)

Acroprint 1900L; Lathem 1900L(1)

Pyramid 35100-10(1)

Side Print Time Clocks(1)

Lathem Model 800P(1)

Lathem 7000E(1)

Lathem Time 700E(1)

Lathem 1600E(1)

Acroprint ATR480(1)

Pyramid 331-10(1)

 
Printing Sides

One Side(12)

Two Sides(9)

2(1)

 
Column Headers

In/Out(3)

Daily Hours; Overtime; Time In/Out; Time Out; Total Pay Period OT Hours; Total Pay Period Regular Hours(1)

In Out(1)

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

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

 
 
 

© 2020-2021 Legal Name, All Rights Reserved