business logic query DDocumentInvoiceXrefByStatus

Parameters

iiCompanyId	integer	Company id
iiDIvnoiceId	integer
icDocumentStatus	character
icDocumentType	character

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 name	data type	db field	description
tdDDocumentInvoiceXrefAlloTC	decimal	DDocumentInvoiceXref.DDocumentInvoiceXrefAlloTC	TC Allocated Amount. This field indicates the invocie amount already Allocated in transaction currency.
tdDDocumentInvoiceXrefDiscTC	decimal	DDocumentInvoiceXref.DDocumentInvoiceXrefDiscTC	TC Discount Amount. This field indicates the discount amount of the invoice already allocated by transaction currency.
tcDDocumentStatus	character	DDocument.DDocumentStatus	Status. The payment status. The default value for a new record is Initial.
tcDDocumentType	character	DDocument.DDocumentType	Payment Instrument. The system displays the payment instrument associated with the payment format linked to the customer bank.
tiDInvoice_ID	integer	DDocumentInvoiceXref.DInvoice_ID	Link to DInvoice

Internal usage

QadFinancials

method BDDocument.AdditionalUpdatesPostingXrefDISuspTax