Added in version 8.3
The BODFIELDMAPPING table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
BODFIELDMAPPINGID (PK) |
nchar(12) |
NOT NULL |
BODFIELDMAPPING_PRIMARY (AK) |
||
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
ENTITY |
varchar(256) |
NULLS |
|
||
| PROPERTY |
nchar(12) |
NULLS |
|
|
|
| FIELDMAPPINGNAME |
nchar(1) |
NULLS |
|
|
|
| PARENTENTITY |
varchar(256) |
NULLS |
|
|
|
| ENTITYXPATH |
nchar(12) |
NULLS |
|
|
|
| PROPERTYXPATH |
nchar(12) |
NULLS |
|
|
|
| ISREQUIRED |
varchar(64) |
NULLS |
|
|
|
| DEFAULTVALUE | nchar(12) | NULLS | |||
| ISCUSTOM | varchar(64) | NULLS | |||
| ISACTIVE | nchar(12) | NULLS | |||
| BODMAPPINGID | varchar(32) | NULLS | BODFIELDMAPPING_BODMAPPINGID (IE) | (One) to (Many) | BODMAPPING.BODMAPPINGID |
| SYNCDIRECTION | varchar(64) | NULLS | |||
| SECCODEID | varchar(256) | NULLS | (One) to (Many) | SECCODEID.SECCODEID | |
| BODELEMENTSEQUENCE | varchar(100) | NULLS | |||
| SYSISACTIVE | varchar(100) | NULLS | |||
| STDBODFIELDMAPPING | nchar(12) | NULLS | |||
| SEARCHCLAUSE | nvarchar(64) | NULLS | |||
| INCLUDEINSEARCH | nchar(1) | NULLS | |||
| BACKOFFICEID | nchar(12) | NULLS | (One) to (Many) | BACKOFFICE.BACKOFFICEID | |
| ISEXTENSION | nchar(1) | NULLS |