MGCLatticeSalesOrderLineCrossReferenceEntity
Sales order line cross-references: the keys external systems use for sales order lines, one row per sales order line and external system. An empty external key clears the key.
- Public collection name:
LatticeSalesOrderLineCrossReferences
- Primary key:
InventoryLotId, ExternalSystem
Fields
| Name | Type | Mandatory | Description |
|---|
SalesOrderNumber | SalesIdBase | No | |
LineNumber | LineNum | No | |
InventoryLotId | TradeInventTransId | Yes | |
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 |
|---|
SalesOrderNumber | SalesLine | SalesId |
LineNumber | SalesLine | LineNum |
InventoryLotId | SalesLine | InventTransId |
ExternalSystem | MGCLatticeCrossReference | ExternalSystemId |
ExternalKey | MGCLatticeCrossReference | ExternalKey |