Assistance locating 'Addl. Leg Ft' and 'Pieces' data in SQL Database

1

We are needing assistance locating the Addl. Leg Ft. (Additional Leg Feet) and Pieces data within Quantify’s SQL database.

Our development team has successfully identified and mapped all other required data elements; however, we have been unable to locate the source tables or fields that store these two metrics.

Could you please provide:

  • The table names where Addl. Leg Ft. and Pieces are stored,

  • The associated field names, or

  • An explanation of how and where these values are calculated or maintained within the database.

Any guidance you can provide would be greatly appreciated and will help us complete our data mapping efforts.

Thank you for your assistance,

Keenan Landry - Austin Industrial

UPDATE:
In the Quantify client Addl. Leg Ft data field is populated in the Scaffold Register tab on the Scaffold tag window:

image
image587×160 13 KB

In the Quantify client Pieces data field is populated in the Power BI Layout on the Scaffold Pivot window:

image
image1242×760 74.8 KB

2

Hi, Keenan.

Thank you for your inquiry.

I’m noting the below based on assumption that column labeled “Addl. Leg FT.” in your Scaffold Register is the standard Quantify Project field, renamed from the default label “Project”. Let us know if that is not the case. Also, let me note that we do not recommend direct database access for Quantify.

Addl. Leg FT. (Scaffold Register)
Table: Project
Column: Name
Link: ProjectID (ScaffoldTag.ProjectID = Project.ProjectID)

Pieces (Scaffold Pivot)
Table: StockedProduct
Column: QOnRent
Aggregate: SUM
Link: ScaffoldTag.StockingLocationID = StockedProduct.StockingLocationID

Please let us know if you need any further information.

3

Thank you for your feedback and assistance. This appears to be exactly what we needed, and we appreciate the time and effort with helping us resolve this matter.

We appreciate your help, and we will be sure to reach out if we need any further assistance.