Datanory Production

select * from customer_to_user_relation where org_id ='goldcrest' and customer_id ='ED483C94E57547999580783F57F69F9A'

select * from customer where customer_code ='301R/021'

select * from member where member_id ='afa9160a6eff4963b8a8bb53322f8d57'

select * from di_RoutePlan_import where process_id ='b36a7a30-280a-46d3-b269-acc153aa2532'

select a.* into di_RoutePlan_import_JB_GC_20231114
from di_RoutePlan_import a
left join member b on a.member_code = b.member_cd and a.org_id=b.org_id
left join customer c on a.customer_code=c.customer_code and a.org_id=c.org_id
where a.process_id = 'b36a7a30-280a-46d3-b269-acc153aa2532' and a.org_id='goldcrest'
and not exists (
select 1 from customer_to_user_relation rel where a.date between rel.start_date and end_date
and rel.customer_id=c.customer_id and rel.user_id=b.member_id
)

select * from di_RoutePlan_import_JB_GC_20231114
 order by at_datetime desc

select b.customer_code as JB_Route_Import_Customer_Code,b.member_code as JB_Route_Import_Salesman_Code,a.PERSON_IN_CHARGE as PIC_IN_AUTOCOUNT_INTEGRATION_TABLE,date,error_message,b.created_date from stg_accounting_import_customer a
inner join di_RoutePlan_import_JB_GC_20231114 b on a.CUSTOMER_CODE = b.customer_code

attached is the file after massage

Find out, not able to import due to data issues. It includes duplication and no customer relation to user. Escalate back to user to further advise.