Added in version 8.3
The BOEPASERVICE table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
| BOEPASERVICEID (PK) |
nchar(12) |
NOT NULL |
BOEPASERVICE_PRIMARY (AK) |
(One) to (Many) | BOEPAMAPPING.BOEPASERVICEID |
|
BACKOFFICEID |
nchar(12) |
NOT NULL |
BOEPASERVICE_BACKOFFICEID (IE) |
(One) to (Many) | BACKOFFICE.BACKOFFICEID |
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
ACTIONNAME |
varchar(256) |
NULLS |
|
||
|
REQUESTTEMPLATE |
ntext |
NULLS |
|
|
|
| ISACTIVE |
nchar(1) |
NULLS |
|
|
|
| DESCRIPTION |
varchar(2000) |
NULLS |
|
|
|
| SECCODEID |
nchar(12) |
NULLS |
(One) to (Many) | SECCODE.SECCODEID | |
| SERVICENAME |
nchar(12) |
NULLS |
|
|
|
| ISCUSTOM |
varchar(64) |
NULLS |
|
|
|
| PASERVICENAME |
nchar(12) |
NULLS |
|||
| SYSISACTIVE |
varchar(1) |
NULLS |
|||
| HANDLERCLASSNAME |
varchar(256) |
NULLS |
|||
| STDBOEPASERVICEID |
nchar(12) |
NULLS |
|||
| ENDPOINT |
nvarchar(1024) |
NULLS | |||
| USERNAME |
nvarchar(100) |
NULLS |
|||
| PASSWORD |
nvarchar(100) |
NULLS |
|||
| SERVICETYPE |
nvarchar(64) |
NULLS |
|||
| METHOD |
nvarchar(4) |
NULLS |
|||
| ACTION |
nvarchar(256) |
NULLS |
|||
| AUTHTYPE |
nvarchar(1) |
NULLS |
|||
| ISEXTENSION | nchar(1) | NULLS |