ErpField Table (425)
Some tooltip text!
• 4 minutes to read
• 4 minutes to read
Store the metadata describing the fields that belong to an actor/connection combination, as described by the Erp Connector
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| erpfield_id | Primary key | PK | |
| ErpConnectionActorTypeId | Link to Erp Connection/Actor type | FK ErpConnectionActorType | |
| ErpFieldKey | The ERP field key | String(254) | |
| DisplayName | Localized field name – shown in the GUI as the label for the control. | String(254) | |
| DisplayDescription | Tooltip for the field name. | String(254) | ● |
| FieldType | Field type | Enum FieldMetadataType | ● |
| ListName | The ERP list name, if the field has a list of values supplied by the ERP Connector | String(254) | ● |
| DefaultValue | Default value, stored using CultureDataFormatter format if it is not a string | String(254) | ● |
| MaxLength | Maximum size of the field, if there is a limit | Int | ● |
| Access | Access restrictions for the field | Enum FieldAccess | ● |
| HasFirstSyncDefaultValue | Should a default value be set on first sync | Bool | ● |
| FirstSyncDefaultValue | The default value to be set, can be blank | String(254) | ● |
| PromptUser | Should the field be shown in the first-sync GUI; independent of whether a default value should be set | Bool | ● |
| Mandatory | Should the user be forced to set a value (the Erp Connector may declare fields mandatory as well) | Bool | ● |
| CrmFieldKey | The CRM field name, as implemented by the Sync entities | String(254) | ● |
| SyncToCrm | Should value changes in ERP be automatically transferred to CRM | Bool | ● |
| SyncToErp | Should value changes in CRM be automatically transferred to ERP | Bool | ● |
| ShowInGui | Should this field be shown as a (read-only!) field in the CRM Gui | Bool | ● |
| ShowInSearch | Should this field be shown in searches | Bool | ● |
| Rank | Rank order of lines in GUI, relevant if ShowInGui is true | Int | ● |
| 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) | ● |
| 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 | ● |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort |
Access restrictions and mandatory status, if any
| --- | |
|---|---|
| 0 | Normal field, no particular restrictions |
| 1 | This field is mandatory |
| 2 | This field is read-only |
Describes the different types of controls that can appear in the Configure connection dialog
| MetadataType | Description |
|---|---|
| 0 | Checkbox widget: Boolean value |
| 1 | Single line textbox |
| 2 | Single line edit field with password characters - input is hidden. |
| 3 | Single line integer number field. |
| 4 | Single line decimal number field. |
| 5 | Dropdown listbox. The list name must be provided. The list items are provided by another interface. The default value should be the list key, not the text of the list item. |
| 6 | Date |
| 99 | Static text - has no input widget associated with it. Can be used for spacing/layout. |
Indexes
| Fields | Types | Description |
|---|---|---|
| erpfield_id | PK | Clustered, Unique |
| 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.