SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table txml(id int identity, data xml);
insert into txml (data) values ('
<order>
    <trans DTrans="20170102" HTrans="10:52"></trans>
    <head Id="552665566"></head>
    <lin headId="552665566">
        <dLin Id="00001" CoArt="1111111" CoArtCust="05220001" NameArt="Product1" dateVal="20161115" />
        <acum DCalAcm="20170101" DIniAcm="20161115"><qtyAcm Qty="1101163.00" /></acum>
        <lastOrd Id="95767" QtyLastOrd="12000.00" DLastOrd="20170101" />
        <pLin LType="4"><uni Qty="24000.00"/><dIni Date="20170104"/><dEnd Date="20170108"/></pLin>
        <pLin LType="4"><uni Qty="20000.00"/><dIni Date="20170109"/><dEnd Date="20170112"/></pLin>
        <pLin LType="4"><uni Qty="24000.00"/><dIni Date="20170113"/><dEnd Date="20170116"/></pLin>
    </lin>
    <lin headId="552665566">
        <dLin Id="00002" CoArt="2222222" CoArtCust="05269958" NameArt="Product2" dateVal="20161101" />
        <acum DCalAcm="20170101" DIniAcm="20161101"><qtyAcm Qty="552652.00" /></acum>
       <lastOrd Id="49956" QtyLastOrd="5000.00" DLastOrd="20170101" />
        <pLin LType="4"><uni Qty="2200.00"/><dIni Date="20170104"/><dEnd Date="20170108"/></pLin>
        <pLin LType="4"><uni Qty="3000.00"/><dIni Date="20170109"/><dEnd Date="20170116"/></pLin>
    </lin>
</order>');
1 rows affected

SELECT	data.value('(/order/trans/@DTrans)[1]',	'datetime') DTrans,
	data.value('(/order/trans/@HTrans)[1]',	'varchar(20)') HTrans,
	data.value('(/order/head/@Id)[1]',	'varchar(20)') HeadIded
FROM	txml;


DTrans
HTrans
HeadIded


2017-01-02 00:00:00.000
10:52
552665566


SELECT	T2.lin.value('(./dLin/@Id)[1]',			'int') Id,
	T2.lin.value('(./dLin/@CoArt)[1]',		'varchar(20)') CoArt,
	T2.lin.value('(./dLin/@CoArtCust)[1]',		'varchar(20)') CoArtCust,
	T2.lin.value('(./lastOrd/@Id)[1]',		'varchar(20)') lastOrderId,
	T2.lin.value('(./lastOrd/@QtyLastOrd)[1]',	'decimal(18,2)') QtyLastOrd
FROM	txml
CROSS APPLY data.nodes('/order/lin') as T2(lin)


Id
CoArt
CoArtCust
lastOrderId
QtyLastOrd


1
1111111
05220001
95767
12000.00

2
2222222
05269958
49956
5000.00