News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Primary keys of 7002 T...

Small and medium business | Business Central, N...

Answered

Primary keys of 7002 Table

(0) Share

Report

Report

Posted on by Community member

13

Hello colleagues,

how may i find out what the primary keys of the table ID 7002 (Sales Prices) are?

thx a lot

my best,

fero

Categories:

Dynamics 365 Business Central

All responses Img

All responses (4)

Answers Img

Answers (3)

Verified answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (1)

Report

Primary keys of 7002 Table

Hi, just to add some info.

It can also be viewed from Page Inspection, but it is not very convenient.

For example,

Hope this helps.

Thanks.

ZHU
Suggested answer

Community member 3 on at

Like (0)

Report

Primary keys of 7002 Table

Hello colleagues,
Verified answer

Natalie Karolak - t... 1,955 on at

Like (1)

Report

Primary keys of 7002 Table

You can look up all standard code here:

https://github.com/StefanMaron/MSDyn365BC.Code.History

Your table in question:

https://github.com/StefanMaron/MSDyn365BC.Code.History/blob/master/BaseApp/Source/Base%20Application/Pricing/SalesPrice.Table.al
Verified answer

Mohana Yadav 59,194 Super User 2024 Season 2 on at

Like (2)

Report

Primary keys of 7002 Table

PK is

"Item No.", "Sales Type", "Sales Code", "Starting Date", "Currency Code", "Variant Code", "Unit of Measure Code", "Minimum Quantity"

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans