OpenSync

Home Forums OpenSync Missing Fields in Items Tables

This topic contains 5 replies, has 2 voices, and was last updated by  Yudel Rosales 1 month, 1 week ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #66659

    Jonathan
    Premium Member

    Hi:

    In the following tables I can’t find price/rate or accounts.

    Itemservice
    Itemothercharge
    Itemsubtotal

    How would I know these if they are not in these tables?

    Thanks.

    #66662

    Yudel Rosales
    Keymaster

    You will find that on their child tables.

    #66663

    Jonathan
    Premium Member

    Can you tell me which are the child tables? I’ve looked everywhere. Thanks. Also do you recommend writing directly to the tables OpenSync creates in a production environment or do you recommend I have my own tables and just post changes to your tables? Thanks.

    #66664

    Jonathan
    Premium Member

    Also which tables should I select in OpenSync once you reply to the above post? Thanks.

    #66667

    Yudel Rosales
    Keymaster

    Child tables cannot be selected. They will be populated as dependency tables. You can check the help file to see the child tables for each parent table.

    #66668

    Yudel Rosales
    Keymaster

    OpenSync will only populate its tables and it has to be the whole schema created in the database. Unfortunately, you cannot get to pick fields or tables to populate.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.