Added in version 8.3
The ERPSALESORDERITEMSUBITEM table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ERPSALESORDERITEMSUBITEMID (PK) |
nchar(12) |
NOT NULL |
ERPSALESORDERITEMSUBITEM_PRIMARY (AK) |
||
|
SALESORDERITEMSID (FK) |
nchar(12) |
NOT NULL |
ERPSALESORDERSUBITEM_SOITEMID (IE) |
(One) to (Many) | SALESORDERITEMS.SALESORDERITEMSID |
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
BASEUOMQUANTITY |
int |
NULLS |
|||
|
BASEUOMCODE |
varchar(64) |
NULLS |
|||
|
DESCRIPTION |
varchar(64) |
NULLS |
|||
|
PRODUCTID(FK) |
nchar(12) |
NULLS |
ERPSALESORDERSUBITEM_PRODUCTID (IE) |
(Many) to (One) | PRODUCT.PRODUCTID |
|
LINENUMBER |
varchar(64) |
NULLS |
|||
|
NOTE |
text |
NULLS |
|||
|
QUANTITY |
decimal(17,4) |
NULLS |
|||
|
PRICE |
float |
NULLS |
|||
|
DOCPRICE |
float |
NULLS |