While this table does not have a field defined as a primary key, the UNITOFMEASUREID field should be unique and considered a primary key.
Added in version 7.5.4
The UNITOFMEASURE table stores unit of measure information for products. The table is used for accounting integration functionality.
|
|
While this table does not have a field defined as a primary key, the UNITOFMEASUREID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
UNITOFMEASUREID |
char(12) |
NOT NULL |
UNITOFMEASURE_PRIMARY (AK) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
UNITOFMEASUREGROUPID |
char(12) |
NULLS |
|
|
(deprecated) |
|
GLOBALSYNCID |
varchar(36) |
NULLS |
UNITOFMEASURE_GLOBALSYNCID (IE) |
|
|
|
APPID (FK) |
varchar(36) |
NULLS |
UNITOFMEASURE_APPID (IE) |
(Many) to (One) |
|
|
TICK |
int |
NULLS |
UNITOFMEASURE_TICK (IE) |
|
|
|
ACTIVEFLAG |
varchar(1) |
NULLS |
|
|
|
|
UOMTYPE |
varchar(64) |
NULLS |
|
|
|
|
NAME |
varchar(64) |
NULLS |
|
|
|
|
SHORTNAME |
varchar(32) |
NULLS |
|
|
|
|
SYMBOL |
varchar(16) |
NULLS |
|
|
|
|
DESCRIPTION |
text(16) |
NULLS |
|
|
|
|
BASENUMBER |
float |
NULLS |
|
|
|
|
ISPRIMARY |
varchar(1) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
| PRODUCTID (FK) | varchar(12) | NULLS |