Added in version 8.3
The BACKOFFICE table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
BACKOFFICEID (PK) |
nchar(12) |
NOT NULL |
BACKOFFICEID_PRIMARY (AK) |
(One) to (Many) | ACCOUNTACCOUNTINGENTITY.BACKOFFICEID |
| (One) to (Many) | BACKOFFICEACCTENTITY.BACKOFFICEID | ||||
| (One) to (Many) | BODMAPPING.BACKOFFICEID | ||||
| (One) to (Many) | BOEPASERVICE.BACKOFFICEID | ||||
| (One) to (Many) | CONTACTACCOUNTINGENTITY.BACKOFFICEID | ||||
| (One) to (Many) | ERPBILLTOACCOUNTINGENTITY.BACKOFFICEID | ||||
| (One) to (Many) | ERPPAYFROMACCOUNTINGENTITY.BACKOFFICEID | ||||
| (One) to (Many) | SLXPRICELIST.BACKOFFICEID | ||||
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
BACKOFFICENAME |
varchar(256) |
NULLS |
|
||
|
DEFAULTRECORDOWNER |
nchar(12) |
NULLS |
|
|
|
| ISACTIVE |
nchar(1) |
NULLS |
|
|
|
| LOGICALID |
varchar(256) |
NULLS |
LOGICALID_IDX (IE) |
|
|
| INTEGRATIONID |
nchar(12) |
NULLS |
|
(One) to (Many) |
|
| ACCOUNTID |
nchar(12) |
NULLS |
|
(One) to (Many) |
|
| SALESPERSONROLE |
varchar(64) |
NULLS |
|
|
|
| DEFAULTACCOUNTMANAGER | nchar(12) | NULLS | (One) to (Many) | USERSECURITY.USERID | |
| COUNTRYCODEFORMAT | varchar(64) | NULLS | |||
| SECCODEID | nchar(12) | NULLS | (One) to (Many) | SECCODEID.SECCODEID | |
| VERSION | varchar(32) | NULLS | |||
| PATYPE | varchar(64) | NULLS | |||
| PAENDPOINT | varchar(256) | NULLS | |||
| PAUSERNAME | varchar(100) | NULLS | |||
| PAPASSWORD | varchar(100) | NULLS | |||
| STDBACKOFFICEID | nchar(12) | NULLS | |||
| LANGUAGEATTRIBUTE | varchar(64) | NULLS |