Dynamics 365 Business Central Sales Order XML
The XML format documented here is used for both the import and export of sales orders in Dynamics 365 Business Central.
We recommend that the ExternalId
field be populated with the unique ID of the sales orders from the external system, Zynk uses this field to track sales orders already imported to prevent duplicates being created in Dynamics 365 Business Central.
Tasks
- Exporting Sales Orders from Dynamics 365 Business Central
- Importing Sales Orders into Dynamics 365 Business Central
XML
Any fields not documented below are not supported with our imports / exports. Examples of where in the XML the fields should appear are shown in the samples below.
Sample Sales Order File:
<?xml version="1.0" encoding="utf-8"?>
<SalesOrders xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SalesOrder>
<Id>695f24f7-f362-ea11-a813-000d3a86fa27</Id>
<ExternalId>12347</ExternalId>
<ODataETag>W/"JzQ0O1paaDBYNnF4bnpodFhyVyt3U0ZtUDdzZEZ0c1U5Q2Nnc3I5bjZWbDM3Rzg9MTswMDsn"</ODataETag>
<Number>101010</Number>
<ExternalDocumentNumber>TEST0003</ExternalDocumentNumber>
<CustomerId>d4f4fd40-34bc-ed11-9a88-6045bd0cf992</CustomerId>
<ContactId />
<CustomerNumber>C00020</CustomerNumber>
<CustomerName>Zynk Software</CustomerName>
<Customer>
<Id>d4f4fd40-34bc-ed11-9a88-6045bd0cf992</Id>
<ODataETag>W/"JzIwOzEzMzE2NzA3MzUyOTk2NjU1NzExMTswMDsn"</ODataETag>
<Number>C00020</Number>
<DisplayName>Zynk Software</DisplayName>
<Type>Company</Type>
<AddressLine1>Office 16</AddressLine1>
<AddressLine2>6 Charlotte Square</AddressLine2>
<City>Newcastle</City>
<State>Tyne & Wear</State>
<Country>GB</Country>
<PostalCode>NE1 4XF</PostalCode>
<PhoneNumber />
<Email>[email protected]</Email>
<Website>www.zynk.com</Website>
<TaxLiable>false</TaxLiable>
<TaxAreaId>248e3bdf-549e-ed11-988a-000d3a3885d3</TaxAreaId>
<TaxAreaDisplayName>Domestic customers and vendors</TaxAreaDisplayName>
<TaxRegistrationNumber />
<CurrencyId>00000000-0000-0000-0000-000000000000</CurrencyId>
<CurrencyCode>GBP</CurrencyCode>
<PaymentTermsId>fa97d7da-549e-ed11-988a-000d3a3885d3</PaymentTermsId>
<ShipmentMethodId>ae98d7da-549e-ed11-988a-000d3a3885d3</ShipmentMethodId>
<PaymentMethodId>c58d3bdf-549e-ed11-988a-000d3a3885d3</PaymentMethodId>
<Blocked>_x0020_</Blocked>
<LastModifiedDateTime>2023-03-06T15:33:37.68Z</LastModifiedDateTime>
</Customer>
<BillToName>Zynk Software</BillToName>
<BillToCustomerId>d4f4fd40-34bc-ed11-9a88-6045bd0cf992</BillToCustomerId>
<BillToCustomerNumber>C00020</BillToCustomerNumber>
<BillToCustomer>
<Id>d4f4fd40-34bc-ed11-9a88-6045bd0cf992</Id>
<ODataETag>W/"JzIwOzEzMzE2NzA3MzUyOTk2NjU1NzExMTswMDsn"</ODataETag>
<Number>C00020</Number>
<DisplayName>Zynk Software</DisplayName>
<Type>Company</Type>
<AddressLine1>Office 16</AddressLine1>
<AddressLine2>6 Charlotte Square</AddressLine2>
<City>Newcastle</City>
<State>Tyne & Wear</State>
<Country>GB</Country>
<PostalCode>NE1 4XF</PostalCode>
<PhoneNumber />
<Email>[email protected]</Email>
<Website>www.zynk.com</Website>
<TaxLiable>false</TaxLiable>
<TaxAreaId>248e3bdf-549e-ed11-988a-000d3a3885d3</TaxAreaId>
<TaxAreaDisplayName>Domestic customers and vendors</TaxAreaDisplayName>
<TaxRegistrationNumber />
<CurrencyId>00000000-0000-0000-0000-000000000000</CurrencyId>
<CurrencyCode>GBP</CurrencyCode>
<PaymentTermsId>fa97d7da-549e-ed11-988a-000d3a3885d3</PaymentTermsId>
<ShipmentMethodId>ae98d7da-549e-ed11-988a-000d3a3885d3</ShipmentMethodId>
<PaymentMethodId>c58d3bdf-549e-ed11-988a-000d3a3885d3</PaymentMethodId>
<Blocked>_x0020_</Blocked>
<LastModifiedDateTime>2023-03-06T15:33:37.68Z</LastModifiedDateTime>
</BillToCustomer>
<SellToAddressLine1>Office 16</SellToAddressLine1>
<SellToAddressLine2>6 Charlotte Square</SellToAddressLine2>
<SellToCity>Newcastle Upon Tyne</SellToCity>
<SellToState>Tyne & Wear</SellToState>
<SellToPostCode>NE1 4XF</SellToPostCode>
<SellToCountry>GB</SellToCountry>
<BillToAddressLine1>Office 16</BillToAddressLine1>
<BillToAddressLine2>6 Charlotte Square</BillToAddressLine2>
<BillToCity>Newcastle Upon Tyne</BillToCity>
<BillToState>Tyne & Wear</BillToState>
<BillToPostCode>NE1 4XF</BillToPostCode>
<BillToCountry>GB</BillToCountry>
<ShipToName>Zynk Software</ShipToName>
<ShipToContact>John Smith</ShipToContact>
<ShipToAddressLine1>Office 16</ShipToAddressLine1>
<ShipToAddressLine2>6 Charlotte Square</ShipToAddressLine2>
<ShipToCity>Newcastle Upon Tyne</ShipToCity>
<ShipToState>Tyne & Wear</ShipToState>
<ShipToPostCode>NE1 4XF</ShipToPostCode>
<ShipToCountry>GB</ShipToCountry>
<CurrencyId>00000000-0000-0000-0000-000000000000</CurrencyId>
<CurrencyCode>GBP</CurrencyCode>
<PaymentTermsId>9eb1e6b3-611d-ea11-bb2d-000d3a4884fc</PaymentTermsId>
<ShipmentMethodId>00000000-0000-0000-0000-000000000000</ShipmentMethodId>
<Salesperson>PS</Salesperson>
<DiscountAmount>0</DiscountAmount>
<TotalAmountExcludingTax>83.33</TotalAmountExcludingTax>
<TotalTaxAmount>16.67</TotalTaxAmount>
<TotalAmountIncludingTax>100</TotalAmountIncludingTax>
<Status>Draft</Status>
<LastModifiedDateTime>2020-03-11T16:29:50.49Z</LastModifiedDateTime>
<PhoneNumber />
<Email>[email protected]</Email>
<PostingDate>2020-03-10T00:00:00</PostingDate>
<PaymentTerm>
<Id>9eb1e6b3-611d-ea11-bb2d-000d3a4884fc</Id>
<ODataETag>W/"JzQ0OzBIUFVhUjVsSGFMczNJZm9nbkdlZk9nTDBqRXR3L3RrYUdHRE1kTHc0WFE9MTswMDsn"</ODataETag>
<Code>1M(8D)</Code>
<DisplayName>1 Month/2% 8 days</DisplayName>
<DueDateCalculation>1M</DueDateCalculation>
<DiscountDateCalculation>8D</DiscountDateCalculation>
<DiscountPercent>2</DiscountPercent>
<CalculateDiscountOnCreditMemos>false</CalculateDiscountOnCreditMemos>
<LastModifiedDateTime>2019-12-13T04:34:12.117Z</LastModifiedDateTime>
</PaymentTerm>
<OrderDate>2020-03-10T00:00:00</OrderDate>
<PricesIncludeTax>true</PricesIncludeTax>
<PartialShipping>true</PartialShipping>
<RequestedDeliveryDate>0001-01-01T00:00:00</RequestedDeliveryDate>
<DiscountAppliedBeforeTax>false</DiscountAppliedBeforeTax>
<FullyShipped>false</FullyShipped>
<SalesOrderLines>
<SalesOrderLine>
<Id>695f24f7-f362-ea11-a813-000d3a86fa27-10000</Id>
<ExternalId>12347-1</ExternalId>
<ODataETag>W/"JzQ0O2xSSm04MnhITFBSd3RyWTJwclV6WE1XL0U2b3JhVnFxbkVPU2FkNUFhV2M9MTswMDsn"</ODataETag>
<DocumentId>695f24f7-f362-ea11-a813-000d3a86fa27</DocumentId>
<Sequence>10000</Sequence>
<ItemId>665f24f7-f362-ea11-a813-000d3a86fa27</ItemId>
<Item>
<Id>d6f5554c-a867-ea11-a813-000d3a86fa27</Id>
<ExternalId>TEST0001</ExternalId>
<Number>TEST0001</Number>
<DisplayName>Test Item</DisplayName>
<Type>Inventory</Type>
<ItemCategoryId>2f18deb9-611d-ea11-bb2d-000d3a4884fc</ItemCategoryId>
<ItemCategoryCode>TABLE</ItemCategoryCode>
<Blocked>false</Blocked>
<Gtin />
<UnitPrice>649.4</UnitPrice>
<PriceIncludesTax>false</PriceIncludesTax>
<UnitCost>506.6</UnitCost>
<TaxGroupId>2c8e3bdf-549e-ed11-988a-000d3a3885d3</TaxGroupId>
<TaxGroupCode>STANDARD</TaxGroupCode>
<BaseUnitOfMeasureId>2d8c3bdf-549e-ed11-988a-000d3a3885d3</BaseUnitOfMeasureId>
<BaseUnitOfMeasureCode>PCS</BaseUnitOfMeasureCode>
</Item>
<AccountId>f9b2e6b3-611d-ea11-bb2d-000d3a4884fc</AccountId>
<Account>
<Number>10100</Number>
</Account>
<LineType>Item</LineType>
<LineObjectNumber>TEST001</LineObjectNumber>
<Description>Test Product</Description>
<UnitOfMeasureId>2d8c3bdf-549e-ed11-988a-000d3a3885d3</UnitOfMeasureId>
<UnitOfMeasureCode>PCS</UnitOfMeasureCode>
<Quantity>1</Quantity>
<UnitPrice>100</UnitPrice>
<DiscountAmount>0</DiscountAmount>
<DiscountPercent>0</DiscountPercent>
<DiscountAppliedBeforeTax>false</DiscountAppliedBeforeTax>
<AmountExcludingTax>83.33</AmountExcludingTax>
<TaxCode>STANDARD</TaxCode>
<TaxPercent>20</TaxPercent>
<TotalTaxAmount>16.67</TotalTaxAmount>
<AmountIncludingTax>100</AmountIncludingTax>
<NetAmount>83.33</NetAmount>
<NetTaxAmount>16.67</NetTaxAmount>
<NetAmountIncludingTax>100</NetAmountIncludingTax>
<InvoiceDiscountAllocation>0</InvoiceDiscountAllocation>
<ShipmentDate>2020-03-10T00:00:00</ShipmentDate>
<ShippedQuantity>0</ShippedQuantity>
<InvoicedQuantity>0</InvoicedQuantity>
<InvoiceQuantity>1</InvoiceQuantity>
<ShipQuantity>1</ShipQuantity>
</SalesOrderLine>
</SalesOrderLines>
</SalesOrder>
</SalesOrders>
In each of the following sections most of the XML has been omitted to make the samples easier to read. The whole structure of the SalesOrders
schema is used below as a reference of where fields should be in the object model.
General
The following information can be found within the 'General' section.
Dynamics Field | XML Field | Type | Input | Notes |
---|---|---|---|---|
- | Id | Guid | Optional | Used for matching existing sales orders |
- | ExternalId | string | Optional | Stored in Zynk's internal DB and used for matching existing sales orders |
No. | Number | string | Optional | Used for matching existing sales orders. The next number will be used when creating a new sales order if not specified |
External Document No. | ExternalDocumentNumber | string | Optional | Used for matching existing sales orders |
Customer No. | CustomerId | Guid | Optional | |
Customer No. | CustomerNumber | string | Optional | Performs a lookup for the customer ID based on the number |
Customer No. | Customer | Customer | Optional | Used for looking up and auto creating customers |
Customer No. | ContactId | string | Optional | Used for looking up the customer |
Customer Name | CustomerName | string | Read-only | |
Sell-To > Address | SellToAddressLine1 | string | Optional | |
Sell-To > Address | SellToAddressLine2 | string | Optional | |
Sell-To > City | SellToCity | string | Optional | |
Sell-To > County | SellToState | string | Optional | |
Sell-To > Postcode | SellToPostCode | string | Optional | |
Sell-To > Country/Region Code | SellToCountry | string | Optional | |
Phone No. | PhoneNumber | string | Optional | |
string | Optional | |||
Posting Date | PostingDate | DateTime | Optional | |
Order Date | OrderDate | DateTime | Optional | |
Requested Delivery Date | RequestedDeliveryDate | DateTime | Optional | |
Salesperson Code | Salesperson | string | Optional | |
Status | Status | string | Read-only | Can be: 'Draft', 'Cancelled', 'Paid', 'On hold', 'Created' |
<?xml version="1.0" encoding="utf-8"?>
<SalesOrders xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SalesOrder>
<Id>695f24f7-f362-ea11-a813-000d3a86fa27</Id>
<ExternalId>12347</ExternalId>
<Number>101010</Number>
<ExternalDocumentNumber>TEST0003</ExternalDocumentNumber>
<CustomerId>30219848-b45f-ea11-a812-000d3a86dae1</CustomerId>
<CustomerNumber>C00040</CustomerNumber>
<Customer>
<!-- See Customer XML for more details -->
</Customer>
<ContactId />
<CustomerName>Zynk Software</CustomerName>
<SellToAddressLine1>Office 16</SellToAddressLine1>
<SellToAddressLine2>6 Charlotte Square</SellToAddressLine2>
<SellToCity>Newcastle Upon Tyne</SellToCity>
<SellToState>Tyne & Wear</SellToState>
<SellToPostCode>NE1 4XF</SellToPostCode>
<SellToCountry>GB</SellToCountry>
<PhoneNumber>0191 820 1484</PhoneNumber>
<Email>[email protected]</Email>
<PostingDate>2020-03-10T00:00:00</PostingDate>
<OrderDate>2020-03-10T00:00:00</OrderDate>
<RequestedDeliveryDate>0001-01-01T00:00:00</RequestedDeliveryDate>
<Salesperson>PS</Salesperson>
<Status>Draft</Status>
</SalesOrder>
</SalesOrders>
Lines
The following information can be found within the 'Lines' section.
Dynamics Field | XML Field | Type | Input | Notes |
---|---|---|---|---|
- | Id | string | Optional | Used for matching existing lines |
- | ExternalId | string | Optional | Stored in Zynk's internal DB and used for matching existing lines |
- | Sequence | string | Optional | Used for matching existing lines. The next number will be used when creating a new line if not specified |
No. | ItemId | Guid | Optional | Used for matching existing lines. |
No. | Item | Item | Optional | Used for looking up and auto creating items |
- | AccountId | Guid | Optional | The line type will be automatically set to 'Account' if specified |
- | Account/Number | Guid | Optional | Performs a lookup for the account ID based on number |
Type | LineType | string | Optional | Can be: Comment, Account, Item, Resource, Fixed Asset, Charge |
No. | LineObjectNumber | string | Optional | Performs a lookup for the item or account ID based on number |
Description | Description | string | Optional | |
Quantity | Quantity | decimal | Required | |
Unit of Measure Code | UnitOfMeasureId | Guid | Optional | |
Unit of Measure Code | UnitOfMeasureCode | string | Optional | Performs a lookup for the unit of measure ID based on code |
Unit Price | UnitPrice | decimal | Required | |
Line Discount % | DiscountPercent | decimal | Optional | |
Line Discount % | DiscountAmount | decimal | Optional | |
- | DiscountAppliedBeforeTax | bool | Read-only | |
Qty. to Ship | ShipQuantity | decimal | Optional | |
Quantity Shipped | ShippedQuantity | decimal | Optional | |
Quantity to Invoice | InvoiceQuantity | decimal | Optional | |
Quantity Invoiced | InvoicedQuantity | decimal | Optional | |
Shipment Date | ShipmentDate | DateTime | Optional | |
- | AmountExcludingTax | decimal | Read-only | |
- | TaxCode | string | Optional | |
- | TaxPercent | decimal | Read-only | |
- | TotalTaxAmount | decimal | Read-only | |
- | AmountIncludingTax | decimal | Read-only | |
- | NetAmount | decimal | Read-only | |
- | NetTaxAmount | decimal | Read-only | |
- | NetAmountIncludingTax | decimal | Read-only | |
- | InvoiceDiscountAllocation | decimal | Read-only | |
Inv. Discount Amount Incl. VAT | DiscountAmount | decimal | Optional | |
Total Excl. VAT | TotalAmountExcludingTax | decimal | Read-only | |
Total VAT | TotalTaxAmount | decimal | Read-only | |
Total Incl. VAT | TotalAmountIncludingTax | decimal | Read-only | |
- | DiscountAppliedBeforeTax | bool | Read-only |
<SalesOrders xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SalesOrder>
<SalesOrderLines>
<SalesOrderLine>
<Id>695f24f7-f362-ea11-a813-000d3a86fa27-10000</Id>
<ExternalId>12347-1</ExternalId>
<Sequence>10000</Sequence>
<ItemId>665f24f7-f362-ea11-a813-000d3a86fa27</ItemId>
<Item>
<!-- See Item XML for more details -->
<Number>TEST001</Number>
</Item>
<AccountId>f9b2e6b3-611d-ea11-bb2d-000d3a4884fc</AccountId>
<Account>
<Number>10100</Number>
</Account>
<LineType>Item</LineType>
<LineObjectNumber>TEST001</LineObjectNumber>
<Description>Test Product</Description>
<Quantity>1</Quantity>
<UnitOfMeasureId>2fb4e6b3-611d-ea11-bb2d-000d3a4884fc</UnitOfMeasureId>
<UnitOfMeasureCode>PCS</UnitOfMeasureCode>
<UnitPrice>100</UnitPrice>
<DiscountPercent>0</DiscountPercent>
<DiscountAmount>0</DiscountAmount>
<DiscountAppliedBeforeTax>false</DiscountAppliedBeforeTax>
<ShipQuantity>1</ShipQuantity>
<ShippedQuantity>0</ShippedQuantity>
<InvoiceQuantity>1</InvoiceQuantity>
<InvoicedQuantity>0</InvoicedQuantity>
<ShipmentDate>2020-03-10T00:00:00</ShipmentDate>
<AmountExcludingTax>83.33</AmountExcludingTax>
<TaxCode>STANDARD</TaxCode>
<TaxPercent>20</TaxPercent>
<TotalTaxAmount>16.67</TotalTaxAmount>
<AmountIncludingTax>100</AmountIncludingTax>
<NetAmount>83.33</NetAmount>
<NetTaxAmount>16.67</NetTaxAmount>
<NetAmountIncludingTax>100</NetAmountIncludingTax>
<InvoiceDiscountAllocation>0</InvoiceDiscountAllocation>
</SalesOrderLine>
</SalesOrderLines>
<DiscountAmount>0</DiscountAmount>
<TotalAmountExcludingTax>83.33</TotalAmountExcludingTax>
<TotalTaxAmount>16.67</TotalTaxAmount>
<TotalAmountIncludingTax>100</TotalAmountIncludingTax>
<DiscountAppliedBeforeTax>false</DiscountAppliedBeforeTax>
</SalesOrder>
</SalesOrders>
Invoice Details
The following information can be found within the 'Invoice Details' section.
Dynamics Field | XML Field | Type | Input | Notes |
---|---|---|---|---|
Currency Code | CurrencyId | Guid | Optional | |
Currency Code | CurrencyCode | string | Optional | Use the 3 letter ISO code |
Prices Including VAT | PricesIncludeTax | bool | Optional | |
Payment Terms Code | PaymentTermsId | Guid | Optional | |
Payment Terms Code | PaymentTerm/Code | string | Optional | Performs a lookup for the payment terms based on code |
<?xml version="1.0" encoding="utf-8"?>
<SalesOrders xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SalesOrder>
<CurrencyId>00000000-0000-0000-0000-000000000000</CurrencyId>
<CurrencyCode>GBP</CurrencyCode>
<PricesIncludeTax>true</PricesIncludeTax>
<PaymentTermsId>9eb1e6b3-611d-ea11-bb2d-000d3a4884fc</PaymentTermsId>
<PaymentTerm>
<Code>1M(8D)</Code>
</PaymentTerm>
</SalesOrder>
</SalesOrders>
Shipping & Billing
The following information can be found within the 'Shipping & Billing' section.
Dynamics Field | XML Field | Type | Input | Notes |
---|---|---|---|---|
Ship-To > Name | ShipToName | string | Optional | |
Ship-To > Address | ShipToAddressLine1 | string | Optional | |
Ship-To > Address | ShipToAddressLine2 | string | Optional | |
Ship-To > City | ShipToCity | string | Optional | |
Ship-To > County | ShipToState | string | Optional | |
Ship-To > Postcode | ShipToPostCode | string | Optional | |
Ship-To > Country/Region | ShipToCountry | string | Optional | |
Ship-To > Contact | ShipToContact | string | Optional | |
Shipment Method > Code | ShipmentMethodId | Guid | Optional | |
Shipment Method > Code | ShipmentMethod/Code | string | Optional | Performs a lookup for the shipment method based on code |
Bill-to | BillToCustomerId | Guid | Optional | |
Bill-to | BillToCustomerNumber | string | Optional | Performs a lookup for the customer ID based on the number |
Bill-to | BillToCustomer | Customer | Optional | Used for looking up and auto creating customers |
Bill-to > Name | BillToName | string | Read-only | |
Bill-to > Address | BillToAddressLine1 | string | Optional | |
Bill-to > Address | BillToAddressLine2 | string | Optional | |
Bill-to > City | BillToCity | string | Optional | |
Bill-to > County | BillToState | string | Optional | |
Bill-to > Postcode | BillToPostCode | string | Optional | |
Bill-to > Country/Region Code | BillToCountry | string | Optional | |
Shipping Advice | PartialShipping | bool | Optional | |
- | FullyShipped | bool | Read-only |
<?xml version="1.0" encoding="utf-8"?>
<SalesOrders xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SalesOrder>
<ShipToName>Zynk Software</ShipToName>
<ShipToAddressLine1>Office 16</ShipToAddressLine1>
<ShipToAddressLine2>6 Charlotte Square</ShipToAddressLine2>
<ShipToCity>Newcastle Upon Tyne</ShipToCity>
<ShipToState>Tyne & Wear</ShipToState>
<ShipToPostCode>NE1 4XF</ShipToPostCode>
<ShipToCountry>GB</ShipToCountry>
<ShipToContact>John Smith</ShipToContact>
<ShipmentMethodId>c4b2e6b3-611d-ea11-bb2d-000d3a4884fc</ShipmentMethodId>
<ShipmentMethod>
<Code>CFR</Code>
</ShipmentMethod>
<BillToCustomerId>30219848-b45f-ea11-a812-000d3a86dae1</BillToCustomerId>
<BillToCustomerNumber>C00040</BillToCustomerNumber>
<BillToCustomer>
<!-- See Customer XML for more details -->
</BillToCustomer>
<BillToName>Zynk Software</BillToName>
<BillToAddressLine1>Office 16</BillToAddressLine1>
<BillToAddressLine2>6 Charlotte Square</BillToAddressLine2>
<BillToCity>Newcastle Upon Tyne</BillToCity>
<BillToState>Tyne & Wear</BillToState>
<BillToPostCode>NE1 4XF</BillToPostCode>
<BillToCountry>GB</BillToCountry>
<PartialShipping>true</PartialShipping>
<FullyShipped>false</FullyShipped>
</SalesOrder>
</SalesOrders>
Miscellaneous
The following information is not visible within Dynamics 365 Business Central.
Dynamics Field | XML Field | Type | Input | Notes |
---|---|---|---|---|
- | ODataETag | string | Optional | Specify the last value to prevent updates if the record has since been modified |
- | LastModifiedDateTime | DateTime | Read-only |
<?xml version="1.0" encoding="utf-8"?>
<SalesOrders xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SalesOrder>
<ODataETag>W/"JzQ0O1paaDBYNnF4bnpodFhyVyt3U0ZtUDdzZEZ0c1U5Q2Nnc3I5bjZWbDM3Rzg9MTswMDsn"</ODataETag>
<LastModifiedDateTime>2020-03-11T16:29:50.49Z</LastModifiedDateTime>
</SalesOrder>
</SalesOrders>