Tier Distribution

SOLVED

I am working on exporting PO_details through an ODBC in Access, teaching myself as I go.  My query is close to what I want but, I need to find the table for the distribution of the "LineKey".  In SO they have a table SO_SalesOrderTierDistribution, in the PO tables they have a couple tier tables but not one for the detail, I don't see any PO table where I can make the relationship.  The SO "linekey" breaks down one line into the different size and colors to create a different record/row.  I attached a screen shot of my SO export.so tier.pdf

  • 0
    verified answer

    If it was me I would get with the firm that you got your third party enhancement for size and color and ask if any of the Purchase Order tables were modified or created. If so they should be able to tell you the table names, if not just use the ReceiptTierDistribution tables