project QadFinancials > class BDDocument > business logic query DDocumentByDebtorReference


Parameters


iiCompanyIdintegerCompany id
iiDebtorIDinteger
icDebtorCodecharacter
icReferencecharacter
icPayFormatPayInstrumentcharacter
iiDDocumentIDinteger


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 namedata typedb fielddescription
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tiBankPayFormat_IDintegerBankPayFormat.BankPayFormat_IDRecord ID
tiDDocument_IDintegerDDocument.DDocument_IDRecord ID
tcDDocumentReferencecharacterDDocument.DDocumentReferenceReference. Reference text for the payment.
tiDebtor_IDintegerDDocument.Debtor_IDCustomer
tcPayFormatTypeCodecharacterPayFormatType.PayFormatTypeCodeFormat Name
tcPayFormatTypePayInstrumentcharacterPayFormatType.PayFormatTypePayInstrumentPayment Instrument


Internal usage


QadFinancials
method BDDocument.ValidateComponentPost