Datanory Production » Datanory - GOLDCREST

select * from customer where org_id='goldcrest'
and customer_Code like '%302k/249%'

select * from member where member_id in (
select user_id from customer_to_user_relation where customer_id='B259C55B83A44CF3936C2014B282B2E7'
)

select * into DMS_Ecosystem_Backup_Table.dbo.txn_credit_note_history_detail_20240525 from txn_credit_note_history_detail where credit_note_id='e093463b-7f33-485a-ae88-d043db70478b'
select * into DMS_Ecosystem_Backup_Table.dbo.txn_credit_note_history_header_20240525 from txn_credit_note_history_header where credit_note_no ='CNWWV000002-231214' and org_id='goldcrest'

select * into DMS_Ecosystem_Backup_Table.dbo.txn_invoice_history_detail_20240525 from txn_invoice_history_detail where invoice_id='40330f25-a81c-42a0-ad55-7d8e03bf8c42'
select * into DMS_Ecosystem_Backup_Table.dbo.txn_invoice_history_header_20240525 from txn_invoice_history_header where customer_id='B259C55B83A44CF3936C2014B282B2E7' and invoice_no='INWWV000002-231214'
and invoice_id='40330f25-a81c-42a0-ad55-7d8e03bf8c42' and org_id='goldcrest'

select * from txn_credit_note_history_detail where credit_note_id='e093463b-7f33-485a-ae88-d043db70478b'
select * from txn_credit_note_history_header where credit_note_no ='CNWWV000002-231214'

select * from txn_invoice_history_detail where invoice_id='40330f25-a81c-42a0-ad55-7d8e03bf8c42'
select * from txn_invoice_history_header where customer_id='B259C55B83A44CF3936C2014B282B2E7' and invoice_no='INWWV000002-231214'
and invoice_id='40330f25-a81c-42a0-ad55-7d8e03bf8c42'

--delete from txn_credit_note_history_detail where credit_note_id='e093463b-7f33-485a-ae88-d043db70478b'
--delete from txn_credit_note_history_header where credit_note_no ='CNWWV000002-231214'

--delete from txn_invoice_history_detail where invoice_id='40330f25-a81c-42a0-ad55-7d8e03bf8c42'
--delete from txn_invoice_history_header where customer_id='B259C55B83A44CF3936C2014B282B2E7' and invoice_no='INWWV000002-231214'
--and invoice_id='40330f25-a81c-42a0-ad55-7d8e03bf8c42'

None