--insert into txn_mobile_collection_detail

select
newid() as [col_dtl_id]
      ,'BB979566-87B6-4356-819B-66CDF723ECC3' as [col_id]
      ,'Cash' as [doc_type]
      ,'Cash' as [doc_no]
      ,'53.00' as [doc_amt]
      ,'2024-02-15'[doc_date]
      ,'0.00' as [doc_unpaid]
      ,'Auto-Approved' as [status]
      ,'' as [remark]
      ,'GOLDCREST' as [org_id]
      ,'GOLDCREST' as [tenant_id]
      ,'2024-02-15' as [created_date]
      ,'dc954dfdc1db4e2aaf9d2759a1522725' as [created_by]
      ,'2024-02-15' as [updated_date]
      ,'dc954dfdc1db4e2aaf9d2759a1522725' as [updated_by]
      ,null as [mobile_remark]
      ,null as [web_remark]
      ,'53.00' as [mobile_paid]
      ,'53.00' as [web_paid]
      ,'' as [bank]
      ,'' as [journal_notation]
      ,'' as [payment_narration]
      ,'' as [temporary_receipt]