9
N° Client Activité N° de Commande Date de commande 100 Assurances 1 1/3/2000 123 Machines/Outils 2 1/3/2000 109 Éducation 3 1/3/2000 104 Éducation 4 1/3/2000 117 Banques 5 1/4/2000 103 Assurances 6 1/4/2000 104 Éducation 7 1/4/2000 111 Alimentaire 8 1/4/2000 113 Construction 9 1/4/2000 116 Pharmaceutique 10 1/4/2000 110 Distribution 11 1/5/2000 112 Machines/Outils 12 1/5/2000 123 Machines/Outils 13 1/5/2000 113 Construction 14 1/5/2000 115 Distribution 15 1/5/2000 124 Éducation 16 1/5/2000 124 Éducation 17 1/5/2000 106 Construction 18 1/5/2000 101 Construction 19 1/5/2000 116 Pharmaceutique 20 1/6/2000 112 Machines/Outils 21 1/6/2000 125 Construction 22 1/6/2000 100 Assurances 23 1/6/2000 125 Construction 24 1/6/2000 104 Éducation 25 1/7/2000 126 Machines/Outils 26 1/7/2000 121 Pharmaceutique 27 1/7/2000 114 Distribution 28 1/7/2000 103 Assurances 29 1/7/2000 125 Construction 30 1/7/2000 120 Banques 31 1/10/2000 111 Alimentaire 32 1/10/2000 118 Éducation 33 1/10/2000 127 Alimentaire 34 1/10/2000 101 Construction 35 1/11/2000 118 Éducation 36 1/11/2000 119 Distribution 37 1/11/2000 106 Construction 38 1/11/2000 121 Pharmaceutique 39 1/11/2000 104 Éducation 40 1/12/2000 101 Construction 41 1/12/2000 106 Construction 42 1/12/2000

xlsxDonnees

Embed Size (px)

DESCRIPTION

uyt

Citation preview

VentesN ClientActivitN de CommandeDate de commandeArticleQuantitPrix par piceRabais Prix total avec rabaisFacture paye100Assurances11/3/00Compaq Presario 1001216501.50%19503Oui123Machines/Outils21/3/00IBM 500222990.00%4598Oui109ducation31/3/00AST Intel 150526900.00%13450Oui104ducation41/3/00AST Intel 200331900.00%9570Oui117Banques51/4/00Compaq Presario 1001316501.50%21128.25Oui103Assurances61/4/00AST Intel 150226900.00%5380Oui104ducation71/4/00AST Intel 200231900.00%6380Oui111Alimentaire81/4/00IBM 500422990.00%9196Oui113Construction91/4/00Compaq Presario 100416500.00%6600Oui116Pharmaceutique101/4/00IBM 500222990.00%4598Oui110Distribution111/5/00AST Intel 200631901.50%18852.9Oui112Machines/Outils121/5/00Compaq Presario 100616501.50%9751.5Oui123Machines/Outils131/5/00IBM 500622991.50%13587.09Oui113Construction141/5/00AST Intel 150326900.00%8070Oui115Distribution151/5/00Compaq Presario 100816501.50%13002Oui124ducation161/5/00AST Intel 200831901.50%25137.2Oui124ducation171/5/00Compaq Presario 1001116501.50%17877.75Oui106Construction181/5/00AST Intel 2001131901.50%34563.65Oui101Construction191/5/00Compaq Presario 1001416501.50%22753.5Non116Pharmaceutique201/6/00IBM 500722991.50%15851.605Non112Machines/Outils211/6/00AST Intel 150626901.50%15897.9Oui125Construction221/6/00Compaq Presario 1002316503.00%36811.5Oui100Assurances231/6/00IBM 500322990.00%6897Oui125Construction241/6/00AST Intel 200231900.00%6380Oui104ducation251/7/00AST Intel 1501226901.50%31795.8Oui126Machines/Outils261/7/00AST Intel 1502426903.00%62623.2Oui121Pharmaceutique271/7/00IBM 500822991.50%18116.12Non114Distribution281/7/00AST Intel 200931901.50%28279.35Oui103Assurances291/7/00Compaq Presario 100616501.50%9751.5Oui125Construction301/7/00AST Intel 200431900.00%12760Oui120Banques311/10/00AST Intel 150226900.00%5380Oui111Alimentaire321/10/00Compaq Presario 1001616503.00%25608Oui118ducation331/10/00IBM 500322990.00%6897Oui127Alimentaire341/10/00IBM 500722991.50%15851.605Oui101Construction351/11/00AST Intel 200631901.50%18852.9Oui118ducation361/11/00Compaq Presario 100516500.00%8250Oui119Distribution371/11/00AST Intel 2002331903.00%71168.9Non106Construction381/11/00IBM 500422990.00%9196Oui121Pharmaceutique391/11/00AST Intel 150726901.50%18547.55Oui104ducation401/12/00Compaq Presario 1001216501.50%19503Oui101Construction411/12/00AST Intel 200131900.00%3190Oui106Construction421/12/00AST Intel 150926901.50%23846.85Oui113Construction431/12/00IBM 500622991.50%13587.09Oui127Alimentaire441/12/00AST Intel 200231900.00%6380Oui100Assurances451/12/00AST Intel 200431900.00%12760Oui109ducation461/13/00AST Intel 150126900.00%2690Non113Construction471/13/00IBM 5001122991.50%24909.665Oui114Distribution481/13/00Compaq Presario 100816501.50%13002Oui122Distribution491/13/00AST Intel 200731901.50%21995.05Oui100Assurances501/13/00AST Intel 1501326901.50%34445.45Oui119Distribution511/14/00IBM 500222990.00%4598Oui102Machines/Outils521/14/00Compaq Presario 100516500.00%8250Oui112Machines/Outils531/17/00AST Intel 200331900.00%9570Oui117Banques541/17/00IBM 500522990.00%11495Oui103Assurances551/18/00IBM 500722991.50%15851.605Oui109ducation561/18/00AST Intel 1502126903.00%54795.3Oui110Distribution571/18/00AST Intel 200731901.50%21995.05Oui127Alimentaire581/18/00Compaq Presario 100716501.50%11376.75Oui105Banques591/18/00IBM 500922991.50%20380.635Oui110Distribution601/18/00AST Intel 200831901.50%25137.2Oui118ducation611/18/00IBM 5001022991.50%22645.15Oui123Machines/Outils621/18/00AST Intel 150426900.00%10760Oui126Machines/Outils631/19/00Compaq Presario 1001216501.50%19503Oui104ducation641/19/00AST Intel 200331900.00%9570Oui121Pharmaceutique651/19/00AST Intel 200431900.00%12760Oui118ducation661/19/00AST Intel 200531900.00%15950Oui120Banques671/19/00IBM 5001222991.50%27174.18Non117Banques681/19/00AST Intel 150526900.00%13450Non101Construction691/19/00Compaq Presario 1001316501.50%21128.25Non103Assurances701/19/00AST Intel 1501226901.50%31795.8Non101Construction711/19/00IBM 500522990.00%11495Non121Pharmaceutique721/19/00AST Intel 2002231903.00%68074.6Non108Pharmaceutique731/20/00AST Intel 2001331901.50%40847.95Non103Assurances741/20/00Compaq Presario 100816501.50%13002Non123Machines/Outils751/20/00AST Intel 1503326904.00%85219.2Non101Construction761/21/00AST Intel 2001031901.50%31421.5Non109ducation771/21/00Compaq Presario 1001116501.50%17877.75Non125Construction781/21/00IBM 500422990.00%9196Non121Pharmaceutique791/24/00Compaq Presario 1001316501.50%21128.25Non111Alimentaire801/24/00AST Intel 200231900.00%6380Non115Distribution811/24/00Compaq Presario 1001516501.50%24378.75Non112Machines/Outils821/24/00AST Intel 150226900.00%5380Non121Pharmaceutique831/24/00AST Intel 200431900.00%12760Non108Pharmaceutique841/24/00AST Intel 2002231903.00%68074.6Non116Pharmaceutique851/25/00Compaq Presario 1002116503.00%33610.5Non105Banques861/25/00Compaq Presario 1001916503.00%30409.5Non105Banques871/25/00IBM 500622991.50%13587.09Non112Machines/Outils881/26/00AST Intel 200231900.00%6380Non122Distribution891/26/00AST Intel 200831901.50%25137.2Non102Machines/Outils901/26/00IBM 500722991.50%15851.605Non123Machines/Outils911/27/00AST Intel 150426900.00%10760Non114Distribution921/27/00Compaq Presario 100516500.00%8250Non127Alimentaire931/27/00AST Intel 200831901.50%25137.2Non106Construction941/27/00AST Intel 200531900.00%15950Non113Construction951/27/00IBM 500622991.50%13587.09Non103Assurances961/27/00IBM 500522990.00%11495Non107Machines/Outils971/28/00AST Intel 150626901.50%15897.9Non123Machines/Outils981/28/00Compaq Presario 100616501.50%9751.5Non109ducation991/28/00Compaq Presario 1003116504.00%49104Non101Construction1001/28/00Compaq Presario 100516500.00%8250Non104ducation1011/28/00IBM 500222990.00%4598Non123Machines/Outils1021/28/00AST Intel 200631901.50%18852.9Non106Construction1031/28/00Compaq Presario 1001116501.50%17877.75Non115Distribution1041/28/00IBM 500322990.00%6897Non117Banques1051/28/00AST Intel 150326900.00%8070Non108Pharmaceutique1061/31/00Compaq Presario 1001516501.50%24378.75Non102Machines/Outils1071/31/00AST Intel 200431900.00%12760Non118ducation1081/31/00IBM 500322990.00%6897Non119ducation1091/31/00AST Intel 150226900.00%5380Non