A customer had a request to merge all Service Call data into another company database and although I recommended against this they wanted it so I merged some 40+ tables. I had to provide new EQUIPID values as those values already existed in the original company along with new index links to accounts, etc.
My issue remains with the notes and attachments. I think I have most/all of the text notes properly displaying but the attachments are another story. Some of the attachments are there but when I copied the notes from the ole notes\company folder to the new company there were some duplicates. Most of the attachments that link to the Service Call are there but those linking to the Item Number appear to be missing or the link is broken.
What does the value in the Notes_Array_1, Notes_Array_2, etc field link to? I cannot find these values in the SY03900 table. I can see noteindx of 146928.00000 but then in the array_1 is see 146929.00000 and array_2 = 146930.00000.
Anyone have any ideas on this?
Thanks much,
Dave
*This post is locked for comments