project QadFinancials > class BDDocument > business logic query DDocumentInvoiceXrefByDInvDet

Description

This query retrieves all debtor documents which holds certain debtor invoice. In case of prepayment, it should be only one debtor document


Parameters


iiDInvoiceIdintegerId of the invoice
iiCompanyIdintegerCompany id


query condition


  each DDocumentInvoiceXref where
DDocumentInvoiceXref.DInvoice_ID = iiDInvoiceId

      first DDocument (inner-join) where
DDocument.Company_Id = iiCompanyId AND
DDocument.DDocument_ID = DDocumentInvoiceXref.DDocument_ID AND


query resultset tqDDocumentInvoiceXrefByDInvDet


field namedata typedb fielddescription
tiDDocument_IDintegerDDocument.DDocument_IDRecord ID
ttDDocumentDueDatedateDDocument.DDocumentDueDateDue Date. The date on which the payment is receivable.
tlDDocumentIsOpenlogicalDDocument.DDocumentIsOpenOpen. This field indicates if the payment is completely paid already.
tiDDocumentNumberintegerDDocument.DDocumentNumberDocument Number. This field hold a unified number for report use.
tcDDocumentReferencecharacterDDocument.DDocumentReferenceReference. Reference text for the payment.
tcDDocumentStatuscharacterDDocument.DDocumentStatusStatus. The payment status. The default value for a new record is Initial.
tcDDocumentSubTypecharacterDDocument.DDocumentSubTypeSubtype. This read-only field indicates that the payment is manual or automatic. You create manual customer payments through the Customer Payment activities, and automatic payments through the Customer Payment Selections.
tcDDocumentTypecharacterDDocument.DDocumentTypePayment Instrument. The system displays the payment instrument associated with the payment format linked to the customer bank.
tiDDocumentYearintegerDDocument.DDocumentYearYear/Number. This field displays the accounting year and payment sequence number, which is automatically generated by the accounting year.
tiDInvoice_IDintegerDDocumentInvoiceXref.DInvoice_IDLink to DInvoice


Internal usage


QadFinancials
method BDDocument.ApiGetDDocumentInvoiceXrefByDInvDet
dataset BDDocument.tDDocumentInvoiceXrefByDInvD