Project

General

Profile

Production Ticket(ST) #12277

YAKULT - import this customer list into Datanory Trial Yakult

Added by Rashdan Hussin 2 months ago. Updated 2 months ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Rashdan Hussin
Start date:
22/07/2024
Due date:
24/07/2024
% Done:

100%

Estimated time:
Spent time:
1.00 h
Job Remark:
Ticket Logged Date:
22/07/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
22/07/2024
SLA Delivery:
24/07/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
22/07/2024
Resolution:

1) Check and verify all the data from excel file given.
2) Patch the customer branch based on list given.

Root cause: Customer master data update.

Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:

None

Description

Dear Rashdan,

Please assist to import this customer list into Datanory Trial Yakult. The update is only the Branch change from WB0001 to WC0017

Thanks.

Warm Regards,

Muhamad Kamal Arif Bin Muhamad

Import Customer User Y2270_20240722.xlsx (23.2 KB) Import Customer User Y2270_20240722.xlsx Rashdan Hussin, 22/07/2024 12:21 PM

History

#1 Updated by Rashdan Hussin 2 months ago

  • Status changed from Assigned To to Support In Progress

#2 Updated by Rashdan Hussin 2 months ago

  • Status changed from Support In Progress to Pending Client Verification
  • % Done changed from 0 to 90
  • Actual Initial Response set to 22/07/2024
  • Resolution updated (diff)

select a.branch_id, c.branch_id, * from customer a
inner join #customer_branch b on b.customer_code = a.customer_code
inner join mst_branch c on c.branch_code = b.branch_code and c.org_id = 'A000002'
WHERE a.org_id = 'A000002' and EXISTS (SELECT 1 FROM customer st WHERE b.customer_code = st.customer_code and st.org_id = 'A000002')

--select * into _customer_20240722 from customer

--update a set a.branch_id = c.branch_id, a.updated_date = getdate(), a.updated_by = 'Support'
--from customer a
--inner join #customer_branch b on b.customer_code = a.customer_code
--inner join mst_branch c on c.branch_code = b.branch_code and c.org_id = 'A000002'
--WHERE a.org_id = 'A000002' and EXISTS (SELECT 1 FROM customer st WHERE b.customer_code = st.customer_code and st.org_id = 'A000002')

select a.branch_id, b.branch_id, * from mst_customer_branch a
inner join customer b on b.customer_id = a.customer_id and b.org_id = 'A000002'
inner join #customer_branch c on c.customer_code = b.customer_code and b.org_id = 'A000002'
inner join mst_branch d on d.branch_code = c.branch_code and d.org_id = 'A000002'
WHERE EXISTS (SELECT 1 FROM mst_customer_branch st WHERE st.customer_id = b.customer_id and st.org_id = 'A000002')

--select * into _mst_customer_branch_20240722 from mst_customer_branch

--update a set a.branch_id = d.branch_id, a.updated_date = getdate(), a.updated_by = 'Support'
--from mst_customer_branch a
--inner join customer b on b.customer_id = a.customer_id and b.org_id = 'A000002'
--inner join #customer_branch c on c.customer_code = b.customer_code and b.org_id = 'A000002'
--inner join mst_branch d on d.branch_code = c.branch_code and d.org_id = 'A000002'
--WHERE EXISTS (SELECT 1 FROM mst_customer_branch st WHERE st.customer_id = b.customer_id and st.org_id = 'A000002')

#3 Updated by Rashdan Hussin 2 months ago

  • Status changed from Pending Client Verification to Ticket Resolved
  • % Done changed from 90 to 100

Also available in: Atom PDF