Project

General

Profile

Actions
Copy link

Feature #13

open

CR - Customer Personal Data & Subscription Data Upload (Unilever)

Added by Andi Malik Rizki Maula 10 months ago. Updated 9 months ago.

Status:
New
Priority:
Normal
Assignee:
anang ahmadi
Start date:
12/19/2025
Due date:
% Done:

0%

Estimated time:

Files

Download all files
VO-BDI-Customer Data Import_object_v1.2.docx (1.7 MB) VO-BDI-Customer Data Import_object_v1.2.docx nurangky augustine, 12/19/2025 08:54 AM
Template create customer Unilever v1 JATIS.xlsx (17.9 KB) Template create customer Unilever v1 JATIS.xlsx nurangky augustine, 12/19/2025 08:58 AM
cr-unilever-v20251219-001-6c96f21.zip (126 MB) cr-unilever-v20251219-001-6c96f21.zip Objects & scripts - cr-unilever/v20251219-001-6c96f21 Andi Malik Rizki Maula, 12/19/2025 08:59 AM
Template_trx_ut_transactions_v1.0 JATIS.xlsx (11.5 KB) Template_trx_ut_transactions_v1.0 JATIS.xlsx nurangky augustine, 12/19/2025 09:08 AM
Test Script Upload.xlsx (77.9 KB) Test Script Upload.xlsx nurangky augustine, 12/19/2025 09:59 AM
Upload Data Customer.xlsx (169 KB) Upload Data Customer.xlsx nurangky augustine, 12/20/2025 12:44 PM
Upload 1000 Transaction Subs 1.xlsx (2.4 MB) Upload 1000 Transaction Subs 1.xlsx nurangky augustine, 12/20/2025 12:44 PM
Upload 1000 Transaction Subs 2.xlsx (2.4 MB) Upload 1000 Transaction Subs 2.xlsx nurangky augustine, 12/20/2025 12:44 PM
Template create customer Unilever v1 JATIS EDITED.xlsx (13.2 KB) Template create customer Unilever v1 JATIS EDITED.xlsx anggito tantyo, 12/22/2025 03:45 AM
Template create customer Unilever v1 JATIS EDITED (1).xlsx (13.2 KB) Template create customer Unilever v1 JATIS EDITED (1).xlsx anggito tantyo, 12/22/2025 03:59 AM
Template create customer Unilever v1 JATIS EDITED_.xlsx (13.2 KB) Template create customer Unilever v1 JATIS EDITED_.xlsx kevin krisandi, 12/22/2025 04:00 AM
Template create customer Unilever v1 JATIS EDITED 2.xlsx (13.2 KB) Template create customer Unilever v1 JATIS EDITED 2.xlsx anggito tantyo, 12/22/2025 06:19 AM
Template create customer Unilever v1 JATIS EDITED 2_.xlsx (13.2 KB) Template create customer Unilever v1 JATIS EDITED 2_.xlsx kevin krisandi, 12/22/2025 06:45 AM
MST_TRX_SUMMARY.xlsx (30 KB) MST_TRX_SUMMARY.xlsx anggito tantyo, 12/22/2025 10:39 AM
cr-unilever-v20251222-001-ec5e961.zip (126 MB) cr-unilever-v20251222-001-ec5e961.zip cr-unilever/v20251222-001-ec5e961 Andi Malik Rizki Maula, 12/22/2025 11:26 AM
Upload Data Customer (2).xlsx (202 KB) Upload Data Customer (2).xlsx aron nigel, 12/29/2025 02:50 AM
583.docx (952 KB) 583.docx aron nigel, 12/29/2025 02:50 AM
cr-unilever-v20251229-001-972cf91.zip (126 MB) cr-unilever-v20251229-001-972cf91.zip cr-unilever/uat-prod/v20251229-001-972cf91 Andi Malik Rizki Maula, 12/29/2025 06:08 AM
cr-unilever-v20251229-002-64ff20a.zip (216 MB) cr-unilever-v20251229-002-64ff20a.zip cr-unilever/v20251229-002-64ff20a Andi Malik Rizki Maula, 12/29/2025 11:25 AM
cr-unilever-v20260106-001-048bc4c.zip (126 MB) cr-unilever-v20260106-001-048bc4c.zip cr-unilever/v20260106-001-048bc4c Andi Malik Rizki Maula, 01/06/2026 09:58 AM
cr-unilever-v20260107-001-bd6e061.zip (126 MB) cr-unilever-v20260107-001-bd6e061.zip cr-unilever/v20260107-001-bd6e061 Andi Malik Rizki Maula, 01/07/2026 09:40 AM
cr-unilever-v20260108-001-935dbde.zip (126 MB) cr-unilever-v20260108-001-935dbde.zip cr-unilever/v20260108-001-935dbde Andi Malik Rizki Maula, 01/08/2026 10:22 AM
cr-unilever-v20260109-001-38b39b1.zip (126 MB) cr-unilever-v20260109-001-38b39b1.zip cr-unilever/v20260109-001-38b39b1 Andi Malik Rizki Maula, 01/09/2026 08:10 AM
cr-unilever-v20260109-003-1087768.zip (126 MB) cr-unilever-v20260109-003-1087768.zip cr-unilever/v20260109-003-1087768 Andi Malik Rizki Maula, 01/09/2026 12:05 PM
cr-unilever-v20260109-004-068b51d.zip (126 MB) cr-unilever-v20260109-004-068b51d.zip cr-unilever/v20260109-004-068b51d Andi Malik Rizki Maula, 01/09/2026 01:21 PM
cr-unilever-full-20260114-001.zip (216 MB) cr-unilever-full-20260114-001.zip cr-unilever-full-20260114-001 Andi Malik Rizki Maula, 01/14/2026 10:46 AM
cr-unilever-full-20260119-001.zip (216 MB) cr-unilever-full-20260119-001.zip cr-unilever-full-20260119-001 Andi Malik Rizki Maula, 01/19/2026 07:34 AM
patch_invacc_pledgestatus_yes_trxtype25_partialredm_exclude_one_product.sql (2.95 KB) patch_invacc_pledgestatus_yes_trxtype25_partialredm_exclude_one_product.sql patch transaksi liquidation Aji Wibowo, 01/28/2026 04:03 AM
Actions
Copy link
 #5

Updated by nurangky augustine 10 months ago

  • File Test Script Upload.xlsx added
Actions
Copy link
 #7

Updated by nurangky augustine 10 months ago

  • File deleted (Test Script Upload.xlsx)
Actions
Copy link
 #12

Updated by Andi Malik Rizki Maula 10 months ago

  • File cr-unilever-v20251222-001-27f6317.zip added
Actions
Copy link
 #13

Updated by Andi Malik Rizki Maula 10 months ago

  • Private changed from No to Yes
Actions
Copy link
 #14

Updated by Andi Malik Rizki Maula 10 months ago

  • Private changed from Yes to No
Actions
Copy link
 #17

Updated by Andi Malik Rizki Maula 10 months ago

  • File cr-unilever-v20251222-002-e3a7871.zip added
Actions
Copy link
 #18

Updated by Andi Malik Rizki Maula 10 months ago

  • File deleted (cr-unilever-v20251222-002-e3a7871.zip)
Actions
Copy link
 #19

Updated by Andi Malik Rizki Maula 10 months ago

  • File deleted (cr-unilever-v20251222-001-27f6317.zip)
Actions
Copy link
 #21

Updated by Andi Malik Rizki Maula 10 months ago · Edited

Version:

  • cr-unilever/v20251222-001-ec5e961

Scripts:

  • [ddl] scripts/ddl-dml/01_ddl_table_changes.sql
  • [dml] scripts/ddl-dml/02_dml_modules.sql

Objects:

  • objects/avt/avantrade-web-sellingagent.zip

Notes:

  • DDL for FILE_UPLOAD_ID column in TRX_CUSTOMER_PERSONAL_UPLOAD_DETAILS table.
  • DML for MST_TRX_SUMMARY FILE_LOCATION update.
  • Fixed logic for setting questionnaire_id, question_id, and answer_id.
  • Fixed DOB spouse validation.
Actions
Copy link
 #23

Updated by Andi Malik Rizki Maula 10 months ago

Version:

  • cr-unilever/uat-prod/v20251229-001-972cf91

Objects:

  • objects/avt/avantrade-web-sellingagent.zip

Notes:

  • CIF number validation fixes.
Actions
Copy link
 #24

Updated by Andi Malik Rizki Maula 10 months ago

Version:

  • cr-unilever/v20251229-002-64ff20a

Objects:

  • objects/avt/avantrade-web-sellingagent.zip
  • objects/avt/birt.zip

Notes:

  • CIF number validation fixes.
  • Take out generated investment account from CIF upload in SID registration report.
Actions
Copy link
 #25

Updated by Andi Malik Rizki Maula 9 months ago

Version:

  • cr-unilever/v20260106-001-048bc4c

Objects:

  • objects/avt/avantrade-web-sellingagent.zip

Notes:

  • FSIDMMA-588: Added e-mail address format validation.
  • FSIDMMA-589: Added province code format validation and data existence in DB.
Actions
Copy link
 #26

Updated by Andi Malik Rizki Maula 9 months ago

Version:

  • cr-unilever/v20260107-001-bd6e061

Objects:

  • objects/avt/avantrade-web-sellingagent.zip

Notes:

  • FSIDMMA-586: Fixed null uploaded subscription order unit causing booking list report error.
  • FSIDMMA-590: Fixed account management approval error.
Actions
Copy link
 #27

Updated by Andi Malik Rizki Maula 9 months ago

Version:

  • cr-unilever/v20260108-001-935dbde

Objects:

  • objects/avt/avantrade-web-sellingagent.zip

Notes:

  • FSIDMMA-591: Added CIF_BANK and Customer CIF equality validation.
Actions
Copy link
 #28

Updated by Andi Malik Rizki Maula 9 months ago

Versions:

  • cr-unilever/v20260109-001-38b39b1

Objects:

  • avt/avantrade-web-sellingagent.zip

Release Note:

  • FSIDMMA-592: Fixed TRX_AMOUNT validation error due to scientific notation format.
Actions
Copy link
 #29

Updated by Andi Malik Rizki Maula 9 months ago

Versions:

  • cr-unilever/v20260109-003-1087768

Objects:

  • avt/avantrade-web-sellingagent.zip

Release Note:

  • FSIDMMA-594: Fixed FEE_AMOUNT validation error caused by empty value.
Actions
Copy link
 #30

Updated by Andi Malik Rizki Maula 9 months ago

Versions:

  • cr-unilever/v20260109-004-068b51d

Objects:

  • avt/avantrade-web-sellingagent.zip

Release Note:

  • FSIDMMA-594: Fixed FEE_AMOUNT validation error caused by empty value.
Actions
Copy link
 #31

Updated by Andi Malik Rizki Maula 9 months ago · Edited

Go Live

Versions:

  • avantrade-web-sellingagent: cr-unilever/v20260109-004-068b51d
  • birt: cr-unilever/v20251229-002-64ff20a

Objects:

  • avt/avantrade-web-sellingagent.zip
  • avt/birt.zip

Scripts:

  • avt/ddl-dml/00_ddl_backup.sql
  • avt/ddl-dml/01_ddl_table_changes.sql
  • avt/ddl-dml/02_dml_modules.sql
  • avt/dql/dql_export_cif_stg_new.sql
  • avt/dql/dql_export_second_ifua.sql

Documents:

  • CR Upload Unilever - Release Document v0.1.0-DRAFT.xlsx

Release Note:

  • CR Unilever customer personal data & subscription data upload features.
Actions
Copy link
 #32

Updated by Andi Malik Rizki Maula 9 months ago

Go Live

Versions:

  • avantrade-web-sellingagent: cr-unilever/v20260109-004-068b51d
  • birt: cr-unilever/v20251229-002-64ff20a

Objects:

  • avt/avantrade-web-sellingagent.zip
  • avt/birt.zip

Scripts:

  • avt/ddl-dml/00_ddl_backup.sql
  • avt/ddl-dml/01_ddl_table_changes.sql
  • avt/ddl-dml/02_dml_modules.sql
  • avt/ddl-dml/99_ddl_rollback.sql
  • avt/ddl-dml/99_dml_rollback.sql
  • avt/dql/dql_export_cif_stg_new.sql
  • avt/dql/dql_export_second_ifua.sql

Documents:

  • CR Upload Unilever - Release Document v0.1.1-DRAFT.xlsx

Release Note:

  • CR Unilever customer personal data & subscription data upload features.
Actions
Copy link

Also available in: Atom PDF