Commerce
BCMatrixOptionsMapping
Represents the mapping of Matrix Items external options to the ERP attributes.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
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 | Created On | - | |
Description:The Time this record was created | ||||
ExternID | nvarchar(128) | External ID | - | |
Description:The unique identifier of the item in the external system. The property is a key field. | ||||
ExternalOptionID | nvarchar | - | ||
Description:The option id in the external system | ||||
ExternalOptionName | nvarchar | External Option | - | |
Description:The option name in the external system | ||||
ExternalOptionSortOrder | int | - | ||
Description:Sort order of the option. | ||||
ExternalOptionValue | nvarchar | External Option Value | - | |
Description:The original value from the external system | ||||
ExternalOptionValueID | nvarchar | - | ||
Description:The original value from the external system | ||||
ItemClassID | int | ERP Item Class | INItemClass | |
Description:The Item Class Id used for the mapping | ||||
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 | Last Modified On | - | |
Description:The Time this record was last modified. | ||||
MappedAttributeID | nvarchar | ERP Attribute | CSAttributeGroup | |
Description:The mapped attribute id | ||||
MappedValue | nvarchar | ERP Attribute Value | CSAttributeDetail | |
Description:The mapped value in the ERP | ||||
OptionMappingID | int | - | ||
Description:Identity of the record | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:Indicates if the this record is selected. | ||||
SyncID | int | Sync ID | BCSyncStatus | |
Description:Sync Id of entity in cref="BCSyncStatus" | ||||