Skip to main content
Question

How to link attachment to company in sql

J
Do Gooder (Customer)
Forum|alt.badge.img+3

An user wants a list of companies, CUSTOMER screen, that has an attachment on any of the tabs. I find the table EDM_FILE_STORAE_TAB but I can’t find a table to link Customer too. 

    4 replies

    Amila Samarasinghe
    Superhero (Partner)
    Forum|alt.badge.img+14

    Hi @jstanley 

     

    The table that links business objects and documents is called Doc_Reference_Object_Tab

     

    Thanks and Regards,

    Amila S. - https://www.linkedin.com/in/amila-samarasinghe-b3285974/
    Marcel.Ausan
    1 person likes this
    • Marcel.Ausan
      Marcel.Ausan
    J
    Do Gooder (Customer)
    Forum|alt.badge.img+3
    • jstanley
    • Author
    • Do Gooder (Customer)
    • 6 replies
    • November 1, 2023

    HI

     

    I don’t see how the DOC_REFERENCE_OBJECT_TAB would link to a company?

    J
    Do Gooder (Customer)
    Forum|alt.badge.img+3
    • jstanley
    • Author
    • Do Gooder (Customer)
    • 6 replies
    • November 1, 2023

    I did find this table doc_reference_obj_ext_details that has the company in it. Thank you. 

    Mathias Dahl
    Superhero (Employee)
    Forum|alt.badge.img+32
    • Mathias Dahl
    • Superhero (Employee)
    • 2843 replies
    • November 2, 2023
    jstanley wrote:

    HI

     

    I don’t see how the DOC_REFERENCE_OBJECT_TAB would link to a company?

    It's done via the LuName and KeyRef attributes.

     

    /Mathias
    Amila Samarasinghe
    P
    2 people like this
    • Amila Samarasinghe
      Amila Samarasinghe
    • P
      Pilar Franco

    Reply


    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings