Parent and Child relationship to Update Currency Index field

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello

I want to update the Currency Index field for a particular Currency ID in all the GP tables through the SQL script.

I built a SQL script to update all the tables which has both Currency ID and Currency Index and i works fine. Now i want to

update the table which has only Currency Index field. I guess if Currency Index field only there on the table in the sense then it will be Child table, so

i need to find the parent table to pick the Currency ID for each line item from the Child table to update exact Currency Index. I have almost updated with

this relationship except some tables. Can you suggest me the Parent tables for the below Child tables? Thanks in Advance.

SE000401

SE988977

TX20500

TX30000

VAT10302

Thanks,

Islam

*This post is locked for comments