project QadFinancials > class BDeductionCat > business logic (internal API) query DeductionCatExpenseInfoByCode


query filter (table tFilter)


tcBusinessFieldNametcDataTypetcOperator
iiCompanyIdi
icDeductionCatCodec=
iiDomain_IDi=
tDeductionCat.DeductionCatCodec=,>=,>,<>,<=,<,begins,can-do,matches
tJournal.JournalCodec=,>=,>,<>,<=,<,begins,can-do,matches


Parameters (internal)


iiCompanyIdintegerCompany id
icDeductionCatCodecharacter
iiDomain_IDinteger


query condition


  each DeductionCat where
DeductionCat.DeductionCatCode = icDeductionCatCode

      each DeductionCatLine (inner-join) where
DeductionCatLine.DeductionCat_ID = DeductionCat.DeductionCat_ID AND
DeductionCatLine.Domain_ID = iiDomain_ID

          first Journal (inner-join) where
Journal.Journal_ID = DeductionCatLine.ExpenseJournal_ID AND
Journal.SharedSet_ID <> 0


query resultset tqDeductionCatExpenseInfoByCode


field namedata typedb fielddescription
tiDeductionCat_IDintegerDeductionCat.DeductionCat_IDRecord ID
tcDeductionCatCodecharacterDeductionCat.DeductionCatCodeDeduction Category Code
tiExpenseJournal_IDintegerDeductionCatLine.ExpenseJournal_IDLink to ExpenseJournal
tcExpenseJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
DeductionCatCustomcharactercalculatedcustom fields
DeductionCatLineCustomcharactercalculatedcustom fields
JournalCustomcharactercalculatedcustom fields
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(DeductionCat),rowid(DeductionCatLine),rowid(Journal)


Internal usage


QadFinancials
method BDInvoice.UpdateDeductionDetailPosting