MGCLatticeCustomerPackingSlipJournalLinesEntity

The MGCLatticeCustomerPackingSlipJournalLinesEntity exposes customer packing slip journal line details (CustPackingSlipTrans) including item, quantity, inventory dimensions, delivery address, and financial dimensions.

Public collection name: LatticeCustomerPackingSlipJournalLines
Primary key: SalesOrderNumber, DeliveryDate, PackingSlipId, LineNumber, InventoryLotId

Fields

Name	Type	Mandatory
`Amount`	`AmountCur`	No
`CountryRegionOfShipment`	`AddressCountryRegionId`	No
`CurrencyCode`	`CurrencyCode`	No
`DeliveryDate`	`SalesShippingDate`	No
`DeliveryType`	`TradeLineDlvTypeId`	No
`DeliveryTermsId`	`SalesDlvTermId`	No
`ExternalItemId`	`SalesExternalItemId`	No
`FullyMatched`	`TradePackingSlipFullyMatched`	No
`IntercompanyInventoryLotId`	`InventTransIdBase`	No
`IntrastatDispatchId`	`IntrastatDispatchId`	No
`InventoryQuantity`	`InventQty`	No
`InventoryRefId`	`InventRefId`	No
`InventoryRefTransId`	`InventRefTransId`	No
`InventoryRefType`	`InventRefType`	No
`InventoryLotId`	`TradeInventTransId`	No
`ItemNumber`	`ItemId`	No
`LineHeader`	`LineHeader`	No
`LineNumber`	`LineNum`	No
`ItemName`	`ItemFreeTxt`	No
`OrderedQuantity`	`SalesQty`	No
`OriginalCountryRegionId`	`ItemOrigCountryRegionId`	No
`OriginalSalesOrderNumber`	`SalesIdOrig`	No
`OriginalStateId`	`ItemOrigStateId`	No
`PackingSlipId`	`PackingSlipId`	No
`Quantity`	`SalesQty`	No
`RemainingQuantity`	`SalesQty`	No
`RemainingInventoryQuantity`	`InventQty`	No
`SalesGroup`	`CommissSalesGroup`	No
`SalesOrderNumber`	`SalesId`	No
`SalesLineShippingDateConfirmed`	`SalesShippingDateConfirmed`	No
`SalesLineShippingDateRequested`	`SalesShippingDateRequested`	No
`SalesUnitSymbol`	`SalesUnit`	No
`Scrap`	`NoYesId`	No
`IntrastatProcId`	`IntrastatProcId`	No
`IntrastatValueMST`	`IntrastatLineAmountMST`	No
`StockedProduct`	`TradeStockedProduct`	No
`IntrastatTransactionCode`	`IntrastatTransactionCodeId`	No
`IntrastatTransport`	`IntrastatTransport`	No
`ValueMST`	`AmountMST`	No
`Weight`	`Weight`	No
`DefaultDimensionDisplayValue`	`DimensionDisplayValue`	No
`DeliveryAddressCountryRegionId`	`LogisticsAddressCountryRegionId`	No
`DeliveryAddressStreetNumber`	`LogisticsAddressStreetNumber`	No
`DeliveryAddressZipCode`	`LogisticsAddressZipCodeId`	No
`DeliveryAddressCityInKana`	`AssetCityKana_JP`	No
`DeliveryAddressLongitude`	`LogisticsAddressLongitude`	No
`DeliveryAddressDescription`	`LogisticsDescription`	No
`DeliveryAddressDunsNumber`	`LogisticsDunsNumber`	No
`DeliveryAddressLocationId`	`LogisticsLocationId`	No
`DeliveryAddressStateId`	`LogisticsAddressStateId`	No
`DeliveryAddressLatitude`	`LogisticsAddressLatitude`	No
`DeliveryAddressCountryRegionISOCode`	`LogisticsAddressCountryRegionISOCode`	No
`DeliveryAddressStreet`	`LogisticsAddressStreet`	No
`DeliveryAddressTimeZone`	`Timezone`	No
`DeliveryAddressCountyId`	`LogisticsAddressCountyId`	No
`DeliveryAddressPostBox`	`LogisticsAddressPostBox`	No
`IsDeliveryAddressPrivate`	`LogisticsIsPrivate`	No
`DeliveryAddressCity`	`LogisticsAddressCityName`	No
`DeliveryAddressStreetInKana`	`AssetStreetKana_JP`	No
`DeliveryAddressDistrictName`	`LogisticsAddressDistrictName`	No
`ValidTo`	`ExpirationDateTime`	No
`ValidFrom`	`EffectiveDateTime`	No
`ItemBatchNumber`	`InventBatchId`	No
`ItemSerialNumber`	`InventSerialId`	No
`OrderedInventoryStatusId`	`WHSInventStatusId`	No
`ProductColorId`	`EcoResItemColorName`	No
`ProductConfigurationId`	`EcoResItemConfigurationName`	No
`ProductSizeId`	`EcoResItemSizeName`	No
`ProductStyleId`	`EcoResItemStyleName`	No
`ProductVersionId`	`EcoResItemVersionName`	No
`ShippingSiteId`	`InventSiteId`	No
`ShippingWarehouseId`	`InventLocationId`	No
`ShippingWarehouseLocationId`	`WMSLocationId`	No

Mappings

Entity field	Data source	Field
`Amount`	`CustPackingSlipTrans`	`AmountCur`
`CountryRegionOfShipment`	`CustPackingSlipTrans`	`CountryRegionOfShipment`
`CurrencyCode`	`CustPackingSlipTrans`	`CurrencyCode`
`DeliveryDate`	`CustPackingSlipTrans`	`DeliveryDate`
`DeliveryType`	`CustPackingSlipTrans`	`DeliveryType`
`DeliveryTermsId`	`CustPackingSlipTrans`	`DlvTerm`
`ExternalItemId`	`CustPackingSlipTrans`	`ExternalItemId`
`FullyMatched`	`CustPackingSlipTrans`	`FullyMatched`
`IntercompanyInventoryLotId`	`CustPackingSlipTrans`	`InterCompanyInventTransId`
`IntrastatDispatchId`	`CustPackingSlipTrans`	`IntrastatDispatchId`
`InventoryQuantity`	`CustPackingSlipTrans`	`inventQty`
`InventoryRefId`	`CustPackingSlipTrans`	`InventRefId`
`InventoryRefTransId`	`CustPackingSlipTrans`	`InventRefTransId`
`InventoryRefType`	`CustPackingSlipTrans`	`InventRefType`
`InventoryLotId`	`CustPackingSlipTrans`	`InventTransId`
`ItemNumber`	`CustPackingSlipTrans`	`ItemId`
`LineHeader`	`CustPackingSlipTrans`	`LineHeader`
`LineNumber`	`CustPackingSlipTrans`	`LineNum`
`ItemName`	`CustPackingSlipTrans`	`Name`
`OrderedQuantity`	`CustPackingSlipTrans`	`Ordered`
`OriginalCountryRegionId`	`CustPackingSlipTrans`	`OrigCountryRegionId`
`OriginalSalesOrderNumber`	`CustPackingSlipTrans`	`OrigSalesId`
`OriginalStateId`	`CustPackingSlipTrans`	`OrigStateId`
`PackingSlipId`	`CustPackingSlipTrans`	`PackingSlipId`
`Quantity`	`CustPackingSlipTrans`	`Qty`
`RemainingQuantity`	`CustPackingSlipTrans`	`Remain`
`RemainingInventoryQuantity`	`CustPackingSlipTrans`	`RemainInvent`
`SalesGroup`	`CustPackingSlipTrans`	`SalesGroup`
`SalesOrderNumber`	`CustPackingSlipTrans`	`SalesId`
`SalesLineShippingDateConfirmed`	`CustPackingSlipTrans`	`SalesLineShippingDateConfirmed`
`SalesLineShippingDateRequested`	`CustPackingSlipTrans`	`SalesLineShippingDateRequested`
`SalesUnitSymbol`	`CustPackingSlipTrans`	`SalesUnit`
`Scrap`	`CustPackingSlipTrans`	`Scrap`
`IntrastatProcId`	`CustPackingSlipTrans`	`StatProcId`
`IntrastatValueMST`	`CustPackingSlipTrans`	`StatValueMST`
`StockedProduct`	`CustPackingSlipTrans`	`StockedProduct`
`IntrastatTransactionCode`	`CustPackingSlipTrans`	`TransactionCode`
`IntrastatTransport`	`CustPackingSlipTrans`	`Transport`
`ValueMST`	`CustPackingSlipTrans`	`ValueMST`
`Weight`	`CustPackingSlipTrans`	`Weight`
`DefaultDimensionDisplayValue`	`DefaultDimensionDAVS`	`DisplayValue`
`DeliveryAddressCountryRegionId`	`LogisticsPostalAddressBaseEntity`	`CountryRegionId`
`DeliveryAddressStreetNumber`	`LogisticsPostalAddressBaseEntity`	`StreetNumber`
`DeliveryAddressZipCode`	`LogisticsPostalAddressBaseEntity`	`ZipCode`
`DeliveryAddressCityInKana`	`LogisticsPostalAddressBaseEntity`	`CityInKana`
`DeliveryAddressLongitude`	`LogisticsPostalAddressBaseEntity`	`Longitude`
`DeliveryAddressDescription`	`LogisticsPostalAddressBaseEntity`	`Description`
`DeliveryAddressDunsNumber`	`LogisticsPostalAddressBaseEntity`	`DunsNumber`
`DeliveryAddressLocationId`	`LogisticsPostalAddressBaseEntity`	`LocationId`
`DeliveryAddressStateId`	`LogisticsPostalAddressBaseEntity`	`State`
`DeliveryAddressLatitude`	`LogisticsPostalAddressBaseEntity`	`Latitude`
`DeliveryAddressCountryRegionISOCode`	`LogisticsPostalAddressBaseEntity`	`CountryRegionISOCode`
`DeliveryAddressStreet`	`LogisticsPostalAddressBaseEntity`	`Street`
`DeliveryAddressTimeZone`	`LogisticsPostalAddressBaseEntity`	`TimeZone`
`DeliveryAddressCountyId`	`LogisticsPostalAddressBaseEntity`	`County`
`DeliveryAddressPostBox`	`LogisticsPostalAddressBaseEntity`	`PostBox`
`IsDeliveryAddressPrivate`	`LogisticsPostalAddressBaseEntity`	`IsPrivate`
`DeliveryAddressCity`	`LogisticsPostalAddressBaseEntity`	`City`
`DeliveryAddressStreetInKana`	`LogisticsPostalAddressBaseEntity`	`StreetInKana`
`DeliveryAddressDistrictName`	`LogisticsPostalAddressBaseEntity`	`DistrictName`
`ValidTo`	`LogisticsPostalAddressBaseEntity`	`ValidTo`
`ValidFrom`	`LogisticsPostalAddressBaseEntity`	`ValidFrom`
`ItemBatchNumber`	`InventDim`	`inventBatchId`
`ItemSerialNumber`	`InventDim`	`inventSerialId`
`OrderedInventoryStatusId`	`InventDim`	`InventStatusId`
`ProductColorId`	`InventDim`	`InventColorId`
`ProductConfigurationId`	`InventDim`	`configId`
`ProductSizeId`	`InventDim`	`InventSizeId`
`ProductStyleId`	`InventDim`	`InventStyleId`
`ProductVersionId`	`InventDim`	`InventVersionId`
`ShippingSiteId`	`InventDim`	`InventSiteId`
`ShippingWarehouseId`	`InventDim`	`InventLocationId`
`ShippingWarehouseLocationId`	`InventDim`	`wMSLocationId`

Fields​

Mappings​

Fields

Mappings