MGCLatticeInventTransactionEntity
The MGCLatticeInventTransactionEntity exposes inventory transactions from InventTrans (root), joined to InventTransOrigin for the item number, transaction id and reference category, and to InventDim for the full set of inventory dimensions (site, warehouse, location, batch, serial, status, license plate). Read-only and DMF/OData enabled with a lean, explicitly projected field set for high-volume inventory movement extract and BYOD scenarios. Keyed on the InventTrans surrogate RecId (export-oriented). InventTrans is a very large table; consumers should always constrain extracts with a $filter (for example by ItemNumber, DateFinancial/DatePhysical or InventDimId).
- Public collection name:
LatticeInventoryTransactions
- Primary key:
SysRecId
Fields
| Name | Type | Mandatory | Description |
|---|
ItemNumber | ItemId | No | |
InventoryLotId | InventTransId | No | |
ReferenceCategory | InventTransType | No | |
StatusIssue | StatusIssue | No | |
StatusReceipt | StatusReceipt | No | |
DatePhysical | DatePhysical | No | |
DateFinancial | DateFinancial | No | |
PackingSlipId | PackingSlipId | No | |
InvoiceId | InvoiceId | No | |
Quantity | InventQty | No | |
CostAmountPosted | CostAmountPosted | No | |
CostAmountPhysical | CostAmountPhysical | No | |
InventoryDimensionId | InventDimId | No | |
InventorySiteId | InventSiteId | No | |
InventoryWarehouseId | InventLocationId | No | |
WarehouseLocationId | WMSLocationId | No | |
InventoryBatchId | InventBatchId | No | |
InventorySerialId | InventSerialId | No | |
InventoryStatusId | WHSInventStatusId | No | |
LicensePlateId | WHSLicensePlateId | No | |
SysRecId | RefRecId | No | |
Mappings
| Entity field | Data source | Field |
|---|
ItemNumber | InventTransOrigin | ItemId |
InventoryLotId | InventTransOrigin | InventTransId |
ReferenceCategory | InventTransOrigin | ReferenceCategory |
StatusIssue | InventTrans | StatusIssue |
StatusReceipt | InventTrans | StatusReceipt |
DatePhysical | InventTrans | DatePhysical |
DateFinancial | InventTrans | DateFinancial |
PackingSlipId | InventTrans | PackingSlipId |
InvoiceId | InventTrans | InvoiceId |
Quantity | InventTrans | Qty |
CostAmountPosted | InventTrans | CostAmountPosted |
CostAmountPhysical | InventTrans | CostAmountPhysical |
InventoryDimensionId | InventTrans | inventDimId |
InventorySiteId | InventDim | InventSiteId |
InventoryWarehouseId | InventDim | InventLocationId |
WarehouseLocationId | InventDim | wMSLocationId |
InventoryBatchId | InventDim | InventBatchId |
InventorySerialId | InventDim | inventSerialId |
InventoryStatusId | InventDim | InventStatusId |
LicensePlateId | InventDim | LicensePlateId |
SysRecId | InventTrans | RecId |