Skip to content

Instantly share code, notes, and snippets.

@jimmyps

jimmyps/SalesOrderHeaders_ViewProjection.json Secret

Created August 10, 2015 11:40
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/ed2985415448d922c4dd to your computer and use it in GitHub Desktop.
Save jimmyps/ed2985415448d922c4dd to your computer and use it in GitHub Desktop.
Download ZIP
Order list with Crosslight view projection
Raw
SalesOrderHeaders_ViewProjection.json
{
"$id": "1",
"$type": "Intersoft.Data.WebApi.QueryResult, Intersoft.Data.WebApi.v4",
"AffectedRows": null,
"InlineCount": null,
"Results": [
{
"$id": "2",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "99700 Bell Road\nAuburn, California",
"CustomerCompany": "Good Toys",
"ProductQuantity": 2,
"SubTotal": 713.796
},
{
"$id": "3",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "251 The Metro Center\nWokingham, England",
"CustomerCompany": "West Side Mart",
"ProductQuantity": 1,
"SubTotal": 63.9
},
{
"$id": "4",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Burgess Hill\nWest Sussex, England",
"CustomerCompany": "Nearby Cycle Shop",
"ProductQuantity": 76,
"SubTotal": 29923.007999999998
},
{
"$id": "5",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "57251 Serene Blvd\nVan Nuys, California",
"CustomerCompany": "Professional Sales and Service",
"ProductQuantity": 140,
"SubTotal": 33319.986000000012
},
{
"$id": "6",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "9992 Whipple Rd\nUnion City, California",
"CustomerCompany": "Eastside Department Store",
"ProductQuantity": 286,
"SubTotal": 65683.367986
},
{
"$id": "7",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Warrington Ldc Unit 25/2\nWoolston, England",
"CustomerCompany": "Action Bicycle Specialists",
"ProductQuantity": 267,
"SubTotal": 89869.276314000032
},
{
"$id": "8",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Riverside\nSherman Oaks, California",
"CustomerCompany": "Extreme Riding Supplies",
"ProductQuantity": 60,
"SubTotal": 47848.026000000013
},
{
"$id": "9",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Galashiels\nLiverpool, England",
"CustomerCompany": "Riding Cycles",
"ProductQuantity": 271,
"SubTotal": 65123.463418000007
},
{
"$id": "10",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Oxnard Outlet\nOxnard, California",
"CustomerCompany": "Thrifty Parts and Sales",
"ProductQuantity": 5,
"SubTotal": 926.916
},
{
"$id": "11",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "123 Camelia Avenue\nOxnard, California",
"CustomerCompany": "Engineered Bike Systems",
"ProductQuantity": 13,
"SubTotal": 2847.4079999999994
},
{
"$id": "12",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Wymbush\nMilton Keynes, England",
"CustomerCompany": "Tachometers and Accessories",
"ProductQuantity": 9,
"SubTotal": 1712.946
},
{
"$id": "13",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Garamonde Drive, Wymbush\nMilton Keynes, England",
"CustomerCompany": "Closest Bicycle Store",
"ProductQuantity": 76,
"SubTotal": 28950.678108
},
{
"$id": "14",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "251340 E. South St.\nCerritos, California",
"CustomerCompany": "Trailblazing Sports",
"ProductQuantity": 77,
"SubTotal": 34118.5356
},
{
"$id": "15",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Internet House, 3399 Science Park\nCambridge, England",
"CustomerCompany": "Sports Store",
"ProductQuantity": 6,
"SubTotal": 1884.3948
},
{
"$id": "16",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "25130 South State Street\nSandy, Utah",
"CustomerCompany": "Transport Bikes",
"ProductQuantity": 2,
"SubTotal": 500.30400000000003
},
{
"$id": "17",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "4660 Rodeo Road\nSanta Fe, New Mexico",
"CustomerCompany": "Thrilling Bike Tours",
"ProductQuantity": 27,
"SubTotal": 11528.844000000001
},
{
"$id": "18",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Po Box 252525\nSanta Ana, California",
"CustomerCompany": "Sports Products Store",
"ProductQuantity": 22,
"SubTotal": 2777.1430760000003
},
{
"$id": "19",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Banbury\nOxon, England",
"CustomerCompany": "Vigorous Sports Store",
"ProductQuantity": 1,
"SubTotal": 858.9
},
{
"$id": "20",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Knaves Beech Ind.\nHigh Wycombe, England",
"CustomerCompany": "Channel Outlet",
"ProductQuantity": 12,
"SubTotal": 524.664
},
{
"$id": "21",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "25136 Jefferson Blvd.\nCulver City, California",
"CustomerCompany": "Futuristic Bikes",
"ProductQuantity": 7,
"SubTotal": 221.25600000000003
},
{
"$id": "22",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "955 E. County Line Rd.\nEnglewood, Colorado",
"CustomerCompany": "Paints and Solvents Company",
"ProductQuantity": 19,
"SubTotal": 10585.05
},
{
"$id": "23",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Phoenix Way, Cirencester\nGloucestershire, England",
"CustomerCompany": "Instruments and Parts Company",
"ProductQuantity": 81,
"SubTotal": 53248.692000000017
},
{
"$id": "24",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Corporate Office\nEl Segundo, California",
"CustomerCompany": "Coalition Bike Company",
"ProductQuantity": 11,
"SubTotal": 1856.2068
},
{
"$id": "25",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Receiving\nFullerton, California",
"CustomerCompany": "Many Bikes Store",
"ProductQuantity": 173,
"SubTotal": 59894.209199999976
},
{
"$id": "26",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "39933 Mission Oaks Blvd\nCamarillo, California",
"CustomerCompany": "Aerobic Exercise Company",
"ProductQuantity": 13,
"SubTotal": 1732.8899999999999
},
{
"$id": "27",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "New Millhouse, 2583 Milton Park\nAbingdon, England",
"CustomerCompany": "Essential Bike Works",
"ProductQuantity": 7,
"SubTotal": 37.758
},
{
"$id": "28",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "603 Gellert Blvd\nDaly City, California",
"CustomerCompany": "Discount Tours",
"ProductQuantity": 16,
"SubTotal": 2527.128
},
{
"$id": "29",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Vista Marketplace\nAlhambra, California",
"CustomerCompany": "The Bicycle Accessories Company",
"ProductQuantity": 19,
"SubTotal": 96.108824
},
{
"$id": "30",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Eastern Beltway Center\nLas Vegas, Nevada",
"CustomerCompany": "Remarkable Bike Store",
"ProductQuantity": 23,
"SubTotal": 5533.8689079999995
},
{
"$id": "31",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "Paramount House\nLondon, England",
"CustomerCompany": "Metropolitan Bicycle Supply",
"ProductQuantity": 197,
"SubTotal": 79589.616023999959
},
{
"$id": "32",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "93-2501, Blackfriars Road,\nLondon, England",
"CustomerCompany": "Bulk Discount Store",
"ProductQuantity": 167,
"SubTotal": 74160.228
},
{
"$id": "33",
"$type": "ViewProjectionSample.DomainModels.SalesOrderHeader, ViewProjectionSample.DomainModels",
"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",
"Address": null,
"Address1": null,
"Customer": null,
"SalesOrderDetails": [ ],
"ShipAddress": "6 The Farm, Liberty Road\nMaidenhead, England",
"CustomerCompany": "Central Bicycle Specialists",
"ProductQuantity": 1,
"SubTotal": 31.584
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment