This table stores information on items and other associated information.
#
Column Name
Nullable
Data Type
Max Length
Description
1
item_id
integer
0
The primary key of this table, which is also a serial field.
2
item_code
character varying
12
Code given to the item.
3
item_name
character varying
150
Name given to the item.
4
item_group_id
integer
0
5
item_type_id
integer
0
Foreign key to the table core.item_groups.
6
brand_id
integer
0
Foreign key to the table core.brands.
7
preferred_supplier_id
bigint
0
Foreign key to the table core.parties.
8
lead_time_in_days
integer
0
Days taken for the shipment of the ordered goods.
9
weight_in_grams
double precision
0
Weight of an individual item in the unit of measure gram.
10
width_in_centimeters
double precision
0
Width of an individual item in centimeter.
11
height_in_centimeters
double precision
0
Height of an individual item in centimeter.
12
length_in_centimeters
double precision
0
Length of an individual item in centimeter.
13
machinable
boolean
0
Select "Yes" if the particular item can be handled by machine while shipping.
14
preferred_shipping_mail_type_id
integer
0
Foreign key to the table core.shipping_mail_types.
15
shipping_package_shape_id
integer
0
Foreign key to the table core.shipping_package_shapes.
16
unit_id
integer
0
Foreign key to the table core.items.
17
hot_item
boolean
0
Hot item will be featured on e-commerce website. Select "Yes" if the item is hot item or vice-versa.
18
cost_price
money_strict
0
Cost price of the item.
19
cost_price_includes_tax
boolean
0
Select "Yes" if the cost price includes tax or vice-versa.
20
selling_price
money_strict
0
Selling price of the item.
21
selling_price_includes_tax
boolean
0
Select "Yes" if the selling price includes tax or vice-versa.
22
sales_tax_id
integer
0
Foreign key to the table core.sales_taxes.
23
reorder_unit_id
integer
0
Foreign key to the table core.units.
24
reorder_level
integer
0
The level of stock on which re-order needs to be placed.
25
reorder_quantity
integer
0
The quantity of good that needs to be ordered as the stock reaches re-order level.
26
maintain_stock
boolean
0
Select "Yes" if you want to maintain the record of transfer (in & out) of stock items.Selecting "Yes" prohibits the user from maintaining negative stock level.
27
audit_user_id
integer
0
Contains the id of the user who last inserted or updated the corresponding row.
28
audit_ts
timestamp with time zone
0
Contains the date and timestamp of the last insert or update action.