tbl_Product
ProductID TypeID Product ProductCode ProductSize IsActive 1 1 BABY CHAIRS CH101 2 1 BAR CHAIR CH102 3 1 BAR CHAIR WITH ARMS CH103 4 1 CAFÉ CH104 5 1 CONSTANTIA NO ARMS CH105 6 1 CONSTANTIA WITH ARMS CH106 7 1 CONSTANTIA MINI CH107 8 1 IMPERIAL CHAIR CH108 9 1 KENTUCKY NO ARMS CH109 10 1 KENTUCKY WITH ARMS CH110 11 1 KENTUCKY MINI CH111 12 1 MANHATTAN NO ARMS CH112 13 1 MANHATTAN WITH ARMS CH113 14 1 MANHATTAN MINI CH114 15 1 MORRIS CHAIR CH115 16 1 OTTOMAN CH116 - MORRIS 17 1 OTTOMAN CH117 - STANDARD 18 1 SLEIGH CHAIR CH118 19 1 TULBAGH CHAIR CH119 20 1 WINSTON NO ARMS CH120 21 1 WINSTON WITH ARMS CH121 22 1 WINSTON MINI CH122 23 2 IMPERIAL COUCH 2 SEATER CC201 24 2 IMPERIAL COUCH 3 SEATER CC202 25 2 TULBAGH COUCH 2 SEATER CC203 26 2 TULBAGH COUCH 3 SEATER CC204 27 2 WINDOW SEAT CC205 28 3 MIRROR -PICCOLO MR301 29 3 MIRROR -GRANDE MR302 30 4 POOL LOUNGER - CHERIE PL401 31 4 POOL LOUNGER - CLASSIC PL402 32 4 POOL LOUNGER - COCO PL403 33 5 SERVER - CLASSIC 1435 X 525 X 850 SV501 34 5 SERVER - FIRENZE 1435 X 525 X 850 SV502 35 6 CLARE ROUND - PICCOLOX 1000 X 750 TA601 1000 36 6 CLARE ROUND - GRANDE X 1500 X 750 TA602 1500 37 6 COFFEE TABLE - LIGHT X 675 X 420 TA603 1280 38 6 COFFEE TABLE - HEAVY X 675 X 420 TA604 1280 39 6 4 SEATER TA605 SQUARE 1000 X 1000 X 760 40 6 6 SEATER TA606 RECTANGULARX 1150 X 760 1900 41 6 8 SEATER TA607 RECTANGULARX 1150 X 760 2450 42 6 8 SEATER TA608 OCTAGONAL X 1780 760 1780 43 6 8 SEATER TA609 SQUARE 1900 X 1900 X 760 44 6 10 SEATER RECTANGULAR 1150 X 760 TA610 2800 X 45 6 10 SEATER EXTENDED OCTAGONAL TA611 46 6 12 SEATER RECTANGULAR 1150 X 760 TA612 3250 X 47 6 12 SEATER EXTENDED OCTAGONAL TA613 48 6 SIDE TABLE - PICCOLO TA614 49 6 SIDE TABLE - GRANDE TA615 50 7 BALUSTRADE BL701 51 8 CHAIR SP801
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
PriceStd PriceTiles PriceSlate 80 0 0 1044.58 0 0 0 0 0 800 0 0 1136.35 0 0 1270.42 0 0 0 0 0 0 0 0 0 0 0 1139.75 0 0 0 0 0 1149.12 0 0 1364.58 0 0 0 0 0 1518 0 0 568.7 0 0 633 0 0 1504.8 0 0 1793 0 0 1174.66 0 0 1366.18 0 0 0 0 0 0 0 0 2933 0 0 3392 0 0 3858.36 0 0 0 0 0 1945.98 0 0 0 0 0 2721.18 0 0 2721.18 0 0 0 0 0 0 2708.64 3575 0 4639.8 4639.8 0 0 0 0 0 0 0 1755.6 2758.8 0 2306.7 2946.9 0 2316.5 3179 0 3848.9 4397.8 0 4180 5868.5 0 4514.4 7177.5 0 4356 7040 0 6490 7976.1 0 0 0 0 7260 9119 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Page 1
tbl_Product
52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88
8 8 8 8 8 9 9 9 9 9 10 10 10 10 10 10 10 10 10 10 10 10 11 11 11 11 11 12 12 12 12 12 12 12 12 12 12
COAT STAND SP802 COUCH SP803 MIRROR SP804 POOL LOUNGER SP805 SERVER SP806 BACK CUSHIONS - CAMFEROL AS901 BACK CUSHIONS - FOAM AS902 PLACE MATS AS903 SERVIETTES AS904 TABLE CLOTHS AS905 CASTING -ST01 FLOWER CASTING -ST02 CUT LASER CROWN - CONSTANTIA ST03 CROWN - MANHATTAN ST04 CROWN - WINSTON ST05 EMBLEM - ST06 CONSTANTIA EMBLEM - ST07 WINSTON KENTUCKY ARMS ST08 LEGS - CENTRE ST09 LEGS - NORMAL ST010 RUNGS - KENTUCKY ST011 RUNGS - MANHATTAN ST012 GLASS TF01 GRANITE TF02 SLATE TF03 TILE TF04 WOOD TF05 ANTIQUE BLACK CL01 ANTIQUE BRONZE CL02 ANTIQUE COPPER CL03 GREY/WHITE CL04 INDIGO BLUE CL05 OAK BEIGE CL06 PORTER GREEN CL07 POWDER COATING CL08 SPECIAL COLOUR CL09 VERDIGREEN CL10
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
0 0 0 0 0 130.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Page 2
tbl_Product
PriceGlass PriceGranite 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3511.2 3768.84 4514.4 5200 5100 0 8100 0 2494.8 3100 3135 3900 3036 3887.4 4268 5586 5330.6 6851.4 5712.3 8094 6050 7510 6431.7 8413.2 0 0 9020 9590.82 0 0 0 0 0 0 0 0 0 0
Page 3
tbl_Product
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Page 4
tbl_Price_Cat
PriceCatId 1 2 3 4 5
PriceCat STANDARD TILES SLATE GLASS GRANITE
Page 5
tbl_Product_Types
TypeID 1 2 3 4 5 6 7 8 9 10 11 12
Type CHAIRS COUCHES MIRRORS POOL LOUNGERS SERVERS TABLES BALUSTRADE SPECIALS ASSESSORIES STYLES TOP FINISHES COLOURS
Page 6