business logic query GetDInvoiceMovementByDocId

Parameters

iiCompanyId	integer	Company id
iiDDocumentId	integer

query condition

each DDocument where

DDocument.Company_Id = iiCompanyId AND
DDocument.DDocument_ID = iiDDocumentId

each DDocumentInvoiceXref (inner-join) where

DDocumentInvoiceXref.DDocument_ID = DDocument.DDocument_ID AND

first DInvoice (inner-join) where

DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = DDocumentInvoiceXref.DInvoice_ID AND

each DInvoiceMovement (inner-join) where

DInvoiceMovement.Company_Id = iiCompanyId AND
DInvoiceMovement.DInvoice_ID = DInvoice.DInvoice_ID AND
DInvoiceMovement.LastModifiedDate = DDocument1.LastModifiedDate AND
DInvoiceMovement.LastModifiedTime = DDocument1.LastModifiedTime

first PostingLine (inner-join) where

PostingLine.Company_Id = iiCompanyId AND
PostingLine.PostingLine_ID = DInvoiceMovement.PostingLine_ID AND

first Posting (inner-join) where

Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = PostingLine.Posting_ID AND

first Journal (inner-join) where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND

query resultset tqGetDInvoiceMovementByDocID

field name	data type	db field	description
tiDDocument_ID	integer	DDocument.DDocument_ID	Record ID
tiDDocumentInvoiceXref_ID	integer	DDocumentInvoiceXref.DDocumentInvoiceXref_ID	Record ID
tiDInvoice_ID	integer	DInvoice.DInvoice_ID	Record ID
tiDInvoiceMovement_ID	integer	DInvoiceMovement.DInvoiceMovement_ID	Record ID
tcDInvoiceMovementType	character	DInvoiceMovement.DInvoiceMovementType	CInvoiceMovementType. "Initial" indicates that the movement represents the initial creation of the invoice, "movement" stands for all subsequent modifications of the invoice balance (payments, adjustments etc).
tcDInvoiceType	character	DInvoice.DInvoiceType	Invoice Type. This field displays the invoice type. Invoice Correction and Credit Note Correction display as choices only when the appropriate daybook types have already been defined.
	api annotation:		PartialUpdate = yes - defaults to Invoice
tiJournal_ID	integer	Journal.Journal_ID	Record ID
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tiPosting_ID	integer	Posting.Posting_ID	Record ID
tiPostingLine_ID	integer	PostingLine.PostingLine_ID	Record ID
tcPostingText	character	Posting.PostingText	Free text describing the posting.
	api annotation:		Value for this field defaults to blank
tiPostingVoucher	integer	Posting.PostingVoucher	Voucher is a sequential number that uniquely identifies the journal entry (within the combination of an entity and a daybook code).
	api annotation:		In create mode,enter 0 in this field - the voucher number is generated by the system. In Modify/Delete, the correct voucher number must be entered because this identifies the record.
tiPostingYear	integer	Posting.PostingYear	The GL calendar year for the posting.

Internal usage

QadFinancials

method BBillReport.GetBillReportPayment