How do I find which tables these columns are in?

(0) Share

Report

Posted on by Community Member

I am working on creating some reports for a customer of mine and I am able to connect in PowerBI to the tables in the database (FO Version) of their systems. When I open the link in PowerBI there are thousands of tables to choose from, many of which are empty. I am trying to figure out which tables these columns belong to:

Account #
Bin Location
Cashier
Category
Customer
Date Sold
Department
Description
Discount
Discount Reason Code
Full Price
Item
Item Cost
Item Sold Price
Last Sold
MSRP
On Hand
Price
Price A
Price B
Price C
Price Source
Profit
Profit Margin
Qty Sold
Register
Return Reason Code
Sale Ends
Sale Price
Sale Starts
Sold Price
Supplier
Tax Change Reason Code
Total Discount
Total Sales
Transaction
Web Item

Does anybody know which tables these columns can be found in or an easy way for me to search the tables for these?

All responses (1)

Answers (0)

AriaConsulting on at

Like (0)

Report

RE: How do I find which tables these columns are in?

Hi,

These fields are in the Commerce POS application, though I'm not sure what table(s). I'm still working on coming up to speed on that .

I recommend you post your question on that forum: community.dynamics.com/.../commerce