Devam Ediyor

501633 MySQL Item Report on 4 tables

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: 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: #2247554