Added in version 8.3
The ERPSHIPMENTITEM table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
| ERPSHIPMENTITEMID (PK) |
nchar(12) |
NOT NULL |
ERPSHIPMENTITEM_PRIMARY (AK) |
||
| ERPSHIPMENTID (FK) |
nchar(12) |
NOT NULL |
ERPSHIPMENTITEM_ERPSHIPMENTID (IE) |
(One) to (Many) | ERPSHIPMENT.ERPSHIPMENTID |
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
ERPBACKORDEREDQUANTITY |
decimal(17,4) |
NULLS |
|||
|
ERPBACKORDEREDUOM |
varchar(64) |
NULLS |
|||
|
PRODUCTID(FK) |
nchar(12) |
NULLS |
ERPSHIPMENTITEM_ERPPRODUCTID (IE) |
(Many) to (One) | PRODUCT.PRODUCTID |
|
SALESORDERID(FK) |
nchar(12) |
NULLS |
ERPSHIPMENTITEM_ERPSALESORDERID (IE) |
(One) to (Many) | SALESORDER.SALESORDERID |
|
ERPLINENUMBER |
varchar(64) |
NULLS |
|||
|
ERPORDERQUANTITY |
decimal(17,4) |
NULLS |
|||
|
ERPORDERUOM |
varchar(64) |
NULLS |
|||
|
SALESORDERLINEREFERENCE |
varchar(64) |
NULLS |
|||
|
ERPSHIPPEDQUANTITY |
decimal(17,4) |
NULLS |
|||
|
ERPSHIPPEDUOM |
varchar(64) |
NULLS |
|||
|
ERPUPCID |
varchar(64) |
NULLS |
|||
|
ERPSALESORDERID |
varchar(100) |
NULLS |
|
||
|
DESCRIPTION |
varchar(1024) |
NULLS |
|||
|
PRODUCTNAME |
varchar(100) |
NULLS |
|||
|
LINENUMBER |
int |
NULLS |
|||
|
ERPNOTES |
text |
NULLS |