project QadFinancials > class BDDocument > business logic query DDocuInvoiceXrefbyIdAllInfo


Parameters


iiCompanyIDinteger
iiDocumentIDinteger


query condition


  each DDocumentInvoiceXref where
DDocumentInvoiceXref.DDocument_ID = iiDocumentID


query resultset tqDDocuInvoiceXrefbyIdAllInfo


field namedata typedb fielddescription
tiDDocument_IDintegerDDocumentInvoiceXref.DDocument_IDLink to DDocument
tiDDocumentInvoiceXref_IDintegerDDocumentInvoiceXref.DDocumentInvoiceXref_IDRecord ID
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.
tiDInvoice_IDintegerDDocumentInvoiceXref.DInvoice_IDLink to DInvoice
ttLastModifiedDatedateDDocumentInvoiceXref.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerDDocumentInvoiceXref.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterDDocumentInvoiceXref.LastModifiedUserLast Modified User
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(DDocumentInvoiceXref)


Internal usage


QadFinancials
method BDCollection.FillProDataSetDocument
method BDCollectionReport.DCollectionReport