News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) Query in SQL to find B...

Microsoft Dynamics RMS (Archived)

Query in SQL to find Barcode

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hi. Twho questions.

1.- I want to make a query to check the barcode of the items in SQL, but I don't know the table name.

In the Items table I Can't find it.

2.- Where can I find the sales header and the sales lines ¿?

Thanks.

*This post is locked for comments

All responses Img

All responses (4)

Answers Img

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Query in SQL to find Barcode

Your welcome. So which was it, barcode format, or itemlookupcode?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Query in SQL to find Barcode

Thanks.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Query in SQL to find Barcode

almost forgot. if you are talking about printing labels with a barcode on them, then that is the [item] table BarcodeFormat column
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Query in SQL to find Barcode

1) the table is [item]. The column is itemlookupcode. (primary only)

also see the alias table for Aliases on items.

2) Sales Header is [Transaction]

Sales lines is [TransactionEntry]

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,503 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans