--insert into txn_mobile_collection_invoice

SELECT newid() as [col_inv_id]
      ,'BB979566-87B6-4356-819B-66CDF723ECC3' as [col_id]
      ,'eed53741-83f5-4255-97eb-542527b46049' as [inv_id]
      ,'' as [receipt_no]
      ,53.00 as[previous_balance]
      ,53.00 as[col_amt]
      ,0.00 as [new_balance]
      ,'Auto-Approved' as [status]
      ,'2024-02-15' as [created_date]
      ,'dc954dfdc1db4e2aaf9d2759a1522725' as [created_by]
      ,'2024-02-15' as [updated_date]
      ,'dc954dfdc1db4e2aaf9d2759a1522725' as [updated_by]
      ,'GOLDCREST' as [org_id]
      ,'GOLDCREST' as [tenant_id]
      ,null as [mobile_remark]
      ,null as [web_remark]
      ,53.00 as[web_paid]
      ,null as [web_new_balance]