Lookup attribute mapped to Number field in MSP does not show value in the schedule

Document ID : KB000074490
Last Modified Date : 22/03/2018
Show Technical Document Details
Issue:
A Lookup-Number type attribute is mapped to a Number field under MSP Field Mappings in CAPPM. When the schedule is opened in MSP the value of the attribute is not displayed even though the tasks have a value for this attribute and instead all values are shown as zero.
User-added image
Resolution:
The document below states that all Number type attributes should be mapped to Number fields in MSP:

https://docops.ca.com/ca-ppm/15-3/en/using/project-management/manage-projects-with-microsoft-project-msp/microsoft-project-msp-field-mappings

However, for Static Lookup -Number type attributes Text4 to Text30 fields should be used else the above issue occurs.