Change #4811
Change #4954: Bulk CR - EB140087, EB140093, EB140104, EB14109 & EB140123
EB140093:Extend Phone Number Field length
Status: | Closed - End of life cycle | Start date: | January 16, 2015 | |
---|---|---|---|---|
Priority: | Normal | Due date: | May 15, 2015 | |
Assignee: | - | % Done: | 100% | |
Category: | - | Spent time: | 9.00 hours | |
Target version: | - |
History
#1 Updated by Ngoh Chee Ping almost 10 years ago
- Due date set to November 20, 2014
- Assignee set to Fan Hansen
- Start date changed from November 13, 2014 to November 19, 2014
#2 Updated by Fan Hansen almost 10 years ago
- Status changed from New - Begin Life Cycle to Finished Development
- % Done changed from 0 to 100
Finish development and push to branch CR#EB140093
#3 Updated by Anonymous almost 10 years ago
- Parent task set to #4954
#4 Updated by Fan Hansen almost 10 years ago
Below is the SQL script needed to modify existing tables (BIB_USER and BIB_COMPANY)
ALTER TABLE BIB_USER ALTER COLUMN OFFICE_EXT_NO VARCHAR
ALTER TABLE BIB_COMPANY ALTER COLUMN OFFICE_PHONE_EXT_NO NVARCHAR
#6 Updated by Ngoh Chee Ping almost 10 years ago
- Assignee changed from Fan Hansen to Anonymous
#7 Updated by Ngoh Chee Ping over 9 years ago
- File NC974_CR_EB140093-ENG.doc added
- Due date changed from November 20, 2014 to January 19, 2015
- Status changed from Finished Development to Development / Work In Progress
- Assignee changed from Anonymous to Fan Hansen
- Start date changed from November 19, 2014 to January 16, 2015
- % Done changed from 100 to 0
The correct field need to change is phone no and fax no Need your help to update it The one we have done before for the extension number no need to change back. Just modify the company phone and fax number.
#8 Updated by Fan Hansen over 9 years ago
- Status changed from Development / Work In Progress to Finished Development
- Assignee changed from Fan Hansen to Anonymous
- % Done changed from 0 to 100
Finished development and pushed to branch CR#EB140093
Field changed including company office no, company fax no, and user tel no.
Below is the SQL script needed to modify existing tables (BIB_USER and BIB_COMPANY):
ALTER TABLE BIB_USER ALTER COLUMN TEL_NO NVARCHAR
ALTER TABLE BIB_COMPANY ALTER COLUMN OFFICE_PHONE_NO NVARCHAR
ALTER TABLE BIB_COMPANY ALTER COLUMN OTHER_PHONE_NO NVARCHAR
#9 Updated by Ngoh Chee Ping over 9 years ago
- File CR# EB140093#1.sql added
- Status changed from Finished Development to System Integration Test
#10 Updated by Anonymous over 9 years ago
- Due date changed from January 19, 2015 to May 15, 2015
- Status changed from System Integration Test to Documentation
- Assignee changed from Anonymous to Tan Jeng Wei
#11 Updated by Tan Jeng Wei over 9 years ago
- Assignee changed from Tan Jeng Wei to Anonymous
Finish update document
#12 Updated by Anonymous over 8 years ago
- Status changed from Documentation to Closed - End of life cycle