ErpField Table (425)
Store the metadata describing the fields that belong to an actor/connection combination, as described by the Erp ConnectorFields
| Name | Description | Type | Nullable |
|---|---|---|---|
| erpfield_id | Primary key | PK | No |
| ErpConnectionActorTypeId | Link to Erp Connection/Actor type | FK ErpConnectionActorType | No |
| ErpFieldKey | The ERP field key | String(254) | No |
| DisplayName | Localized field name – shown in the GUI as the label for the control. | String(254) | No |
| DisplayDescription | Tooltip for the field name. | String(254) | Yes |
| FieldType | Field type | Enum FieldMetadataType | Yes |
| ListName | The ERP list name, if the field has a list of values supplied by the ERP Connector | String(254) | Yes |
| DefaultValue | Default value, stored using CultureDataFormatter format if it is not a string | String(254) | Yes |
| MaxLength | Maximum size of the field, if there is a limit | Int | Yes |
| Access | Access restrictions for the field | Enum FieldAccess | Yes |
| HasFirstSyncDefaultValue | Should a default value be set on first sync | Bool | Yes |
| FirstSyncDefaultValue | The default value to be set, can be blank | String(254) | Yes |
| PromptUser | Should the field be shown in the first-sync GUI; independent of whether a default value should be set | Bool | Yes |
| Mandatory | Should the user be forced to set a value (the Erp Connector may declare fields mandatory as well) | Bool | Yes |
| CrmFieldKey | The CRM field name, as implemented by the Sync entities | String(254) | Yes |
| SyncToCrm | Should value changes in ERP be automatically transferred to CRM | Bool | Yes |
| SyncToErp | Should value changes in CRM be automatically transferred to ERP | Bool | Yes |
| ShowInGui | Should this field be shown as a (read-only!) field in the CRM Gui | Bool | Yes |
| ShowInSearch | Should this field be shown in searches | Bool | Yes |
| Rank | Rank order of lines in GUI, relevant if ShowInGui is true | Int | Yes |
| ListReference | Reference to CRM list, if a mapping exists. Format: table=<table name>[&<extra id>=<value>], to make it independent of actual table numbers | String(254) | Yes |
| MissingInERP | Set to true if this field has previously been defined, but was no longer in the ‘supported fields’ response from the connector. This typically happens if the target ERP system changes, and means the field needs to be unmapped. | Bool | Yes |
| registered | Registered when | UtcDateTime | No |
| registered_associate_id | Registered by whom | FK associate | No |
| updated | Last updated when | UtcDateTime | No |
| updated_associate_id | Last updated by whom | FK associate | No |
| updatedCount | Number of updates made to this record | UShort | No |
Indexes
| Fields | Types | Description |
|---|---|---|
| ErpConnectionActorTypeId, ErpFieldKey | FK, String(254) | Unique |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| ErpConnectionActorType | Data about the configuration of one Erp Actor on one ErpConnection |
| ErpListItemMapping | Defines a mapping of ERP to CRM fields, per connection and actor type |
Replication Flags
- None
Security Flags
- No access control via user’s Role.