We are working on a RMS project with some customization for data extraction and reporting. The data extraction and reporting mandates maximum number of characters for certain fields, such as ItemLookupCode, which cannot excede
14 characters. We are evaluating some of the possible options to meet this requirement. One of the possible solutions appears to be changing the field lengths in the RMS database tables. We have the following questions and appreciate your help if you have any answer for us.
a) Is this a viable option?
b) Can you resize any or all the columns?
c) Can you extend this approach to HQ?
d) What is the side effect of this solution?
Thank you for your help.