|
A step-by-step walkthrough of using the unity system to access Fusion data.
First need to determine what view(s) I will need to access.
If I go to https://unity.karmak.io/ReportDataAccess.html and look through the various “cards” to look for the data that I need. For this exercise I’m going to use Parts Order (https://unity.karmak.io/Parts-Order.html).
Now that I have the view I want, I need to get the Unity details for this view. I go to https://unity.karmak.io/View-Properties.html and select the Fusion version(s) that correspond to the Dealer/Account I’m going to pull data from. For this exercise I’m going to use v3.58.30.0.
In the window that shows the details for that version I do a search for “PartsOrder”. (Just removed the space from the name of the view I selected)
This search brings me to the section for this View where a couple of important details are presented to me:
| Field | Value | Description |
|---|---|---|
| “Key” | “PartsOrder” | this is the text that I will use in my Unity call to retrieve data for this view (we need to improve our docs and at least include this information on https://unity.karmak.io/Parts-Order.html) |
| “DefaultSort” | “PartsOrderNumber” | if I don’t specify any sort criteria, the returned data will be sorted by this column (all Data Access results are sorted) |
| “DefaultPageSize” | 100 | if I don’t specify a page size (i.e. number of records to bring back at once) then this is the page size that will be used |
| “MaxPageSize” | 1000 | if I try to ask for an obscene amount of data because I only want to make one call and get all the things….this is the maximum amount of rows I can get back in one call |
| “Output” | this is an array stating the specific column names and data types that Unity will return for this view, this should closely match what is shown on (https://unity.karmak.io/Parts-Order.html) |
Now armed with this information I’m ready to make a call.
First I need to obtain a token, I review the instructions available at https://unity.karmak.io/Using-Unity.html
Here is a cURL example:
curl --location --request POST 'https://api.karmak.io/auth/connect/token' \
--header 'Content-Type: application/x-www-form-urlencoded ' \
--data-urlencode 'client_id=PUT_YOUR_CLIENT_ID_HERE' \
--data-urlencode 'client_secret=PUT_YOUR_CLIENT_SECRET_HERE' \
--data-urlencode 'grant_type=karmak_identity' \
--data-urlencode 'scope=api' \
--data-urlencode 'account=PUT_YOUR_ACCOUNT_GUID_HERE' \
--data-urlencode 'user=PUT_YOUR_USER_GUID_HERE' \
I get back a JSON response that contains three properties:
- “access_token”
- “expires_in”
- “token_type”
The “expires_in” property tells me how long, in seconds, this token is good for (currently this is set at one hour). The key piece of information is the “access_token”, I need to capture this crazy long string of characters (the whole thing) so I can include it with my next call(s).
Now that I have a token I can start getting data.
I prepare my HTTPS GET request by reviewing the instructions available at https://unity.karmak.io/Data-Access-API.html
I like to start with requesting the view without any additional parameters, this helps ensure the view is working, my token is valid, and gives me a peek at the data available.
Here is a cURL example:
curl --location --request GET 'https://api.karmak.io/api/unity/v1/unityapi/frw/PartsOrder' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer eyJhbGciOiJSUzI1NiIsThisIsFakeM1NDY0QkE0QzM1MDg2RENCMjYxNzczMzkzRjJFRTQ5MTg3MkI0RUQiLCJ0eXAiOiJhdCtqd3QiLCJ4NXQiOiJOVVpMcE1OUWh0eXlZWGN6a19MdVNSaHl0TzAifQ.eyJuYmYiOjE1ODQxMDIyNzThisIsFakeMTU4NDEwNTg3MywiaXNzIjoiaHR0cDovL3dlYi5jb3JlYXV0aDo5MDI1IiwiYXVkIjoiYXBpIiwiY2xpZW50X2lkIjoidW5pdHktcWEtaW50X2NsaWVudCIsInN1YiI6InVuaXR5LXFhLWludF9jbGllbnQiLCJhdXRoX3RpbWUiOjE1ODQxMDIyNzMsImlkcCI6ImxvY2FsIiwiWC1FbGstSWRlbnRpdHktQWNjb3VudCI6IjNkNWNjNjE2LWI5YTQtNGY0NC1hMjc1LTZlYzgzMDBkOTVhOSIsIlgtRWxrLUlkZW50aXR5LVVzZXIiOiJkZDk0OGNhOS1hNDI5LTQ2OTQtYTM0MC0xNmY3MGU2OTcxYTEiLCJhY2NvdW50IjoiM2Q1Y2M2MTYtYjlhNC00ZjQ0LWEyNzUtNmVjODMwMGQ5NWE5IiwidXNlciI6ImRkOTQ4Y2E5LWE0MjktNDY5NC1hMzQwLTE2ZjcwZTY5NzFhMSIsInJvbGUiOiIwMDAwMDAwMC0wMDAwLTAwMDAtMDAwMC0wMDAwMDAwMDAwMDAiLCJYLUVsay1JZGVudGl0eS1Sb2xlIjoiMDAwMDAwMDAtMDAwMC0wMDAwLTAwMDAtMDAwMDAwMDAwMDAwIiwic2VjdXJpdHlfcHJvZmlsZV91c2VyIjoiMmRkMWU1NTAtYmUyNC00OGY0LTlmY2EtODkyOGM2OWU1MWM4Iiwic2VjdXJpdHlfcHJvZmlsZV9hY2NvdW50IjoiMDAwMDAwMDEtMDAwMS0wMDAxLTAwMDEtMDAwMDAwMDAwMDAxIiwiWC1FbGstU2VjdXJpdHlQcm9maWxlLVVzZXIiOiIyZGQxZTU1MC1iZTI0LTQ4ZjQtOWZjYS04OTI4YzY5ZTUxYzgiLCJYLUVsay1TZWN1cmThisIsFakebGUtQWNjb3VudCI6IjAwMDAwMDAxLTAwMDEtMDAwMS0wMDAxLTAwMDAwMDAwMDAwMSIsImFkbWluIjoiYWRtaW4iLCJzY29wZSI6WyJhcGkiXSwiYW1yIjpbImthcm1hayJdfQ.b5JyILyBoK52QM2mptcClThisIsFakewCjwpbSiz9aotUbBYZiDkNFR4K9rSP_17KU_McEH1XDJkhwK1GBWjH9EmG26bZm6KjpxgEfuR2sMLp68H96eBEv-QunNpvgGblThisIsFake2kEknWruYSRu03fSpBPlAR-hOnms5ihZiCmwtZSEWNQ6z6B37LWsdQBDKt84SMJAgH4F_d6sfX1Iuo66jC65ZAGbmINcNeDJEC3kShNfoLw3J9SBztY2n78I5dnGOdfMigDTmoRL_5V0QYZso1bKHkRXKNVcvO2VO7JzzONd8SoxEq84JqficIUpd_OQV_kbfwIS5MKNsFw'
I get back data (hooray!) Here is an example response from our internal QA system:
[
{
"PartsSalesOrderID": 29414,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 1484,
"BillingCustomerID": 1484,
"TaxCodeID": 11,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 22400,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 4,
"JoinID": "81",
"CanadianTaxID": null,
"QuebecTaxID": null,
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 1,
"OrderStatus": "Invoiced",
"CreationDate": "2016-01-25T13:31:00.960",
"CustomerNumber": "7879",
"CompanyName": "7879",
"CustomerPO": "8569",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2016-01-25T13:31:00.873",
"InvoiceNumber": "81",
"LastUpdate": "2016-01-25T13:31:00.960",
"AddUser": "futuresakate",
"UpdateUser": "futuresakate",
"InvoiceUser": "futuresakate",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": " ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "7879",
"BillingCompanyName": "7879",
"TaxCode": "Taxable",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Adam Griffith",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": " ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "7879",
"ShipToAddress1": "1",
"ShipToAddress2": "",
"ShipToCity": "kar",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 10000.0000,
"ReplacementCost": 10000.0000,
"OrderSubtotal": 15000.00,
"OrderTotal": 15000.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 5000.0000,
"ReplacementCostGrossProfit": 5000.0000,
"AverageCostGrossProfitMargin": 0.333333,
"ReplacementCostGrossProfitMargin": 0.333333,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "cash",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 47679,
"BranchID": 5,
"DepartmentID": 3,
"CustomerID": 8486,
"BillingCustomerID": 8486,
"TaxCodeID": 11,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 32278,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 4,
"JoinID": "061",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "Inactive1",
"Department": "Parts",
"PartsOrderNumber": 1,
"OrderStatus": "Invoiced",
"CreationDate": "2018-06-13T15:05:47.320",
"CustomerNumber": "E0601399",
"CompanyName": "Gad5",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-06-13T15:06:16.353",
"InvoiceNumber": "061",
"LastUpdate": "2018-06-13T15:05:47.320",
"AddUser": "jschesvo",
"UpdateUser": "jschesvo",
"InvoiceUser": "jschesvo",
"BillingCustomerAccountStatus": "COD",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "E0601399",
"BillingCompanyName": "Gad5",
"TaxCode": "Taxable",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "DecisivJEB2 DecisivJEB2",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "Gad5",
"ShipToAddress1": "519 osage road",
"ShipToAddress2": "",
"ShipToCity": "willard",
"ShipToRegion": "IL",
"ShipToPostalCode": "65781",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "cmersch@karmak.com",
"AverageCost": 6.0000,
"ReplacementCost": 6.0000,
"OrderSubtotal": 10.50,
"OrderTotal": 10.50,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 4.5000,
"ReplacementCostGrossProfit": 4.5000,
"AverageCostGrossProfitMargin": 0.428571,
"ReplacementCostGrossProfitMargin": 0.428571,
"SalesTerritory": "",
"CustomerAccountStatus": "COD",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "1 - Offset",
"UserDefinedPaymentMethodID": 155,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 32029,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 1523,
"BillingCustomerID": 1523,
"TaxCodeID": 11,
"TaxBodyID": 14,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 24196,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 4,
"JoinID": "82",
"CanadianTaxID": null,
"QuebecTaxID": null,
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 2,
"OrderStatus": "Invoiced",
"CreationDate": "2016-08-30T07:47:42.227",
"CustomerNumber": "1231",
"CompanyName": "Petri Inc",
"CustomerPO": "ABC123",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2016-08-30T07:47:42.170",
"InvoiceNumber": "82",
"LastUpdate": "2016-08-30T07:47:42.227",
"AddUser": "ffjpetri",
"UpdateUser": "ffjpetri",
"InvoiceUser": "ffjpetri",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Al ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1231",
"BillingCompanyName": "Petri Inc",
"TaxCode": "Taxable",
"TaxBody": "Carlinville",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "naresh sharma",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Al ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Petri Inc",
"ShipToAddress1": "100 S Main St",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 90.0000,
"ReplacementCost": 90.0000,
"OrderSubtotal": 163.02,
"OrderTotal": 163.02,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 73.0200,
"ReplacementCostGrossProfit": 73.0200,
"AverageCostGrossProfitMargin": 0.447920,
"ReplacementCostGrossProfitMargin": 0.447920,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Billing Service Open ",
"UserDefinedPaymentMethodID": 113,
"StaticPaymentMethodID": 4,
"Territory": ""
},
{
"PartsSalesOrderID": 50614,
"BranchID": 5,
"DepartmentID": 3,
"CustomerID": 9692,
"BillingCustomerID": 9692,
"TaxCodeID": 11,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 23,
"SalesOrderStatusID": 1,
"JoinID": "50614",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "Inactive1",
"Department": "Parts",
"PartsOrderNumber": 2,
"OrderStatus": "In Process",
"CreationDate": "2018-11-26T15:23:03.067",
"CustomerNumber": "1625",
"CompanyName": "co name",
"CustomerPO": "",
"PickupDeliveryMethod": "~Pickup",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-11-26T15:23:03.067",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "COD",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "1625",
"BillingCompanyName": "co name",
"TaxCode": "Taxable",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "DecisivJEB2 DecisivJEB2",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "co name",
"ShipToAddress1": "123 main",
"ShipToAddress2": "",
"ShipToCity": "Farmington",
"ShipToRegion": "MO",
"ShipToPostalCode": "9999999999",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 11.0000,
"ReplacementCost": 11.0000,
"OrderSubtotal": 18.70,
"OrderTotal": 18.70,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 7.7000,
"ReplacementCostGrossProfit": 7.7000,
"AverageCostGrossProfitMargin": 0.411764,
"ReplacementCostGrossProfitMargin": 0.411764,
"SalesTerritory": "",
"CustomerAccountStatus": "COD",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "*cash open A/R",
"UserDefinedPaymentMethodID": 145,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 34709,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 973,
"BillingCustomerID": 973,
"TaxCodeID": 11,
"TaxBodyID": 41,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 24,
"SalesOrderStatusID": 1,
"JoinID": "34709",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 3,
"OrderStatus": "In Process",
"CreationDate": "2017-02-22T11:08:33.060",
"CustomerNumber": "00878",
"CompanyName": "FUTURE RADIO FLYER",
"CustomerPO": "1",
"PickupDeliveryMethod": "Express",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-08-28T16:51:04.020",
"AddUser": "futuresakate",
"UpdateUser": "karmak",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "William Lewis",
"BillingHomePhone": "",
"BillingWorkPhone": "CON-TAC-WORK",
"BillingCustomerNumber": "00878",
"BillingCompanyName": "FUTURE RADIO FLYER",
"TaxCode": "Taxable",
"TaxBody": "Ontario",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "naresh sharma",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "William Lewis",
"ContactHomePhone": "",
"ContactWorkPhone": "CON-TAC-WORK",
"ShipToCustomerName": "FUTURE RADIO FLYER - CARLINVILLE 62626 F/C",
"ShipToAddress1": "ST Address Line 1",
"ShipToAddress2": "ST Addresss line 2",
"ShipToCity": "carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "(217) 854-4721",
"ShipToFax": null,
"ShipToShopPhone": "800-222-shop",
"ShipToEmail": null,
"AverageCost": 18.8800,
"ReplacementCost": 24.0000,
"OrderSubtotal": 26.00,
"OrderTotal": 29.38,
"SalesTaxTotal": 3.38,
"AverageCostGrossProfit": 7.1200,
"ReplacementCostGrossProfit": 2.0000,
"AverageCostGrossProfitMargin": 0.273846,
"ReplacementCostGrossProfitMargin": 0.076923,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 37103,
"BranchID": 15,
"DepartmentID": 1,
"CustomerID": 1700,
"BillingCustomerID": 1700,
"TaxCodeID": 11,
"TaxBodyID": 37,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 26802,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 5,
"JoinID": "084",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "G&AA",
"PartsOrderNumber": 4,
"OrderStatus": "Invoiced",
"CreationDate": "2017-06-20T13:24:22.093",
"CustomerNumber": "3676",
"CompanyName": "KLBKR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-06-20T13:24:21.970",
"InvoiceNumber": "084",
"LastUpdate": "2017-06-20T13:25:58.173",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Lori R",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "KLBKR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "St Louis City TEST",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Lori R",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Robinson's Trucking",
"ShipToAddress1": "#1 Paradise Ave",
"ShipToAddress2": "",
"ShipToCity": "St Louis",
"ShipToRegion": "MO",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "lrobinson@karmak.com",
"AverageCost": 15.0000,
"ReplacementCost": 15.0000,
"OrderSubtotal": 150.00,
"OrderTotal": 150.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 135.0000,
"ReplacementCostGrossProfit": 135.0000,
"AverageCostGrossProfitMargin": 0.900000,
"ReplacementCostGrossProfitMargin": 0.900000,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": true,
"PaymentMethod": "Controlled PM",
"UserDefinedPaymentMethodID": 124,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 37103,
"BranchID": 15,
"DepartmentID": 1,
"CustomerID": 1700,
"BillingCustomerID": 1700,
"TaxCodeID": 11,
"TaxBodyID": 37,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 26802,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 5,
"JoinID": "084.01",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "G&AA",
"PartsOrderNumber": 4,
"OrderStatus": "Voided",
"CreationDate": "2017-06-20T13:24:22.093",
"CustomerNumber": "3676",
"CompanyName": "KLBKR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-06-20T13:25:58.173",
"InvoiceNumber": "084.01",
"LastUpdate": "2017-06-20T13:25:58.173",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Lori R",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "KLBKR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "St Louis City TEST",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Lori R",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Robinson's Trucking",
"ShipToAddress1": "#1 Paradise Ave",
"ShipToAddress2": "",
"ShipToCity": "St Louis",
"ShipToRegion": "MO",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "lrobinson@karmak.com",
"AverageCost": -15.0000,
"ReplacementCost": -15.0000,
"OrderSubtotal": -150.00,
"OrderTotal": -150.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": -135.0000,
"ReplacementCostGrossProfit": -135.0000,
"AverageCostGrossProfitMargin": -0.900000,
"ReplacementCostGrossProfitMargin": -0.900000,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": true,
"PaymentMethod": "Controlled PM",
"UserDefinedPaymentMethodID": 124,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 37103,
"BranchID": 15,
"DepartmentID": 1,
"CustomerID": 1700,
"BillingCustomerID": 1700,
"TaxCodeID": 11,
"TaxBodyID": 37,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 26803,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 4,
"JoinID": "084.02",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "G&AA",
"PartsOrderNumber": 4,
"OrderStatus": "Invoiced",
"CreationDate": "2017-06-20T13:26:09.007",
"CustomerNumber": "3676",
"CompanyName": "KLBKR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-06-20T13:26:08.923",
"InvoiceNumber": "084.02",
"LastUpdate": "2017-06-20T13:26:09.007",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Lori R",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "KLBKR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "St Louis City TEST",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Lori R",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Robinson's Trucking",
"ShipToAddress1": "#1 Paradise Ave",
"ShipToAddress2": "",
"ShipToCity": "St Louis",
"ShipToRegion": "MO",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "lrobinson@karmak.com",
"AverageCost": 15.0000,
"ReplacementCost": 15.0000,
"OrderSubtotal": 150.00,
"OrderTotal": 150.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 135.0000,
"ReplacementCostGrossProfit": 135.0000,
"AverageCostGrossProfitMargin": 0.900000,
"ReplacementCostGrossProfitMargin": 0.900000,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Controlled PM",
"UserDefinedPaymentMethodID": 124,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 37104,
"BranchID": 15,
"DepartmentID": 1,
"CustomerID": 1700,
"BillingCustomerID": 1700,
"TaxCodeID": 11,
"TaxBodyID": 37,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 26804,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 4,
"JoinID": "085",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "G&AA",
"PartsOrderNumber": 5,
"OrderStatus": "Invoiced",
"CreationDate": "2017-06-20T13:38:52.187",
"CustomerNumber": "3676",
"CompanyName": "KLBKR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-06-20T13:38:52.097",
"InvoiceNumber": "085",
"LastUpdate": "2017-06-20T13:38:52.187",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Lori R",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "KLBKR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "St Louis City TEST",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Lori R",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Robinson's Trucking",
"ShipToAddress1": "#1 Paradise Ave",
"ShipToAddress2": "",
"ShipToCity": "St Louis",
"ShipToRegion": "MO",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "lrobinson@karmak.com",
"AverageCost": 15.0000,
"ReplacementCost": 15.0000,
"OrderSubtotal": 175.00,
"OrderTotal": 175.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 160.0000,
"ReplacementCostGrossProfit": 160.0000,
"AverageCostGrossProfitMargin": 0.914285,
"ReplacementCostGrossProfitMargin": 0.914285,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 2,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Controlled PM",
"UserDefinedPaymentMethodID": 124,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 37496,
"BranchID": 15,
"DepartmentID": 1,
"CustomerID": 1700,
"BillingCustomerID": 1700,
"TaxCodeID": 11,
"TaxBodyID": 31,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 26976,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 4,
"JoinID": "086",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "G&AA",
"PartsOrderNumber": 6,
"OrderStatus": "Invoiced",
"CreationDate": "2017-07-31T10:07:31.797",
"CustomerNumber": "3676",
"CompanyName": "KLBKR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-07-31T10:07:31.497",
"InvoiceNumber": "086",
"LastUpdate": "2017-07-31T10:07:31.797",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Lori R",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "KLBKR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "Waggoner town",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Lori R",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Robinson's Trucking",
"ShipToAddress1": "#1 Paradise Ave",
"ShipToAddress2": "Bill-to address",
"ShipToCity": "waggoner",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "lrobinson@karmak.com",
"AverageCost": 15.0000,
"ReplacementCost": 15.0000,
"OrderSubtotal": 1000.00,
"OrderTotal": 1020.00,
"SalesTaxTotal": 20.00,
"AverageCostGrossProfit": 985.0000,
"ReplacementCostGrossProfit": 985.0000,
"AverageCostGrossProfitMargin": 0.985000,
"ReplacementCostGrossProfitMargin": 0.985000,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Controlled PM",
"UserDefinedPaymentMethodID": 124,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 37516,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3827,
"BillingCustomerID": 3827,
"TaxCodeID": 3,
"TaxBodyID": 14,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 1,
"JoinID": "37516",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 7,
"OrderStatus": "In Process",
"CreationDate": "2017-08-02T12:38:33.507",
"CustomerNumber": "Momo",
"CompanyName": "Imogen's Casual Destruction",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-08-28T16:59:56.260",
"AddUser": "karmak",
"UpdateUser": "karmak",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Josh Schesvold",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "Momo",
"BillingCompanyName": "Imogen's Casual Destruction",
"TaxCode": "ex",
"TaxBody": "Carlinville",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Josh Schesvold",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Josh Schesvold",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "123 Company",
"ShipToAddress1": "One Karmak Plaza",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "555-555-5555",
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "jschesvold@karmak.com",
"AverageCost": 40.0000,
"ReplacementCost": 40.0000,
"OrderSubtotal": 96.00,
"OrderTotal": 96.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 56.0000,
"ReplacementCostGrossProfit": 56.0000,
"AverageCostGrossProfitMargin": 0.583333,
"ReplacementCostGrossProfitMargin": 0.583333,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 37774,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 1441,
"BillingCustomerID": 1441,
"TaxCodeID": 18,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 1,
"JoinID": "37774",
"CanadianTaxID": "850348186RT0001",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 9,
"OrderStatus": "In Process",
"CreationDate": "2017-08-21T15:31:44.983",
"CustomerNumber": "2506",
"CompanyName": "A & B Truck Repair ",
"CustomerPO": "",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-06-11T16:36:56.227",
"AddUser": "bbaker",
"UpdateUser": "rgilmore",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Rich Norman",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "2506",
"BillingCompanyName": "A & B Truck Repair ",
"TaxCode": "Governmental",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Beth Baker",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Rich Norman",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "A & B Truck Repair ",
"ShipToAddress1": "100011 North Rte. 4",
"ShipToAddress2": "",
"ShipToCity": "Staunton",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "1234567890",
"ShipToFax": "1234564",
"ShipToShopPhone": null,
"ShipToEmail": "bbaker@karmak.com",
"AverageCost": 55.5162,
"ReplacementCost": 55.5162,
"OrderSubtotal": 173.25,
"OrderTotal": 173.25,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 117.7338,
"ReplacementCostGrossProfit": 117.7338,
"AverageCostGrossProfitMargin": 0.679560,
"ReplacementCostGrossProfitMargin": 0.679560,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 2,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "AmexTest",
"UserDefinedPaymentMethodID": 150,
"StaticPaymentMethodID": 3,
"Territory": "Mid-West"
},
{
"PartsSalesOrderID": 29396,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 1713,
"BillingCustomerID": 1713,
"TaxCodeID": 11,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 22393,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 4,
"JoinID": "910",
"CanadianTaxID": null,
"QuebecTaxID": null,
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 10,
"OrderStatus": "Invoiced",
"CreationDate": "2016-01-20T09:55:11.663",
"CustomerNumber": "1224",
"CompanyName": "Choklad-10",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2016-01-20T09:55:11.553",
"InvoiceNumber": "910",
"LastUpdate": "2016-01-20T09:55:11.663",
"AddUser": "lchoklad-future",
"UpdateUser": "lchoklad-future",
"InvoiceUser": "lchoklad-future",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "First Name Last Name",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1224",
"BillingCompanyName": "Choklad-10",
"TaxCode": "Taxable",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "First Name Last Name",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Choklad-10",
"ShipToAddress1": "Ship-To Address 1",
"ShipToAddress2": "Ship-To Address 2",
"ShipToCity": "City",
"ShipToRegion": "MO",
"ShipToPostalCode": "65775",
"ShipToOfficePhone": "Office Phone",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "lchoklad@karmak.com",
"AverageCost": 190.6400,
"ReplacementCost": 190.6400,
"OrderSubtotal": 306.94,
"OrderTotal": 306.94,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 116.3000,
"ReplacementCostGrossProfit": 116.3000,
"AverageCostGrossProfitMargin": 0.378901,
"ReplacementCostGrossProfitMargin": 0.378901,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Test method",
"UserDefinedPaymentMethodID": 90,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 37783,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3927,
"BillingCustomerID": 3927,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 27202,
"PickupDeliveryMethodID": 10,
"SalesOrderStatusID": 4,
"JoinID": "0810",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 10,
"OrderStatus": "Invoiced",
"CreationDate": "2017-08-23T08:40:02.240",
"CustomerNumber": "0128",
"CompanyName": "Allison's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Carlile to Alpine",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-08-23T08:40:01.770",
"InvoiceNumber": "0810",
"LastUpdate": "2017-08-23T08:40:02.240",
"AddUser": "Morgan",
"UpdateUser": "Morgan",
"InvoiceUser": "Morgan",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": "M G",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "0128",
"BillingCompanyName": "Allison's Trucking",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Isla Bear",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "M G",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Allison's Trucking",
"ShipToAddress1": "tests",
"ShipToAddress2": "",
"ShipToCity": "test2",
"ShipToRegion": "MO",
"ShipToPostalCode": "62056",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 500.0000,
"ReplacementCost": 500.0000,
"OrderSubtotal": 852.04,
"OrderTotal": 852.04,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 352.0400,
"ReplacementCostGrossProfit": 352.0400,
"AverageCostGrossProfitMargin": 0.413173,
"ReplacementCostGrossProfitMargin": 0.413173,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 2,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "cash",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 29397,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 1713,
"BillingCustomerID": 1713,
"TaxCodeID": 11,
"TaxBodyID": 11,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 22394,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 4,
"JoinID": "911",
"CanadianTaxID": null,
"QuebecTaxID": null,
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 11,
"OrderStatus": "Invoiced",
"CreationDate": "2016-01-20T09:59:50.030",
"CustomerNumber": "1224",
"CompanyName": "Choklad-10",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2016-01-20T09:59:50.067",
"InvoiceNumber": "911",
"LastUpdate": "2016-01-20T09:59:50.030",
"AddUser": "lchoklad-future",
"UpdateUser": "lchoklad-future",
"InvoiceUser": "lchoklad-future",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "First Name Last Name",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1224",
"BillingCompanyName": "Choklad-10",
"TaxCode": "Taxable",
"TaxBody": "City Tax",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Amit Sharma",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "First Name Last Name",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Choklad-10",
"ShipToAddress1": "Ship-To Address 1",
"ShipToAddress2": "Ship-To Address 2",
"ShipToCity": "City",
"ShipToRegion": "AK",
"ShipToPostalCode": "65775",
"ShipToOfficePhone": "Office Phone",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "lchoklad@karmak.com",
"AverageCost": 285.9600,
"ReplacementCost": 285.9600,
"OrderSubtotal": 475.41,
"OrderTotal": 475.41,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 189.4500,
"ReplacementCostGrossProfit": 189.4500,
"AverageCostGrossProfitMargin": 0.398498,
"ReplacementCostGrossProfitMargin": 0.398498,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 2,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Charge",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 38306,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 1348,
"BillingCustomerID": 1348,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": 10075,
"PartsSalesOrderInvoiceID": 27660,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 5,
"JoinID": "0811",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 11,
"OrderStatus": "Invoiced",
"CreationDate": "2017-10-02T10:55:04.627",
"CustomerNumber": "95082",
"CompanyName": "Inventory - New HD DTNA",
"CustomerPO": "",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-10-02T10:55:04.400",
"InvoiceNumber": "0811",
"LastUpdate": "2017-10-02T10:57:08.443",
"AddUser": "davefutsa",
"UpdateUser": "davefutsa",
"InvoiceUser": "davefutsa",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "95082",
"BillingCompanyName": "Inventory - New HD DTNA",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": 4932,
"OutsidePartsSalesperson": "naresh sharma",
"PartsAccounting": "Internal",
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "Inventory - New HD DTNA",
"ShipToAddress1": "...",
"ShipToAddress2": "",
"ShipToCity": "ANCHORAGE",
"ShipToRegion": "AK",
"ShipToPostalCode": "99518",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 21.3000,
"ReplacementCost": 21.3000,
"OrderSubtotal": 105.00,
"OrderTotal": 95.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 83.7000,
"ReplacementCostGrossProfit": 83.7000,
"AverageCostGrossProfitMargin": 0.797142,
"ReplacementCostGrossProfitMargin": 0.797142,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 2,
"UpdateStatus": "",
"IsVoided": true,
"PaymentMethod": "Inventory - New HD DTNA",
"UserDefinedPaymentMethodID": 27,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 38306,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 1348,
"BillingCustomerID": 1348,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": 10075,
"PartsSalesOrderInvoiceID": 27660,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 5,
"JoinID": "0811.01",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 11,
"OrderStatus": "Voided",
"CreationDate": "2017-10-02T10:55:04.627",
"CustomerNumber": "95082",
"CompanyName": "Inventory - New HD DTNA",
"CustomerPO": "",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-10-02T10:57:08.443",
"InvoiceNumber": "0811.01",
"LastUpdate": "2017-10-02T10:57:08.443",
"AddUser": "davefutsa",
"UpdateUser": "davefutsa",
"InvoiceUser": "davefutsa",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "95082",
"BillingCompanyName": "Inventory - New HD DTNA",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": 4932,
"OutsidePartsSalesperson": "naresh sharma",
"PartsAccounting": "Internal",
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "Inventory - New HD DTNA",
"ShipToAddress1": "...",
"ShipToAddress2": "",
"ShipToCity": "ANCHORAGE",
"ShipToRegion": "AK",
"ShipToPostalCode": "99518",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": -21.3000,
"ReplacementCost": -21.3000,
"OrderSubtotal": -105.00,
"OrderTotal": -95.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": -83.7000,
"ReplacementCostGrossProfit": -83.7000,
"AverageCostGrossProfitMargin": -0.797142,
"ReplacementCostGrossProfitMargin": -0.797142,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 2,
"UpdateStatus": "",
"IsVoided": true,
"PaymentMethod": "Inventory - New HD DTNA",
"UserDefinedPaymentMethodID": 27,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 38306,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 1348,
"BillingCustomerID": 1348,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": 10075,
"PartsSalesOrderInvoiceID": 27661,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 4,
"JoinID": "0811.02",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 11,
"OrderStatus": "Invoiced",
"CreationDate": "2017-10-02T10:57:41.030",
"CustomerNumber": "95082",
"CompanyName": "Inventory - New HD DTNA",
"CustomerPO": "",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-10-02T10:57:40.897",
"InvoiceNumber": "0811.02",
"LastUpdate": "2017-10-02T10:57:41.030",
"AddUser": "davefutsa",
"UpdateUser": "davefutsa",
"InvoiceUser": "davefutsa",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "95082",
"BillingCompanyName": "Inventory - New HD DTNA",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": 4932,
"OutsidePartsSalesperson": "naresh sharma",
"PartsAccounting": "Internal",
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "Inventory - New HD DTNA",
"ShipToAddress1": "...",
"ShipToAddress2": "",
"ShipToCity": "ANCHORAGE",
"ShipToRegion": "AK",
"ShipToPostalCode": "99518",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 21.3000,
"ReplacementCost": 21.3000,
"OrderSubtotal": 95.00,
"OrderTotal": 95.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 73.7000,
"ReplacementCostGrossProfit": 73.7000,
"AverageCostGrossProfitMargin": 0.775789,
"ReplacementCostGrossProfitMargin": 0.775789,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 2,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Inventory - New HD DTNA",
"UserDefinedPaymentMethodID": 27,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 29398,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 1713,
"BillingCustomerID": 1713,
"TaxCodeID": 11,
"TaxBodyID": 4,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 32280,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 4,
"JoinID": "1012",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 12,
"OrderStatus": "Invoiced",
"CreationDate": "2018-06-13T15:21:34.283",
"CustomerNumber": "1224",
"CompanyName": "Choklad-10",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-06-13T15:22:03.273",
"InvoiceNumber": "1012",
"LastUpdate": "2018-06-13T15:21:34.283",
"AddUser": "lchoklad-future",
"UpdateUser": "jschesvo",
"InvoiceUser": "jschesvo",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "First Name Last Name",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1224",
"BillingCompanyName": "Choklad-10",
"TaxCode": "Taxable",
"TaxBody": "Whatever I want",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Amit Sharma",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "First Name Last Name",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Choklad-10",
"ShipToAddress1": "Ship-To Address 1",
"ShipToAddress2": "Ship-To Address 2",
"ShipToCity": "City",
"ShipToRegion": "MO",
"ShipToPostalCode": "65775",
"ShipToOfficePhone": "Office Phone",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "lchoklad@karmak.com",
"AverageCost": 101.3200,
"ReplacementCost": 101.3200,
"OrderSubtotal": 163.97,
"OrderTotal": 164.50,
"SalesTaxTotal": 0.53,
"AverageCostGrossProfit": 62.6500,
"ReplacementCostGrossProfit": 62.6500,
"AverageCostGrossProfitMargin": 0.382082,
"ReplacementCostGrossProfitMargin": 0.382082,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 2,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 43227,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 8314,
"BillingCustomerID": 8314,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 29101,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 4,
"JoinID": "0812",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 12,
"OrderStatus": "Invoiced",
"CreationDate": "2017-12-13T15:39:33.037",
"CustomerNumber": "1431",
"CompanyName": "Seabolt",
"CustomerPO": "",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-12-13T15:39:33.090",
"InvoiceNumber": "0812",
"LastUpdate": "2017-12-13T15:39:33.037",
"AddUser": "vseabolt",
"UpdateUser": "vseabolt",
"InvoiceUser": "vseabolt",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Test1 ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1431",
"BillingCompanyName": "Seabolt",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Vanessa Seabolt",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Test1 ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Seabolt",
"ShipToAddress1": "123 Main",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 125.0000,
"ReplacementCost": 125.0000,
"OrderSubtotal": 157.50,
"OrderTotal": 157.50,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 32.5000,
"ReplacementCostGrossProfit": 32.5000,
"AverageCostGrossProfitMargin": 0.206349,
"ReplacementCostGrossProfitMargin": 0.206349,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Charge",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 29399,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 1713,
"BillingCustomerID": 1713,
"TaxCodeID": 11,
"TaxBodyID": 4,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 1,
"JoinID": "29399",
"CanadianTaxID": null,
"QuebecTaxID": null,
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 13,
"OrderStatus": "In Process",
"CreationDate": "2016-01-20T10:08:28.283",
"CustomerNumber": "1224",
"CompanyName": "Choklad-10",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2016-01-20T10:08:28.283",
"AddUser": "lchoklad-future",
"UpdateUser": "lchoklad-future",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "First Name Last Name",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1224",
"BillingCompanyName": "Choklad-10",
"TaxCode": "Taxable",
"TaxBody": "Whatever I want",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Amit Sharma",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "First Name Last Name",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Choklad-10",
"ShipToAddress1": "Bill-To Address 1",
"ShipToAddress2": "Bill-To Address 2",
"ShipToCity": "City",
"ShipToRegion": "MO",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "Office Phone",
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "lchoklad@karmak.com",
"AverageCost": 95.3200,
"ReplacementCost": 95.3200,
"OrderSubtotal": 153.47,
"OrderTotal": 153.47,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 58.1500,
"ReplacementCostGrossProfit": 58.1500,
"AverageCostGrossProfitMargin": 0.378901,
"ReplacementCostGrossProfitMargin": 0.378901,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 43228,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 8314,
"BillingCustomerID": 8314,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 29102,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 4,
"JoinID": "0813",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 13,
"OrderStatus": "Invoiced",
"CreationDate": "2017-12-13T15:45:31.077",
"CustomerNumber": "1431",
"CompanyName": "Seabolt",
"CustomerPO": "",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-12-13T15:45:31.113",
"InvoiceNumber": "0813",
"LastUpdate": "2017-12-13T15:45:31.077",
"AddUser": "vseabolt",
"UpdateUser": "vseabolt",
"InvoiceUser": "vseabolt",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Test1 ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1431",
"BillingCompanyName": "Seabolt",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Vanessa Seabolt",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Test1 ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Seabolt",
"ShipToAddress1": "123 Main",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 125.0000,
"ReplacementCost": 125.0000,
"OrderSubtotal": 157.50,
"OrderTotal": 157.50,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 32.5000,
"ReplacementCostGrossProfit": 32.5000,
"AverageCostGrossProfitMargin": 0.206349,
"ReplacementCostGrossProfitMargin": 0.206349,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Charge",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 29400,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 1713,
"BillingCustomerID": 1713,
"TaxCodeID": 11,
"TaxBodyID": 4,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 1,
"JoinID": "29400",
"CanadianTaxID": null,
"QuebecTaxID": null,
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 14,
"OrderStatus": "In Process",
"CreationDate": "2016-01-20T10:09:21.890",
"CustomerNumber": "1224",
"CompanyName": "Choklad-10",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2016-01-20T10:09:21.890",
"AddUser": "lchoklad-future",
"UpdateUser": "lchoklad-future",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "First Name Last Name",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1224",
"BillingCompanyName": "Choklad-10",
"TaxCode": "Taxable",
"TaxBody": "Whatever I want",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Amit Sharma",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "First Name Last Name",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Choklad-10",
"ShipToAddress1": "Bill-To Address 1",
"ShipToAddress2": "Bill-To Address 2",
"ShipToCity": "City",
"ShipToRegion": "MO",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "Office Phone",
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "lchoklad@karmak.com",
"AverageCost": 95.3200,
"ReplacementCost": 95.3200,
"OrderSubtotal": 153.47,
"OrderTotal": 153.47,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 58.1500,
"ReplacementCostGrossProfit": 58.1500,
"AverageCostGrossProfitMargin": 0.378901,
"ReplacementCostGrossProfitMargin": 0.378901,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 44536,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 8314,
"BillingCustomerID": 8314,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 1,
"JoinID": "44536",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 14,
"OrderStatus": "In Process",
"CreationDate": "2017-12-28T11:19:16.870",
"CustomerNumber": "1431",
"CompanyName": "Seabolt",
"CustomerPO": "",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-12-28T11:20:04.010",
"AddUser": "vseabolt",
"UpdateUser": "vseabolt",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Test1 ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1431",
"BillingCompanyName": "Seabolt",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Vanessa Seabolt",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Test1 ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Seabolt",
"ShipToAddress1": null,
"ShipToAddress2": null,
"ShipToCity": null,
"ShipToRegion": null,
"ShipToPostalCode": null,
"ShipToOfficePhone": "11111111",
"ShipToFax": null,
"ShipToShopPhone": "333333",
"ShipToEmail": "vseabolt@karmak.com",
"AverageCost": 783.0000,
"ReplacementCost": 783.0000,
"OrderSubtotal": 1331.10,
"OrderTotal": 1331.10,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 548.1000,
"ReplacementCostGrossProfit": 548.1000,
"AverageCostGrossProfitMargin": 0.411764,
"ReplacementCostGrossProfitMargin": 0.411764,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 29401,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 1713,
"BillingCustomerID": 1713,
"TaxCodeID": 11,
"TaxBodyID": 4,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 22395,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 4,
"JoinID": "915",
"CanadianTaxID": null,
"QuebecTaxID": null,
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 15,
"OrderStatus": "Invoiced",
"CreationDate": "2016-01-20T10:25:21.413",
"CustomerNumber": "1224",
"CompanyName": "Choklad-10",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2016-01-20T10:25:21.673",
"InvoiceNumber": "915",
"LastUpdate": "2016-01-20T10:25:21.413",
"AddUser": "lchoklad-future",
"UpdateUser": "lchoklad-future",
"InvoiceUser": "lchoklad-future",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "First Name Last Name",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1224",
"BillingCompanyName": "Choklad-10",
"TaxCode": "Taxable",
"TaxBody": "Whatever I want",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Amit Sharma",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "First Name Last Name",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Choklad-10",
"ShipToAddress1": "Ship-To Address 1",
"ShipToAddress2": "Ship-To Address 2",
"ShipToCity": "City",
"ShipToRegion": "MO",
"ShipToPostalCode": "65775",
"ShipToOfficePhone": "Office Phone",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "lchoklad@karmak.com",
"AverageCost": 95.3200,
"ReplacementCost": 95.3200,
"OrderSubtotal": 153.47,
"OrderTotal": 161.14,
"SalesTaxTotal": 7.67,
"AverageCostGrossProfit": 58.1500,
"ReplacementCostGrossProfit": 58.1500,
"AverageCostGrossProfitMargin": 0.378901,
"ReplacementCostGrossProfitMargin": 0.378901,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Charge",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 44569,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 8314,
"BillingCustomerID": 8314,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 1,
"JoinID": "44569",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 15,
"OrderStatus": "In Process",
"CreationDate": "2017-12-29T15:34:26.377",
"CustomerNumber": "1431",
"CompanyName": "Seabolt",
"CustomerPO": "",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-12-29T15:34:35.643",
"AddUser": "vseabolt",
"UpdateUser": "vseabolt",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Test1 ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1431",
"BillingCompanyName": "Seabolt",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Vanessa Seabolt",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Test1 ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Seabolt",
"ShipToAddress1": null,
"ShipToAddress2": null,
"ShipToCity": null,
"ShipToRegion": null,
"ShipToPostalCode": null,
"ShipToOfficePhone": "11111111",
"ShipToFax": null,
"ShipToShopPhone": "333333",
"ShipToEmail": "vseabolt@karmak.com",
"AverageCost": 112.5000,
"ReplacementCost": 112.5000,
"OrderSubtotal": 191.25,
"OrderTotal": 191.25,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 78.7500,
"ReplacementCostGrossProfit": 78.7500,
"AverageCostGrossProfitMargin": 0.411764,
"ReplacementCostGrossProfitMargin": 0.411764,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 29402,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 1713,
"BillingCustomerID": 1713,
"TaxCodeID": 11,
"TaxBodyID": 4,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 22396,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 4,
"JoinID": "916",
"CanadianTaxID": null,
"QuebecTaxID": null,
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 16,
"OrderStatus": "Invoiced",
"CreationDate": "2016-01-20T10:27:30.033",
"CustomerNumber": "1224",
"CompanyName": "Choklad-10",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2016-01-20T10:27:30.313",
"InvoiceNumber": "916",
"LastUpdate": "2016-01-20T10:27:30.033",
"AddUser": "lchoklad-future",
"UpdateUser": "lchoklad-future",
"InvoiceUser": "lchoklad-future",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "First Name Last Name",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1224",
"BillingCompanyName": "Choklad-10",
"TaxCode": "Taxable",
"TaxBody": "Whatever I want",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Amit Sharma",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "First Name Last Name",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Choklad-10",
"ShipToAddress1": "Ship-To Address 1",
"ShipToAddress2": "Ship-To Address 2",
"ShipToCity": "City",
"ShipToRegion": "MO",
"ShipToPostalCode": "65775",
"ShipToOfficePhone": "Office Phone",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "lchoklad@karmak.com",
"AverageCost": 95.3200,
"ReplacementCost": 95.3200,
"OrderSubtotal": 153.47,
"OrderTotal": 161.14,
"SalesTaxTotal": 7.67,
"AverageCostGrossProfit": 58.1500,
"ReplacementCostGrossProfit": 58.1500,
"AverageCostGrossProfitMargin": 0.378901,
"ReplacementCostGrossProfitMargin": 0.378901,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Charge",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 44570,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 8314,
"BillingCustomerID": 8314,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 1,
"JoinID": "44570",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 16,
"OrderStatus": "In Process",
"CreationDate": "2017-12-29T15:38:01.313",
"CustomerNumber": "1431",
"CompanyName": "Seabolt",
"CustomerPO": "",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-12-29T15:38:11.363",
"AddUser": "vseabolt",
"UpdateUser": "vseabolt",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Test1 ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1431",
"BillingCompanyName": "Seabolt",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Vanessa Seabolt",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Test1 ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Seabolt",
"ShipToAddress1": null,
"ShipToAddress2": null,
"ShipToCity": null,
"ShipToRegion": null,
"ShipToPostalCode": null,
"ShipToOfficePhone": "11111111",
"ShipToFax": null,
"ShipToShopPhone": "333333",
"ShipToEmail": "vseabolt@karmak.com",
"AverageCost": 225.0000,
"ReplacementCost": 225.0000,
"OrderSubtotal": 382.50,
"OrderTotal": 382.50,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 157.5000,
"ReplacementCostGrossProfit": 157.5000,
"AverageCostGrossProfitMargin": 0.411764,
"ReplacementCostGrossProfitMargin": 0.411764,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 30140,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 1747,
"BillingCustomerID": 1747,
"TaxCodeID": 11,
"TaxBodyID": 14,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 1,
"JoinID": "30140",
"CanadianTaxID": null,
"QuebecTaxID": null,
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 17,
"OrderStatus": "In Process",
"CreationDate": "2016-04-13T11:51:22.333",
"CustomerNumber": "MVP10",
"CompanyName": "MV Preferred",
"CustomerPO": "005-12345",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2016-04-13T12:00:52.507",
"AddUser": "mgfuture",
"UpdateUser": "mgfuture",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "MV Preferred ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "MVP10",
"BillingCompanyName": "MV Preferred",
"TaxCode": "Taxable",
"TaxBody": "Carlinville",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "MV Preferred ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "MV Preferred",
"ShipToAddress1": "925 E Sunshine St ",
"ShipToAddress2": "",
"ShipToCity": "Springfield",
"ShipToRegion": "IL",
"ShipToPostalCode": "65807",
"ShipToOfficePhone": "4142987895",
"ShipToFax": "800FAX1234",
"ShipToShopPhone": null,
"ShipToEmail": "",
"AverageCost": 290.6400,
"ReplacementCost": 290.6400,
"OrderSubtotal": 466.04,
"OrderTotal": 484.46,
"SalesTaxTotal": 18.42,
"AverageCostGrossProfit": 175.4000,
"ReplacementCostGrossProfit": 175.4000,
"AverageCostGrossProfitMargin": 0.376362,
"ReplacementCostGrossProfitMargin": 0.376362,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "MV Preferred",
"UserDefinedPaymentMethodID": 88,
"StaticPaymentMethodID": 7,
"Territory": ""
},
{
"PartsSalesOrderID": 45104,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3826,
"BillingCustomerID": 3826,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 1,
"JoinID": "45104",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 17,
"OrderStatus": "In Process",
"CreationDate": "2018-02-14T09:11:41.443",
"CustomerNumber": "11107",
"CompanyName": "Roper Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-02-14T09:11:41.443",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Cheri Roper",
"BillingHomePhone": "217-444-4444",
"BillingWorkPhone": "",
"BillingCustomerNumber": "11107",
"BillingCompanyName": "Roper Trucking",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Morgan Gress",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Cheri Roper",
"ContactHomePhone": "217-444-4444",
"ContactWorkPhone": "",
"ShipToCustomerName": "Roper Trucking",
"ShipToAddress1": "15642 Greenridge Rd",
"ShipToAddress2": "",
"ShipToCity": "Girard",
"ShipToRegion": "IL",
"ShipToPostalCode": "62640",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "croper@karmak.com",
"AverageCost": 10.7325,
"ReplacementCost": 10.7325,
"OrderSubtotal": 19.65,
"OrderTotal": 19.65,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 8.9175,
"ReplacementCostGrossProfit": 8.9175,
"AverageCostGrossProfitMargin": 0.453816,
"ReplacementCostGrossProfitMargin": 0.453816,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": "West Coast"
},
{
"PartsSalesOrderID": 30160,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 1747,
"BillingCustomerID": 1747,
"TaxCodeID": 11,
"TaxBodyID": 14,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 1,
"JoinID": "30160",
"CanadianTaxID": null,
"QuebecTaxID": null,
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 18,
"OrderStatus": "In Process",
"CreationDate": "2016-04-14T13:34:17.947",
"CustomerNumber": "MVP10",
"CompanyName": "MV Preferred",
"CustomerPO": "005-",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2016-04-14T13:34:17.947",
"AddUser": "mgfuture",
"UpdateUser": "mgfuture",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "MV Preferred ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "MVP10",
"BillingCompanyName": "MV Preferred",
"TaxCode": "Taxable",
"TaxBody": "Carlinville",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "MV Preferred ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "MV Preferred",
"ShipToAddress1": "925 E Sunshine St ",
"ShipToAddress2": "",
"ShipToCity": "Springfield",
"ShipToRegion": "IL",
"ShipToPostalCode": "65807",
"ShipToOfficePhone": "4142987895",
"ShipToFax": "800FAX1234",
"ShipToShopPhone": null,
"ShipToEmail": "",
"AverageCost": 10000.0000,
"ReplacementCost": 10000.0000,
"OrderSubtotal": 15902.00,
"OrderTotal": 15902.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 5902.0000,
"ReplacementCostGrossProfit": 5902.0000,
"AverageCostGrossProfitMargin": 0.371148,
"ReplacementCostGrossProfitMargin": 0.371148,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "MV Preferred",
"UserDefinedPaymentMethodID": 88,
"StaticPaymentMethodID": 7,
"Territory": ""
},
{
"PartsSalesOrderID": 45105,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 973,
"BillingCustomerID": 973,
"TaxCodeID": 11,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 1,
"JoinID": "45105",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 18,
"OrderStatus": "In Process",
"CreationDate": "2018-02-14T09:14:56.590",
"CustomerNumber": "00878",
"CompanyName": "FUTURE RADIO FLYER",
"CustomerPO": "8675309",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-02-14T09:14:56.590",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "William Lewis",
"BillingHomePhone": "",
"BillingWorkPhone": "CON-TAC-WORK",
"BillingCustomerNumber": "00878",
"BillingCompanyName": "FUTURE RADIO FLYER",
"TaxCode": "Taxable",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "naresh sharma",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "William Lewis",
"ContactHomePhone": "",
"ContactWorkPhone": "CON-TAC-WORK",
"ShipToCustomerName": "FUTURE RADIO FLYER - CARLINVILLE 62626 F/C",
"ShipToAddress1": "BT Address line 1",
"ShipToAddress2": "BT Address Line 2",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "(217) 854-4721",
"ShipToFax": null,
"ShipToShopPhone": "800-222-shop",
"ShipToEmail": null,
"AverageCost": 10.7325,
"ReplacementCost": 10.7325,
"OrderSubtotal": 19.65,
"OrderTotal": 19.65,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 8.9175,
"ReplacementCostGrossProfit": 8.9175,
"AverageCostGrossProfitMargin": 0.453816,
"ReplacementCostGrossProfitMargin": 0.453816,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": "Mid-West"
},
{
"PartsSalesOrderID": 33312,
"BranchID": 17,
"DepartmentID": 1,
"CustomerID": 1441,
"BillingCustomerID": 1441,
"TaxCodeID": 6,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 25313,
"PickupDeliveryMethodID": 14,
"SalesOrderStatusID": 4,
"JoinID": "919",
"CanadianTaxID": null,
"QuebecTaxID": null,
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "G&AA",
"PartsOrderNumber": 19,
"OrderStatus": "Invoiced",
"CreationDate": "2016-10-05T15:58:29.420",
"CustomerNumber": "2506",
"CompanyName": "A & B Truck Repair ",
"CustomerPO": "",
"PickupDeliveryMethod": "ASCI",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2016-10-05T15:58:29.473",
"InvoiceNumber": "919",
"LastUpdate": "2016-10-05T15:58:29.420",
"AddUser": "jbishop",
"UpdateUser": "jbishop",
"InvoiceUser": "jbishop",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Rich Norman",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "2506",
"BillingCompanyName": "A & B Truck Repair ",
"TaxCode": "Taxable - No Tire Tax",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Beth Baker",
"PartsAccounting": "Internal",
"Source": "Part Counter",
"ContactName": "Rich Norman",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "A & B Truck Repair ",
"ShipToAddress1": "123 TRUCK STREET",
"ShipToAddress2": "",
"ShipToCity": "CARLINVILLE",
"ShipToRegion": "IL",
"ShipToPostalCode": "",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 95.3200,
"ReplacementCost": 95.3200,
"OrderSubtotal": 153.51,
"OrderTotal": 164.26,
"SalesTaxTotal": 10.75,
"AverageCostGrossProfit": 58.1900,
"ReplacementCostGrossProfit": 58.1900,
"AverageCostGrossProfitMargin": 0.379063,
"ReplacementCostGrossProfitMargin": 0.379063,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Billing Service Open ",
"UserDefinedPaymentMethodID": 113,
"StaticPaymentMethodID": 4,
"Territory": ""
},
{
"PartsSalesOrderID": 45106,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3805,
"BillingCustomerID": 3805,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 1,
"JoinID": "45106",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 19,
"OrderStatus": "In Process",
"CreationDate": "2018-02-14T09:17:09.793",
"CustomerNumber": "1302",
"CompanyName": "Trader Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-02-14T09:17:09.793",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": " ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1302",
"BillingCompanyName": "Trader Trucking",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": " ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Trader Trucking",
"ShipToAddress1": "1 Main St",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "ttrader@karmak.com",
"AverageCost": 10.7325,
"ReplacementCost": 10.7325,
"OrderSubtotal": 13.95,
"OrderTotal": 13.95,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 3.2175,
"ReplacementCostGrossProfit": 3.2175,
"AverageCostGrossProfitMargin": 0.230645,
"ReplacementCostGrossProfitMargin": 0.230645,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 33589,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 1720,
"BillingCustomerID": 1720,
"TaxCodeID": 11,
"TaxBodyID": 13,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 1,
"JoinID": "33589",
"CanadianTaxID": null,
"QuebecTaxID": null,
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 20,
"OrderStatus": "In Process",
"CreationDate": "2016-11-08T09:53:12.943",
"CustomerNumber": "1285",
"CompanyName": "BH01",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2016-11-08T09:53:12.943",
"AddUser": "bhaab",
"UpdateUser": "bhaab",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Becki Kalaher",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1285",
"BillingCompanyName": "BH01",
"TaxCode": "Taxable",
"TaxBody": "Macoupin County",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Becki Kalaher",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "BH01",
"ShipToAddress1": "101 Main",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 4.0000,
"ReplacementCost": 4.0000,
"OrderSubtotal": 10.00,
"OrderTotal": 10.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 6.0000,
"ReplacementCostGrossProfit": 6.0000,
"AverageCostGrossProfitMargin": 0.600000,
"ReplacementCostGrossProfitMargin": 0.600000,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 45107,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3933,
"BillingCustomerID": 3933,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 1,
"JoinID": "45107",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 20,
"OrderStatus": "In Process",
"CreationDate": "2018-02-14T09:18:50.423",
"CustomerNumber": "9669",
"CompanyName": "ARR Trucking Company Formerly Robinson Towing Company incorporated LLC.",
"CustomerPO": "",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-02-14T09:18:50.423",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "9669",
"BillingCompanyName": "ARR Trucking Company Formerly Robinson Towing Company incorporated LLC.",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Anthony Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "ARR Trucking Company Formerly Robinson Towing Company incorporated LLC.",
"ShipToAddress1": "123 Black lane",
"ShipToAddress2": "",
"ShipToCity": "litchfield",
"ShipToRegion": "IL",
"ShipToPostalCode": "62056",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 10.7325,
"ReplacementCost": 10.7325,
"OrderSubtotal": 12.95,
"OrderTotal": 12.95,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 2.2175,
"ReplacementCostGrossProfit": 2.2175,
"AverageCostGrossProfitMargin": 0.171235,
"ReplacementCostGrossProfitMargin": 0.171235,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Warranty - Freightliner",
"UserDefinedPaymentMethodID": 49,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 33707,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 1732,
"BillingCustomerID": 1732,
"TaxCodeID": 11,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 2,
"JoinID": "33707",
"CanadianTaxID": null,
"QuebecTaxID": null,
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 21,
"OrderStatus": "Quote",
"CreationDate": "2016-11-17T11:19:57.640",
"CustomerNumber": "4481B10",
"CompanyName": "Gilbert'sTrucking Service B3",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2016-11-17T11:19:57.640",
"AddUser": "sarah",
"UpdateUser": "sarah",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "testing ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "4481B10",
"BillingCompanyName": "Gilbert'sTrucking Service B3",
"TaxCode": "Taxable",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "testing ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Gilbert'sTrucking Service B3",
"ShipToAddress1": "123 W. Main St.",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "AK",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "hgilbert@karmak.com",
"AverageCost": 200.0000,
"ReplacementCost": 200.0000,
"OrderSubtotal": 200.00,
"OrderTotal": 200.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 0.0000,
"ReplacementCostGrossProfit": 0.0000,
"AverageCostGrossProfitMargin": 0.000000,
"ReplacementCostGrossProfitMargin": 0.000000,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 45116,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3826,
"BillingCustomerID": 3826,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 1,
"JoinID": "45116",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 21,
"OrderStatus": "In Process",
"CreationDate": "2018-02-14T10:46:19.957",
"CustomerNumber": "11107",
"CompanyName": "Roper Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-02-14T10:46:19.957",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Cheri Roper",
"BillingHomePhone": "217-444-4444",
"BillingWorkPhone": "",
"BillingCustomerNumber": "11107",
"BillingCompanyName": "Roper Trucking",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Morgan Gress",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Cheri Roper",
"ContactHomePhone": "217-444-4444",
"ContactWorkPhone": "",
"ShipToCustomerName": "Roper Trucking",
"ShipToAddress1": "15642 Greenridge Rd",
"ShipToAddress2": "",
"ShipToCity": "Girard",
"ShipToRegion": "IL",
"ShipToPostalCode": "62640",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "croper@karmak.com",
"AverageCost": 10.7325,
"ReplacementCost": 10.7325,
"OrderSubtotal": 19.65,
"OrderTotal": 19.65,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 8.9175,
"ReplacementCostGrossProfit": 8.9175,
"AverageCostGrossProfitMargin": 0.453816,
"ReplacementCostGrossProfitMargin": 0.453816,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": "West Coast"
},
{
"PartsSalesOrderID": 33822,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 3837,
"BillingCustomerID": 3837,
"TaxCodeID": 3,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 25621,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 4,
"JoinID": "1022",
"CanadianTaxID": null,
"QuebecTaxID": null,
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 22,
"OrderStatus": "Invoiced",
"CreationDate": "2016-12-02T09:36:14.210",
"CustomerNumber": "1323",
"CompanyName": "Choklad - Base Branch 10",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2016-12-02T09:36:14.127",
"InvoiceNumber": "1022",
"LastUpdate": "2016-12-02T09:36:14.210",
"AddUser": "lchoklad-future",
"UpdateUser": "lchoklad-future",
"InvoiceUser": "lchoklad-future",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "1323",
"BillingCompanyName": "Choklad - Base Branch 10",
"TaxCode": "ex",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "Choklad - Base Branch 10",
"ShipToAddress1": "Bill-To Address 1",
"ShipToAddress2": "Bill-To Address 2",
"ShipToCity": "Bill-To City",
"ShipToRegion": "IL",
"ShipToPostalCode": "Postal",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 10.0000,
"ReplacementCost": 10.0000,
"OrderSubtotal": 12.55,
"OrderTotal": 13.43,
"SalesTaxTotal": 0.88,
"AverageCostGrossProfit": 2.5500,
"ReplacementCostGrossProfit": 2.5500,
"AverageCostGrossProfitMargin": 0.203187,
"ReplacementCostGrossProfitMargin": 0.203187,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Charge",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 45117,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 973,
"BillingCustomerID": 973,
"TaxCodeID": 11,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 1,
"JoinID": "45117",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 22,
"OrderStatus": "In Process",
"CreationDate": "2018-02-14T10:47:03.357",
"CustomerNumber": "00878",
"CompanyName": "FUTURE RADIO FLYER",
"CustomerPO": "8675309",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-02-14T10:47:03.357",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "William Lewis",
"BillingHomePhone": "",
"BillingWorkPhone": "CON-TAC-WORK",
"BillingCustomerNumber": "00878",
"BillingCompanyName": "FUTURE RADIO FLYER",
"TaxCode": "Taxable",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "naresh sharma",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "William Lewis",
"ContactHomePhone": "",
"ContactWorkPhone": "CON-TAC-WORK",
"ShipToCustomerName": "FUTURE RADIO FLYER - CARLINVILLE 62626 F/C",
"ShipToAddress1": "BT Address line 1",
"ShipToAddress2": "BT Address Line 2",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "(217) 854-4721",
"ShipToFax": null,
"ShipToShopPhone": "800-222-shop",
"ShipToEmail": null,
"AverageCost": 10.7325,
"ReplacementCost": 10.7325,
"OrderSubtotal": 19.65,
"OrderTotal": 19.65,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 8.9175,
"ReplacementCostGrossProfit": 8.9175,
"AverageCostGrossProfitMargin": 0.453816,
"ReplacementCostGrossProfitMargin": 0.453816,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": "Mid-West"
},
{
"PartsSalesOrderID": 34041,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 1720,
"BillingCustomerID": 1720,
"TaxCodeID": 11,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 2,
"JoinID": "34041",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 23,
"OrderStatus": "Quote",
"CreationDate": "2016-12-16T08:37:28.650",
"CustomerNumber": "1285",
"CompanyName": "BH01",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2016-12-16T08:38:05.323",
"AddUser": "jschesvo",
"UpdateUser": "jschesvo",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Becki Kalaher",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1285",
"BillingCompanyName": "BH01",
"TaxCode": "Taxable",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Becki Kalaher",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "BH01",
"ShipToAddress1": "101 Main",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 95.3200,
"ReplacementCost": 95.3200,
"OrderSubtotal": 176.34,
"OrderTotal": 188.68,
"SalesTaxTotal": 12.34,
"AverageCostGrossProfit": 81.0200,
"ReplacementCostGrossProfit": 81.0200,
"AverageCostGrossProfitMargin": 0.459453,
"ReplacementCostGrossProfitMargin": 0.459453,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 45118,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3805,
"BillingCustomerID": 3805,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 1,
"JoinID": "45118",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 23,
"OrderStatus": "In Process",
"CreationDate": "2018-02-14T10:48:03.787",
"CustomerNumber": "1302",
"CompanyName": "Trader Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-02-14T10:48:03.787",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": " ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1302",
"BillingCompanyName": "Trader Trucking",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": " ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Trader Trucking",
"ShipToAddress1": "1 Main St",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "ttrader@karmak.com",
"AverageCost": 10.7325,
"ReplacementCost": 10.7325,
"OrderSubtotal": 13.95,
"OrderTotal": 13.95,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 3.2175,
"ReplacementCostGrossProfit": 3.2175,
"AverageCostGrossProfitMargin": 0.230645,
"ReplacementCostGrossProfitMargin": 0.230645,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 34199,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 1720,
"BillingCustomerID": 1720,
"TaxCodeID": 11,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 25843,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 4,
"JoinID": "1024",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 24,
"OrderStatus": "Invoiced",
"CreationDate": "2017-01-03T11:57:09",
"CustomerNumber": "1285",
"CompanyName": "BH01",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-01-03T11:57:09.037",
"InvoiceNumber": "1024",
"LastUpdate": "2017-01-03T11:57:09",
"AddUser": "jschesvo",
"UpdateUser": "jschesvo",
"InvoiceUser": "jschesvo",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Becki Kalaher",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1285",
"BillingCompanyName": "BH01",
"TaxCode": "Taxable",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Becki Kalaher",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "BH01",
"ShipToAddress1": "101 Main",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 100.0000,
"ReplacementCost": 100.0000,
"OrderSubtotal": 170.00,
"OrderTotal": 170.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 70.0000,
"ReplacementCostGrossProfit": 70.0000,
"AverageCostGrossProfitMargin": 0.411764,
"ReplacementCostGrossProfitMargin": 0.411764,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "cash",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 45119,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3933,
"BillingCustomerID": 3933,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 25,
"SalesOrderStatusID": 1,
"JoinID": "45119",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 24,
"OrderStatus": "In Process",
"CreationDate": "2018-02-14T10:48:38.643",
"CustomerNumber": "9669",
"CompanyName": "ARR Trucking Company Formerly Robinson Towing Company incorporated LLC.",
"CustomerPO": "",
"PickupDeliveryMethod": "01 pickup method",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-02-14T10:48:38.643",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "9669",
"BillingCompanyName": "ARR Trucking Company Formerly Robinson Towing Company incorporated LLC.",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Anthony Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "ARR Trucking Company Formerly Robinson Towing Company incorporated LLC.",
"ShipToAddress1": "123 Black lane",
"ShipToAddress2": "",
"ShipToCity": "litchfield",
"ShipToRegion": "IL",
"ShipToPostalCode": "62056",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 10.7325,
"ReplacementCost": 10.7325,
"OrderSubtotal": 12.95,
"OrderTotal": 12.95,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 2.2175,
"ReplacementCostGrossProfit": 2.2175,
"AverageCostGrossProfitMargin": 0.171235,
"ReplacementCostGrossProfitMargin": 0.171235,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Warranty - Freightliner",
"UserDefinedPaymentMethodID": 49,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 34200,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 841,
"BillingCustomerID": 841,
"TaxCodeID": 11,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 1,
"JoinID": "34200",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 25,
"OrderStatus": "In Process",
"CreationDate": "2017-01-03T12:08:19.287",
"CustomerNumber": "01710",
"CompanyName": "A+ HOME SERVICE",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-01-03T12:08:19.287",
"AddUser": "jschesvo",
"UpdateUser": "jschesvo",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": "MICHAEL SMITH",
"BillingHomePhone": "",
"BillingWorkPhone": "3451890",
"BillingCustomerNumber": "01710",
"BillingCompanyName": "A+ HOME SERVICE",
"TaxCode": "Taxable",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Andre Tanner",
"PartsAccounting": "Internal",
"Source": "Part Counter",
"ContactName": "MICHAEL SMITH",
"ContactHomePhone": "",
"ContactWorkPhone": "3451890",
"ShipToCustomerName": "A+ HOME SERVICE",
"ShipToAddress1": "7501 E RED STREET",
"ShipToAddress2": "",
"ShipToCity": "MIAMI",
"ShipToRegion": "FL",
"ShipToPostalCode": "99522",
"ShipToOfficePhone": "345-189-0200",
"ShipToFax": "868-677-0020",
"ShipToShopPhone": "345-189-0200",
"ShipToEmail": null,
"AverageCost": 12.0000,
"ReplacementCost": 12.0000,
"OrderSubtotal": 19.60,
"OrderTotal": 19.60,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 7.6000,
"ReplacementCostGrossProfit": 7.6000,
"AverageCostGrossProfitMargin": 0.387755,
"ReplacementCostGrossProfitMargin": 0.387755,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 45533,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3827,
"BillingCustomerID": 3827,
"TaxCodeID": 11,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 30715,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 4,
"JoinID": "0826",
"CanadianTaxID": "101951655RT0001",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 26,
"OrderStatus": "Invoiced",
"CreationDate": "2018-03-07T17:18:38.670",
"CustomerNumber": "Momo",
"CompanyName": "Imogen's Casual Destruction",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-03-07T17:18:52.100",
"InvoiceNumber": "0826",
"LastUpdate": "2018-03-07T17:18:38.670",
"AddUser": "jschesvo",
"UpdateUser": "jschesvo",
"InvoiceUser": "jschesvo",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Josh Schesvold",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "Momo",
"BillingCompanyName": "Imogen's Casual Destruction",
"TaxCode": "Taxable",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Josh Schesvold",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Josh Schesvold",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Imogen's Casual Destruction",
"ShipToAddress1": "One Karmak Plaza",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "555-555-5555",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 30.0000,
"ReplacementCost": 30.0000,
"OrderSubtotal": 51.00,
"OrderTotal": 51.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 21.0000,
"ReplacementCostGrossProfit": 21.0000,
"AverageCostGrossProfitMargin": 0.411764,
"ReplacementCostGrossProfitMargin": 0.411764,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "charge",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 34211,
"BranchID": 17,
"DepartmentID": 1,
"CustomerID": 3871,
"BillingCustomerID": 3871,
"TaxCodeID": 3,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 7,
"SalesOrderStatusID": 1,
"JoinID": "34211",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "G&AA",
"PartsOrderNumber": 27,
"OrderStatus": "In Process",
"CreationDate": "2017-01-05T09:56:45.707",
"CustomerNumber": "1303",
"CompanyName": "Sutton Inc.",
"CustomerPO": "",
"PickupDeliveryMethod": "Fed Ex",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-01-05T09:56:45.707",
"AddUser": "asutton",
"UpdateUser": "asutton",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "1303",
"BillingCompanyName": "Sutton Inc.",
"TaxCode": "ex",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "Sutton Inc.",
"ShipToAddress1": "25415",
"ShipToAddress2": "",
"ShipToCity": "Girard",
"ShipToRegion": "IL",
"ShipToPostalCode": "62640",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 0.0000,
"ReplacementCost": 0.0000,
"OrderSubtotal": 250.00,
"OrderTotal": 250.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 250.0000,
"ReplacementCostGrossProfit": 250.0000,
"AverageCostGrossProfitMargin": 1.000000,
"ReplacementCostGrossProfitMargin": 1.000000,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 47082,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 1699,
"BillingCustomerID": 1699,
"TaxCodeID": 11,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 31994,
"PickupDeliveryMethodID": 23,
"SalesOrderStatusID": 4,
"JoinID": "0827",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 27,
"OrderStatus": "Invoiced",
"CreationDate": "2018-04-17T10:42:31.107",
"CustomerNumber": "1497",
"CompanyName": "Josh's Test",
"CustomerPO": "",
"PickupDeliveryMethod": "~Pickup",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-04-17T10:42:42.567",
"InvoiceNumber": "0827",
"LastUpdate": "2018-04-17T10:42:31.107",
"AddUser": "jbishop",
"UpdateUser": "jbishop",
"InvoiceUser": "jbishop",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": " ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1497",
"BillingCompanyName": "Josh's Test",
"TaxCode": "Taxable",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Josh Bishop",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": " ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Josh's Test",
"ShipToAddress1": "123 Main Street",
"ShipToAddress2": "",
"ShipToCity": "Greenfield",
"ShipToRegion": "IL",
"ShipToPostalCode": "62044",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "217-368-2074",
"ShipToEmail": "jbishop@karmak.com",
"AverageCost": 90.7500,
"ReplacementCost": 99.8250,
"OrderSubtotal": 100.80,
"OrderTotal": 105.84,
"SalesTaxTotal": 5.04,
"AverageCostGrossProfit": 10.0500,
"ReplacementCostGrossProfit": 0.9750,
"AverageCostGrossProfitMargin": 0.099702,
"ReplacementCostGrossProfitMargin": 0.009672,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "AR Charge",
"UserDefinedPaymentMethodID": 103,
"StaticPaymentMethodID": 3,
"Territory": "North West"
},
{
"PartsSalesOrderID": 34214,
"BranchID": 17,
"DepartmentID": 1,
"CustomerID": 3871,
"BillingCustomerID": 3871,
"TaxCodeID": 3,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 14,
"SalesOrderStatusID": 1,
"JoinID": "34214",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "G&AA",
"PartsOrderNumber": 28,
"OrderStatus": "In Process",
"CreationDate": "2017-01-05T11:04:12.950",
"CustomerNumber": "1303",
"CompanyName": "Sutton Inc.",
"CustomerPO": "",
"PickupDeliveryMethod": "ASCI",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-01-05T11:04:31.610",
"AddUser": "tpresley",
"UpdateUser": "tpresley",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "1303",
"BillingCompanyName": "Sutton Inc.",
"TaxCode": "ex",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "Sutton Inc.",
"ShipToAddress1": "25415",
"ShipToAddress2": "",
"ShipToCity": "Girard",
"ShipToRegion": "IL",
"ShipToPostalCode": "62640",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 2.0000,
"ReplacementCost": 2.0000,
"OrderSubtotal": 402.51,
"OrderTotal": 402.69,
"SalesTaxTotal": 0.18,
"AverageCostGrossProfit": 400.5100,
"ReplacementCostGrossProfit": 400.5100,
"AverageCostGrossProfitMargin": 0.995031,
"ReplacementCostGrossProfitMargin": 0.995031,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 47095,
"BranchID": 15,
"DepartmentID": 1,
"CustomerID": 8426,
"BillingCustomerID": 8426,
"TaxCodeID": 10,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 31998,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 5,
"JoinID": "0828",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "G&AA",
"PartsOrderNumber": 28,
"OrderStatus": "Invoiced",
"CreationDate": "2018-04-17T16:43:37.877",
"CustomerNumber": "1509",
"CompanyName": "Kayla's MackTtrucks",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-04-17T16:43:49.633",
"InvoiceNumber": "0828",
"LastUpdate": "2018-04-17T16:44:30.087",
"AddUser": "kayla",
"UpdateUser": "kayla",
"InvoiceUser": "kayla",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": " ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1509",
"BillingCompanyName": "Kayla's MackTtrucks",
"TaxCode": "Taxable Items",
"TaxBody": "Illinois",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "aaaaa aaaaa",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": " ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Kayla's MackTtrucks",
"ShipToAddress1": "960 Whitelaw ave ",
"ShipToAddress2": "",
"ShipToCity": "Wood River ",
"ShipToRegion": "IL",
"ShipToPostalCode": "62095",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "kscroggins@karmak.com",
"AverageCost": 25.6000,
"ReplacementCost": 25.6000,
"OrderSubtotal": 46.08,
"OrderTotal": 46.08,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 20.4800,
"ReplacementCostGrossProfit": 20.4800,
"AverageCostGrossProfitMargin": 0.444444,
"ReplacementCostGrossProfitMargin": 0.444444,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": true,
"PaymentMethod": "342042 ",
"UserDefinedPaymentMethodID": 165,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 47095,
"BranchID": 15,
"DepartmentID": 1,
"CustomerID": 8426,
"BillingCustomerID": 8426,
"TaxCodeID": 10,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 31998,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 5,
"JoinID": "0828.01",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "G&AA",
"PartsOrderNumber": 28,
"OrderStatus": "Voided",
"CreationDate": "2018-04-17T16:43:37.877",
"CustomerNumber": "1509",
"CompanyName": "Kayla's MackTtrucks",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-04-17T16:44:30.087",
"InvoiceNumber": "0828.01",
"LastUpdate": "2018-04-17T16:44:30.087",
"AddUser": "kayla",
"UpdateUser": "kayla",
"InvoiceUser": "kayla",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": " ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1509",
"BillingCompanyName": "Kayla's MackTtrucks",
"TaxCode": "Taxable Items",
"TaxBody": "Illinois",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "aaaaa aaaaa",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": " ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Kayla's MackTtrucks",
"ShipToAddress1": "960 Whitelaw ave ",
"ShipToAddress2": "",
"ShipToCity": "Wood River ",
"ShipToRegion": "IL",
"ShipToPostalCode": "62095",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "kscroggins@karmak.com",
"AverageCost": -25.6000,
"ReplacementCost": -25.6000,
"OrderSubtotal": -46.08,
"OrderTotal": -46.08,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": -20.4800,
"ReplacementCostGrossProfit": -20.4800,
"AverageCostGrossProfitMargin": -0.444444,
"ReplacementCostGrossProfitMargin": -0.444444,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": true,
"PaymentMethod": "342042 ",
"UserDefinedPaymentMethodID": 165,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 47095,
"BranchID": 15,
"DepartmentID": 1,
"CustomerID": 8426,
"BillingCustomerID": 8426,
"TaxCodeID": 10,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 1,
"JoinID": "47095",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "G&AA",
"PartsOrderNumber": 28,
"OrderStatus": "In Process",
"CreationDate": "2018-04-17T16:43:23.293",
"CustomerNumber": "1509",
"CompanyName": "Kayla's MackTtrucks",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-04-17T16:44:30.087",
"AddUser": "kayla",
"UpdateUser": "kayla",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": " ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1509",
"BillingCompanyName": "Kayla's MackTtrucks",
"TaxCode": "Taxable Items",
"TaxBody": "Illinois",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "aaaaa aaaaa",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": " ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Kayla's MackTtrucks",
"ShipToAddress1": "960 Whitelaw ave ",
"ShipToAddress2": "",
"ShipToCity": "Wood River ",
"ShipToRegion": "IL",
"ShipToPostalCode": "62095",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "kscroggins@karmak.com",
"AverageCost": 25.6000,
"ReplacementCost": 25.6000,
"OrderSubtotal": 46.08,
"OrderTotal": 46.08,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 20.4800,
"ReplacementCostGrossProfit": 20.4800,
"AverageCostGrossProfitMargin": 0.444444,
"ReplacementCostGrossProfitMargin": 0.444444,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Non A/R Charge ",
"UserDefinedPaymentMethodID": 165,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 34578,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 3893,
"BillingCustomerID": 3893,
"TaxCodeID": 11,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 1,
"JoinID": "34578",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 29,
"OrderStatus": "In Process",
"CreationDate": "2017-02-09T10:37:09.637",
"CustomerNumber": "1352",
"CompanyName": "PEPSI BASEBRANCH10",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-02-09T10:37:09.637",
"AddUser": "futuresakate",
"UpdateUser": "futuresakate",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "1352",
"BillingCompanyName": "PEPSI BASEBRANCH10",
"TaxCode": "Taxable",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Kate Lewis",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "PEPSI BASEBRANCH10",
"ShipToAddress1": "456 BETTER THAN COKE DR",
"ShipToAddress2": "",
"ShipToCity": "CARLINVILLE",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 23.7600,
"ReplacementCost": 23.7600,
"OrderSubtotal": 35.64,
"OrderTotal": 35.64,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 11.8800,
"ReplacementCostGrossProfit": 11.8800,
"AverageCostGrossProfitMargin": 0.333333,
"ReplacementCostGrossProfitMargin": 0.333333,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 47290,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3826,
"BillingCustomerID": 3826,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 23,
"SalesOrderStatusID": 1,
"JoinID": "47290",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 29,
"OrderStatus": "In Process",
"CreationDate": "2018-05-02T14:41:49.760",
"CustomerNumber": "11107",
"CompanyName": "Roper Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "~Pickup",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-05-02T14:42:33.857",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Cheri Roper",
"BillingHomePhone": "217-444-4444",
"BillingWorkPhone": "",
"BillingCustomerNumber": "11107",
"BillingCompanyName": "Roper Trucking",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Morgan Gress",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Cheri Roper",
"ContactHomePhone": "217-444-4444",
"ContactWorkPhone": "",
"ShipToCustomerName": "Roper Trucking",
"ShipToAddress1": "15642 Greenridge Rd",
"ShipToAddress2": "",
"ShipToCity": "Girard",
"ShipToRegion": "IL",
"ShipToPostalCode": "62640",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "croper@karmak.com",
"AverageCost": 400.0000,
"ReplacementCost": 400.0000,
"OrderSubtotal": 396.00,
"OrderTotal": 396.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": -4.0000,
"ReplacementCostGrossProfit": -4.0000,
"AverageCostGrossProfitMargin": -0.010101,
"ReplacementCostGrossProfitMargin": -0.010101,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": "West Coast"
},
{
"PartsSalesOrderID": 34581,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 3893,
"BillingCustomerID": 3893,
"TaxCodeID": 11,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 1,
"JoinID": "34581",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 30,
"OrderStatus": "In Process",
"CreationDate": "2017-02-09T10:55:24.373",
"CustomerNumber": "1352",
"CompanyName": "PEPSI BASEBRANCH10",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-02-09T10:55:24.373",
"AddUser": "futuresakate",
"UpdateUser": "futuresakate",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "1352",
"BillingCompanyName": "PEPSI BASEBRANCH10",
"TaxCode": "Taxable",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Kate Lewis",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "PEPSI BASEBRANCH10",
"ShipToAddress1": "456 BETTER THAN COKE DR",
"ShipToAddress2": "",
"ShipToCity": "CARLINVILLE",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 95.3200,
"ReplacementCost": 95.3200,
"OrderSubtotal": 176.34,
"OrderTotal": 188.68,
"SalesTaxTotal": 12.34,
"AverageCostGrossProfit": 81.0200,
"ReplacementCostGrossProfit": 81.0200,
"AverageCostGrossProfitMargin": 0.459453,
"ReplacementCostGrossProfitMargin": 0.459453,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 47296,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3826,
"BillingCustomerID": 3826,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 23,
"SalesOrderStatusID": 1,
"JoinID": "47296",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 30,
"OrderStatus": "In Process",
"CreationDate": "2018-05-02T15:15:37.757",
"CustomerNumber": "11107",
"CompanyName": "Roper Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "~Pickup",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-05-02T15:16:12.043",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Cheri Roper",
"BillingHomePhone": "217-444-4444",
"BillingWorkPhone": "",
"BillingCustomerNumber": "11107",
"BillingCompanyName": "Roper Trucking",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Morgan Gress",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Cheri Roper",
"ContactHomePhone": "217-444-4444",
"ContactWorkPhone": "",
"ShipToCustomerName": "Roper Trucking",
"ShipToAddress1": "15642 Greenridge Rd",
"ShipToAddress2": "",
"ShipToCity": "Girard",
"ShipToRegion": "IL",
"ShipToPostalCode": "62640",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "croper@karmak.com",
"AverageCost": 400.0000,
"ReplacementCost": 400.0000,
"OrderSubtotal": 396.00,
"OrderTotal": 396.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": -4.0000,
"ReplacementCostGrossProfit": -4.0000,
"AverageCostGrossProfitMargin": -0.010101,
"ReplacementCostGrossProfitMargin": -0.010101,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": "West Coast"
},
{
"PartsSalesOrderID": 36599,
"BranchID": 17,
"DepartmentID": 2,
"CustomerID": 3935,
"BillingCustomerID": 3935,
"TaxCodeID": 3,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 26554,
"PickupDeliveryMethodID": 10,
"SalesOrderStatusID": 4,
"JoinID": "1031",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Service",
"PartsOrderNumber": 31,
"OrderStatus": "Invoiced",
"CreationDate": "2017-05-04T14:50:47.877",
"CustomerNumber": "9669",
"CompanyName": "ARR Trucking Company Formerly Robinson Towing Company incorporated LLC.",
"CustomerPO": "",
"PickupDeliveryMethod": "Carlile to Alpine",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-05-04T14:50:47.223",
"InvoiceNumber": "1031",
"LastUpdate": "2017-05-04T14:50:47.877",
"AddUser": "tpresley1",
"UpdateUser": "tpresley1",
"InvoiceUser": "tpresley1",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "9669",
"BillingCompanyName": "ARR Trucking Company Formerly Robinson Towing Company incorporated LLC.",
"TaxCode": "ex",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Anthony Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "ARR Trucking Company Formerly Robinson Towing Company incorporated LLC.",
"ShipToAddress1": "123 Black Lane",
"ShipToAddress2": "",
"ShipToCity": "Litchfield ",
"ShipToRegion": "IL",
"ShipToPostalCode": "62056",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 10.0000,
"ReplacementCost": 10.0000,
"OrderSubtotal": 11.00,
"OrderTotal": 11.77,
"SalesTaxTotal": 0.77,
"AverageCostGrossProfit": 1.0000,
"ReplacementCostGrossProfit": 1.0000,
"AverageCostGrossProfitMargin": 0.090909,
"ReplacementCostGrossProfitMargin": 0.090909,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "cash",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 36600,
"BranchID": 17,
"DepartmentID": 2,
"CustomerID": 3935,
"BillingCustomerID": 3935,
"TaxCodeID": 3,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 10,
"SalesOrderStatusID": 1,
"JoinID": "36600",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Service",
"PartsOrderNumber": 32,
"OrderStatus": "In Process",
"CreationDate": "2017-05-04T14:50:49.653",
"CustomerNumber": "9669",
"CompanyName": "ARR Trucking Company Formerly Robinson Towing Company incorporated LLC.",
"CustomerPO": "",
"PickupDeliveryMethod": "Carlile to Alpine",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-05-04T14:50:49.653",
"AddUser": "tpresley1",
"UpdateUser": "tpresley1",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "9669",
"BillingCompanyName": "ARR Trucking Company Formerly Robinson Towing Company incorporated LLC.",
"TaxCode": "ex",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Anthony Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "ARR Trucking Company Formerly Robinson Towing Company incorporated LLC.",
"ShipToAddress1": "123 Black Lane",
"ShipToAddress2": "",
"ShipToCity": "Litchfield ",
"ShipToRegion": "IL",
"ShipToPostalCode": "62056",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 30.0000,
"ReplacementCost": 30.0000,
"OrderSubtotal": 30.00,
"OrderTotal": 30.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 0.0000,
"ReplacementCostGrossProfit": 0.0000,
"AverageCostGrossProfitMargin": 0.000000,
"ReplacementCostGrossProfitMargin": 0.000000,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 47299,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3826,
"BillingCustomerID": 3826,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 23,
"SalesOrderStatusID": 1,
"JoinID": "47299",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 32,
"OrderStatus": "In Process",
"CreationDate": "2018-05-03T08:12:51.603",
"CustomerNumber": "11107",
"CompanyName": "Roper Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "~Pickup",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-05-03T08:13:33.250",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Cheri Roper",
"BillingHomePhone": "217-444-4444",
"BillingWorkPhone": "",
"BillingCustomerNumber": "11107",
"BillingCompanyName": "Roper Trucking",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Morgan Gress",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Cheri Roper",
"ContactHomePhone": "217-444-4444",
"ContactWorkPhone": "",
"ShipToCustomerName": "Roper Trucking",
"ShipToAddress1": "15642 Greenridge Rd",
"ShipToAddress2": "",
"ShipToCity": "Girard",
"ShipToRegion": "IL",
"ShipToPostalCode": "62640",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "croper@karmak.com",
"AverageCost": 400.0000,
"ReplacementCost": 400.0000,
"OrderSubtotal": 720.00,
"OrderTotal": 720.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 320.0000,
"ReplacementCostGrossProfit": 320.0000,
"AverageCostGrossProfitMargin": 0.444444,
"ReplacementCostGrossProfitMargin": 0.444444,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": "West Coast"
},
{
"PartsSalesOrderID": 36601,
"BranchID": 17,
"DepartmentID": 2,
"CustomerID": 3935,
"BillingCustomerID": 3935,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 26555,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 4,
"JoinID": "1033",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Service",
"PartsOrderNumber": 33,
"OrderStatus": "Invoiced",
"CreationDate": "2017-05-04T14:54:00.890",
"CustomerNumber": "9669",
"CompanyName": "ARR Trucking Company Formerly Robinson Towing Company incorporated LLC.",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-05-04T14:54:00.497",
"InvoiceNumber": "1033",
"LastUpdate": "2017-05-04T14:54:00.890",
"AddUser": "tpresley1",
"UpdateUser": "tpresley1",
"InvoiceUser": "tpresley1",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "9669",
"BillingCompanyName": "ARR Trucking Company Formerly Robinson Towing Company incorporated LLC.",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Anthony Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "ARR Trucking Company Formerly Robinson Towing Company incorporated LLC.",
"ShipToAddress1": "123 Black Lane",
"ShipToAddress2": "",
"ShipToCity": "Litchfield ",
"ShipToRegion": "IL",
"ShipToPostalCode": "62056",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 10.0000,
"ReplacementCost": 10.0000,
"OrderSubtotal": 11.00,
"OrderTotal": 11.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 1.0000,
"ReplacementCostGrossProfit": 1.0000,
"AverageCostGrossProfitMargin": 0.090909,
"ReplacementCostGrossProfitMargin": 0.090909,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "cash",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 47310,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3826,
"BillingCustomerID": 3826,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 23,
"SalesOrderStatusID": 1,
"JoinID": "47310",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 33,
"OrderStatus": "In Process",
"CreationDate": "2018-05-03T10:03:44.700",
"CustomerNumber": "11107",
"CompanyName": "Roper Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "~Pickup",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-05-03T10:04:30.963",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Cheri Roper",
"BillingHomePhone": "217-444-4444",
"BillingWorkPhone": "",
"BillingCustomerNumber": "11107",
"BillingCompanyName": "Roper Trucking",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Morgan Gress",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Cheri Roper",
"ContactHomePhone": "217-444-4444",
"ContactWorkPhone": "",
"ShipToCustomerName": "Roper Trucking",
"ShipToAddress1": "15642 Greenridge Rd",
"ShipToAddress2": "",
"ShipToCity": "Girard",
"ShipToRegion": "IL",
"ShipToPostalCode": "62640",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "croper@karmak.com",
"AverageCost": 400.0000,
"ReplacementCost": 400.0000,
"OrderSubtotal": 720.00,
"OrderTotal": 720.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 320.0000,
"ReplacementCostGrossProfit": 320.0000,
"AverageCostGrossProfitMargin": 0.444444,
"ReplacementCostGrossProfitMargin": 0.444444,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": "West Coast"
},
{
"PartsSalesOrderID": 47312,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3826,
"BillingCustomerID": 3826,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 23,
"SalesOrderStatusID": 1,
"JoinID": "47312",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 34,
"OrderStatus": "In Process",
"CreationDate": "2018-05-03T10:13:54.217",
"CustomerNumber": "11107",
"CompanyName": "Roper Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "~Pickup",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-05-03T10:15:49.507",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Cheri Roper",
"BillingHomePhone": "217-444-4444",
"BillingWorkPhone": "",
"BillingCustomerNumber": "11107",
"BillingCompanyName": "Roper Trucking",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Morgan Gress",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Cheri Roper",
"ContactHomePhone": "217-444-4444",
"ContactWorkPhone": "",
"ShipToCustomerName": "Roper Trucking",
"ShipToAddress1": "15642 Greenridge Rd",
"ShipToAddress2": "",
"ShipToCity": "Girard",
"ShipToRegion": "IL",
"ShipToPostalCode": "62640",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "croper@karmak.com",
"AverageCost": 1200.0000,
"ReplacementCost": 1200.0000,
"OrderSubtotal": 1512.00,
"OrderTotal": 1512.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 312.0000,
"ReplacementCostGrossProfit": 312.0000,
"AverageCostGrossProfitMargin": 0.206349,
"ReplacementCostGrossProfitMargin": 0.206349,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": "West Coast"
},
{
"PartsSalesOrderID": 36952,
"BranchID": 17,
"DepartmentID": 2,
"CustomerID": 8235,
"BillingCustomerID": 8235,
"TaxCodeID": 3,
"TaxBodyID": 4,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 26750,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 4,
"JoinID": "1035",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Service",
"PartsOrderNumber": 35,
"OrderStatus": "Invoiced",
"CreationDate": "2017-06-07T09:57:26.913",
"CustomerNumber": "4153",
"CompanyName": "Cardinals Trucking Base 10",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-06-07T09:57:26.453",
"InvoiceNumber": "1035",
"LastUpdate": "2017-06-07T09:57:26.913",
"AddUser": "kfairbairnF",
"UpdateUser": "kfairbairnF",
"InvoiceUser": "kfairbairnF",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": "Cardinals Trucking ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "4153",
"BillingCompanyName": "Cardinals Trucking Base 10",
"TaxCode": "ex",
"TaxBody": "Whatever I want",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Cardinals Trucking ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Cardinals Trucking Base 10",
"ShipToAddress1": "#1 Cardinals Lane",
"ShipToAddress2": "",
"ShipToCity": "St Louis",
"ShipToRegion": "MO",
"ShipToPostalCode": "62557",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 190.6400,
"ReplacementCost": 190.6400,
"OrderSubtotal": 352.68,
"OrderTotal": 352.68,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 162.0400,
"ReplacementCostGrossProfit": 162.0400,
"AverageCostGrossProfitMargin": 0.459453,
"ReplacementCostGrossProfitMargin": 0.459453,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Charge",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 47323,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3826,
"BillingCustomerID": 3826,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 23,
"SalesOrderStatusID": 1,
"JoinID": "47323",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 35,
"OrderStatus": "In Process",
"CreationDate": "2018-05-04T08:08:47.250",
"CustomerNumber": "11107",
"CompanyName": "Roper Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "~Pickup",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-05-04T08:09:05.183",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Cheri Roper",
"BillingHomePhone": "217-444-4444",
"BillingWorkPhone": "",
"BillingCustomerNumber": "11107",
"BillingCompanyName": "Roper Trucking",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Morgan Gress",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Cheri Roper",
"ContactHomePhone": "217-444-4444",
"ContactWorkPhone": "",
"ShipToCustomerName": "Roper Trucking",
"ShipToAddress1": "15642 Greenridge Rd",
"ShipToAddress2": "",
"ShipToCity": "Girard",
"ShipToRegion": "IL",
"ShipToPostalCode": "62640",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "croper@karmak.com",
"AverageCost": 75.0000,
"ReplacementCost": 75.0000,
"OrderSubtotal": 132.50,
"OrderTotal": 132.50,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 57.5000,
"ReplacementCostGrossProfit": 57.5000,
"AverageCostGrossProfitMargin": 0.433962,
"ReplacementCostGrossProfitMargin": 0.433962,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": "West Coast"
},
{
"PartsSalesOrderID": 37391,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 8249,
"BillingCustomerID": 8249,
"TaxCodeID": 3,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 26930,
"PickupDeliveryMethodID": 14,
"SalesOrderStatusID": 4,
"JoinID": "1036",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 36,
"OrderStatus": "Invoiced",
"CreationDate": "2017-07-18T16:05:32.420",
"CustomerNumber": "1396",
"CompanyName": "132 Test",
"CustomerPO": "",
"PickupDeliveryMethod": "ASCI",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-07-18T16:05:32.470",
"InvoiceNumber": "1036",
"LastUpdate": "2017-07-18T16:05:32.420",
"AddUser": "ttrader",
"UpdateUser": "ttrader",
"InvoiceUser": "ttrader",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "1396",
"BillingCompanyName": "132 Test",
"TaxCode": "ex",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Abby H",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "132 Test",
"ShipToAddress1": "#1 Paradise beach",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 1.0000,
"ReplacementCost": 1.0000,
"OrderSubtotal": 1.70,
"OrderTotal": 1.70,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 0.7000,
"ReplacementCostGrossProfit": 0.7000,
"AverageCostGrossProfitMargin": 0.411764,
"ReplacementCostGrossProfitMargin": 0.411764,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "cash",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 47620,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3826,
"BillingCustomerID": 3826,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 23,
"SalesOrderStatusID": 1,
"JoinID": "47620",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 36,
"OrderStatus": "In Process",
"CreationDate": "2018-06-07T11:12:06.567",
"CustomerNumber": "11107",
"CompanyName": "Roper Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "~Pickup",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-06-07T11:12:06.567",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Cheri Roper",
"BillingHomePhone": "217-444-4444",
"BillingWorkPhone": "",
"BillingCustomerNumber": "11107",
"BillingCompanyName": "Roper Trucking",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Morgan Gress",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Cheri Roper",
"ContactHomePhone": "217-444-4444",
"ContactWorkPhone": "",
"ShipToCustomerName": "Roper Trucking",
"ShipToAddress1": "15642 Greenridge Rd",
"ShipToAddress2": "",
"ShipToCity": "Girard",
"ShipToRegion": "IL",
"ShipToPostalCode": "62640",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "croper@karmak.com",
"AverageCost": 44.0000,
"ReplacementCost": 44.0000,
"OrderSubtotal": 79.20,
"OrderTotal": 79.20,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 35.2000,
"ReplacementCostGrossProfit": 35.2000,
"AverageCostGrossProfitMargin": 0.444444,
"ReplacementCostGrossProfitMargin": 0.444444,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": "West Coast"
},
{
"PartsSalesOrderID": 37619,
"BranchID": 17,
"DepartmentID": 2,
"CustomerID": 3890,
"BillingCustomerID": 3890,
"TaxCodeID": 11,
"TaxBodyID": 37,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 1,
"JoinID": "37619",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Service",
"PartsOrderNumber": 37,
"OrderStatus": "In Process",
"CreationDate": "2017-08-10T12:57:47.593",
"CustomerNumber": "3676",
"CompanyName": "AR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-08-10T12:57:47.593",
"AddUser": "mgfuture",
"UpdateUser": "mgfuture",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": "Kirsten ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "AR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "St Louis City TEST",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Kirsten ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "AR Robinson's Trucking",
"ShipToAddress1": "1# Paradise Ave",
"ShipToAddress2": "",
"ShipToCity": "St Louis",
"ShipToRegion": "MO",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 22.6400,
"ReplacementCost": 22.6400,
"OrderSubtotal": 206.30,
"OrderTotal": 206.30,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 183.6600,
"ReplacementCostGrossProfit": 183.6600,
"AverageCostGrossProfitMargin": 0.890256,
"ReplacementCostGrossProfitMargin": 0.890256,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 37854,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 3890,
"BillingCustomerID": 3890,
"TaxCodeID": 11,
"TaxBodyID": 37,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 27335,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 4,
"JoinID": "1038",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 38,
"OrderStatus": "Invoiced",
"CreationDate": "2017-08-29T12:58:04.020",
"CustomerNumber": "3676",
"CompanyName": "AR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-08-29T12:58:04",
"InvoiceNumber": "1038",
"LastUpdate": "2017-08-29T12:58:04.020",
"AddUser": "davefutsa",
"UpdateUser": "davefutsa",
"InvoiceUser": "davefutsa",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": "Kirsten ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "AR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "St Louis City TEST",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Kirsten ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "AR Robinson's Trucking",
"ShipToAddress1": "1# Paradise Ave",
"ShipToAddress2": "",
"ShipToCity": "St Louis",
"ShipToRegion": "MO",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 2.0250,
"ReplacementCost": 2.0250,
"OrderSubtotal": 100.00,
"OrderTotal": 100.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 97.9750,
"ReplacementCostGrossProfit": 97.9750,
"AverageCostGrossProfitMargin": 0.979750,
"ReplacementCostGrossProfitMargin": 0.979750,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Advertising - Buses",
"UserDefinedPaymentMethodID": 48,
"StaticPaymentMethodID": 2,
"Territory": ""
},
{
"PartsSalesOrderID": 47646,
"BranchID": 15,
"DepartmentID": 1,
"CustomerID": 8426,
"BillingCustomerID": 8426,
"TaxCodeID": 25,
"TaxBodyID": 90,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 32247,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 4,
"JoinID": "0838",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "G&AA",
"PartsOrderNumber": 38,
"OrderStatus": "Invoiced",
"CreationDate": "2018-06-11T13:35:12.443",
"CustomerNumber": "1509",
"CompanyName": "Kayla's MackTtrucks",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-06-11T13:35:44.993",
"InvoiceNumber": "0838",
"LastUpdate": "2018-06-11T13:35:12.443",
"AddUser": "kayla",
"UpdateUser": "kayla",
"InvoiceUser": "kayla",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": " ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "1509",
"BillingCompanyName": "Kayla's MackTtrucks",
"TaxCode": "Exempt/Taxable",
"TaxBody": "Kansas354413",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "aaaaa aaaaa",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": " ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Kayla's MackTtrucks",
"ShipToAddress1": "1234 Main St.",
"ShipToAddress2": "",
"ShipToCity": "Test",
"ShipToRegion": "KS",
"ShipToPostalCode": "12345",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "kscroggins@karmak.com",
"AverageCost": 0.0000,
"ReplacementCost": 0.0000,
"OrderSubtotal": 50.00,
"OrderTotal": 50.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 50.0000,
"ReplacementCostGrossProfit": 50.0000,
"AverageCostGrossProfitMargin": 1.000000,
"ReplacementCostGrossProfitMargin": 1.000000,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Charge",
"UserDefinedPaymentMethodID": 103,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 37856,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 3890,
"BillingCustomerID": 3890,
"TaxCodeID": 11,
"TaxBodyID": 37,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 1,
"JoinID": "37856",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 39,
"OrderStatus": "In Process",
"CreationDate": "2017-08-29T13:15:25.050",
"CustomerNumber": "3676",
"CompanyName": "AR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-08-29T13:15:25.050",
"AddUser": "davefutsa",
"UpdateUser": "davefutsa",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": "Kirsten ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "AR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "St Louis City TEST",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Kirsten ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "AR Robinson's Trucking",
"ShipToAddress1": "1# Paradise Ave",
"ShipToAddress2": "",
"ShipToCity": "St Louis",
"ShipToRegion": "MO",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 8.8800,
"ReplacementCost": 8.8800,
"OrderSubtotal": 100.00,
"OrderTotal": 100.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 91.1200,
"ReplacementCostGrossProfit": 91.1200,
"AverageCostGrossProfitMargin": 0.911200,
"ReplacementCostGrossProfitMargin": 0.911200,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Advertising - Buses",
"UserDefinedPaymentMethodID": 48,
"StaticPaymentMethodID": 2,
"Territory": ""
},
{
"PartsSalesOrderID": 47893,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3912,
"BillingCustomerID": 3912,
"TaxCodeID": 11,
"TaxBodyID": 41,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 32390,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 4,
"JoinID": "0839",
"CanadianTaxID": "134908359RT0001",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 39,
"OrderStatus": "Invoiced",
"CreationDate": "2018-06-27T12:15:40.517",
"CustomerNumber": "MISC2",
"CompanyName": "miscellaneous account",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-06-27T12:16:44.457",
"InvoiceNumber": "0839",
"LastUpdate": "2018-06-27T12:15:40.517",
"AddUser": "bbaker",
"UpdateUser": "bbaker",
"InvoiceUser": "bbaker",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "MISC2",
"BillingCompanyName": "miscellaneous account",
"TaxCode": "Taxable",
"TaxBody": "Ontario",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "sarah smith",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "Beth Baker",
"ShipToAddress1": "5000",
"ShipToAddress2": "",
"ShipToCity": "London ",
"ShipToRegion": "ON",
"ShipToPostalCode": "",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": -250.0000,
"ReplacementCost": -250.0000,
"OrderSubtotal": -1250.00,
"OrderTotal": -1250.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": -1000.0000,
"ReplacementCostGrossProfit": -1000.0000,
"AverageCostGrossProfitMargin": 0.800000,
"ReplacementCostGrossProfitMargin": 0.800000,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 38033,
"BranchID": 17,
"DepartmentID": 2,
"CustomerID": 3890,
"BillingCustomerID": 3890,
"TaxCodeID": 11,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 27464,
"PickupDeliveryMethodID": 14,
"SalesOrderStatusID": 4,
"JoinID": "1040",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Service",
"PartsOrderNumber": 40,
"OrderStatus": "Invoiced",
"CreationDate": "2017-09-08T12:28:48.453",
"CustomerNumber": "3676",
"CompanyName": "AR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "ASCI",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-09-08T12:28:48.640",
"InvoiceNumber": "1040",
"LastUpdate": "2017-09-08T12:28:48.453",
"AddUser": "kfairbairnF",
"UpdateUser": "kfairbairnF",
"InvoiceUser": "kfairbairnF",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": "Kirsten ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "AR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Kirsten ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "AR Robinson's Trucking",
"ShipToAddress1": "1# Paradise Ave",
"ShipToAddress2": "",
"ShipToCity": "St Louis",
"ShipToRegion": "MO",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 10.0000,
"ReplacementCost": 10.0000,
"OrderSubtotal": 11.00,
"OrderTotal": 11.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 1.0000,
"ReplacementCostGrossProfit": 1.0000,
"AverageCostGrossProfitMargin": 0.090909,
"ReplacementCostGrossProfitMargin": 0.090909,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Advertising - Buses",
"UserDefinedPaymentMethodID": 48,
"StaticPaymentMethodID": 2,
"Territory": ""
},
{
"PartsSalesOrderID": 47896,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3912,
"BillingCustomerID": 3912,
"TaxCodeID": 11,
"TaxBodyID": 41,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 32393,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 4,
"JoinID": "0840",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 40,
"OrderStatus": "Invoiced",
"CreationDate": "2018-06-27T12:21:53.603",
"CustomerNumber": "MISC2",
"CompanyName": "miscellaneous account",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-06-27T12:22:57.533",
"InvoiceNumber": "0840",
"LastUpdate": "2018-06-27T12:21:53.603",
"AddUser": "bbaker",
"UpdateUser": "bbaker",
"InvoiceUser": "bbaker",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "MISC2",
"BillingCompanyName": "miscellaneous account",
"TaxCode": "Taxable",
"TaxBody": "Ontario",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "sarah smith",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "5000",
"ShipToAddress1": "Test",
"ShipToAddress2": "",
"ShipToCity": "London",
"ShipToRegion": "ON",
"ShipToPostalCode": "",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 39.0000,
"ReplacementCost": 39.0000,
"OrderSubtotal": 70.20,
"OrderTotal": 70.20,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 31.2000,
"ReplacementCostGrossProfit": 31.2000,
"AverageCostGrossProfitMargin": 0.444444,
"ReplacementCostGrossProfitMargin": 0.444444,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 2,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 38296,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 841,
"BillingCustomerID": 841,
"TaxCodeID": 11,
"TaxBodyID": 6,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 1,
"JoinID": "38296",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 41,
"OrderStatus": "In Process",
"CreationDate": "2017-09-28T15:14:48.803",
"CustomerNumber": "01710",
"CompanyName": "A+ HOME SERVICE",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-09-28T15:14:48.803",
"AddUser": "karmak",
"UpdateUser": "karmak",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": "MICHAEL SMITH",
"BillingHomePhone": "",
"BillingWorkPhone": "3451890",
"BillingCustomerNumber": "01710",
"BillingCompanyName": "A+ HOME SERVICE",
"TaxCode": "Taxable",
"TaxBody": "FL",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Andre Tanner",
"PartsAccounting": "Internal",
"Source": "Part Counter",
"ContactName": "MICHAEL SMITH",
"ContactHomePhone": "",
"ContactWorkPhone": "3451890",
"ShipToCustomerName": "A+ HOME SERVICE",
"ShipToAddress1": "7501 E RED STREET",
"ShipToAddress2": "",
"ShipToCity": "MIAMI",
"ShipToRegion": "FL",
"ShipToPostalCode": "99522",
"ShipToOfficePhone": "345-189-0200",
"ShipToFax": "868-677-0020",
"ShipToShopPhone": "345-189-0200",
"ShipToEmail": null,
"AverageCost": 158.9121,
"ReplacementCost": 158.9121,
"OrderSubtotal": 293.99,
"OrderTotal": 293.99,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 135.0779,
"ReplacementCostGrossProfit": 135.0779,
"AverageCostGrossProfitMargin": 0.459464,
"ReplacementCostGrossProfitMargin": 0.459464,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 47897,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3912,
"BillingCustomerID": 3912,
"TaxCodeID": 11,
"TaxBodyID": 41,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 32394,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 4,
"JoinID": "0841",
"CanadianTaxID": "134908359RT0001",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 41,
"OrderStatus": "Invoiced",
"CreationDate": "2018-06-27T12:22:53.273",
"CustomerNumber": "MISC2",
"CompanyName": "miscellaneous account",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-06-27T12:23:57.220",
"InvoiceNumber": "0841",
"LastUpdate": "2018-06-27T12:22:53.273",
"AddUser": "bbaker",
"UpdateUser": "bbaker",
"InvoiceUser": "bbaker",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "MISC2",
"BillingCompanyName": "miscellaneous account",
"TaxCode": "Taxable",
"TaxBody": "Ontario",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "sarah smith",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "Beth",
"ShipToAddress1": "Test",
"ShipToAddress2": "",
"ShipToCity": "London",
"ShipToRegion": "ON",
"ShipToPostalCode": "",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": -19.0000,
"ReplacementCost": -19.0000,
"OrderSubtotal": -34.20,
"OrderTotal": -34.20,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": -15.2000,
"ReplacementCostGrossProfit": -15.2000,
"AverageCostGrossProfitMargin": 0.444444,
"ReplacementCostGrossProfitMargin": 0.444444,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 43229,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 8249,
"BillingCustomerID": 8249,
"TaxCodeID": 3,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 14,
"SalesOrderStatusID": 1,
"JoinID": "43229",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 42,
"OrderStatus": "In Process",
"CreationDate": "2017-12-13T15:43:18.897",
"CustomerNumber": "1396",
"CompanyName": "132 Test",
"CustomerPO": "",
"PickupDeliveryMethod": "ASCI",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-12-13T15:47:22.153",
"AddUser": "vseabolt",
"UpdateUser": "vseabolt",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "1396",
"BillingCompanyName": "132 Test",
"TaxCode": "ex",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Abby H",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "132 Test",
"ShipToAddress1": "#1 Paradise beach",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 100.0000,
"ReplacementCost": 100.0000,
"OrderSubtotal": 170.00,
"OrderTotal": 170.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 70.0000,
"ReplacementCostGrossProfit": 70.0000,
"AverageCostGrossProfitMargin": 0.411764,
"ReplacementCostGrossProfitMargin": 0.411764,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 49115,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3826,
"BillingCustomerID": 3826,
"TaxCodeID": 3,
"TaxBodyID": 41,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 23,
"SalesOrderStatusID": 1,
"JoinID": "49115",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 42,
"OrderStatus": "In Process",
"CreationDate": "2018-07-19T10:52:43.880",
"CustomerNumber": "11107",
"CompanyName": "Roper Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "~Pickup",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-07-19T10:52:43.880",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Cheri Roper",
"BillingHomePhone": "217-444-4444",
"BillingWorkPhone": "",
"BillingCustomerNumber": "11107",
"BillingCompanyName": "Roper Trucking",
"TaxCode": "ex",
"TaxBody": "Ontario",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Morgan Gress",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Cheri Roper",
"ContactHomePhone": "217-444-4444",
"ContactWorkPhone": "",
"ShipToCustomerName": "Roper Trucking",
"ShipToAddress1": "15642 Greenridge Rd",
"ShipToAddress2": "",
"ShipToCity": "Girard",
"ShipToRegion": "IL",
"ShipToPostalCode": "62640",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "croper@karmak.com",
"AverageCost": 2.0000,
"ReplacementCost": 2.0000,
"OrderSubtotal": 3.60,
"OrderTotal": 3.60,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 1.6000,
"ReplacementCostGrossProfit": 1.6000,
"AverageCostGrossProfitMargin": 0.444444,
"ReplacementCostGrossProfitMargin": 0.444444,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": "West Coast"
},
{
"PartsSalesOrderID": 43230,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 8249,
"BillingCustomerID": 8249,
"TaxCodeID": 3,
"TaxBodyID": 1,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 14,
"SalesOrderStatusID": 1,
"JoinID": "43230",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 43,
"OrderStatus": "In Process",
"CreationDate": "2017-12-13T15:48:34.523",
"CustomerNumber": "1396",
"CompanyName": "132 Test",
"CustomerPO": "",
"PickupDeliveryMethod": "ASCI",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-12-13T15:48:36.673",
"AddUser": "vseabolt",
"UpdateUser": "vseabolt",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "1396",
"BillingCompanyName": "132 Test",
"TaxCode": "ex",
"TaxBody": "Alaska Tax Body",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Abby H",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "132 Test",
"ShipToAddress1": "#1 Paradise beach",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 50.0000,
"ReplacementCost": 50.0000,
"OrderSubtotal": 85.00,
"OrderTotal": 85.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 35.0000,
"ReplacementCostGrossProfit": 35.0000,
"AverageCostGrossProfitMargin": 0.411764,
"ReplacementCostGrossProfitMargin": 0.411764,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 49379,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3826,
"BillingCustomerID": 3826,
"TaxCodeID": 3,
"TaxBodyID": 41,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 23,
"SalesOrderStatusID": 1,
"JoinID": "49379",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 43,
"OrderStatus": "In Process",
"CreationDate": "2018-08-09T10:32:35.693",
"CustomerNumber": "11107",
"CompanyName": "Roper Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "~Pickup",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-08-09T10:32:35.693",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Cheri Roper",
"BillingHomePhone": "217-444-4444",
"BillingWorkPhone": "",
"BillingCustomerNumber": "11107",
"BillingCompanyName": "Roper Trucking",
"TaxCode": "ex",
"TaxBody": "Ontario",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Morgan Gress",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Cheri Roper",
"ContactHomePhone": "217-444-4444",
"ContactWorkPhone": "",
"ShipToCustomerName": "Roper Trucking",
"ShipToAddress1": "15642 Greenridge Rd",
"ShipToAddress2": "",
"ShipToCity": "Girard",
"ShipToRegion": "IL",
"ShipToPostalCode": "62640",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "croper@karmak.com",
"AverageCost": 8.6682,
"ReplacementCost": 5.0000,
"OrderSubtotal": 9.00,
"OrderTotal": 9.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 0.3318,
"ReplacementCostGrossProfit": 4.0000,
"AverageCostGrossProfitMargin": 0.036866,
"ReplacementCostGrossProfitMargin": 0.444444,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": "West Coast"
},
{
"PartsSalesOrderID": 45029,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 3956,
"BillingCustomerID": 3956,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 30463,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 5,
"JoinID": "1044",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 44,
"OrderStatus": "Invoiced",
"CreationDate": "2018-02-07T13:51:22.880",
"CustomerNumber": "2506",
"CompanyName": "A & B Truck Repair",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-02-07T13:50:08",
"InvoiceNumber": "1044",
"LastUpdate": "2018-02-07T13:51:17.390",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "2506",
"BillingCompanyName": "A & B Truck Repair",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Beth Baker",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "A & B Truck Repair",
"ShipToAddress1": "1044 North Rte 4",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "bbaker@karmak.com",
"AverageCost": 200.0000,
"ReplacementCost": 200.0000,
"OrderSubtotal": 200.00,
"OrderTotal": 200.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 0.0000,
"ReplacementCostGrossProfit": 0.0000,
"AverageCostGrossProfitMargin": 0.000000,
"ReplacementCostGrossProfitMargin": 0.000000,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": true,
"PaymentMethod": "LAR Open Item",
"UserDefinedPaymentMethodID": 153,
"StaticPaymentMethodID": 3,
"Territory": "Mid-West"
},
{
"PartsSalesOrderID": 45029,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 3956,
"BillingCustomerID": 3956,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 30463,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 5,
"JoinID": "1044.01",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 44,
"OrderStatus": "Voided",
"CreationDate": "2018-02-07T13:51:22.880",
"CustomerNumber": "2506",
"CompanyName": "A & B Truck Repair",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-02-07T13:51:17.390",
"InvoiceNumber": "1044.01",
"LastUpdate": "2018-02-07T13:51:17.390",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "2506",
"BillingCompanyName": "A & B Truck Repair",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Beth Baker",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "A & B Truck Repair",
"ShipToAddress1": "1044 North Rte 4",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "bbaker@karmak.com",
"AverageCost": -200.0000,
"ReplacementCost": -200.0000,
"OrderSubtotal": -200.00,
"OrderTotal": -200.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 0.0000,
"ReplacementCostGrossProfit": 0.0000,
"AverageCostGrossProfitMargin": 0.000000,
"ReplacementCostGrossProfitMargin": 0.000000,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": true,
"PaymentMethod": "LAR Open Item",
"UserDefinedPaymentMethodID": 153,
"StaticPaymentMethodID": 3,
"Territory": "Mid-West"
},
{
"PartsSalesOrderID": 45029,
"BranchID": 17,
"DepartmentID": 3,
"CustomerID": 3956,
"BillingCustomerID": 3956,
"TaxCodeID": 3,
"TaxBodyID": 12,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 30464,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 4,
"JoinID": "1044.02",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "ROCHESTER",
"Department": "Parts",
"PartsOrderNumber": 44,
"OrderStatus": "Invoiced",
"CreationDate": "2018-02-07T13:52:36.343",
"CustomerNumber": "2506",
"CompanyName": "A & B Truck Repair",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-02-07T13:51:21.530",
"InvoiceNumber": "1044.02",
"LastUpdate": "2018-02-07T13:52:36.343",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "2506",
"BillingCompanyName": "A & B Truck Repair",
"TaxCode": "ex",
"TaxBody": "Illinois",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Beth Baker",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "A & B Truck Repair",
"ShipToAddress1": "1044 North Rte 4",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "bbaker@karmak.com",
"AverageCost": 200.0000,
"ReplacementCost": 200.0000,
"OrderSubtotal": 200.00,
"OrderTotal": 200.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 0.0000,
"ReplacementCostGrossProfit": 0.0000,
"AverageCostGrossProfitMargin": 0.000000,
"ReplacementCostGrossProfitMargin": 0.000000,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "LAR Open Item",
"UserDefinedPaymentMethodID": 153,
"StaticPaymentMethodID": 3,
"Territory": "Mid-West"
},
{
"PartsSalesOrderID": 49380,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3826,
"BillingCustomerID": 3826,
"TaxCodeID": 3,
"TaxBodyID": 41,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 23,
"SalesOrderStatusID": 1,
"JoinID": "49380",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 44,
"OrderStatus": "In Process",
"CreationDate": "2018-08-09T10:41:48.047",
"CustomerNumber": "11107",
"CompanyName": "Roper Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "~Pickup",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-08-09T10:41:48.047",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Cheri Roper",
"BillingHomePhone": "217-444-4444",
"BillingWorkPhone": "",
"BillingCustomerNumber": "11107",
"BillingCompanyName": "Roper Trucking",
"TaxCode": "ex",
"TaxBody": "Ontario",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Morgan Gress",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Cheri Roper",
"ContactHomePhone": "217-444-4444",
"ContactWorkPhone": "",
"ShipToCustomerName": "Roper Trucking",
"ShipToAddress1": "15642 Greenridge Rd",
"ShipToAddress2": "",
"ShipToCity": "Girard",
"ShipToRegion": "IL",
"ShipToPostalCode": "62640",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "croper@karmak.com",
"AverageCost": 17.3364,
"ReplacementCost": 10.0000,
"OrderSubtotal": 18.00,
"OrderTotal": 18.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 0.6636,
"ReplacementCostGrossProfit": 8.0000,
"AverageCostGrossProfitMargin": 0.036866,
"ReplacementCostGrossProfitMargin": 0.444444,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 2,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": "West Coast"
},
{
"PartsSalesOrderID": 49418,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3826,
"BillingCustomerID": 3826,
"TaxCodeID": 3,
"TaxBodyID": 41,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 23,
"SalesOrderStatusID": 1,
"JoinID": "49418",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 45,
"OrderStatus": "In Process",
"CreationDate": "2018-08-13T15:30:09.913",
"CustomerNumber": "11107",
"CompanyName": "Roper Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "~Pickup",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-08-13T15:30:09.913",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Cheri Roper",
"BillingHomePhone": "217-444-4444",
"BillingWorkPhone": "",
"BillingCustomerNumber": "11107",
"BillingCompanyName": "Roper Trucking",
"TaxCode": "ex",
"TaxBody": "Ontario",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Morgan Gress",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Cheri Roper",
"ContactHomePhone": "217-444-4444",
"ContactWorkPhone": "",
"ShipToCustomerName": "Roper Trucking",
"ShipToAddress1": "15642 Greenridge Rd",
"ShipToAddress2": "",
"ShipToCity": "Girard",
"ShipToRegion": "IL",
"ShipToPostalCode": "62640",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "croper@karmak.com",
"AverageCost": 45.0000,
"ReplacementCost": 45.0000,
"OrderSubtotal": 81.00,
"OrderTotal": 81.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 36.0000,
"ReplacementCostGrossProfit": 36.0000,
"AverageCostGrossProfitMargin": 0.444444,
"ReplacementCostGrossProfitMargin": 0.444444,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": "West Coast"
},
{
"PartsSalesOrderID": 49566,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3826,
"BillingCustomerID": 3826,
"TaxCodeID": 3,
"TaxBodyID": 41,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 23,
"SalesOrderStatusID": 1,
"JoinID": "49566",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 46,
"OrderStatus": "In Process",
"CreationDate": "2018-08-28T14:17:28.263",
"CustomerNumber": "11107",
"CompanyName": "Roper Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "~Pickup",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-08-28T14:17:28.263",
"AddUser": "croper",
"UpdateUser": "croper",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Cheri Roper",
"BillingHomePhone": "217-444-4444",
"BillingWorkPhone": "",
"BillingCustomerNumber": "11107",
"BillingCompanyName": "Roper Trucking",
"TaxCode": "ex",
"TaxBody": "Ontario",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Morgan Gress",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Cheri Roper",
"ContactHomePhone": "217-444-4444",
"ContactWorkPhone": "",
"ShipToCustomerName": "Roper Trucking",
"ShipToAddress1": "15642 Greenridge Rd",
"ShipToAddress2": "",
"ShipToCity": "Girard",
"ShipToRegion": "IL",
"ShipToPostalCode": "62640",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "croper@karmak.com",
"AverageCost": 50.0000,
"ReplacementCost": 50.0000,
"OrderSubtotal": 90.00,
"OrderTotal": 90.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 40.0000,
"ReplacementCostGrossProfit": 40.0000,
"AverageCostGrossProfitMargin": 0.444444,
"ReplacementCostGrossProfitMargin": 0.444444,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Cash1",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": "West Coast"
},
{
"PartsSalesOrderID": 29415,
"BranchID": 4,
"DepartmentID": 3,
"CustomerID": 1437,
"BillingCustomerID": 1437,
"TaxCodeID": 6,
"TaxBodyID": 6,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 22401,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 4,
"JoinID": "550",
"CanadianTaxID": null,
"QuebecTaxID": null,
"Division": "Future1",
"Branch": "JBE1",
"Department": "Parts",
"PartsOrderNumber": 50,
"OrderStatus": "Invoiced",
"CreationDate": "2016-01-25T13:33:11.200",
"CustomerNumber": "1207",
"CompanyName": "Renee's Garbage Pickers",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2016-01-25T13:33:11.163",
"InvoiceNumber": "550",
"LastUpdate": "2016-01-25T13:33:11.200",
"AddUser": "futuresakate",
"UpdateUser": "futuresakate",
"InvoiceUser": "futuresakate",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "1207",
"BillingCompanyName": "Renee's Garbage Pickers",
"TaxCode": "Taxable - No Tire Tax",
"TaxBody": "FL",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "Billy Stacy",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "Renee's Garbage Pickers",
"ShipToAddress1": "123 Main Street",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 18000.0000,
"ReplacementCost": 18000.0000,
"OrderSubtotal": 20000.00,
"OrderTotal": 20000.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 2000.0000,
"ReplacementCostGrossProfit": 2000.0000,
"AverageCostGrossProfitMargin": 0.100000,
"ReplacementCostGrossProfitMargin": 0.100000,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "cash",
"UserDefinedPaymentMethodID": 1,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 34217,
"BranchID": 4,
"DepartmentID": 3,
"CustomerID": 3837,
"BillingCustomerID": 3837,
"TaxCodeID": 3,
"TaxBodyID": 6,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 1,
"JoinID": "34217",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "JBE1",
"Department": "Parts",
"PartsOrderNumber": 51,
"OrderStatus": "In Process",
"CreationDate": "2017-01-05T13:24:28.113",
"CustomerNumber": "1323",
"CompanyName": "Choklad - Base Branch 10",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-01-05T13:24:28.113",
"AddUser": "futuresakate",
"UpdateUser": "futuresakate",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "1323",
"BillingCompanyName": "Choklad - Base Branch 10",
"TaxCode": "ex",
"TaxBody": "FL",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "Choklad - Base Branch 10",
"ShipToAddress1": "Bill-To Address 1",
"ShipToAddress2": "Bill-To Address 2",
"ShipToCity": "Bill-To City",
"ShipToRegion": "IL",
"ShipToPostalCode": "Postal",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 730.7270,
"ReplacementCost": 730.7270,
"OrderSubtotal": 500.00,
"OrderTotal": 500.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": -230.7270,
"ReplacementCostGrossProfit": -230.7270,
"AverageCostGrossProfitMargin": -0.461454,
"ReplacementCostGrossProfitMargin": -0.461454,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 34238,
"BranchID": 4,
"DepartmentID": 1,
"CustomerID": 3837,
"BillingCustomerID": 3837,
"TaxCodeID": 3,
"TaxBodyID": 14,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 25857,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 4,
"JoinID": "JBE152",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "JBE1",
"Department": "G&AA",
"PartsOrderNumber": 52,
"OrderStatus": "Invoiced",
"CreationDate": "2017-01-06T15:14:53.617",
"CustomerNumber": "1323",
"CompanyName": "Choklad - Base Branch 10",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-01-06T15:14:53.470",
"InvoiceNumber": "JBE152",
"LastUpdate": "2017-01-06T15:14:53.617",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "1323",
"BillingCompanyName": "Choklad - Base Branch 10",
"TaxCode": "ex",
"TaxBody": "Carlinville",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "Choklad - Base Branch 10",
"ShipToAddress1": "Bill-To Address 1",
"ShipToAddress2": "Bill-To Address 2",
"ShipToCity": "Bill-To City",
"ShipToRegion": "IL",
"ShipToPostalCode": "Postal",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 20.0000,
"ReplacementCost": 20.0000,
"OrderSubtotal": 37.00,
"OrderTotal": 37.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 17.0000,
"ReplacementCostGrossProfit": 17.0000,
"AverageCostGrossProfitMargin": 0.459459,
"ReplacementCostGrossProfitMargin": 0.459459,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Charge",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 49622,
"BranchID": 15,
"DepartmentID": 3,
"CustomerID": 3827,
"BillingCustomerID": 3827,
"TaxCodeID": 11,
"TaxBodyID": 41,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 1,
"JoinID": "49622",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "Parts",
"PartsOrderNumber": 52,
"OrderStatus": "In Process",
"CreationDate": "2018-09-04T16:23:55.960",
"CustomerNumber": "Momo",
"CompanyName": "Imogen's Casual Destruction",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2018-09-04T16:24:44.330",
"AddUser": "jschesvo",
"UpdateUser": "jschesvo",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Josh Schesvold",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "Momo",
"BillingCompanyName": "Imogen's Casual Destruction",
"TaxCode": "Taxable",
"TaxBody": "Ontario",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": "josh josh",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Josh Schesvold",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Imogen's Casual Destruction",
"ShipToAddress1": "Test",
"ShipToAddress2": "",
"ShipToCity": "Carlinville,",
"ShipToRegion": "IL",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "555-555-5555",
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "jschesvold@karmak.com",
"AverageCost": 30.0000,
"ReplacementCost": 30.0000,
"OrderSubtotal": 53.97,
"OrderTotal": 53.97,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 23.9700,
"ReplacementCostGrossProfit": 23.9700,
"AverageCostGrossProfitMargin": 0.444135,
"ReplacementCostGrossProfitMargin": 0.444135,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Advertising - Sprinter",
"UserDefinedPaymentMethodID": 47,
"StaticPaymentMethodID": 3,
"Territory": ""
},
{
"PartsSalesOrderID": 34435,
"BranchID": 4,
"DepartmentID": 2,
"CustomerID": 3837,
"BillingCustomerID": 3837,
"TaxCodeID": 3,
"TaxBodyID": 6,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 10,
"SalesOrderStatusID": 1,
"JoinID": "34435",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "JBE1",
"Department": "Service",
"PartsOrderNumber": 53,
"OrderStatus": "In Process",
"CreationDate": "2017-01-27T15:26:16.107",
"CustomerNumber": "1323",
"CompanyName": "Choklad - Base Branch 10",
"CustomerPO": "",
"PickupDeliveryMethod": "Carlile to Alpine",
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-01-27T15:26:16.107",
"AddUser": "tpresley",
"UpdateUser": "tpresley",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "1323",
"BillingCompanyName": "Choklad - Base Branch 10",
"TaxCode": "ex",
"TaxBody": "FL",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "Choklad - Base Branch 10",
"ShipToAddress1": "Bill-To Address 1",
"ShipToAddress2": "Bill-To Address 2",
"ShipToCity": "Bill-To City",
"ShipToRegion": "IL",
"ShipToPostalCode": "Postal",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 20.0000,
"ReplacementCost": 20.0000,
"OrderSubtotal": 2.00,
"OrderTotal": 2.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": -18.0000,
"ReplacementCostGrossProfit": -18.0000,
"AverageCostGrossProfitMargin": -9.000000,
"ReplacementCostGrossProfitMargin": -9.000000,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 50494,
"BranchID": 15,
"DepartmentID": 1,
"CustomerID": 1700,
"BillingCustomerID": 1700,
"TaxCodeID": 11,
"TaxBodyID": 31,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 34064,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 4,
"JoinID": "0853",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "G&AA",
"PartsOrderNumber": 53,
"OrderStatus": "Invoiced",
"CreationDate": "2018-11-16T07:52:57.350",
"CustomerNumber": "3676",
"CompanyName": "KLBKR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-11-16T07:54:44.423",
"InvoiceNumber": "0853",
"LastUpdate": "2018-11-16T07:52:57.350",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Lori R",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "KLBKR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "Waggoner town",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Lori R",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "KLBKR Robinson's Trucking",
"ShipToAddress1": "#1 Plaza dr",
"ShipToAddress2": "",
"ShipToCity": "waggoner",
"ShipToRegion": "IL",
"ShipToPostalCode": "",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": -10407.0000,
"ReplacementCost": -10407.0000,
"OrderSubtotal": 1500.00,
"OrderTotal": 1575.00,
"SalesTaxTotal": 75.00,
"AverageCostGrossProfit": 11907.0000,
"ReplacementCostGrossProfit": 11907.0000,
"AverageCostGrossProfitMargin": 7.938000,
"ReplacementCostGrossProfitMargin": 7.938000,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Wire",
"UserDefinedPaymentMethodID": 19,
"StaticPaymentMethodID": 17,
"Territory": ""
},
{
"PartsSalesOrderID": 34436,
"BranchID": 4,
"DepartmentID": 2,
"CustomerID": 3837,
"BillingCustomerID": 3837,
"TaxCodeID": 3,
"TaxBodyID": 14,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 1,
"JoinID": "34436",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "JBE1",
"Department": "Service",
"PartsOrderNumber": 54,
"OrderStatus": "In Process",
"CreationDate": "2017-01-27T15:33:08.180",
"CustomerNumber": "1323",
"CompanyName": "Choklad - Base Branch 10",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-01-27T15:37:50.520",
"AddUser": "tpresley",
"UpdateUser": "tpresley",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": null,
"BillingHomePhone": null,
"BillingWorkPhone": null,
"BillingCustomerNumber": "1323",
"BillingCompanyName": "Choklad - Base Branch 10",
"TaxCode": "ex",
"TaxBody": "Carlinville",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": null,
"ContactHomePhone": null,
"ContactWorkPhone": null,
"ShipToCustomerName": "Choklad - Base Branch 10",
"ShipToAddress1": "Bill-To Address 1",
"ShipToAddress2": "Bill-To Address 2",
"ShipToCity": "Bill-To City",
"ShipToRegion": "IL",
"ShipToPostalCode": "Postal",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": null,
"AverageCost": 60.0000,
"ReplacementCost": 60.0000,
"OrderSubtotal": 40.00,
"OrderTotal": 40.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": -20.0000,
"ReplacementCostGrossProfit": -20.0000,
"AverageCostGrossProfitMargin": -0.500000,
"ReplacementCostGrossProfitMargin": -0.500000,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 50496,
"BranchID": 15,
"DepartmentID": 1,
"CustomerID": 1700,
"BillingCustomerID": 1700,
"TaxCodeID": 11,
"TaxBodyID": 31,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 34065,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 4,
"JoinID": "0854",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "G&AA",
"PartsOrderNumber": 54,
"OrderStatus": "Invoiced",
"CreationDate": "2018-11-16T07:54:03.907",
"CustomerNumber": "3676",
"CompanyName": "KLBKR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-11-16T07:55:51.377",
"InvoiceNumber": "0854",
"LastUpdate": "2018-11-16T07:54:03.907",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Lori R",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "KLBKR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "Waggoner town",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Lori R",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "KLBKR Robinson's Trucking",
"ShipToAddress1": "#1 Plaza dr",
"ShipToAddress2": "",
"ShipToCity": "waggoner",
"ShipToRegion": "IL",
"ShipToPostalCode": "",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": -1040.7000,
"ReplacementCost": -1040.7000,
"OrderSubtotal": 150.00,
"OrderTotal": 157.50,
"SalesTaxTotal": 7.50,
"AverageCostGrossProfit": 1190.7000,
"ReplacementCostGrossProfit": 1190.7000,
"AverageCostGrossProfitMargin": 7.938000,
"ReplacementCostGrossProfitMargin": 7.938000,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Wire",
"UserDefinedPaymentMethodID": 19,
"StaticPaymentMethodID": 17,
"Territory": ""
},
{
"PartsSalesOrderID": 34561,
"BranchID": 4,
"DepartmentID": 3,
"CustomerID": 1732,
"BillingCustomerID": 1732,
"TaxCodeID": 11,
"TaxBodyID": 6,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": null,
"PickupDeliveryMethodID": null,
"SalesOrderStatusID": 1,
"JoinID": "34561",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "JBE1",
"Department": "Parts",
"PartsOrderNumber": 55,
"OrderStatus": "In Process",
"CreationDate": "2017-02-07T13:45:15.383",
"CustomerNumber": "4481B10",
"CompanyName": "Gilbert'sTrucking Service B3",
"CustomerPO": "",
"PickupDeliveryMethod": null,
"DeliveryDate": null,
"TrackingNumber": null,
"InvoiceDate": null,
"InvoiceNumber": null,
"LastUpdate": "2017-02-07T13:45:15.383",
"AddUser": "futuresakate",
"UpdateUser": "futuresakate",
"InvoiceUser": null,
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "testing ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "4481B10",
"BillingCompanyName": "Gilbert'sTrucking Service B3",
"TaxCode": "Taxable",
"TaxBody": "FL",
"IsLocal": true,
"LPO": null,
"OutsidePartsSalesperson": null,
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "testing ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "Gilbert'sTrucking Service B3",
"ShipToAddress1": "123 W. Main St.",
"ShipToAddress2": "",
"ShipToCity": "Carlinville",
"ShipToRegion": "AK",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": null,
"ShipToFax": null,
"ShipToShopPhone": null,
"ShipToEmail": "hgilbert@karmak.com",
"AverageCost": 23.7600,
"ReplacementCost": 23.7600,
"OrderSubtotal": 35.64,
"OrderTotal": 35.64,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 11.8800,
"ReplacementCostGrossProfit": 11.8800,
"AverageCostGrossProfitMargin": 0.333333,
"ReplacementCostGrossProfitMargin": 0.333333,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 0,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "test",
"UserDefinedPaymentMethodID": 3,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 51058,
"BranchID": 15,
"DepartmentID": 1,
"CustomerID": 1700,
"BillingCustomerID": 1700,
"TaxCodeID": 11,
"TaxBodyID": 31,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 34194,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 5,
"JoinID": "0855",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "G&AA",
"PartsOrderNumber": 55,
"OrderStatus": "Invoiced",
"CreationDate": "2018-12-11T15:19:03.527",
"CustomerNumber": "3676",
"CompanyName": "KLBKR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-12-11T15:21:05.527",
"InvoiceNumber": "0855",
"LastUpdate": "2018-12-11T15:22:50.197",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Lori R",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "KLBKR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "Waggoner town",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Lori R",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "KLBKR Robinson's Trucking",
"ShipToAddress1": "#1 Plaza dr",
"ShipToAddress2": "",
"ShipToCity": "waggoner",
"ShipToRegion": "IL",
"ShipToPostalCode": "",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": -3152.1000,
"ReplacementCost": -3152.1000,
"OrderSubtotal": 150.00,
"OrderTotal": 157.50,
"SalesTaxTotal": 7.50,
"AverageCostGrossProfit": 3302.1000,
"ReplacementCostGrossProfit": 3302.1000,
"AverageCostGrossProfitMargin": 22.014000,
"ReplacementCostGrossProfitMargin": 22.014000,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": true,
"PaymentMethod": "1673369",
"UserDefinedPaymentMethodID": 121,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 51058,
"BranchID": 15,
"DepartmentID": 1,
"CustomerID": 1700,
"BillingCustomerID": 1700,
"TaxCodeID": 11,
"TaxBodyID": 31,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 34194,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 5,
"JoinID": "0855.01",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "G&AA",
"PartsOrderNumber": 55,
"OrderStatus": "Voided",
"CreationDate": "2018-12-11T15:19:03.527",
"CustomerNumber": "3676",
"CompanyName": "KLBKR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-12-11T15:22:50.197",
"InvoiceNumber": "0855.01",
"LastUpdate": "2018-12-11T15:22:50.197",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Lori R",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "KLBKR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "Waggoner town",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Lori R",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "KLBKR Robinson's Trucking",
"ShipToAddress1": "#1 Plaza dr",
"ShipToAddress2": "",
"ShipToCity": "waggoner",
"ShipToRegion": "IL",
"ShipToPostalCode": "",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 3152.1000,
"ReplacementCost": 3152.1000,
"OrderSubtotal": -150.00,
"OrderTotal": -157.50,
"SalesTaxTotal": -7.50,
"AverageCostGrossProfit": -3302.1000,
"ReplacementCostGrossProfit": -3302.1000,
"AverageCostGrossProfitMargin": -22.014000,
"ReplacementCostGrossProfitMargin": -22.014000,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": true,
"PaymentMethod": "1673369",
"UserDefinedPaymentMethodID": 121,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 51058,
"BranchID": 15,
"DepartmentID": 1,
"CustomerID": 1700,
"BillingCustomerID": 1700,
"TaxCodeID": 11,
"TaxBodyID": 31,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 34195,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 5,
"JoinID": "0855.02",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "G&AA",
"PartsOrderNumber": 55,
"OrderStatus": "Invoiced",
"CreationDate": "2018-12-11T15:21:12.450",
"CustomerNumber": "3676",
"CompanyName": "KLBKR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-12-11T15:23:14.480",
"InvoiceNumber": "0855.02",
"LastUpdate": "2018-12-12T15:17:12.570",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Lori R",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "KLBKR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "Waggoner town",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Lori R",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "KLBKR Robinson's Trucking",
"ShipToAddress1": "#1 Plaza dr",
"ShipToAddress2": "",
"ShipToCity": "waggoner",
"ShipToRegion": "IL",
"ShipToPostalCode": "",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": -2096.4000,
"ReplacementCost": -2096.4000,
"OrderSubtotal": 150.00,
"OrderTotal": 157.50,
"SalesTaxTotal": 7.50,
"AverageCostGrossProfit": 2246.4000,
"ReplacementCostGrossProfit": 2246.4000,
"AverageCostGrossProfitMargin": 14.976000,
"ReplacementCostGrossProfitMargin": 14.976000,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": true,
"PaymentMethod": "1673369",
"UserDefinedPaymentMethodID": 121,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 51058,
"BranchID": 15,
"DepartmentID": 1,
"CustomerID": 1700,
"BillingCustomerID": 1700,
"TaxCodeID": 11,
"TaxBodyID": 31,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 34195,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 5,
"JoinID": "0855.03",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "G&AA",
"PartsOrderNumber": 55,
"OrderStatus": "Voided",
"CreationDate": "2018-12-11T15:21:12.450",
"CustomerNumber": "3676",
"CompanyName": "KLBKR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-12-12T15:17:12.570",
"InvoiceNumber": "0855.03",
"LastUpdate": "2018-12-12T15:17:12.570",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Lori R",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "KLBKR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "Waggoner town",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Lori R",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "KLBKR Robinson's Trucking",
"ShipToAddress1": "#1 Plaza dr",
"ShipToAddress2": "",
"ShipToCity": "waggoner",
"ShipToRegion": "IL",
"ShipToPostalCode": "",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 2096.4000,
"ReplacementCost": 2096.4000,
"OrderSubtotal": -150.00,
"OrderTotal": -157.50,
"SalesTaxTotal": -7.50,
"AverageCostGrossProfit": -2246.4000,
"ReplacementCostGrossProfit": -2246.4000,
"AverageCostGrossProfitMargin": -14.976000,
"ReplacementCostGrossProfitMargin": -14.976000,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": true,
"PaymentMethod": "1673369",
"UserDefinedPaymentMethodID": 121,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 51058,
"BranchID": 15,
"DepartmentID": 1,
"CustomerID": 1700,
"BillingCustomerID": 1700,
"TaxCodeID": 11,
"TaxBodyID": 31,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 34203,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 4,
"JoinID": "0855.04",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "7",
"Department": "G&AA",
"PartsOrderNumber": 55,
"OrderStatus": "Invoiced",
"CreationDate": "2018-12-12T15:15:30.523",
"CustomerNumber": "3676",
"CompanyName": "KLBKR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2018-12-12T15:17:30.710",
"InvoiceNumber": "0855.04",
"LastUpdate": "2018-12-12T15:15:30.523",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "Open",
"BillingContactName": "Lori R",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "KLBKR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "Waggoner town",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Lori R",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "KLBKR Robinson's Trucking",
"ShipToAddress1": "#1 Plaza dr",
"ShipToAddress2": "",
"ShipToCity": "waggoner",
"ShipToRegion": "IL",
"ShipToPostalCode": "",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": -1040.7000,
"ReplacementCost": -1040.7000,
"OrderSubtotal": 150.00,
"OrderTotal": 157.50,
"SalesTaxTotal": 7.50,
"AverageCostGrossProfit": 1190.7000,
"ReplacementCostGrossProfit": 1190.7000,
"AverageCostGrossProfitMargin": 7.938000,
"ReplacementCostGrossProfitMargin": 7.938000,
"SalesTerritory": "",
"CustomerAccountStatus": "Open",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "1673369",
"UserDefinedPaymentMethodID": 121,
"StaticPaymentMethodID": 1,
"Territory": ""
},
{
"PartsSalesOrderID": 37497,
"BranchID": 4,
"DepartmentID": 1,
"CustomerID": 3890,
"BillingCustomerID": 3890,
"TaxCodeID": 11,
"TaxBodyID": 37,
"LocalPurchaseOrderID": null,
"PartsSalesOrderInvoiceID": 26977,
"PickupDeliveryMethodID": 2,
"SalesOrderStatusID": 4,
"JoinID": "0556",
"CanadianTaxID": "",
"QuebecTaxID": "",
"Division": "Future1",
"Branch": "JBE1",
"Department": "G&AA",
"PartsOrderNumber": 56,
"OrderStatus": "Invoiced",
"CreationDate": "2017-07-31T10:14:30.037",
"CustomerNumber": "3676",
"CompanyName": "AR Robinson's Trucking",
"CustomerPO": "",
"PickupDeliveryMethod": "Delivery",
"DeliveryDate": null,
"TrackingNumber": "",
"InvoiceDate": "2017-07-31T10:14:29.750",
"InvoiceNumber": "0556",
"LastUpdate": "2017-07-31T10:14:30.037",
"AddUser": "Lorirfuture",
"UpdateUser": "Lorirfuture",
"InvoiceUser": "Lorirfuture",
"BillingCustomerAccountStatus": "On Hold",
"BillingContactName": "Kirsten ",
"BillingHomePhone": "",
"BillingWorkPhone": "",
"BillingCustomerNumber": "3676",
"BillingCompanyName": "AR Robinson's Trucking",
"TaxCode": "Taxable",
"TaxBody": "St Louis City TEST",
"IsLocal": false,
"LPO": null,
"OutsidePartsSalesperson": "Lori Robinson",
"PartsAccounting": null,
"Source": "Part Counter",
"ContactName": "Kirsten ",
"ContactHomePhone": "",
"ContactWorkPhone": "",
"ShipToCustomerName": "AR Robinson's Trucking",
"ShipToAddress1": "1# Paradise Ave",
"ShipToAddress2": "",
"ShipToCity": "St Louis",
"ShipToRegion": "MO",
"ShipToPostalCode": "62626",
"ShipToOfficePhone": "",
"ShipToFax": "",
"ShipToShopPhone": "",
"ShipToEmail": "",
"AverageCost": 15.0000,
"ReplacementCost": 15.0000,
"OrderSubtotal": 10000.00,
"OrderTotal": 10000.00,
"SalesTaxTotal": 0.00,
"AverageCostGrossProfit": 9985.0000,
"ReplacementCostGrossProfit": 9985.0000,
"AverageCostGrossProfitMargin": 0.998500,
"ReplacementCostGrossProfitMargin": 0.998500,
"SalesTerritory": "",
"CustomerAccountStatus": "On Hold",
"ItemsReadyforPickup": 1,
"UpdateStatus": "",
"IsVoided": false,
"PaymentMethod": "Controlled PM",
"UserDefinedPaymentMethodID": 124,
"StaticPaymentMethodID": 3,
"Territory": ""
}
]
OMG, that is a lot of data!
Now it’s time to fine tune my call to get the targeted data I’m interested in.
I review the parameter options available in the instructions at https://unity.karmak.io/Data-Access-API.html
Some common fields I might want to filter Parts Orders by: InvoiceDate, OrderStatus, CreationDate, CustomerID, OrderTotal
Using these filters involves adding querystring information to the URL.
Example URL filtering by InvoiceDate where the Invoice Date is on or after January 1, 2020 and is also before February 1, 2020:
https://api.karmak.io/api/unity/v1/unityapi/frw/PartsOrder?filter=InvoiceDate[GTE]2020-01-01,InvoiceDate[LT]2020-02-01
Now that I’m filtering the data down I want to adjust the way the rows are sorted.
For this exercise I want to sort the records by InvoiceDate in descending order. After reviewing the instructions at https://unity.karmak.io/Data-Access-API.html, I construct my URL.
Example URL that still uses the filtering from before and adds the sorting:
https://api.karmak.io/api/unity/v1/unityapi/frw/PartsOrder?filter=InvoiceDate[GTE]2020-01-01,InvoiceDate[LT]2020-02-01&sort=-InvoiceDate
With the proper sorting and filtering in place, I want to adjust the paging parameters to control how many records I process at a time.
After reviewing the instructions at https://unity.karmak.io/Data-Access-API.html, I construct my URL. Example URL that still uses the filtering and sorting from before and adds the paging:
https://api.karmak.io/api/unity/v1/unityapi/frw/PartsOrder?filter=InvoiceDate[GTE]2020-01-01,InvoiceDate[LT]2020-02-01&sort=-InvoiceDate&pagesize=10
After adding page sizing, I can loop through the pages in my code.
Re-reading through instructions at https://unity.karmak.io/Data-Access-API.html I know that if I send a call for a page that goes beyond the result set I will get no rows back on that call.
Example URLs for the first 5 pages for our exercise thus far:
- Page 1 - https://api.karmak.io/api/unity/v1/unityapi/frw/PartsOrder?filter=InvoiceDate[GTE]2020-01-01,InvoiceDate[LT]2020-02-01&sort=-InvoiceDate&pagesize=10&page=1
- Page 2 - https://api.karmak.io/api/unity/v1/unityapi/frw/PartsOrder?filter=InvoiceDate[GTE]2020-01-01,InvoiceDate[LT]2020-02-01&sort=-InvoiceDate&pagesize=10&page=2
- Page 3 - https://api.karmak.io/api/unity/v1/unityapi/frw/PartsOrder?filter=InvoiceDate[GTE]2020-01-01,InvoiceDate[LT]2020-02-01&sort=-InvoiceDate&pagesize=10&page=3
- Page 4 - https://api.karmak.io/api/unity/v1/unityapi/frw/PartsOrder?filter=InvoiceDate[GTE]2020-01-01,InvoiceDate[LT]2020-02-01&sort=-InvoiceDate&pagesize=10&page=4
- Page 5 - https://api.karmak.io/api/unity/v1/unityapi/frw/PartsOrder?filter=InvoiceDate[GTE]2020-01-01,InvoiceDate[LT]2020-02-01&sort=-InvoiceDate&pagesize=10&page=5
Now that I’m filtering, sorting, and paging the data, I can reduce the number of columns coming back for each row to only focus on the data that I actually need.
For this exercise I’m going to return PartsSalesOrderID, InvoiceDate, OrderStatus, CreationDate, CustomerID, and OrderTotal.
After reviewing the instructions at https://unity.karmak.io/Data-Access-API.html, I construct my URL:
https://api.karmak.io/api/unity/v1/unityapi/frw/PartsOrder?filter=InvoiceDate[GTE]2020-01-01,InvoiceDate[LT]2020-02-01&sort=-InvoiceDate&pagesize=10&page=1&select=PartsSalesOrderID,InvoiceDate,OrderStatus,CreationDate,CustomerID,OrderTotal
Now I have a well focused Unity call that is returning the data that I need to utilize.
Here is an example call from our internal QA system, I had to use a different date range due to the data available.
URL used:https://qa.karmak.io/api/unity/v1/unityapi/frw/PartsOrder?filter=InvoiceDate[GTE]2016-01-01,InvoiceDate[LT]2016-02-01&sort=-InvoiceDate&pagesize=10&page=1&select=PartsSalesOrderID,InvoiceDate,OrderStatus,CreationDate,CustomerID,OrderTotal
cURL format:
curl --location --request GET 'https://qa.karmak.io/api/unity/v1/unityapi/frw/PartsOrder?filter=InvoiceDate[GTE]2016-01-01,InvoiceDate[LT]2016-02-01&sort=-InvoiceDate&pagesize=10&page=1&select=PartsSalesOrderID,InvoiceDate,OrderStatus,CreationDate,CustomerID,OrderTotal' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer eyJhbGciOiJSUzI1NiIsImtpZCIThisIsFakekE0QzM1MDg2RENCMjYxNzczMzkzRjJFRTQ5MTg3MkI0RUQiLCJ0eXAiOiJhdCtqd3QiLCJ4NXQiOiJOVVpMcE1OUWh0eXlZWGNThisIsFakeHl0TzAifQ.eyJuYmYiOjE1ODQxMDY0NjksImV4cCI6MTU4NDExMDA2OSwiaXNzIjoiaHThisIsFakeYi5jb3JlYXV0aDo5MDI1IiwiYXVkIjoiYXBpIiwiY2xpZW50X2lkIjoidW5pdHktcWEtaW50X2NsaWVudCIsInN1YiI6InVuaXR5LXFhLWludF9jbGllbnQiLCJhdXRoX3RpbWUiOjE1ODQxMDY0NjksImlkcCI6ImxvY2FsIiwiWC1FbGstSWRlbnRpdHThisIsFakedCI6IjNkNWNjNjE2LWI5YTQtNGY0NC1hMjc1LTZlYzgzMDBkOTVhOSIsIlgtRWxrLUlkZW50aXR5LVVzZXIiOiJkZDk0OGNhOS1hNDI5LTQ2OTQtYTM0MC0xNmY3MGU2OTcxYTEiLCJhY2NvdW50IjoiM2Q1Y2M2MTYtYjlhNC00ZjQ0LWEyNzUtNmVjODMwMGQ5NWE5IiwidXNlciI6ImRkOTQ4Y2E5LWE0MjktNDY5NC1hMzQwLTE2ZjcwZTY5NzFhMSIsInJvbGUiOiIwMDAwMDAwMThisIsFakewMDAtMDAwMC0wMDAwMDAwMDAwMDAiLCJYLUVsay1JZGVudGl0eS1Sb2xlIjoiMDAwMDAwMDAtMDAwMC0wMDAwLTAwMDAtMDAwMDAwMDAwMDAwIiwic2VjdXJpdHlfcHJvZmlsZV91c2VyIjoiMmRkMWU1NTAtYmUyNC00OGY0LTlmY2EtODkyOGM2OWU1MWThisIsFakedXJpdHlfcHJvZmlsZV9hY2NvdW50IjoiMDAwMDAwMDEtMDAwMS0wMDAxLTAwMDEtMDAwMDAwMDAwMDAxIiwiWC1FbGstU2VjdXJpdHlQcm9maWxlLVVzZXIiOiIyZGQxZTU1MC1iZTI0LTQ4ZjQtOWZjYS04OTI4YzY5ZTUxYzgiLCJYLUVsay1TZWN1cml0eVByb2ZpbGUtQWNjbThisIsFakewMDAwMDAxLTAwMDEtMDAwMS0wMDAxLTAwMDAwMDAwMDAwMSIsImFkbWluIjoiYWRtaW4iLCJzY29wZSI6WyJhcGkiXSwiYW1yIjpbImthcm1hayJdfQ.lPwflMBF95Ktw--wneNADy4Z6VcgtQBzX36kDrh4N5DVkBeQYf4iAeCzwjh65mhnM2PBYmIvKHBIGnbz9R_hmfBfJwi4wC8ROKmdPsLCyYFE23YARZXMr4AoXylh_whsp9Myrhfoohdo597hoJBQzSgYZ7OkIQJc8ZV0zCbR-r9NyUMvvhEJP4daCyRPg0fTzG-B0hPDB0tx9bkW1WU0lAVYJgfgqD1pvLGWUh55DAThisIsFakemoarH5ETlmL2HTytAUjGwTRFqDB6Udyi4YgLxgXXNtGbFTEvgZWle9z7ZhXNWT3n4R6OJ8n8me7qiUrCEl1QmWIaBoslPdF2Dw'
Response:
[
{
"PartsSalesOrderID": 29469,
"InvoiceDate": "2016-01-29T08:22:55.767",
"OrderStatus": "Invoiced",
"CreationDate": "2016-01-29T08:22:55.400",
"CustomerID": 1434,
"OrderTotal": 94.50
},
{
"PartsSalesOrderID": 29468,
"InvoiceDate": "2016-01-29T08:22:51.050",
"OrderStatus": "Invoiced",
"CreationDate": "2016-01-29T08:22:50.693",
"CustomerID": 1434,
"OrderTotal": 113.40
},
{
"PartsSalesOrderID": 29467,
"InvoiceDate": "2016-01-29T08:13:20.747",
"OrderStatus": "Invoiced",
"CreationDate": "2016-01-29T08:13:20.447",
"CustomerID": 1434,
"OrderTotal": 47.25
},
{
"PartsSalesOrderID": 29466,
"InvoiceDate": "2016-01-29T08:13:15.963",
"OrderStatus": "Invoiced",
"CreationDate": "2016-01-29T08:13:15.640",
"CustomerID": 1434,
"OrderTotal": 56.70
},
{
"PartsSalesOrderID": 29465,
"InvoiceDate": "2016-01-29T07:35:51.330",
"OrderStatus": "Invoiced",
"CreationDate": "2016-01-29T07:35:51.037",
"CustomerID": 1434,
"OrderTotal": 0.00
},
{
"PartsSalesOrderID": 29464,
"InvoiceDate": "2016-01-29T07:35:41.453",
"OrderStatus": "Invoiced",
"CreationDate": "2016-01-29T07:35:41.130",
"CustomerID": 1434,
"OrderTotal": -199.50
},
{
"PartsSalesOrderID": 29463,
"InvoiceDate": "2016-01-29T07:34:53.577",
"OrderStatus": "Invoiced",
"CreationDate": "2016-01-29T07:34:53.283",
"CustomerID": 1434,
"OrderTotal": 0.00
},
{
"PartsSalesOrderID": 29462,
"InvoiceDate": "2016-01-29T07:34:40.263",
"OrderStatus": "Invoiced",
"CreationDate": "2016-01-29T07:34:39.957",
"CustomerID": 1434,
"OrderTotal": 199.50
},
{
"PartsSalesOrderID": 29461,
"InvoiceDate": "2016-01-29T07:32:44.250",
"OrderStatus": "Invoiced",
"CreationDate": "2016-01-29T07:32:43.950",
"CustomerID": 1434,
"OrderTotal": 0.00
},
{
"PartsSalesOrderID": 29460,
"InvoiceDate": "2016-01-29T07:32:38.860",
"OrderStatus": "Invoiced",
"CreationDate": "2016-01-29T07:32:38.557",
"CustomerID": 1434,
"OrderTotal": -199.50
}
]