project QadFinancials > class B1099MiscellaneousReport > business logic query 1099Boxes


Parameters


iiPaymentYearinteger


query condition


  each Box1099 where
Box1099.Box1099CalendarYear = iiPaymentYear AND
Box1099.Box1099IsActive = true

      each Box1099PurchaseTypeLink (inner-join) where
Box1099PurchaseTypeLink.Box1099_ID = Box1099.Box1099_ID AND

          first PurchaseType (inner-join) where
PurchaseType.PurchaseType_ID = Box1099PurchaseTypeLink.PurchaseType_ID AND
PurchaseType.PurchaseTypeIsActive = true


query resultset tq1099Boxes


field namedata typedb fielddescription
tiBox1099_IDintegerBox1099.Box1099_IDRecord ID
tiBox1099CalendarYearintegerBox1099.Box1099CalendarYearCalendar Year
tcBox1099CodecharacterBox1099.Box1099Code1099 Box Code
tdBox1099MinimumAmountLCdecimalBox1099.Box1099MinimumAmountLCMinimum Amount
tiBox1099PurchaseTypeLink_IDintegerBox1099PurchaseTypeLink.Box1099PurchaseTypeLink_IDRecord ID
tcBox1099ReferencecharacterBox1099.Box1099Reference1099 Box Reference
tiPurchaseType_IDintegerBox1099PurchaseTypeLink.PurchaseType_IDPurchase Type
tcPurchaseTypeCodecharacterPurchaseType.PurchaseTypeCodePurchase Type
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(Box1099),rowid(Box1099PurchaseTypeLink),rowid(PurchaseType)


Internal usage


QadFinancials
method B1099MiscellaneousReport.GetReportData