|
id
|
int(11)
|
|
|
|
|
date
|
timestamp
|
|
|
current_timestamp()
|
|
reference_no
|
varchar(55)
|
|
|
|
|
warehouse_id
|
int(11)
|
|
|
|
|
type
|
varchar(10)
|
|
|
|
|
initial_file
|
varchar(50)
|
|
|
|
|
final_file
|
varchar(50)
|
|
|
|
|
brands
|
varchar(50)
|
|
|
|
|
brand_names
|
varchar(100)
|
|
|
|
|
categories
|
varchar(50)
|
|
|
|
|
category_names
|
varchar(100)
|
|
|
|
|
note
|
text
|
|
|
|
|
products
|
int(11)
|
|
|
|
|
rows
|
int(11)
|
|
|
|
|
differences
|
int(11)
|
|
|
|
|
matches
|
int(11)
|
|
|
|
|
missing
|
int(11)
|
|
|
|
|
created_by
|
int(11)
|
|
|
|
|
updated_by
|
int(11)
|
|
|
|
|
updated_at
|
datetime
|
|
|
|
|
finalized
|
tinyint(1)
|
|
|
|