Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Vendor Tax ID Number

(1) ShareShare
ReportReport
Posted on by 6
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
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,979 Super User 2025 Season 1 on at
    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?
  • Heather.Stacco Profile Picture
    Heather.Stacco 6 on at
    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.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,979 Super User 2025 Season 1 on at
    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? 
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,257 Super User 2025 Season 1 on at
    Vendor Tax ID Number
    That field is in VendTable:
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans