2,075
Dear All,
Currently our master data for customer not completed, for some record, in this case field city not filled yet.
is there any feature to upload the city ,
if I upload at sql directly, anyonce could inform how many and what is the related table for customer city field.
I need to prevent if I upload from sql, its only update at some table/ missing update at some table.
Thank you
*This post is locked for comments
I have the same question (0)
Hi,
You need to update field City of table LogisticsPostalAddress for a given customer. Following are the table and there relations.
CustTable
DirPartyTable: CustTable.Party == DirPartyTable.RecId
DirPartyLocation: DirPartyLocation.Party == DirPartyTable.RecId
LogisticsLocation: DirPartyLocation.Location == LogisticsLocation.RecId
LogisticsPostalAddress: LogisticsPostalAddress.Location == LogisticsLocation.RecId
LogisticsAddresssCity: LogisticsPostalAddress.CityRecId == LogisticsAddresssCity.RecId
Share
Report
All responses (
Answers (
