[json] CustomersOrders

Viewer

copydownloadembedprintName: CustomersOrders
  1. <?xml version="1.0" encoding="utf-8"?>  
  2. <Root>  
  3.   <Customers>  
  4.     <Customer CustomerID="GREAL">  
  5.       <CompanyName>Great Lakes Food Market</CompanyName>  
  6.       <ContactName>Howard Snyder</ContactName>  
  7.       <ContactTitle>Marketing Manager</ContactTitle>  
  8.       <Phone>(503) 555-7555</Phone>  
  9.       <FullAddress>  
  10.         <Address>2732 Baker Blvd.</Address>  
  11.         <City>Eugene</City>  
  12.         <Region>OR</Region>  
  13.         <PostalCode>97403</PostalCode>  
  14.         <Country>USA</Country>  
  15.       </FullAddress>  
  16.     </Customer>  
  17.     <Customer CustomerID="HUNGC">  
  18.       <CompanyName>Hungry Coyote Import Store</CompanyName>  
  19.       <ContactName>Yoshi Latimer</ContactName>  
  20.       <ContactTitle>Sales Representative</ContactTitle>  
  21.       <Phone>(503) 555-6874</Phone>  
  22.       <Fax>(503) 555-2376</Fax>  
  23.       <FullAddress>  
  24.         <Address>City Center Plaza 516 Main St.</Address>  
  25.         <City>Elgin</City>  
  26.         <Region>OR</Region>  
  27.         <PostalCode>97827</PostalCode>  
  28.         <Country>USA</Country>  
  29.       </FullAddress>  
  30.     </Customer>  
  31.     <Customer CustomerID="LAZYK">  
  32.       <CompanyName>Lazy K Kountry Store</CompanyName>  
  33.       <ContactName>John Steel</ContactName>  
  34.       <ContactTitle>Marketing Manager</ContactTitle>  
  35.       <Phone>(509) 555-7969</Phone>  
  36.       <Fax>(509) 555-6221</Fax>  
  37.       <FullAddress>  
  38.         <Address>12 Orchestra Terrace</Address>  
  39.         <City>Walla Walla</City>  
  40.         <Region>WA</Region>  
  41.         <PostalCode>99362</PostalCode>  
  42.         <Country>USA</Country>  
  43.       </FullAddress>  
  44.     </Customer>  
  45.     <Customer CustomerID="LETSS">  
  46.       <CompanyName>Let's Stop N Shop</CompanyName>  
  47.       <ContactName>Jaime Yorres</ContactName>  
  48.       <ContactTitle>Owner</ContactTitle>  
  49.       <Phone>(415) 555-5938</Phone>  
  50.       <FullAddress>  
  51.         <Address>87 Polk St. Suite 5</Address>  
  52.         <City>San Francisco</City>  
  53.         <Region>CA</Region>  
  54.         <PostalCode>94117</PostalCode>  
  55.         <Country>USA</Country>  
  56.       </FullAddress>  
  57.     </Customer>  
  58.   </Customers>  
  59.   <Orders>  
  60.     <Order>  
  61.       <CustomerID>GREAL</CustomerID>  
  62.       <EmployeeID>6</EmployeeID>  
  63.       <OrderDate>1997-05-06T00:00:00</OrderDate>  
  64.       <RequiredDate>1997-05-20T00:00:00</RequiredDate>  
  65.       <ShipInfo ShippedDate="1997-05-09T00:00:00">  
  66.         <ShipVia>2</ShipVia>  
  67.         <Freight>3.35</Freight>  
  68.         <ShipName>Great Lakes Food Market</ShipName>  
  69.         <ShipAddress>2732 Baker Blvd.</ShipAddress>  
  70.         <ShipCity>Eugene</ShipCity>  
  71.         <ShipRegion>OR</ShipRegion>  
  72.         <ShipPostalCode>97403</ShipPostalCode>  
  73.         <ShipCountry>USA</ShipCountry>  
  74.       </ShipInfo>  
  75.     </Order>  
  76.     <Order>  
  77.       <CustomerID>GREAL</CustomerID>  
  78.       <EmployeeID>8</EmployeeID>  
  79.       <OrderDate>1997-07-04T00:00:00</OrderDate>  
  80.       <RequiredDate>1997-08-01T00:00:00</RequiredDate>  
  81.       <ShipInfo ShippedDate="1997-07-14T00:00:00">  
  82.         <ShipVia>2</ShipVia>  
  83.         <Freight>4.42</Freight>  
  84.         <ShipName>Great Lakes Food Market</ShipName>  
  85.         <ShipAddress>2732 Baker Blvd.</ShipAddress>  
  86.         <ShipCity>Eugene</ShipCity>  
  87.         <ShipRegion>OR</ShipRegion>  
  88.         <ShipPostalCode>97403</ShipPostalCode>  
  89.         <ShipCountry>USA</ShipCountry>  
  90.       </ShipInfo>  
  91.     </Order>  
  92.     <Order>  
  93.       <CustomerID>GREAL</CustomerID>  
  94.       <EmployeeID>1</EmployeeID>  
  95.       <OrderDate>1997-07-31T00:00:00</OrderDate>  
  96.       <RequiredDate>1997-08-28T00:00:00</RequiredDate>  
  97.       <ShipInfo ShippedDate="1997-08-05T00:00:00">  
  98.         <ShipVia>2</ShipVia>  
  99.         <Freight>116.53</Freight>  
  100.         <ShipName>Great Lakes Food Market</ShipName>  
  101.         <ShipAddress>2732 Baker Blvd.</ShipAddress>  
  102.         <ShipCity>Eugene</ShipCity>  
  103.         <ShipRegion>OR</ShipRegion>  
  104.         <ShipPostalCode>97403</ShipPostalCode>  
  105.         <ShipCountry>USA</ShipCountry>  
  106.       </ShipInfo>  
  107.     </Order>  
  108.     <Order>  
  109.       <CustomerID>GREAL</CustomerID>  
  110.       <EmployeeID>4</EmployeeID>  
  111.       <OrderDate>1997-07-31T00:00:00</OrderDate>  
  112.       <RequiredDate>1997-08-28T00:00:00</RequiredDate>  
  113.       <ShipInfo ShippedDate="1997-08-04T00:00:00">  
  114.         <ShipVia>2</ShipVia>  
  115.         <Freight>18.53</Freight>  
  116.         <ShipName>Great Lakes Food Market</ShipName>  
  117.         <ShipAddress>2732 Baker Blvd.</ShipAddress>  
  118.         <ShipCity>Eugene</ShipCity>  
  119.         <ShipRegion>OR</ShipRegion>  
  120.         <ShipPostalCode>97403</ShipPostalCode>  
  121.         <ShipCountry>USA</ShipCountry>  
  122.       </ShipInfo>  
  123.     </Order>  
  124.     <Order>  
  125.       <CustomerID>GREAL</CustomerID>  
  126.       <EmployeeID>6</EmployeeID>  
  127.       <OrderDate>1997-09-04T00:00:00</OrderDate>  
  128.       <RequiredDate>1997-10-02T00:00:00</RequiredDate>  
  129.       <ShipInfo ShippedDate="1997-09-10T00:00:00">  
  130.         <ShipVia>1</ShipVia>  
  131.         <Freight>57.15</Freight>  
  132.         <ShipName>Great Lakes Food Market</ShipName>  
  133.         <ShipAddress>2732 Baker Blvd.</ShipAddress>  
  134.         <ShipCity>Eugene</ShipCity>  
  135.         <ShipRegion>OR</ShipRegion>  
  136.         <ShipPostalCode>97403</ShipPostalCode>  
  137.         <ShipCountry>USA</ShipCountry>  
  138.       </ShipInfo>  
  139.     </Order>  
  140.     <Order>  
  141.       <CustomerID>GREAL</CustomerID>  
  142.       <EmployeeID>3</EmployeeID>  
  143.       <OrderDate>1997-09-25T00:00:00</OrderDate>  
  144.       <RequiredDate>1997-10-23T00:00:00</RequiredDate>  
  145.       <ShipInfo ShippedDate="1997-09-30T00:00:00">  
  146.         <ShipVia>3</ShipVia>  
  147.         <Freight>76.13</Freight>  
  148.         <ShipName>Great Lakes Food Market</ShipName>  
  149.         <ShipAddress>2732 Baker Blvd.</ShipAddress>  
  150.         <ShipCity>Eugene</ShipCity>  
  151.         <ShipRegion>OR</ShipRegion>  
  152.         <ShipPostalCode>97403</ShipPostalCode>  
  153.         <ShipCountry>USA</ShipCountry>  
  154.       </ShipInfo>  
  155.     </Order>  
  156.     <Order>  
  157.       <CustomerID>GREAL</CustomerID>  
  158.       <EmployeeID>4</EmployeeID>  
  159.       <OrderDate>1998-01-06T00:00:00</OrderDate>  
  160.       <RequiredDate>1998-02-03T00:00:00</RequiredDate>  
  161.       <ShipInfo ShippedDate="1998-02-04T00:00:00">  
  162.         <ShipVia>2</ShipVia>  
  163.         <Freight>719.78</Freight>  
  164.         <ShipName>Great Lakes Food Market</ShipName>  
  165.         <ShipAddress>2732 Baker Blvd.</ShipAddress>  
  166.         <ShipCity>Eugene</ShipCity>  
  167.         <ShipRegion>OR</ShipRegion>  
  168.         <ShipPostalCode>97403</ShipPostalCode>  
  169.         <ShipCountry>USA</ShipCountry>  
  170.       </ShipInfo>  
  171.     </Order>  
  172.     <Order>  
  173.       <CustomerID>GREAL</CustomerID>  
  174.       <EmployeeID>3</EmployeeID>  
  175.       <OrderDate>1998-03-09T00:00:00</OrderDate>  
  176.       <RequiredDate>1998-04-06T00:00:00</RequiredDate>  
  177.       <ShipInfo ShippedDate="1998-03-18T00:00:00">  
  178.         <ShipVia>2</ShipVia>  
  179.         <Freight>33.68</Freight>  
  180.         <ShipName>Great Lakes Food Market</ShipName>  
  181.         <ShipAddress>2732 Baker Blvd.</ShipAddress>  
  182.         <ShipCity>Eugene</ShipCity>  
  183.         <ShipRegion>OR</ShipRegion>  
  184.         <ShipPostalCode>97403</ShipPostalCode>  
  185.         <ShipCountry>USA</ShipCountry>  
  186.       </ShipInfo>  
  187.     </Order>  
  188.     <Order>  
  189.       <CustomerID>GREAL</CustomerID>  
  190.       <EmployeeID>3</EmployeeID>  
  191.       <OrderDate>1998-04-07T00:00:00</OrderDate>  
  192.       <RequiredDate>1998-05-05T00:00:00</RequiredDate>  
  193.       <ShipInfo ShippedDate="1998-04-15T00:00:00">  
  194.         <ShipVia>2</ShipVia>  
  195.         <Freight>25.19</Freight>  
  196.         <ShipName>Great Lakes Food Market</ShipName>  
  197.         <ShipAddress>2732 Baker Blvd.</ShipAddress>  
  198.         <ShipCity>Eugene</ShipCity>  
  199.         <ShipRegion>OR</ShipRegion>  
  200.         <ShipPostalCode>97403</ShipPostalCode>  
  201.         <ShipCountry>USA</ShipCountry>  
  202.       </ShipInfo>  
  203.     </Order>  
  204.     <Order>  
  205.       <CustomerID>GREAL</CustomerID>  
  206.       <EmployeeID>4</EmployeeID>  
  207.       <OrderDate>1998-04-22T00:00:00</OrderDate>  
  208.       <RequiredDate>1998-05-20T00:00:00</RequiredDate>  
  209.       <ShipInfo>  
  210.         <ShipVia>3</ShipVia>  
  211.         <Freight>18.84</Freight>  
  212.         <ShipName>Great Lakes Food Market</ShipName>  
  213.         <ShipAddress>2732 Baker Blvd.</ShipAddress>  
  214.         <ShipCity>Eugene</ShipCity>  
  215.         <ShipRegion>OR</ShipRegion>  
  216.         <ShipPostalCode>97403</ShipPostalCode>  
  217.         <ShipCountry>USA</ShipCountry>  
  218.       </ShipInfo>  
  219.     </Order>  
  220.     <Order>  
  221.       <CustomerID>GREAL</CustomerID>  
  222.       <EmployeeID>4</EmployeeID>  
  223.       <OrderDate>1998-04-30T00:00:00</OrderDate>  
  224.       <RequiredDate>1998-06-11T00:00:00</RequiredDate>  
  225.       <ShipInfo>  
  226.         <ShipVia>3</ShipVia>  
  227.         <Freight>14.01</Freight>  
  228.         <ShipName>Great Lakes Food Market</ShipName>  
  229.         <ShipAddress>2732 Baker Blvd.</ShipAddress>  
  230.         <ShipCity>Eugene</ShipCity>  
  231.         <ShipRegion>OR</ShipRegion>  
  232.         <ShipPostalCode>97403</ShipPostalCode>  
  233.         <ShipCountry>USA</ShipCountry>  
  234.       </ShipInfo>  
  235.     </Order>  
  236.     <Order>  
  237.       <CustomerID>HUNGC</CustomerID>  
  238.       <EmployeeID>3</EmployeeID>  
  239.       <OrderDate>1996-12-06T00:00:00</OrderDate>  
  240.       <RequiredDate>1997-01-03T00:00:00</RequiredDate>  
  241.       <ShipInfo ShippedDate="1996-12-09T00:00:00">  
  242.         <ShipVia>2</ShipVia>  
  243.         <Freight>20.12</Freight>  
  244.         <ShipName>Hungry Coyote Import Store</ShipName>  
  245.         <ShipAddress>City Center Plaza 516 Main St.</ShipAddress>  
  246.         <ShipCity>Elgin</ShipCity>  
  247.         <ShipRegion>OR</ShipRegion>  
  248.         <ShipPostalCode>97827</ShipPostalCode>  
  249.         <ShipCountry>USA</ShipCountry>  
  250.       </ShipInfo>  
  251.     </Order>  
  252.     <Order>  
  253.       <CustomerID>HUNGC</CustomerID>  
  254.       <EmployeeID>1</EmployeeID>  
  255.       <OrderDate>1996-12-25T00:00:00</OrderDate>  
  256.       <RequiredDate>1997-01-22T00:00:00</RequiredDate>  
  257.       <ShipInfo ShippedDate="1997-01-03T00:00:00">  
  258.         <ShipVia>3</ShipVia>  
  259.         <Freight>30.34</Freight>  
  260.         <ShipName>Hungry Coyote Import Store</ShipName>  
  261.         <ShipAddress>City Center Plaza 516 Main St.</ShipAddress>  
  262.         <ShipCity>Elgin</ShipCity>  
  263.         <ShipRegion>OR</ShipRegion>  
  264.         <ShipPostalCode>97827</ShipPostalCode>  
  265.         <ShipCountry>USA</ShipCountry>  
  266.       </ShipInfo>  
  267.     </Order>  
  268.     <Order>  
  269.       <CustomerID>HUNGC</CustomerID>  
  270.       <EmployeeID>3</EmployeeID>  
  271.       <OrderDate>1997-01-15T00:00:00</OrderDate>  
  272.       <RequiredDate>1997-02-12T00:00:00</RequiredDate>  
  273.       <ShipInfo ShippedDate="1997-01-24T00:00:00">  
  274.         <ShipVia>1</ShipVia>  
  275.         <Freight>0.2</Freight>  
  276.         <ShipName>Hungry Coyote Import Store</ShipName>  
  277.         <ShipAddress>City Center Plaza 516 Main St.</ShipAddress>  
  278.         <ShipCity>Elgin</ShipCity>  
  279.         <ShipRegion>OR</ShipRegion>  
  280.         <ShipPostalCode>97827</ShipPostalCode>  
  281.         <ShipCountry>USA</ShipCountry>  
  282.       </ShipInfo>  
  283.     </Order>  
  284.     <Order>  
  285.       <CustomerID>HUNGC</CustomerID>  
  286.       <EmployeeID>4</EmployeeID>  
  287.       <OrderDate>1997-07-16T00:00:00</OrderDate>  
  288.       <RequiredDate>1997-08-13T00:00:00</RequiredDate>  
  289.       <ShipInfo ShippedDate="1997-07-21T00:00:00">  
  290.         <ShipVia>1</ShipVia>  
  291.         <Freight>45.13</Freight>  
  292.         <ShipName>Hungry Coyote Import Store</ShipName>  
  293.         <ShipAddress>City Center Plaza 516 Main St.</ShipAddress>  
  294.         <ShipCity>Elgin</ShipCity>  
  295.         <ShipRegion>OR</ShipRegion>  
  296.         <ShipPostalCode>97827</ShipPostalCode>  
  297.         <ShipCountry>USA</ShipCountry>  
  298.       </ShipInfo>  
  299.     </Order>  
  300.     <Order>  
  301.       <CustomerID>HUNGC</CustomerID>  
  302.       <EmployeeID>8</EmployeeID>  
  303.       <OrderDate>1997-09-08T00:00:00</OrderDate>  
  304.       <RequiredDate>1997-10-06T00:00:00</RequiredDate>  
  305.       <ShipInfo ShippedDate="1997-10-15T00:00:00">  
  306.         <ShipVia>1</ShipVia>  
  307.         <Freight>111.29</Freight>  
  308.         <ShipName>Hungry Coyote Import Store</ShipName>  
  309.         <ShipAddress>City Center Plaza 516 Main St.</ShipAddress>  
  310.         <ShipCity>Elgin</ShipCity>  
  311.         <ShipRegion>OR</ShipRegion>  
  312.         <ShipPostalCode>97827</ShipPostalCode>  
  313.         <ShipCountry>USA</ShipCountry>  
  314.       </ShipInfo>  
  315.     </Order>  
  316.     <Order>  
  317.       <CustomerID>LAZYK</CustomerID>  
  318.       <EmployeeID>1</EmployeeID>  
  319.       <OrderDate>1997-03-21T00:00:00</OrderDate>  
  320.       <RequiredDate>1997-04-18T00:00:00</RequiredDate>  
  321.       <ShipInfo ShippedDate="1997-04-10T00:00:00">  
  322.         <ShipVia>3</ShipVia>  
  323.         <Freight>7.48</Freight>  
  324.         <ShipName>Lazy K Kountry Store</ShipName>  
  325.         <ShipAddress>12 Orchestra Terrace</ShipAddress>  
  326.         <ShipCity>Walla Walla</ShipCity>  
  327.         <ShipRegion>WA</ShipRegion>  
  328.         <ShipPostalCode>99362</ShipPostalCode>  
  329.         <ShipCountry>USA</ShipCountry>  
  330.       </ShipInfo>  
  331.     </Order>  
  332.     <Order>  
  333.       <CustomerID>LAZYK</CustomerID>  
  334.       <EmployeeID>8</EmployeeID>  
  335.       <OrderDate>1997-05-22T00:00:00</OrderDate>  
  336.       <RequiredDate>1997-06-19T00:00:00</RequiredDate>  
  337.       <ShipInfo ShippedDate="1997-06-26T00:00:00">  
  338.         <ShipVia>2</ShipVia>  
  339.         <Freight>11.92</Freight>  
  340.         <ShipName>Lazy K Kountry Store</ShipName>  
  341.         <ShipAddress>12 Orchestra Terrace</ShipAddress>  
  342.         <ShipCity>Walla Walla</ShipCity>  
  343.         <ShipRegion>WA</ShipRegion>  
  344.         <ShipPostalCode>99362</ShipPostalCode>  
  345.         <ShipCountry>USA</ShipCountry>  
  346.       </ShipInfo>  
  347.     </Order>  
  348.     <Order>  
  349.       <CustomerID>LETSS</CustomerID>  
  350.       <EmployeeID>1</EmployeeID>  
  351.       <OrderDate>1997-06-25T00:00:00</OrderDate>  
  352.       <RequiredDate>1997-07-23T00:00:00</RequiredDate>  
  353.       <ShipInfo ShippedDate="1997-07-04T00:00:00">  
  354.         <ShipVia>2</ShipVia>  
  355.         <Freight>13.73</Freight>  
  356.         <ShipName>Let's Stop N Shop</ShipName>  
  357.         <ShipAddress>87 Polk St. Suite 5</ShipAddress>  
  358.         <ShipCity>San Francisco</ShipCity>  
  359.         <ShipRegion>CA</ShipRegion>  
  360.         <ShipPostalCode>94117</ShipPostalCode>  
  361.         <ShipCountry>USA</ShipCountry>  
  362.       </ShipInfo>  
  363.     </Order>  
  364.     <Order>  
  365.       <CustomerID>LETSS</CustomerID>  
  366.       <EmployeeID>8</EmployeeID>  
  367.       <OrderDate>1997-10-27T00:00:00</OrderDate>  
  368.       <RequiredDate>1997-11-24T00:00:00</RequiredDate>  
  369.       <ShipInfo ShippedDate="1997-11-05T00:00:00">  
  370.         <ShipVia>2</ShipVia>  
  371.         <Freight>51.44</Freight>  
  372.         <ShipName>Let's Stop N Shop</ShipName>  
  373.         <ShipAddress>87 Polk St. Suite 5</ShipAddress>  
  374.         <ShipCity>San Francisco</ShipCity>  
  375.         <ShipRegion>CA</ShipRegion>  
  376.         <ShipPostalCode>94117</ShipPostalCode>  
  377.         <ShipCountry>USA</ShipCountry>  
  378.       </ShipInfo>  
  379.     </Order>  
  380.     <Order>  
  381.       <CustomerID>LETSS</CustomerID>  
  382.       <EmployeeID>6</EmployeeID>  
  383.       <OrderDate>1997-11-10T00:00:00</OrderDate>  
  384.       <RequiredDate>1997-12-08T00:00:00</RequiredDate>  
  385.       <ShipInfo ShippedDate="1997-11-21T00:00:00">  
  386.         <ShipVia>2</ShipVia>  
  387.         <Freight>45.97</Freight>  
  388.         <ShipName>Let's Stop N Shop</ShipName>  
  389.         <ShipAddress>87 Polk St. Suite 5</ShipAddress>  
  390.         <ShipCity>San Francisco</ShipCity>  
  391.         <ShipRegion>CA</ShipRegion>  
  392.         <ShipPostalCode>94117</ShipPostalCode>  
  393.         <ShipCountry>USA</ShipCountry>  
  394.       </ShipInfo>  
  395.     </Order>  
  396.     <Order>  
  397.       <CustomerID>LETSS</CustomerID>  
  398.       <EmployeeID>4</EmployeeID>  
  399.       <OrderDate>1998-02-12T00:00:00</OrderDate>  
  400.       <RequiredDate>1998-03-12T00:00:00</RequiredDate>  
  401.       <ShipInfo ShippedDate="1998-02-13T00:00:00">  
  402.         <ShipVia>2</ShipVia>  
  403.         <Freight>90.97</Freight>  
  404.         <ShipName>Let's Stop N Shop</ShipName>  
  405.         <ShipAddress>87 Polk St. Suite 5</ShipAddress>  
  406.         <ShipCity>San Francisco</ShipCity>  
  407.         <ShipRegion>CA</ShipRegion>  
  408.         <ShipPostalCode>94117</ShipPostalCode>  
  409.         <ShipCountry>USA</ShipCountry>  
  410.       </ShipInfo>  
  411.     </Order>  
  412.   </Orders>  
  413. </Root>

Editor

You can edit this paste and save as new:


File Description
  • CustomersOrders
  • Paste Code
  • 23 May-2022
  • 15.94 Kb
You can Share it: