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:

Business Central

All responses Img

All responses (4)

Answers Img

Answers (3)

Verified answer

YUN ZHU 73,378 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,133 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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,064 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans