Get Full Information About Entity
The completeness of the entity information depends of parameter on request header.
Usual request looks like
OData-Version:4.0
OData-MaxVersion:4.0
Content-Type:application/json;odata.metadata=minimal
Accept:application/json;odata.metadata=minimal
Accept-Charset:UTF-8
Authorization:Bearer {{token}}
Host:{{base_url}}
When we are trying describe requirement for destination system our requests for response.
Accept:application/json;odata.metadata=minimal we can accept only json response with minimal information represent inside
Example
Request: GET: https://{{base_url}}/data/SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')
Response:
{
"@odata.context": "https://{{base_url}}/data/$metadata#SalesOrderHeadersV2/$entity",
"@odata.etag": "W/\"JzAsNTYzNzE0NDU3NjswLDA7MCwwOzAsMDswLDA7MCwwJw==\"",
"dataAreaId": "usmf",
"SalesOrderNumber": "000002",
"OrderTotalChargesAmount": 0,
"FiscalDocumentOperationTypeId": "",
"OrderTakerPersonnelNumber": "",
"RequestedReceiptDate": "2015-01-15T12:00:00Z",
"EInvoiceDimensionAccountCode": "",
"IsOwnEntryCertificateIssued": "No",
"InvoiceAddressStreet": "Bahnhofstrasse 5",
"CampaignId": "",
"FormattedDelveryAddress": "",
"Email": "contoso.europe@vendor8.consolidatedmessenger.com",
"BaseDocumentLineNumber": 0,
"BaseDocumentType": "None",
"DefaultShippingSiteId": "",
"TransportationBrokerId": "",
"TransportationModeId": "",
"DeliveryAddressDescription": "",
"CFPSCode": "",
"IsInvoiceAddressPrivate": "No",
"IsSalesProcessingStopped": "No",
"ShippingCarrierCustomerAccountNumber": "",
"TMACustomerGroupId": "",
"BankSpecificSymbol": "",
"SalesOrderStatus": "Invoiced",
"NumberSequenceGroupId": "",
"SalesOrderOriginCode": "PHONE",
"InvoiceAddressLatitude": 0,
"CustomerPaymentFinancialInterestCode": "",
"TransportationTemplateId": "",
"InvoiceAddressStreetInKana": "",
"BankConstantSymbol": "",
"OrderTotalTaxAmount": 0,
"IsOneTimeCustomer": "No",
"SalesOrderPoolId": "01",
"DeliveryAddressCountryRegionId": "",
"DeliveryAddressLatitude": 0,
"TotalDiscountCustomerGroupCode": "",
"DeliveryAddressCity": "",
"SalesRebateCustomerGroupId": "",
"ThirdPartySalesDigitalPlatformCNPJ": "",
"SalesOrderPromisingMethod": "None",
"ProjectId": "",
"ShippingCarrierId": "",
"TotalDiscountPercentage": 0,
"DeliveryAddressDistrictName": "",
"DeliveryAddressCountyId": "",
"ConfirmedReceiptDate": "2015-01-15T12:00:00Z",
"BaseDocumentItemNumber": "",
"DeliveryAddressZipCode": "",
"FiscalOperationPresenceType": "DoesNotApply",
"QuotationNumber": "",
"IsConsolidatedInvoiceTarget": "No",
"LanguageId": "en-us",
"DeliveryAddressDunsNumber": "",
"MultilineDiscountCustomerGroupCode": "",
"BaseDocumentNumber": "",
"InvoiceAddressStateId": "BE",
"ServiceFiscalInformationCode": "",
"CustomerPaymentMethodSpecificationName": "",
"CommissionCustomerGroupId": "",
"DeliveryAddressName": "Contoso Europe",
"InvoiceAddressCountryRegionId": "DEU",
"PaymentTermsBaseDate": "1900-01-01T12:00:00Z",
"DeliveryAddressStreetNumber": "",
"CreditNoteReasonCode": "",
"DeliveryAddressStreetInKana": "",
"ChargeCustomerGroupId": "",
"InvoiceAddressStreetNumber": "",
"IsDeliveryAddressPrivate": "No",
"TaxExemptNumber": "998765",
"AreTotalsCalculated": "No",
"TotalDiscountAmount": 0,
"OrderTotalAmount": 0,
"CustomersOrderReference": "",
"FormattedInvoiceAddress": "Bahnhofstrasse 5\n10115 Berlin\nDEU",
"OrderResponsiblePersonnelNumber": "",
"ExportReason": "",
"DeliveryAddressCountryRegionISOCode": "",
"CashDiscountCode": "",
"OrderOrAgreementCode": "",
"PaymentScheduleName": "",
"InvoiceAddressCountryRegionISOCode": "DE",
"IntrastatTransactionCode": "",
"URL": "",
"OrderTotalDiscountAmount": 0,
"CurrencyCode": "USD",
"InvoiceType": "Invoice",
"OrderCreationDateTime": "2015-01-15T16:26:20Z",
"ArePricesIncludingSalesTax": "No",
"InvoiceCustomerAccountNumber": "DE-001",
"DeliveryAddressLocationId": "",
"CustomerTransactionSettlementType": "OpenTransact",
"CommissionSalesRepresentativeGroupId": "",
"InvoiceAddressCityInKana": "",
"WillAutomaticInventoryReservationConsiderBatchAttributes": "No",
"IntrastatStatisticsProcedureCode": "",
"IsEInvoiceDimensionAccountCodeSpecifiedPerLine": "No",
"DeliveryAddressStreet": "",
"DeliveryModeCode": "40",
"IsExportSale": "No",
"ConfirmedShippingDate": "2015-01-15T12:00:00Z",
"FixedDueDate": "1900-01-01T12:00:00Z",
"TransportationDocumentLineId": "00000000-0000-0000-0000-000000000000",
"SalesTaxGroupCode": "EXMPT FOR",
"IsDeliveryAddressOrderSpecific": "No",
"CustomerRequisitionNumber": "",
"InvoiceAddressLongitude": 0,
"InvoiceAddressCity": "Berlin",
"IsFinalUser": "No",
"InvoiceAddressPostBox": "",
"ShippingCarrierServiceGroupId": "",
"ContactPersonId": "",
"EUSalesListCode": "IncludeNot",
"InvoiceAddressDistrictName": "",
"ThirdPartySalesDigitalPlatform": "No",
"PaymentTermsName": "Net10",
"DeliveryAddressCityInKana": "",
"BaseDocumentDate": "1900-01-01T12:00:00Z",
"CustomerPostingProfileId": "GEN",
"DeliveryAddressLongitude": 0,
"TenderCode": "",
"InvoiceAddressZipCode": "10115",
"DeliveryTermsCode": "FOB",
"ShippingCarrierServiceId": "",
"DefaultLedgerDimensionDisplayValue": "001--",
"DeliveryAddressTimeZone": null,
"SalesOrderName": "Contoso Europe",
"DefaultShippingWarehouseId": "",
"IsEntryCertificateRequired": "No",
"DeliveryAddressStateId": "",
"DeliveryBuildingCompliment": "",
"IntrastatTransportModeCode": "",
"InvoicePaymentAttachmentType": "None",
"DeliveryAddressPostBox": "",
"InvoiceAddressTimeZone": null,
"InvoiceAddressCountyId": "",
"DirectDebitMandateId": "",
"LineDiscountCustomerGroupCode": "",
"IntrastatPortId": "",
"CIPEcode": "",
"OrderingCustomerAccountNumber": "DE-001",
"CustomerPaymentFineCode": "",
"InvoiceBuildingCompliment": "",
"PriceCustomerGroupCode": "09",
"DeliveryReasonCode": "",
"IsServiceDeliveryAddressBased": "No",
"ReportingCurrencyFixedExchangeRate": 0,
"OrderHeaderTaxAmount": 0,
"InventoryReservationMethod": "None",
"RequestedShippingDate": "2015-01-15T12:00:00Z",
"SalesOrderProcessingStatus": "Invoiced",
"TransportationRoutePlanId": "",
"SkipCreateAutoCharges": "Yes",
"CustomerPaymentMethodName": "",
"SalesUnitId": "",
"FixedExchangeRate": 0,
"RevRecReallocationId": "",
"RevRecFollowOriginalPricingMethod": "No",
"RevRecMultipleSOReallocation": "No",
"RevRecContractEndDate": "1900-01-01T12:00:00Z",
"RevRecLatestReverseJournal": 0,
"RevRecContractStartDate": "1900-01-01T12:00:00Z"
}
Same request with Accept:application/json;odata.metadata=full
Example
Request: GET: https://{{base_url}}/data/SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')
Response:
{
"@odata.context": "https://{{base_url}}/data/$metadata#SalesOrderHeadersV2/$entity",
"@odata.type": "#Microsoft.Dynamics.DataEntities.SalesOrderHeaderV2",
"@odata.id": "https://{{base_url}}/data/SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')",
"@odata.etag": "W/\"JzAsNTYzNzE0NDU3NjswLDA7MCwwOzAsMDswLDA7MCwwJw==\"",
"@odata.editLink": "SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')",
"dataAreaId": "usmf",
"SalesOrderNumber": "000002",
"OrderTotalChargesAmount@odata.type": "#Decimal",
"OrderTotalChargesAmount": 0,
"FiscalDocumentOperationTypeId": "",
"OrderTakerPersonnelNumber": "",
"RequestedReceiptDate@odata.type": "#DateTimeOffset",
"RequestedReceiptDate": "2015-01-15T12:00:00Z",
"EInvoiceDimensionAccountCode": "",
"IsOwnEntryCertificateIssued@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"IsOwnEntryCertificateIssued": "No",
"InvoiceAddressStreet": "Bahnhofstrasse 5",
"CampaignId": "",
"FormattedDelveryAddress": "",
"Email": "contoso.europe@vendor8.consolidatedmessenger.com",
"BaseDocumentLineNumber": 0,
"BaseDocumentType@odata.type": "#Microsoft.Dynamics.DataEntities.DocumentType_IT",
"BaseDocumentType": "None",
"DefaultShippingSiteId": "",
"TransportationBrokerId": "",
"TransportationModeId": "",
"DeliveryAddressDescription": "",
"CFPSCode": "",
"IsInvoiceAddressPrivate@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"IsInvoiceAddressPrivate": "No",
"IsSalesProcessingStopped@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"IsSalesProcessingStopped": "No",
"ShippingCarrierCustomerAccountNumber": "",
"TMACustomerGroupId": "",
"BankSpecificSymbol": "",
"SalesOrderStatus@odata.type": "#Microsoft.Dynamics.DataEntities.SalesStatus",
"SalesOrderStatus": "Invoiced",
"NumberSequenceGroupId": "",
"SalesOrderOriginCode": "PHONE",
"InvoiceAddressLatitude@odata.type": "#Decimal",
"InvoiceAddressLatitude": 0,
"CustomerPaymentFinancialInterestCode": "",
"TransportationTemplateId": "",
"InvoiceAddressStreetInKana": "",
"BankConstantSymbol": "",
"OrderTotalTaxAmount@odata.type": "#Decimal",
"OrderTotalTaxAmount": 0,
"IsOneTimeCustomer@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"IsOneTimeCustomer": "No",
"SalesOrderPoolId": "01",
"DeliveryAddressCountryRegionId": "",
"DeliveryAddressLatitude@odata.type": "#Decimal",
"DeliveryAddressLatitude": 0,
"TotalDiscountCustomerGroupCode": "",
"DeliveryAddressCity": "",
"SalesRebateCustomerGroupId": "",
"ThirdPartySalesDigitalPlatformCNPJ": "",
"SalesOrderPromisingMethod@odata.type": "#Microsoft.Dynamics.DataEntities.SalesDeliveryDateControlType",
"SalesOrderPromisingMethod": "None",
"ProjectId": "",
"ShippingCarrierId": "",
"TotalDiscountPercentage@odata.type": "#Decimal",
"TotalDiscountPercentage": 0,
"DeliveryAddressDistrictName": "",
"DeliveryAddressCountyId": "",
"ConfirmedReceiptDate@odata.type": "#DateTimeOffset",
"ConfirmedReceiptDate": "2015-01-15T12:00:00Z",
"BaseDocumentItemNumber": "",
"DeliveryAddressZipCode": "",
"FiscalOperationPresenceType@odata.type": "#Microsoft.Dynamics.DataEntities.EFDocPresenceType_BR",
"FiscalOperationPresenceType": "DoesNotApply",
"QuotationNumber": "",
"IsConsolidatedInvoiceTarget@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"IsConsolidatedInvoiceTarget": "No",
"LanguageId": "en-us",
"DeliveryAddressDunsNumber": "",
"MultilineDiscountCustomerGroupCode": "",
"BaseDocumentNumber": "",
"InvoiceAddressStateId": "BE",
"ServiceFiscalInformationCode": "",
"CustomerPaymentMethodSpecificationName": "",
"CommissionCustomerGroupId": "",
"DeliveryAddressName": "Contoso Europe",
"InvoiceAddressCountryRegionId": "DEU",
"PaymentTermsBaseDate@odata.type": "#DateTimeOffset",
"PaymentTermsBaseDate": "1900-01-01T12:00:00Z",
"DeliveryAddressStreetNumber": "",
"CreditNoteReasonCode": "",
"DeliveryAddressStreetInKana": "",
"ChargeCustomerGroupId": "",
"InvoiceAddressStreetNumber": "",
"IsDeliveryAddressPrivate@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"IsDeliveryAddressPrivate": "No",
"TaxExemptNumber": "998765",
"AreTotalsCalculated@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"AreTotalsCalculated": "No",
"TotalDiscountAmount@odata.type": "#Decimal",
"TotalDiscountAmount": 0,
"OrderTotalAmount@odata.type": "#Decimal",
"OrderTotalAmount": 0,
"CustomersOrderReference": "",
"FormattedInvoiceAddress": "Bahnhofstrasse 5\n10115 Berlin\nDEU",
"OrderResponsiblePersonnelNumber": "",
"ExportReason": "",
"DeliveryAddressCountryRegionISOCode": "",
"CashDiscountCode": "",
"OrderOrAgreementCode": "",
"PaymentScheduleName": "",
"InvoiceAddressCountryRegionISOCode": "DE",
"IntrastatTransactionCode": "",
"URL": "",
"OrderTotalDiscountAmount@odata.type": "#Decimal",
"OrderTotalDiscountAmount": 0,
"CurrencyCode": "USD",
"InvoiceType@odata.type": "#Microsoft.Dynamics.DataEntities.InvoiceType_MY",
"InvoiceType": "Invoice",
"OrderCreationDateTime@odata.type": "#DateTimeOffset",
"OrderCreationDateTime": "2015-01-15T16:26:20Z",
"ArePricesIncludingSalesTax@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"ArePricesIncludingSalesTax": "No",
"InvoiceCustomerAccountNumber": "DE-001",
"DeliveryAddressLocationId": "",
"CustomerTransactionSettlementType@odata.type": "#Microsoft.Dynamics.DataEntities.SettlementType",
"CustomerTransactionSettlementType": "OpenTransact",
"CommissionSalesRepresentativeGroupId": "",
"InvoiceAddressCityInKana": "",
"WillAutomaticInventoryReservationConsiderBatchAttributes@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"WillAutomaticInventoryReservationConsiderBatchAttributes": "No",
"IntrastatStatisticsProcedureCode": "",
"IsEInvoiceDimensionAccountCodeSpecifiedPerLine@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"IsEInvoiceDimensionAccountCodeSpecifiedPerLine": "No",
"DeliveryAddressStreet": "",
"DeliveryModeCode": "40",
"IsExportSale@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"IsExportSale": "No",
"ConfirmedShippingDate@odata.type": "#DateTimeOffset",
"ConfirmedShippingDate": "2015-01-15T12:00:00Z",
"FixedDueDate@odata.type": "#DateTimeOffset",
"FixedDueDate": "1900-01-01T12:00:00Z",
"TransportationDocumentLineId@odata.type": "#Guid",
"TransportationDocumentLineId": "00000000-0000-0000-0000-000000000000",
"SalesTaxGroupCode": "EXMPT FOR",
"IsDeliveryAddressOrderSpecific@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"IsDeliveryAddressOrderSpecific": "No",
"CustomerRequisitionNumber": "",
"InvoiceAddressLongitude@odata.type": "#Decimal",
"InvoiceAddressLongitude": 0,
"InvoiceAddressCity": "Berlin",
"IsFinalUser@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"IsFinalUser": "No",
"InvoiceAddressPostBox": "",
"ShippingCarrierServiceGroupId": "",
"ContactPersonId": "",
"EUSalesListCode@odata.type": "#Microsoft.Dynamics.DataEntities.Listcode",
"EUSalesListCode": "IncludeNot",
"InvoiceAddressDistrictName": "",
"ThirdPartySalesDigitalPlatform@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"ThirdPartySalesDigitalPlatform": "No",
"PaymentTermsName": "Net10",
"DeliveryAddressCityInKana": "",
"BaseDocumentDate@odata.type": "#DateTimeOffset",
"BaseDocumentDate": "1900-01-01T12:00:00Z",
"CustomerPostingProfileId": "GEN",
"DeliveryAddressLongitude@odata.type": "#Decimal",
"DeliveryAddressLongitude": 0,
"TenderCode": "",
"InvoiceAddressZipCode": "10115",
"DeliveryTermsCode": "FOB",
"ShippingCarrierServiceId": "",
"DefaultLedgerDimensionDisplayValue": "001--",
"DeliveryAddressTimeZone": null,
"SalesOrderName": "Contoso Europe",
"DefaultShippingWarehouseId": "",
"IsEntryCertificateRequired@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"IsEntryCertificateRequired": "No",
"DeliveryAddressStateId": "",
"DeliveryBuildingCompliment": "",
"IntrastatTransportModeCode": "",
"InvoicePaymentAttachmentType@odata.type": "#Microsoft.Dynamics.DataEntities.PaymentStub",
"InvoicePaymentAttachmentType": "None",
"DeliveryAddressPostBox": "",
"InvoiceAddressTimeZone": null,
"InvoiceAddressCountyId": "",
"DirectDebitMandateId": "",
"LineDiscountCustomerGroupCode": "",
"IntrastatPortId": "",
"CIPEcode": "",
"OrderingCustomerAccountNumber": "DE-001",
"CustomerPaymentFineCode": "",
"InvoiceBuildingCompliment": "",
"PriceCustomerGroupCode": "09",
"DeliveryReasonCode": "",
"IsServiceDeliveryAddressBased@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"IsServiceDeliveryAddressBased": "No",
"ReportingCurrencyFixedExchangeRate@odata.type": "#Decimal",
"ReportingCurrencyFixedExchangeRate": 0,
"OrderHeaderTaxAmount@odata.type": "#Decimal",
"OrderHeaderTaxAmount": 0,
"InventoryReservationMethod@odata.type": "#Microsoft.Dynamics.DataEntities.ItemReservation",
"InventoryReservationMethod": "None",
"RequestedShippingDate@odata.type": "#DateTimeOffset",
"RequestedShippingDate": "2015-01-15T12:00:00Z",
"SalesOrderProcessingStatus@odata.type": "#Microsoft.Dynamics.DataEntities.SalesOrderProcessingStatus",
"SalesOrderProcessingStatus": "Invoiced",
"TransportationRoutePlanId": "",
"SkipCreateAutoCharges@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"SkipCreateAutoCharges": "Yes",
"CustomerPaymentMethodName": "",
"SalesUnitId": "",
"FixedExchangeRate@odata.type": "#Decimal",
"FixedExchangeRate": 0,
"RevRecReallocationId": "",
"RevRecFollowOriginalPricingMethod@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"RevRecFollowOriginalPricingMethod": "No",
"RevRecMultipleSOReallocation@odata.type": "#Microsoft.Dynamics.DataEntities.NoYes",
"RevRecMultipleSOReallocation": "No",
"RevRecContractEndDate@odata.type": "#DateTimeOffset",
"RevRecContractEndDate": "1900-01-01T12:00:00Z",
"RevRecLatestReverseJournal@odata.type": "#Int64",
"RevRecLatestReverseJournal": 0,
"RevRecContractStartDate@odata.type": "#DateTimeOffset",
"RevRecContractStartDate": "1900-01-01T12:00:00Z",
"SalesOrderOrigin@odata.associationLink": "https://{{base_url}}/data/SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')/SalesOrderOrigin/$ref",
"SalesOrderOrigin@odata.navigationLink": "https://{{base_url}}/data/SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')/SalesOrderOrigin",
"Project@odata.associationLink": "https://{{base_url}}/data/SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')/Project/$ref",
"Project@odata.navigationLink": "https://{{base_url}}/data/SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')/Project",
"DimensionSet@odata.associationLink": "https://{{base_url}}/data/SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')/DimensionSet/$ref",
"DimensionSet@odata.navigationLink": "https://{{base_url}}/data/SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')/DimensionSet",
"QualityOrderHeaders@odata.associationLink": "https://{{base_url}}/data/SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')/QualityOrderHeaders/$ref",
"QualityOrderHeaders@odata.navigationLink": "https://{{base_url}}/data/SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')/QualityOrderHeaders",
"SalesOrderLines@odata.associationLink": "https://{{base_url}}/data/SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')/SalesOrderLines/$ref",
"SalesOrderLines@odata.navigationLink": "https://{{base_url}}/data/SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')/SalesOrderLines"
}
@odata.id - direct link for current record (in case we have got few records for request it can be useful) and allow to undestand key fields in brackets https://{{base_url}}/data/SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')
Additional we can get rellation of this entity with different entityes. For example "SalesOrderLines@odata.navigationLink": "https://{{base_url}}/data/SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')/SalesOrderLines" allow to get all headers and lines in one query.
Example - how to get Sales table and related Sales lines in one query
GET: https://{{base_url}}/data/SalesOrderHeadersV2(dataAreaId='usmf',SalesOrderNumber='000002')?$expand=SalesOrderLines
We have got one header and all 5 lines over one query
Response:
{
"@odata.context": "https://{{base_url}}/data/$metadata#SalesOrderHeadersV2/$entity",
"@odata.etag": "W/\"JzAsNTYzNzE0NDU3NjswLDA7MCwwOzAsMDswLDA7MCwwJw==\"",
"dataAreaId": "usmf",
"SalesOrderNumber": "000002",
"OrderTotalChargesAmount": 0,
"FiscalDocumentOperationTypeId": "",
"OrderTakerPersonnelNumber": "",
"RequestedReceiptDate": "2015-01-15T12:00:00Z",
"EInvoiceDimensionAccountCode": "",
"IsOwnEntryCertificateIssued": "No",
"InvoiceAddressStreet": "Bahnhofstrasse 5",
"CampaignId": "",
"FormattedDelveryAddress": "",
"Email": "contoso.europe@vendor8.consolidatedmessenger.com",
"BaseDocumentLineNumber": 0,
"BaseDocumentType": "None",
"DefaultShippingSiteId": "",
"TransportationBrokerId": "",
"TransportationModeId": "",
"DeliveryAddressDescription": "",
"CFPSCode": "",
"IsInvoiceAddressPrivate": "No",
"IsSalesProcessingStopped": "No",
"ShippingCarrierCustomerAccountNumber": "",
"TMACustomerGroupId": "",
"BankSpecificSymbol": "",
"SalesOrderStatus": "Invoiced",
"NumberSequenceGroupId": "",
"SalesOrderOriginCode": "PHONE",
"InvoiceAddressLatitude": 0,
"CustomerPaymentFinancialInterestCode": "",
"TransportationTemplateId": "",
"InvoiceAddressStreetInKana": "",
"BankConstantSymbol": "",
"OrderTotalTaxAmount": 0,
"IsOneTimeCustomer": "No",
"SalesOrderPoolId": "01",
"DeliveryAddressCountryRegionId": "",
"DeliveryAddressLatitude": 0,
"TotalDiscountCustomerGroupCode": "",
"DeliveryAddressCity": "",
"SalesRebateCustomerGroupId": "",
"ThirdPartySalesDigitalPlatformCNPJ": "",
"SalesOrderPromisingMethod": "None",
"ProjectId": "",
"ShippingCarrierId": "",
"TotalDiscountPercentage": 0,
"DeliveryAddressDistrictName": "",
"DeliveryAddressCountyId": "",
"ConfirmedReceiptDate": "2015-01-15T12:00:00Z",
"BaseDocumentItemNumber": "",
"DeliveryAddressZipCode": "",
"FiscalOperationPresenceType": "DoesNotApply",
"QuotationNumber": "",
"IsConsolidatedInvoiceTarget": "No",
"LanguageId": "en-us",
"DeliveryAddressDunsNumber": "",
"MultilineDiscountCustomerGroupCode": "",
"BaseDocumentNumber": "",
"InvoiceAddressStateId": "BE",
"ServiceFiscalInformationCode": "",
"CustomerPaymentMethodSpecificationName": "",
"CommissionCustomerGroupId": "",
"DeliveryAddressName": "Contoso Europe",
"InvoiceAddressCountryRegionId": "DEU",
"PaymentTermsBaseDate": "1900-01-01T12:00:00Z",
"DeliveryAddressStreetNumber": "",
"CreditNoteReasonCode": "",
"DeliveryAddressStreetInKana": "",
"ChargeCustomerGroupId": "",
"InvoiceAddressStreetNumber": "",
"IsDeliveryAddressPrivate": "No",
"TaxExemptNumber": "998765",
"AreTotalsCalculated": "No",
"TotalDiscountAmount": 0,
"OrderTotalAmount": 0,
"CustomersOrderReference": "",
"FormattedInvoiceAddress": "Bahnhofstrasse 5\n10115 Berlin\nDEU",
"OrderResponsiblePersonnelNumber": "",
"ExportReason": "",
"DeliveryAddressCountryRegionISOCode": "",
"CashDiscountCode": "",
"OrderOrAgreementCode": "",
"PaymentScheduleName": "",
"InvoiceAddressCountryRegionISOCode": "DE",
"IntrastatTransactionCode": "",
"URL": "",
"OrderTotalDiscountAmount": 0,
"CurrencyCode": "USD",
"InvoiceType": "Invoice",
"OrderCreationDateTime": "2015-01-15T16:26:20Z",
"ArePricesIncludingSalesTax": "No",
"InvoiceCustomerAccountNumber": "DE-001",
"DeliveryAddressLocationId": "",
"CustomerTransactionSettlementType": "OpenTransact",
"CommissionSalesRepresentativeGroupId": "",
"InvoiceAddressCityInKana": "",
"WillAutomaticInventoryReservationConsiderBatchAttributes": "No",
"IntrastatStatisticsProcedureCode": "",
"IsEInvoiceDimensionAccountCodeSpecifiedPerLine": "No",
"DeliveryAddressStreet": "",
"DeliveryModeCode": "40",
"IsExportSale": "No",
"ConfirmedShippingDate": "2015-01-15T12:00:00Z",
"FixedDueDate": "1900-01-01T12:00:00Z",
"TransportationDocumentLineId": "00000000-0000-0000-0000-000000000000",
"SalesTaxGroupCode": "EXMPT FOR",
"IsDeliveryAddressOrderSpecific": "No",
"CustomerRequisitionNumber": "",
"InvoiceAddressLongitude": 0,
"InvoiceAddressCity": "Berlin",
"IsFinalUser": "No",
"InvoiceAddressPostBox": "",
"ShippingCarrierServiceGroupId": "",
"ContactPersonId": "",
"EUSalesListCode": "IncludeNot",
"InvoiceAddressDistrictName": "",
"ThirdPartySalesDigitalPlatform": "No",
"PaymentTermsName": "Net10",
"DeliveryAddressCityInKana": "",
"BaseDocumentDate": "1900-01-01T12:00:00Z",
"CustomerPostingProfileId": "GEN",
"DeliveryAddressLongitude": 0,
"TenderCode": "",
"InvoiceAddressZipCode": "10115",
"DeliveryTermsCode": "FOB",
"ShippingCarrierServiceId": "",
"DefaultLedgerDimensionDisplayValue": "001--",
"DeliveryAddressTimeZone": null,
"SalesOrderName": "Contoso Europe",
"DefaultShippingWarehouseId": "",
"IsEntryCertificateRequired": "No",
"DeliveryAddressStateId": "",
"DeliveryBuildingCompliment": "",
"IntrastatTransportModeCode": "",
"InvoicePaymentAttachmentType": "None",
"DeliveryAddressPostBox": "",
"InvoiceAddressTimeZone": null,
"InvoiceAddressCountyId": "",
"DirectDebitMandateId": "",
"LineDiscountCustomerGroupCode": "",
"IntrastatPortId": "",
"CIPEcode": "",
"OrderingCustomerAccountNumber": "DE-001",
"CustomerPaymentFineCode": "",
"InvoiceBuildingCompliment": "",
"PriceCustomerGroupCode": "09",
"DeliveryReasonCode": "",
"IsServiceDeliveryAddressBased": "No",
"ReportingCurrencyFixedExchangeRate": 0,
"OrderHeaderTaxAmount": 0,
"InventoryReservationMethod": "None",
"RequestedShippingDate": "2015-01-15T12:00:00Z",
"SalesOrderProcessingStatus": "Invoiced",
"TransportationRoutePlanId": "",
"SkipCreateAutoCharges": "Yes",
"CustomerPaymentMethodName": "",
"SalesUnitId": "",
"FixedExchangeRate": 0,
"RevRecReallocationId": "",
"RevRecFollowOriginalPricingMethod": "No",
"RevRecMultipleSOReallocation": "No",
"RevRecContractEndDate": "1900-01-01T12:00:00Z",
"RevRecLatestReverseJournal": 0,
"RevRecContractStartDate": "1900-01-01T12:00:00Z",
"SalesOrderLines": [
{
"@odata.etag": "W/\"JzAsNTYzNzE0NDU3NjswLDA7MCwwOzAsMDswLDA7MCwwOzAsMCc=\"",
"dataAreaId": "usmf",
"InventoryLotId": "000221",
"RequestedReceiptDate": "2015-01-20T12:00:00Z",
"RetailCalculatedTotalDiscountPercentage": 0,
"EInvoiceDimensionAccountCode": "",
"FormattedDelveryAddress": "",
"ShippingWarehouseLocationId": "",
"SalesOrderLineStatus": "Invoiced",
"ProjectCategoryId": "",
"ItemNumber": "D0001",
"DeliveryAddressDescription": "",
"MultilineDiscountPercentage": 0,
"ShippingWarehouseId": "13",
"GiftCardBuyerName": "",
"GiftCardNumber": "",
"CustomsDocumentNumber": "",
"LineDiscountAmount": 0,
"ProductStyleId": "",
"ProductConfigurationId": "",
"DeliverySalesTaxGroupCode": "",
"IsIntrastatTriangularDeal": "No",
"MultilineDiscountAmount": 0,
"ItemBatchNumber": "",
"DeliveryAddressCountryRegionId": "",
"DeliveryAddressLatitude": 0,
"DeliveryAddressCity": "",
"SalesProductCategoryName": "Speakers",
"SalesOrderPromisingMethod": "None",
"ProjectId": "",
"ProjectLinePropertyId": "",
"DeliveryAddressDistrictName": "",
"SalesRebateProductGroupId": "",
"DeliveryAddressCountyId": "",
"SalesUnitSymbol": "ea",
"ItemWithholdingTaxCodeGroupCode": "",
"ConfirmedReceiptDate": "2015-01-20T12:00:00Z",
"ProductSizeId": "",
"FixedPriceCharges": 0,
"DeliveryAddressZipCode": "",
"DeliveryAddressDunsNumber": "",
"DeliveryTermsId": "",
"ServiceFiscalInformationCode": "",
"RetailCalculatedTotalDiscountAmount": 0,
"DeliveryAddressName": "Contoso Europe",
"PackingUnitSymbol": "",
"OrderedSalesQuantity": 150,
"BOMId": "",
"DeliveryAddressStreetNumber": "",
"CreditNoteReasonCode": "",
"DeliveryAddressStreetInKana": "",
"ShippingSiteId": "1",
"NGPCode": 0,
"RetailCalculatedLineDiscountAmount": 0,
"IsDeliveryAddressPrivate": "No",
"LineCreationSequenceNumber": 1,
"RetailCalculatedTenderDiscountPercentage": 0,
"MainAccountIdDisplayValue": "",
"OrderedInventoryStatusId": "",
"GiftCardRecipientEmail": "",
"DeliveryAddressCountryRegionISOCode": "",
"ItemSerialNumber": "",
"RetailCalculatedManualLineDiscountPercentage": 0,
"RetailCalculatedPeriodicDiscountAmount": 0,
"IntrastatTransactionCode": "",
"CurrencyCode": "USD",
"DeliveryAddressLocationId": "",
"SalesTaxItemGroupCode": "AU/VI",
"RouteId": "",
"EInvoicePropertyNumber": "",
"ProductVersionId": "",
"CommissionSalesRepresentativeGroupId": "",
"CustomsDocumentName": "",
"WillAutomaticInventoryReservationConsiderBatchAttributes": "No",
"IntrastatStatisticsProcedureCode": "",
"LineDescription": "Mid-Range Speaker",
"DeliveryAddressStreet": "",
"DeliveryModeCode": "40",
"ConfirmedShippingDate": "2015-01-20T12:00:00Z",
"RetailCalculatedLineDiscountPercentage": 0,
"SalesTaxGroupCode": "EXMPT FOR",
"ServiceOrderNumber": "",
"IsDeliveryAddressOrderSpecific": "No",
"CustomerRequisitionNumber": "",
"SalesOrderNumber": "000002",
"FiscalDocumentTypeId": "",
"DeliveryCFOPCode": "",
"LineDiscountPercentage": 0,
"SalesPrice": 330,
"GiftCardGiftMessage": "",
"FulfillmentStatus": "Unknown",
"OrderedCatchWeightQuantity": 0,
"RetailCalculatedPeriodicDiscountPercentage": 0,
"OrderLineReference": "",
"AllowedUnderdeliveryPercentage": 0,
"DeliveryAddressCityInKana": "",
"AllowedOverdeliveryPercentage": 0,
"DeliveryAddressLongitude": 0,
"IntrastatCommodityCode": "",
"DefaultLedgerDimensionDisplayValue": "001--",
"DeliveryAddressTimeZone": null,
"ProductColorId": "",
"GiftCardRecipientName": "",
"CFOPCode": "",
"DeliverySalesTaxItemGroupCode": "",
"DeliveryAddressStateId": "",
"DeliveryBuildingCompliment": "",
"IntrastatTransportModeCode": "",
"DeliveryAddressPostBox": "",
"CustomsDocumentDate": "1900-01-01T12:00:00Z",
"CustomersLineNumber": 0,
"GiftCardType": "Email",
"LineAmount": 49500,
"IntrastatPortId": "",
"IntrastatSpecialMovementCode": "",
"SalesPriceQuantity": 1,
"WillRebateCalculationExcludeLine": "No",
"RetailCalculatedTenderDiscountAmount": 0,
"SuframaDiscountPercentage": 0,
"InventoryReservationMethod": "None",
"RequestedShippingDate": "2015-01-20T12:00:00Z",
"RetailCalculatedManualLineDiscountAmount": 0,
"WithholdingTaxGroupCode": "",
"FulfillmentStoreId": "",
"SkipCreateAutoCharges": "Yes",
"ExternalItemNumber": "",
"IntrastatStatisticValue": 0,
"IsLineStopped": "No",
"GiftCardBuyerEmail": "",
"RevRecRevenueScheduleId": "",
"RevRecSalesDeliverNow": 0,
"RevRecContractEndDate": "1900-01-01T12:00:00Z",
"RevRecOccurrences": 0,
"RevRecContractStartDate": "1900-01-01T12:00:00Z"
},
{
"@odata.etag": "W/\"JzAsNTYzNzE0NDU3NzswLDA7MCwwOzAsMDswLDA7MCwwOzAsMCc=\"",
"dataAreaId": "usmf",
"InventoryLotId": "000222",
"RequestedReceiptDate": "2015-01-20T12:00:00Z",
"RetailCalculatedTotalDiscountPercentage": 0,
"EInvoiceDimensionAccountCode": "",
"FormattedDelveryAddress": "",
"ShippingWarehouseLocationId": "13",
"SalesOrderLineStatus": "Invoiced",
"ProjectCategoryId": "",
"ItemNumber": "L0001",
"DeliveryAddressDescription": "",
"MultilineDiscountPercentage": 0,
"ShippingWarehouseId": "13",
"GiftCardBuyerName": "",
"GiftCardNumber": "",
"CustomsDocumentNumber": "",
"LineDiscountAmount": 0,
"ProductStyleId": "",
"ProductConfigurationId": "",
"DeliverySalesTaxGroupCode": "",
"IsIntrastatTriangularDeal": "No",
"MultilineDiscountAmount": 0,
"ItemBatchNumber": "",
"DeliveryAddressCountryRegionId": "",
"DeliveryAddressLatitude": 0,
"DeliveryAddressCity": "",
"SalesProductCategoryName": "Speakers",
"SalesOrderPromisingMethod": "None",
"ProjectId": "",
"ProjectLinePropertyId": "",
"DeliveryAddressDistrictName": "",
"SalesRebateProductGroupId": "",
"DeliveryAddressCountyId": "",
"SalesUnitSymbol": "ea",
"ItemWithholdingTaxCodeGroupCode": "",
"ConfirmedReceiptDate": "2015-01-20T12:00:00Z",
"ProductSizeId": "",
"FixedPriceCharges": 0,
"DeliveryAddressZipCode": "",
"DeliveryAddressDunsNumber": "",
"DeliveryTermsId": "",
"ServiceFiscalInformationCode": "",
"RetailCalculatedTotalDiscountAmount": 0,
"DeliveryAddressName": "Contoso Europe",
"PackingUnitSymbol": "",
"OrderedSalesQuantity": 120,
"BOMId": "",
"DeliveryAddressStreetNumber": "",
"CreditNoteReasonCode": "",
"DeliveryAddressStreetInKana": "",
"ShippingSiteId": "1",
"NGPCode": 0,
"RetailCalculatedLineDiscountAmount": 0,
"IsDeliveryAddressPrivate": "No",
"LineCreationSequenceNumber": 2,
"RetailCalculatedTenderDiscountPercentage": 0,
"MainAccountIdDisplayValue": "",
"OrderedInventoryStatusId": "",
"GiftCardRecipientEmail": "",
"DeliveryAddressCountryRegionISOCode": "",
"ItemSerialNumber": "",
"RetailCalculatedManualLineDiscountPercentage": 0,
"RetailCalculatedPeriodicDiscountAmount": 0,
"IntrastatTransactionCode": "",
"CurrencyCode": "USD",
"DeliveryAddressLocationId": "",
"SalesTaxItemGroupCode": "AU/VI",
"RouteId": "",
"EInvoicePropertyNumber": "",
"ProductVersionId": "",
"CommissionSalesRepresentativeGroupId": "",
"CustomsDocumentName": "",
"WillAutomaticInventoryReservationConsiderBatchAttributes": "No",
"IntrastatStatisticsProcedureCode": "",
"LineDescription": "Mid-Range Speaker 2",
"DeliveryAddressStreet": "",
"DeliveryModeCode": "40",
"ConfirmedShippingDate": "2015-01-20T12:00:00Z",
"RetailCalculatedLineDiscountPercentage": 0,
"SalesTaxGroupCode": "EXMPT FOR",
"ServiceOrderNumber": "",
"IsDeliveryAddressOrderSpecific": "No",
"CustomerRequisitionNumber": "",
"SalesOrderNumber": "000002",
"FiscalDocumentTypeId": "",
"DeliveryCFOPCode": "",
"LineDiscountPercentage": 0,
"SalesPrice": 308,
"GiftCardGiftMessage": "",
"FulfillmentStatus": "Unknown",
"OrderedCatchWeightQuantity": 0,
"RetailCalculatedPeriodicDiscountPercentage": 0,
"OrderLineReference": "",
"AllowedUnderdeliveryPercentage": 0,
"DeliveryAddressCityInKana": "",
"AllowedOverdeliveryPercentage": 0,
"DeliveryAddressLongitude": 0,
"IntrastatCommodityCode": "",
"DefaultLedgerDimensionDisplayValue": "001--",
"DeliveryAddressTimeZone": null,
"ProductColorId": "",
"GiftCardRecipientName": "",
"CFOPCode": "",
"DeliverySalesTaxItemGroupCode": "",
"DeliveryAddressStateId": "",
"DeliveryBuildingCompliment": "",
"IntrastatTransportModeCode": "",
"DeliveryAddressPostBox": "",
"CustomsDocumentDate": "1900-01-01T12:00:00Z",
"CustomersLineNumber": 0,
"GiftCardType": "Email",
"LineAmount": 36960,
"IntrastatPortId": "",
"IntrastatSpecialMovementCode": "",
"SalesPriceQuantity": 1,
"WillRebateCalculationExcludeLine": "No",
"RetailCalculatedTenderDiscountAmount": 0,
"SuframaDiscountPercentage": 0,
"InventoryReservationMethod": "None",
"RequestedShippingDate": "2015-01-20T12:00:00Z",
"RetailCalculatedManualLineDiscountAmount": 0,
"WithholdingTaxGroupCode": "",
"FulfillmentStoreId": "",
"SkipCreateAutoCharges": "Yes",
"ExternalItemNumber": "",
"IntrastatStatisticValue": 0,
"IsLineStopped": "No",
"GiftCardBuyerEmail": "",
"RevRecRevenueScheduleId": "",
"RevRecSalesDeliverNow": 0,
"RevRecContractEndDate": "1900-01-01T12:00:00Z",
"RevRecOccurrences": 0,
"RevRecContractStartDate": "1900-01-01T12:00:00Z"
},
{
"@odata.etag": "W/\"JzAsNTYzNzE0NDU3ODswLDA7MCwwOzAsMDswLDA7MCwwOzAsMCc=\"",
"dataAreaId": "usmf",
"InventoryLotId": "000223",
"RequestedReceiptDate": "2015-01-20T12:00:00Z",
"RetailCalculatedTotalDiscountPercentage": 0,
"EInvoiceDimensionAccountCode": "",
"FormattedDelveryAddress": "",
"ShippingWarehouseLocationId": "",
"SalesOrderLineStatus": "Invoiced",
"ProjectCategoryId": "",
"ItemNumber": "P0001",
"DeliveryAddressDescription": "",
"MultilineDiscountPercentage": 0,
"ShippingWarehouseId": "32",
"GiftCardBuyerName": "",
"GiftCardNumber": "",
"CustomsDocumentNumber": "",
"LineDiscountAmount": 0,
"ProductStyleId": "",
"ProductConfigurationId": "",
"DeliverySalesTaxGroupCode": "",
"IsIntrastatTriangularDeal": "No",
"MultilineDiscountAmount": 0,
"ItemBatchNumber": "",
"DeliveryAddressCountryRegionId": "",
"DeliveryAddressLatitude": 0,
"DeliveryAddressCity": "",
"SalesProductCategoryName": "",
"SalesOrderPromisingMethod": "None",
"ProjectId": "",
"ProjectLinePropertyId": "",
"DeliveryAddressDistrictName": "",
"SalesRebateProductGroupId": "",
"DeliveryAddressCountyId": "",
"SalesUnitSymbol": "ea",
"ItemWithholdingTaxCodeGroupCode": "",
"ConfirmedReceiptDate": "2015-01-20T12:00:00Z",
"ProductSizeId": "",
"FixedPriceCharges": 0,
"DeliveryAddressZipCode": "",
"DeliveryAddressDunsNumber": "",
"DeliveryTermsId": "",
"ServiceFiscalInformationCode": "",
"RetailCalculatedTotalDiscountAmount": 0,
"DeliveryAddressName": "Contoso Europe",
"PackingUnitSymbol": "",
"OrderedSalesQuantity": 2500,
"BOMId": "",
"DeliveryAddressStreetNumber": "",
"CreditNoteReasonCode": "",
"DeliveryAddressStreetInKana": "",
"ShippingSiteId": "3",
"NGPCode": 0,
"RetailCalculatedLineDiscountAmount": 0,
"IsDeliveryAddressPrivate": "No",
"LineCreationSequenceNumber": 3,
"RetailCalculatedTenderDiscountPercentage": 0,
"MainAccountIdDisplayValue": "",
"OrderedInventoryStatusId": "",
"GiftCardRecipientEmail": "",
"DeliveryAddressCountryRegionISOCode": "",
"ItemSerialNumber": "",
"RetailCalculatedManualLineDiscountPercentage": 0,
"RetailCalculatedPeriodicDiscountAmount": 0,
"IntrastatTransactionCode": "",
"CurrencyCode": "USD",
"DeliveryAddressLocationId": "",
"SalesTaxItemGroupCode": "SPB",
"RouteId": "",
"EInvoicePropertyNumber": "",
"ProductVersionId": "",
"CommissionSalesRepresentativeGroupId": "",
"CustomsDocumentName": "",
"WillAutomaticInventoryReservationConsiderBatchAttributes": "No",
"IntrastatStatisticsProcedureCode": "",
"LineDescription": "Acoustic Foam panel",
"DeliveryAddressStreet": "",
"DeliveryModeCode": "40",
"ConfirmedShippingDate": "2015-01-20T12:00:00Z",
"RetailCalculatedLineDiscountPercentage": 0,
"SalesTaxGroupCode": "EXMPT FOR",
"ServiceOrderNumber": "",
"IsDeliveryAddressOrderSpecific": "No",
"CustomerRequisitionNumber": "",
"SalesOrderNumber": "000002",
"FiscalDocumentTypeId": "",
"DeliveryCFOPCode": "",
"LineDiscountPercentage": 0,
"SalesPrice": 27.5,
"GiftCardGiftMessage": "",
"FulfillmentStatus": "Unknown",
"OrderedCatchWeightQuantity": 0,
"RetailCalculatedPeriodicDiscountPercentage": 0,
"OrderLineReference": "",
"AllowedUnderdeliveryPercentage": 0,
"DeliveryAddressCityInKana": "",
"AllowedOverdeliveryPercentage": 0,
"DeliveryAddressLongitude": 0,
"IntrastatCommodityCode": "",
"DefaultLedgerDimensionDisplayValue": "001--",
"DeliveryAddressTimeZone": null,
"ProductColorId": "",
"GiftCardRecipientName": "",
"CFOPCode": "",
"DeliverySalesTaxItemGroupCode": "",
"DeliveryAddressStateId": "",
"DeliveryBuildingCompliment": "",
"IntrastatTransportModeCode": "",
"DeliveryAddressPostBox": "",
"CustomsDocumentDate": "1900-01-01T12:00:00Z",
"CustomersLineNumber": 0,
"GiftCardType": "Email",
"LineAmount": 68750,
"IntrastatPortId": "",
"IntrastatSpecialMovementCode": "",
"SalesPriceQuantity": 1,
"WillRebateCalculationExcludeLine": "No",
"RetailCalculatedTenderDiscountAmount": 0,
"SuframaDiscountPercentage": 0,
"InventoryReservationMethod": "None",
"RequestedShippingDate": "2015-01-20T12:00:00Z",
"RetailCalculatedManualLineDiscountAmount": 0,
"WithholdingTaxGroupCode": "",
"FulfillmentStoreId": "",
"SkipCreateAutoCharges": "Yes",
"ExternalItemNumber": "",
"IntrastatStatisticValue": 0,
"IsLineStopped": "No",
"GiftCardBuyerEmail": "",
"RevRecRevenueScheduleId": "",
"RevRecSalesDeliverNow": 0,
"RevRecContractEndDate": "1900-01-01T12:00:00Z",
"RevRecOccurrences": 0,
"RevRecContractStartDate": "1900-01-01T12:00:00Z"
},
{
"@odata.etag": "W/\"JzAsNTYzNzE0NDU3OTswLDA7MCwwOzAsMDswLDA7MCwwOzAsMCc=\"",
"dataAreaId": "usmf",
"InventoryLotId": "000224",
"RequestedReceiptDate": "2015-01-20T12:00:00Z",
"RetailCalculatedTotalDiscountPercentage": 0,
"EInvoiceDimensionAccountCode": "",
"FormattedDelveryAddress": "",
"ShippingWarehouseLocationId": "",
"SalesOrderLineStatus": "Invoiced",
"ProjectCategoryId": "",
"ItemNumber": "D0003",
"DeliveryAddressDescription": "",
"MultilineDiscountPercentage": 0,
"ShippingWarehouseId": "13",
"GiftCardBuyerName": "",
"GiftCardNumber": "",
"CustomsDocumentNumber": "",
"LineDiscountAmount": 0,
"ProductStyleId": "",
"ProductConfigurationId": "",
"DeliverySalesTaxGroupCode": "",
"IsIntrastatTriangularDeal": "No",
"MultilineDiscountAmount": 0,
"ItemBatchNumber": "",
"DeliveryAddressCountryRegionId": "",
"DeliveryAddressLatitude": 0,
"DeliveryAddressCity": "",
"SalesProductCategoryName": "Speakers",
"SalesOrderPromisingMethod": "None",
"ProjectId": "",
"ProjectLinePropertyId": "",
"DeliveryAddressDistrictName": "",
"SalesRebateProductGroupId": "",
"DeliveryAddressCountyId": "",
"SalesUnitSymbol": "ea",
"ItemWithholdingTaxCodeGroupCode": "",
"ConfirmedReceiptDate": "2015-01-20T12:00:00Z",
"ProductSizeId": "",
"FixedPriceCharges": 0,
"DeliveryAddressZipCode": "",
"DeliveryAddressDunsNumber": "",
"DeliveryTermsId": "",
"ServiceFiscalInformationCode": "",
"RetailCalculatedTotalDiscountAmount": 0,
"DeliveryAddressName": "Contoso Europe",
"PackingUnitSymbol": "",
"OrderedSalesQuantity": 140,
"BOMId": "",
"DeliveryAddressStreetNumber": "",
"CreditNoteReasonCode": "",
"DeliveryAddressStreetInKana": "",
"ShippingSiteId": "1",
"NGPCode": 0,
"RetailCalculatedLineDiscountAmount": 0,
"IsDeliveryAddressPrivate": "No",
"LineCreationSequenceNumber": 4,
"RetailCalculatedTenderDiscountPercentage": 0,
"MainAccountIdDisplayValue": "",
"OrderedInventoryStatusId": "",
"GiftCardRecipientEmail": "",
"DeliveryAddressCountryRegionISOCode": "",
"ItemSerialNumber": "",
"RetailCalculatedManualLineDiscountPercentage": 0,
"RetailCalculatedPeriodicDiscountAmount": 0,
"IntrastatTransactionCode": "",
"CurrencyCode": "USD",
"DeliveryAddressLocationId": "",
"SalesTaxItemGroupCode": "AU/VI",
"RouteId": "",
"EInvoicePropertyNumber": "",
"ProductVersionId": "",
"CommissionSalesRepresentativeGroupId": "",
"CustomsDocumentName": "",
"WillAutomaticInventoryReservationConsiderBatchAttributes": "No",
"IntrastatStatisticsProcedureCode": "",
"LineDescription": "Standard Speaker",
"DeliveryAddressStreet": "",
"DeliveryModeCode": "40",
"ConfirmedShippingDate": "2015-01-20T12:00:00Z",
"RetailCalculatedLineDiscountPercentage": 0,
"SalesTaxGroupCode": "EXMPT FOR",
"ServiceOrderNumber": "",
"IsDeliveryAddressOrderSpecific": "No",
"CustomerRequisitionNumber": "",
"SalesOrderNumber": "000002",
"FiscalDocumentTypeId": "",
"DeliveryCFOPCode": "",
"LineDiscountPercentage": 0,
"SalesPrice": 198,
"GiftCardGiftMessage": "",
"FulfillmentStatus": "Unknown",
"OrderedCatchWeightQuantity": 0,
"RetailCalculatedPeriodicDiscountPercentage": 0,
"OrderLineReference": "",
"AllowedUnderdeliveryPercentage": 0,
"DeliveryAddressCityInKana": "",
"AllowedOverdeliveryPercentage": 0,
"DeliveryAddressLongitude": 0,
"IntrastatCommodityCode": "",
"DefaultLedgerDimensionDisplayValue": "001--",
"DeliveryAddressTimeZone": null,
"ProductColorId": "",
"GiftCardRecipientName": "",
"CFOPCode": "",
"DeliverySalesTaxItemGroupCode": "",
"DeliveryAddressStateId": "",
"DeliveryBuildingCompliment": "",
"IntrastatTransportModeCode": "",
"DeliveryAddressPostBox": "",
"CustomsDocumentDate": "1900-01-01T12:00:00Z",
"CustomersLineNumber": 0,
"GiftCardType": "Email",
"LineAmount": 27720,
"IntrastatPortId": "",
"IntrastatSpecialMovementCode": "",
"SalesPriceQuantity": 1,
"WillRebateCalculationExcludeLine": "No",
"RetailCalculatedTenderDiscountAmount": 0,
"SuframaDiscountPercentage": 0,
"InventoryReservationMethod": "None",
"RequestedShippingDate": "2015-01-20T12:00:00Z",
"RetailCalculatedManualLineDiscountAmount": 0,
"WithholdingTaxGroupCode": "",
"FulfillmentStoreId": "",
"SkipCreateAutoCharges": "Yes",
"ExternalItemNumber": "",
"IntrastatStatisticValue": 0,
"IsLineStopped": "No",
"GiftCardBuyerEmail": "",
"RevRecRevenueScheduleId": "",
"RevRecSalesDeliverNow": 0,
"RevRecContractEndDate": "1900-01-01T12:00:00Z",
"RevRecOccurrences": 0,
"RevRecContractStartDate": "1900-01-01T12:00:00Z"
},
{
"@odata.etag": "W/\"JzAsNTYzNzE0NDU4MDswLDA7MCwwOzAsMDswLDA7MCwwOzAsMCc=\"",
"dataAreaId": "usmf",
"InventoryLotId": "000225",
"RequestedReceiptDate": "2015-01-20T12:00:00Z",
"RetailCalculatedTotalDiscountPercentage": 0,
"EInvoiceDimensionAccountCode": "",
"FormattedDelveryAddress": "",
"ShippingWarehouseLocationId": "",
"SalesOrderLineStatus": "Invoiced",
"ProjectCategoryId": "",
"ItemNumber": "D0004",
"DeliveryAddressDescription": "",
"MultilineDiscountPercentage": 0,
"ShippingWarehouseId": "13",
"GiftCardBuyerName": "",
"GiftCardNumber": "",
"CustomsDocumentNumber": "",
"LineDiscountAmount": 0,
"ProductStyleId": "",
"ProductConfigurationId": "Default",
"DeliverySalesTaxGroupCode": "",
"IsIntrastatTriangularDeal": "No",
"MultilineDiscountAmount": 0,
"ItemBatchNumber": "",
"DeliveryAddressCountryRegionId": "",
"DeliveryAddressLatitude": 0,
"DeliveryAddressCity": "",
"SalesProductCategoryName": "Speakers",
"SalesOrderPromisingMethod": "None",
"ProjectId": "",
"ProjectLinePropertyId": "",
"DeliveryAddressDistrictName": "",
"SalesRebateProductGroupId": "",
"DeliveryAddressCountyId": "",
"SalesUnitSymbol": "ea",
"ItemWithholdingTaxCodeGroupCode": "",
"ConfirmedReceiptDate": "2015-01-20T12:00:00Z",
"ProductSizeId": "",
"FixedPriceCharges": 0,
"DeliveryAddressZipCode": "",
"DeliveryAddressDunsNumber": "",
"DeliveryTermsId": "",
"ServiceFiscalInformationCode": "",
"RetailCalculatedTotalDiscountAmount": 0,
"DeliveryAddressName": "Contoso Europe",
"PackingUnitSymbol": "",
"OrderedSalesQuantity": 120,
"BOMId": "",
"DeliveryAddressStreetNumber": "",
"CreditNoteReasonCode": "",
"DeliveryAddressStreetInKana": "",
"ShippingSiteId": "1",
"NGPCode": 0,
"RetailCalculatedLineDiscountAmount": 0,
"IsDeliveryAddressPrivate": "No",
"LineCreationSequenceNumber": 5,
"RetailCalculatedTenderDiscountPercentage": 0,
"MainAccountIdDisplayValue": "",
"OrderedInventoryStatusId": "",
"GiftCardRecipientEmail": "",
"DeliveryAddressCountryRegionISOCode": "",
"ItemSerialNumber": "",
"RetailCalculatedManualLineDiscountPercentage": 0,
"RetailCalculatedPeriodicDiscountAmount": 0,
"IntrastatTransactionCode": "",
"CurrencyCode": "USD",
"DeliveryAddressLocationId": "",
"SalesTaxItemGroupCode": "AU/VI",
"RouteId": "",
"EInvoicePropertyNumber": "",
"ProductVersionId": "",
"CommissionSalesRepresentativeGroupId": "",
"CustomsDocumentName": "",
"WillAutomaticInventoryReservationConsiderBatchAttributes": "No",
"IntrastatStatisticsProcedureCode": "",
"LineDescription": "High End Speaker",
"DeliveryAddressStreet": "",
"DeliveryModeCode": "40",
"ConfirmedShippingDate": "2015-01-20T12:00:00Z",
"RetailCalculatedLineDiscountPercentage": 0,
"SalesTaxGroupCode": "EXMPT FOR",
"ServiceOrderNumber": "",
"IsDeliveryAddressOrderSpecific": "No",
"CustomerRequisitionNumber": "",
"SalesOrderNumber": "000002",
"FiscalDocumentTypeId": "",
"DeliveryCFOPCode": "",
"LineDiscountPercentage": 0,
"SalesPrice": 1210,
"GiftCardGiftMessage": "",
"FulfillmentStatus": "Unknown",
"OrderedCatchWeightQuantity": 0,
"RetailCalculatedPeriodicDiscountPercentage": 0,
"OrderLineReference": "",
"AllowedUnderdeliveryPercentage": 0,
"DeliveryAddressCityInKana": "",
"AllowedOverdeliveryPercentage": 0,
"DeliveryAddressLongitude": 0,
"IntrastatCommodityCode": "",
"DefaultLedgerDimensionDisplayValue": "001--",
"DeliveryAddressTimeZone": null,
"ProductColorId": "",
"GiftCardRecipientName": "",
"CFOPCode": "",
"DeliverySalesTaxItemGroupCode": "",
"DeliveryAddressStateId": "",
"DeliveryBuildingCompliment": "",
"IntrastatTransportModeCode": "",
"DeliveryAddressPostBox": "",
"CustomsDocumentDate": "1900-01-01T12:00:00Z",
"CustomersLineNumber": 0,
"GiftCardType": "Email",
"LineAmount": 145200,
"IntrastatPortId": "",
"IntrastatSpecialMovementCode": "",
"SalesPriceQuantity": 1,
"WillRebateCalculationExcludeLine": "No",
"RetailCalculatedTenderDiscountAmount": 0,
"SuframaDiscountPercentage": 0,
"InventoryReservationMethod": "None",
"RequestedShippingDate": "2015-01-20T12:00:00Z",
"RetailCalculatedManualLineDiscountAmount": 0,
"WithholdingTaxGroupCode": "",
"FulfillmentStoreId": "",
"SkipCreateAutoCharges": "Yes",
"ExternalItemNumber": "",
"IntrastatStatisticValue": 0,
"IsLineStopped": "No",
"GiftCardBuyerEmail": "",
"RevRecRevenueScheduleId": "",
"RevRecSalesDeliverNow": 0,
"RevRecContractEndDate": "1900-01-01T12:00:00Z",
"RevRecOccurrences": 0,
"RevRecContractStartDate": "1900-01-01T12:00:00Z"
}
]
}
We can expends SalesOrderLines in this query too, but not need to do this too much.
Please remember - each request make load AOS. You should use only nessesory field list in your query, filter records by internal indxes (next post describe how to get indexes for entity), build not too deep requests.
Please find more indormation how to use oData requests in this post
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.
Last modified
January 19, 2021
: vendor invoice added, change layout of pages (c2791fc)