Find IBase and Instance by order GUID

[Former Member]

Hi.

How can I find IBase and Instance by order GUID?

Please list all tables and paths.

Best Regards.

[former_member789970 · Accepted solution]

Hi, Igor.

Try to use this chain:

CRMD_LINK-GUID_HI=CRMD_ORDERADM_H-GUID, where

CRMD_LINK-OBJTYPE_SET=29

CRMD_SRV_OSSET-GUID_SET = СRMD_LINK-GUID_SET

CRMD_SRV_REFOBJ-GUID_REF=CRMD_SRV_OSSET-GUID

IBIN-IN_GUID=CRMD_SRV_REFOBJ-IB_COMP_REF_GUID=IBINTX-IN_GUID

IBase is in IBIN-IBASE

Instance is in IBIN-INSTANCE, Description in IBINTX-DESCR.

I hope this could help you

Best regards,

Vadim.

[Former Member]

Hi, we are in a strange situation. for some odd reason, while loading Ibases, duplicate Instances are getting created in IBIN. this is leading to some corrupt sales orders.

Any idea as to why duplicate Instances get created?