| id |
integer |
Yes |
Yes |
nextval('inventory_uoms_id_seq'::regclass) |
Unique identifier |
| whse |
character varying(6) |
Yes |
No |
|
Warehouse for item - links to inventory.whse |
| part_no |
character varying(34) |
Yes |
No |
|
Part number for item - links to inventory.part_no |
| uom |
character varying(10) |
No |
No |
|
Unit of measure code for this record |
| description |
character varying(80) |
No |
No |
|
Unit of Measure description for this record |
| qty_factor |
numeric(11,5) |
No |
No |
|
Factor of conversion for this unit of measure |
| direct_factor |
boolean |
No |
No |
|
Direct conversion factor flag; FALSE = Not direct (UOM is divided) TRUE = Direct (UOM is multiplied) |
| allow_fractional_qty |
boolean |
No |
No |
|
Fractional quantity permitted flag; FALSE = whole quantities only TRUE = fractional quantities permitted |
| buy_uom |
boolean |
No |
No |
|
Unit of Measure Purchase flag; FALSE = Not permited for Purchase TRUE = Permitted for Purchasing |
| sell_uom |
boolean |
No |
No |
|
Unit of Measure Sell flag; FALSE = Not permitted for Sales TRUE = Permitted for Sales |
| whse_location |
character varying(20) |
No |
No |
|
Warehouse physical location for this Unit of Measure |
| weight |
numeric(11,5) |
No |
No |
|
Weight of this Unit of Measure |
| _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 |
| sell_prices |
numeric(15,5)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Sell Price 1 - 20 for this Unit of Measure |
| break_qty |
numeric(11)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
Not used |
| break_qty_price |
numeric(15,5)[] |
Yes |
No |
'{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] |
|
| use_price_factor |
boolean |
Yes |
No |
|
Calculate price from Inventory Unit of Measure using Price Factor; FALSE = No TRUE = Yes |
| price_factor |
numeric(11,5) |
No |
No |
|
Factor used to calculate price from Inventory stock Unit of Measue |
| inventory_id |
integer |
Yes |
No |
|
Inventory identifier - links to inventory.id |