Added in version 8.3
The QUOTESUBITEM table stores configuration information for the Configure Price Quote (CPQ) feature.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
QUOTESUBITEMID (PK) |
nchar(12) |
NOT NULL |
QUOTESUBITEM_PRIMARY (AK) |
||
|
QUOTEITEMID (FK) |
nchar(12) |
NOT NULL |
QUOTESUBITEM_QUOTEITEMID (IE) |
(One) to (Many) | QUOTEITEM.QUOTEITEMID |
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
PRODUCTID(FK) |
nchar(12) |
NULLS |
QUOTESUBITEM_PRODUCTID (IE) |
(Many) to (One) | PRODUCT.PRODUCTID |
|
LINENUMBER |
varchar(64) |
NULLS |
|||
|
QUANTITY |
decimal(17,4) |
NULLS |
|||
|
DESCRIPTION |
varchar(64) |
NULLS |
|||
|
BASEUOMCODE |
varchar(64) |
NULLS |
|||
|
BASEUOMQUANTITY |
int |
NULLS |
|||
|
NOTE |
text |
NULLS |
|||
|
PRICE |
float |
NULLS |
|||
|
DOCPRICE |
float |
NULLS |