MGCLatticeProductVariantCrossReferenceEntity
Product variant cross-references: the keys external systems use for released product variants, one row per variant and external system. An empty external key clears the key.
- Public collection name:
LatticeProductVariantCrossReferences
- Primary key:
ItemNumber, ProductConfigurationId, ProductSizeId, ProductColorId, ProductStyleId, ProductVersionId, ExternalSystem
Fields
| Name | Type | Mandatory | Description |
|---|
ItemNumber | ItemId | Yes | |
ProductConfigurationId | EcoResItemConfigurationName | No | |
ProductSizeId | EcoResItemSizeName | No | |
ProductColorId | EcoResItemColorName | No | |
ProductStyleId | EcoResItemStyleName | No | |
ProductVersionId | EcoResItemVersionName | No | |
ExternalSystem | MGCLatticeExternalSystemId | Yes | The external system, such as a CRM, a marketplace or a legacy ERP, whose key this is. |
ExternalKey | MGCLatticeExternalKey | No | The external system's own key for this record, such as its customer or order number. |
Mappings
| Entity field | Data source | Field |
|---|
ItemNumber | InventDimCombination | ItemId |
ProductConfigurationId | InventDim | configId |
ProductSizeId | InventDim | InventSizeId |
ProductColorId | InventDim | InventColorId |
ProductStyleId | InventDim | InventStyleId |
ProductVersionId | InventDim | InventVersionId |
ExternalSystem | MGCLatticeCrossReference | ExternalSystemId |
ExternalKey | MGCLatticeCrossReference | ExternalKey |