| id |
integer |
Yes |
Yes |
nextval('inventory_id_seq'::regclass) |
|
| whse |
character varying(6) |
Yes |
No |
|
Warehouse for this item |
| part_no |
character varying(34) |
Yes |
No |
|
Part number for this item |
| description |
character varying(80) |
No |
No |
|
Description of this item |
| product_code |
character varying(10) |
No |
No |
|
Product Code assigned to the item. From table inventory_product_codes |
| hold |
smallint |
No |
No |
|
Is item on hold flag 0 = No 1 = Yes 2 = Inactive |
| current_cost |
numeric(15,5) |
No |
No |
|
Current or last cost of the item. Is updated by inventory receiving but is editable by user. |
| average_cost |
numeric(15,5) |
No |
No |
|
Average cost of the item. |
| tax_code |
smallint |
No |
No |
|
|
| uom_purchase |
character varying(10) |
No |
No |
|
Default purchase unit of measure |
| uom_inventory |
character varying(10) |
No |
No |
|
Inventory or stocking unit of measure |
| uom_sales |
character varying(10) |
No |
No |
|
Default sales unit of measure |
| current_po |
character varying(10) |
No |
No |
|
Last PO issued for this item |
| min_buy_qty |
numeric(11) |
No |
No |
|
Minimum quantity that can be purchased. |
| po_due_date |
date |
No |
No |
|
Due date of last PO issued. |
| discountable |
boolean |
No |
No |
|
Discountable flag TRUE = Yes FALSE = No |
| serialized |
boolean |
Yes |
No |
false |
Serialized flag TRUE = Yes FALSE = No |
| sales_acct |
smallint |
No |
No |
|
Sales department assigned from table sales_departments |
| onhand_qty |
numeric(15,5) |
No |
No |
|
Quantity on hand |
| reorder_qty |
numeric(15,5) |
No |
No |
|
Re-Order Quantity |
| committed_qty |
numeric(15,5) |
No |
No |
|
Quantity committed |
| backorder_qty |
numeric(15,5) |
No |
No |
|
Quantiry back ordered |
| purchase_qty |
numeric(15,5) |
No |
No |
|
Quantity on issued purchase orders |
| alt_part_no |
character varying(40) |
No |
No |
|
Alternate part number |
| misc_1 |
character varying(40) |
No |
No |
|
Miscellaneous alpha-numeric field |
| misc_2 |
numeric(15,5) |
No |
No |
|
Miscellaneous numeric field |
| type |
character varying(1) |
No |
No |
|
Inventory type N - Normal M - Manufactured K - Kit R - Raw material V - Non Physical |
| image_path |
character varying(261) |
No |
No |
|
Path to a save image |
| upload |
boolean |
No |
No |
|
Flag for upload to ecommerce site TRUE = Yes FASLE = No |
| allow_back_orders |
boolean |
No |
No |
|
Back orders allowed TRUE = Yes FALSE = No |
| allow_returns |
boolean |
No |
No |
|
Allow returns TRUE = Yes FALSE = No |
| preferred_vendor |
character varying(20) |
No |
No |
|
Preferred vendor use for requistions |
| rebate_ab |
boolean |
No |
No |
|
Is a rebate set for Alberta TRUE = Yes FALSE = No |
| rebate_bc |
boolean |
No |
No |
|
Is a rebate set for BC TRUE = Yes FALSE = No |
| rebate_mb |
boolean |
No |
No |
|
Is a rebate set for Manitoba TRUE = Yes FALSE = No |
| rebate_nb |
boolean |
No |
No |
|
Is a rebate set for New Brunswick TRUE = Yes FALSE = No |
| rebate_nl |
boolean |
No |
No |
|
Is a rebate set for Newfoundland TRUE = Yes FALSE = No |
| rebate_nu |
boolean |
No |
No |
|
Is a rebate set for Nunavut TRUE = Yes FALSE = No |
| rebate_ns |
boolean |
No |
No |
|
Is a rebate set for Nova Scotia TRUE = Yes FALSE = No |
| rebate_nt |
boolean |
No |
No |
|
Is a rebate set for Northwest Territories TRUE = Yes FALSE = No |
| rebate_on |
boolean |
No |
No |
|
Is a rebate set for Ontario TRUE = Yes FALSE = No |
| rebate_pe |
boolean |
No |
No |
|
Is a rebate set for Prince Edward Island TRUE = Yes FALSE = No |
| rebate_qc |
boolean |
No |
No |
|
Is a rebate set for Quebec TRUE = Yes FALSE = No |
| rebate_sk |
boolean |
No |
No |
|
Is a rebate set for Saskatchewan TRUE = Yes FALSE = No |
| rebate_yt |
boolean |
No |
No |
|
Is a rebate set for Yukon TRUE = Yes FALSE = No |
| rebate_zz |
boolean |
No |
No |
|
Is a rebate set for other jurisdictions TRUE = Yes FALSE = No |
| _dbversion |
integer |
No |
No |
|
Program version that created item |
| _created |
timestamp without time zone |
No |
No |
|
Date/Time created |
| _created_by |
character varying(3) |
No |
No |
|
Initials of user that created item |
| _modified |
timestamp without time zone |
No |
No |
|
Date/Time last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that last modified item |
| pack_size |
numeric(9,3) |
No |
No |
|
Usual pack size |
| color_text |
bigint |
Yes |
No |
0 |
Text color of item |
| color_back |
bigint |
Yes |
No |
(B'111111111111111111111111'::"bit")::integer |
Background color of item |
| chgn_int |
character varying(3) |
No |
No |
|
|
| chgn_date |
date |
No |
No |
|
|
| levy_code |
character varying(3) |
No |
No |
|
Levy code assigned |
| lot_numbered |
boolean |
Yes |
No |
false |
Lot numbered TRUE = Yes FALSE = No |
| duty_perc |
numeric(7,2) |
No |
No |
|
Duty percentage to add to PO for this item |
| freight_perc |
numeric(7,2) |
No |
No |
|
Freight percentage to add to PO for this item |
| accessory_whse |
character varying(6) |
No |
No |
|
Warehouse of this items accessory |
| accessory_partno |
character varying(34) |
No |
No |
|
Part number of this items accessory |
| std_cost |
numeric(15,5) |
No |
No |
|
Standard cost. Only updated by a user. |
| last_serial |
character varying(40) |
No |
No |
|
Next serial number to use when receiving |
| dflt_expiry_days |
integer |
No |
No |
|
Deafult expiry/best before days to add to receive date |
| non_standard |
boolean |
No |
No |
|
|
| hs_code |
character varying(27) |
No |
No |
|
Harmonized System code |
| mfg_country |
character varying(3) |
No |
No |
|
Country of origin |
| rental_whse |
character varying(6) |
No |
No |
|
Not used |
| rental_part_no |
character varying(34) |
No |
No |
|
Not used |
| rental_description |
character varying(80) |
No |
No |
|
Not used |
| lot_consume_type |
smallint |
No |
No |
|
Lot number consume type 0 = User choice 1 = Date received 2 = Alpha Numeric 3 = Expiration Date |
| tax_flags |
boolean[] |
Yes |
No |
'{f,f,f,f}'::boolean[] |
Array field containing 4 tax flags t = Yes f = No |
| extended_description |
text |
No |
No |
|
Extended description |
| udf_data |
hstore |
No |
No |
''::hstore |
hstore field containing the user defined data. |
| last_modified |
timestamp without time zone |
No |
No |
|
|
| last_year_qty |
numeric(15,5) |
No |
No |
0 |
|
| last_year_revenue |
numeric(15,5) |
No |
No |
0 |
|
| this_year_qty |
numeric(15,5) |
No |
No |
0 |
|
| this_year_revenue |
numeric(15,5) |
No |
No |
0 |
|
| next_year_qty |
numeric(15,5) |
No |
No |
0 |
|
| next_year_revenue |
numeric(15,5) |
No |
No |
0 |
|