web

You’re offline. This is a read only version of the page.

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

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

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: Query in SQL to find Barcode

Your welcome. So which was it, barcode format, or itemlookupcode?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Query in SQL to find Barcode

Thanks.

Was this reply helpful? Yes No
Suggested answer

Community Member 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

Was this reply helpful? Yes No
Suggested answer

Community Member 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]

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Responsible AI policies for the Community

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans