Project

General

Profile

Production Ticket(ST) #11981

YAKULT - change the customer type to Credit outlet

Added by Rashdan Hussin 4 months ago. Updated 3 months ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Rashdan Hussin
Start date:
10/06/2024
Due date:
14/06/2024
% Done:

100%

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

1) Patch the customer type from cash to credit outlet based on customer list given

Root cause: Change customer type.

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

None

Description

Dear Rashdan,

Please assist to change the customer type to Credit outlet based on the list in attached file.

Please let me know if you have any questions.

Thanks.

Warm Regards,

Muhamad Kamal Arif Bin Muhamad

Update Customer TYpe (Yakult) 20240606.xlsx (159 KB) Update Customer TYpe (Yakult) 20240606.xlsx Rashdan Hussin, 10/06/2024 11:25 AM

History

#1 Updated by Rashdan Hussin 3 months ago

  • Status changed from Assigned To to Support In Progress

#2 Updated by Rashdan Hussin 3 months ago

  • Status changed from Support In Progress to Ticket Resolved
  • % Done changed from 0 to 100
  • Actual Initial Response set to 10/06/2024
  • Resolution updated (diff)

select * from #temptable

select * from customer where org_id = 'A000002' and customer_code in
(select customer_code from #temptable)

--select * into _customer_20240614 from customer

--update customer set customer_type = 'Credit Outlet'
--where org_id = 'A000002' and customer_code in
--(select customer_code from #temptable)

Also available in: Atom PDF