| id |
integer |
Yes |
Yes |
nextval('inventory_id_seq'::regclass) |
Unique identifier |
| 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 for this item |
| product_code |
character varying(10) |
No |
No |
|
Product Code assigned to the item - links to inventory_product_codes.product_code |
| hold |
smallint |
No |
No |
|
Hold flag for item; 0 = No 1 = Yes |
| current_cost |
numeric(15,5) |
No |
No |
|
Current or last cost of the item as updated by inventory receiving however is editable by user |
| average_cost |
numeric(15,5) |
No |
No |
|
Average cost of the item as calculated at inventory receipt time |
| tax_code |
smallint |
No |
No |
|
Not used |
| uom_purchase |
character varying(10) |
No |
No |
|
Default unit of measure to be used for purchasing - links to inventory_uoms |
| uom_inventory |
character varying(10) |
No |
No |
|
Unit of measure used by this item for On Hand quantity - links to inventory_uoms |
| uom_sales |
character varying(10) |
No |
No |
|
Default unit of measure to be used for sales - links to inventory_uoms |
| current_po |
character varying(10) |
No |
No |
|
Last Purchase Order number issued for this item |
| min_buy_qty |
numeric(11) |
No |
No |
|
Minimum quantity that can be purchased from vendor |
| po_due_date |
date |
No |
No |
|
Due date of last Puchase Order issued for this item |
| discountable |
boolean |
No |
No |
|
Item Discountable flag; FALSE = No TRUE = Yes |
| serialized |
boolean |
Yes |
No |
false |
Serialized flag; FALSE = No TRUE = Yes |
| sales_acct |
smallint |
No |
No |
|
Sales department assigned to set General Ledger Accounts - links to sales_departments.id blank or 0 will use Company Settings, General Ledger, Special Accounts, Special Accounts, Sales, Cost of Goods and Inventory defaults |
| onhand_qty |
numeric(15,5) |
No |
No |
|
Quantity on hand for this item |
| reorder_qty |
numeric(15,5) |
No |
No |
|
Reorder Point |
| committed_qty |
numeric(15,5) |
No |
No |
|
Committed quantity - set by Sales Order shipped quantity, Production Order commited quantity and Inventory Transfer quantity |
| backorder_qty |
numeric(15,5) |
No |
No |
|
Back Ordered quantity - set by Sales Order back ordered quantity |
| purchase_qty |
numeric(15,5) |
No |
No |
|
Quantity on; - issued Purchase Orders - remaining quantity on Pending and In Progress Production Orders - Inventory Transfers |
| alt_part_no |
character varying(40) |
No |
No |
|
Alternate part numberto be used when this part number is out of stock or On Hold |
| misc_1 |
character varying(40) |
No |
No |
|
Inventory type - links to record_types.user_type where record_types.link_tbl='INV' |
| misc_2 |
numeric(15,5) |
No |
No |
|
Miscellaneous numeric field |
| type |
character varying(1) |
No |
No |
|
Inventory type; K - Kit M - Manufactured N - Normal R - Raw material V - Non Physical, On Hand, Committed and On Order not tracked |
| image_path |
character varying(261) |
No |
No |
|
Path to a graphic image file |
| upload |
boolean |
No |
No |
|
Flag for upload to ecommerce site; TRUE = Yes FASLE = No |
| allow_back_orders |
boolean |
No |
No |
|
Back orders allowed flag; FALSE = No TRUE = Yes |
| allow_returns |
boolean |
No |
No |
|
Allow returns flag; FALSE = No TRUE = Yes |
| preferred_vendor |
character varying(20) |
No |
No |
|
Preferred vendor code to use for Requistions and Purchase Orders - links to vendors.vendor_no |
| rebate_ab |
boolean |
No |
No |
|
Tax rebate flag for Alberta; FALSE = No TRUE = Yes |
| rebate_bc |
boolean |
No |
No |
|
Tax rebate flag for British Columbia; FALSE = No TRUE = Yes |
| rebate_mb |
boolean |
No |
No |
|
Tax rebate flag for Manitoba; FALSE = No TRUE = Yes |
| rebate_nb |
boolean |
No |
No |
|
Tax rebate flag for New Brunswick; FALSE = No TRUE = Yes |
| rebate_nl |
boolean |
No |
No |
|
Tax rebate flag for Newfoundland; FALSE = No TRUE = Yes |
| rebate_nu |
boolean |
No |
No |
|
Tax rebate flag for Nunavut; FALSE = No TRUE = Yes |
| rebate_ns |
boolean |
No |
No |
|
Tax rebate flag for Nova Scotia; FALSE = No TRUE = Yes |
| rebate_nt |
boolean |
No |
No |
|
Tax rebate flag for Northwest Territories; FALSE = No TRUE = Yes |
| rebate_on |
boolean |
No |
No |
|
Tax rebate flag for Ontario; FALSE = No TRUE = Yes |
| rebate_pe |
boolean |
No |
No |
|
Tax rebate flag for Prince Edward Island; FALSE = No TRUE = Yes |
| rebate_qc |
boolean |
No |
No |
|
Tax rebate flag for Quebec; FALSE = No TRUE = Yes |
| rebate_sk |
boolean |
No |
No |
|
Tax rebate flag for Saskatchewan; FALSE = No TRUE = Yes |
| rebate_yt |
boolean |
No |
No |
|
Tax rebate flag for Yukon; FALSE = No TRUE = Yes |
| rebate_zz |
boolean |
No |
No |
|
Tax rebate flag for Other jurisdictions; FALSE = No TRUE = Yes |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time this record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |
| pack_size |
numeric(9,3) |
No |
No |
|
Usual pack size - reference use only |
| color_text |
bigint |
Yes |
No |
0 |
Text colour code for display of description |
| color_back |
bigint |
Yes |
No |
(B'111111111111111111111111'::"bit")::integer |
Background colour code for display of description |
| chgn_int |
character varying(3) |
No |
No |
|
Not used |
| chgn_date |
date |
No |
No |
|
Not used |
| levy_code |
character varying(3) |
No |
No |
|
Levy code assigned to this item - links to inventory_levy_codes.code |
| lot_numbered |
boolean |
Yes |
No |
false |
Lot numbered flag; FALSE = No TRUE = Yes |
| duty_perc |
numeric(7,2) |
No |
No |
|
Default Duty percentage to add to Purchase Order for this item. |
| freight_perc |
numeric(7,2) |
No |
No |
|
Default Freight percentage to add to Purchase Order for this item. |
| std_cost |
numeric(15,5) |
No |
No |
|
Standard cost as sey by a user |
| last_serial |
character varying(40) |
No |
No |
|
Last serial number set for this item - used by Auto Generate when receiving |
| dflt_expiry_days |
integer |
No |
No |
|
Default number of days to add to receive date and fill Expiry date, when creating a lot number during Inventory receipts |
| non_standard |
boolean |
No |
No |
|
Not used |
| hs_code |
character varying(27) |
No |
No |
|
Harmonized System code for import / export use |
| mfg_country |
character varying(3) |
No |
No |
|
Country of manufacture/origin for import/export |
| rental_whse |
character varying(6) |
No |
No |
|
Used by 3rd Party development |
| rental_part_no |
character varying(34) |
No |
No |
|
Used by 3rd Party development |
| rental_description |
character varying(80) |
No |
No |
|
Used by 3rd Party development |
| lot_consume_type |
smallint |
No |
No |
|
Lot number consume type; 0 = User choice from selection dialog 1 = Auto consume by date received 2 = Auto consume in Alpha Numeric order 3 = Auto consume in Expiry Date order |
| tax_flags |
boolean[] |
Yes |
No |
'{f,f,f,f}'::boolean[] |
Taxable flags for Sales tax 1 - 4; FALSE = No TRUE = Yes |
| extended_description |
text |
No |
No |
|
Extended description |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |
| last_modified |
timestamp without time zone |
No |
No |
|
Date/Time this record was last modified by Spire process, not user edit. |
| last_year_qty |
numeric(15,5) |
No |
No |
0 |
Total quantity sold last fiscal year |
| last_year_revenue |
numeric(15,5) |
No |
No |
0 |
Total value sold last fiscal year |
| this_year_qty |
numeric(15,5) |
No |
No |
0 |
Total quantity sold this fiscal year |
| this_year_revenue |
numeric(15,5) |
No |
No |
0 |
Total value sold this fiscal year |
| next_year_qty |
numeric(15,5) |
No |
No |
0 |
Total quantity sold next fiscal year |
| next_year_revenue |
numeric(15,5) |
No |
No |
0 |
Total value sold next fiscal year |
| last_count_date |
date |
No |
No |
|
Date that last Inventory Count was posted for this item |
| last_count_qty |
numeric(15,5) |
No |
No |
|
Quantity counted at last Inventory Count |
| last_count_variance |
numeric(15,5) |
No |
No |
|
Amount adjusted at last Inventory Count |
| show_options |
boolean |
No |
No |
|
Show options flag for Kitted items |