Table comparison: sma_purchase_items
|
LO PEDIS |
ELIZ |
| Table-name |
Type |
Nullable |
Type |
Nullable |
|
id |
int(11) |
NO |
int(11) |
NO |
|
purchase_id |
int(11) |
YES |
int(11) |
YES |
|
transfer_id |
int(11) |
YES |
int(11) |
YES |
|
product_id |
int(11) |
NO |
int(11) |
NO |
|
product_code |
varchar(50) |
NO |
varchar(50) |
NO |
|
product_name |
varchar(255) |
NO |
varchar(255) |
NO |
|
option_id |
int(11) |
YES |
int(11) |
YES |
|
net_unit_cost |
decimal(25,4) |
NO |
decimal(25,4) |
NO |
|
quantity |
decimal(15,4) |
NO |
decimal(15,4) |
NO |
|
warehouse_id |
int(11) |
NO |
int(11) |
NO |
|
item_tax |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
tax_rate_id |
int(11) |
YES |
int(11) |
YES |
|
tax |
varchar(20) |
YES |
varchar(20) |
YES |
|
discount |
varchar(20) |
YES |
varchar(20) |
YES |
|
item_discount |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
expiry |
date |
YES |
date |
YES |
|
subtotal |
decimal(25,4) |
NO |
decimal(25,4) |
NO |
|
quantity_balance |
decimal(15,4) |
YES |
decimal(15,4) |
YES |
|
date |
date |
NO |
date |
NO |
|
status |
varchar(50) |
NO |
varchar(50) |
NO |
|
unit_cost |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
real_unit_cost |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
quantity_received |
decimal(15,4) |
YES |
decimal(15,4) |
YES |
|
supplier_part_no |
varchar(50) |
YES |
varchar(50) |
YES |
|
purchase_item_id |
int(11) |
YES |
int(11) |
YES |
|
product_unit_id |
int(11) |
YES |
int(11) |
YES |
|
product_unit_code |
varchar(10) |
YES |
varchar(10) |
YES |
|
unit_quantity |
decimal(15,4) |
NO |
decimal(15,4) |
NO |
|
gst |
varchar(20) |
YES |
varchar(20) |
YES |
|
cgst |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
sgst |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
igst |
decimal(25,4) |
YES |
decimal(25,4) |
YES |
|
base_unit_cost |
decimal(25,4) |
YES |
decimal(25,4) |
YES |