Added in version 8.3
The ERPRECEIVABLEADDRESS table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ERPSHIPMENTADDRESSID (PK) |
nchar(12) |
NOT NULL
|
ERPSHIPMENTADDRESS_PRIMARY_PK (AK) |
|
|
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
ADDRESS1 |
varchar(64) |
NULLS |
|
||
|
ADDRESS2 |
varchar(64) |
NULLS |
|
|
|
|
ADDRESS3 |
varchar(64) |
NULLS |
|
|
|
|
ADDRESS4 |
varchar(64) |
NULLS |
|
|
|
|
CITY |
varchar(64) |
NULLS |
|
|
|
|
STATE |
varchar(100) |
NULLS |
|
|
|
|
POSTALCODE |
varchar(100) |
NULLS |
|
|
|
|
COUNTRYCODE |
varchar(100) |
NULLS |
|||
|
COUNTRY |
varchar(100) |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(64) |
NULLS |
|||
|
ADDRESS5 |
varchar(64) |
NULLS |
|||
|
ADDRESS6 |
varchar(64) |
NULLS |
|||
|
ERPSHIPMENTID (FK) |
nchar(12) |
NULLS |
ERPSHIPMENTADDRESS_ERPSHIPMENTID (IE) |
(One) to (Many) |
|
| ADDRESSID | nchar(12) |
NULLS |
(One) to (Many) | ADDRESS.ADDRESSID |