MGCLatticeRouteVersionCrossReferenceEntity
Route version cross-references: the keys external systems use for route versions, one row per version and external system. A version is named by the key of the standard route version entity (RouteVersionV2Entity): item, route, site and product dimensions, active flag, valid-from date and from quantity. An empty external key clears the key.
- Public collection name:
LatticeRouteVersionCrossReferences
- Primary key:
ItemNumber, RouteId, ProductionSiteId, ProductConfigurationId, ProductColorId, ProductSizeId, ProductStyleId, ProductVersionId, IsActive, ValidFromDate, ValidFromQuantity, ExternalSystem
Fields
| Name | Type | Mandatory | Description |
|---|
ItemNumber | ItemIdProduction | Yes | |
RouteId | RouteId | Yes | |
ProductionSiteId | InventSiteId | Yes | |
ProductConfigurationId | EcoResItemConfigurationName | No | |
ProductColorId | EcoResItemColorName | No | |
ProductSizeId | EcoResItemSizeName | No | |
ProductStyleId | EcoResItemStyleName | No | |
ProductVersionId | EcoResItemVersionName | No | |
IsActive | RouteVersionActive | No | |
ValidFromDate | FromDate | No | |
ValidFromQuantity | ProductFromQuantity | 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 | RouteVersion | ItemId |
RouteId | RouteVersion | RouteId |
ProductionSiteId | InventDim | InventSiteId |
ProductConfigurationId | InventDim | configId |
ProductColorId | InventDim | InventColorId |
ProductSizeId | InventDim | InventSizeId |
ProductStyleId | InventDim | InventStyleId |
ProductVersionId | InventDim | InventVersionId |
IsActive | RouteVersion | Active |
ValidFromDate | RouteVersion | FromDate |
ValidFromQuantity | RouteVersion | FromQty |
ExternalSystem | MGCLatticeCrossReference | ExternalSystemId |
ExternalKey | MGCLatticeCrossReference | ExternalKey |