project QadFinancials > class BVerifyStatusTransition > business logic query VerifyStatusTransByAll


Parameters


iiCompanyIdintegerCompany id
icVerifyStatusTransFrStatuscharacter
icVerifyStatusTransToStatuscharacter


query condition


  each VerifyStatusTrans where
VerifyStatusTrans.Company_Id = iiCompanyId AND
VerifyStatusTrans.VerifyStatusTransFrStatus = icVerifyStatusTransFrStatus AND
VerifyStatusTrans.VerifyStatusTransToStatus = icVerifyStatusTransToStatus


query resultset tqVerifyStatusTransByAll


field namedata typedb fielddescription
tiCompany_IDintegerVerifyStatusTrans.Company_IDLink to Company
tcVerifyStatusTransFrStatuscharacterVerifyStatusTrans.VerifyStatusTransFrStatusFrom Status
tcVerifyStatusTransToStatuscharacterVerifyStatusTrans.VerifyStatusTransToStatusTo Status
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(VerifyStatusTrans)


Internal usage


QadFinancials
method BJournalEntry.ApiSetPostingStatusChange
method BVerifyStatusTransition.LoadVerifyStatusTransition