project QadFinancials > class BReason > business logic query ReasonByIdCode

Description

This query allows you to get a Reason by Id or Code.

Parameters

iiReasonId	integer
icReasonCode	character

query condition

each Reason where

Reason.Reason_ID = iiReasonId AND
Reason.ReasonCode = icReasonCode

query resultset tqReasonByIdCode

field name	data type	db field	description
tiReason_ID	integer	Reason.Reason_ID	Record ID
tcReasonAllocationStatus	character	Reason.ReasonAllocationStatus	Allocation Status
tcReasonCode	character	Reason.ReasonCode	Invoice Status Code
tcReasonDescription	character	Reason.ReasonDescription	Description
tlReasonIsActive	logical	Reason.ReasonIsActive	Active
tlReasonIsInitialStatus	logical	Reason.ReasonIsInitialStatus	Initial Status
tlReasonIsInvoiceApproved	logical	Reason.ReasonIsInvoiceApproved	Invoice Approved
tlReasonIsLockPayment	logical	Reason.ReasonIsLockPayment	Lock Payment
tlReasonIsLogisticMatching	logical	Reason.ReasonIsLogisticMatching	Receiver Matching

Internal usage

QadFinancials

method BBankEntry.ValidateComponentPre
method BCInvoice.AllocateCInvoices
method BCInvoice.ApiStdMaintainTTWithExtPost
method BCInvoice.Calculate
method BCInvoice.CreateCInvoices
method BCInvoice.CreateCInvoicesReason
method BCInvoice.CreateCInvoicesValidate
method BCInvoice.ValidateComponentPre
method BCInvoiceAPMatching.CreateCInvoice
method BCreditor.InitialValues
method BCreditor.ValReasonCode
method BDebtor.ValReasonCode
method BOpenItemAdjustment.GetBusinessRelationForCredDeb
method BOpenItemAdjustment.OIAdjCommitValidateTwo
method BOpenItemAdjustment.OIAdjNewOpenItem
method BReason.ValidateComponent
method TConvertInstalNETXML.SetOutputData