project QadFinancials > class BReason > business logic query ReasonForMatching
Description
Query that returns the linked-MatchingReasonCode for a certain reason-code
Parameters
| iiReasonID | integer | |
| icReasonCode | character | |
| ilReasonIsLogisticMatching | logical | |
| ilReasonIsActive | logical | |
| ilReasonIsInitialStatus | logical | |
query condition
each Reason where
Reason.Reason_ID = iiReasonID AND
Reason.ReasonCode = icReasonCode AND
Reason.ReasonIsLogisticMatching = ilReasonIsLogisticMatching AND
Reason.ReasonIsActive = ilReasonIsActive AND
Reason.ReasonIsInitialStatus = ilReasonIsInitialStatus
first Reason2 (outer-join) where
Reason2.Reason_ID = Reason.MatchingReason_ID AND
query resultset tqReasonForMatching
| field name | data type | db field | description |
|---|
| tlReasonIsActive | logical | Reason.ReasonIsActive | Active |
| tlReasonIsInitialStatus | logical | Reason.ReasonIsInitialStatus | Initial Status |
| tiReason_ID | integer | Reason.Reason_ID | Record ID |
| tcReasonCode | character | Reason.ReasonCode | Invoice Status Code |
| tlReasonIsLogisticMatching | logical | Reason.ReasonIsLogisticMatching | Receiver Matching |
| tiMatchingReason_ID | integer | Reason.MatchingReason_ID | Status After Match |
| tcMatchingReasonCode | character | Reason2.ReasonCode | Invoice Status Code |
Internal usage
QadFinancials