select * from member where  member_cd= 'jnm'; -- 7f8c3d45b01d4b948c1372e2c5644762 MemberId
select * from customer where customer_code='301k/156'; --1723B7E255864D7796A299B2CA4E6415 customer-id
select * from  customer_to_user_relation where customer_id='1723B7E255864D7796A299B2CA4E6415'
--9A5046EB-7677-4EDA-8971-88586CA37C67 -- integration APi
 
 select * from di_mobile_txn_collection_header where created_by= '7f8c3d45b01d4b948c1372e2c5644762';
 select * from di_txn_invoice_history  where member_id= '7f8c3d45b01d4b948c1372e2c5644762';

select * from txn_mobile_collection_invoice


select * from 
 



 -- Find invoice Id
 SELECT  

    b.customer_code, 
    b.customer_name, 
    *  
FROM  
    txn_invoice_history_header a 
INNER JOIN  
    customer b ON a.customer_id = b.customer_id 
WHERE  
    a.org_id ='goldcrest'  
    AND customer_code = '301k/156'
    order by a.created_date desc


	-- To get the Collection_id
	SELECT *  
FROM txn_mobile_collection_invoice
WHERE inv_id IN ('14c7824b-eaf7-4e7e-98be-597eaf9489b7',  '27dfb513-fdda-44a1-b92f-4c74ea527158',  '6A7CEFC0C1B04F44AA8F272F152551F4',  'd6be9ff8-da3c-408f-ba07-c46ea1670f2a',  '8B9B0728C83641DFAFC119CCE587B4BB')
order by created_date desc


-- I could not find this collection invoice   
select * from txn_mobile_collection_invoice   WHERE inv_id  ='14c7824b-eaf7-4e7e-98be-597eaf9489b7'

	SELECT *  
FROM txn_mobile_collection_invoice
WHERE inv_id='14c7824b-eaf7-4e7e-98be-597eaf9489b7' 

 

-- collection header
select * from txn_mobile_collection_header where col_id IN ('33acd5b5-0663-4213-bc5b-24b4df727a85', 
                 'f7f75de9-fc87-43f9-95fc-45c7f66fd13c', 
                 '6A7CEFC0C1B04F44AA8F272F152551F4', 
                 '639592ef-7488-48ba-a14a-1c7025f7e39c', 
                 '4ccebc1a-ae61-46bd-b0c8-128a9cecfbfd',
                 '38cef976-84b8-4f15-b05f-1a7c63313f7e') order by created_date desc

-- get the collection detail                                                                                                                                      
SELECT * 
FROM txn_mobile_collection_detail 
WHERE col_id IN ('33acd5b5-0663-4213-bc5b-24b4df727a85', 
                 'f7f75de9-fc87-43f9-95fc-45c7f66fd13c', 
                 '6A7CEFC0C1B04F44AA8F272F152551F4', 
                 '639592ef-7488-48ba-a14a-1c7025f7e39c', 
                 '4ccebc1a-ae61-46bd-b0c8-128a9cecfbfd',
                 '38cef976-84b8-4f15-b05f-1a7c63313f7e') order by created_date desc