Datanory Production » Datanory - SNEKKU

-- identify the

select * from customer where org_id = 'snekku' and customer_code = '5j005'
--5054BFE6BB454D439FCA9926F2A1CE35
select * from member where org_id = 'goldcrest'

select * from customer where customer_id= '4G009_2'
select * from customer where org_id = 'snekku' and customer_code = '5j005'

select * from customer_at where customer_id= '677BD2CCAC1944BD9E55B7801A290095' order by at_date desc
--------------------------------------------Sales Order--------------------------------------------
select b.customer_code, * from txn_sales_order_header a
inner join customer b on a.customer_id = b.customer_id
where a.org_id = 'snekku'
--and a.member_id = '2c9e40b5f5904775b71192b8fd8b71ad'
and a.customer_id = '677BD2CCAC1944BD9E55B7801A290095'
-- 677BD2CCAC1944BD9E55B7801A290095 different customer-id
order by a.created_date desc
--

--------------------------------------------invoice--------------------------------------------
-- Found in the invoice header
select * from txn_invoice_history_header
where org_id = 'snekku'
and invoice_id = '797842927B274361B62546B47141506E'
order by created_date desc
--------------

select at_date, at_type, * from txn_invoice_history_header_at
where org_id = 'snekku'
and invoice_no = 'IN24/005186' order by created_date desc

--------------------------------------------collection--------------------------------------------

select * from txn_invoice_history_header
where org_id = 'snekku'

and invoice_id = '797842927B274361B62546B47141506E'

select c.customer_code, b.customer_id, b.invoice_no, * from txn_mobile_collection_invoice a
inner join txn_invoice_history_header b on a.inv_id = b.invoice_id
inner join customer c on b.customer_id = c.customer_id
where a.org_id = 'snekku'
and c.customer_id ='5054BFE6BB454D439FCA9926F2A1CE35'

select c.customer_code, * from txn_mobile_collection_header a
inner join txn_mobile_header b on a.txn_id = b.txn_id
inner join customer c on b.customer_id = c.customer_id
where a.org_id = 'snekku' and c.customer_id= '5054BFE6BB454D439FCA9926F2A1CE35'

-- Found collection
select * from txn_mobile_collection_invoice_at
where org_id = 'snekku'

and inv_id= '7548864b-ef29-4337-8856-850a1db183be'

--at_type I
select * from txn_mobile_collection_header_at
where org_id = 'snekku'