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