Added in version 8.3
The BOEPAMAPPING table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
BOEPAMAPPINGID (PK) |
nchar(12) |
NOT NULL |
BOEPAMAPPING_PRIMARY (AK) |
||
| BOEPASERVICEID |
nchar(12) |
NOT NULL |
BOEPASERICID (IE) | (One) to (Many) | BOEPASERVICE.BOEPASERVICEID |
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
| PAMAPPINGNAME |
varchar(256) |
NULLS |
|
||
| PROPERTY |
varchar(256) |
NULLS |
|
|
|
| DESCRIPTION |
varchar(2000) |
NULLS |
|
|
|
| ISACTIVE |
nchar(1) |
NULLS |
|||
| SYNCDIRECTION | varchar(64) |
NULLS |
|||
| SECCODEID | nchar(12) |
NULLS |
(One) to (Many) | SECCODE.SECCODEID | |
| ISCUSTOM |
nchar(1) |
NULLS |
|||
| ISREQUIRED | nchar(1) |
NULLS |
|||
| ENTITY | varchar(256) |
NULLS |
|||
| SYSISACTIVE | nchar(1) |
NULLS |
|||
| ENTITYXPATH |
varchar(600) |
NULLS |
|
|
|
| PROPERTYXPATH |
varchar(600) |
NULLS |
|
|
|
| REQUESTELEMENTSEQUENCE | integer | NULLS | |||
| PARENTENTITY |
varchar(256) |
NULLS |
|
|
|
| DEFAULTVALUE |
varchar(1000) |
NULLS |
|
|
|
| STDBODMAPPINGID | nchar(12) |
NULLS |
|||
| BACKOFFICEID | nchar(12) | NULLS | (One) to (Many) | BACKOFFICE.BACKOFFICEID | |
| ISEXTENSION | nchar(1) | NULLS |