Table comparison: sma_costing
|
LO PEDIS |
ELIZ |
| Table-name |
Type |
Nullable |
Type |
Nullable |
|
id |
int(11) |
NO |
int(11) |
NO |
|
date |
date |
NO |
date |
NO |
|
product_id |
int(11) |
YES |
int(11) |
YES |
|
sale_item_id |
int(11) |
NO |
int(11) |
NO |
|
sale_id |
int(11) |
YES |
int(11) |
YES |
|
purchase_item_id |
int(11) |
YES |
int(11) |
YES |
|
quantity |
decimal(15,4) |
NO |
decimal(15,4) |
NO |
|
purchase_net_unit_cost |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
purchase_unit_cost |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
sale_net_unit_price |
decimal(25,4) |
NO |
decimal(25,4) |
NO |
|
sale_unit_price |
decimal(25,4) |
NO |
decimal(25,4) |
NO |
|
quantity_balance |
decimal(15,4) |
YES |
decimal(15,4) |
YES |
|
inventory |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
overselling |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
option_id |
int(11) |
YES |
int(11) |
YES |
|
purchase_id |
int(11) |
YES |
int(11) |
YES |
|
transfer_id |
int(11) |
YES |
int(11) |
YES |