Determine a one time address via SQL


I have a SQL query to pull customer invoices. One of the requirements is pulling in the ship to address (which is working fine). Another requirement is to show whether it was a one-time address of it is a static ship to.

Is there a way to do that via SQL?

I thought there would be a checkbox somewhere I could pull in but I can’t find one.



It is determined by using the LogisticsLocationRole.Type. If the value is LogisticsLocationRoleType::Onetime then it is a one time address.

Moving to developer forum. Please always tag your AX version.