MGCLatticeSetBasedInventoryJournalLineEntity

Imports inventory journal lines of the movement, adjustment, transfer, counting, project and ownership change journal types in bulk with set-based processing.

Primary key: JournalNumber, LineNumber

Fields

Name	Type	Mandatory
`JournalNumber`	`InventJournalId`	Yes
`JournalNameId`	`InventJournalNameId`	No
`LineNumber`	`LineNum`	Yes
`TransactionDate`	`JournalTransDate`	No
`ItemNumber`	`ItemIdInventoried`	Yes
`InventoryQuantity`	`InventQtyJournal`	No
`CountedQuantity`	`InventQtyCounted`	No
`UnitCost`	`ItemCostPrice`	No
`UnitCostQuantity`	`InventPriceUnitQty`	No
`CostAmount`	`CostAmount`	No
`FixedCostCharges`	`CostMarkup`	No
`ProjectId`	`ProjId`	No
`ProjectCategoryId`	`ProjCategoryId`	No
`ProjectLinePropertyId`	`ProjLinePropertyId`	No
`ProjectSalesPrice`	`ProjSalesPriceCost`	No
`ProjectSalesCurrencyCode`	`ProjSalesCurrencyCode`	No
`InventorySiteId`	`InventSiteId`	No
`InventoryWarehouseId`	`InventLocationId`	No
`WarehouseLocationId`	`WMSLocationId`	No
`ItemBatchNumber`	`InventBatchId`	No
`ItemSerialNumber`	`InventSerialId`	No
`InventoryStatusId`	`WHSInventStatusId`	No
`LicensePlateNumber`	`WHSLicensePlateId`	No
`ProductConfigurationId`	`EcoResItemConfigurationName`	No
`ProductSizeId`	`EcoResItemSizeName`	No
`ProductColorId`	`EcoResItemColorName`	No
`ProductStyleId`	`EcoResItemStyleName`	No
`ProductVersionId`	`EcoResItemVersionName`	No
`InventoryOwnerId`	`InventOwnerId`	No
`ToInventorySiteId`	`InventSiteId`	No
`ToInventoryWarehouseId`	`InventLocationId`	No
`ToWarehouseLocationId`	`WMSLocationId`	No
`ToItemBatchNumber`	`InventBatchId`	No
`ToItemSerialNumber`	`InventSerialId`	No
`ToInventoryStatusId`	`WHSInventStatusId`	No
`ToLicensePlateNumber`	`WHSLicensePlateId`	No
`ToInventoryOwnerId`	`InventOwnerId`	No
`OffsetMainAccountId`	`MainAccountNum`	No
`DefaultDimensionDisplayValue`	`DimensionDisplayValue`	No

Mappings

Entity field	Data source	Field
`JournalNumber`	`InventJournalTable`	`JournalId`
`JournalNameId`	`InventJournalTable`	`JournalNameId`
`LineNumber`	`InventJournalTrans`	`LineNum`
`TransactionDate`	`InventJournalTrans`	`TransDate`
`ItemNumber`	`InventJournalTrans`	`ItemId`
`InventoryQuantity`	`InventJournalTrans`	`Qty`
`CountedQuantity`	`InventJournalTrans`	`Counted`
`UnitCost`	`InventJournalTrans`	`CostPrice`
`UnitCostQuantity`	`InventJournalTrans`	`PriceUnit`
`CostAmount`	`InventJournalTrans`	`CostAmount`
`FixedCostCharges`	`InventJournalTrans`	`CostMarkup`
`ProjectId`	`InventJournalTrans`	`ProjId`
`ProjectCategoryId`	`InventJournalTrans`	`ProjCategoryId`
`ProjectLinePropertyId`	`InventJournalTrans`	`ProjLinePropertyId`
`ProjectSalesPrice`	`InventJournalTrans`	`ProjSalesPrice`
`ProjectSalesCurrencyCode`	`InventJournalTrans`	`ProjSalesCurrencyId`
`InventorySiteId`	`InventDim`	`InventSiteId`
`InventoryWarehouseId`	`InventDim`	`InventLocationId`
`WarehouseLocationId`	`InventDim`	`wMSLocationId`
`ItemBatchNumber`	`InventDim`	`inventBatchId`
`ItemSerialNumber`	`InventDim`	`inventSerialId`
`InventoryStatusId`	`InventDim`	`InventStatusId`
`LicensePlateNumber`	`InventDim`	`LicensePlateId`
`ProductConfigurationId`	`InventDim`	`configId`
`ProductSizeId`	`InventDim`	`InventSizeId`
`ProductColorId`	`InventDim`	`InventColorId`
`ProductStyleId`	`InventDim`	`InventStyleId`
`ProductVersionId`	`InventDim`	`InventVersionId`
`InventoryOwnerId`	`InventDim`	`InventOwnerId_RU`
`ToInventorySiteId`	`ToInventDim`	`InventSiteId`
`ToInventoryWarehouseId`	`ToInventDim`	`InventLocationId`
`ToWarehouseLocationId`	`ToInventDim`	`wMSLocationId`
`ToItemBatchNumber`	`ToInventDim`	`inventBatchId`
`ToItemSerialNumber`	`ToInventDim`	`inventSerialId`
`ToInventoryStatusId`	`ToInventDim`	`InventStatusId`
`ToLicensePlateNumber`	`ToInventDim`	`LicensePlateId`
`ToInventoryOwnerId`	`ToInventDim`	`InventOwnerId_RU`

Fields​

Mappings​

Fields

Mappings