INInput.cs

[PXProjection(typeof(Select4<INTranSplit,
                    Where<INTranSplit.released, Equal<True>,
                        And<INTranSplit.lotSerialNbr, IsNotNull,
                        And<
                            Where<INTranSplit.docType, Equal<INDocType.receipt>,
                                Or<Where<INTranSplit.docType, Equal<INDocType.issue>,
                                    And<INTranSplit.tranType, Equal<INTranType.creditMemo>>>>>>>>,
                    Aggregate<GroupBy<INTranSplit.inventoryID,
                                GroupBy<INTranSplit.lotSerialNbr,
                                    Max<INTranSplit.releasedDateTime>>>>>))]
    public partial class INInput : IBqlTable
    {
        #region InventoryID
        public abstract class inventoryID : PX.Data.BQL.BqlInt.Field<inventoryID> { }

        [StockItem(IsKey = true, BqlField = typeof(INTranSplit.inventoryID), Enabled = false)]
        public virtual Int32? InventoryID { get; set; }
        #endregion
        #region LotSerialNbr
        public abstract class lotSerialNbr : PX.Data.BQL.BqlString.Field<lotSerialNbr> { }

        [PXDBString(100, IsUnicode = true, InputMask = "", BqlField = typeof(INTranSplit.lotSerialNbr))]
        [PXUIField(DisplayName = "Lot/Serial Nbr.", FieldClass = "LotSerial")]
        public virtual String LotSerialNbr { get; set; }
        #endregion
        #region ReleasedDateTime
        public abstract class releasedDateTime : PX.Data.BQL.BqlDateTime.Field<releasedDateTime> { }

        [PXDBDate(BqlField = typeof(INTranSplit.releasedDateTime))]
        public virtual DateTime? ReleasedDateTime { get; set; }
        #endregion
    }