Added in version 8.3
The ERPSHIPTO table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
| ERPSHIPTOID (PK) |
nchar(12) |
NOT NULL |
ERPSHIPTO_PRIMARY (AK) |
(One) to (Many) | ADDRESS.ENTITYID |
| (One) to (Many) | ERPBILLTOSHIPTO.ERPSHIPTOID | ||||
| (One) to (Many) | ERPINVOICE.ERPSHIPTOID | ||||
| (One) to (Many) | ERPRECEIVABLE.ERPSHIPTOID | ||||
| (One) to (Many) | ERPSHIPMENT.ERPSHIPTOID | ||||
| (One) to (Many) | ERPSHIPTOACCOUNT.ERPSHIPTOID | ||||
| (One) to (Many) | ERPSHIPTOACCOUNTINGENTITY.ERPSHIPTOID | ||||
| (One) to (Many) | ERPSHIPTOCONTACT.ERPSHIPTOID | ||||
| (One) to (Many) | ERPSHIPTOPERSON.ERPSHIPTOID | ||||
| (One) to (Many) | QUOTE.SHIPTOID | ||||
| (One) to (Many) | QUOTEITEM.SHIPTOID | ||||
| (One) to (Many) | SALESORDER.ERPBILLTOID | ||||
| (One) to (Many) | SALESORDERITEMS.ERPSHIPTOID | ||||
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
ADDRESSID (FK) |
nchar(12) |
NULLS |
ERPSHIPTO_ADDRESSID(IE) |
(Many) to (One) | ADDRESS.ADDRESSID |
|
NAME |
varchar(100) |
NULLS |
|||
|
CARRIERNAME |
varchar(64) |
NULLS |
|||
|
TERRITORY |
varchar(64) |
NULLS |
|||
|
FAX |
varchar(48) |
NULLS |
|||
|
MAINPHONE |
varchar(48) |
NULLS |
|||
|
|
varchar(255) |
NULLS |
|||
|
ERPDISPLAYID |
varchar(100) |
NULLS |
|||
|
ERPEXTID |
varchar(100) |
NULLS |
ERPSHIPITO_ERPEXTID(IE) |
||
|
ERPACCOUNTINGENTITYID |
varchar(22) |
NULLS |
|
||
|
ERPLOGICALID |
varchar(255) |
NULLS |
|
||
|
ERPVARIATIONID |
varchar(22) |
NULLS |
|
||
|
TAXCODE |
varchar(64) |
NULLS |
|
||
|
PAYMENTTERMID |
varchar(64) |
NULLS |
|
||
|
STATUSDATE |
datetime |
NULLS |
|
||
|
ERPUNIQUEID |
varchar(377) |
NULLS |
ERPSHIPTO_ERPUNIQUEID(IE) |
||
|
ERPPAYMENTMETHOD |
varchar(64) |
NULLS |
|
||
|
ERPCUSTOMERTYPE |
varchar(64) |
NULLS |
|||
|
BUYERCONTACTID |
nchar(12) |
NULLS |
ERPSHIPTO_BUYERCONTACTID(CA) |
(Many) to (One) | CONTACT.CONTACTID |
|
ERPSTATUS |
varchar(64) |
NULLS |
|
||
|
SECCODEID(FK) |
nchar(12) |
NULLS |
|
(One) to (Many) | SECCODE.SECCODEID |
|
CARRIERID |
nchar(12) |
NULLS |
|
(One) to (Many) | CARRIER.CARRIERID |
|
SYNCSTATUS |
varchar(64) |
NULLS |
|
||
|
ERPNOTES |
text |
NULLS |