project QadFinancials > class BBankImportLine > business logic query BankImpLineLogByImpLine

Description

This query returns all fields of Bank Import Line Log for selected Bank Import Line.


Parameters


icBankImpLineIdListcharacterBank Import Line ID's list


query condition


  each BankImpLineLog where
BankImpLineLog.BankImpLine_ID can-do icBankImpLineIdList

      first BankImpLine (inner-join) where
BankImpLine.BankImpLine_ID = BankImpLineLog.BankImpLine_ID AND
BankImpLine.ProcessInCompany_ID >= 0


query resultset tqBankImpLineLogByImpLine


field namedata typedb fielddescription
tiBankImpLine_IDintegerBankImpLineLog.BankImpLine_IDLink to BankImpLine
tiBankImpLineLog_IDintegerBankImpLineLog.BankImpLineLog_IDRecord ID
tcBankImpLineLogFieldLabelcharacterBankImpLineLog.BankImpLineLogFieldLabelField Label
tcBankImpLineLogFieldNamecharacterBankImpLineLog.BankImpLineLogFieldNameField Name
tcBankImpLineLogFieldValuecharacterBankImpLineLog.BankImpLineLogFieldValueField Value
tcBankImpLineLogLogcharacterBankImpLineLog.BankImpLineLogLogLog
tcBankImpLineLogMessagecharacterBankImpLineLog.BankImpLineLogMessageMessage
tcBankImpLineLogRowidcharacterBankImpLineLog.BankImpLineLogRowidRow ID
tiBankImpLineLogSeverityintegerBankImpLineLog.BankImpLineLogSeveritySeverity
tcBankImpLineLogTypecharacterBankImpLineLog.BankImpLineLogTypeType
ttLastModifiedDatedateBankImpLineLog.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerBankImpLineLog.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterBankImpLineLog.LastModifiedUserLast Modified User
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(BankImpLineLog),rowid(BankImpLine)


Internal usage


QadFinancials
method BBankImportLine.GetBankImpLineByFilter