Search code examples
navisiondynamics-nav

Which table in Dynamics NAV contains Salesperson code?

I want to connect to Dynamics Nav through SQL.

Which table in Dynamics NAV contains 'Salesperson code'? It can be viewed in Aging of Receivables report? What are the keys to join between [CompanyName$Detailed Cust_ Ledg_ Entry] and [CompanyName$Cust_ Ledger Entry]?

Does any table contain information on actual 'Salesperson code' (not the former when receivable was created)?

Solution

  • There is "Cust Ledg entry no" on detailed-table.

    Is table "Salesperson_Purchaser" what you are looking?