Added in version 8.3
The ERPSHIPMENT table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ERPSHIPMENTID(PK) |
nchar(12) |
NOT NULL |
ERPSHIPMENT_PRIMARY (AK) |
(One) to (Many) | DISCOUNTCHARGEITEM.SHIPMENTID |
| (One) to (Many) | ERPSHIPMENTADDRESS.ERPSHIPMENTID | ||||
| (One) to (Many) | ERPSHIPMENTITEM.ERPSHIPMENTID | ||||
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
ACCOUNTID(FK) |
nchar(12) |
NULLS |
ERPSHIPMENT_ACCOUNTID(IE) |
(One) to (Many) | ACCOUNT.ACCOUNTID |
|
ERPSHIPFROMID |
nchar(12) |
NULLS |
|
(One) to (Many) | ERPPAYFROM.ERPPAYFROMID |
|
ERPSHIPTOID |
nchar(12) |
NULLS |
ERPSHIPMENT_SHIPTOID(IE) |
(One) to (Many) | ERPSHIPTO.ERPSHIPTOID |
|
ERPACTUALDELIVERYDATE |
datetime |
NULLS |
|
||
|
ERPACTUALSHIPDATE |
datetime |
NULLS |
|
||
|
ERPCARRIERPARTY |
varchar(64) |
NULLS |
|
||
|
SHIPMENTNUMBER |
varchar(64) |
NULLS |
|
||
|
ERPEXTID |
varchar(100) |
NULLS |
ERPSHIPMENT_ERPEXTID(IE) |
||
|
ERPACCOUNTINGENTITYID |
varchar(22) |
NULLS |
|
||
|
ERPLOGICALID |
varchar(255) |
NULLS |
|
||
|
ERPLOCATION |
varchar(22) |
NULLS |
|
||
|
ERPFREIGHTAMOUNT |
float |
NULLS |
|
||
|
DATEPROMISED |
datetime |
NULLS |
|
||
|
SALESPRICEAMOUNT |
float |
NULLS |
|
||
|
SALESPRICECURRENCY |
varchar(3) |
NULLS |
|
||
|
SHIPMENTTOTALAMOUNT |
float |
NULLS |
|
||
|
ERPSTATUS |
varchar(64) |
NULLS |
|
||
|
ERPSTATUSDATE |
datetime |
NULLS |
|
||
|
ERPTRANSPORTATIONMETHOD |
varchar(64) |
NULLS |
|
||
|
ERPINCOTERM |
varchar(64) |
NULLS |
|
||
|
ERPOWNERSHIPTRANSFER |
varchar(64) |
NULLS |
|
||
|
ERPWAREHOUSEID |
nchar(12) |
NULLS |
|
(Many) to (One) | SLXLOCATION.SLXLOCATIONID |
|
ERPUNIQUEID |
varchar(377) |
NULLS |
ERPSHIPMENT_ERPUNIQUEID(IE) |
||
|
ERPVARIATIONID |
varchar(22) |
NULLS |
|
||
|
ERPDECLAREDVALUE |
float |
NULLS |
|
||
|
ERPDOCREFTYPE |
varchar(100) |
NULLS |
|
||
|
ERPDOCREF |
varchar(100) |
NULLS |
|
||
|
ERPDOCREFACCTENTITYID |
varchar(22) |
NULLS |
|
||
|
SHIPPINGADDRESSID(FK) |
nchar(12) |
NULLS |
ERPSHIPMENT_SHIPPINGADDRID(IE) |
(Many) to (One) | ERPSHIPMENTADDRESS.ERPSHIPMENTADDRESSID |
|
ERPPARTIALSHIPALLOWED |
nchar(1) |
NULLS | |||
|
ERPDOCUMENTDATE |
datetime |
NULLS |
|
||
|
ERPLASTMODIFIEDDATE |
datetime |
NULLS |
|
||
|
ERPDECLAREDBASEVALUE |
float |
NULLS |
|
||
|
ERPFREIGHTBASEAMOUNT |
float |
NULLS |
|
||
|
SALESPRICEBASEAMOUNT |
float |
NULLS |
|
||
|
SHIPMENTTOTALBASEAMOUNT |
float |
NULLS |
|
||
|
ERPGROSSWEIGHT |
decimal(17,4) |
NULLS |
|
||
|
ERPGROSSWEIGHTUNIT |
varchar(255) |
NULLS |
|
||
|
CURRENCYCODE |
varchar(64) |
NULLS |
|
||
|
BASECURRENCYCODE |
varchar(64) |
NULLS |
|
||
|
CARRIERID |
nchar(12) |
NULLS |
(One) to (Many) | CARRIER.CARRIERID | |
|
ERPNOTES |
text |
NULLS |
|||
| ISNORMALIZED | char(1) |
NULLS |