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ü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, report mysql

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

Proje NO: #2247554