project QadFinancials > class BBox1099 > business logic query PurTypeLinkByYear


Parameters


iiCalYearinteger
iiPurTypeLinkIDinteger
iiPurTypeIDinteger


query condition


  each Box1099 where
Box1099.Box1099CalendarYear = iiCalYear

      each Box1099PurchaseTypeLink (inner-join) where
Box1099PurchaseTypeLink.Box1099_ID = Box1099.Box1099_ID AND
Box1099PurchaseTypeLink.Box1099PurchaseTypeLink_ID <> iiPurTypeLinkID AND
Box1099PurchaseTypeLink.PurchaseType_ID = iiPurTypeID


query resultset tqPurTypeLinkByYear


field namedata typedb fielddescription
tiBox1099_IDintegerBox1099PurchaseTypeLink.Box1099_IDLink to Box1099
tiBox1099CalendarYearintegerBox1099.Box1099CalendarYearCalendar Year
tiBox1099PurchaseTypeLink_IDintegerBox1099PurchaseTypeLink.Box1099PurchaseTypeLink_IDRecord ID
tiPurchaseType_IDintegerBox1099PurchaseTypeLink.PurchaseType_IDPurchase Type


Internal usage


QadFinancials
method BBox1099.ValidateComponent