While this table does not have a field defined as a primary key, the BODMAPPINGID field should be unique and considered a primary key.
Added in version 8.3
The BODMAPPING 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 BODMAPPINGID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
BODMAPPINGID |
nchar(12) |
NOT NULL |
BODMAPPING_PRIMARY (AK) |
(One) to (Many) | BODFIELDMAPPING.BODMAPPINGID |
| BACKOFFICEID (FK) |
nchar(12) |
NOT NULL |
BODMAPPING_BACKOFFICEID (IE) | (One) to (Many) | BACKOFFICE.BACKOFFICEID |
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
| BODMAPPINGNAME |
varchar(256) |
NULLS |
|
||
| NOUN |
varchar(256) |
NULLS |
|
|
|
| ENTITYNAME |
varchar(256) |
NULLS |
|
|
|
| UNIQUEIDXPATH |
varchar(2000) |
NULLS |
|
|
|
| UNIQUEIDNODE |
varchar(2000) |
NULLS |
|
|
|
| PRIORITY |
integer |
NULLS |
|
|
|
| OUTBOUNDTEMPLATE |
ntext |
NULLS |
|
|
|
| RECORDOWNER | varchar(100) | NULLS | |||
| ISCUSTOM | nchar(1) | NULLS | |||
| ISACTIVE | nchar(1) | NULLS | |||
| HANDLERCLASSNAME | varchar(2000) | NULLS | |||
| DELETEBEHAVIOR | varchar(64) | NULLS | |||
| PARENTBODMAPPINGID | nchar(12) | NULLS | |||
| RELEASEID | varchar(100) | NULLS | |||
| VERSIONID | varchar(100) | NULLS | |||
| GENOUTTEMPLATE | nchar(1) | NULLS | |||
| SECCODEID | nchar(1) | NULLS | (One) to (Many) | SECCODE.SECCODEID | |
| SYSISACTIVE | nchar(1) | NULLS | |||
| OUTBOUNDONCREATE | varchar(1) | NULLS | |||
| OUTBOUNDONUPDATE | varchar(1) | NULLS | |||
| OUTBOUNDONDELETE | varchar(1) | NULLS | |||
| STDBODMAPPINGID | nchar(12) | NULLS | |||
| SYSTEMOFRECORD | nvarchar(64) | NULLS | |||
| SYNCTEMPLATE | ntext | NULLS | |||
| ACKNOWLEDGETEMPLATE | ntext | NULLS | |||
| PRENOUNHANDLER | nvarchar(2000) | NULLS | |||
| OUTBOUNDHANDLER | nvarchar(2000) | NULLS | |||
| ISEXTENSION | nchar(1) | NULLS | |||
| ISMASTERDATA | nchar(1) | NULLS |