ERPSHIPTOCONTACT Table

Added in version 8.3

The ERPSHIPTOCONTACT table is used for Infor CRM Back Office Extension (ICBOE) functionality.

Legend
 

Field Datatype (Length) Allow Nulls Indexes Relationship Related Table and Field
ERPSHIPTOCONTACTID(PK)

nchar(12)

NOT NULL

ERPSHIPTOCONTACT_PRIMARY (AK)

   

CREATEUSER (FK)

nchar(12)

NULLS

 

   

CREATEDATE

datetime

NULLS

 

   

MODIFYUSER (FK)

nchar(12)

NULLS

 

   

MODIFYDATE

datetime

NULLS

 

   

CONTACTID(FK)

nchar(12)

NULLS

ERPSHIPTOCONTACT_CONTACTID(IE)

(One) to (Many) CONTACT.CONTACTID

ERPSHIPTOID(FK)

nchar(12)

NULLS

ERPSHIPTOCONTACT_SHIPTOID(IE)

(One) to (Many) ERPSHIPTO.ERPSHIPTOID