project QadFinancials > class BDDocument > business logic query DDocumentInvoiceXrefByStatus


Parameters


iiCompanyIdintegerCompany id
iiDIvnoiceIdinteger
icDocumentStatuscharacter
icDocumentTypecharacter


query condition


  each DDocumentInvoiceXref where
DDocumentInvoiceXref.DInvoice_ID = iiDIvnoiceId

      first DDocument (inner-join) where
DDocument.Company_Id = iiCompanyId AND
DDocument.DDocument_ID = DDocumentInvoiceXref.DDocument_ID AND
DDocument.DDocumentStatus can-do icDocumentStatus AND
DDocument.DDocumentType = icDocumentType


query resultset tqDDocumentInvoiceXrefByStatus


field namedata typedb fielddescription
tdDDocumentInvoiceXrefAlloTCdecimalDDocumentInvoiceXref.DDocumentInvoiceXrefAlloTCTC Allocated Amount. This field indicates the invocie amount already Allocated in transaction currency.
tdDDocumentInvoiceXrefDiscTCdecimalDDocumentInvoiceXref.DDocumentInvoiceXrefDiscTCTC Discount Amount. This field indicates the discount amount of the invoice already allocated by transaction currency.
tcDDocumentStatuscharacterDDocument.DDocumentStatusStatus. The payment status. The default value for a new record is Initial.
tcDDocumentTypecharacterDDocument.DDocumentTypePayment Instrument. The system displays the payment instrument associated with the payment format linked to the customer bank.
tiDInvoice_IDintegerDDocumentInvoiceXref.DInvoice_IDLink to DInvoice


Internal usage


QadFinancials
method BDDocument.AdditionalUpdatesPostingXrefDISuspTax