Product Table - SharePoint List

Product Table

The purpose of this post is to highlight the table schema that I’ll be using henceforth, in my upcoming posts, targeting Microsoft PowerApps and Microsoft Flow. The table schema design is based on the Product Table from AdventureWorks. Here, I have highlighted all the fields used and their types. Some of the fields are custom so as to suit my case scenario.

Table Schema

Column Data type Required Description
Title Text SharePoint default
Make Flag Choice 0 = Product is purchased.
1 = Product is manufactured in-house.
Finished Goods Flag Choice 0 = Product is not a salable item.
1 = Product is salable.
Color Text Product color
Safety Stock Level Number Minimum inventory quantity
Reorder Point Number Inventory level that triggers a purchase order or work order
Standard Cost Currency Standard cost of the product
List Price Currency Selling price
Supplier Lookup Supplier Identifier
Size Number Product size
Weight Number Product weight
Days To Manufacture Number Number of days required to manufacture the product
Product Line Managed Metadata R = Road
M = Mountain
T = Touring
S = Standard
Class Managed Metadata H = High
M = Medium
L = Low
Style Managed Metadata W = Women’s
M = Men’s
U = Universal
Sell Start Date Date and Time Date the product was available for sale
Sell End Date Date and Time Date the product was no longer available for sale
Discontinued Date Date and Time Date the product was discontinued
Product Image Hyperlink or Picture Image of the Product
Modified Date and Time SharePoint default
Created Date and Time SharePoint default
Created By Person or Group SharePoint default
Modified By Person or Group SharePoint default

Key Takeaway

  • Since, this table will be used a lot in my future posts, instead of defining it again and again, I’ll be using this post for reference.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.