business logic query VerifyStatusTransByAll

Parameters

iiCompanyId	integer	Company id
icVerifyStatusTransFrStatus	character
icVerifyStatusTransToStatus	character

query condition

each VerifyStatusTrans where

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

query resultset tqVerifyStatusTransByAll

field name	data type	db field	description
tiCompany_ID	integer	VerifyStatusTrans.Company_ID	Link to Company
tcVerifyStatusTransFrStatus	character	VerifyStatusTrans.VerifyStatusTransFrStatus	From Status
tcVerifyStatusTransToStatus	character	VerifyStatusTrans.VerifyStatusTransToStatus	To Status
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(VerifyStatusTrans)

Internal usage

QadFinancials

method BJournalEntry.ApiSetPostingStatusChange
method BVerifyStatusTransition.LoadVerifyStatusTransition