Live integration - requests and responses

A Live Integration between Dynamicweb and a remote system makes it possible to retrieve data from a remote system, e.g. live prices and stock levels – or to have the remote system handle order, discount, and/or shipping fee calculations in real time.

All of these requests are handled by the Live Integration add-in, and they are presented here mainly to allow you to test and debug using the Dynamicweb Connector TestTool.

A basic feature of the Live Integration is the ability to request customer-specific prices from a remote system. Technically, this happens on pageload whenever a price is rendered and the Enable live prices checkbox is checked in the add-in.

Two parameters are used to request customer-specific prices – ExternalUserId and/or AccessUserCustomerNumber.

Parameter

Values

Required

Comments

ExternalUserId

An external id from the remote system

No

 

AccessUserCustomerNumber

A value from 

Yes

If user is anonymous, the value is set to the ERP Anonymous users key. This key must match a customer on the remote side.

       

Standard request:

XML
<GetEcomData ExternalUserId="E000010" AccessUserCustomerNumber="20000"> <tables> <Products type="filter" unitPrices="true"> <Product> <ProductId>1906-S</ProductId> <ProductVariantId></ProductVariantId> <ProductNumber>1900-S</ProductNumber> <ProductIdentifier>1900-S..LANG1</ProductIdentifier> <CurrencyCode>GBP</CurrencyCode> <Quantity>1</Quantity> </Product> </Products> </tables> </GetEcomData>

Standard response:

XML
<?xml version="1.0" encoding="utf-16"?> <tables version="1.2.0.6_NAV11.0.19394" url="http://dwis-nav2018:443/DynamicsNAV110/WS/CRONUS%20Danmark%20A%2FS/Codeunit/DWWebService"> <table tableName="EcomProducts"> <item table="EcomProducts"> <column columnName="ProductId"><![CDATA[1906-S]]></column> <column columnName="ProductVariantId"><![CDATA[]]></column> <column columnName="ProductIdentifier"><![CDATA[]]></column> <column columnName="ProductNumber"><![CDATA[1906-S]]></column> <column columnName="ProductName"><![CDATA[ATHEN Skuffemodul]]></column> <column columnName="ProductPrice"><![CDATA[1,800]]></column> <column columnName="ProductStock"><![CDATA[254]]></column> <column columnName="ProductCurrencyCode"><![CDATA[]]></column> <column columnName="ProductDefaultUnitId"><![CDATA[Unit_STK]]></column> </item> </table> <table tableName="EcomPrices"> <item table="EcomPrices"> <column columnName="PriceProductId"><![CDATA[1906-S]]></column> <column columnName="PriceUserCustomerNumber"><![CDATA[20000]]></column> <column columnName="PriceProductUnitId"><![CDATA[Unit_PAKKE]]></column> <column columnName="PriceQuantity"><![CDATA[2]]></column> <column columnName="PriceAmount"><![CDATA[1,600]]></column> </item> <item table="EcomPrices"> <column columnName="PriceProductId"><![CDATA[1906-S]]></column> <column columnName="PriceUserCustomerNumber"><![CDATA[20000]]></column> <column columnName="PriceProductUnitId"><![CDATA[Unit_PALLE]]></column> <column columnName="PriceQuantity"><![CDATA[6]]></column> <column columnName="PriceAmount"><![CDATA[1,200]]></column> </item> <item table="EcomPrices"> <column columnName="PriceProductId"><![CDATA[1906-S]]></column> <column columnName="PriceUserCustomerNumber"><![CDATA[20000]]></column> <column columnName="PriceProductUnitId"><![CDATA[Unit_STK]]></column> <column columnName="PriceQuantity"><![CDATA[1]]></column> <column columnName="PriceAmount"><![CDATA[1,800]]></column> </item> </table> </tables>

A customer statement PDF is a report of all entried in the customer’s account balance in NAV/Business Central. Basically, you submit a customerID, a start date and an end date to the remote system and revceive a pdf base64 string back which you must then handle on your end. This request is not implemented on any DW app by default but is made available for custom projects.

Parameter

Value

Required

Comments

customerID

A valid ‘customer no’ in NAV/BC

Yes

The ‘customer no’ value is typically imported to the standard DW customer number field.

startdate

YYYY-MM-DD

Yes

 

enddate

YYYY-MM-DD

Yes

 

Standard request:

XML
<GetCustomerStatementPDF customerID="20000" startDate="2009-12-30" endDate="2020-12-30"></GetCustomerStatementPDF>

Standard response:

This request returns a pdf base64 string response - if using the TestTool, the response is automatically opened in a pdf-viewer.

Standard request:

XML
<?xml version="1.0" encoding="utf-8" standalone="yes"?> <tables source="LiveIntegration" submitType="LiveOrderOrCart" referenceName="OrdersPut"> <table tableName="EcomOrders"> <item table="EcomOrders"> <column columnName="OrderCustomerAccessUserExternalId">E000010</column> <column columnName="OrderCustomerNumber">20000</column> <column columnName="OrderCustomerName"/> <column columnName="OrderCustomerAddress">Parkvej 44</column> <column columnName="OrderCustomerAddress2"/> <column columnName="OrderCustomerCity">Atlanta</column> <column columnName="OrderCustomerState"/> <column columnName="OrderCustomerZip">4300</column> <column columnName="OrderCustomerCountryCode">DK</column> <column columnName="OrderCustomerEmail">ravel.mobler@contoso.com</column> <column columnName="OrderCustomerPhone"/> <column columnName="OrderCustomerFax"/> <column columnName="OrderCustomerCompany">Ravel Møbler</column> <column columnName="OrderCustomerComment"/> <column columnName="OrderCustomerFirstName"/> <column columnName="OrderCustomerSurname"/> <column columnName="OrderDeliveryName"/> <column columnName="OrderDeliveryAddress"/> <column columnName="OrderDeliveryAddress2"/> <column columnName="OrderDeliveryCity"/> <column columnName="OrderDeliveryState"/> <column columnName="OrderDeliveryZip"/> <column columnName="OrderDeliveryCountryCode">DZ</column> <column columnName="OrderDeliveryEmail"/> <column columnName="OrderDeliveryPhone"/> <column columnName="OrderDeliveryFax"/> <column columnName="OrderDeliveryCompany"/> <column columnName="CreateOrder">True</column> <column columnName="OrderId">ORDER678</column> <column columnName="OrderAutoId">3256</column> <column columnName="OrderIntegrationOrderId"/> <column columnName="OrderCurrencyCode">EUR</column> <column columnName="OrderDate">2020-01-02T11:04:33</column> <column columnName="OrderPaymentMethodName" isInformationalOnly="True">invoice</column> <column columnName="OrderPaymentMethodId">PAY9</column> <column columnName="OrderShippingMethodName" isInformationalOnly="True">ship1</column> <column columnName="OrderShippingMethodId">SHIP16</column> <column columnName="OrderShippingFee">12.5</column> <column columnName="OrderShippingFeeWithoutVat">10</column> <column columnName="OrderShippingItemKey">DW-SHIP</column> <column columnName="OrderPriceTotal">826.18</column> <column columnName="OrderCaptureAmount">0</column> <column columnName="OrderVoucherCode"/> <column columnName="OrderTransactionId"/> <column columnName="OrderStateId">OS1</column> <column columnName="OrderStateName" isInformationalOnly="True"/> <column columnName="ErpControlsDiscount">False</column> </item> </table> <table tableName="EcomOrderLines"> <item table="EcomOrderLines"> <column columnName="OrderLineId">OL40399</column> <column columnName="OrderLineOrderId">ORDER678</column> <column columnName="OrderLineParentLineId"/> <column columnName="OrderLineProductId">1920-S</column> <column columnName="OrderLineProductVariantId"/> <column columnName="OrderLineProductNumber">1920-S</column> <column columnName="OrderLineProductName">ANTWERP Conference Table</column> <column columnName="OrderLineProductIdentifier">1920-S..ENU</column> <column columnName="OrderLineQuantity">1</column> <column columnName="OrderLineUnitId"/> <column columnName="OrderLinePriceWithoutVat">650.94</column> <column columnName="OrderLineUnitPriceWithoutVat">650.94</column> <column columnName="NetPrice">3599</column> <column columnName="OrderLineType">2</column> <column columnName="OrderLineTypeName">Fixed</column> <column columnName="OrderLineBom">False</column> <column columnName="OrderLineBomItemId"/> <column columnName="OrderLineGiftCardCode"/> <column columnName="OrderLineIsGiftCardDiscount" isCustomField="True">False</column> <column columnName="OrderLineFieldValues">&lt;OrderLineFieldValueCollection /&gt;</column> </item> </table> <table tableName="EcomOrderLineFields"/> </tables>

Standard response:

XML
<?xml version="1.0" encoding="utf-16"?> <tables version="1.2.0.6_NAV11.0.19394" url="http://dwis-nav2018:443/DynamicsNAV110/WS/CRONUS%20Danmark%20A%2FS/Codeunit/DWWebService"> <table tableName="EcomOrderLines"> <item table="EcomOrderLines"> <column columnName="OrderLineProductNumber"><![CDATA[1920-S]]></column> <column columnName="OrderLineProductVariantId"><![CDATA[]]></column> <column columnName="OrderLineUnitId"><![CDATA[Unit_STK]]></column> <column columnName="OrderLineId"><![CDATA[10000]]></column> <column columnName="OrderLineQuantity"><![CDATA[1]]></column> <column columnName="OrderLineType"><![CDATA[0]]></column> <column columnName="OrderLinePriceWithoutVat"><![CDATA[650.94]]></column> <column columnName="OrderLineUnitPriceWithoutVat"><![CDATA[650.943]]></column> <column columnName="OrderLinePriceWithVat"><![CDATA[813.68]]></column> <column columnName="OrderLineUnitPriceWithVat"><![CDATA[813.68]]></column> <column columnName="OrderLinePriceVat"><![CDATA[162.74]]></column> <column columnName="OrderLineUnitPriceVat"><![CDATA[162.74]]></column> <column columnName="OrderLinePriceVatPercent"><![CDATA[25]]></column> <column columnName="OrderLineUnitPriceVatPercent"><![CDATA[25]]></column> </item> </table> <table tableName="EcomOrders"> <item table="EcomOrders"> <column columnName="OrderShippingMethodName"><![CDATA[ship1]]></column> <column columnName="OrderShippingMethodId"><![CDATA[SHIP16]]></column> <column columnName="OrderShippingFee"><![CDATA[12.5]]></column> <column columnName="OrderCreated"><![CDATA[TRUE]]></column> <column columnName="OrderId"><![CDATA[1345]]></column> <column columnName="OrderCurrencyCode"><![CDATA[EUR]]></column> <column columnName="OrderDate"><![CDATA[02/13/20]]></column> <column columnName="OrderPaymentMethodName"><![CDATA[]]></column> <column columnName="OrderCustomerName"><![CDATA[Ravel Møbler]]></column> <column columnName="OrderCustomerAddress"><![CDATA[Parkvej 44]]></column> <column columnName="OrderCustomerAddress2"><![CDATA[]]></column> <column columnName="OrderCustomerCity"><![CDATA[Atlanta]]></column> <column columnName="OrderCustomerCountryCode"><![CDATA[DK]]></column> <column columnName="OrderCustomerEmail"><![CDATA[]]></column> <column columnName="OrderCustomerFax"><![CDATA[]]></column> <column columnName="OrderCustomerPhone"><![CDATA[]]></column> <column columnName="OrderCustomerZip"><![CDATA[]]></column> <column columnName="OrderDeliveryName"><![CDATA[]]></column> <column columnName="OrderDeliveryAddress"><![CDATA[]]></column> <column columnName="OrderDeliveryAddress2"><![CDATA[]]></column> <column columnName="OrderDeliveryCity"><![CDATA[]]></column> <column columnName="OrderDeliveryCountryCode"><![CDATA[DK]]></column> <column columnName="OrderDeliveryEmail"><![CDATA[]]></column> <column columnName="OrderDeliveryFax"><![CDATA[]]></column> <column columnName="OrderDeliveryPhone"><![CDATA[]]></column> <column columnName="OrderDeliveryZip"><![CDATA[]]></column> <column columnName="OrderPriceWithVat"><![CDATA[826.18]]></column> <column columnName="OrderPriceWithoutVat"><![CDATA[660.94]]></column> <column columnName="OrderPriceVat"><![CDATA[162.74]]></column> <column columnName="OrderSalesDiscount"><![CDATA[0]]></column> </item> </table> </tables>

The GetList request is used to retrieve lists of various documents from the remote system – orders, invoices, and credit memos. These requests are transmitted to the remote system by the integration customer center. There are four parameters – they are:

Parameter

Value

Required

Comment

type

Credit
Invoice
OpenOrder

Yes

In principle, the type parameter can take any custom value, in order to expose data from another table than the three standard types. This does however require an ERP developer to specify the XML reponse readable in Dynamicweb.

customerID

A valid ‘customer no’ in NAV/BC

Yes

The ‘customer no’ value is typically imported to the standard DW customer number field.

requestAmount

An integer

No

Used to control how many list items are returned per request.

firstItem

An integer

No

Used to control which list item is the first item in the current batch of list items.

Standard requests:

XML
<GetList type="Credit" customerID="20000"></GetList> <GetList type="Invoice" customerID="20000"></GetList> <GetList type="OpenOrder" customerID="20000"></GetList> <!--Paging--> <GetList type="OpenOrder" customerID="20000" requestAmount="1" firstItem="1"></GetList>

Standard responses:

XML
<!--Credit memos--> <?xml version="1.0" encoding="utf-16"?> <Items type="Credit" version="1.2.0.6_NAV11.0.19394" url="http://dwis-nav2018:443/DynamicsNAV110/WS/CRONUS%20Danmark%20A%2FS/Codeunit/DWWebService"> <item> <column columnName="id"><![CDATA[104002]]></column> <column columnName="orderDate"><![CDATA[2019/01/15]]></column> <column columnName="shipDate"><![CDATA[2019/01/15]]></column> <column columnName="dueDate"><![CDATA[2019/01/15]]></column> <column columnName="postingDate"><![CDATA[2019/01/15]]></column> <column columnName="documentDate"><![CDATA[2019/01/15]]></column> <column columnName="totalAmount"><![CDATA[5,393.20]]></column> <column columnName="totalAmountIncVat"><![CDATA[6,741.50]]></column> </item> <item> <column columnName="id"><![CDATA[104003]]></column> <column columnName="orderDate"><![CDATA[2019/01/18]]></column> <column columnName="shipDate"><![CDATA[2019/01/18]]></column> <column columnName="dueDate"><![CDATA[2019/01/18]]></column> <column columnName="postingDate"><![CDATA[2019/01/18]]></column> <column columnName="documentDate"><![CDATA[2019/01/18]]></column> <column columnName="totalAmount"><![CDATA[7,845.36]]></column> <column columnName="totalAmountIncVat"><![CDATA[9,806.70]]></column> </item> </Items> <!-- Invoices --> <?xml version="1.0" encoding="utf-16"?> <Items type="Invoice" version="1.2.0.6_NAV11.0.19394" url="http://dwis-nav2018:443/DynamicsNAV110/WS/CRONUS%20Danmark%20A%2FS/Codeunit/DWWebService"> <item> <column columnName="id"><![CDATA[103002]]></column> <column columnName="orderDate"><![CDATA[2019/01/21]]></column> <column columnName="shipDate"><![CDATA[2019/01/21]]></column> <column columnName="dueDate"><![CDATA[2019/02/04]]></column> <column columnName="postingDate"><![CDATA[2019/01/21]]></column> <column columnName="documentDate"><![CDATA[2019/01/21]]></column> <column columnName="totalAmount"><![CDATA[53,990.20]]></column> <column columnName="totalAmountIncVat"><![CDATA[67,487.75]]></column> </item> <item> <column columnName="id"><![CDATA[103018]]></column> <column columnName="orderDate"><![CDATA[2019/01/09]]></column> <column columnName="shipDate"><![CDATA[2019/01/09]]></column> <column columnName="dueDate"><![CDATA[2019/01/23]]></column> <column columnName="postingDate"><![CDATA[2019/01/13]]></column> <column columnName="documentDate"><![CDATA[2019/01/09]]></column> <column columnName="totalAmount"><![CDATA[5,393.20]]></column> <column columnName="totalAmountIncVat"><![CDATA[6,741.50]]></column> </item> <item> <column columnName="id"><![CDATA[103019]]></column> <column columnName="orderDate"><![CDATA[2019/01/13]]></column> <column columnName="shipDate"><![CDATA[2019/01/13]]></column> <column columnName="dueDate"><![CDATA[2019/01/27]]></column> <column columnName="postingDate"><![CDATA[2019/01/15]]></column> <column columnName="documentDate"><![CDATA[2019/01/13]]></column> <column columnName="totalAmount"><![CDATA[1,479.25]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,849.06]]></column> </item> <item> <column columnName="id"><![CDATA[103024]]></column> <column columnName="orderDate"><![CDATA[2019/01/14]]></column> <column columnName="shipDate"><![CDATA[2019/01/14]]></column> <column columnName="dueDate"><![CDATA[2019/01/28]]></column> <column columnName="postingDate"><![CDATA[2019/01/21]]></column> <column columnName="documentDate"><![CDATA[2019/01/14]]></column> <column columnName="totalAmount"><![CDATA[7,845.36]]></column> <column columnName="totalAmountIncVat"><![CDATA[9,806.70]]></column> </item> <item> <column columnName="id"><![CDATA[103032]]></column> <column columnName="orderDate"><![CDATA[2019/07/03]]></column> <column columnName="shipDate"><![CDATA[2019/07/03]]></column> <column columnName="dueDate"><![CDATA[2019/07/17]]></column> <column columnName="postingDate"><![CDATA[2019/07/03]]></column> <column columnName="documentDate"><![CDATA[2019/07/03]]></column> <column columnName="totalAmount"><![CDATA[540.23]]></column> <column columnName="totalAmountIncVat"><![CDATA[675.29]]></column> </item> <item> <column columnName="id"><![CDATA[103035]]></column> <column columnName="orderDate"><![CDATA[2019/07/03]]></column> <column columnName="shipDate"><![CDATA[2019/07/03]]></column> <column columnName="dueDate"><![CDATA[2019/07/17]]></column> <column columnName="postingDate"><![CDATA[2019/07/03]]></column> <column columnName="documentDate"><![CDATA[2019/07/03]]></column> <column columnName="totalAmount"><![CDATA[3,609.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[4,511.25]]></column> </item> <item> <column columnName="id"><![CDATA[103039]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[650.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[813.68]]></column> </item> <item> <column columnName="id"><![CDATA[103044]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[103045]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[103047]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[103048]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[103049]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[103050]]></column> <column columnName="orderDate"><![CDATA[2019/12/20]]></column> <column columnName="shipDate"><![CDATA[2019/12/20]]></column> <column columnName="dueDate"><![CDATA[2020/01/03]]></column> <column columnName="postingDate"><![CDATA[2019/12/20]]></column> <column columnName="documentDate"><![CDATA[2019/12/20]]></column> <column columnName="totalAmount"><![CDATA[1,666.57]]></column> <column columnName="totalAmountIncVat"><![CDATA[2,083.21]]></column> </item> <item> <column columnName="id"><![CDATA[103051]]></column> <column columnName="orderDate"><![CDATA[2020/01/02]]></column> <column columnName="shipDate"><![CDATA[2020/01/02]]></column> <column columnName="dueDate"><![CDATA[2020/01/16]]></column> <column columnName="postingDate"><![CDATA[2020/01/02]]></column> <column columnName="documentDate"><![CDATA[2020/01/02]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> </Items> <!--Open Orders --> <?xml version="1.0" encoding="utf-16"?> <Items type="OpenOrder" version="1.2.0.6_NAV11.0.19394" url="http://dwis-nav2018:443/DynamicsNAV110/WS/CRONUS%20Danmark%20A%2FS/Codeunit/DWWebService"> <item> <column columnName="id"><![CDATA[101017]]></column> <column columnName="orderDate"><![CDATA[2019/01/25]]></column> <column columnName="shipDate"><![CDATA[2019/01/25]]></column> <column columnName="dueDate"><![CDATA[2019/02/08]]></column> <column columnName="postingDate"><![CDATA[2019/01/25]]></column> <column columnName="documentDate"><![CDATA[2019/01/25]]></column> <column columnName="totalAmount"><![CDATA[9,495.90]]></column> <column columnName="totalAmountIncVat"><![CDATA[11,869.88]]></column> </item> <item> <column columnName="id"><![CDATA[1012]]></column> <column columnName="orderDate"><![CDATA[2019/01/21]]></column> <column columnName="shipDate"><![CDATA[2019/01/21]]></column> <column columnName="dueDate"><![CDATA[2019/02/04]]></column> <column columnName="postingDate"><![CDATA[2019/01/21]]></column> <column columnName="documentDate"><![CDATA[2019/01/21]]></column> <column columnName="totalAmount"><![CDATA[-100.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[-56.59]]></column> </item> <item> <column columnName="id"><![CDATA[1014]]></column> <column columnName="orderDate"><![CDATA[2019/01/24]]></column> <column columnName="shipDate"><![CDATA[2019/01/24]]></column> <column columnName="dueDate"><![CDATA[2019/02/07]]></column> <column columnName="postingDate"><![CDATA[2019/01/24]]></column> <column columnName="documentDate"><![CDATA[2019/01/24]]></column> <column columnName="totalAmount"><![CDATA[31.93]]></column> <column columnName="totalAmountIncVat"><![CDATA[39.91]]></column> </item> <item> <column columnName="id"><![CDATA[1015]]></column> <column columnName="orderDate"><![CDATA[2019/01/21]]></column> <column columnName="shipDate"><![CDATA[2019/01/21]]></column> <column columnName="dueDate"><![CDATA[2019/02/04]]></column> <column columnName="postingDate"><![CDATA[2019/01/21]]></column> <column columnName="documentDate"><![CDATA[2019/01/21]]></column> <column columnName="totalAmount"><![CDATA[30.92]]></column> <column columnName="totalAmountIncVat"><![CDATA[38.65]]></column> </item> <item> <column columnName="id"><![CDATA[1016]]></column> <column columnName="orderDate"><![CDATA[2019/01/28]]></column> <column columnName="shipDate"><![CDATA[2019/01/28]]></column> <column columnName="dueDate"><![CDATA[2019/02/11]]></column> <column columnName="postingDate"><![CDATA[2019/01/28]]></column> <column columnName="documentDate"><![CDATA[2019/01/28]]></column> <column columnName="totalAmount"><![CDATA[32.55]]></column> <column columnName="totalAmountIncVat"><![CDATA[40.69]]></column> </item> <item> <column columnName="id"><![CDATA[1017]]></column> <column columnName="orderDate"><![CDATA[2019/01/28]]></column> <column columnName="shipDate"><![CDATA[2019/01/28]]></column> <column columnName="dueDate"><![CDATA[2019/02/11]]></column> <column columnName="postingDate"><![CDATA[2019/01/28]]></column> <column columnName="documentDate"><![CDATA[2019/01/28]]></column> <column columnName="totalAmount"><![CDATA[1,054.46]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,318.08]]></column> </item> <item> <column columnName="id"><![CDATA[1018]]></column> <column columnName="orderDate"><![CDATA[2019/01/28]]></column> <column columnName="shipDate"><![CDATA[2019/01/28]]></column> <column columnName="dueDate"><![CDATA[2019/02/11]]></column> <column columnName="postingDate"><![CDATA[2019/01/28]]></column> <column columnName="documentDate"><![CDATA[2019/01/28]]></column> <column columnName="totalAmount"><![CDATA[32.55]]></column> <column columnName="totalAmountIncVat"><![CDATA[40.69]]></column> </item> <item> <column columnName="id"><![CDATA[1019]]></column> <column columnName="orderDate"><![CDATA[2019/02/20]]></column> <column columnName="shipDate"><![CDATA[2019/02/20]]></column> <column columnName="dueDate"><![CDATA[2019/03/06]]></column> <column columnName="postingDate"><![CDATA[2019/02/20]]></column> <column columnName="documentDate"><![CDATA[2019/02/20]]></column> <column columnName="totalAmount"><![CDATA[263.53]]></column> <column columnName="totalAmountIncVat"><![CDATA[329.41]]></column> </item> <item> <column columnName="id"><![CDATA[1022]]></column> <column columnName="orderDate"><![CDATA[2019/02/20]]></column> <column columnName="shipDate"><![CDATA[2019/02/20]]></column> <column columnName="dueDate"><![CDATA[2019/03/06]]></column> <column columnName="postingDate"><![CDATA[2019/02/20]]></column> <column columnName="documentDate"><![CDATA[2019/02/20]]></column> <column columnName="totalAmount"><![CDATA[2,011.25]]></column> <column columnName="totalAmountIncVat"><![CDATA[2,514.06]]></column> </item> <item> <column columnName="id"><![CDATA[1030]]></column> <column columnName="orderDate"><![CDATA[2019/02/21]]></column> <column columnName="shipDate"><![CDATA[2019/02/21]]></column> <column columnName="dueDate"><![CDATA[2019/03/07]]></column> <column columnName="postingDate"><![CDATA[2019/02/21]]></column> <column columnName="documentDate"><![CDATA[2019/02/21]]></column> <column columnName="totalAmount"><![CDATA[3,057.58]]></column> <column columnName="totalAmountIncVat"><![CDATA[3,821.98]]></column> </item> <item> <column columnName="id"><![CDATA[1032]]></column> <column columnName="orderDate"><![CDATA[2019/03/11]]></column> <column columnName="shipDate"><![CDATA[2019/03/11]]></column> <column columnName="dueDate"><![CDATA[2019/03/25]]></column> <column columnName="postingDate"><![CDATA[2019/03/11]]></column> <column columnName="documentDate"><![CDATA[2019/03/11]]></column> <column columnName="totalAmount"><![CDATA[18.09]]></column> <column columnName="totalAmountIncVat"><![CDATA[22.61]]></column> </item> <item> <column columnName="id"><![CDATA[1033]]></column> <column columnName="orderDate"><![CDATA[2019/03/12]]></column> <column columnName="shipDate"><![CDATA[2019/03/12]]></column> <column columnName="dueDate"><![CDATA[2019/03/26]]></column> <column columnName="postingDate"><![CDATA[2019/03/12]]></column> <column columnName="documentDate"><![CDATA[2019/03/12]]></column> <column columnName="totalAmount"><![CDATA[40.70]]></column> <column columnName="totalAmountIncVat"><![CDATA[50.88]]></column> </item> <item> <column columnName="id"><![CDATA[1037]]></column> <column columnName="orderDate"><![CDATA[2019/05/28]]></column> <column columnName="shipDate"><![CDATA[2019/05/28]]></column> <column columnName="dueDate"><![CDATA[2019/06/11]]></column> <column columnName="postingDate"><![CDATA[2019/05/28]]></column> <column columnName="documentDate"><![CDATA[2019/05/28]]></column> <column columnName="totalAmount"><![CDATA[193.71]]></column> <column columnName="totalAmountIncVat"><![CDATA[242.14]]></column> </item> <item> <column columnName="id"><![CDATA[104002]]></column> <column columnName="orderDate"><![CDATA[2019/01/16]]></column> <column columnName="shipDate"><![CDATA[2019/01/16]]></column> <column columnName="dueDate"><![CDATA[2019/01/30]]></column> <column columnName="postingDate"><![CDATA[2019/01/16]]></column> <column columnName="documentDate"><![CDATA[2019/01/16]]></column> <column columnName="totalAmount"><![CDATA[2,498.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[3,122.50]]></column> </item> <item> <column columnName="id"><![CDATA[104007]]></column> <column columnName="orderDate"><![CDATA[2019/01/16]]></column> <column columnName="shipDate"><![CDATA[2019/01/16]]></column> <column columnName="dueDate"><![CDATA[2019/01/30]]></column> <column columnName="postingDate"><![CDATA[2019/01/16]]></column> <column columnName="documentDate"><![CDATA[2019/01/16]]></column> <column columnName="totalAmount"><![CDATA[2,632.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[3,290.00]]></column> </item> <item> <column columnName="id"><![CDATA[104012]]></column> <column columnName="orderDate"><![CDATA[2019/01/16]]></column> <column columnName="shipDate"><![CDATA[2019/01/16]]></column> <column columnName="dueDate"><![CDATA[2019/01/30]]></column> <column columnName="postingDate"><![CDATA[2019/01/16]]></column> <column columnName="documentDate"><![CDATA[2019/01/16]]></column> <column columnName="totalAmount"><![CDATA[1,242.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,552.50]]></column> </item> <item> <column columnName="id"><![CDATA[1053]]></column> <column columnName="orderDate"><![CDATA[2019/05/29]]></column> <column columnName="shipDate"><![CDATA[2019/05/29]]></column> <column columnName="dueDate"><![CDATA[2019/06/12]]></column> <column columnName="postingDate"><![CDATA[2019/05/29]]></column> <column columnName="documentDate"><![CDATA[2019/05/29]]></column> <column columnName="totalAmount"><![CDATA[542.60]]></column> <column columnName="totalAmountIncVat"><![CDATA[678.25]]></column> </item> <item> <column columnName="id"><![CDATA[1054]]></column> <column columnName="orderDate"><![CDATA[2019/05/29]]></column> <column columnName="shipDate"><![CDATA[2019/05/29]]></column> <column columnName="dueDate"><![CDATA[2019/06/12]]></column> <column columnName="postingDate"><![CDATA[2019/05/29]]></column> <column columnName="documentDate"><![CDATA[2019/05/29]]></column> <column columnName="totalAmount"><![CDATA[145.28]]></column> <column columnName="totalAmountIncVat"><![CDATA[181.60]]></column> </item> <item> <column columnName="id"><![CDATA[1055]]></column> <column columnName="orderDate"><![CDATA[2019/05/29]]></column> <column columnName="shipDate"><![CDATA[2019/05/29]]></column> <column columnName="dueDate"><![CDATA[2019/06/12]]></column> <column columnName="postingDate"><![CDATA[2019/05/29]]></column> <column columnName="documentDate"><![CDATA[2019/05/29]]></column> <column columnName="totalAmount"><![CDATA[96.85]]></column> <column columnName="totalAmountIncVat"><![CDATA[121.06]]></column> </item> <item> <column columnName="id"><![CDATA[1057]]></column> <column columnName="orderDate"><![CDATA[2019/05/29]]></column> <column columnName="shipDate"><![CDATA[2019/05/29]]></column> <column columnName="dueDate"><![CDATA[2019/06/12]]></column> <column columnName="postingDate"><![CDATA[2019/05/29]]></column> <column columnName="documentDate"><![CDATA[2019/05/29]]></column> <column columnName="totalAmount"><![CDATA[96.86]]></column> <column columnName="totalAmountIncVat"><![CDATA[121.08]]></column> </item> <item> <column columnName="id"><![CDATA[1058]]></column> <column columnName="orderDate"><![CDATA[2019/05/29]]></column> <column columnName="shipDate"><![CDATA[2019/05/29]]></column> <column columnName="dueDate"><![CDATA[2019/06/12]]></column> <column columnName="postingDate"><![CDATA[2019/05/29]]></column> <column columnName="documentDate"><![CDATA[2019/05/29]]></column> <column columnName="totalAmount"><![CDATA[-290.55]]></column> <column columnName="totalAmountIncVat"><![CDATA[-363.19]]></column> </item> <item> <column columnName="id"><![CDATA[1059]]></column> <column columnName="orderDate"><![CDATA[2019/05/29]]></column> <column columnName="shipDate"><![CDATA[2019/05/29]]></column> <column columnName="dueDate"><![CDATA[2019/06/12]]></column> <column columnName="postingDate"><![CDATA[2019/05/29]]></column> <column columnName="documentDate"><![CDATA[2019/05/29]]></column> <column columnName="totalAmount"><![CDATA[290.56]]></column> <column columnName="totalAmountIncVat"><![CDATA[363.20]]></column> </item> <item> <column columnName="id"><![CDATA[1060]]></column> <column columnName="orderDate"><![CDATA[2019/05/30]]></column> <column columnName="shipDate"><![CDATA[2019/05/30]]></column> <column columnName="dueDate"><![CDATA[2019/06/13]]></column> <column columnName="postingDate"><![CDATA[2019/05/30]]></column> <column columnName="documentDate"><![CDATA[2019/05/30]]></column> <column columnName="totalAmount"><![CDATA[1,085.20]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,356.50]]></column> </item> <item> <column columnName="id"><![CDATA[1061]]></column> <column columnName="orderDate"><![CDATA[2019/05/30]]></column> <column columnName="shipDate"><![CDATA[2019/05/30]]></column> <column columnName="dueDate"><![CDATA[2019/06/13]]></column> <column columnName="postingDate"><![CDATA[2019/05/30]]></column> <column columnName="documentDate"><![CDATA[2019/05/30]]></column> <column columnName="totalAmount"><![CDATA[803.25]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,004.06]]></column> </item> <item> <column columnName="id"><![CDATA[1062]]></column> <column columnName="orderDate"><![CDATA[2019/05/30]]></column> <column columnName="shipDate"><![CDATA[2019/05/30]]></column> <column columnName="dueDate"><![CDATA[2019/06/13]]></column> <column columnName="postingDate"><![CDATA[2019/05/30]]></column> <column columnName="documentDate"><![CDATA[2019/05/30]]></column> <column columnName="totalAmount"><![CDATA[1,085.20]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,356.50]]></column> </item> <item> <column columnName="id"><![CDATA[1063]]></column> <column columnName="orderDate"><![CDATA[2019/05/30]]></column> <column columnName="shipDate"><![CDATA[2019/05/30]]></column> <column columnName="dueDate"><![CDATA[2019/06/13]]></column> <column columnName="postingDate"><![CDATA[2019/05/30]]></column> <column columnName="documentDate"><![CDATA[2019/05/30]]></column> <column columnName="totalAmount"><![CDATA[1,085.20]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,356.50]]></column> </item> <item> <column columnName="id"><![CDATA[1064]]></column> <column columnName="orderDate"><![CDATA[2019/05/30]]></column> <column columnName="shipDate"><![CDATA[2019/05/30]]></column> <column columnName="dueDate"><![CDATA[2019/06/13]]></column> <column columnName="postingDate"><![CDATA[2019/05/30]]></column> <column columnName="documentDate"><![CDATA[2019/05/30]]></column> <column columnName="totalAmount"><![CDATA[701.77]]></column> <column columnName="totalAmountIncVat"><![CDATA[877.21]]></column> </item> <item> <column columnName="id"><![CDATA[1065]]></column> <column columnName="orderDate"><![CDATA[2019/05/30]]></column> <column columnName="shipDate"><![CDATA[2019/05/30]]></column> <column columnName="dueDate"><![CDATA[2019/06/13]]></column> <column columnName="postingDate"><![CDATA[2019/05/30]]></column> <column columnName="documentDate"><![CDATA[2019/05/30]]></column> <column columnName="totalAmount"><![CDATA[1,066.42]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,333.03]]></column> </item> <item> <column columnName="id"><![CDATA[1066]]></column> <column columnName="orderDate"><![CDATA[2019/05/30]]></column> <column columnName="shipDate"><![CDATA[2019/05/30]]></column> <column columnName="dueDate"><![CDATA[2019/06/13]]></column> <column columnName="postingDate"><![CDATA[2019/05/30]]></column> <column columnName="documentDate"><![CDATA[2019/05/30]]></column> <column columnName="totalAmount"><![CDATA[1,230.48]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,538.10]]></column> </item> <item> <column columnName="id"><![CDATA[1067]]></column> <column columnName="orderDate"><![CDATA[2019/05/30]]></column> <column columnName="shipDate"><![CDATA[2019/05/30]]></column> <column columnName="dueDate"><![CDATA[2019/06/13]]></column> <column columnName="postingDate"><![CDATA[2019/05/30]]></column> <column columnName="documentDate"><![CDATA[2019/05/30]]></column> <column columnName="totalAmount"><![CDATA[1,230.48]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,538.10]]></column> </item> <item> <column columnName="id"><![CDATA[1068]]></column> <column columnName="orderDate"><![CDATA[2019/05/30]]></column> <column columnName="shipDate"><![CDATA[2019/05/30]]></column> <column columnName="dueDate"><![CDATA[2019/06/13]]></column> <column columnName="postingDate"><![CDATA[2019/05/30]]></column> <column columnName="documentDate"><![CDATA[2019/05/30]]></column> <column columnName="totalAmount"><![CDATA[1,066.42]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,333.03]]></column> </item> <item> <column columnName="id"><![CDATA[1069]]></column> <column columnName="orderDate"><![CDATA[2019/05/30]]></column> <column columnName="shipDate"><![CDATA[2019/05/30]]></column> <column columnName="dueDate"><![CDATA[2019/06/13]]></column> <column columnName="postingDate"><![CDATA[2019/05/30]]></column> <column columnName="documentDate"><![CDATA[2019/05/30]]></column> <column columnName="totalAmount"><![CDATA[701.77]]></column> <column columnName="totalAmountIncVat"><![CDATA[877.21]]></column> </item> <item> <column columnName="id"><![CDATA[1071]]></column> <column columnName="orderDate"><![CDATA[2019/05/30]]></column> <column columnName="shipDate"><![CDATA[2019/05/30]]></column> <column columnName="dueDate"><![CDATA[2019/06/13]]></column> <column columnName="postingDate"><![CDATA[2019/05/30]]></column> <column columnName="documentDate"><![CDATA[2019/05/30]]></column> <column columnName="totalAmount"><![CDATA[1,066.42]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,333.03]]></column> </item> <item> <column columnName="id"><![CDATA[1072]]></column> <column columnName="orderDate"><![CDATA[2019/05/30]]></column> <column columnName="shipDate"><![CDATA[2019/05/30]]></column> <column columnName="dueDate"><![CDATA[2019/06/13]]></column> <column columnName="postingDate"><![CDATA[2019/05/30]]></column> <column columnName="documentDate"><![CDATA[2019/05/30]]></column> <column columnName="totalAmount"><![CDATA[532.56]]></column> <column columnName="totalAmountIncVat"><![CDATA[665.70]]></column> </item> <item> <column columnName="id"><![CDATA[1073]]></column> <column columnName="orderDate"><![CDATA[2019/05/30]]></column> <column columnName="shipDate"><![CDATA[2019/05/30]]></column> <column columnName="dueDate"><![CDATA[2019/06/13]]></column> <column columnName="postingDate"><![CDATA[2019/05/30]]></column> <column columnName="documentDate"><![CDATA[2019/05/30]]></column> <column columnName="totalAmount"><![CDATA[596.17]]></column> <column columnName="totalAmountIncVat"><![CDATA[745.21]]></column> </item> <item> <column columnName="id"><![CDATA[1074]]></column> <column columnName="orderDate"><![CDATA[2019/05/30]]></column> <column columnName="shipDate"><![CDATA[2019/05/30]]></column> <column columnName="dueDate"><![CDATA[2019/06/13]]></column> <column columnName="postingDate"><![CDATA[2019/05/30]]></column> <column columnName="documentDate"><![CDATA[2019/05/30]]></column> <column columnName="totalAmount"><![CDATA[532.62]]></column> <column columnName="totalAmountIncVat"><![CDATA[665.78]]></column> </item> <item> <column columnName="id"><![CDATA[1077]]></column> <column columnName="orderDate"><![CDATA[2019/06/03]]></column> <column columnName="shipDate"><![CDATA[2019/06/03]]></column> <column columnName="dueDate"><![CDATA[2019/06/17]]></column> <column columnName="postingDate"><![CDATA[2019/06/03]]></column> <column columnName="documentDate"><![CDATA[2019/06/03]]></column> <column columnName="totalAmount"><![CDATA[95.50]]></column> <column columnName="totalAmountIncVat"><![CDATA[119.38]]></column> </item> <item> <column columnName="id"><![CDATA[1078]]></column> <column columnName="orderDate"><![CDATA[2019/06/05]]></column> <column columnName="shipDate"><![CDATA[2019/06/05]]></column> <column columnName="dueDate"><![CDATA[2019/06/19]]></column> <column columnName="postingDate"><![CDATA[2019/06/05]]></column> <column columnName="documentDate"><![CDATA[2019/06/05]]></column> <column columnName="totalAmount"><![CDATA[133.70]]></column> <column columnName="totalAmountIncVat"><![CDATA[167.13]]></column> </item> <item> <column columnName="id"><![CDATA[1079]]></column> <column columnName="orderDate"><![CDATA[2019/06/05]]></column> <column columnName="shipDate"><![CDATA[2019/06/05]]></column> <column columnName="dueDate"><![CDATA[2019/06/19]]></column> <column columnName="postingDate"><![CDATA[2019/06/05]]></column> <column columnName="documentDate"><![CDATA[2019/06/05]]></column> <column columnName="totalAmount"><![CDATA[305.59]]></column> <column columnName="totalAmountIncVat"><![CDATA[381.99]]></column> </item> <item> <column columnName="id"><![CDATA[1080]]></column> <column columnName="orderDate"><![CDATA[2019/06/05]]></column> <column columnName="shipDate"><![CDATA[2019/06/05]]></column> <column columnName="dueDate"><![CDATA[2019/06/19]]></column> <column columnName="postingDate"><![CDATA[2019/06/05]]></column> <column columnName="documentDate"><![CDATA[2019/06/05]]></column> <column columnName="totalAmount"><![CDATA[133.70]]></column> <column columnName="totalAmountIncVat"><![CDATA[167.13]]></column> </item> <item> <column columnName="id"><![CDATA[1081]]></column> <column columnName="orderDate"><![CDATA[2019/06/06]]></column> <column columnName="shipDate"><![CDATA[2019/06/06]]></column> <column columnName="dueDate"><![CDATA[2019/06/20]]></column> <column columnName="postingDate"><![CDATA[2019/06/06]]></column> <column columnName="documentDate"><![CDATA[2019/06/06]]></column> <column columnName="totalAmount"><![CDATA[267.39]]></column> <column columnName="totalAmountIncVat"><![CDATA[334.24]]></column> </item> <item> <column columnName="id"><![CDATA[1082]]></column> <column columnName="orderDate"><![CDATA[2019/06/06]]></column> <column columnName="shipDate"><![CDATA[2019/06/06]]></column> <column columnName="dueDate"><![CDATA[2019/06/20]]></column> <column columnName="postingDate"><![CDATA[2019/06/06]]></column> <column columnName="documentDate"><![CDATA[2019/06/06]]></column> <column columnName="totalAmount"><![CDATA[40.70]]></column> <column columnName="totalAmountIncVat"><![CDATA[50.88]]></column> </item> <item> <column columnName="id"><![CDATA[1083]]></column> <column columnName="orderDate"><![CDATA[2019/06/21]]></column> <column columnName="shipDate"><![CDATA[2019/06/21]]></column> <column columnName="dueDate"><![CDATA[2019/07/05]]></column> <column columnName="postingDate"><![CDATA[2019/06/21]]></column> <column columnName="documentDate"><![CDATA[2019/06/21]]></column> <column columnName="totalAmount"><![CDATA[484.27]]></column> <column columnName="totalAmountIncVat"><![CDATA[605.34]]></column> </item> <item> <column columnName="id"><![CDATA[1084]]></column> <column columnName="orderDate"><![CDATA[2019/06/21]]></column> <column columnName="shipDate"><![CDATA[2019/06/21]]></column> <column columnName="dueDate"><![CDATA[2019/07/05]]></column> <column columnName="postingDate"><![CDATA[2019/06/21]]></column> <column columnName="documentDate"><![CDATA[2019/06/21]]></column> <column columnName="totalAmount"><![CDATA[286.49]]></column> <column columnName="totalAmountIncVat"><![CDATA[358.11]]></column> </item> <item> <column columnName="id"><![CDATA[1089]]></column> <column columnName="orderDate"><![CDATA[2019/06/21]]></column> <column columnName="shipDate"><![CDATA[2019/06/21]]></column> <column columnName="dueDate"><![CDATA[2019/07/05]]></column> <column columnName="postingDate"><![CDATA[2019/06/21]]></column> <column columnName="documentDate"><![CDATA[2019/06/21]]></column> <column columnName="totalAmount"><![CDATA[193.71]]></column> <column columnName="totalAmountIncVat"><![CDATA[242.14]]></column> </item> <item> <column columnName="id"><![CDATA[1096]]></column> <column columnName="orderDate"><![CDATA[2019/06/25]]></column> <column columnName="shipDate"><![CDATA[2019/06/25]]></column> <column columnName="dueDate"><![CDATA[2019/07/09]]></column> <column columnName="postingDate"><![CDATA[2019/06/25]]></column> <column columnName="documentDate"><![CDATA[2019/06/25]]></column> <column columnName="totalAmount"><![CDATA[135.29]]></column> <column columnName="totalAmountIncVat"><![CDATA[169.11]]></column> </item> <item> <column columnName="id"><![CDATA[1097]]></column> <column columnName="orderDate"><![CDATA[2019/06/25]]></column> <column columnName="shipDate"><![CDATA[2019/06/25]]></column> <column columnName="dueDate"><![CDATA[2019/07/09]]></column> <column columnName="postingDate"><![CDATA[2019/06/25]]></column> <column columnName="documentDate"><![CDATA[2019/06/25]]></column> <column columnName="totalAmount"><![CDATA[135.29]]></column> <column columnName="totalAmountIncVat"><![CDATA[169.11]]></column> </item> <item> <column columnName="id"><![CDATA[1098]]></column> <column columnName="orderDate"><![CDATA[2019/06/25]]></column> <column columnName="shipDate"><![CDATA[2019/06/25]]></column> <column columnName="dueDate"><![CDATA[2019/07/09]]></column> <column columnName="postingDate"><![CDATA[2019/06/25]]></column> <column columnName="documentDate"><![CDATA[2019/06/25]]></column> <column columnName="totalAmount"><![CDATA[155.29]]></column> <column columnName="totalAmountIncVat"><![CDATA[194.11]]></column> </item> <item> <column columnName="id"><![CDATA[1103]]></column> <column columnName="orderDate"><![CDATA[2019/06/27]]></column> <column columnName="shipDate"><![CDATA[2019/06/27]]></column> <column columnName="dueDate"><![CDATA[2019/07/11]]></column> <column columnName="postingDate"><![CDATA[2019/06/27]]></column> <column columnName="documentDate"><![CDATA[2019/06/27]]></column> <column columnName="totalAmount"><![CDATA[193.71]]></column> <column columnName="totalAmountIncVat"><![CDATA[242.14]]></column> </item> <item> <column columnName="id"><![CDATA[1122]]></column> <column columnName="orderDate"><![CDATA[2019/07/01]]></column> <column columnName="shipDate"><![CDATA[2019/07/01]]></column> <column columnName="dueDate"><![CDATA[2019/07/15]]></column> <column columnName="postingDate"><![CDATA[2019/07/01]]></column> <column columnName="documentDate"><![CDATA[2019/07/01]]></column> <column columnName="totalAmount"><![CDATA[135.29]]></column> <column columnName="totalAmountIncVat"><![CDATA[169.11]]></column> </item> <item> <column columnName="id"><![CDATA[1123]]></column> <column columnName="orderDate"><![CDATA[2019/07/01]]></column> <column columnName="shipDate"><![CDATA[2019/07/01]]></column> <column columnName="dueDate"><![CDATA[2019/07/15]]></column> <column columnName="postingDate"><![CDATA[2019/07/01]]></column> <column columnName="documentDate"><![CDATA[2019/07/01]]></column> <column columnName="totalAmount"><![CDATA[152.80]]></column> <column columnName="totalAmountIncVat"><![CDATA[191.00]]></column> </item> <item> <column columnName="id"><![CDATA[1125]]></column> <column columnName="orderDate"><![CDATA[2019/07/02]]></column> <column columnName="shipDate"><![CDATA[2019/07/02]]></column> <column columnName="dueDate"><![CDATA[2019/07/16]]></column> <column columnName="postingDate"><![CDATA[2019/07/02]]></column> <column columnName="documentDate"><![CDATA[2019/07/02]]></column> <column columnName="totalAmount"><![CDATA[278.54]]></column> <column columnName="totalAmountIncVat"><![CDATA[348.18]]></column> </item> <item> <column columnName="id"><![CDATA[1126]]></column> <column columnName="orderDate"><![CDATA[2019/07/02]]></column> <column columnName="shipDate"><![CDATA[2019/07/02]]></column> <column columnName="dueDate"><![CDATA[2019/07/16]]></column> <column columnName="postingDate"><![CDATA[2019/07/02]]></column> <column columnName="documentDate"><![CDATA[2019/07/02]]></column> <column columnName="totalAmount"><![CDATA[143.25]]></column> <column columnName="totalAmountIncVat"><![CDATA[179.06]]></column> </item> <item> <column columnName="id"><![CDATA[1127]]></column> <column columnName="orderDate"><![CDATA[2019/07/02]]></column> <column columnName="shipDate"><![CDATA[2019/07/02]]></column> <column columnName="dueDate"><![CDATA[2019/07/16]]></column> <column columnName="postingDate"><![CDATA[2019/07/02]]></column> <column columnName="documentDate"><![CDATA[2019/07/02]]></column> <column columnName="totalAmount"><![CDATA[280.57]]></column> <column columnName="totalAmountIncVat"><![CDATA[350.71]]></column> </item> <item> <column columnName="id"><![CDATA[1128]]></column> <column columnName="orderDate"><![CDATA[2019/07/02]]></column> <column columnName="shipDate"><![CDATA[2019/07/02]]></column> <column columnName="dueDate"><![CDATA[2019/07/16]]></column> <column columnName="postingDate"><![CDATA[2019/07/02]]></column> <column columnName="documentDate"><![CDATA[2019/07/02]]></column> <column columnName="totalAmount"><![CDATA[423.82]]></column> <column columnName="totalAmountIncVat"><![CDATA[529.78]]></column> </item> <item> <column columnName="id"><![CDATA[1129]]></column> <column columnName="orderDate"><![CDATA[2019/07/02]]></column> <column columnName="shipDate"><![CDATA[2019/07/02]]></column> <column columnName="dueDate"><![CDATA[2019/07/16]]></column> <column columnName="postingDate"><![CDATA[2019/07/02]]></column> <column columnName="documentDate"><![CDATA[2019/07/02]]></column> <column columnName="totalAmount"><![CDATA[135.29]]></column> <column columnName="totalAmountIncVat"><![CDATA[169.11]]></column> </item> <item> <column columnName="id"><![CDATA[1130]]></column> <column columnName="orderDate"><![CDATA[2019/07/02]]></column> <column columnName="shipDate"><![CDATA[2019/07/02]]></column> <column columnName="dueDate"><![CDATA[2019/07/16]]></column> <column columnName="postingDate"><![CDATA[2019/07/02]]></column> <column columnName="documentDate"><![CDATA[2019/07/02]]></column> <column columnName="totalAmount"><![CDATA[135.29]]></column> <column columnName="totalAmountIncVat"><![CDATA[169.11]]></column> </item> <item> <column columnName="id"><![CDATA[1131]]></column> <column columnName="orderDate"><![CDATA[2019/07/02]]></column> <column columnName="shipDate"><![CDATA[2019/07/02]]></column> <column columnName="dueDate"><![CDATA[2019/07/16]]></column> <column columnName="postingDate"><![CDATA[2019/07/02]]></column> <column columnName="documentDate"><![CDATA[2019/07/02]]></column> <column columnName="totalAmount"><![CDATA[278.54]]></column> <column columnName="totalAmountIncVat"><![CDATA[348.18]]></column> </item> <item> <column columnName="id"><![CDATA[1132]]></column> <column columnName="orderDate"><![CDATA[2019/07/02]]></column> <column columnName="shipDate"><![CDATA[2019/07/02]]></column> <column columnName="dueDate"><![CDATA[2019/07/16]]></column> <column columnName="postingDate"><![CDATA[2019/07/02]]></column> <column columnName="documentDate"><![CDATA[2019/07/02]]></column> <column columnName="totalAmount"><![CDATA[278.54]]></column> <column columnName="totalAmountIncVat"><![CDATA[348.18]]></column> </item> <item> <column columnName="id"><![CDATA[1133]]></column> <column columnName="orderDate"><![CDATA[2019/07/02]]></column> <column columnName="shipDate"><![CDATA[2019/07/02]]></column> <column columnName="dueDate"><![CDATA[2019/07/16]]></column> <column columnName="postingDate"><![CDATA[2019/07/02]]></column> <column columnName="documentDate"><![CDATA[2019/07/02]]></column> <column columnName="totalAmount"><![CDATA[135.29]]></column> <column columnName="totalAmountIncVat"><![CDATA[169.11]]></column> </item> <item> <column columnName="id"><![CDATA[1134]]></column> <column columnName="orderDate"><![CDATA[2019/07/02]]></column> <column columnName="shipDate"><![CDATA[2019/07/02]]></column> <column columnName="dueDate"><![CDATA[2019/07/16]]></column> <column columnName="postingDate"><![CDATA[2019/07/02]]></column> <column columnName="documentDate"><![CDATA[2019/07/02]]></column> <column columnName="totalAmount"><![CDATA[135.29]]></column> <column columnName="totalAmountIncVat"><![CDATA[169.11]]></column> </item> <item> <column columnName="id"><![CDATA[1135]]></column> <column columnName="orderDate"><![CDATA[2019/07/02]]></column> <column columnName="shipDate"><![CDATA[2019/07/02]]></column> <column columnName="dueDate"><![CDATA[2019/07/16]]></column> <column columnName="postingDate"><![CDATA[2019/07/02]]></column> <column columnName="documentDate"><![CDATA[2019/07/02]]></column> <column columnName="totalAmount"><![CDATA[135.29]]></column> <column columnName="totalAmountIncVat"><![CDATA[169.11]]></column> </item> <item> <column columnName="id"><![CDATA[1136]]></column> <column columnName="orderDate"><![CDATA[2019/07/02]]></column> <column columnName="shipDate"><![CDATA[2019/07/02]]></column> <column columnName="dueDate"><![CDATA[2019/07/16]]></column> <column columnName="postingDate"><![CDATA[2019/07/02]]></column> <column columnName="documentDate"><![CDATA[2019/07/02]]></column> <column columnName="totalAmount"><![CDATA[135.29]]></column> <column columnName="totalAmountIncVat"><![CDATA[169.11]]></column> </item> <item> <column columnName="id"><![CDATA[1137]]></column> <column columnName="orderDate"><![CDATA[2019/07/03]]></column> <column columnName="shipDate"><![CDATA[2019/07/03]]></column> <column columnName="dueDate"><![CDATA[2019/07/17]]></column> <column columnName="postingDate"><![CDATA[2019/07/03]]></column> <column columnName="documentDate"><![CDATA[2019/07/03]]></column> <column columnName="totalAmount"><![CDATA[540.23]]></column> <column columnName="totalAmountIncVat"><![CDATA[675.29]]></column> </item> <item> <column columnName="id"><![CDATA[1138]]></column> <column columnName="orderDate"><![CDATA[2019/07/03]]></column> <column columnName="shipDate"><![CDATA[2019/07/03]]></column> <column columnName="dueDate"><![CDATA[2019/07/17]]></column> <column columnName="postingDate"><![CDATA[2019/07/03]]></column> <column columnName="documentDate"><![CDATA[2019/07/03]]></column> <column columnName="totalAmount"><![CDATA[133.70]]></column> <column columnName="totalAmountIncVat"><![CDATA[167.13]]></column> </item> <item> <column columnName="id"><![CDATA[1139]]></column> <column columnName="orderDate"><![CDATA[2019/07/03]]></column> <column columnName="shipDate"><![CDATA[2019/07/03]]></column> <column columnName="dueDate"><![CDATA[2019/07/17]]></column> <column columnName="postingDate"><![CDATA[2019/07/03]]></column> <column columnName="documentDate"><![CDATA[2019/07/03]]></column> <column columnName="totalAmount"><![CDATA[193.71]]></column> <column columnName="totalAmountIncVat"><![CDATA[242.14]]></column> </item> <item> <column columnName="id"><![CDATA[1141]]></column> <column columnName="orderDate"><![CDATA[2019/07/03]]></column> <column columnName="shipDate"><![CDATA[2019/07/03]]></column> <column columnName="dueDate"><![CDATA[2019/07/17]]></column> <column columnName="postingDate"><![CDATA[2019/07/03]]></column> <column columnName="documentDate"><![CDATA[2019/07/03]]></column> <column columnName="totalAmount"><![CDATA[327.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[409.26]]></column> </item> <item> <column columnName="id"><![CDATA[1145]]></column> <column columnName="orderDate"><![CDATA[2019/07/12]]></column> <column columnName="shipDate"><![CDATA[2019/07/12]]></column> <column columnName="dueDate"><![CDATA[2019/07/26]]></column> <column columnName="postingDate"><![CDATA[2019/07/12]]></column> <column columnName="documentDate"><![CDATA[2019/07/12]]></column> <column columnName="totalAmount"><![CDATA[143.25]]></column> <column columnName="totalAmountIncVat"><![CDATA[179.06]]></column> </item> <item> <column columnName="id"><![CDATA[1146]]></column> <column columnName="orderDate"><![CDATA[2019/07/12]]></column> <column columnName="shipDate"><![CDATA[2019/07/12]]></column> <column columnName="dueDate"><![CDATA[2019/07/26]]></column> <column columnName="postingDate"><![CDATA[2019/07/12]]></column> <column columnName="documentDate"><![CDATA[2019/07/12]]></column> <column columnName="totalAmount"><![CDATA[153.25]]></column> <column columnName="totalAmountIncVat"><![CDATA[189.06]]></column> </item> <item> <column columnName="id"><![CDATA[1147]]></column> <column columnName="orderDate"><![CDATA[2019/07/15]]></column> <column columnName="shipDate"><![CDATA[2019/07/15]]></column> <column columnName="dueDate"><![CDATA[2019/07/29]]></column> <column columnName="postingDate"><![CDATA[2019/07/15]]></column> <column columnName="documentDate"><![CDATA[2019/07/15]]></column> <column columnName="totalAmount"><![CDATA[143.25]]></column> <column columnName="totalAmountIncVat"><![CDATA[179.06]]></column> </item> <item> <column columnName="id"><![CDATA[1148]]></column> <column columnName="orderDate"><![CDATA[2019/07/15]]></column> <column columnName="shipDate"><![CDATA[2019/07/15]]></column> <column columnName="dueDate"><![CDATA[2019/07/29]]></column> <column columnName="postingDate"><![CDATA[2019/07/15]]></column> <column columnName="documentDate"><![CDATA[2019/07/15]]></column> <column columnName="totalAmount"><![CDATA[145.29]]></column> <column columnName="totalAmountIncVat"><![CDATA[179.11]]></column> </item> <item> <column columnName="id"><![CDATA[1162]]></column> <column columnName="orderDate"><![CDATA[2019/07/03]]></column> <column columnName="shipDate"><![CDATA[2019/07/03]]></column> <column columnName="dueDate"><![CDATA[2019/07/17]]></column> <column columnName="postingDate"><![CDATA[2019/07/03]]></column> <column columnName="documentDate"><![CDATA[2019/07/03]]></column> <column columnName="totalAmount"><![CDATA[459.39]]></column> <column columnName="totalAmountIncVat"><![CDATA[574.24]]></column> </item> <item> <column columnName="id"><![CDATA[1163]]></column> <column columnName="orderDate"><![CDATA[2019/07/22]]></column> <column columnName="shipDate"><![CDATA[2019/07/22]]></column> <column columnName="dueDate"><![CDATA[2019/08/05]]></column> <column columnName="postingDate"><![CDATA[2019/07/22]]></column> <column columnName="documentDate"><![CDATA[2019/07/22]]></column> <column columnName="totalAmount"><![CDATA[459.39]]></column> <column columnName="totalAmountIncVat"><![CDATA[574.24]]></column> </item> <item> <column columnName="id"><![CDATA[1164]]></column> <column columnName="orderDate"><![CDATA[2019/07/22]]></column> <column columnName="shipDate"><![CDATA[2019/07/22]]></column> <column columnName="dueDate"><![CDATA[2019/08/05]]></column> <column columnName="postingDate"><![CDATA[2019/07/22]]></column> <column columnName="documentDate"><![CDATA[2019/07/22]]></column> <column columnName="totalAmount"><![CDATA[153.80]]></column> <column columnName="totalAmountIncVat"><![CDATA[192.25]]></column> </item> <item> <column columnName="id"><![CDATA[1165]]></column> <column columnName="orderDate"><![CDATA[2019/07/22]]></column> <column columnName="shipDate"><![CDATA[2019/07/22]]></column> <column columnName="dueDate"><![CDATA[2019/08/05]]></column> <column columnName="postingDate"><![CDATA[2019/07/22]]></column> <column columnName="documentDate"><![CDATA[2019/07/22]]></column> <column columnName="totalAmount"><![CDATA[153.80]]></column> <column columnName="totalAmountIncVat"><![CDATA[192.25]]></column> </item> <item> <column columnName="id"><![CDATA[1166]]></column> <column columnName="orderDate"><![CDATA[2019/07/03]]></column> <column columnName="shipDate"><![CDATA[2019/07/03]]></column> <column columnName="dueDate"><![CDATA[2019/07/17]]></column> <column columnName="postingDate"><![CDATA[2019/07/03]]></column> <column columnName="documentDate"><![CDATA[2019/07/03]]></column> <column columnName="totalAmount"><![CDATA[324.69]]></column> <column columnName="totalAmountIncVat"><![CDATA[405.86]]></column> </item> <item> <column columnName="id"><![CDATA[1167]]></column> <column columnName="orderDate"><![CDATA[2019/07/22]]></column> <column columnName="shipDate"><![CDATA[2019/07/22]]></column> <column columnName="dueDate"><![CDATA[2019/08/05]]></column> <column columnName="postingDate"><![CDATA[2019/07/22]]></column> <column columnName="documentDate"><![CDATA[2019/07/22]]></column> <column columnName="totalAmount"><![CDATA[172.35]]></column> <column columnName="totalAmountIncVat"><![CDATA[212.94]]></column> </item> <item> <column columnName="id"><![CDATA[1168]]></column> <column columnName="orderDate"><![CDATA[2019/07/22]]></column> <column columnName="shipDate"><![CDATA[2019/07/22]]></column> <column columnName="dueDate"><![CDATA[2019/08/05]]></column> <column columnName="postingDate"><![CDATA[2019/07/22]]></column> <column columnName="documentDate"><![CDATA[2019/07/22]]></column> <column columnName="totalAmount"><![CDATA[10.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[10.00]]></column> </item> <item> <column columnName="id"><![CDATA[1169]]></column> <column columnName="orderDate"><![CDATA[2019/07/23]]></column> <column columnName="shipDate"><![CDATA[2019/07/23]]></column> <column columnName="dueDate"><![CDATA[2019/08/06]]></column> <column columnName="postingDate"><![CDATA[2019/07/23]]></column> <column columnName="documentDate"><![CDATA[2019/07/23]]></column> <column columnName="totalAmount"><![CDATA[131.10]]></column> <column columnName="totalAmountIncVat"><![CDATA[161.37]]></column> </item> <item> <column columnName="id"><![CDATA[1170]]></column> <column columnName="orderDate"><![CDATA[2019/07/23]]></column> <column columnName="shipDate"><![CDATA[2019/07/23]]></column> <column columnName="dueDate"><![CDATA[2019/08/06]]></column> <column columnName="postingDate"><![CDATA[2019/07/23]]></column> <column columnName="documentDate"><![CDATA[2019/07/23]]></column> <column columnName="totalAmount"><![CDATA[121.09]]></column> <column columnName="totalAmountIncVat"><![CDATA[151.36]]></column> </item> <item> <column columnName="id"><![CDATA[1171]]></column> <column columnName="orderDate"><![CDATA[2019/07/23]]></column> <column columnName="shipDate"><![CDATA[2019/07/23]]></column> <column columnName="dueDate"><![CDATA[2019/08/06]]></column> <column columnName="postingDate"><![CDATA[2019/07/23]]></column> <column columnName="documentDate"><![CDATA[2019/07/23]]></column> <column columnName="totalAmount"><![CDATA[121.09]]></column> <column columnName="totalAmountIncVat"><![CDATA[151.36]]></column> </item> <item> <column columnName="id"><![CDATA[1172]]></column> <column columnName="orderDate"><![CDATA[2019/07/23]]></column> <column columnName="shipDate"><![CDATA[2019/07/23]]></column> <column columnName="dueDate"><![CDATA[2019/08/06]]></column> <column columnName="postingDate"><![CDATA[2019/07/23]]></column> <column columnName="documentDate"><![CDATA[2019/07/23]]></column> <column columnName="totalAmount"><![CDATA[230.66]]></column> <column columnName="totalAmountIncVat"><![CDATA[285.83]]></column> </item> <item> <column columnName="id"><![CDATA[1173]]></column> <column columnName="orderDate"><![CDATA[2019/07/23]]></column> <column columnName="shipDate"><![CDATA[2019/07/23]]></column> <column columnName="dueDate"><![CDATA[2019/08/06]]></column> <column columnName="postingDate"><![CDATA[2019/07/23]]></column> <column columnName="documentDate"><![CDATA[2019/07/23]]></column> <column columnName="totalAmount"><![CDATA[123.51]]></column> <column columnName="totalAmountIncVat"><![CDATA[151.89]]></column> </item> <item> <column columnName="id"><![CDATA[1174]]></column> <column columnName="orderDate"><![CDATA[2019/07/23]]></column> <column columnName="shipDate"><![CDATA[2019/07/23]]></column> <column columnName="dueDate"><![CDATA[2019/08/06]]></column> <column columnName="postingDate"><![CDATA[2019/07/23]]></column> <column columnName="documentDate"><![CDATA[2019/07/23]]></column> <column columnName="totalAmount"><![CDATA[227.86]]></column> <column columnName="totalAmountIncVat"><![CDATA[284.83]]></column> </item> <item> <column columnName="id"><![CDATA[1175]]></column> <column columnName="orderDate"><![CDATA[2019/07/23]]></column> <column columnName="shipDate"><![CDATA[2019/07/23]]></column> <column columnName="dueDate"><![CDATA[2019/08/06]]></column> <column columnName="postingDate"><![CDATA[2019/07/23]]></column> <column columnName="documentDate"><![CDATA[2019/07/23]]></column> <column columnName="totalAmount"><![CDATA[259.59]]></column> <column columnName="totalAmountIncVat"><![CDATA[321.99]]></column> </item> <item> <column columnName="id"><![CDATA[1176]]></column> <column columnName="orderDate"><![CDATA[2019/07/23]]></column> <column columnName="shipDate"><![CDATA[2019/07/23]]></column> <column columnName="dueDate"><![CDATA[2019/08/06]]></column> <column columnName="postingDate"><![CDATA[2019/07/23]]></column> <column columnName="documentDate"><![CDATA[2019/07/23]]></column> <column columnName="totalAmount"><![CDATA[337.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[418.75]]></column> </item> <item> <column columnName="id"><![CDATA[1177]]></column> <column columnName="orderDate"><![CDATA[2019/07/23]]></column> <column columnName="shipDate"><![CDATA[2019/07/23]]></column> <column columnName="dueDate"><![CDATA[2019/08/06]]></column> <column columnName="postingDate"><![CDATA[2019/07/23]]></column> <column columnName="documentDate"><![CDATA[2019/07/23]]></column> <column columnName="totalAmount"><![CDATA[302.23]]></column> <column columnName="totalAmountIncVat"><![CDATA[375.29]]></column> </item> <item> <column columnName="id"><![CDATA[1178]]></column> <column columnName="orderDate"><![CDATA[2019/07/03]]></column> <column columnName="shipDate"><![CDATA[2019/07/03]]></column> <column columnName="dueDate"><![CDATA[2019/07/17]]></column> <column columnName="postingDate"><![CDATA[2019/07/03]]></column> <column columnName="documentDate"><![CDATA[2019/07/03]]></column> <column columnName="totalAmount"><![CDATA[292.23]]></column> <column columnName="totalAmountIncVat"><![CDATA[365.29]]></column> </item> <item> <column columnName="id"><![CDATA[1179]]></column> <column columnName="orderDate"><![CDATA[2019/07/23]]></column> <column columnName="shipDate"><![CDATA[2019/07/23]]></column> <column columnName="dueDate"><![CDATA[2019/08/06]]></column> <column columnName="postingDate"><![CDATA[2019/07/23]]></column> <column columnName="documentDate"><![CDATA[2019/07/23]]></column> <column columnName="totalAmount"><![CDATA[304.53]]></column> <column columnName="totalAmountIncVat"><![CDATA[378.16]]></column> </item> <item> <column columnName="id"><![CDATA[1180]]></column> <column columnName="orderDate"><![CDATA[2019/07/23]]></column> <column columnName="shipDate"><![CDATA[2019/07/23]]></column> <column columnName="dueDate"><![CDATA[2019/08/06]]></column> <column columnName="postingDate"><![CDATA[2019/07/23]]></column> <column columnName="documentDate"><![CDATA[2019/07/23]]></column> <column columnName="totalAmount"><![CDATA[302.23]]></column> <column columnName="totalAmountIncVat"><![CDATA[375.29]]></column> </item> <item> <column columnName="id"><![CDATA[1181]]></column> <column columnName="orderDate"><![CDATA[2019/07/23]]></column> <column columnName="shipDate"><![CDATA[2019/07/23]]></column> <column columnName="dueDate"><![CDATA[2019/08/06]]></column> <column columnName="postingDate"><![CDATA[2019/07/23]]></column> <column columnName="documentDate"><![CDATA[2019/07/23]]></column> <column columnName="totalAmount"><![CDATA[923.75]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,152.19]]></column> </item> <item> <column columnName="id"><![CDATA[1182]]></column> <column columnName="orderDate"><![CDATA[2019/07/23]]></column> <column columnName="shipDate"><![CDATA[2019/07/23]]></column> <column columnName="dueDate"><![CDATA[2019/08/06]]></column> <column columnName="postingDate"><![CDATA[2019/07/23]]></column> <column columnName="documentDate"><![CDATA[2019/07/23]]></column> <column columnName="totalAmount"><![CDATA[805.87]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,004.84]]></column> </item> <item> <column columnName="id"><![CDATA[1183]]></column> <column columnName="orderDate"><![CDATA[2019/07/24]]></column> <column columnName="shipDate"><![CDATA[2019/07/24]]></column> <column columnName="dueDate"><![CDATA[2019/08/07]]></column> <column columnName="postingDate"><![CDATA[2019/07/24]]></column> <column columnName="documentDate"><![CDATA[2019/07/24]]></column> <column columnName="totalAmount"><![CDATA[62.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[75.51]]></column> </item> <item> <column columnName="id"><![CDATA[1184]]></column> <column columnName="orderDate"><![CDATA[2019/07/24]]></column> <column columnName="shipDate"><![CDATA[2019/07/24]]></column> <column columnName="dueDate"><![CDATA[2019/08/07]]></column> <column columnName="postingDate"><![CDATA[2019/07/24]]></column> <column columnName="documentDate"><![CDATA[2019/07/24]]></column> <column columnName="totalAmount"><![CDATA[222.82]]></column> <column columnName="totalAmountIncVat"><![CDATA[276.03]]></column> </item> <item> <column columnName="id"><![CDATA[1185]]></column> <column columnName="orderDate"><![CDATA[2019/07/24]]></column> <column columnName="shipDate"><![CDATA[2019/07/24]]></column> <column columnName="dueDate"><![CDATA[2019/08/07]]></column> <column columnName="postingDate"><![CDATA[2019/07/24]]></column> <column columnName="documentDate"><![CDATA[2019/07/24]]></column> <column columnName="totalAmount"><![CDATA[55.17]]></column> <column columnName="totalAmountIncVat"><![CDATA[68.96]]></column> </item> <item> <column columnName="id"><![CDATA[1186]]></column> <column columnName="orderDate"><![CDATA[2019/07/03]]></column> <column columnName="shipDate"><![CDATA[2019/07/03]]></column> <column columnName="dueDate"><![CDATA[2019/07/17]]></column> <column columnName="postingDate"><![CDATA[2019/07/03]]></column> <column columnName="documentDate"><![CDATA[2019/07/03]]></column> <column columnName="totalAmount"><![CDATA[52.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[65.51]]></column> </item> <item> <column columnName="id"><![CDATA[1187]]></column> <column columnName="orderDate"><![CDATA[2019/07/24]]></column> <column columnName="shipDate"><![CDATA[2019/07/24]]></column> <column columnName="dueDate"><![CDATA[2019/08/07]]></column> <column columnName="postingDate"><![CDATA[2019/07/24]]></column> <column columnName="documentDate"><![CDATA[2019/07/24]]></column> <column columnName="totalAmount"><![CDATA[65.17]]></column> <column columnName="totalAmountIncVat"><![CDATA[78.96]]></column> </item> <item> <column columnName="id"><![CDATA[1188]]></column> <column columnName="orderDate"><![CDATA[2019/07/24]]></column> <column columnName="shipDate"><![CDATA[2019/07/24]]></column> <column columnName="dueDate"><![CDATA[2019/08/07]]></column> <column columnName="postingDate"><![CDATA[2019/07/24]]></column> <column columnName="documentDate"><![CDATA[2019/07/24]]></column> <column columnName="totalAmount"><![CDATA[172.35]]></column> <column columnName="totalAmountIncVat"><![CDATA[212.94]]></column> </item> <item> <column columnName="id"><![CDATA[1189]]></column> <column columnName="orderDate"><![CDATA[2019/07/24]]></column> <column columnName="shipDate"><![CDATA[2019/07/24]]></column> <column columnName="dueDate"><![CDATA[2019/08/07]]></column> <column columnName="postingDate"><![CDATA[2019/07/24]]></column> <column columnName="documentDate"><![CDATA[2019/07/24]]></column> <column columnName="totalAmount"><![CDATA[109.30]]></column> <column columnName="totalAmountIncVat"><![CDATA[134.13]]></column> </item> <item> <column columnName="id"><![CDATA[1190]]></column> <column columnName="orderDate"><![CDATA[2019/07/24]]></column> <column columnName="shipDate"><![CDATA[2019/07/24]]></column> <column columnName="dueDate"><![CDATA[2019/08/07]]></column> <column columnName="postingDate"><![CDATA[2019/07/24]]></column> <column columnName="documentDate"><![CDATA[2019/07/24]]></column> <column columnName="totalAmount"><![CDATA[835.12]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,041.40]]></column> </item> <item> <column columnName="id"><![CDATA[1191]]></column> <column columnName="orderDate"><![CDATA[2019/07/24]]></column> <column columnName="shipDate"><![CDATA[2019/07/24]]></column> <column columnName="dueDate"><![CDATA[2019/08/07]]></column> <column columnName="postingDate"><![CDATA[2019/07/24]]></column> <column columnName="documentDate"><![CDATA[2019/07/24]]></column> <column columnName="totalAmount"><![CDATA[826.48]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,033.10]]></column> </item> <item> <column columnName="id"><![CDATA[1192]]></column> <column columnName="orderDate"><![CDATA[2019/07/24]]></column> <column columnName="shipDate"><![CDATA[2019/07/24]]></column> <column columnName="dueDate"><![CDATA[2019/08/07]]></column> <column columnName="postingDate"><![CDATA[2019/07/24]]></column> <column columnName="documentDate"><![CDATA[2019/07/24]]></column> <column columnName="totalAmount"><![CDATA[767.20]]></column> <column columnName="totalAmountIncVat"><![CDATA[956.50]]></column> </item> <item> <column columnName="id"><![CDATA[1193]]></column> <column columnName="orderDate"><![CDATA[2019/07/24]]></column> <column columnName="shipDate"><![CDATA[2019/07/24]]></column> <column columnName="dueDate"><![CDATA[2019/08/07]]></column> <column columnName="postingDate"><![CDATA[2019/07/24]]></column> <column columnName="documentDate"><![CDATA[2019/07/24]]></column> <column columnName="totalAmount"><![CDATA[816.02]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,017.53]]></column> </item> <item> <column columnName="id"><![CDATA[1194]]></column> <column columnName="orderDate"><![CDATA[2019/07/24]]></column> <column columnName="shipDate"><![CDATA[2019/07/24]]></column> <column columnName="dueDate"><![CDATA[2019/08/07]]></column> <column columnName="postingDate"><![CDATA[2019/07/24]]></column> <column columnName="documentDate"><![CDATA[2019/07/24]]></column> <column columnName="totalAmount"><![CDATA[162.35]]></column> <column columnName="totalAmountIncVat"><![CDATA[202.94]]></column> </item> <item> <column columnName="id"><![CDATA[1201]]></column> <column columnName="orderDate"><![CDATA[2019/08/05]]></column> <column columnName="shipDate"><![CDATA[2019/08/05]]></column> <column columnName="dueDate"><![CDATA[2019/08/19]]></column> <column columnName="postingDate"><![CDATA[2019/08/05]]></column> <column columnName="documentDate"><![CDATA[2019/08/05]]></column> <column columnName="totalAmount"><![CDATA[189.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[236.76]]></column> </item> <item> <column columnName="id"><![CDATA[1202]]></column> <column columnName="orderDate"><![CDATA[2019/08/05]]></column> <column columnName="shipDate"><![CDATA[2019/08/05]]></column> <column columnName="dueDate"><![CDATA[2019/08/19]]></column> <column columnName="postingDate"><![CDATA[2019/08/05]]></column> <column columnName="documentDate"><![CDATA[2019/08/05]]></column> <column columnName="totalAmount"><![CDATA[200.55]]></column> <column columnName="totalAmountIncVat"><![CDATA[250.69]]></column> </item> <item> <column columnName="id"><![CDATA[1204]]></column> <column columnName="orderDate"><![CDATA[2019/08/06]]></column> <column columnName="shipDate"><![CDATA[2019/08/06]]></column> <column columnName="dueDate"><![CDATA[2019/08/20]]></column> <column columnName="postingDate"><![CDATA[2019/08/06]]></column> <column columnName="documentDate"><![CDATA[2019/08/06]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[246.76]]></column> </item> <item> <column columnName="id"><![CDATA[1205]]></column> <column columnName="orderDate"><![CDATA[2019/08/06]]></column> <column columnName="shipDate"><![CDATA[2019/08/06]]></column> <column columnName="dueDate"><![CDATA[2019/08/20]]></column> <column columnName="postingDate"><![CDATA[2019/08/06]]></column> <column columnName="documentDate"><![CDATA[2019/08/06]]></column> <column columnName="totalAmount"><![CDATA[189.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[236.76]]></column> </item> <item> <column columnName="id"><![CDATA[1206]]></column> <column columnName="orderDate"><![CDATA[2019/08/06]]></column> <column columnName="shipDate"><![CDATA[2019/08/06]]></column> <column columnName="dueDate"><![CDATA[2019/08/20]]></column> <column columnName="postingDate"><![CDATA[2019/08/06]]></column> <column columnName="documentDate"><![CDATA[2019/08/06]]></column> <column columnName="totalAmount"><![CDATA[189.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[236.76]]></column> </item> <item> <column columnName="id"><![CDATA[1207]]></column> <column columnName="orderDate"><![CDATA[2019/08/06]]></column> <column columnName="shipDate"><![CDATA[2019/08/06]]></column> <column columnName="dueDate"><![CDATA[2019/08/20]]></column> <column columnName="postingDate"><![CDATA[2019/08/06]]></column> <column columnName="documentDate"><![CDATA[2019/08/06]]></column> <column columnName="totalAmount"><![CDATA[197.91]]></column> <column columnName="totalAmountIncVat"><![CDATA[247.39]]></column> </item> <item> <column columnName="id"><![CDATA[1208]]></column> <column columnName="orderDate"><![CDATA[2019/08/06]]></column> <column columnName="shipDate"><![CDATA[2019/08/06]]></column> <column columnName="dueDate"><![CDATA[2019/08/20]]></column> <column columnName="postingDate"><![CDATA[2019/08/06]]></column> <column columnName="documentDate"><![CDATA[2019/08/06]]></column> <column columnName="totalAmount"><![CDATA[201.91]]></column> <column columnName="totalAmountIncVat"><![CDATA[249.26]]></column> </item> <item> <column columnName="id"><![CDATA[1211]]></column> <column columnName="orderDate"><![CDATA[2019/08/09]]></column> <column columnName="shipDate"><![CDATA[2019/08/09]]></column> <column columnName="dueDate"><![CDATA[2019/08/23]]></column> <column columnName="postingDate"><![CDATA[2019/08/09]]></column> <column columnName="documentDate"><![CDATA[2019/08/09]]></column> <column columnName="totalAmount"><![CDATA[201.91]]></column> <column columnName="totalAmountIncVat"><![CDATA[252.39]]></column> </item> <item> <column columnName="id"><![CDATA[1212]]></column> <column columnName="orderDate"><![CDATA[2019/08/09]]></column> <column columnName="shipDate"><![CDATA[2019/08/09]]></column> <column columnName="dueDate"><![CDATA[2019/08/23]]></column> <column columnName="postingDate"><![CDATA[2019/08/09]]></column> <column columnName="documentDate"><![CDATA[2019/08/09]]></column> <column columnName="totalAmount"><![CDATA[222.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[278.54]]></column> </item> <item> <column columnName="id"><![CDATA[1213]]></column> <column columnName="orderDate"><![CDATA[2019/08/09]]></column> <column columnName="shipDate"><![CDATA[2019/08/09]]></column> <column columnName="dueDate"><![CDATA[2019/08/23]]></column> <column columnName="postingDate"><![CDATA[2019/08/09]]></column> <column columnName="documentDate"><![CDATA[2019/08/09]]></column> <column columnName="totalAmount"><![CDATA[222.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[278.54]]></column> </item> <item> <column columnName="id"><![CDATA[1214]]></column> <column columnName="orderDate"><![CDATA[2019/08/09]]></column> <column columnName="shipDate"><![CDATA[2019/08/09]]></column> <column columnName="dueDate"><![CDATA[2019/08/23]]></column> <column columnName="postingDate"><![CDATA[2019/08/09]]></column> <column columnName="documentDate"><![CDATA[2019/08/09]]></column> <column columnName="totalAmount"><![CDATA[235.33]]></column> <column columnName="totalAmountIncVat"><![CDATA[294.16]]></column> </item> <item> <column columnName="id"><![CDATA[1215]]></column> <column columnName="orderDate"><![CDATA[2019/08/09]]></column> <column columnName="shipDate"><![CDATA[2019/08/09]]></column> <column columnName="dueDate"><![CDATA[2019/08/23]]></column> <column columnName="postingDate"><![CDATA[2019/08/09]]></column> <column columnName="documentDate"><![CDATA[2019/08/09]]></column> <column columnName="totalAmount"><![CDATA[235.33]]></column> <column columnName="totalAmountIncVat"><![CDATA[291.04]]></column> </item> <item> <column columnName="id"><![CDATA[1216]]></column> <column columnName="orderDate"><![CDATA[2019/08/09]]></column> <column columnName="shipDate"><![CDATA[2019/08/09]]></column> <column columnName="dueDate"><![CDATA[2019/08/23]]></column> <column columnName="postingDate"><![CDATA[2019/08/09]]></column> <column columnName="documentDate"><![CDATA[2019/08/09]]></column> <column columnName="totalAmount"><![CDATA[201.91]]></column> <column columnName="totalAmountIncVat"><![CDATA[249.26]]></column> </item> <item> <column columnName="id"><![CDATA[1217]]></column> <column columnName="orderDate"><![CDATA[2019/07/03]]></column> <column columnName="shipDate"><![CDATA[2019/07/03]]></column> <column columnName="dueDate"><![CDATA[2019/07/17]]></column> <column columnName="postingDate"><![CDATA[2019/07/03]]></column> <column columnName="documentDate"><![CDATA[2019/07/03]]></column> <column columnName="totalAmount"><![CDATA[10.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[12.50]]></column> </item> <item> <column columnName="id"><![CDATA[1218]]></column> <column columnName="orderDate"><![CDATA[2019/08/09]]></column> <column columnName="shipDate"><![CDATA[2019/08/09]]></column> <column columnName="dueDate"><![CDATA[2019/08/23]]></column> <column columnName="postingDate"><![CDATA[2019/08/09]]></column> <column columnName="documentDate"><![CDATA[2019/08/09]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[249.26]]></column> </item> <item> <column columnName="id"><![CDATA[1219]]></column> <column columnName="orderDate"><![CDATA[2019/08/09]]></column> <column columnName="shipDate"><![CDATA[2019/08/09]]></column> <column columnName="dueDate"><![CDATA[2019/08/23]]></column> <column columnName="postingDate"><![CDATA[2019/08/09]]></column> <column columnName="documentDate"><![CDATA[2019/08/09]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[246.76]]></column> </item> <item> <column columnName="id"><![CDATA[1220]]></column> <column columnName="orderDate"><![CDATA[2019/08/09]]></column> <column columnName="shipDate"><![CDATA[2019/08/09]]></column> <column columnName="dueDate"><![CDATA[2019/08/23]]></column> <column columnName="postingDate"><![CDATA[2019/08/09]]></column> <column columnName="documentDate"><![CDATA[2019/08/09]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[249.26]]></column> </item> <item> <column columnName="id"><![CDATA[1221]]></column> <column columnName="orderDate"><![CDATA[2019/08/09]]></column> <column columnName="shipDate"><![CDATA[2019/08/09]]></column> <column columnName="dueDate"><![CDATA[2019/08/23]]></column> <column columnName="postingDate"><![CDATA[2019/08/09]]></column> <column columnName="documentDate"><![CDATA[2019/08/09]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[249.26]]></column> </item> <item> <column columnName="id"><![CDATA[1222]]></column> <column columnName="orderDate"><![CDATA[2019/08/09]]></column> <column columnName="shipDate"><![CDATA[2019/08/09]]></column> <column columnName="dueDate"><![CDATA[2019/08/23]]></column> <column columnName="postingDate"><![CDATA[2019/08/09]]></column> <column columnName="documentDate"><![CDATA[2019/08/09]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[246.76]]></column> </item> <item> <column columnName="id"><![CDATA[1223]]></column> <column columnName="orderDate"><![CDATA[2019/08/09]]></column> <column columnName="shipDate"><![CDATA[2019/08/09]]></column> <column columnName="dueDate"><![CDATA[2019/08/23]]></column> <column columnName="postingDate"><![CDATA[2019/08/09]]></column> <column columnName="documentDate"><![CDATA[2019/08/09]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[246.76]]></column> </item> <item> <column columnName="id"><![CDATA[1224]]></column> <column columnName="orderDate"><![CDATA[2019/08/09]]></column> <column columnName="shipDate"><![CDATA[2019/08/09]]></column> <column columnName="dueDate"><![CDATA[2019/08/23]]></column> <column columnName="postingDate"><![CDATA[2019/08/09]]></column> <column columnName="documentDate"><![CDATA[2019/08/09]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[249.26]]></column> </item> <item> <column columnName="id"><![CDATA[1225]]></column> <column columnName="orderDate"><![CDATA[2019/08/12]]></column> <column columnName="shipDate"><![CDATA[2019/08/12]]></column> <column columnName="dueDate"><![CDATA[2019/08/26]]></column> <column columnName="postingDate"><![CDATA[2019/08/12]]></column> <column columnName="documentDate"><![CDATA[2019/08/12]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[249.26]]></column> </item> <item> <column columnName="id"><![CDATA[1226]]></column> <column columnName="orderDate"><![CDATA[2019/08/12]]></column> <column columnName="shipDate"><![CDATA[2019/08/12]]></column> <column columnName="dueDate"><![CDATA[2019/08/26]]></column> <column columnName="postingDate"><![CDATA[2019/08/12]]></column> <column columnName="documentDate"><![CDATA[2019/08/12]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[249.26]]></column> </item> <item> <column columnName="id"><![CDATA[1229]]></column> <column columnName="orderDate"><![CDATA[2019/08/12]]></column> <column columnName="shipDate"><![CDATA[2019/08/12]]></column> <column columnName="dueDate"><![CDATA[2019/08/26]]></column> <column columnName="postingDate"><![CDATA[2019/08/12]]></column> <column columnName="documentDate"><![CDATA[2019/08/12]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[246.76]]></column> </item> <item> <column columnName="id"><![CDATA[1230]]></column> <column columnName="orderDate"><![CDATA[2019/08/12]]></column> <column columnName="shipDate"><![CDATA[2019/08/12]]></column> <column columnName="dueDate"><![CDATA[2019/08/26]]></column> <column columnName="postingDate"><![CDATA[2019/08/12]]></column> <column columnName="documentDate"><![CDATA[2019/08/12]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[246.76]]></column> </item> <item> <column columnName="id"><![CDATA[1231]]></column> <column columnName="orderDate"><![CDATA[2019/08/12]]></column> <column columnName="shipDate"><![CDATA[2019/08/12]]></column> <column columnName="dueDate"><![CDATA[2019/08/26]]></column> <column columnName="postingDate"><![CDATA[2019/08/12]]></column> <column columnName="documentDate"><![CDATA[2019/08/12]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[246.76]]></column> </item> <item> <column columnName="id"><![CDATA[1232]]></column> <column columnName="orderDate"><![CDATA[2019/08/12]]></column> <column columnName="shipDate"><![CDATA[2019/08/12]]></column> <column columnName="dueDate"><![CDATA[2019/08/26]]></column> <column columnName="postingDate"><![CDATA[2019/08/12]]></column> <column columnName="documentDate"><![CDATA[2019/08/12]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[246.76]]></column> </item> <item> <column columnName="id"><![CDATA[1233]]></column> <column columnName="orderDate"><![CDATA[2019/08/12]]></column> <column columnName="shipDate"><![CDATA[2019/08/12]]></column> <column columnName="dueDate"><![CDATA[2019/08/26]]></column> <column columnName="postingDate"><![CDATA[2019/08/12]]></column> <column columnName="documentDate"><![CDATA[2019/08/12]]></column> <column columnName="totalAmount"><![CDATA[189.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[236.76]]></column> </item> <item> <column columnName="id"><![CDATA[1234]]></column> <column columnName="orderDate"><![CDATA[2019/08/12]]></column> <column columnName="shipDate"><![CDATA[2019/08/12]]></column> <column columnName="dueDate"><![CDATA[2019/08/26]]></column> <column columnName="postingDate"><![CDATA[2019/08/12]]></column> <column columnName="documentDate"><![CDATA[2019/08/12]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[236.76]]></column> </item> <item> <column columnName="id"><![CDATA[1235]]></column> <column columnName="orderDate"><![CDATA[2019/08/12]]></column> <column columnName="shipDate"><![CDATA[2019/08/12]]></column> <column columnName="dueDate"><![CDATA[2019/08/26]]></column> <column columnName="postingDate"><![CDATA[2019/08/12]]></column> <column columnName="documentDate"><![CDATA[2019/08/12]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[236.76]]></column> </item> <item> <column columnName="id"><![CDATA[1236]]></column> <column columnName="orderDate"><![CDATA[2019/08/12]]></column> <column columnName="shipDate"><![CDATA[2019/08/12]]></column> <column columnName="dueDate"><![CDATA[2019/08/26]]></column> <column columnName="postingDate"><![CDATA[2019/08/12]]></column> <column columnName="documentDate"><![CDATA[2019/08/12]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[236.76]]></column> </item> <item> <column columnName="id"><![CDATA[1237]]></column> <column columnName="orderDate"><![CDATA[2019/08/12]]></column> <column columnName="shipDate"><![CDATA[2019/08/12]]></column> <column columnName="dueDate"><![CDATA[2019/08/26]]></column> <column columnName="postingDate"><![CDATA[2019/08/12]]></column> <column columnName="documentDate"><![CDATA[2019/08/12]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[246.76]]></column> </item> <item> <column columnName="id"><![CDATA[1238]]></column> <column columnName="orderDate"><![CDATA[2019/08/12]]></column> <column columnName="shipDate"><![CDATA[2019/08/12]]></column> <column columnName="dueDate"><![CDATA[2019/08/26]]></column> <column columnName="postingDate"><![CDATA[2019/08/12]]></column> <column columnName="documentDate"><![CDATA[2019/08/12]]></column> <column columnName="totalAmount"><![CDATA[199.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[236.76]]></column> </item> <item> <column columnName="id"><![CDATA[1239]]></column> <column columnName="orderDate"><![CDATA[2019/08/12]]></column> <column columnName="shipDate"><![CDATA[2019/08/12]]></column> <column columnName="dueDate"><![CDATA[2019/08/26]]></column> <column columnName="postingDate"><![CDATA[2019/08/12]]></column> <column columnName="documentDate"><![CDATA[2019/08/12]]></column> <column columnName="totalAmount"><![CDATA[133.70]]></column> <column columnName="totalAmountIncVat"><![CDATA[167.13]]></column> </item> <item> <column columnName="id"><![CDATA[1240]]></column> <column columnName="orderDate"><![CDATA[2019/08/12]]></column> <column columnName="shipDate"><![CDATA[2019/08/12]]></column> <column columnName="dueDate"><![CDATA[2019/08/26]]></column> <column columnName="postingDate"><![CDATA[2019/08/12]]></column> <column columnName="documentDate"><![CDATA[2019/08/12]]></column> <column columnName="totalAmount"><![CDATA[152.80]]></column> <column columnName="totalAmountIncVat"><![CDATA[191.00]]></column> </item> <item> <column columnName="id"><![CDATA[1243]]></column> <column columnName="orderDate"><![CDATA[2019/08/13]]></column> <column columnName="shipDate"><![CDATA[2019/08/13]]></column> <column columnName="dueDate"><![CDATA[2019/08/27]]></column> <column columnName="postingDate"><![CDATA[2019/08/13]]></column> <column columnName="documentDate"><![CDATA[2019/08/13]]></column> <column columnName="totalAmount"><![CDATA[200.55]]></column> <column columnName="totalAmountIncVat"><![CDATA[250.69]]></column> </item> <item> <column columnName="id"><![CDATA[1244]]></column> <column columnName="orderDate"><![CDATA[2019/08/13]]></column> <column columnName="shipDate"><![CDATA[2019/08/13]]></column> <column columnName="dueDate"><![CDATA[2019/08/27]]></column> <column columnName="postingDate"><![CDATA[2019/08/13]]></column> <column columnName="documentDate"><![CDATA[2019/08/13]]></column> <column columnName="totalAmount"><![CDATA[133.70]]></column> <column columnName="totalAmountIncVat"><![CDATA[167.13]]></column> </item> <item> <column columnName="id"><![CDATA[1245]]></column> <column columnName="orderDate"><![CDATA[2019/08/13]]></column> <column columnName="shipDate"><![CDATA[2019/08/13]]></column> <column columnName="dueDate"><![CDATA[2019/08/27]]></column> <column columnName="postingDate"><![CDATA[2019/08/13]]></column> <column columnName="documentDate"><![CDATA[2019/08/13]]></column> <column columnName="totalAmount"><![CDATA[152.80]]></column> <column columnName="totalAmountIncVat"><![CDATA[191.00]]></column> </item> <item> <column columnName="id"><![CDATA[1247]]></column> <column columnName="orderDate"><![CDATA[2019/08/13]]></column> <column columnName="shipDate"><![CDATA[2019/08/13]]></column> <column columnName="dueDate"><![CDATA[2019/08/27]]></column> <column columnName="postingDate"><![CDATA[2019/08/13]]></column> <column columnName="documentDate"><![CDATA[2019/08/13]]></column> <column columnName="totalAmount"><![CDATA[200.55]]></column> <column columnName="totalAmountIncVat"><![CDATA[250.69]]></column> </item> <item> <column columnName="id"><![CDATA[1248]]></column> <column columnName="orderDate"><![CDATA[2019/08/19]]></column> <column columnName="shipDate"><![CDATA[2019/08/19]]></column> <column columnName="dueDate"><![CDATA[2019/09/02]]></column> <column columnName="postingDate"><![CDATA[2019/08/19]]></column> <column columnName="documentDate"><![CDATA[2019/08/19]]></column> <column columnName="totalAmount"><![CDATA[152.80]]></column> <column columnName="totalAmountIncVat"><![CDATA[191.00]]></column> </item> <item> <column columnName="id"><![CDATA[1249]]></column> <column columnName="orderDate"><![CDATA[2019/08/19]]></column> <column columnName="shipDate"><![CDATA[2019/08/19]]></column> <column columnName="dueDate"><![CDATA[2019/09/02]]></column> <column columnName="postingDate"><![CDATA[2019/08/19]]></column> <column columnName="documentDate"><![CDATA[2019/08/19]]></column> <column columnName="totalAmount"><![CDATA[232.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[288.54]]></column> </item> <item> <column columnName="id"><![CDATA[1250]]></column> <column columnName="orderDate"><![CDATA[2019/08/19]]></column> <column columnName="shipDate"><![CDATA[2019/08/19]]></column> <column columnName="dueDate"><![CDATA[2019/09/02]]></column> <column columnName="postingDate"><![CDATA[2019/08/19]]></column> <column columnName="documentDate"><![CDATA[2019/08/19]]></column> <column columnName="totalAmount"><![CDATA[232.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[288.54]]></column> </item> <item> <column columnName="id"><![CDATA[1251]]></column> <column columnName="orderDate"><![CDATA[2019/08/19]]></column> <column columnName="shipDate"><![CDATA[2019/08/19]]></column> <column columnName="dueDate"><![CDATA[2019/09/02]]></column> <column columnName="postingDate"><![CDATA[2019/08/19]]></column> <column columnName="documentDate"><![CDATA[2019/08/19]]></column> <column columnName="totalAmount"><![CDATA[232.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[291.04]]></column> </item> <item> <column columnName="id"><![CDATA[1252]]></column> <column columnName="orderDate"><![CDATA[2019/08/19]]></column> <column columnName="shipDate"><![CDATA[2019/08/19]]></column> <column columnName="dueDate"><![CDATA[2019/09/02]]></column> <column columnName="postingDate"><![CDATA[2019/08/19]]></column> <column columnName="documentDate"><![CDATA[2019/08/19]]></column> <column columnName="totalAmount"><![CDATA[222.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[278.54]]></column> </item> <item> <column columnName="id"><![CDATA[1253]]></column> <column columnName="orderDate"><![CDATA[2019/08/20]]></column> <column columnName="shipDate"><![CDATA[2019/08/20]]></column> <column columnName="dueDate"><![CDATA[2019/09/03]]></column> <column columnName="postingDate"><![CDATA[2019/08/20]]></column> <column columnName="documentDate"><![CDATA[2019/08/20]]></column> <column columnName="totalAmount"><![CDATA[881.26]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,101.58]]></column> </item> <item> <column columnName="id"><![CDATA[1254]]></column> <column columnName="orderDate"><![CDATA[2019/08/20]]></column> <column columnName="shipDate"><![CDATA[2019/08/20]]></column> <column columnName="dueDate"><![CDATA[2019/09/03]]></column> <column columnName="postingDate"><![CDATA[2019/08/20]]></column> <column columnName="documentDate"><![CDATA[2019/08/20]]></column> <column columnName="totalAmount"><![CDATA[780.23]]></column> <column columnName="totalAmountIncVat"><![CDATA[975.29]]></column> </item> <item> <column columnName="id"><![CDATA[1255]]></column> <column columnName="orderDate"><![CDATA[2019/08/20]]></column> <column columnName="shipDate"><![CDATA[2019/08/20]]></column> <column columnName="dueDate"><![CDATA[2019/09/03]]></column> <column columnName="postingDate"><![CDATA[2019/08/20]]></column> <column columnName="documentDate"><![CDATA[2019/08/20]]></column> <column columnName="totalAmount"><![CDATA[232.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[288.54]]></column> </item> <item> <column columnName="id"><![CDATA[1256]]></column> <column columnName="orderDate"><![CDATA[2019/08/20]]></column> <column columnName="shipDate"><![CDATA[2019/08/20]]></column> <column columnName="dueDate"><![CDATA[2019/09/03]]></column> <column columnName="postingDate"><![CDATA[2019/08/20]]></column> <column columnName="documentDate"><![CDATA[2019/08/20]]></column> <column columnName="totalAmount"><![CDATA[232.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[291.04]]></column> </item> <item> <column columnName="id"><![CDATA[1257]]></column> <column columnName="orderDate"><![CDATA[2019/08/27]]></column> <column columnName="shipDate"><![CDATA[2019/08/27]]></column> <column columnName="dueDate"><![CDATA[2019/09/10]]></column> <column columnName="postingDate"><![CDATA[2019/08/27]]></column> <column columnName="documentDate"><![CDATA[2019/08/27]]></column> <column columnName="totalAmount"><![CDATA[222.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[278.54]]></column> </item> <item> <column columnName="id"><![CDATA[1258]]></column> <column columnName="orderDate"><![CDATA[2019/08/27]]></column> <column columnName="shipDate"><![CDATA[2019/08/27]]></column> <column columnName="dueDate"><![CDATA[2019/09/10]]></column> <column columnName="postingDate"><![CDATA[2019/08/27]]></column> <column columnName="documentDate"><![CDATA[2019/08/27]]></column> <column columnName="totalAmount"><![CDATA[162.80]]></column> <column columnName="totalAmountIncVat"><![CDATA[201.00]]></column> </item> <item> <column columnName="id"><![CDATA[1259]]></column> <column columnName="orderDate"><![CDATA[2019/08/27]]></column> <column columnName="shipDate"><![CDATA[2019/08/27]]></column> <column columnName="dueDate"><![CDATA[2019/09/10]]></column> <column columnName="postingDate"><![CDATA[2019/08/27]]></column> <column columnName="documentDate"><![CDATA[2019/08/27]]></column> <column columnName="totalAmount"><![CDATA[232.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[291.04]]></column> </item> <item> <column columnName="id"><![CDATA[1260]]></column> <column columnName="orderDate"><![CDATA[2019/08/27]]></column> <column columnName="shipDate"><![CDATA[2019/08/27]]></column> <column columnName="dueDate"><![CDATA[2019/09/10]]></column> <column columnName="postingDate"><![CDATA[2019/08/27]]></column> <column columnName="documentDate"><![CDATA[2019/08/27]]></column> <column columnName="totalAmount"><![CDATA[346.51]]></column> <column columnName="totalAmountIncVat"><![CDATA[433.14]]></column> </item> <item> <column columnName="id"><![CDATA[1261]]></column> <column columnName="orderDate"><![CDATA[2019/08/27]]></column> <column columnName="shipDate"><![CDATA[2019/08/27]]></column> <column columnName="dueDate"><![CDATA[2019/09/10]]></column> <column columnName="postingDate"><![CDATA[2019/08/27]]></column> <column columnName="documentDate"><![CDATA[2019/08/27]]></column> <column columnName="totalAmount"><![CDATA[346.51]]></column> <column columnName="totalAmountIncVat"><![CDATA[433.14]]></column> </item> <item> <column columnName="id"><![CDATA[1262]]></column> <column columnName="orderDate"><![CDATA[2019/08/27]]></column> <column columnName="shipDate"><![CDATA[2019/08/27]]></column> <column columnName="dueDate"><![CDATA[2019/09/10]]></column> <column columnName="postingDate"><![CDATA[2019/08/27]]></column> <column columnName="documentDate"><![CDATA[2019/08/27]]></column> <column columnName="totalAmount"><![CDATA[232.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[291.04]]></column> </item> <item> <column columnName="id"><![CDATA[1263]]></column> <column columnName="orderDate"><![CDATA[2019/08/27]]></column> <column columnName="shipDate"><![CDATA[2019/08/27]]></column> <column columnName="dueDate"><![CDATA[2019/09/10]]></column> <column columnName="postingDate"><![CDATA[2019/08/27]]></column> <column columnName="documentDate"><![CDATA[2019/08/27]]></column> <column columnName="totalAmount"><![CDATA[0.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[0.00]]></column> </item> <item> <column columnName="id"><![CDATA[1264]]></column> <column columnName="orderDate"><![CDATA[2019/08/30]]></column> <column columnName="shipDate"><![CDATA[2019/08/30]]></column> <column columnName="dueDate"><![CDATA[2019/09/13]]></column> <column columnName="postingDate"><![CDATA[2019/08/30]]></column> <column columnName="documentDate"><![CDATA[2019/08/30]]></column> <column columnName="totalAmount"><![CDATA[305.59]]></column> <column columnName="totalAmountIncVat"><![CDATA[381.99]]></column> </item> <item> <column columnName="id"><![CDATA[1265]]></column> <column columnName="orderDate"><![CDATA[2019/08/30]]></column> <column columnName="shipDate"><![CDATA[2019/08/30]]></column> <column columnName="dueDate"><![CDATA[2019/09/13]]></column> <column columnName="postingDate"><![CDATA[2019/08/30]]></column> <column columnName="documentDate"><![CDATA[2019/08/30]]></column> <column columnName="totalAmount"><![CDATA[191.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[238.75]]></column> </item> <item> <column columnName="id"><![CDATA[1266]]></column> <column columnName="orderDate"><![CDATA[2019/09/11]]></column> <column columnName="shipDate"><![CDATA[2019/09/11]]></column> <column columnName="dueDate"><![CDATA[2019/09/25]]></column> <column columnName="postingDate"><![CDATA[2019/09/11]]></column> <column columnName="documentDate"><![CDATA[2019/09/11]]></column> <column columnName="totalAmount"><![CDATA[222.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[278.54]]></column> </item> <item> <column columnName="id"><![CDATA[1268]]></column> <column columnName="orderDate"><![CDATA[2019/09/23]]></column> <column columnName="shipDate"><![CDATA[2019/09/23]]></column> <column columnName="dueDate"><![CDATA[2019/10/07]]></column> <column columnName="postingDate"><![CDATA[2019/09/23]]></column> <column columnName="documentDate"><![CDATA[2019/09/23]]></column> <column columnName="totalAmount"><![CDATA[1,952.77]]></column> <column columnName="totalAmountIncVat"><![CDATA[2,440.96]]></column> </item> <item> <column columnName="id"><![CDATA[1269]]></column> <column columnName="orderDate"><![CDATA[2019/09/23]]></column> <column columnName="shipDate"><![CDATA[2019/09/23]]></column> <column columnName="dueDate"><![CDATA[2019/10/07]]></column> <column columnName="postingDate"><![CDATA[2019/09/23]]></column> <column columnName="documentDate"><![CDATA[2019/09/23]]></column> <column columnName="totalAmount"><![CDATA[191.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[238.75]]></column> </item> <item> <column columnName="id"><![CDATA[1270]]></column> <column columnName="orderDate"><![CDATA[2019/09/23]]></column> <column columnName="shipDate"><![CDATA[2019/09/23]]></column> <column columnName="dueDate"><![CDATA[2019/10/07]]></column> <column columnName="postingDate"><![CDATA[2019/09/23]]></column> <column columnName="documentDate"><![CDATA[2019/09/23]]></column> <column columnName="totalAmount"><![CDATA[191.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[238.75]]></column> </item> <item> <column columnName="id"><![CDATA[1271]]></column> <column columnName="orderDate"><![CDATA[2019/09/23]]></column> <column columnName="shipDate"><![CDATA[2019/09/23]]></column> <column columnName="dueDate"><![CDATA[2019/10/07]]></column> <column columnName="postingDate"><![CDATA[2019/09/23]]></column> <column columnName="documentDate"><![CDATA[2019/09/23]]></column> <column columnName="totalAmount"><![CDATA[191.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[238.75]]></column> </item> <item> <column columnName="id"><![CDATA[1272]]></column> <column columnName="orderDate"><![CDATA[2019/10/10]]></column> <column columnName="shipDate"><![CDATA[2019/10/10]]></column> <column columnName="dueDate"><![CDATA[2019/10/24]]></column> <column columnName="postingDate"><![CDATA[2019/10/10]]></column> <column columnName="documentDate"><![CDATA[2019/10/10]]></column> <column columnName="totalAmount"><![CDATA[1,005.63]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,257.04]]></column> </item> <item> <column columnName="id"><![CDATA[1273]]></column> <column columnName="orderDate"><![CDATA[2019/10/10]]></column> <column columnName="shipDate"><![CDATA[2019/10/10]]></column> <column columnName="dueDate"><![CDATA[2019/10/24]]></column> <column columnName="postingDate"><![CDATA[2019/10/10]]></column> <column columnName="documentDate"><![CDATA[2019/10/10]]></column> <column columnName="totalAmount"><![CDATA[203.71]]></column> <column columnName="totalAmountIncVat"><![CDATA[254.64]]></column> </item> <item> <column columnName="id"><![CDATA[1274]]></column> <column columnName="orderDate"><![CDATA[2019/10/10]]></column> <column columnName="shipDate"><![CDATA[2019/10/10]]></column> <column columnName="dueDate"><![CDATA[2019/10/24]]></column> <column columnName="postingDate"><![CDATA[2019/10/10]]></column> <column columnName="documentDate"><![CDATA[2019/10/10]]></column> <column columnName="totalAmount"><![CDATA[650.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[813.68]]></column> </item> <item> <column columnName="id"><![CDATA[1275]]></column> <column columnName="orderDate"><![CDATA[2019/10/10]]></column> <column columnName="shipDate"><![CDATA[2019/10/10]]></column> <column columnName="dueDate"><![CDATA[2019/10/24]]></column> <column columnName="postingDate"><![CDATA[2019/10/10]]></column> <column columnName="documentDate"><![CDATA[2019/10/10]]></column> <column columnName="totalAmount"><![CDATA[1,005.63]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,257.04]]></column> </item> <item> <column columnName="id"><![CDATA[1276]]></column> <column columnName="orderDate"><![CDATA[2019/10/10]]></column> <column columnName="shipDate"><![CDATA[2019/10/10]]></column> <column columnName="dueDate"><![CDATA[2019/10/24]]></column> <column columnName="postingDate"><![CDATA[2019/10/10]]></column> <column columnName="documentDate"><![CDATA[2019/10/10]]></column> <column columnName="totalAmount"><![CDATA[1,441.34]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,801.68]]></column> </item> <item> <column columnName="id"><![CDATA[1277]]></column> <column columnName="orderDate"><![CDATA[2019/10/23]]></column> <column columnName="shipDate"><![CDATA[2019/10/23]]></column> <column columnName="dueDate"><![CDATA[2019/11/06]]></column> <column columnName="postingDate"><![CDATA[2019/10/23]]></column> <column columnName="documentDate"><![CDATA[2019/10/23]]></column> <column columnName="totalAmount"><![CDATA[650.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[813.68]]></column> </item> <item> <column columnName="id"><![CDATA[1278]]></column> <column columnName="orderDate"><![CDATA[2019/10/23]]></column> <column columnName="shipDate"><![CDATA[2019/10/23]]></column> <column columnName="dueDate"><![CDATA[2019/11/06]]></column> <column columnName="postingDate"><![CDATA[2019/10/23]]></column> <column columnName="documentDate"><![CDATA[2019/10/23]]></column> <column columnName="totalAmount"><![CDATA[222.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[278.54]]></column> </item> <item> <column columnName="id"><![CDATA[1279]]></column> <column columnName="orderDate"><![CDATA[2019/10/23]]></column> <column columnName="shipDate"><![CDATA[2019/10/23]]></column> <column columnName="dueDate"><![CDATA[2019/11/06]]></column> <column columnName="postingDate"><![CDATA[2019/10/23]]></column> <column columnName="documentDate"><![CDATA[2019/10/23]]></column> <column columnName="totalAmount"><![CDATA[650.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[813.68]]></column> </item> <item> <column columnName="id"><![CDATA[1280]]></column> <column columnName="orderDate"><![CDATA[2019/10/23]]></column> <column columnName="shipDate"><![CDATA[2019/10/23]]></column> <column columnName="dueDate"><![CDATA[2019/11/06]]></column> <column columnName="postingDate"><![CDATA[2019/10/23]]></column> <column columnName="documentDate"><![CDATA[2019/10/23]]></column> <column columnName="totalAmount"><![CDATA[222.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[278.54]]></column> </item> <item> <column columnName="id"><![CDATA[1281]]></column> <column columnName="orderDate"><![CDATA[2019/10/23]]></column> <column columnName="shipDate"><![CDATA[2019/10/23]]></column> <column columnName="dueDate"><![CDATA[2019/11/06]]></column> <column columnName="postingDate"><![CDATA[2019/10/23]]></column> <column columnName="documentDate"><![CDATA[2019/10/23]]></column> <column columnName="totalAmount"><![CDATA[1,005.63]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,257.04]]></column> </item> <item> <column columnName="id"><![CDATA[1282]]></column> <column columnName="orderDate"><![CDATA[2019/10/23]]></column> <column columnName="shipDate"><![CDATA[2019/10/23]]></column> <column columnName="dueDate"><![CDATA[2019/11/06]]></column> <column columnName="postingDate"><![CDATA[2019/10/23]]></column> <column columnName="documentDate"><![CDATA[2019/10/23]]></column> <column columnName="totalAmount"><![CDATA[1,301.89]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,627.36]]></column> </item> <item> <column columnName="id"><![CDATA[1283]]></column> <column columnName="orderDate"><![CDATA[2019/10/23]]></column> <column columnName="shipDate"><![CDATA[2019/10/23]]></column> <column columnName="dueDate"><![CDATA[2019/11/06]]></column> <column columnName="postingDate"><![CDATA[2019/10/23]]></column> <column columnName="documentDate"><![CDATA[2019/10/23]]></column> <column columnName="totalAmount"><![CDATA[55.17]]></column> <column columnName="totalAmountIncVat"><![CDATA[68.96]]></column> </item> <item> <column columnName="id"><![CDATA[1284]]></column> <column columnName="orderDate"><![CDATA[2019/10/23]]></column> <column columnName="shipDate"><![CDATA[2019/10/23]]></column> <column columnName="dueDate"><![CDATA[2019/11/06]]></column> <column columnName="postingDate"><![CDATA[2019/10/23]]></column> <column columnName="documentDate"><![CDATA[2019/10/23]]></column> <column columnName="totalAmount"><![CDATA[222.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[278.54]]></column> </item> <item> <column columnName="id"><![CDATA[1285]]></column> <column columnName="orderDate"><![CDATA[2019/10/24]]></column> <column columnName="shipDate"><![CDATA[2019/10/24]]></column> <column columnName="dueDate"><![CDATA[2019/11/07]]></column> <column columnName="postingDate"><![CDATA[2019/10/24]]></column> <column columnName="documentDate"><![CDATA[2019/10/24]]></column> <column columnName="totalAmount"><![CDATA[650.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[813.68]]></column> </item> <item> <column columnName="id"><![CDATA[1288]]></column> <column columnName="orderDate"><![CDATA[2019/10/25]]></column> <column columnName="shipDate"><![CDATA[2019/10/25]]></column> <column columnName="dueDate"><![CDATA[2019/11/08]]></column> <column columnName="postingDate"><![CDATA[2019/10/25]]></column> <column columnName="documentDate"><![CDATA[2019/10/25]]></column> <column columnName="totalAmount"><![CDATA[870.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,088.68]]></column> </item> <item> <column columnName="id"><![CDATA[1289]]></column> <column columnName="orderDate"><![CDATA[2019/10/25]]></column> <column columnName="shipDate"><![CDATA[2019/10/25]]></column> <column columnName="dueDate"><![CDATA[2019/11/08]]></column> <column columnName="postingDate"><![CDATA[2019/10/25]]></column> <column columnName="documentDate"><![CDATA[2019/10/25]]></column> <column columnName="totalAmount"><![CDATA[921.80]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,152.25]]></column> </item> <item> <column columnName="id"><![CDATA[1290]]></column> <column columnName="orderDate"><![CDATA[2019/10/28]]></column> <column columnName="shipDate"><![CDATA[2019/10/28]]></column> <column columnName="dueDate"><![CDATA[2019/11/11]]></column> <column columnName="postingDate"><![CDATA[2019/10/28]]></column> <column columnName="documentDate"><![CDATA[2019/10/28]]></column> <column columnName="totalAmount"><![CDATA[616.92]]></column> <column columnName="totalAmountIncVat"><![CDATA[771.15]]></column> </item> <item> <column columnName="id"><![CDATA[1297]]></column> <column columnName="orderDate"><![CDATA[2019/11/22]]></column> <column columnName="shipDate"><![CDATA[2019/11/22]]></column> <column columnName="dueDate"><![CDATA[2019/12/06]]></column> <column columnName="postingDate"><![CDATA[2019/11/22]]></column> <column columnName="documentDate"><![CDATA[2019/11/22]]></column> <column columnName="totalAmount"><![CDATA[3,880.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[4,850.00]]></column> </item> <item> <column columnName="id"><![CDATA[1298]]></column> <column columnName="orderDate"><![CDATA[2019/07/03]]></column> <column columnName="shipDate"><![CDATA[2019/07/03]]></column> <column columnName="dueDate"><![CDATA[2019/07/17]]></column> <column columnName="postingDate"><![CDATA[2019/07/03]]></column> <column columnName="documentDate"><![CDATA[2019/07/03]]></column> <column columnName="totalAmount"><![CDATA[3,880.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[4,850.00]]></column> </item> <item> <column columnName="id"><![CDATA[1299]]></column> <column columnName="orderDate"><![CDATA[2019/11/22]]></column> <column columnName="shipDate"><![CDATA[2019/11/22]]></column> <column columnName="dueDate"><![CDATA[2019/12/06]]></column> <column columnName="postingDate"><![CDATA[2019/11/22]]></column> <column columnName="documentDate"><![CDATA[2019/11/22]]></column> <column columnName="totalAmount"><![CDATA[3,880.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[4,850.00]]></column> </item> <item> <column columnName="id"><![CDATA[1300]]></column> <column columnName="orderDate"><![CDATA[2019/11/22]]></column> <column columnName="shipDate"><![CDATA[2019/11/22]]></column> <column columnName="dueDate"><![CDATA[2019/12/06]]></column> <column columnName="postingDate"><![CDATA[2019/11/22]]></column> <column columnName="documentDate"><![CDATA[2019/11/22]]></column> <column columnName="totalAmount"><![CDATA[50.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[62.50]]></column> </item> <item> <column columnName="id"><![CDATA[1301]]></column> <column columnName="orderDate"><![CDATA[2019/11/22]]></column> <column columnName="shipDate"><![CDATA[2019/11/22]]></column> <column columnName="dueDate"><![CDATA[2019/12/06]]></column> <column columnName="postingDate"><![CDATA[2019/11/22]]></column> <column columnName="documentDate"><![CDATA[2019/11/22]]></column> <column columnName="totalAmount"><![CDATA[15.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[18.75]]></column> </item> <item> <column columnName="id"><![CDATA[1302]]></column> <column columnName="orderDate"><![CDATA[2019/11/22]]></column> <column columnName="shipDate"><![CDATA[2019/11/22]]></column> <column columnName="dueDate"><![CDATA[2019/12/06]]></column> <column columnName="postingDate"><![CDATA[2019/11/22]]></column> <column columnName="documentDate"><![CDATA[2019/11/22]]></column> <column columnName="totalAmount"><![CDATA[7,810.00]]></column> <column columnName="totalAmountIncVat"><![CDATA[9,762.50]]></column> </item> <item> <column columnName="id"><![CDATA[1303]]></column> <column columnName="orderDate"><![CDATA[2019/11/26]]></column> <column columnName="shipDate"><![CDATA[2019/11/26]]></column> <column columnName="dueDate"><![CDATA[2019/12/10]]></column> <column columnName="postingDate"><![CDATA[2019/11/26]]></column> <column columnName="documentDate"><![CDATA[2019/11/26]]></column> <column columnName="totalAmount"><![CDATA[831.99]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,039.99]]></column> </item> <item> <column columnName="id"><![CDATA[1304]]></column> <column columnName="orderDate"><![CDATA[2019/12/02]]></column> <column columnName="shipDate"><![CDATA[2019/12/02]]></column> <column columnName="dueDate"><![CDATA[2019/12/16]]></column> <column columnName="postingDate"><![CDATA[2019/12/02]]></column> <column columnName="documentDate"><![CDATA[2019/12/02]]></column> <column columnName="totalAmount"><![CDATA[1,157.55]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,446.94]]></column> </item> <item> <column columnName="id"><![CDATA[1305]]></column> <column columnName="orderDate"><![CDATA[2019/12/03]]></column> <column columnName="shipDate"><![CDATA[2019/12/03]]></column> <column columnName="dueDate"><![CDATA[2019/12/17]]></column> <column columnName="postingDate"><![CDATA[2019/12/03]]></column> <column columnName="documentDate"><![CDATA[2019/12/03]]></column> <column columnName="totalAmount"><![CDATA[1,157.55]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,446.94]]></column> </item> <item> <column columnName="id"><![CDATA[1306]]></column> <column columnName="orderDate"><![CDATA[2019/12/04]]></column> <column columnName="shipDate"><![CDATA[2019/12/04]]></column> <column columnName="dueDate"><![CDATA[2019/12/18]]></column> <column columnName="postingDate"><![CDATA[2019/12/04]]></column> <column columnName="documentDate"><![CDATA[2019/12/04]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[1307]]></column> <column columnName="orderDate"><![CDATA[2019/12/09]]></column> <column columnName="shipDate"><![CDATA[2019/12/09]]></column> <column columnName="dueDate"><![CDATA[2019/12/23]]></column> <column columnName="postingDate"><![CDATA[2019/12/09]]></column> <column columnName="documentDate"><![CDATA[2019/12/09]]></column> <column columnName="totalAmount"><![CDATA[337.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[421.76]]></column> </item> <item> <column columnName="id"><![CDATA[1308]]></column> <column columnName="orderDate"><![CDATA[2019/12/09]]></column> <column columnName="shipDate"><![CDATA[2019/12/09]]></column> <column columnName="dueDate"><![CDATA[2019/12/23]]></column> <column columnName="postingDate"><![CDATA[2019/12/09]]></column> <column columnName="documentDate"><![CDATA[2019/12/09]]></column> <column columnName="totalAmount"><![CDATA[232.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[291.04]]></column> </item> <item> <column columnName="id"><![CDATA[1312]]></column> <column columnName="orderDate"><![CDATA[2019/12/10]]></column> <column columnName="shipDate"><![CDATA[2019/12/10]]></column> <column columnName="dueDate"><![CDATA[2019/12/24]]></column> <column columnName="postingDate"><![CDATA[2019/12/10]]></column> <column columnName="documentDate"><![CDATA[2019/12/10]]></column> <column columnName="totalAmount"><![CDATA[337.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[421.76]]></column> </item> <item> <column columnName="id"><![CDATA[1313]]></column> <column columnName="orderDate"><![CDATA[2019/12/10]]></column> <column columnName="shipDate"><![CDATA[2019/12/10]]></column> <column columnName="dueDate"><![CDATA[2019/12/24]]></column> <column columnName="postingDate"><![CDATA[2019/12/10]]></column> <column columnName="documentDate"><![CDATA[2019/12/10]]></column> <column columnName="totalAmount"><![CDATA[232.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[291.04]]></column> </item> <item> <column columnName="id"><![CDATA[1314]]></column> <column columnName="orderDate"><![CDATA[2019/12/10]]></column> <column columnName="shipDate"><![CDATA[2019/12/10]]></column> <column columnName="dueDate"><![CDATA[2019/12/24]]></column> <column columnName="postingDate"><![CDATA[2019/12/10]]></column> <column columnName="documentDate"><![CDATA[2019/12/10]]></column> <column columnName="totalAmount"><![CDATA[337.41]]></column> <column columnName="totalAmountIncVat"><![CDATA[421.76]]></column> </item> <item> <column columnName="id"><![CDATA[1315]]></column> <column columnName="orderDate"><![CDATA[2019/12/10]]></column> <column columnName="shipDate"><![CDATA[2019/12/10]]></column> <column columnName="dueDate"><![CDATA[2019/12/24]]></column> <column columnName="postingDate"><![CDATA[2019/12/10]]></column> <column columnName="documentDate"><![CDATA[2019/12/10]]></column> <column columnName="totalAmount"><![CDATA[232.83]]></column> <column columnName="totalAmountIncVat"><![CDATA[291.04]]></column> </item> <item> <column columnName="id"><![CDATA[1316]]></column> <column columnName="orderDate"><![CDATA[2019/12/12]]></column> <column columnName="shipDate"><![CDATA[2019/12/12]]></column> <column columnName="dueDate"><![CDATA[2019/12/26]]></column> <column columnName="postingDate"><![CDATA[2019/12/12]]></column> <column columnName="documentDate"><![CDATA[2019/12/12]]></column> <column columnName="totalAmount"><![CDATA[666.68]]></column> <column columnName="totalAmountIncVat"><![CDATA[833.35]]></column> </item> <item> <column columnName="id"><![CDATA[1317]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[1319]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[1320]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[1321]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[1322]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[1323]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[1324]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[1325]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[1326]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[1327]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[1330]]></column> <column columnName="orderDate"><![CDATA[2019/12/19]]></column> <column columnName="shipDate"><![CDATA[2019/12/19]]></column> <column columnName="dueDate"><![CDATA[2020/01/02]]></column> <column columnName="postingDate"><![CDATA[2019/12/19]]></column> <column columnName="documentDate"><![CDATA[2019/12/19]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> <item> <column columnName="id"><![CDATA[1342]]></column> <column columnName="orderDate"><![CDATA[2020/01/20]]></column> <column columnName="shipDate"><![CDATA[2020/01/20]]></column> <column columnName="dueDate"><![CDATA[2020/02/03]]></column> <column columnName="postingDate"><![CDATA[2020/01/20]]></column> <column columnName="documentDate"><![CDATA[2020/01/20]]></column> <column columnName="totalAmount"><![CDATA[1,171.70]]></column> <column columnName="totalAmountIncVat"><![CDATA[1,464.63]]></column> </item> <item> <column columnName="id"><![CDATA[1345]]></column> <column columnName="orderDate"><![CDATA[2020/02/13]]></column> <column columnName="shipDate"><![CDATA[2020/02/13]]></column> <column columnName="dueDate"><![CDATA[2020/02/27]]></column> <column columnName="postingDate"><![CDATA[2020/02/13]]></column> <column columnName="documentDate"><![CDATA[2020/02/13]]></column> <column columnName="totalAmount"><![CDATA[660.94]]></column> <column columnName="totalAmountIncVat"><![CDATA[826.18]]></column> </item> </Items> <!--Paged open orders--> <?xml version="1.0" encoding="utf-16"?> <Items type="OpenOrder" totalCount="213" version="1.2.0.6_NAV11.0.19394" url="http://dwis-nav2018:443/DynamicsNAV110/WS/CRONUS%20Danmark%20A%2FS/Codeunit/DWWebService"> <item> <column columnName="id"><![CDATA[101017]]></column> <column columnName="orderDate"><![CDATA[2019/01/25]]></column> <column columnName="shipDate"><![CDATA[2019/01/25]]></column> <column columnName="dueDate"><![CDATA[2019/02/08]]></column> <column columnName="postingDate"><![CDATA[2019/01/25]]></column> <column columnName="documentDate"><![CDATA[2019/01/25]]></column> <column columnName="totalAmount"><![CDATA[9,495.90]]></column> <column columnName="totalAmountIncVat"><![CDATA[11,869.88]]></column> </item> </Items>

The GetItem request is sent to the remote system by the Integration Customer Center and is used to request specific orders from the order list requested by GetList.

Standard GetItem request:

XML
<GetItem type="Invoice" customerID="2960" documentNO="SF11598"></GetItem>

Standard GetItem response:

XML
<?xml version="1.0" encoding="utf-8"?> <Items type="Invoice" totalCount="2"> <item> <column columnName="id"><![CDATA[SF11598]]></column> <column columnName="orderDate"><![CDATA[08/26/16]]></column> <column columnName="shipDate"><![CDATA[08/26/16]]></column> <column columnName="dueDate"><![CDATA[09/05/16]]></column> <column columnName="totalAmount"><![CDATA[7.123,55]]></column> <column columnName="totalAmountIncVat"><![CDATA[8.904,44]]></column> </item> <item> <column columnName="id"><![CDATA[SF11599]]></column> <column columnName="orderDate"><![CDATA[08/26/16]]></column> <column columnName="shipDate"><![CDATA[08/26/16]]></column> <column columnName="dueDate"><![CDATA[09/05/16]]></column> <column columnName="totalAmount"><![CDATA[755,00]]></column> <column columnName="totalAmountIncVat"><![CDATA[800,00]]></column> </item> </Items>

When checking the xml that is being generated by the remote system, there are a few details you should be aware of:

  • The EcomOrders and EcomOrderlines values in the "table" properties are expected by the Live Integration Project.
  • If you add columns to either orders or order lines, they will automatically be available via tags in the templates for rendering the items and lists
  • The communication between Dynamicweb and the remote system, and the conversion between the XML generated by the remote system and Dynamicweb tags, is handled by the Live Integration Project, in the internal class IntegrationCustomerCenterHandler - and can be customized there

When you parse the XML to build e.g. a list of files to download you can customize the file name of the downloaded file by adding &filename=invoice234.pdf to the download link. 

Parameter

Value

type

Credit
Invoice
OpenOrder

id

A valid ID of a document

externalUserID

An ID of the user in the remote system

 

Standard request:

XML
<GetPDFForItem type="OpenOrder" id="101001" externalUserID="10000"/>

Standard response:

This request returns a pdf base64 string response - if using the TestTool, the response is automatically opened in a pdf-viewer.

The XML response in the integration customer center can be sorted by adding additional parameters to the request.

The parameters for sorting are sort (direction) and sortByField as in the example below.

XML
<GetList type="Invoice" customerID="1234" requestAmount="10" firstItem="10" sort="asc" sortByField="id"></GetList>

Sort parameter values:

Parameter value Description
asc sorts the response high to low / new to old
desc sorts the response low to high / old to new

If the parameter is not set the ICC defaults to sorting in a descending order.

Sort by field parameter values:

Parameter value Description
id Sort by ID
shipdate Sort by shipping date
duedate Sort by due date
postingdate Sort by posting date
totalamount Sort by amount
totalamountincvat Sort by amount including VAT
documentdate Sort by document date

If the parameter is not set the ICC defaults to sorting by order date.

 

As of version 1.2.0.40 of the Business Central Codeunit, the rounding precisions used by the codeunit to round both order lines and order totals are obtained from the General Ledger and Currency setup in Business Central. This means, that when the Live integration sends an order to Business Central, the following rounding rules are applied:

Orders in the local currency (LCY):

  • Order lines are rounded to the precision defined in General Ledger, Unit-amount rounding precision (LCY)
  • Order totals are rounded to the precision defined in General Ledger, Amount rounding precision (LCY)

Orders in currencies OTHER than LCY:

  • Order lines are rounded to the precision defined for the specific currency in Currencies, Unit-amount rounding precision
  • Order totals are rounded to the precision defined for the specific currency in Currencies, Amount rounding precision