Commerce
BCEntityImportMapping
Represents a mapping used for importing of objects. The mapping is inserted by user on the Entities (BC202000) form.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BindingID | int | BCEntity | ||
Description:The ID of the binding this mapping belongs to. | ||||
ConnectorType | char(3) | BCEntity | ||
Description:The type of connector this mapping belongs to. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:The ID of the account that created this record. | ||||
CreatedByScreenID | char(8) | - | ||
Description:The ID of the Screen that created this record. | ||||
CreatedDateTime | datetime | - | ||
Description:The Time this record was created | ||||
EntityType | char(2) | BCEntity | ||
Description:The entity type this mapping belongs to. | ||||
ImportMappingID | int | - | ||
Description:Represents an order number of this entry among all entris of this type and determines its position in the grid. | ||||
IsActive | bit | Active | - | |
Description:The property that indicates whether the rule is applied to the import. If the property equals false, this rule is not applied to the import. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:The ID of the account that last modified this record. | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:The ID of the screen that last modified this record. | ||||
LastModifiedDateTime | datetime | - | ||
Description:The Time this record was last modified. | ||||
NoteID | uniqueidentifier | - | ||
Description:The Note ID for this record. | ||||
SortOrder | int | Line Nbr. | - | |
Description:The sort order of this record. | ||||
SourceField | nvarchar | External Field / Value | - | |
Description:The field that contains the value to be applied to the target field. | ||||
SourceObject | nvarchar(100) | External Object | - | |
Description:The object that contains source field BCEntityImportMapping.SourceField that value should be taken from. | ||||
TargetField | nvarchar(100) | ERP Field | - | |
Description:The field to which the target object value should be applied. | ||||
TargetObject | nvarchar(100) | ERP Object | - | |
Description:The object that contains the value which should be applied to the target field. For details, BCEntityImportMapping.TargetField. | ||||
Tstamp | timestamp | - | ||
Description:The Time Stamp for this record. | ||||