Table relationships

[Former Member]

Hi,

How to find the relationship between the following tables to manin table like CRMD_ORDER_INDEX or CRMD_LINK.

CRMM_PRP_PROD_I

CRMM_PRP_PROD_IH

CRMM_PRPADM_H

CRMM_PRPADM_HH

CRMM_PRPADM_I

CRMM_PRPADM_IH

CRMR_PRICING

Regards

Srinu

[Former Member]

Hi.

For Contract orders

(CRMD_PARTNER-PARTNER_NO) crmd_partner (GUID) ->

(GUID_SET) crmd_link (GUID_HI) ->

(GUID) crmd_orderadm_h (GUID) ->

(HEADER) crmd_order_index (ITEM) ->

(GUID) crmd_orderadm_i (GUID) ->

(REF_ITEM) CRMM_PRPADM_H (GUID) ->

(PARENT_GUID) CRMM_PRPADM_I (GUID) ->

PARENT_GUID) CRMM_PRP_PROD_I (PRODUCT_REF_GUID) ->

(PRODUCT_GUID) COMM_Product

-

---

for other orders

(CRMD_PARTNER-PARTNER_NO)crmd_partner(GUID) -> (GUID_SET)crmd_link(GUID_HI) -> (GUID)crmd_orderadm_h(GUID) -> (HEADER)crmd_order_index(ITEM) -> (GUID)crmd_orderadm_i(PRODUCT) -> (PRODUCT_GUID)COMM_Product

Best regards, Sergey.

[ashish_nagpal]

hi

to get the table relationship just go to your table and there u need to give the object id or object name then execute it and header GUID generated,you need to copy it and then paste that GUID in table CRMD_ORDER_INDEX,as soon as you execute it you will get the desired result,

procedure is same for every table.

hope it helps you

best regards

ashish