Finance | Project Operations, Human Resources, ...

Vendor Tax ID Number

(1) Share

Report

Posted on by Heather.Stacco

We are in a build phase for D365. We are using Synapse Link to pull tables into our Delta Lake and for now I am using serverless SQL to query the data to become familiar with joins, data, etc to help map some of our integrations from our old ERP to F&O. I am struggling with any type of formal documentation being available. For now I am trying to get from VendTable to the Federal Tax ID. In the form it says it is Tax1099RegNum on VendTable but VendTable has no field with that name. I am sure there are some other tables I need to join together to find this value as it doesn't exist in DirPartyTable, DirOrganization and any other Tax type table I have been able to pull into our environment. Any help would be appreciated.

Thanks,

Heather

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

Vendor Tax ID Number

That field is in VendTable:

Was this reply helpful? Yes No
André Arnaud de Cal... 300,195 Super User 2025 Season 2 on at

Like (0)

Report

Vendor Tax ID Number

Hi Heather,

The field Tax1099RegNum does exist on the VendTable table. Did you set up data entities or tables for the Synapse Link?

Was this reply helpful? Yes No
Heather.Stacco 6 on at

Like (0)

Report

Vendor Tax ID Number

I'm not sure what is different in our set up but we essentially set up Synapse Link to pull into our blob storage account. We are using SQL Serverless connections to read the data using SSMS. I have snipped how I am connecting below and Tax1099RegNum is not a valid column in that table. ?? I'm stumped.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,195 Super User 2025 Season 2 on at

Like (0)

Report

Vendor Tax ID Number

Hi Heather,

I'm currently not able to verify the connection you established. When connecting to the AXDB directly, I'm able to get values from this field. Can you check if you can find the VendTable in your list and what columns are included?

Was this reply helpful? Yes No