Added in version 8.3
The QUOTEITEM table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
QUOTEITEMID (PK) |
nchar(12) |
NOT NULL |
QUOTEITEM_PRIMARY (AK) |
(One) to (Many) |
DISCOUNTCHARGEITEM.QUOTEITEMID |
|
(One) to (Many) |
QUOTESUBITEM.QUOTEIID | ||||
|
(One) to (Many) |
QUOTESUBITEM.QUOTEITEMID | ||||
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
QUOTEID (FK) |
nchar(12) |
NULLS |
QUOTEITEM_QUOTEID (IE) |
||
|
OPPORTUNITYPRODUCTID (FK) |
nchar(12) |
NULLS |
(Many) to (One) |
OPPORTUNITY_PRODUCT.OPPPRODUCTID | |
|
PRODUCTID(FK) |
nchar(12) |
NULLS |
QUOTEITEM_PRODUCTID (IE) |
(One) to (Many) |
PRODUCT.PRODUCTID |
|
PRODUCTNAME |
varchar(64) |
NULLS |
|||
|
PROGRAM |
varchar(64) |
NULLS |
|||
|
LINENUMBER |
int |
NULLS |
|||
|
ERPLINENUMBER |
varchar(64) |
NULLS |
|||
|
STATUS |
varchar(64) |
NULLS |
|||
|
STATUSDATE |
datetime |
NULLS |
|||
|
DESCRIPTION |
varchar(1024) |
NULLS |
|||
|
FAMILY |
varchar(64) |
NULLS |
|||
|
LINETYPE |
varchar(64) |
NULLS |
|||
|
QUANTITY |
float |
NULLS |
|||
|
OPENQUANTITY |
decimal(17,4) |
NULLS |
|||
|
PRICE |
float |
NULLS |
|||
|
PRICEDETAILDESCRIPTION |
varchar(64) |
NULLS |
|||
|
PRICEDETAILNOTES |
text |
NULLS |
|||
|
DISCOUNT |
float |
NULLS |
|||
|
CALCULATEDPRICE |
decimal(17,4) |
NULLS |
|||
|
EXTENDEDPRICE |
float |
NULLS |
|||
|
OPENUNITOFMEASURE |
varchar(64) |
NULLS |
|||
|
UNITPRICEPERQUANTITY |
decimal(17,4) |
NULLS |
|||
|
UNITPRICEPERQUANTITYUOM |
varchar(255) |
NULLS |
|||
|
UNITPRICEUNITOFMEASURE |
varchar(64) |
NULLS |
|||
|
ITEMLOCKED |
nchar(1) |
NULLS |
|||
|
FIXEDPRICE |
nchar(1) |
NULLS |
|||
|
UNITOFMEASUREID |
nchar(12) |
NULLS |
(Many) to (One) |
UNITOFMEASURE.UNITOFMEASUREID | |
|
UNITOFMEASURECODE |
varchar(64) |
NULLS |
|||
|
UNITOFMEASUREQUANTITY |
decimal(17,4) |
NULLS |
|||
|
SHIPTOID(FK) |
nchar(12) |
NULLS |
|
(One) to (Many) |
ERPSHIPTO.ERPSHIPTOID |
|
RUSHREQUEST |
nchar(1) |
NULLS |
|||
|
COMMODITYTYPE |
varchar(64) |
NULLS |
|||
|
ACTUALID |
varchar(64) |
NULLS |
|
||
|
UPCID |
varchar(64) |
NULLS |
|||
|
NOTE |
text |
NULLS |
|||
|
CREATESOURCE |
varchar(64) |
NULLS |
|||
|
PROMISEDDELIVERYDATE |
datetime |
NULLS |
|||
|
PROMISEDSHIPDATE |
datetime |
NULLS |
|||
|
WAREHOUSEID(FK) |
nchar(12) |
NULLS |
|
(Many) to (One) |
SLXLOCATION.SLXLOCATIONID |
|
INCOTERM |
varchar(64) |
NULLS |
|||
|
DROPSHIP |
nchar(1) |
NULLS |
|||
|
REQUIREDDELIVERYDATE |
datetime |
NULLS |
|||
|
TOTALAMOUNT |
float |
NULLS |
|||
|
DOCTOTALAMOUNT |
float |
NULLS |
|||
|
DOCCALCULATEDPRICE |
decimal(17,4) |
NULLS |
|||
|
DOCEXTENDEDPRICE |
decimal(17,4) |
NULLS |
|||
|
SLXLOCATIONID(FK) |
nchar(12) |
NULLS |
|
(One) to (Many) | SLXLOCATION.SLXLOCATIONID |
|
AVAILABLEQUANTITY |
decimal(17,4) |
NULLS |
|||
|
ATPDATE |
datetime |
NULLS |
|||
| CONFIGURATIONID |
nvarchar(64) |
NULLS |
|||
| CONFIGURATIONDETAILID |
nvarchar(64) |
NULLS |
|||
|
ERPNOTES |
text |
NULLS |