business logic query ApproveStatusTransByAll

Parameters

iiCompanyId	integer	Company id
icApproveStatusTransFrStatus	character
icApproveStatusTransToStatus	character

query condition

each ApproveStatusTrans where

ApproveStatusTrans.Company_Id = iiCompanyId AND
ApproveStatusTrans.ApproveStatusTransFrStatus = icApproveStatusTransFrStatus AND
ApproveStatusTrans.ApproveStatusTransToStatus = icApproveStatusTransToStatus

query resultset tqApproveStatusTransByAll

field name	data type	db field	description
tiApproveStatusTrans_ID	integer	ApproveStatusTrans.ApproveStatusTrans_ID	Record ID
tcApproveStatusTransFrStatus	character	ApproveStatusTrans.ApproveStatusTransFrStatus	From Status
tcApproveStatusTransToStatus	character	ApproveStatusTrans.ApproveStatusTransToStatus	To Status
tiCompany_ID	integer	ApproveStatusTrans.Company_ID	Link to Company
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(ApproveStatusTrans)

Internal usage

QadFinancials

method BApproveStatusTransition.LoadApproveStatusTransition
method BJournalEntry.ApiSetPostingStatusChange