check_data

--------------- no sales -------------------

select * from "BillingRegister"."BillingRegisterDetails" brd
left outer join "BillingRegister"."SalesRegisters" sr
	on sr."BRDetId" = brd."Id"
aand brd."BillingRegisterTypeId" = 1
and sr."Id" is null


select * from "BillingRegister"."BillingRegisterDetails" brd
where brd."BillingRegisterTypeId" = 1
and "StatusId" = 4
and "Id" not in (select "BillingRegisterId" from "BillingRegister"."SalesRegisters" sr)


select coalesce(replace('2,000', ',', '')::numeric, 0)