project QadFinancials > class BDDocument > business logic query DDocumentByDebtorReference
Parameters
| iiCompanyId | integer | Company id |
| iiDebtorID | integer | |
| icDebtorCode | character | |
| icReference | character | |
| icPayFormatPayInstrument | character | |
| iiDDocumentID | integer | |
query condition
each DDocument where
DDocument.Company_Id = iiCompanyId AND
DDocument.Debtor_ID = iiDebtorID AND
DDocument.DDocumentReference = icReference AND
DDocument.DDocument_ID <> iiDDocumentID
first Debtor (inner-join) where
Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID = DDocument.Debtor_ID AND
Debtor.DebtorCode = icDebtorCode
first BankNumber (inner-join) where
BankNumber.BankNumber_ID = DDocument.BankNumber_ID AND
first BankPayFormat (inner-join) where
BankPayFormat.BankPayFormat_ID = BankNumber.BankPayFormat_ID AND
first PayFormatType (inner-join) where
PayFormatType.PayFormatTypeCode = BankPayFormat.PayFormatTypeCode AND
PayFormatType.PayFormatTypePayInstrument = icPayFormatPayInstrument
query resultset tqDDocumentByDebtorReference
| field name | data type | db field | description |
|---|
| tiBankNumber_ID | integer | BankNumber.BankNumber_ID | Record ID |
| tiBankPayFormat_ID | integer | BankPayFormat.BankPayFormat_ID | Record ID |
| tiDDocument_ID | integer | DDocument.DDocument_ID | Record ID |
| tcDDocumentReference | character | DDocument.DDocumentReference | Reference. Reference text for the payment. |
| tiDebtor_ID | integer | DDocument.Debtor_ID | Customer |
| tcPayFormatTypeCode | character | PayFormatType.PayFormatTypeCode | Format Name |
| tcPayFormatTypePayInstrument | character | PayFormatType.PayFormatTypePayInstrument | Payment Instrument |
Internal usage
QadFinancials