Skip to content

Instantly share code, notes, and snippets.

@jimmyps

jimmyps/SalesOrderHeaders_Includes.json Secret

Created August 10, 2015 10:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jimmyps/f2e3968436ca1e66d2fd to your computer and use it in GitHub Desktop.
Save jimmyps/f2e3968436ca1e66d2fd to your computer and use it in GitHub Desktop.
Download ZIP
Order data with Includes
Raw
SalesOrderHeaders_Includes.json
{
"$id": "1",
"$type": "Intersoft.Data.WebApi.QueryResult, Intersoft.Data.WebApi.v4",
"AffectedRows": null,
"InlineCount": null,
"Results": [
{
"$id": "2",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "3",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 1092,
"AddressLine1": "99700 Bell Road",
"AddressLine2": null,
"City": "Auburn",
"StateProvince": "California",
"CountryRegion": "United States",
"PostalCode": "95603",
"rowguid": "79cdd89c-3c91-48db-8277-46d04aad7251",
"ModifiedDate": "2002-09-01T00:00:00.000",
"CompleteAddress": "99700 Bell Road\nAuburn, California"
},
"Customer": {
"$id": "4",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29847,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "David",
"MiddleName": null,
"LastName": "Hodgson",
"Suffix": null,
"CompanyName": "Good Toys",
"SalesPerson": "adventure-works\\linda3",
"EmailAddress": "david16@adventure-works.com",
"Phone": "969-555-0117",
"PasswordHash": "+gtwbVycsIIj2loVtrHNRN6IBLl20lQpRK8+JhzxyEo=",
"PasswordSalt": "AwqZdYk=",
"rowguid": "fdd7d9cb-9a81-40fc-baf6-facde8da4923",
"ModifiedDate": "2002-09-01T00:00:00.000"
},
"SalesOrderID": 71774,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71774",
"PurchaseOrderNumber": "PO348186287",
"AccountNumber": "10-4020-000609",
"CustomerID": 29847,
"ShipToAddressID": 1092,
"BillToAddressID": 1092,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 70.4279,
"Freight": 22.0087,
"Comment": null,
"rowguid": "89e42cdc-8506-48a2-b89b-eb3e64e3554e",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "5",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "6",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 640,
"AddressLine1": "251 The Metro Center",
"AddressLine2": "",
"City": "Wokingham",
"StateProvince": "England",
"CountryRegion": "United Kingdom",
"PostalCode": "RG41 1QW",
"rowguid": "0e4ac5bb-be0d-4a96-a58e-064daec08e1a",
"ModifiedDate": "2003-09-01T00:00:00.000",
"CompleteAddress": "251 The Metro Center\nWokingham, England"
},
"Customer": {
"$id": "7",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 30072,
"NameStyle": false,
"Title": "Ms.",
"FirstName": "Andrea",
"MiddleName": "A.",
"LastName": "Thomsen",
"Suffix": "",
"CompanyName": "West Side Mart",
"SalesPerson": "adventure-works\\jae0",
"EmailAddress": "andrea1@adventure-works.com",
"Phone": "1 (11) 500 555-0120",
"PasswordHash": "LDoJwsGCFLtxVdbdQBbN/to7zFF1skP+hWLrIrCxvAw=",
"PasswordSalt": "NuexV8w=",
"rowguid": "9bbbddc1-8e1a-4edf-aa2f-a8abea78c940",
"ModifiedDate": "2003-09-01T00:00:00.000"
},
"SalesOrderID": 71776,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-01T00:00:00.000",
"ShipDate": null,
"Status": 4,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71776",
"PurchaseOrderNumber": "PO19952192051",
"AccountNumber": "10-4020-000106",
"CustomerID": 30072,
"ShipToAddressID": 640,
"BillToAddressID": 640,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 6.3048,
"Freight": 1.9703,
"Comment": null,
"rowguid": "8a3448c5-e677-4158-a29b-dd33069be0b0",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "8",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "9",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 653,
"AddressLine1": "Burgess Hill",
"AddressLine2": "Edward Way",
"City": "West Sussex",
"StateProvince": "England",
"CountryRegion": "United Kingdom",
"PostalCode": "RH15 9UD",
"rowguid": "38cc8647-b4bb-4669-b21d-c7497e76478d",
"ModifiedDate": "2002-09-01T00:00:00.000",
"CompleteAddress": "Burgess Hill\nWest Sussex, England"
},
"Customer": {
"$id": "10",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 30113,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Raja",
"MiddleName": "D.",
"LastName": "Venugopal",
"Suffix": null,
"CompanyName": "Nearby Cycle Shop",
"SalesPerson": "adventure-works\\jae0",
"EmailAddress": "raja0@adventure-works.com",
"Phone": "1 (11) 500 555-0195",
"PasswordHash": "lx5a4+AFGzH6mzjz6hpiR9scxbYGX8OcqFpv/cI6yFs=",
"PasswordSalt": "hSwmBWk=",
"rowguid": "84975c44-dc82-49d3-bfc4-8f31b4c8e994",
"ModifiedDate": "2002-09-01T00:00:00.000"
},
"SalesOrderID": 71780,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71780",
"PurchaseOrderNumber": "PO19604173239",
"AccountNumber": "10-4020-000340",
"CustomerID": 30113,
"ShipToAddressID": 653,
"BillToAddressID": 653,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 3073.4952,
"Freight": 960.4672,
"Comment": null,
"rowguid": "a47665d2-7ac9-4cf3-8a8b-2a3883554284",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "11",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "12",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 1086,
"AddressLine1": "57251 Serene Blvd",
"AddressLine2": null,
"City": "Van Nuys",
"StateProvince": "California",
"CountryRegion": "United States",
"PostalCode": "91411",
"rowguid": "7df3a412-f2b3-4abb-88e1-21d4677f1311",
"ModifiedDate": "2003-09-01T00:00:00.000",
"CompleteAddress": "57251 Serene Blvd\nVan Nuys, California"
},
"Customer": {
"$id": "13",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29485,
"NameStyle": false,
"Title": "Ms.",
"FirstName": "Catherine",
"MiddleName": "R.",
"LastName": "Abel",
"Suffix": null,
"CompanyName": "Professional Sales and Service",
"SalesPerson": "adventure-works\\linda3",
"EmailAddress": "catherine0@adventure-works.com",
"Phone": "747-555-0171",
"PasswordHash": "zh3goJUbYsPv92k4bVZuJtlLHwuvpQtu6uNcjkKSdF8=",
"PasswordSalt": "rpyd5Tw=",
"rowguid": "392ae773-d7ec-48ac-b8d0-6e65b770285c",
"ModifiedDate": "2005-05-16T16:33:33.077"
},
"SalesOrderID": 71782,
"RevisionNumber": 4,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": null,
"Status": 6,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71782",
"PurchaseOrderNumber": "PO19372114749",
"AccountNumber": "10-4020-000582",
"CustomerID": 29485,
"ShipToAddressID": 1086,
"BillToAddressID": 1086,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 3182.8264,
"Freight": 994.6333,
"Comment": null,
"rowguid": "f1be45a5-5c57-4a50-93c6-5f8be44cb7cb",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "14",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "15",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 992,
"AddressLine1": "9992 Whipple Rd",
"AddressLine2": null,
"City": "Union City",
"StateProvince": "California",
"CountryRegion": "United States",
"PostalCode": "94587",
"rowguid": "88258a1b-b50f-440f-93b9-5d7af831d5fc",
"ModifiedDate": "2002-09-01T00:00:00.000",
"CompleteAddress": "9992 Whipple Rd\nUnion City, California"
},
"Customer": {
"$id": "16",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29957,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Kevin",
"MiddleName": null,
"LastName": "Liu",
"Suffix": null,
"CompanyName": "Eastside Department Store",
"SalesPerson": "adventure-works\\linda3",
"EmailAddress": "kevin5@adventure-works.com",
"Phone": "926-555-0164",
"PasswordHash": "ylTpkIOHKLcjihNjS0j/k10eOHOsWQMNhlbuOCp+UTY=",
"PasswordSalt": "TgZnUOg=",
"rowguid": "e115475e-25da-4139-8256-934f48c8453d",
"ModifiedDate": "2002-09-01T00:00:00.000"
},
"SalesOrderID": 71783,
"RevisionNumber": 4,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": null,
"Status": 6,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71783",
"PurchaseOrderNumber": "PO19343113609",
"AccountNumber": "10-4020-000024",
"CustomerID": 29957,
"ShipToAddressID": 992,
"BillToAddressID": 992,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 6708.6741,
"Freight": 2096.4607,
"Comment": null,
"rowguid": "7db2329e-6446-42a8-8915-9c8370b68ed8",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "17",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "18",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 659,
"AddressLine1": "Warrington Ldc Unit 25/2",
"AddressLine2": null,
"City": "Woolston",
"StateProvince": "England",
"CountryRegion": "United Kingdom",
"PostalCode": "WA1 4SY",
"rowguid": "f44a7d0d-9bc5-427e-b3ae-f638dd5804b0",
"ModifiedDate": "2003-09-01T00:00:00.000",
"CompleteAddress": "Warrington Ldc Unit 25/2\nWoolston, England"
},
"Customer": {
"$id": "19",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29736,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Terry",
"MiddleName": null,
"LastName": "Eminhizer",
"Suffix": null,
"CompanyName": "Action Bicycle Specialists",
"SalesPerson": "adventure-works\\jae0",
"EmailAddress": "terry1@adventure-works.com",
"Phone": "1 (11) 500 555-0176",
"PasswordHash": "y8RaWYkfTrcpFEipLXAyKC2pL8AJgQhpW2mOmZ8sqF4=",
"PasswordSalt": "vx5Ko/Q=",
"rowguid": "2252470b-71f6-4077-a744-613525a2df0d",
"ModifiedDate": "2003-09-01T00:00:00.000"
},
"SalesOrderID": 71784,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71784",
"PurchaseOrderNumber": "PO19285135919",
"AccountNumber": "10-4020-000448",
"CustomerID": 29736,
"ShipToAddressID": 659,
"BillToAddressID": 659,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 8684.9465,
"Freight": 2714.0458,
"Comment": null,
"rowguid": "ca31f324-2c32-4f8d-95eb-596e7f343027",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "20",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "21",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 1058,
"AddressLine1": "Riverside",
"AddressLine2": null,
"City": "Sherman Oaks",
"StateProvince": "California",
"CountryRegion": "United States",
"PostalCode": "91403",
"rowguid": "a26100f0-511f-45a2-879a-ff365794fcf5",
"ModifiedDate": "2003-09-01T00:00:00.000",
"CompleteAddress": "Riverside\nSherman Oaks, California"
},
"Customer": {
"$id": "22",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29660,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Anthony",
"MiddleName": null,
"LastName": "Chor",
"Suffix": null,
"CompanyName": "Extreme Riding Supplies",
"SalesPerson": "adventure-works\\linda3",
"EmailAddress": "anthony0@adventure-works.com",
"Phone": "429-555-0145",
"PasswordHash": "8C7859RNaDWPJkDaaxgaJaZPSf7ikFyFa//RYOz0aPo=",
"PasswordSalt": "tAAs8Fk=",
"rowguid": "e24193f1-f5df-481e-ac1a-bab86bd72c54",
"ModifiedDate": "2003-09-01T00:00:00.000"
},
"SalesOrderID": 71796,
"RevisionNumber": 5,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-10T00:00:00.000",
"ShipDate": null,
"Status": 2,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71796",
"PurchaseOrderNumber": "PO17052159664",
"AccountNumber": "10-4020-000420",
"CustomerID": 29660,
"ShipToAddressID": 1058,
"BillToAddressID": 1058,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 4610.7707,
"Freight": 1440.8659,
"Comment": null,
"rowguid": "917ef5ba-f32d-4563-8588-66db0bcdc846",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "23",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "24",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 642,
"AddressLine1": "Galashiels",
"AddressLine2": "",
"City": "Liverpool",
"StateProvince": "England",
"CountryRegion": "United Kingdom",
"PostalCode": "L4 4HB",
"rowguid": "3593cdf3-38ec-4847-ad42-157220e68f32",
"ModifiedDate": "2003-09-01T00:00:00.000",
"CompleteAddress": "Galashiels\nLiverpool, England"
},
"Customer": {
"$id": "25",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29796,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Jon",
"MiddleName": null,
"LastName": "Grande",
"Suffix": null,
"CompanyName": "Riding Cycles",
"SalesPerson": "adventure-works\\jae0",
"EmailAddress": "jon1@adventure-works.com",
"Phone": "1 (11) 500 555-0114",
"PasswordHash": "26rwIeR9oyfo+P6lodeASP/MAC2/tdKFbmFVC5uBRmA=",
"PasswordSalt": "83inWt0=",
"rowguid": "a580dd97-441a-4cf8-9d9e-7e1ebe6cec43",
"ModifiedDate": "2003-09-01T00:00:00.000"
},
"SalesOrderID": 71797,
"RevisionNumber": 5,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-03T00:00:00.000",
"ShipDate": null,
"Status": 2,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71797",
"PurchaseOrderNumber": "PO16501134889",
"AccountNumber": "10-4020-000142",
"CustomerID": 29796,
"ShipToAddressID": 642,
"BillToAddressID": 642,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 6242.3752,
"Freight": 1950.7422,
"Comment": null,
"rowguid": "bb3fee84-c8bf-4dd2-bcca-675ab6a11c38",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "26",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "27",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 1034,
"AddressLine1": "Oxnard Outlet",
"AddressLine2": null,
"City": "Oxnard",
"StateProvince": "California",
"CountryRegion": "United States",
"PostalCode": "93030",
"rowguid": "300d2a6e-67b4-417b-83a9-2026818a21c6",
"ModifiedDate": "2003-09-01T00:00:00.000",
"CompleteAddress": "Oxnard Outlet\nOxnard, California"
},
"Customer": {
"$id": "28",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 30089,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Michael John",
"MiddleName": "R.",
"LastName": "Troyer",
"Suffix": null,
"CompanyName": "Thrifty Parts and Sales",
"SalesPerson": "adventure-works\\linda3",
"EmailAddress": "michaeljohn0@adventure-works.com",
"Phone": "308-555-0175",
"PasswordHash": "Gdklarx2tW1EtZEyrAUEIhhguzrFKVS4Bh3BdAsGngk=",
"PasswordSalt": "HUE+JKI=",
"rowguid": "8d6af1e8-5082-4e5c-9f15-dfd04e64fd95",
"ModifiedDate": "2003-09-01T00:00:00.000"
},
"SalesOrderID": 71815,
"RevisionNumber": 4,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": null,
"Status": 2,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71815",
"PurchaseOrderNumber": "PO13021155785",
"AccountNumber": "10-4020-000276",
"CustomerID": 30089,
"ShipToAddressID": 1034,
"BillToAddressID": 1034,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 91.3263,
"Freight": 28.5395,
"Comment": null,
"rowguid": "2aa5f39b-1096-4a4b-b17b-f10504a397ce",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "29",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "30",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 1038,
"AddressLine1": "123 Camelia Avenue",
"AddressLine2": null,
"City": "Oxnard",
"StateProvince": "California",
"CountryRegion": "United States",
"PostalCode": "93030",
"rowguid": "a86c8140-ad7d-4caa-9b40-4006bd9998e2",
"ModifiedDate": "2003-09-01T00:00:00.000",
"CompleteAddress": "123 Camelia Avenue\nOxnard, California"
},
"Customer": {
"$id": "31",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 30027,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Joseph",
"MiddleName": "P.",
"LastName": "Mitzner",
"Suffix": "Jr.",
"CompanyName": "Engineered Bike Systems",
"SalesPerson": "adventure-works\\shu0",
"EmailAddress": "joseph4@adventure-works.com",
"Phone": "129-555-0164",
"PasswordHash": "7obarvC3BHLIE/oFo0n+bkB/EZ03Zc8Vu+F2jpK/CNM=",
"PasswordSalt": "k6zgROU=",
"rowguid": "029c27b5-72e5-4024-a5fa-53bdb42b98bc",
"ModifiedDate": "2003-09-01T00:00:00.000"
},
"SalesOrderID": 71816,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71816",
"PurchaseOrderNumber": "PO12992180445",
"AccountNumber": "10-4020-000295",
"CustomerID": 30027,
"ShipToAddressID": 1038,
"BillToAddressID": 1038,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 271.8533,
"Freight": 84.9541,
"Comment": null,
"rowguid": "e3c189e7-98de-4c40-b6c2-0d1d13f9bb33",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "32",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "33",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 652,
"AddressLine1": "Wymbush",
"AddressLine2": null,
"City": "Milton Keynes",
"StateProvince": "England",
"CountryRegion": "United Kingdom",
"PostalCode": "MK8 8DF",
"rowguid": "54e20963-b0e9-41cf-ab7e-d50459a3325c",
"ModifiedDate": "2002-09-01T00:00:00.000",
"CompleteAddress": "Wymbush\nMilton Keynes, England"
},
"Customer": {
"$id": "34",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 30019,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Matthew",
"MiddleName": "J.",
"LastName": "Miller",
"Suffix": null,
"CompanyName": "Tachometers and Accessories",
"SalesPerson": "adventure-works\\jae0",
"EmailAddress": "matthew5@adventure-works.com",
"Phone": "1 (11) 500 555-0176",
"PasswordHash": "/hDOTbr9X/E4UE8H6wjOGHYZ6Gb8GDpmutPWgFTXQnc=",
"PasswordSalt": "eiCRDs8=",
"rowguid": "226d328b-23d4-4215-b9c4-3da08f2e68db",
"ModifiedDate": "2002-09-01T00:00:00.000"
},
"SalesOrderID": 71831,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71831",
"PurchaseOrderNumber": "PO10295111084",
"AccountNumber": "10-4020-000322",
"CustomerID": 30019,
"ShipToAddressID": 652,
"BillToAddressID": 652,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 161.3073,
"Freight": 50.4085,
"Comment": null,
"rowguid": "625d76fc-c26f-4149-bf24-939fb2bccd77",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "35",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "36",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 639,
"AddressLine1": "Garamonde Drive, Wymbush",
"AddressLine2": "PO Box 4023",
"City": "Milton Keynes",
"StateProvince": "England",
"CountryRegion": "United Kingdom",
"PostalCode": "MK8 8ZD",
"rowguid": "8f34cedd-fb6e-4814-b509-9965a31bc2e5",
"ModifiedDate": "2003-09-01T00:00:00.000",
"CompleteAddress": "Garamonde Drive, Wymbush\nMilton Keynes, England"
},
"Customer": {
"$id": "37",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29922,
"NameStyle": false,
"Title": "Ms.",
"FirstName": "Pamala",
"MiddleName": "M.",
"LastName": "Kotc",
"Suffix": null,
"CompanyName": "Closest Bicycle Store",
"SalesPerson": "adventure-works\\jae0",
"EmailAddress": "pamala0@adventure-works.com",
"Phone": "1 (11) 500 555-0173",
"PasswordHash": "3nXek8BFNaBhIi8CwSzQOVdo1ZthphI3kGbZTrt6jNM=",
"PasswordSalt": "/rh9tFs=",
"rowguid": "d532c98a-db1a-46d5-8f34-a2e2d63df722",
"ModifiedDate": "2003-09-01T00:00:00.000"
},
"SalesOrderID": 71832,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-01T00:00:00.000",
"ShipDate": null,
"Status": 3,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71832",
"PurchaseOrderNumber": "PO10353140756",
"AccountNumber": "10-4020-000088",
"CustomerID": 29922,
"ShipToAddressID": 639,
"BillToAddressID": 639,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 2862.0169,
"Freight": 894.3803,
"Comment": null,
"rowguid": "addb8620-432a-456e-8470-1bedd4bc3457",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "38",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "39",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 1020,
"AddressLine1": "251340 E. South St.",
"AddressLine2": null,
"City": "Cerritos",
"StateProvince": "California",
"CountryRegion": "United States",
"PostalCode": "90703",
"rowguid": "ba72737a-0827-46a8-af5b-971fd8464a87",
"ModifiedDate": "2001-09-01T00:00:00.000",
"CompleteAddress": "251340 E. South St.\nCerritos, California"
},
"Customer": {
"$id": "40",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29938,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Frank",
"MiddleName": null,
"LastName": "Campbell",
"Suffix": null,
"CompanyName": "Trailblazing Sports",
"SalesPerson": "adventure-works\\shu0",
"EmailAddress": "frank4@adventure-works.com",
"Phone": "491-555-0132",
"PasswordHash": "XKb/GbNNUPKesifxpBwavz3wz5Y3jbFPJgsBIVEFvO0=",
"PasswordSalt": "/9h1e7s=",
"rowguid": "8739bccd-a0f4-496d-875e-46963b2f9723",
"ModifiedDate": "2001-09-01T00:00:00.000"
},
"SalesOrderID": 71845,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71845",
"PurchaseOrderNumber": "PO2697119362",
"AccountNumber": "10-4020-000187",
"CustomerID": 29938,
"ShipToAddressID": 1020,
"BillToAddressID": 1020,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 3329.7641,
"Freight": 1040.5513,
"Comment": null,
"rowguid": "e68f7ee9-c581-45cd-9c4f-386aeda74d84",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "41",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "42",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 669,
"AddressLine1": "Internet House, 3399 Science Park",
"AddressLine2": null,
"City": "Cambridge",
"StateProvince": "England",
"CountryRegion": "United Kingdom",
"PostalCode": "CB4 4BZ",
"rowguid": "56baec2a-5cc5-4a90-bef9-ee57e82f2e69",
"ModifiedDate": "2002-12-01T00:00:00.000",
"CompleteAddress": "Internet House, 3399 Science Park\nCambridge, England"
},
"Customer": {
"$id": "43",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 30102,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Roger",
"MiddleName": null,
"LastName": "Van Houten",
"Suffix": null,
"CompanyName": "Sports Store",
"SalesPerson": "adventure-works\\jae0",
"EmailAddress": "roger2@adventure-works.com",
"Phone": "1 (11) 500 555-0110",
"PasswordHash": "C0yLsx6zITh7lXoIPgG1bl1t5II3nx4GYi/RaS1yB84=",
"PasswordSalt": "WnTAc/0=",
"rowguid": "0ee7e95d-f12d-4d0d-8c6e-c64a0dda719a",
"ModifiedDate": "2002-12-01T00:00:00.000"
},
"SalesOrderID": 71846,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71846",
"PurchaseOrderNumber": "PO2378131604",
"AccountNumber": "10-4020-000635",
"CustomerID": 30102,
"ShipToAddressID": 669,
"BillToAddressID": 669,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 196.3012,
"Freight": 61.3441,
"Comment": null,
"rowguid": "a86d90ad-d1c0-440d-9a57-5b763bf18234",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "44",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "45",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 1090,
"AddressLine1": "25130 South State Street",
"AddressLine2": null,
"City": "Sandy",
"StateProvince": "Utah",
"CountryRegion": "United States",
"PostalCode": "84070",
"rowguid": "cf3ae92a-3e66-4af0-b683-731826e89cd1",
"ModifiedDate": "2003-09-01T00:00:00.000",
"CompleteAddress": "25130 South State Street\nSandy, Utah"
},
"Customer": {
"$id": "46",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 30033,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Vassar",
"MiddleName": "J.",
"LastName": "Stern",
"Suffix": null,
"CompanyName": "Transport Bikes",
"SalesPerson": "adventure-works\\shu0",
"EmailAddress": "vassar0@adventure-works.com",
"Phone": "328-555-0123",
"PasswordHash": "nPkLkDdemKmfK3VexvRWH5zYyNzwcfvny8DxWGnicSw=",
"PasswordSalt": "hLswDiQ=",
"rowguid": "66193607-693c-4073-be28-78e3892141a2",
"ModifiedDate": "2003-09-01T00:00:00.000"
},
"SalesOrderID": 71856,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71856",
"PurchaseOrderNumber": "PO16530177647",
"AccountNumber": "10-4020-000601",
"CustomerID": 30033,
"ShipToAddressID": 1090,
"BillToAddressID": 1090,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 48.1756,
"Freight": 15.0549,
"Comment": null,
"rowguid": "05fee073-0640-4a3c-914d-fe4ae6da3d43",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "47",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "48",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 1019,
"AddressLine1": "4660 Rodeo Road",
"AddressLine2": null,
"City": "Santa Fe",
"StateProvince": "New Mexico",
"CountryRegion": "United States",
"PostalCode": "87501",
"rowguid": "4fe824c1-f1bc-48b6-a4fd-6b866d0d07c8",
"ModifiedDate": "2003-09-01T00:00:00.000",
"CompleteAddress": "4660 Rodeo Road\nSanta Fe, New Mexico"
},
"Customer": {
"$id": "49",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29653,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Pei",
"MiddleName": null,
"LastName": "Chow",
"Suffix": null,
"CompanyName": "Thrilling Bike Tours",
"SalesPerson": "adventure-works\\linda3",
"EmailAddress": "pei0@adventure-works.com",
"Phone": "789-555-0184",
"PasswordHash": "UVTWGfYZBU+ZmXLqhvqZFDwYXdtX14O87KHOHN36XDc=",
"PasswordSalt": "pI/k4Qw=",
"rowguid": "16ffb394-535a-428d-aa61-96863a7ac191",
"ModifiedDate": "2003-09-01T00:00:00.000"
},
"SalesOrderID": 71858,
"RevisionNumber": 3,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": null,
"Status": 1,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71858",
"PurchaseOrderNumber": "PO16153112278",
"AccountNumber": "10-4020-000186",
"CustomerID": 29653,
"ShipToAddressID": 1019,
"BillToAddressID": 1019,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 1105.8967,
"Freight": 345.5927,
"Comment": null,
"rowguid": "5ef091e1-a0af-437d-85ed-0b557c7923f7",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "50",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "51",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 1098,
"AddressLine1": "Po Box 252525",
"AddressLine2": null,
"City": "Santa Ana",
"StateProvince": "California",
"CountryRegion": "United States",
"PostalCode": "92701",
"rowguid": "7d2bd572-f8ab-435a-a47b-3a534d7d9cdc",
"ModifiedDate": "2002-09-01T00:00:00.000",
"CompleteAddress": "Po Box 252525\nSanta Ana, California"
},
"Customer": {
"$id": "52",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29975,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Walter",
"MiddleName": "J.",
"LastName": "Mays",
"Suffix": "Sr.",
"CompanyName": "Sports Products Store",
"SalesPerson": "adventure-works\\linda3",
"EmailAddress": "walter1@adventure-works.com",
"Phone": "245-555-0191",
"PasswordHash": "PubfC/rRrBqx4Duzd5die33tt0m74frlazigsOv3D7s=",
"PasswordSalt": "IZ6tF0Y=",
"rowguid": "77083660-ddc4-4f13-877d-9e49e0854079",
"ModifiedDate": "2002-09-01T00:00:00.000"
},
"SalesOrderID": 71863,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": null,
"Status": 1,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71863",
"PurchaseOrderNumber": "PO16124166561",
"AccountNumber": "10-4020-000649",
"CustomerID": 29975,
"ShipToAddressID": 1098,
"BillToAddressID": 1098,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 265.9421,
"Freight": 83.1069,
"Comment": null,
"rowguid": "3ed03b56-a4bf-4872-9471-bc6c7893eab7",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "53",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "54",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 643,
"AddressLine1": "Banbury",
"AddressLine2": null,
"City": "Oxon",
"StateProvince": "England",
"CountryRegion": "United Kingdom",
"PostalCode": "OX16 8RS",
"rowguid": "99ff4c64-b405-4ac1-85ed-49e4e60ef87f",
"ModifiedDate": "2002-09-01T00:00:00.000",
"CompleteAddress": "Banbury\nOxon, England"
},
"Customer": {
"$id": "55",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29644,
"NameStyle": false,
"Title": "Ms.",
"FirstName": "Brigid",
"MiddleName": "F.",
"LastName": "Cavendish",
"Suffix": null,
"CompanyName": "Vigorous Sports Store",
"SalesPerson": "adventure-works\\jae0",
"EmailAddress": "brigid0@adventure-works.com",
"Phone": "1 (11) 500 555-0178",
"PasswordHash": "20rlqqjWOPLBi7oYKBrHMzouHcYl6OknJcV+yc0zQKo=",
"PasswordSalt": "QS6UTS4=",
"rowguid": "d28aa7e1-f125-44ad-a121-544332c2254f",
"ModifiedDate": "2002-09-01T00:00:00.000"
},
"SalesOrderID": 71867,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71867",
"PurchaseOrderNumber": "PO13050111529",
"AccountNumber": "10-4020-000160",
"CustomerID": 29644,
"ShipToAddressID": 643,
"BillToAddressID": 643,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 84.7448,
"Freight": 26.4828,
"Comment": null,
"rowguid": "29743c1b-d3af-4cfe-bd2e-6de436e3398f",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "56",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "57",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 649,
"AddressLine1": "Knaves Beech Ind.",
"AddressLine2": null,
"City": "High Wycombe",
"StateProvince": "England",
"CountryRegion": "United Kingdom",
"PostalCode": "HP10 9QY",
"rowguid": "11fcff74-5c80-4b37-a842-45c765d96029",
"ModifiedDate": "2003-09-01T00:00:00.000",
"CompleteAddress": "Knaves Beech Ind.\nHigh Wycombe, England"
},
"Customer": {
"$id": "58",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29612,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Richard",
"MiddleName": "A.",
"LastName": "Byham",
"Suffix": null,
"CompanyName": "Channel Outlet",
"SalesPerson": "adventure-works\\jae0",
"EmailAddress": "richard2@adventure-works.com",
"Phone": "1 (11) 500 555-0138",
"PasswordHash": "adQ3TmZB28FhQvF2FntW1RInx5S+aOSvwpURQDLarr8=",
"PasswordSalt": "KoBtEoU=",
"rowguid": "768148e4-4d17-4b9b-86ca-76f5122fc107",
"ModifiedDate": "2003-09-01T00:00:00.000"
},
"SalesOrderID": 71885,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71885",
"PurchaseOrderNumber": "PO6119130779",
"AccountNumber": "10-4020-000268",
"CustomerID": 29612,
"ShipToAddressID": 649,
"BillToAddressID": 649,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 44.0309,
"Freight": 13.7597,
"Comment": null,
"rowguid": "caad090d-56a6-444e-af24-7bee7605f120",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "59",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "60",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 1014,
"AddressLine1": "25136 Jefferson Blvd.",
"AddressLine2": null,
"City": "Culver City",
"StateProvince": "California",
"CountryRegion": "United States",
"PostalCode": "90232",
"rowguid": "05196d3f-f726-4ab9-a66b-af87500846ad",
"ModifiedDate": "2002-09-01T00:00:00.000",
"CompleteAddress": "25136 Jefferson Blvd.\nCulver City, California"
},
"Customer": {
"$id": "61",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29584,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Walter",
"MiddleName": "J.",
"LastName": "Brian",
"Suffix": "IV",
"CompanyName": "Futuristic Bikes",
"SalesPerson": "adventure-works\\shu0",
"EmailAddress": "walter0@adventure-works.com",
"Phone": "163-555-0155",
"PasswordHash": "NN11OHHxrOm6r8lPyhXuBk13QMD+8tph5PIdJ4t0JmY=",
"PasswordSalt": "PiILPfc=",
"rowguid": "bd077add-f8f5-471c-a5fd-31a61303f41f",
"ModifiedDate": "2002-09-01T00:00:00.000"
},
"SalesOrderID": 71895,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71895",
"PurchaseOrderNumber": "PO3770176273",
"AccountNumber": "10-4020-000151",
"CustomerID": 29584,
"ShipToAddressID": 1014,
"BillToAddressID": 1014,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 19.7391,
"Freight": 6.1685,
"Comment": null,
"rowguid": "07a17c0a-7f9a-4413-a035-519e5a4573be",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "62",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "63",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 1026,
"AddressLine1": "955 E. County Line Rd.",
"AddressLine2": null,
"City": "Englewood",
"StateProvince": "Colorado",
"CountryRegion": "United States",
"PostalCode": "80110",
"rowguid": "17a96f13-8658-4f02-a557-2bc4463ade21",
"ModifiedDate": "2003-09-01T00:00:00.000",
"CompleteAddress": "955 E. County Line Rd.\nEnglewood, Colorado"
},
"Customer": {
"$id": "64",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29877,
"NameStyle": false,
"Title": "Ms.",
"FirstName": "Joyce",
"MiddleName": null,
"LastName": "Jarvis",
"Suffix": null,
"CompanyName": "Paints and Solvents Company",
"SalesPerson": "adventure-works\\shu0",
"EmailAddress": "joyce0@adventure-works.com",
"Phone": "458-555-0179",
"PasswordHash": "HdGP+FhhGf8dYBcwT4pIsPs6mdixGxg1UVN0kMtW2Jk=",
"PasswordSalt": "XdEyqf4=",
"rowguid": "c2e1e791-19c2-4e4b-81d1-96b98537fd41",
"ModifiedDate": "2003-09-01T00:00:00.000"
},
"SalesOrderID": 71897,
"RevisionNumber": 3,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": null,
"Status": 1,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71897",
"PurchaseOrderNumber": "PO4785152479",
"AccountNumber": "10-4020-000223",
"CustomerID": 29877,
"ShipToAddressID": 1026,
"BillToAddressID": 1026,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 1014.8712,
"Freight": 317.1472,
"Comment": null,
"rowguid": "f88b3458-e0cf-4248-9b72-1805351463b2",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "65",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "66",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 637,
"AddressLine1": "Phoenix Way, Cirencester",
"AddressLine2": null,
"City": "Gloucestershire",
"StateProvince": "England",
"CountryRegion": "United Kingdom",
"PostalCode": "GL7 1RY",
"rowguid": "10a3d496-881e-4042-bbd0-5802cf73a872",
"ModifiedDate": "2003-09-01T00:00:00.000",
"CompleteAddress": "Phoenix Way, Cirencester\nGloucestershire, England"
},
"Customer": {
"$id": "67",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29932,
"NameStyle": false,
"Title": "Ms.",
"FirstName": "Rebecca",
"MiddleName": null,
"LastName": "Laszlo",
"Suffix": null,
"CompanyName": "Instruments and Parts Company",
"SalesPerson": "adventure-works\\jae0",
"EmailAddress": "rebecca2@adventure-works.com",
"Phone": "1 (11) 500 555-0155",
"PasswordHash": "ox4SPBzzVPKyCVoIcZvkdVLtnQlKoDXCciBGcqVAfrI=",
"PasswordSalt": "n7ydrrc=",
"rowguid": "998bb200-e2ad-4e26-8266-ce8bf95ca4de",
"ModifiedDate": "2003-09-01T00:00:00.000"
},
"SalesOrderID": 71898,
"RevisionNumber": 3,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": null,
"Status": 1,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71898",
"PurchaseOrderNumber": "PO5713190501",
"AccountNumber": "10-4020-000052",
"CustomerID": 29932,
"ShipToAddressID": 637,
"BillToAddressID": 637,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 5118.4791,
"Freight": 1599.5247,
"Comment": null,
"rowguid": "96f84d24-3355-43d2-b5a3-55e97c17e58c",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "68",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "69",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 993,
"AddressLine1": "Corporate Office",
"AddressLine2": "",
"City": "El Segundo",
"StateProvince": "California",
"CountryRegion": "United States",
"PostalCode": "90245",
"rowguid": "6cccc74f-6389-4d08-8ed1-9079b42cf7ae",
"ModifiedDate": "2002-09-01T00:00:00.000",
"CompleteAddress": "Corporate Office\nEl Segundo, California"
},
"Customer": {
"$id": "70",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29568,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Donald",
"MiddleName": "L.",
"LastName": "Blanton",
"Suffix": null,
"CompanyName": "Coalition Bike Company",
"SalesPerson": "adventure-works\\shu0",
"EmailAddress": "donald0@adventure-works.com",
"Phone": "357-555-0161",
"PasswordHash": "pKYDelLBOZMO98GBzhMxBSzzE0gUYKx9dXzYTYNuBgw=",
"PasswordSalt": "jKtOaOw=",
"rowguid": "d8b39163-b4b4-428d-acd7-1df795d801dc",
"ModifiedDate": "2002-09-01T00:00:00.000"
},
"SalesOrderID": 71899,
"RevisionNumber": 3,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": null,
"Status": 1,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71899",
"PurchaseOrderNumber": "PO4582142611",
"AccountNumber": "10-4020-000025",
"CustomerID": 29568,
"ShipToAddressID": 993,
"BillToAddressID": 993,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 193.2538,
"Freight": 60.3918,
"Comment": null,
"rowguid": "31d41e8f-6f43-4cae-bee3-3cccb262f231",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "71",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "72",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 999,
"AddressLine1": "Receiving",
"AddressLine2": null,
"City": "Fullerton",
"StateProvince": "California",
"CountryRegion": "United States",
"PostalCode": "92831",
"rowguid": "93d3c32f-cc26-4f27-b91f-35a804554976",
"ModifiedDate": "2002-09-01T00:00:00.000",
"CompleteAddress": "Receiving\nFullerton, California"
},
"Customer": {
"$id": "73",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29929,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Jeffrey",
"MiddleName": null,
"LastName": "Kurtz",
"Suffix": null,
"CompanyName": "Many Bikes Store",
"SalesPerson": "adventure-works\\shu0",
"EmailAddress": "jeffrey3@adventure-works.com",
"Phone": "452-555-0179",
"PasswordHash": "zn3Nk0+i/zyvxFNh3OziN2Pxa3NfiIlVMJ9Ox86ytao=",
"PasswordSalt": "5MZXwF4=",
"rowguid": "ae0f0317-2254-4d4f-9f4d-b01bbb10b3a0",
"ModifiedDate": "2002-09-01T00:00:00.000"
},
"SalesOrderID": 71902,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71902",
"PurchaseOrderNumber": "PO5539125166",
"AccountNumber": "10-4020-000061",
"CustomerID": 29929,
"ShipToAddressID": 999,
"BillToAddressID": 999,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 5924.7046,
"Freight": 1851.4702,
"Comment": null,
"rowguid": "137850d6-efdf-4de1-920f-5757a86cdaaf",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "74",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "75",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 989,
"AddressLine1": "39933 Mission Oaks Blvd",
"AddressLine2": null,
"City": "Camarillo",
"StateProvince": "California",
"CountryRegion": "United States",
"PostalCode": "93010",
"rowguid": "8b1241ca-1db6-4f9d-861e-1d6cc3796443",
"ModifiedDate": "2003-09-01T00:00:00.000",
"CompleteAddress": "39933 Mission Oaks Blvd\nCamarillo, California"
},
"Customer": {
"$id": "76",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29638,
"NameStyle": false,
"Title": "Ms.",
"FirstName": "Rosmarie",
"MiddleName": "J.",
"LastName": "Carroll",
"Suffix": null,
"CompanyName": "Aerobic Exercise Company",
"SalesPerson": "adventure-works\\linda3",
"EmailAddress": "rosmarie0@adventure-works.com",
"Phone": "244-555-0112",
"PasswordHash": "OKT0scizCdIzymHHOtyJKQiC/fCILSooSZ8dQ2Y34VM=",
"PasswordSalt": "ihWf50M=",
"rowguid": "3611a221-a20a-463a-ac19-265db991ccc0",
"ModifiedDate": "2003-09-01T00:00:00.000"
},
"SalesOrderID": 71915,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71915",
"PurchaseOrderNumber": "PO2349143275",
"AccountNumber": "10-4020-000006",
"CustomerID": 29638,
"ShipToAddressID": 989,
"BillToAddressID": 989,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 170.9785,
"Freight": 53.4308,
"Comment": null,
"rowguid": "0bcb3d9c-9008-4b99-bb45-928adae7be6b",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "77",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "78",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 651,
"AddressLine1": "New Millhouse, 2583 Milton Park",
"AddressLine2": null,
"City": "Abingdon",
"StateProvince": "England",
"CountryRegion": "United Kingdom",
"PostalCode": "OX14 4SE",
"rowguid": "e844b847-b0b3-491d-a4f1-0b78f56e4424",
"ModifiedDate": "2003-09-01T00:00:00.000",
"CompleteAddress": "New Millhouse, 2583 Milton Park\nAbingdon, England"
},
"Customer": {
"$id": "79",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 30025,
"NameStyle": false,
"Title": "Ms.",
"FirstName": "Linda",
"MiddleName": null,
"LastName": "Mitchell",
"Suffix": null,
"CompanyName": "Essential Bike Works",
"SalesPerson": "adventure-works\\jae0",
"EmailAddress": "linda9@adventure-works.com",
"Phone": "1 (11) 500 555-0182",
"PasswordHash": "LJhS2DW9IscOBidp+dn6JWOa8axqqpEw2XIUiUMRKVM=",
"PasswordSalt": "hrRF3s4=",
"rowguid": "838acd04-5b60-459c-88cc-ef5d1d696e05",
"ModifiedDate": "2003-09-01T00:00:00.000"
},
"SalesOrderID": 71917,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71917",
"PurchaseOrderNumber": "PO29111718",
"AccountNumber": "10-4020-000304",
"CustomerID": 30025,
"ShipToAddressID": 651,
"BillToAddressID": 651,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 3.2724,
"Freight": 1.0226,
"Comment": null,
"rowguid": "6e903ea3-1b9e-4232-94c3-81c15669f830",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "80",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "81",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 1102,
"AddressLine1": "603 Gellert Blvd",
"AddressLine2": null,
"City": "Daly City",
"StateProvince": "California",
"CountryRegion": "United States",
"PostalCode": "94015",
"rowguid": "a8dcad62-8678-458c-87eb-e2c2e550ff80",
"ModifiedDate": "2001-12-01T00:00:00.000",
"CompleteAddress": "603 Gellert Blvd\nDaly City, California"
},
"Customer": {
"$id": "82",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29982,
"NameStyle": false,
"Title": "Ms.",
"FirstName": "Melissa",
"MiddleName": "R.",
"LastName": "Marple",
"Suffix": null,
"CompanyName": "Discount Tours",
"SalesPerson": "adventure-works\\shu0",
"EmailAddress": "melissa0@adventure-works.com",
"Phone": "685-555-0117",
"PasswordHash": "UbL/DUTnTSqLeeA4RQCXS5ofw+ATOi1iWyGfuy/PO6g=",
"PasswordSalt": "CAB+B+I=",
"rowguid": "da27541e-8f63-451d-8e58-ef11a02520a0",
"ModifiedDate": "2001-12-01T00:00:00.000"
},
"SalesOrderID": 71920,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71920",
"PurchaseOrderNumber": "PO4002189853",
"AccountNumber": "10-4020-000674",
"CustomerID": 29982,
"ShipToAddressID": 1102,
"BillToAddressID": 1102,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 238.4634,
"Freight": 74.5198,
"Comment": null,
"rowguid": "6228c9cb-1cab-4e32-98ca-d0dae5fe563e",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "83",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "84",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 1035,
"AddressLine1": "Vista Marketplace",
"AddressLine2": null,
"City": "Alhambra",
"StateProvince": "California",
"CountryRegion": "United States",
"PostalCode": "91801",
"rowguid": "7795fcdf-76c3-4627-86b2-0291398868de",
"ModifiedDate": "2002-09-01T00:00:00.000",
"CompleteAddress": "Vista Marketplace\nAlhambra, California"
},
"Customer": {
"$id": "85",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29781,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Guy",
"MiddleName": null,
"LastName": "Gilbert",
"Suffix": null,
"CompanyName": "The Bicycle Accessories Company",
"SalesPerson": "adventure-works\\shu0",
"EmailAddress": "guy0@adventure-works.com",
"Phone": "583-555-0198",
"PasswordHash": "YMhZzdS3NtxXPsz/PPksfdYWIvhuoemim9KoDsx20cg=",
"PasswordSalt": "rQoQs38=",
"rowguid": "68835187-35c9-4c57-a0cf-cb9eb2e713d7",
"ModifiedDate": "2002-09-01T00:00:00.000"
},
"SalesOrderID": 71923,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71923",
"PurchaseOrderNumber": "PO174173096",
"AccountNumber": "10-4020-000277",
"CustomerID": 29781,
"ShipToAddressID": 1035,
"BillToAddressID": 1035,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 8.5233,
"Freight": 2.6635,
"Comment": null,
"rowguid": "f9899f3f-b4b6-4756-b013-96c16be20427",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "86",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "87",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 1061,
"AddressLine1": "Eastern Beltway Center",
"AddressLine2": null,
"City": "Las Vegas",
"StateProvince": "Nevada",
"CountryRegion": "United States",
"PostalCode": "89106",
"rowguid": "84603598-f6d4-4e26-9b9e-6a468365d4d8",
"ModifiedDate": "2001-12-01T00:00:00.000",
"CompleteAddress": "Eastern Beltway Center\nLas Vegas, Nevada"
},
"Customer": {
"$id": "88",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29531,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Cory",
"MiddleName": "K.",
"LastName": "Booth",
"Suffix": null,
"CompanyName": "Remarkable Bike Store",
"SalesPerson": "adventure-works\\linda3",
"EmailAddress": "cory0@adventure-works.com",
"Phone": "121-555-0157",
"PasswordHash": "OfvFj11NFlpVFhEacTp7Nw+8EqwxHKIv9aJ+2ZgcUMI=",
"PasswordSalt": "XaJdIYM=",
"rowguid": "75d00aa7-752f-41c9-9c5d-899e8e3061bd",
"ModifiedDate": "2001-12-01T00:00:00.000"
},
"SalesOrderID": 71935,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71935",
"PurchaseOrderNumber": "PO7946145876",
"AccountNumber": "10-4020-000438",
"CustomerID": 29531,
"ShipToAddressID": 1061,
"BillToAddressID": 1061,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 530.7437,
"Freight": 165.8574,
"Comment": null,
"rowguid": "7033c6ec-b12c-45bc-bd96-56efde4c7dd0",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "89",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "90",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 662,
"AddressLine1": "Paramount House",
"AddressLine2": null,
"City": "London",
"StateProvince": "England",
"CountryRegion": "United Kingdom",
"PostalCode": "W1N 9FA",
"rowguid": "e50d1077-d135-41cc-a0b1-c53395f94541",
"ModifiedDate": "2002-09-01T00:00:00.000",
"CompleteAddress": "Paramount House\nLondon, England"
},
"Customer": {
"$id": "91",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 30050,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Krishna",
"MiddleName": null,
"LastName": "Sunkammurali",
"Suffix": null,
"CompanyName": "Metropolitan Bicycle Supply",
"SalesPerson": "adventure-works\\jae0",
"EmailAddress": "krishna1@adventure-works.com",
"Phone": "1 (11) 500 555-0177",
"PasswordHash": "rKKXHEQ/Zb5Z596gCAMQepmJHLIzJy+BpJaz5GSv31c=",
"PasswordSalt": "sEZH3m0=",
"rowguid": "2492e57f-c37b-4aeb-a038-c3f897111232",
"ModifiedDate": "2002-09-01T00:00:00.000"
},
"SalesOrderID": 71936,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71936",
"PurchaseOrderNumber": "PO8671170385",
"AccountNumber": "10-4020-000502",
"CustomerID": 30050,
"ShipToAddressID": 662,
"BillToAddressID": 662,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 7862.2953,
"Freight": 2456.9673,
"Comment": null,
"rowguid": "119db56a-a97e-414d-b41c-64886fc50ab7",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "92",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "93",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 635,
"AddressLine1": "93-2501, Blackfriars Road,",
"AddressLine2": null,
"City": "London",
"StateProvince": "England",
"CountryRegion": "United Kingdom",
"PostalCode": "SE1 8HL",
"rowguid": "00e75f99-488c-462d-a0bc-ac3c08a9db77",
"ModifiedDate": "2002-09-01T00:00:00.000",
"CompleteAddress": "93-2501, Blackfriars Road,\nLondon, England"
},
"Customer": {
"$id": "94",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29546,
"NameStyle": false,
"Title": "Mr.",
"FirstName": "Christopher",
"MiddleName": "R.",
"LastName": "Beck",
"Suffix": "Jr.",
"CompanyName": "Bulk Discount Store",
"SalesPerson": "adventure-works\\jae0",
"EmailAddress": "christopher1@adventure-works.com",
"Phone": "1 (11) 500 555-0132",
"PasswordHash": "sKt9daCzEEKWAzivEGPOp8tmaM1R3I+aJfcBjzJRFLo=",
"PasswordSalt": "8KfYx/4=",
"rowguid": "228a34a5-66ef-4a18-bef2-be74beb84191",
"ModifiedDate": "2002-09-01T00:00:00.000"
},
"SalesOrderID": 71938,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71938",
"PurchaseOrderNumber": "PO8468183315",
"AccountNumber": "10-4020-000016",
"CustomerID": 29546,
"ShipToAddressID": 635,
"BillToAddressID": 635,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 7105.0290,
"Freight": 2220.3216,
"Comment": null,
"rowguid": "a36ee74a-cf0d-4024-a1ce-4eaffd1f85f0",
"ModifiedDate": "2015-06-08T00:00:00.000"
},
{
"$id": "95",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"Address1": {
"$id": "96",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"AddressID": 660,
"AddressLine1": "6 The Farm, Liberty Road",
"AddressLine2": null,
"City": "Maidenhead",
"StateProvince": "England",
"CountryRegion": "United Kingdom",
"PostalCode": "SL67RJ",
"rowguid": "e22d616b-ea06-48e9-a00f-b1c4bb02f595",
"ModifiedDate": "2003-09-01T00:00:00.000",
"CompleteAddress": "6 The Farm, Liberty Road\nMaidenhead, England"
},
"Customer": {
"$id": "97",
"$type": "System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Object, mscorlib]], mscorlib",
"CustomerID": 29741,
"NameStyle": false,
"Title": "Sra.",
"FirstName": "Janeth",
"MiddleName": null,
"LastName": "Esteves",
"Suffix": null,
"CompanyName": "Central Bicycle Specialists",
"SalesPerson": "adventure-works\\jae0",
"EmailAddress": "janeth1@adventure-works.com",
"Phone": "1 (11) 500 555-0136",
"PasswordHash": "X1Y5qQtF/cCa0JcWV87/0KfmpSje5R9/RdWM+fyB7Go=",
"PasswordSalt": "+iF/Sqs=",
"rowguid": "7d8c6b41-4d65-4f2c-ab91-5fce276b5bf5",
"ModifiedDate": "2003-09-01T00:00:00.000"
},
"SalesOrderID": 71946,
"RevisionNumber": 2,
"OrderDate": "2015-06-01T00:00:00.000",
"DueDate": "2015-06-13T00:00:00.000",
"ShipDate": "2015-06-08T00:00:00.000",
"Status": 5,
"OnlineOrderFlag": false,
"SalesOrderNumber": "SO71946",
"PurchaseOrderNumber": "PO8961158629",
"AccountNumber": "10-4020-000466",
"CustomerID": 29741,
"ShipToAddressID": 660,
"BillToAddressID": 660,
"ShipMethod": "CARGO TRANSPORT 5",
"CreditCardApprovalCode": null,
"TaxAmt": 3.1163,
"Freight": 0.9738,
"Comment": null,
"rowguid": "10e3129d-657f-46f9-86f5-cedd79b1901c",
"ModifiedDate": "2015-06-08T00:00:00.000"
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment