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 "Ledger Sheets") 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 ('LedgerSheet' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+LedgerSheet' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"LedgerSheet"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"LedgerSheet"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"LedgerSheet"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"LedgerSheet"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+LedgerSheet' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='LedgerSheet',`category_4` ='LedgerSheet') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'LedgerSheet,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('LedgerSheet', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Ledger Sheets

Refine Search

  GO
Brand

Wilson Jones(28)

National(1)

Adams(1)

Manufacturer Part Number

G7203A(1)

G7204A(1)

G7202A(1)

G50-36(1)

G50-24(1)

G50-30(1)

G7205A(1)

G7206A(1)

GN2D(1)

N2D(1)

GN2B(1)

G7225A(1)

G7208A(1)

G7213A(1)

G50-12(1)

G30-24(1)

903-10(1)

G10-10(1)

901-30(1)

901-10(1)

14-055(1)

758-50(1)

G10-20(1)

G10-24(1)

G30-10(1)

G30-20(1)

G10-8(1)

G10-6(1)

G10-3(1)

ARB58100(1)

Country of Origin

US(28)

BR(1)

CN(1)

For Use With

WLJ-039511(2)

WLJ-039531(1)

WLJ-020358BL(1)

RED-63453(1)

ABFARB59LB(1)

Sheet Size

9 1/4" x 11 7/8"(9)

11" x 8 1/2"(8)

11" x 17"(4)

11" x 14"(3)

5" x 8 1/2"(2)

11" x 24 1/4"(1)

11" x 16 3/8"(1)

5 x 8 1/2(1)

14" x 8 1/2"(1)

Cover Material(s)

Chipboard Back; Flexible Front(8)

Binding

Reinforced; Side(8)

Number of Holes Punched

3(11)

4(10)

2(7)

12(1)

6(1)

Print and Ruling Color(s)

Light Green(13)

Brown; Dark Green(8)

Green(3)

Blue; White(1)

Blue(1)

Green/Brown(1)

Layout

Sheet Ruled Both Sides Alike; Single-Page Form(15)

Double-Page Form; Sheet Ruled Both Sides Different(7)

Unruled; Un-numbered(3)

Sheet Ruled One Side Only; Single-Page Form(2)

Format

Loose Sheet(20)

50-Sheet Pad(8)

Preprinted

No(3)

Yes(3)

Numbering Color(s)

Green(8)

Number of Columns

24(3)

6(2)

5(2)

3(2)

8(2)

20(2)

10(2)

13(1)

25(1)

4(1)

36(1)

12(1)

30(1)

2(1)

Paper Color(s)

Green(16)

Light Green(8)

White(4)

Ivory(2)

Punching

Side, Slotted Holes(13)

Side, Three-Hole(8)

Rectangular; 8 1/2" Outside Centers(3)

5/16" Dia. Holes; 7 1/8" Outside Centers(3)

Side, Six-Hole(1)

Numbering

Preprinted Columns; Preprinted Lines(8)

Paper Stock

Bond(8)

24-lb.(3)

28-lb.(3)

Column Headers

Debit; Credit; Balance(2)

Balance;Credit;Debit(1)

Price Range

$0-$49.99(20)

$50-$99.99(10)

To  GO

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

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