4. 打印
進行(xíng)相關參數(shù)設置後(指定打印機,設置模闆,設置打印數(shù)據),将指令通(tōng)過API傳給打印機。
Print: function (arr) {
var cfgData = new Object;
cfgData.XAction = "Print"
cfgData.XOpenId = m_OpenId;
cfgData.XTokens = m_Tokens;
/*指定打印機*/
cfgData.PrinterName = this.selected;
/*模闆方式,0-客戶端模闆,1-遠程模闆,
2-如果本地模闆存在,使用本地,不存在使用遠程模闆,3-不使用模闆*/
cfgData.TemplateMode = "1";
/*遠程模闆URL或本地模闆的文件夾*/
cfgData.TemplateURL = "http://img.51321.cn/web/chicore/VPrinting/API";
//cfgData.TemplateURL = "E:\\臨時(shí)數(shù)據\\打印\\打印樣本\\API标簽模闆";
/*模闆文件名*/
cfgData.TemplateName = "20220414x210x140Wire.Lblx";
/*打印數(shù)據的類型,0-數(shù)組,1-Json數(shù)組,元素為(wèi)JSON對象,字段:值*/
cfgData.PrintDataType = 1;
/*傳遞打印數(shù)據 Json數(shù)組*/ /*內(nèi)容不允許 半角的逗号及半角的分隔符*/
cfgData.PrintData = JSON.stringify(arr);
/*打印 發送給打印機進行(xíng)打印*/
CCPrintingAPI.Excute(cfgData,
XTimeout => { },
XFail => {
this.mytipsmessage = 'API可(kě)能未安裝或未啓動, ' + XFail;
},
XSuccess => {
var d = new Date;
this.timetick = d.getTime();
var apiResult = JSON.parse(XSuccess.trim());
if (apiResult.Status == "1") {
var smsg = apiResult.Message[0];
if (apiResult.Message.length > 1)
smsg += " : " + apiResult.Message[1]
this.mytipsmessage = smsg;
} else {
if (apiResult.Message.length > 1)
this.mytipsmessage = apiResult.Message[0] + " : " + apiResult.Message[1];
else
this.mytipsmessage = apiResult.Message[0];
}
}
);
}
4. 1 打印1
Print1:function(){
var arr = [
{E1861_CN_No_Id:"1",OrderID:"10258",CustomerID:"ERNSH",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-07-17 00:00:00",RequiredDate:"1996-08-14 00:00:00",ShippedDate:"1996-07-23 00:00:00",Freight:"140.51",ShipName:"Ernst Handel",ShipAddress:"Kirchgasse 6",ShipCity:"Graz",ShipRegion:"",ShipPostalCode:"8010",ShipCountry:"Austria"},
{E1861_CN_No_Id:"2",OrderID:"10270",CustomerID:"WARTH",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-08-01 00:00:00",RequiredDate:"1996-08-29 00:00:00",ShippedDate:"1996-08-02 00:00:00",Freight:"136.54",ShipName:"Wartian Herkku",ShipAddress:"Torikatu 38",ShipCity:"Oulu",ShipRegion:"",ShipPostalCode:"90110",ShipCountry:"Finland"},
{E1861_CN_No_Id:"3",OrderID:"10275",CustomerID:"MAGAA",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-08-07 00:00:00",RequiredDate:"1996-09-04 00:00:00",ShippedDate:"1996-08-09 00:00:00",Freight:"26.93",ShipName:"Magazzini Alimentari Riuniti",ShipAddress:"Via Ludovico il Moro 22",ShipCity:"Bergamo",ShipRegion:"",ShipPostalCode:"24100",ShipCountry:"Italy"},
{E1861_CN_No_Id:"4",OrderID:"10285",CustomerID:"QUICK",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-08-20 00:00:00",RequiredDate:"1996-09-17 00:00:00",ShippedDate:"1996-08-26 00:00:00",Freight:"76.83",ShipName:"QUICK-Stop",ShipAddress:"Taucherstraße 10",ShipCity:"Cunewalde",ShipRegion:"",ShipPostalCode:"01307",ShipCountry:"Germany"},
{E1861_CN_No_Id:"5",OrderID:"10292",CustomerID:"TRADH",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-08-28 00:00:00",RequiredDate:"1996-09-25 00:00:00",ShippedDate:"1996-09-02 00:00:00",Freight:"1.35",ShipName:"Tradiçao Hipermercados",ShipAddress:"Av. Inês de Castro 414",ShipCity:"Sao Paulo",ShipRegion:"SP",ShipPostalCode:"05634-030",ShipCountry:"Brazil"},
{E1861_CN_No_Id:"6",OrderID:"10293",CustomerID:"TORTU",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-08-29 00:00:00",RequiredDate:"1996-09-26 00:00:00",ShippedDate:"1996-09-11 00:00:00",Freight:"21.18",ShipName:"Tortuga Restaurante",ShipAddress:"Avda. Azteca 123",ShipCity:"México D.F.",ShipRegion:"",ShipPostalCode:"05033",ShipCountry:"Mexico"},
{E1861_CN_No_Id:"7",OrderID:"10304",CustomerID:"TORTU",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-09-12 00:00:00",RequiredDate:"1996-10-10 00:00:00",ShippedDate:"1996-09-17 00:00:00",Freight:"63.79",ShipName:"Tortuga Restaurante",ShipAddress:"Avda. Azteca 123",ShipCity:"México D.F.",ShipRegion:"",ShipPostalCode:"05033",ShipCountry:"Mexico"},
{E1861_CN_No_Id:"8",OrderID:"10306",CustomerID:"ROMEY",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-09-16 00:00:00",RequiredDate:"1996-10-14 00:00:00",ShippedDate:"1996-09-23 00:00:00",Freight:"7.56",ShipName:"Romero y tomillo",ShipAddress:"Gran Vía 1",ShipCity:"Madrid",ShipRegion:"",ShipPostalCode:"28001",ShipCountry:"Spain"},
{E1861_CN_No_Id:"9",OrderID:"10311",CustomerID:"DUMON",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-09-20 00:00:00",RequiredDate:"1996-10-04 00:00:00",ShippedDate:"1996-09-26 00:00:00",Freight:"24.69",ShipName:"Du monde entier",ShipAddress:"67 rue des Cinquante Otages",ShipCity:"Nantes",ShipRegion:"",ShipPostalCode:"44000",ShipCountry:"France"}
];
Print(arr);
}
4. 2 打印2
Print2:function(){
var arr = [
{E1861_CN_No_Id:"1",OrderID:"10258",CustomerID:"ERNSH",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-07-17 00:00:00",RequiredDate:"1996-08-14 00:00:00",ShippedDate:"1996-07-23 00:00:00",Freight:"140.51",ShipName:"Ernst Handel",ShipAddress:"Kirchgasse 6",ShipCity:"Graz",ShipRegion:"",ShipPostalCode:"8010",ShipCountry:"Austria"},
{E1861_CN_No_Id:"2",OrderID:"10270",CustomerID:"WARTH",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-08-01 00:00:00",RequiredDate:"1996-08-29 00:00:00",ShippedDate:"1996-08-02 00:00:00",Freight:"136.54",ShipName:"Wartian Herkku",ShipAddress:"Torikatu 38",ShipCity:"Oulu",ShipRegion:"",ShipPostalCode:"90110",ShipCountry:"Finland"},
{E1861_CN_No_Id:"3",OrderID:"10275",CustomerID:"MAGAA",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-08-07 00:00:00",RequiredDate:"1996-09-04 00:00:00",ShippedDate:"1996-08-09 00:00:00",Freight:"26.93",ShipName:"Magazzini Alimentari Riuniti",ShipAddress:"Via Ludovico il Moro 22",ShipCity:"Bergamo",ShipRegion:"",ShipPostalCode:"24100",ShipCountry:"Italy"},
{E1861_CN_No_Id:"4",OrderID:"10285",CustomerID:"QUICK",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-08-20 00:00:00",RequiredDate:"1996-09-17 00:00:00",ShippedDate:"1996-08-26 00:00:00",Freight:"76.83",ShipName:"QUICK-Stop",ShipAddress:"Taucherstraße 10",ShipCity:"Cunewalde",ShipRegion:"",ShipPostalCode:"01307",ShipCountry:"Germany"},
{E1861_CN_No_Id:"5",OrderID:"10292",CustomerID:"TRADH",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-08-28 00:00:00",RequiredDate:"1996-09-25 00:00:00",ShippedDate:"1996-09-02 00:00:00",Freight:"1.35",ShipName:"Tradiçao Hipermercados",ShipAddress:"Av. Inês de Castro 414",ShipCity:"Sao Paulo",ShipRegion:"SP",ShipPostalCode:"05634-030",ShipCountry:"Brazil"},
{E1861_CN_No_Id:"6",OrderID:"10293",CustomerID:"TORTU",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-08-29 00:00:00",RequiredDate:"1996-09-26 00:00:00",ShippedDate:"1996-09-11 00:00:00",Freight:"21.18",ShipName:"Tortuga Restaurante",ShipAddress:"Avda. Azteca 123",ShipCity:"México D.F.",ShipRegion:"",ShipPostalCode:"05033",ShipCountry:"Mexico"},
{E1861_CN_No_Id:"7",OrderID:"10304",CustomerID:"TORTU",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-09-12 00:00:00",RequiredDate:"1996-10-10 00:00:00",ShippedDate:"1996-09-17 00:00:00",Freight:"63.79",ShipName:"Tortuga Restaurante",ShipAddress:"Avda. Azteca 123",ShipCity:"México D.F.",ShipRegion:"",ShipPostalCode:"05033",ShipCountry:"Mexico"},
{E1861_CN_No_Id:"8",OrderID:"10306",CustomerID:"ROMEY",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-09-16 00:00:00",RequiredDate:"1996-10-14 00:00:00",ShippedDate:"1996-09-23 00:00:00",Freight:"7.56",ShipName:"Romero y tomillo",ShipAddress:"Gran Vía 1",ShipCity:"Madrid",ShipRegion:"",ShipPostalCode:"28001",ShipCountry:"Spain"},
{E1861_CN_No_Id:"9",OrderID:"10311",CustomerID:"DUMON",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-09-20 00:00:00",RequiredDate:"1996-10-04 00:00:00",ShippedDate:"1996-09-26 00:00:00",Freight:"24.69",ShipName:"Du monde entier",ShipAddress:"67 rue des Cinquante Otages",ShipCity:"Nantes",ShipRegion:"",ShipPostalCode:"44000",ShipCountry:"France"},
{E1861_CN_No_Id:"10",OrderID:"10314",CustomerID:"RATTC",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-09-25 00:00:00",RequiredDate:"1996-10-23 00:00:00",ShippedDate:"1996-10-04 00:00:00",Freight:"74.16",ShipName:"Rattlesnake Canyon Grocery",ShipAddress:"2817 Milton Dr.",ShipCity:"Albuquerque",ShipRegion:"NM",ShipPostalCode:"87110",ShipCountry:"USA"},
{E1861_CN_No_Id:"11",OrderID:"10316",CustomerID:"RATTC",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-09-27 00:00:00",RequiredDate:"1996-10-25 00:00:00",ShippedDate:"1996-10-08 00:00:00",Freight:"150.15",ShipName:"Rattlesnake Canyon Grocery",ShipAddress:"2817 Milton Dr.",ShipCity:"Albuquerque",ShipRegion:"NM",ShipPostalCode:"87110",ShipCountry:"USA"},
{E1861_CN_No_Id:"12",OrderID:"10325",CustomerID:"KOENE",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-10-09 00:00:00",RequiredDate:"1996-10-23 00:00:00",ShippedDate:"1996-10-14 00:00:00",Freight:"64.86",ShipName:"Königlich Essen",ShipAddress:"Maubelstr. 90",ShipCity:"Brandenburg",ShipRegion:"",ShipPostalCode:"14776",ShipCountry:"Germany"},
{E1861_CN_No_Id:"13",OrderID:"10340",CustomerID:"BONAP",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-10-29 00:00:00",RequiredDate:"1996-11-26 00:00:00",ShippedDate:"1996-11-08 00:00:00",Freight:"166.31",ShipName:"Bon app'",ShipAddress:"12 rue des Bouchers",ShipCity:"Marseille",ShipRegion:"",ShipPostalCode:"13008",ShipCountry:"France"},
{E1861_CN_No_Id:"14",OrderID:"10351",CustomerID:"ERNSH",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-11-11 00:00:00",RequiredDate:"1996-12-09 00:00:00",ShippedDate:"1996-11-20 00:00:00",Freight:"162.33",ShipName:"Ernst Handel",ShipAddress:"Kirchgasse 6",ShipCity:"Graz",ShipRegion:"",ShipPostalCode:"8010",ShipCountry:"Austria"},
{E1861_CN_No_Id:"15",OrderID:"10357",CustomerID:"LILAS",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-11-19 00:00:00",RequiredDate:"1996-12-17 00:00:00",ShippedDate:"1996-12-02 00:00:00",Freight:"34.88",ShipName:"LILA-Supermercado",ShipAddress:"Carrera 52 con Ave. Bolívar #65-98 Llano Largo",ShipCity:"Barquisimeto",ShipRegion:"Lara",ShipPostalCode:"3508",ShipCountry:"Venezuela"},
{E1861_CN_No_Id:"16",OrderID:"10361",CustomerID:"QUICK",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-11-22 00:00:00",RequiredDate:"1996-12-20 00:00:00",ShippedDate:"1996-12-03 00:00:00",Freight:"183.17",ShipName:"QUICK-Stop",ShipAddress:"Taucherstraße 10",ShipCity:"Cunewalde",ShipRegion:"",ShipPostalCode:"01307",ShipCountry:"Germany"},
{E1861_CN_No_Id:"17",OrderID:"10364",CustomerID:"EASTC",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-11-26 00:00:00",RequiredDate:"1997-01-07 00:00:00",ShippedDate:"1996-12-04 00:00:00",Freight:"71.97",ShipName:"Eastern Connection",ShipAddress:"35 King George",ShipCity:"London",ShipRegion:"",ShipPostalCode:"WX3 6FW",ShipCountry:"UK"},
{E1861_CN_No_Id:"18",OrderID:"10371",CustomerID:"LAMAI",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-12-03 00:00:00",RequiredDate:"1996-12-31 00:00:00",ShippedDate:"1996-12-24 00:00:00",Freight:"0.45",ShipName:"La maison d'Asie",ShipAddress:"1 rue Alsace-Lorraine",ShipCity:"Toulouse",ShipRegion:"",ShipPostalCode:"31000",ShipCountry:"France"},
{E1861_CN_No_Id:"19",OrderID:"10374",CustomerID:"WANDKX",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-12-05 00:00:00",RequiredDate:"1997-01-02 00:00:00",ShippedDate:"1996-12-09 00:00:00",Freight:"3.94",ShipName:"Wolski Zajazd",ShipAddress:"ul. Filtrowa 68",ShipCity:"Warszawa",ShipRegion:"",ShipPostalCode:"01-012",ShipCountry:"Poland"},
{E1861_CN_No_Id:"20",OrderID:"10376",CustomerID:"MEREP",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-12-09 00:00:00",RequiredDate:"1997-01-06 00:00:00",ShippedDate:"1996-12-13 00:00:00",Freight:"20.39",ShipName:"Mère Paillarde",ShipAddress:"43 rue St. Laurent",ShipCity:"Montréal",ShipRegion:"Québec",ShipPostalCode:"H1J 1C3",ShipCountry:"Canada"},
{E1861_CN_No_Id:"21",OrderID:"10377",CustomerID:"SEVES",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-12-09 00:00:00",RequiredDate:"1997-01-06 00:00:00",ShippedDate:"1996-12-13 00:00:00",Freight:"22.21",ShipName:"Seven Seas Imports",ShipAddress:"90 Wadhurst Rd.",ShipCity:"London",ShipRegion:"",ShipPostalCode:"OX15 4NB",ShipCountry:"UK"}
];
Print(arr);
}
4. 3 打印3
Print3:function(){
var arr = [
{E1861_CN_No_Id:"1",OrderID:"10258",CustomerID:"ERNSH",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-07-17 00:00:00",RequiredDate:"1996-08-14 00:00:00",ShippedDate:"1996-07-23 00:00:00",Freight:"140.51",ShipName:"Ernst Handel",ShipAddress:"Kirchgasse 6",ShipCity:"Graz",ShipRegion:"",ShipPostalCode:"8010",ShipCountry:"Austria"},
{E1861_CN_No_Id:"2",OrderID:"10270",CustomerID:"WARTH",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-08-01 00:00:00",RequiredDate:"1996-08-29 00:00:00",ShippedDate:"1996-08-02 00:00:00",Freight:"136.54",ShipName:"Wartian Herkku",ShipAddress:"Torikatu 38",ShipCity:"Oulu",ShipRegion:"",ShipPostalCode:"90110",ShipCountry:"Finland"},
{E1861_CN_No_Id:"3",OrderID:"10275",CustomerID:"MAGAA",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-08-07 00:00:00",RequiredDate:"1996-09-04 00:00:00",ShippedDate:"1996-08-09 00:00:00",Freight:"26.93",ShipName:"Magazzini Alimentari Riuniti",ShipAddress:"Via Ludovico il Moro 22",ShipCity:"Bergamo",ShipRegion:"",ShipPostalCode:"24100",ShipCountry:"Italy"},
{E1861_CN_No_Id:"4",OrderID:"10285",CustomerID:"QUICK",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-08-20 00:00:00",RequiredDate:"1996-09-17 00:00:00",ShippedDate:"1996-08-26 00:00:00",Freight:"76.83",ShipName:"QUICK-Stop",ShipAddress:"Taucherstraße 10",ShipCity:"Cunewalde",ShipRegion:"",ShipPostalCode:"01307",ShipCountry:"Germany"},
{E1861_CN_No_Id:"5",OrderID:"10292",CustomerID:"TRADH",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-08-28 00:00:00",RequiredDate:"1996-09-25 00:00:00",ShippedDate:"1996-09-02 00:00:00",Freight:"1.35",ShipName:"Tradiçao Hipermercados",ShipAddress:"Av. Inês de Castro 414",ShipCity:"Sao Paulo",ShipRegion:"SP",ShipPostalCode:"05634-030",ShipCountry:"Brazil"},
{E1861_CN_No_Id:"6",OrderID:"10293",CustomerID:"TORTU",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-08-29 00:00:00",RequiredDate:"1996-09-26 00:00:00",ShippedDate:"1996-09-11 00:00:00",Freight:"21.18",ShipName:"Tortuga Restaurante",ShipAddress:"Avda. Azteca 123",ShipCity:"México D.F.",ShipRegion:"",ShipPostalCode:"05033",ShipCountry:"Mexico"},
{E1861_CN_No_Id:"7",OrderID:"10304",CustomerID:"TORTU",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-09-12 00:00:00",RequiredDate:"1996-10-10 00:00:00",ShippedDate:"1996-09-17 00:00:00",Freight:"63.79",ShipName:"Tortuga Restaurante",ShipAddress:"Avda. Azteca 123",ShipCity:"México D.F.",ShipRegion:"",ShipPostalCode:"05033",ShipCountry:"Mexico"},
{E1861_CN_No_Id:"8",OrderID:"10306",CustomerID:"ROMEY",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-09-16 00:00:00",RequiredDate:"1996-10-14 00:00:00",ShippedDate:"1996-09-23 00:00:00",Freight:"7.56",ShipName:"Romero y tomillo",ShipAddress:"Gran Vía 1",ShipCity:"Madrid",ShipRegion:"",ShipPostalCode:"28001",ShipCountry:"Spain"},
{E1861_CN_No_Id:"9",OrderID:"10311",CustomerID:"DUMON",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-09-20 00:00:00",RequiredDate:"1996-10-04 00:00:00",ShippedDate:"1996-09-26 00:00:00",Freight:"24.69",ShipName:"Du monde entier",ShipAddress:"67 rue des Cinquante Otages",ShipCity:"Nantes",ShipRegion:"",ShipPostalCode:"44000",ShipCountry:"France"},
{E1861_CN_No_Id:"10",OrderID:"10314",CustomerID:"RATTC",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-09-25 00:00:00",RequiredDate:"1996-10-23 00:00:00",ShippedDate:"1996-10-04 00:00:00",Freight:"74.16",ShipName:"Rattlesnake Canyon Grocery",ShipAddress:"2817 Milton Dr.",ShipCity:"Albuquerque",ShipRegion:"NM",ShipPostalCode:"87110",ShipCountry:"USA"},
{E1861_CN_No_Id:"11",OrderID:"10316",CustomerID:"RATTC",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-09-27 00:00:00",RequiredDate:"1996-10-25 00:00:00",ShippedDate:"1996-10-08 00:00:00",Freight:"150.15",ShipName:"Rattlesnake Canyon Grocery",ShipAddress:"2817 Milton Dr.",ShipCity:"Albuquerque",ShipRegion:"NM",ShipPostalCode:"87110",ShipCountry:"USA"},
{E1861_CN_No_Id:"12",OrderID:"10325",CustomerID:"KOENE",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-10-09 00:00:00",RequiredDate:"1996-10-23 00:00:00",ShippedDate:"1996-10-14 00:00:00",Freight:"64.86",ShipName:"Königlich Essen",ShipAddress:"Maubelstr. 90",ShipCity:"Brandenburg",ShipRegion:"",ShipPostalCode:"14776",ShipCountry:"Germany"},
{E1861_CN_No_Id:"13",OrderID:"10340",CustomerID:"BONAP",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-10-29 00:00:00",RequiredDate:"1996-11-26 00:00:00",ShippedDate:"1996-11-08 00:00:00",Freight:"166.31",ShipName:"Bon app'",ShipAddress:"12 rue des Bouchers",ShipCity:"Marseille",ShipRegion:"",ShipPostalCode:"13008",ShipCountry:"France"},
{E1861_CN_No_Id:"14",OrderID:"10351",CustomerID:"ERNSH",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-11-11 00:00:00",RequiredDate:"1996-12-09 00:00:00",ShippedDate:"1996-11-20 00:00:00",Freight:"162.33",ShipName:"Ernst Handel",ShipAddress:"Kirchgasse 6",ShipCity:"Graz",ShipRegion:"",ShipPostalCode:"8010",ShipCountry:"Austria"},
{E1861_CN_No_Id:"15",OrderID:"10357",CustomerID:"LILAS",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-11-19 00:00:00",RequiredDate:"1996-12-17 00:00:00",ShippedDate:"1996-12-02 00:00:00",Freight:"34.88",ShipName:"LILA-Supermercado",ShipAddress:"Carrera 52 con Ave. Bolívar #65-98 Llano Largo",ShipCity:"Barquisimeto",ShipRegion:"Lara",ShipPostalCode:"3508",ShipCountry:"Venezuela"},
{E1861_CN_No_Id:"16",OrderID:"10361",CustomerID:"QUICK",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-11-22 00:00:00",RequiredDate:"1996-12-20 00:00:00",ShippedDate:"1996-12-03 00:00:00",Freight:"183.17",ShipName:"QUICK-Stop",ShipAddress:"Taucherstraße 10",ShipCity:"Cunewalde",ShipRegion:"",ShipPostalCode:"01307",ShipCountry:"Germany"},
{E1861_CN_No_Id:"17",OrderID:"10364",CustomerID:"EASTC",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-11-26 00:00:00",RequiredDate:"1997-01-07 00:00:00",ShippedDate:"1996-12-04 00:00:00",Freight:"71.97",ShipName:"Eastern Connection",ShipAddress:"35 King George",ShipCity:"London",ShipRegion:"",ShipPostalCode:"WX3 6FW",ShipCountry:"UK"},
{E1861_CN_No_Id:"18",OrderID:"10371",CustomerID:"LAMAI",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-12-03 00:00:00",RequiredDate:"1996-12-31 00:00:00",ShippedDate:"1996-12-24 00:00:00",Freight:"0.45",ShipName:"La maison d'Asie",ShipAddress:"1 rue Alsace-Lorraine",ShipCity:"Toulouse",ShipRegion:"",ShipPostalCode:"31000",ShipCountry:"France"},
{E1861_CN_No_Id:"19",OrderID:"10374",CustomerID:"WANDKX",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-12-05 00:00:00",RequiredDate:"1997-01-02 00:00:00",ShippedDate:"1996-12-09 00:00:00",Freight:"3.94",ShipName:"Wolski Zajazd",ShipAddress:"ul. Filtrowa 68",ShipCity:"Warszawa",ShipRegion:"",ShipPostalCode:"01-012",ShipCountry:"Poland"},
{E1861_CN_No_Id:"20",OrderID:"10376",CustomerID:"MEREP",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-12-09 00:00:00",RequiredDate:"1997-01-06 00:00:00",ShippedDate:"1996-12-13 00:00:00",Freight:"20.39",ShipName:"Mère Paillarde",ShipAddress:"43 rue St. Laurent",ShipCity:"Montréal",ShipRegion:"Québec",ShipPostalCode:"H1J 1C3",ShipCountry:"Canada"},
{E1861_CN_No_Id:"21",OrderID:"10377",CustomerID:"SEVES",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-12-09 00:00:00",RequiredDate:"1997-01-06 00:00:00",ShippedDate:"1996-12-13 00:00:00",Freight:"22.21",ShipName:"Seven Seas Imports",ShipAddress:"90 Wadhurst Rd.",ShipCity:"London",ShipRegion:"",ShipPostalCode:"OX15 4NB",ShipCountry:"UK"},
{E1861_CN_No_Id:"22",OrderID:"10385",CustomerID:"SPLIR",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-12-17 00:00:00",RequiredDate:"1997-01-14 00:00:00",ShippedDate:"1996-12-23 00:00:00",Freight:"30.96",ShipName:"Split Rail Beer & Ale",ShipAddress:"P.O. Box 555",ShipCity:"Lander",ShipRegion:"WY",ShipPostalCode:"82520",ShipCountry:"USA"},
{E1861_CN_No_Id:"23",OrderID:"10387",CustomerID:"SANTG",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-12-18 00:00:00",RequiredDate:"1997-01-15 00:00:00",ShippedDate:"1996-12-20 00:00:00",Freight:"93.63",ShipName:"Santé Gourmet",ShipAddress:"Erling Skakkes gate 78",ShipCity:"Stavern",ShipRegion:"",ShipPostalCode:"4110",ShipCountry:"Norway"},
{E1861_CN_No_Id:"24",OrderID:"10393",CustomerID:"SAVEA",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-12-25 00:00:00",RequiredDate:"1997-01-22 00:00:00",ShippedDate:"1997-01-03 00:00:00",Freight:"126.56",ShipName:"Save-a-lot Markets",ShipAddress:"187 Suffolk Ln.",ShipCity:"Boise",ShipRegion:"ID",ShipPostalCode:"83720",ShipCountry:"USA"},
{E1861_CN_No_Id:"25",OrderID:"10394",CustomerID:"HUNGC",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-12-25 00:00:00",RequiredDate:"1997-01-22 00:00:00",ShippedDate:"1997-01-03 00:00:00",Freight:"30.34",ShipName:"Hungry Coyote Import Store",ShipAddress:"City Center Plaza 516 Main St.",ShipCity:"Elgin",ShipRegion:"OR",ShipPostalCode:"97827",ShipCountry:"USA"},
{E1861_CN_No_Id:"26",OrderID:"10396",CustomerID:"FRANK",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1996-12-27 00:00:00",RequiredDate:"1997-01-10 00:00:00",ShippedDate:"1997-01-06 00:00:00",Freight:"135.35",ShipName:"Frankenversand",ShipAddress:"Berliner Platz 43",ShipCity:"München",ShipRegion:"",ShipPostalCode:"80805",ShipCountry:"Germany"},
{E1861_CN_No_Id:"27",OrderID:"10400",CustomerID:"EASTC",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1997-01-01 00:00:00",RequiredDate:"1997-01-29 00:00:00",ShippedDate:"1997-01-16 00:00:00",Freight:"83.93",ShipName:"Eastern Connection",ShipAddress:"35 King George",ShipCity:"London",ShipRegion:"",ShipPostalCode:"WX3 6FW",ShipCountry:"UK"},
{E1861_CN_No_Id:"28",OrderID:"10401",CustomerID:"RATTC",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1997-01-01 00:00:00",RequiredDate:"1997-01-29 00:00:00",ShippedDate:"1997-01-10 00:00:00",Freight:"12.51",ShipName:"Rattlesnake Canyon Grocery",ShipAddress:"2817 Milton Dr.",ShipCity:"Albuquerque",ShipRegion:"NM",ShipPostalCode:"87110",ShipCountry:"USA"},
{E1861_CN_No_Id:"29",OrderID:"10405",CustomerID:"LINOD",EmployeeID:"1",EmployeeIDX:"1000001",FirstName:"Nancy",LastName:"Davolio",OrderDate:"1997-01-06 00:00:00",RequiredDate:"1997-02-03 00:00:00",ShippedDate:"1997-01-22 00:00:00",Freight:"34.82",ShipName:"LINO-Delicateses",ShipAddress:"Ave. 5 de Mayo Porlamar",ShipCity:"I. de Margarita",ShipRegion:"Nueva Esparta",ShipPostalCode:"4980",ShipCountry:"Venezuela"},
{E1861_CN_No_Id:"186",OrderID:"10846",CustomerID:"SUPRD",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-01-22 00:00:00",RequiredDate:"1998-03-05 00:00:00",ShippedDate:"1998-01-23 00:00:00",Freight:"56.46",ShipName:"Suprêmes délices",ShipAddress:"Boulevard Tirou 255",ShipCity:"Charleroi",ShipRegion:"",ShipPostalCode:"B-6000",ShipCountry:"Belgium"},
{E1861_CN_No_Id:"187",OrderID:"10858",CustomerID:"LACOR",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-01-29 00:00:00",RequiredDate:"1998-02-26 00:00:00",ShippedDate:"1998-02-03 00:00:00",Freight:"52.51",ShipName:"La corne d'abondance",ShipAddress:"67 avenue de l'Europe",ShipCity:"Versailles",ShipRegion:"",ShipPostalCode:"78000",ShipCountry:"France"},
{E1861_CN_No_Id:"188",OrderID:"10865",CustomerID:"QUICK",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-02-02 00:00:00",RequiredDate:"1998-02-16 00:00:00",ShippedDate:"1998-02-12 00:00:00",Freight:"348.14",ShipName:"QUICK-Stop",ShipAddress:"Taucherstraße 10",ShipCity:"Cunewalde",ShipRegion:"",ShipPostalCode:"01307",ShipCountry:"Germany"},
{E1861_CN_No_Id:"189",OrderID:"10912",CustomerID:"HUNGO",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-02-26 00:00:00",RequiredDate:"1998-03-26 00:00:00",ShippedDate:"1998-03-18 00:00:00",Freight:"580.91",ShipName:"Hungry Owl All-Night Grocers",ShipAddress:"8 Johnstown Road",ShipCity:"Cork",ShipRegion:"Co. Cork",ShipPostalCode:"",ShipCountry:"Ireland"},
{E1861_CN_No_Id:"190",OrderID:"10915",CustomerID:"TORTU",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-02-27 00:00:00",RequiredDate:"1998-03-27 00:00:00",ShippedDate:"1998-03-02 00:00:00",Freight:"3.51",ShipName:"Tortuga Restaurante",ShipAddress:"Avda. Azteca 123",ShipCity:"México D.F.",ShipRegion:"",ShipPostalCode:"05033",ShipCountry:"Mexico"},
{E1861_CN_No_Id:"191",OrderID:"10919",CustomerID:"LINOD",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-03-02 00:00:00",RequiredDate:"1998-03-30 00:00:00",ShippedDate:"1998-03-04 00:00:00",Freight:"19.8",ShipName:"LINO-Delicateses",ShipAddress:"Ave. 5 de Mayo Porlamar",ShipCity:"I. de Margarita",ShipRegion:"Nueva Esparta",ShipPostalCode:"4980",ShipCountry:"Venezuela"},
{E1861_CN_No_Id:"192",OrderID:"10939",CustomerID:"MAGAA",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-03-10 00:00:00",RequiredDate:"1998-04-07 00:00:00",ShippedDate:"1998-03-13 00:00:00",Freight:"76.33",ShipName:"Magazzini Alimentari Riuniti",ShipAddress:"Via Ludovico il Moro 22",ShipCity:"Bergamo",ShipRegion:"",ShipPostalCode:"24100",ShipCountry:"Italy"},
{E1861_CN_No_Id:"193",OrderID:"10949",CustomerID:"BOTTM",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-03-13 00:00:00",RequiredDate:"1998-04-10 00:00:00",ShippedDate:"1998-03-17 00:00:00",Freight:"74.44",ShipName:"Bottom-Dollar Markets",ShipAddress:"23 Tsawassen Blvd.",ShipCity:"Tsawassen",ShipRegion:"BC",ShipPostalCode:"T2F 8M4",ShipCountry:"Canada"},
{E1861_CN_No_Id:"194",OrderID:"10967",CustomerID:"TOMSP",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-03-23 00:00:00",RequiredDate:"1998-04-20 00:00:00",ShippedDate:"1998-04-02 00:00:00",Freight:"62.22",ShipName:"Toms Spezialitäten",ShipAddress:"Luisenstr. 48",ShipCity:"Münster",ShipRegion:"",ShipPostalCode:"44087",ShipCountry:"Germany"},
{E1861_CN_No_Id:"195",OrderID:"10971",CustomerID:"FRANR",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-03-24 00:00:00",RequiredDate:"1998-04-21 00:00:00",ShippedDate:"1998-04-02 00:00:00",Freight:"121.82",ShipName:"France restauration",ShipAddress:"54 rue Royale",ShipCity:"Nantes",ShipRegion:"",ShipPostalCode:"44000",ShipCountry:"France"},
{E1861_CN_No_Id:"196",OrderID:"10982",CustomerID:"BOTTM",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-03-27 00:00:00",RequiredDate:"1998-04-24 00:00:00",ShippedDate:"1998-04-08 00:00:00",Freight:"14.01",ShipName:"Bottom-Dollar Markets",ShipAddress:"23 Tsawassen Blvd.",ShipCity:"Tsawassen",ShipRegion:"BC",ShipPostalCode:"T2F 8M4",ShipCountry:"Canada"},
{E1861_CN_No_Id:"197",OrderID:"10983",CustomerID:"SAVEA",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-03-27 00:00:00",RequiredDate:"1998-04-24 00:00:00",ShippedDate:"1998-04-06 00:00:00",Freight:"657.54",ShipName:"Save-a-lot Markets",ShipAddress:"187 Suffolk Ln.",ShipCity:"Boise",ShipRegion:"ID",ShipPostalCode:"83720",ShipCountry:"USA"},
{E1861_CN_No_Id:"198",OrderID:"10985",CustomerID:"HUNGO",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-03-30 00:00:00",RequiredDate:"1998-04-27 00:00:00",ShippedDate:"1998-04-02 00:00:00",Freight:"91.51",ShipName:"Hungry Owl All-Night Grocers",ShipAddress:"8 Johnstown Road",ShipCity:"Cork",ShipRegion:"Co. Cork",ShipPostalCode:"",ShipCountry:"Ireland"},
{E1861_CN_No_Id:"199",OrderID:"10989",CustomerID:"QUEDE",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-03-31 00:00:00",RequiredDate:"1998-04-28 00:00:00",ShippedDate:"1998-04-02 00:00:00",Freight:"34.76",ShipName:"Que Delícia",ShipAddress:"Rua da Panificadora 12",ShipCity:"Rio de Janeiro",ShipRegion:"RJ",ShipPostalCode:"02389-673",ShipCountry:"Brazil"},
{E1861_CN_No_Id:"200",OrderID:"10990",CustomerID:"ERNSH",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-01 00:00:00",RequiredDate:"1998-05-13 00:00:00",ShippedDate:"1998-04-07 00:00:00",Freight:"117.61",ShipName:"Ernst Handel",ShipAddress:"Kirchgasse 6",ShipCity:"Graz",ShipRegion:"",ShipPostalCode:"8010",ShipCountry:"Austria"},
{E1861_CN_No_Id:"201",OrderID:"10994",CustomerID:"VAFFE",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-02 00:00:00",RequiredDate:"1998-04-16 00:00:00",ShippedDate:"1998-04-09 00:00:00",Freight:"65.53",ShipName:"Vaffeljernet",ShipAddress:"Smagsloget 45",ShipCity:"Århus",ShipRegion:"",ShipPostalCode:"8200",ShipCountry:"Denmark"},
{E1861_CN_No_Id:"202",OrderID:"11000",CustomerID:"RATTC",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-06 00:00:00",RequiredDate:"1998-05-04 00:00:00",ShippedDate:"1998-04-14 00:00:00",Freight:"55.12",ShipName:"Rattlesnake Canyon Grocery",ShipAddress:"2817 Milton Dr.",ShipCity:"Albuquerque",ShipRegion:"NM",ShipPostalCode:"87110",ShipCountry:"USA"},
{E1861_CN_No_Id:"203",OrderID:"11001",CustomerID:"FOLKO",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-06 00:00:00",RequiredDate:"1998-05-04 00:00:00",ShippedDate:"1998-04-14 00:00:00",Freight:"197.3",ShipName:"Folk och fä HB",ShipAddress:"Åkergatan 24",ShipCity:"Bräcke",ShipRegion:"",ShipPostalCode:"S-844 67",ShipCountry:"Sweden"},
{E1861_CN_No_Id:"204",OrderID:"11005",CustomerID:"WILMK",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-07 00:00:00",RequiredDate:"1998-05-05 00:00:00",ShippedDate:"1998-04-10 00:00:00",Freight:"0.75",ShipName:"Wilman Kala",ShipAddress:"Keskuskatu 45",ShipCity:"Helsinki",ShipRegion:"",ShipPostalCode:"21240",ShipCountry:"Finland"},
{E1861_CN_No_Id:"205",OrderID:"11009",CustomerID:"GODOS",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-08 00:00:00",RequiredDate:"1998-05-06 00:00:00",ShippedDate:"1998-04-10 00:00:00",Freight:"59.11",ShipName:"Godos Cocina Típica",ShipAddress:"C/ Romero 33",ShipCity:"Sevilla",ShipRegion:"",ShipPostalCode:"41101",ShipCountry:"Spain"},
{E1861_CN_No_Id:"206",OrderID:"11010",CustomerID:"REGGC",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-09 00:00:00",RequiredDate:"1998-05-07 00:00:00",ShippedDate:"1998-04-21 00:00:00",Freight:"28.71",ShipName:"Reggiani Caseifici",ShipAddress:"Strada Provinciale 124",ShipCity:"Reggio Emilia",ShipRegion:"",ShipPostalCode:"42100",ShipCountry:"Italy"},
{E1861_CN_No_Id:"207",OrderID:"11013",CustomerID:"ROMEY",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-09 00:00:00",RequiredDate:"1998-05-07 00:00:00",ShippedDate:"1998-04-10 00:00:00",Freight:"32.99",ShipName:"Romero y tomillo",ShipAddress:"Gran Vía 1",ShipCity:"Madrid",ShipRegion:"",ShipPostalCode:"28001",ShipCountry:"Spain"},
{E1861_CN_No_Id:"208",OrderID:"11014",CustomerID:"LINOD",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-10 00:00:00",RequiredDate:"1998-05-08 00:00:00",ShippedDate:"1998-04-15 00:00:00",Freight:"23.6",ShipName:"LINO-Delicateses",ShipAddress:"Ave. 5 de Mayo Porlamar",ShipCity:"I. de Margarita",ShipRegion:"Nueva Esparta",ShipPostalCode:"4980",ShipCountry:"Venezuela"},
{E1861_CN_No_Id:"209",OrderID:"11015",CustomerID:"SANTG",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-10 00:00:00",RequiredDate:"1998-04-24 00:00:00",ShippedDate:"1998-04-20 00:00:00",Freight:"4.62",ShipName:"Santé Gourmet",ShipAddress:"Erling Skakkes gate 78",ShipCity:"Stavern",ShipRegion:"",ShipPostalCode:"4110",ShipCountry:"Norway"},
{E1861_CN_No_Id:"210",OrderID:"11020",CustomerID:"OTTIK",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-14 00:00:00",RequiredDate:"1998-05-12 00:00:00",ShippedDate:"1998-04-16 00:00:00",Freight:"43.3",ShipName:"Ottilies Käseladen",ShipAddress:"Mehrheimerstr. 369",ShipCity:"Köln",ShipRegion:"",ShipPostalCode:"50739",ShipCountry:"Germany"},
{E1861_CN_No_Id:"211",OrderID:"11028",CustomerID:"KOENE",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-16 00:00:00",RequiredDate:"1998-05-14 00:00:00",ShippedDate:"1998-04-22 00:00:00",Freight:"29.59",ShipName:"Königlich Essen",ShipAddress:"Maubelstr. 90",ShipCity:"Brandenburg",ShipRegion:"",ShipPostalCode:"14776",ShipCountry:"Germany"},
{E1861_CN_No_Id:"212",OrderID:"11032",CustomerID:"WHITC",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-17 00:00:00",RequiredDate:"1998-05-15 00:00:00",ShippedDate:"1998-04-23 00:00:00",Freight:"606.19",ShipName:"White Clover Markets",ShipAddress:"1029 - 12th Ave. S.",ShipCity:"Seattle",ShipRegion:"WA",ShipPostalCode:"98124",ShipCountry:"USA"},
{E1861_CN_No_Id:"213",OrderID:"11035",CustomerID:"SUPRD",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-20 00:00:00",RequiredDate:"1998-05-18 00:00:00",ShippedDate:"1998-04-24 00:00:00",Freight:"0.17",ShipName:"Suprêmes délices",ShipAddress:"Boulevard Tirou 255",ShipCity:"Charleroi",ShipRegion:"",ShipPostalCode:"B-6000",ShipCountry:"Belgium"},
{E1861_CN_No_Id:"214",OrderID:"11042",CustomerID:"COMMI",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-22 00:00:00",RequiredDate:"1998-05-06 00:00:00",ShippedDate:"1998-05-01 00:00:00",Freight:"29.99",ShipName:"Comércio Mineiro",ShipAddress:"Av. dos Lusíadas 23",ShipCity:"Sao Paulo",ShipRegion:"SP",ShipPostalCode:"05432-043",ShipCountry:"Brazil"},
{E1861_CN_No_Id:"215",OrderID:"11053",CustomerID:"PICCO",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-27 00:00:00",RequiredDate:"1998-05-25 00:00:00",ShippedDate:"1998-04-29 00:00:00",Freight:"53.05",ShipName:"Piccolo und mehr",ShipAddress:"Geislweg 14",ShipCity:"Salzburg",ShipRegion:"",ShipPostalCode:"5020",ShipCountry:"Austria"},
{E1861_CN_No_Id:"216",OrderID:"11059",CustomerID:"RICAR",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-29 00:00:00",RequiredDate:"1998-06-10 00:00:00",ShippedDate:"",Freight:"85.8",ShipName:"Ricardo Adocicados",ShipAddress:"Av. Copacabana 267",ShipCity:"Rio de Janeiro",ShipRegion:"RJ",ShipPostalCode:"02389-890",ShipCountry:"Brazil"},
{E1861_CN_No_Id:"217",OrderID:"11060",CustomerID:"FRANS",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-04-30 00:00:00",RequiredDate:"1998-05-28 00:00:00",ShippedDate:"1998-05-04 00:00:00",Freight:"10.98",ShipName:"Franchi S.p.A.",ShipAddress:"Via Monte Bianco 34",ShipCity:"Torino",ShipRegion:"",ShipPostalCode:"10100",ShipCountry:"Italy"},
{E1861_CN_No_Id:"218",OrderID:"11070",CustomerID:"LEHMS",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-05-05 00:00:00",RequiredDate:"1998-06-02 00:00:00",ShippedDate:"",Freight:"136",ShipName:"Lehmanns Marktstand",ShipAddress:"Magazinweg 7",ShipCity:"Frankfurt a.M.",ShipRegion:"",ShipPostalCode:"60528",ShipCountry:"Germany"},
{E1861_CN_No_Id:"219",OrderID:"11073",CustomerID:"PERIC",EmployeeID:"2",EmployeeIDX:"1000002",FirstName:"Andrew",LastName:"Fuller",OrderDate:"1998-05-05 00:00:00",RequiredDate:"1998-06-02 00:00:00",ShippedDate:"",Freight:"24.95",ShipName:"Pericles Comidas clásicas",ShipAddress:"Calle Dr. Jorge Cash 321",ShipCity:"México D.F.",ShipRegion:"",ShipPostalCode:"05033",ShipCountry:"Mexico"}
];
Print(arr);
}