select
ctl.unit_selling_price UNIT_SELLING_PRICE --出库单价,是含税的
,ctl.extended_amount out_amount --出库金额,是含税的
,ct.trx_number --事务单号
,ct.trx_date --业务日期
,ctl.*
from ra_customer_trx_lines_ALL ctl
LEFT JOIN ra_customer_trx_ALL ct
ON ctl.customer_trx_id=ct.customer_trx_id
where ctl.interface_line_attribute6=456719 --订单行line_id
![](https://img2024.cnblogs.com/blog/35695/202502/35695-20250207193659673-708765730.jpg)