Datanory Production

SELECT i.DocNo, CONVERT DocDate, i.DebtorCode, i.SalesAgent, i.SalesLocation, i.Cancelled, i.NetTotal, a.Outstanding
FROM IV i
INNER JOIN ARInvoice a ON a.DocNo = i.DocNo
WHERE i.SalesAgent is not null
and exists (select 1 from IVDTL d where i.DocKey=d.DocKey and isnull(d.ItemCode,'') <> '')
and i.docno ='INWWX000069-240205'

SELECT i.DocNo, CONVERT(VARCHAR, i.DocDate, 25) DocDate, i.DebtorCode, i.SalesAgent, i.SalesLocation, i.Cancelled, i.NetTotal, a.Outstanding 
                FROM IV i 
                INNER JOIN ARInvoice a ON a.DocNo = i.DocNo 
                WHERE i.SalesAgent is not null
        and exists (select 1 from IVDTL d where i.DocKey=d.DocKey and isnull(d.ItemCode,'') <> '')
and i.docno ='I297551'

select at_type,at_date,* from txn_invoice_history_header_at a where org_id ='goldcrest' and invoice_no ='I297551'
order by a.at_date desc
select * from customer where customer_id ='A8DD4BDB6721432D98D27B950F47D0D5'

select invoice_balance,* from txn_invoice_history_header where org_id ='goldcrest' and invoice_no in ('INWWX000069-240205','I297551')
select * into _txn_invoice_history_header20240221 from txn_invoice_history_header ;

select * from txn_invoice_history_header where invoice_no= 'I297551'

update txn_invoice_history_header set invoice_balance=0.00 where invoice_no= 'I297551'

select * from txn_invoice_history_header where invoice_no= 'INWWX000069-240205'

update txn_invoice_history_header set invoice_balance=0.00 where invoice_no= 'INWWX000069-240205'