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

All responses (4)

Answers (0)

Sort by

Suggested answer

Frank Hamelly | MVP... 46,633 Moderator on at

Like (0)

Report
Copy link

Link copied!

That field is in VendTable:
André Arnaud de Cal... 307,271 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Heather,

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

Like (0)

Report
Copy link

Link copied!

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.
André Arnaud de Cal... 307,271 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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?