project QadFinancials > class BReason > business logic query ReasonPrim

Description

ReasonPrim; Query that can be used to convert the ID into the Code and vice-versa (Code is also a related-key-business-field in this query).

Parameters

iiReasonId	integer	Reason ID
icReasonCode	character	Reason Code

query condition

each Reason where

Reason.Reason_ID = iiReasonId AND
Reason.ReasonCode = icReasonCode

query resultset tqReasonPrim

field name	data type	db field	description
tcReasonAllocationStatus	character	Reason.ReasonAllocationStatus	Allocation Status
tlReasonIsActive	logical	Reason.ReasonIsActive	Active
tiReason_ID	integer	Reason.Reason_ID	Record ID
tcReasonCode	character	Reason.ReasonCode	Invoice Status Code

Internal usage

QadFinancials

method BCreditor.ApiLoadCreditor
method BCreditor.ApiLoadCreditorCalcReasonCode
method BCreditor.ApiLoadCreditorV01
method BCreditorOpenBalance.ApiCreateCreditorOpenBalanceV01
method BDebtor.ApiLoadDebtor
method BDebtor.ApiLoadDebtorCalcReasonCode
method BDInvoice.CreateDInvoicesValidate
read related business field(s) on tAPMatching.Reason_ID
read related business field(s) on tCInvoice.Reason_ID
read related business field(s) on tCreditor.Reason_ID
read related business field(s) on tDebtor.Reason_ID
read related business field(s) on tDInvoice.Reason_ID
read related business field(s) on tReason.MatchingReason_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tAPMatching.Reason_ID
validate related business field(s) on tCInvoice.Reason_ID
validate related business field(s) on tCreditor.Reason_ID
validate related business field(s) on tDebtor.Reason_ID
validate related business field(s) on tDInvoice.Reason_ID
validate related business field(s) on tReason.MatchingReason_ID