BackOfficeUserImportErrRecords
Primary Key
| Primary Key | Field Type |
|---|---|
| Id | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| BackOfficeId | int | yes | ||
| RE7RecordsId | int | yes | ||
| Quarantine | bit | Default = 0 | ||
| UserName | nvarchar(100) | yes | ||
| Password | nvarchar(40) | yes | ||
| FirstName | nvarchar(100) | yes | ||
| LastName | nvarchar(100) | yes | ||
| ErrMsg | nvarchar(510) | yes | ||
| nvarchar(200) | yes |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| BackOfficeSystemsId | int | yes | BackOfficeSystems.ID | |
| ClientUsersId | int | yes | ClientUsers.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_BackOfficeUserImportErrRecords_BOSysId_BOId | BackOfficeSystemsId, BackOfficeId | |||
| PK_BackOfficeUserImportErrRecords | Id | yes | yes | yes |