Task #6703
LHDN: Add validation for Employer number
Status: | Work Completed-End life cycle | Start date: | October 14, 2016 | |
---|---|---|---|---|
Priority: | High | Due date: | October 19, 2016 | |
Assignee: | Norhaidah Md Dasuki | % Done: | 100% | |
Category: | UAT - LHDN | Spent time: | - | |
Target version: | - |
Description
1) Create a new table for the new LHDN Employer with 3 fields
i) Employer number
ii) Company Name
iii) Flag (temporary use this name until known)
2) Validate employer number with DB. If not exist, fail the request.
History
#1 Updated by Ngoh Chee Onn almost 8 years ago
- File LHDN_REG_EMPLOYER_TABLE.sql added
- File EmployerNoColumnType.sql added
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- Assignee changed from Ngoh Chee Onn to Yap Kah Yan
- % Done changed from 0 to 80
Hi Kah Yan,
Development done and pushed to staging mercurial. Please help to deploy in SIT and UAT server and refer attachment for the new create table script, which this table use to keep all registered employer. Furthermore, the previous column NO_EMPLOYER and NO_EMPLOYER_HEADQUARTERS in BIB_LHDN_RECORD table in wrong date type. Please help to execute the query in second attachment in SIT and UAT db for this column type fixed.
Thank you.
#2 Updated by Yap Kah Yan almost 8 years ago
- Category changed from Development to Internal Test
- Assignee changed from Yap Kah Yan to Erni Suhaireen Zulkifli
- % Done changed from 80 to 0
Hi Erni,
Deployed Chee Onn's changes for validating LHDN registration.
Please test. Thank you.
#3 Updated by Erni Suhaireen Zulkifli almost 8 years ago
Hi Chee Onn,
Already test the subject. Even when change the employer number to be invalid employer number. System still receive the file. No validation occurred on this scenario. Kindly refer attached file and fix the bug.
Thank you.
#4 Updated by Ngoh Chee Onn almost 8 years ago
- Status changed from Development / Work In Progress to Internal Testing
Hi Erni,
Please check properly the number you change is Headquarter Employer Number and not Employer Number. Employer Number is starting from length 21 until 31.
Thank you.
#5 Updated by Erni Suhaireen Zulkifli almost 8 years ago
- File Task 6703 Test Result_LHDNValidationEmployerNumeber_V 0.1.docx added
- Status changed from Internal Testing to Pending Review
- Assignee changed from Erni Suhaireen Zulkifli to Norhaidah Md Dasuki
- % Done changed from 0 to 100
Hi,
Sorry for the mistake. Subject has been tested and successfully pass. Kindly review the Test Result on attached file.
Thank you.
#6 Updated by Norhaidah Md Dasuki almost 8 years ago
- Category changed from Internal Test to UAT - LHDN
#7 Updated by Norhaidah Md Dasuki almost 8 years ago
- Status changed from Pending Review to Work Completed-End life cycle
Reviewed.