PXDBScalar to retrieve Qty Returned for a Shipment Line

PXDBScalar_Search4_ShipLine_QtyReturned.cs

#region UsrQtyReturned
[PXDecimal]
[PXUIField(DisplayName = Messages.FldUsrQtyReturned, Enabled = false)]
[PXDBScalar(
	typeof(Search4<SOLine.orderQty,
		Where<SOLine.origOrderType, Equal<SOShipLine.origOrderType>,
			And<SOLine.origOrderNbr, Equal<SOShipLine.origOrderNbr>,
			And<SOLine.origLineNbr, Equal<SOShipLine.origLineNbr>,
			And<SOLine.origOrderNbr, IsNotNull>>>>,
		Aggregate<Sum<SOLine.orderQty,
			GroupBy<SOLine.origOrderType,
			GroupBy<SOLine.origOrderNbr,
			GroupBy<SOLine.origLineNbr>>>>>>
	))]
public decimal? UsrQtyReturned
{
	get { return _UsrQtyReturned = (_UsrQtyReturned ?? 0); }
	set { _UsrQtyReturned = (value ?? 0); }
}
public decimal? _UsrQtyReturned; 
public abstract class UsrQtyReturned : PX.Data.BQL.BqlDecimal.Field<UsrQtyReturned> { }
#endregion