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