While this table does not have a field defined as a primary key, the CARRIERID field should be unique and considered a primary key.C
Added in version 8.3
The CARRIER table is used for Infor CRM Back Office Extension (ICBOE) functionality.
|
|
While this table does not have a field defined as a primary key, the CARRIERID field should be unique and considered a primary key.C |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
| CARRIERID |
nchar(12) |
NOT NULL |
CARRIER_PRIMARY (AK) |
(One) to (Many) | ACCOUNT.CARRIERID |
| (One) to (Many) | ERPSHIPMENT.CARRIERID | ||||
| (One) to (Many) | ERPSHIPTO.CARRIERID | ||||
| (One) to (Many) | QUOTE.CARRIERID | ||||
| (One) to (Many) | RMA.CARRIERID | ||||
| (One) to (Many) | SALESORDER.CARRIERID | ||||
| (One) to (Many) | SALESORDERITEM.CARRIERID | ||||
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
CARRIERNAME |
varchar(64) |
NULLS |
|
||
|
ERPEXTID |
varchar(100) |
NULLS |
|
|
|
| ERPACCOUNTINGENTITY |
varchar(22) |
NULLS |
|
|
|
| ERPLOGICALID |
varchar(255) |
NULLS |
(One) to (Many) | ||
| ERPVARIATIONID |
varchar(22) |
NULLS |
|
|
|
| ERPUNIQUEID |
varchar(64) |
NULLS |
CARRIER_ERPUNIQUEID (IE) |
|
|