project QadFinancials > class BReason > business logic query ReasonByIdCode

Description

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


Parameters


iiReasonIdinteger
icReasonCodecharacter


query condition


  each Reason where
Reason.Reason_ID = iiReasonId AND
Reason.ReasonCode = icReasonCode


query resultset tqReasonByIdCode


field namedata typedb fielddescription
tiReason_IDintegerReason.Reason_IDRecord ID
tcReasonAllocationStatuscharacterReason.ReasonAllocationStatusAllocation Status
tcReasonCodecharacterReason.ReasonCodeInvoice Status Code
tcReasonDescriptioncharacterReason.ReasonDescriptionDescription
tlReasonIsActivelogicalReason.ReasonIsActiveActive
tlReasonIsInitialStatuslogicalReason.ReasonIsInitialStatusInitial Status
tlReasonIsInvoiceApprovedlogicalReason.ReasonIsInvoiceApprovedInvoice Approved
tlReasonIsLockPaymentlogicalReason.ReasonIsLockPaymentLock Payment
tlReasonIsLogisticMatchinglogicalReason.ReasonIsLogisticMatchingReceiver 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