Devam Ediyor

506774 MySQL Item Report on 4 tables 2

Four Tables. Will require addition and subtracting. See attached 4 tables.

Main table = Item_List.

Table = Item Adjustment

Table = Item Received

Table = Item Sold

12 Columns

From TABLE Item_List : ItemId, ItemNum, Cost, SalesPrice, Notes.

From TABLE Item Adjustment: Adj_Loc, Adj_Q.

From TABLE Item Received: Rec_Loc, Rec_Q.

From TABLE Item Sold: Sold_Loc, Sold_Q.

The col Current will = Adj_Q + Rec_Q - Sold_Q = Current_Q

All math based on the total sum for each location in TABLES Adj+Rec-Sold and showing all [url removed, login to view]'s

Structure Example:

ItemId | ItemNum | Adj_Loc | Adj_Q | Rec_Loc | Rec_Q | Sold_Loc | Sold_Q | Current | Cost | SalesPrice | Notes

Beceriler: Her şey Kabul, MySQL, SQL

Daha fazlasını görün: report example, rec, mysql structure, report table, item sold, math report, notes mysql, math table, sum total, adj, item, cost report, sum report, mysql columns, sql mysql report mysql, report mysql

İşveren Hakkında:
( 4 değerlendirme ) Jacksonville, United States

Proje NO: #2252700