business logic query DInvoiceByIDForDeductionReview

Parameters

iiCompanyId	integer	Company id
iiDeductionInvID	integer

each DInvoice where

DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = iiDeductionInvID

first Company (inner-join) where

Company.Company_Id = iiCompanyId AND
Company.Company_ID = DInvoice.Company_ID AND

first Journal (inner-join) where

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

field name	data type	db field	description
tiCompany_ID	integer	DInvoice.Company_ID	Link to Company
tcCompanyCode	character	Company.CompanyCode	Entity Code
tiDInvoicePostingYear	integer	DInvoice.DInvoicePostingYear	Year.This field indicates the accounting year for the invoice. If you modify these fields, the posting and tax dates are changed correspondingly.
	api annotation:		This field defaults to the accounting year associated with the posting date.
tiDInvoiceVoucher	integer	DInvoice.DInvoiceVoucher	Voucher.This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is charged(after transfer), the voucher is cleared. Voucher must be unique in one GL period. When the user input is zero, the system automatically assign a value not used yet for this field.
tiJournal_ID	integer	DInvoice.Journal_ID	Daybook Code
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).

QadFinancials