project QadFinancials > class BReason > business logic query ReasonByAllocLockPayment
Parameters
| icReasonAllocationStatus | character | Can contain one of the preprocessors on the allocation status. |
| ilReasonLockPayment | logical | |
| ilReasonIsActive | logical | |
query condition
each Reason where
Reason.ReasonIsActive = ilReasonIsActive AND
Reason.ReasonIsLockPayment = ilReasonLockPayment AND
Reason.ReasonAllocationStatus = icReasonAllocationStatus
query resultset tqReasonByAllocLockPayment
| 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 |
| tlReasonIsLockPayment | logical | Reason.ReasonIsLockPayment | Lock Payment |
Internal usage
QadFinancials